| # |
type |
message |
| 1 |  sfPatternRouting | Connect sfRequestRoute "sf_captchagd" (/captcha) |
| 2 | sfPatternRouting | Match route "homepage" (/:lang) for / with parameters array ( 'module' => 'pageHome', 'action' => 'index', 'lang' => '',) |
| 3 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 4 | sfFilterChain | Executing filter "ChangeLanguageFilter" |
| 5 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 6 | pageHomeActions | Call "pageHomeActions->executeIndex()" |
| 7 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 8 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.config_key AS a__config_key, a.config_val AS a__config_val, a.is_active AS a__is_active, a.lang AS a__lang, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM ad_config a WHERE (a.is_active = 1) - () |
| 9 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.is_active = 1 AND v.is_home = 1 AND (v.parent_id = ? OR v.parent_id is null)) ORDER BY v.priority asc LIMIT 4 - () |
| 10 | Doctrine_Connection_Mysql | query : SELECT v.id AS v__id, v.name AS v__name, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.slug AS v__slug FROM vtp_products_category v WHERE (v.is_active = 1 AND v.is_home = 1) ORDER BY v.priority DESC - () |
| 11 | Doctrine_Connection_Mysql | query : SELECT v.id AS v__id, v.name AS v__name, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.slug AS v__slug FROM vtp_products_category v WHERE (v.is_active = 1 AND v.is_home = 1) ORDER BY v.priority DESC - () |
| 12 | sfPHPView | Render "sf_app_dir/modules/pageHome/templates/indexSuccess.php" |
| 13 | main | Call "pageHome->executeDepartment()" |
| 14 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE ((h.parent_id = ? OR h.parent_id is null) AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - () |
| 15 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (14) |
| 16 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (19) |
| 17 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (20) |
| 18 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (10) |
| 19 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (5) |
| 20 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (4) |
| 21 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (11) |
| 22 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (12) |
| 23 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (13) |
| 24 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (15) |
| 25 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (18) |
| 26 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.name AS h__name, h.image AS h__image, h.description AS h__description, h.parent_id AS h__parent_id, h.priority AS h__priority, h.is_active AS h__is_active, h.lang AS h__lang, h.slug AS h__slug FROM hq_brand h WHERE (h.parent_id = ? AND h.is_active = 1) ORDER BY h.priority desc LIMIT 15 - (21) |
| 27 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_department.php" |
| 28 | main | Call "pageHome->executeSlideShow()" |
| 29 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.view_type AS a__view_type, a.height AS a__height, a.width AS a__width, a.name AS a__name, a2.id AS a2__id, a2.file_path AS a2__file_path, a2.link AS a2__link FROM ad_advertise a INNER JOIN ad_advertise_image a2 ON a.id = a2.advertise_id INNER JOIN ad_advertise_location a3 ON a.id = a3.advertise_id WHERE (a.is_active = ? AND a3.page = ? AND a2.is_active = 1) - (1, homepage) |
| 30 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_slideShow.php" |
| 31 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_shipping.php" |
| 32 | main | Call "pageHome->executeProductCategoryHot()" |
| 33 | Doctrine_Connection_Mysql | query : SELECT v.id AS v__id, v.name AS v__name, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.slug AS v__slug FROM vtp_products_category v WHERE (v.is_active = 1 AND v.is_home = 1) ORDER BY v.priority DESC - () |
| 34 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 16) |
| 35 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 28) |
| 36 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 36) |
| 37 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 31) |
| 38 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 39) |
| 39 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 60) |
| 40 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 37) |
| 41 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 85) |
| 42 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 100) |
| 43 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 94) |
| 44 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 83) |
| 45 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 92) |
| 46 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 41) |
| 47 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 53) |
| 48 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 46) |
| 49 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 79) |
| 50 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 57) |
| 51 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 42) |
| 52 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 50) |
| 53 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 32) |
| 54 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 33) |
| 55 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 45) |
| 56 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 70) |
| 57 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 71) |
| 58 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 72) |
| 59 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 73) |
| 60 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 74) |
| 61 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 75) |
| 62 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 77) |
| 63 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 84) |
| 64 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 86) |
| 65 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 87) |
| 66 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 88) |
| 67 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 89) |
| 68 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 90) |
| 69 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 93) |
| 70 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 97) |
| 71 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 98) |
| 72 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 99) |
| 73 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 102) |
| 74 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 104) |
| 75 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.description AS v__description, v.image_path AS v__image_path, v.link AS v__link, v.slug AS v__slug, v.price AS v__price, v.price_promotion AS v__price_promotion FROM vtp_products v WHERE (v.is_active = ? AND v.is_home = ? AND v.category_id = ?) ORDER BY v.priority DESC LIMIT 20 - (1, 1, 108) |
| 76 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_productCategoryHot.php" |
| 77 | main | Call "pageHome->executeService()" |
| 78 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.name AS a__name, a.description AS a__description, a.content AS a__content, a.image_path AS a__image_path, a.is_active AS a__is_active, a.is_hot AS a__is_hot, a.lang AS a__lang, a.category_id AS a__category_id, a.slug AS a__slug, a.meta_keyword AS a__meta_keyword, a.meta_description AS a__meta_description, a.price AS a__price, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM ad_product a WHERE (a.is_active = ?) ORDER BY a.category_id DESC LIMIT 2 - (1) |
| 79 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_service.php" |
| 80 | main | Call "pageHome->executeBrand()" |
| 81 | sfPartialView | Render "sf_app_dir/modules/pageHome/templates/_brand.php" |
| 82 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 83 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 84 | main | Call "moduleMenu->executeMainMenu()" |
| 85 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE ((v.parent_id = ? OR v.parent_id is null) AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - () |
| 86 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (59) |
| 87 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (70) |
| 88 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (71) |
| 89 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (72) |
| 90 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (73) |
| 91 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (74) |
| 92 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (75) |
| 93 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (97) |
| 94 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.name AS v__name, v.address AS v__address, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.is_active AS v__is_active, v.is_home AS v__is_home, v.lang AS v__lang, v.description AS v__description, v.slug AS v__slug, v.portal_id AS v__portal_id, v.meta AS v__meta, v.keywords AS v__keywords, v.parent_id AS v__parent_id, v.level AS v__level, v.lat AS v__lat, v.log AS v__log, v.parameter_ids AS v__parameter_ids, v.list_image AS v__list_image, v.email AS v__email, v.msisdn AS v__msisdn, v.created_by AS v__created_by, v.updated_by AS v__updated_by, v.created_at AS v__created_at, v.updated_at AS v__updated_at FROM vtp_products_category v WHERE (v.parent_id = ? AND v.is_active = 1) ORDER BY v.priority desc LIMIT 50 - (108) |
| 95 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.name AS a__name, a.description AS a__description, a.content AS a__content, a.image_path AS a__image_path, a.is_active AS a__is_active, a.is_hot AS a__is_hot, a.lang AS a__lang, a.category_id AS a__category_id, a.slug AS a__slug, a.meta_keyword AS a__meta_keyword, a.meta_description AS a__meta_description, a.price AS a__price, a.created_by AS a__created_by, a.updated_by AS a__updated_by, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM ad_product a ORDER BY a.category_id DESC LIMIT 10 - () |
| 96 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_mainMenu.php" |
| 97 | main | Call "moduleMenu->executeContentFooter()" |
| 98 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_contentFooter.php" |
| 99 | main | Call "pageProduct->executeInquiryNowForm()" |
| 100 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_inquiryNowForm.php" |
| 101 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
| 102 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
config
view
logs
30464.0 KB
636 ms
74
