# |
type |
message |
1 | sfPatternRouting | Connect sfRequestRoute "sf_captchagd" (/captcha) |
2 | sfPatternRouting | Match route "hq_product_detail" (/product-detail/:slug) for /product-detail/seagrass-vase-ksv18 with parameters array ( 'module' => 'pageProduct', 'action' => 'detail', 'slug' => 'seagrass-vase-ksv18',) |
3 | sfFilterChain | Executing filter "sfRenderingFilter" |
4 | sfFilterChain | Executing filter "ChangeLanguageFilter" |
5 | sfFilterChain | Executing filter "sfExecutionFilter" |
6 | pageProductActions | Call "pageProductActions->executeDetail()" |
7 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
8 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.product_code AS v__product_code, v.category_id AS v__category_id, v.price AS v__price, v.price_promotion AS v__price_promotion, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.content AS v__content, v.comment AS v__comment, v.warranty_information AS v__warranty_information, v.manufacturer AS v__manufacturer, v.accessories AS v__accessories, v.is_active AS v__is_active, v.is_home AS v__is_home, v.is_hot AS v__is_hot, v.slug AS v__slug, v.portal_id AS v__portal_id, v.lang AS v__lang, v.meta AS v__meta, v.keywords AS v__keywords, v.brand AS v__brand, v.reference_price AS v__reference_price, v.unit AS v__unit, v.origin AS v__origin, v.payment AS v__payment, v.delivery AS v__delivery, v.port AS v__port, v.supply_ability AS v__supply_ability, v.packing AS v__packing, v.special_req AS v__special_req, 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 v WHERE (v.slug = ? AND v.is_active = ?) - (seagrass-vase-ksv18, 1) |
9 | 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) - () |
10 | sfPHPView | Render "sf_app_dir/modules/pageProduct/templates/detailSuccess.php" |
11 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.file_path AS v__file_path FROM vtp_products_image v WHERE (v.product_id = ?) ORDER BY v.priority ASC - (862) |
12 | main | Call "moduleMenu->executeBreadscrumbs()" |
13 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_breadscrumbs.php" |
14 | main | Call "pageProduct->executeProductRelated()" |
15 | Doctrine_Connection_Statement | execute : SELECT v.id AS v__id, v.product_name AS v__product_name, v.product_code AS v__product_code, v.category_id AS v__category_id, v.price AS v__price, v.price_promotion AS v__price_promotion, v.image_path AS v__image_path, v.link AS v__link, v.priority AS v__priority, v.description AS v__description, v.content AS v__content, v.comment AS v__comment, v.warranty_information AS v__warranty_information, v.manufacturer AS v__manufacturer, v.accessories AS v__accessories, v.is_active AS v__is_active, v.is_home AS v__is_home, v.is_hot AS v__is_hot, v.slug AS v__slug, v.portal_id AS v__portal_id, v.lang AS v__lang, v.meta AS v__meta, v.keywords AS v__keywords, v.brand AS v__brand, v.reference_price AS v__reference_price, v.unit AS v__unit, v.origin AS v__origin, v.payment AS v__payment, v.delivery AS v__delivery, v.port AS v__port, v.supply_ability AS v__supply_ability, v.packing AS v__packing, v.special_req AS v__special_req, 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 v WHERE (v.category_id = ? AND v.is_active = ?) ORDER BY v.updated_at DESC LIMIT 10 - (53, 1) |
16 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_productRelated.php" |
17 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_inquiryNow.php" |
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.id = ?) - (10) |
19 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_inquiryNowForm.php" |
20 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
21 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
22 | main | Call "moduleMenu->executeMainMenu()" |
23 | 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 - () |
24 | 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) |
25 | 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) |
26 | 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) |
27 | 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) |
28 | 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) |
29 | 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) |
30 | 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) |
31 | 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) |
32 | 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) |
33 | 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 - () |
34 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_mainMenu.php" |
35 | main | Call "moduleMenu->executeContentFooter()" |
36 | sfPartialView | Render "sf_app_dir/modules/moduleMenu/templates/_contentFooter.php" |
37 | main | Call "pageProduct->executeInquiryNowForm()" |
38 | sfPartialView | Render "sf_app_dir/modules/pageProduct/templates/_inquiryNowForm.php" |
39 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
40 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |