# |
type |
message |
1 | sfPatternRouting | Match route "product" (/productos/:slug) for /productos/vida-proteccion-max with parameters array ( 'module' => 'products', 'action' => 'showProduct', 'slug' => 'vida-proteccion-max',) |
2 | sfFilterChain | Executing filter "sfRenderingFilter" |
3 | sfFilterChain | Executing filter "sfExecutionFilter" |
4 | productsActions | Call "productsActions->executeShowProduct()" |
5 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
6 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_content AS p__box_content, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.title_subtitle AS p__title_subtitle, p.subtitle AS p__subtitle, p.title_content AS p__title_content, p.content AS p__content, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.category_id AS p__category_id, p.sub_category_id AS p__sub_category_id, p.button_text AS p__button_text, p.button_link AS p__button_link, p.show_details AS p__show_details, p.show_plans AS p__show_plans, p.reference AS p__reference, p.is_active AS p__is_active, p.is_featured AS p__is_featured, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product p WHERE (p.slug = ?) LIMIT 1 - (vida-proteccion-max) |
7 | sfAdminView | Render "sf_app_dir/modules/products/templates/showProductSuccess.php" |
8 | main | Call "default->executeHeader()" |
9 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.subtitle AS p__subtitle, p.content AS p__content, p.category_id AS p__category_id, p.button_text AS p__button_text, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.show_comparation AS p__show_comparation, p.is_featured AS p__is_featured, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_sub_category p WHERE (p.is_active = ? AND p.is_featured = ?) ORDER BY p.order_num ASC - (1, 1) |
10 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.subtitle AS p__subtitle, p.content AS p__content, p.button_text AS p__button_text, p.order_num AS p__order_num, p.is_company AS p__is_company, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_category p WHERE (p.slug = ?) LIMIT 1 - (vida-proteccion-max) |
11 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.subtitle AS p__subtitle, p.content AS p__content, p.category_id AS p__category_id, p.button_text AS p__button_text, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.show_comparation AS p__show_comparation, p.is_featured AS p__is_featured, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_sub_category p WHERE (p.slug = ?) LIMIT 1 - (vida-proteccion-max) |
12 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_content AS p__box_content, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.title_subtitle AS p__title_subtitle, p.subtitle AS p__subtitle, p.title_content AS p__title_content, p.content AS p__content, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.category_id AS p__category_id, p.sub_category_id AS p__sub_category_id, p.button_text AS p__button_text, p.button_link AS p__button_link, p.show_details AS p__show_details, p.show_plans AS p__show_plans, p.reference AS p__reference, p.is_active AS p__is_active, p.is_featured AS p__is_featured, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product p WHERE (p.slug = ?) LIMIT 1 - (vida-proteccion-max) |
13 | sfPartialView | Render "sf_app_dir/modules/default/templates/_header.php" |
14 | main | Call "default->executeTop_info()" |
15 | Doctrine_Connection_Mysql | query : SELECT c.id AS c__id, c.telephone AS c__telephone, c.telephone_2 AS c__telephone_2, c.cellphone AS c__cellphone, c.cellphone_2 AS c__cellphone_2, c.email AS c__email, c.contact_time AS c__contact_time, c.country_id AS c__country_id, c.province_id AS c__province_id, c.city_id AS c__city_id, c.address AS c__address, c.google_maps_url AS c__google_maps_url, c.zip AS c__zip, c.facebook AS c__facebook, c.twitter AS c__twitter, c.linkedin AS c__linkedin, c.whatsapp AS c__whatsapp FROM config c - () |
16 | sfPartialView | Render "sf_app_dir/modules/default/templates/_top_info.php" |
17 | main | Call "default->executeMenu()" |
18 | Doctrine_Connection_Mysql | query : SELECT p.id AS p__id, p.name AS p__name, p.subtitle AS p__subtitle, p.content AS p__content, p.button_text AS p__button_text, p.order_num AS p__order_num, p.is_company AS p__is_company, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug, p2.id AS p2__id, p2.name AS p2__name, p2.box_action_type AS p2__box_action_type, p2.box_action AS p2__box_action, p2.subtitle AS p2__subtitle, p2.content AS p2__content, p2.category_id AS p2__category_id, p2.button_text AS p2__button_text, p2.as_icons AS p2__as_icons, p2.icon AS p2__icon, p2.order_num AS p2__order_num, p2.show_comparation AS p2__show_comparation, p2.is_featured AS p2__is_featured, p2.is_active AS p2__is_active, p2.created_at AS p2__created_at, p2.updated_at AS p2__updated_at, p2.slug AS p2__slug FROM product_category p INNER JOIN product_sub_category p2 ON p.id = p2.category_id - () |
19 | sfPartialView | Render "sf_app_dir/modules/default/templates/_menu.php" |
20 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.subtitle AS p__subtitle, p.content AS p__content, p.category_id AS p__category_id, p.button_text AS p__button_text, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.show_comparation AS p__show_comparation, p.is_featured AS p__is_featured, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_sub_category p WHERE (p.category_id = ? AND p.is_active = ?) ORDER BY p.order_num ASC - (3, 1) |
21 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.subtitle AS p__subtitle, p.content AS p__content, p.category_id AS p__category_id, p.button_text AS p__button_text, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.show_comparation AS p__show_comparation, p.is_featured AS p__is_featured, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_sub_category p WHERE (p.category_id = ? AND p.is_active = ?) ORDER BY p.order_num ASC - (4, 1) |
22 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.subtitle AS p__subtitle, p.content AS p__content, p.button_text AS p__button_text, p.order_num AS p__order_num, p.is_company AS p__is_company, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_category p WHERE (p.id = ?) - (3) |
23 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.box_action_type AS p__box_action_type, p.box_action AS p__box_action, p.subtitle AS p__subtitle, p.content AS p__content, p.category_id AS p__category_id, p.button_text AS p__button_text, p.as_icons AS p__as_icons, p.icon AS p__icon, p.order_num AS p__order_num, p.show_comparation AS p__show_comparation, p.is_featured AS p__is_featured, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM product_sub_category p WHERE (p.id = ?) - (7) |
24 | main | Call "contact->executeForm_product()" |
25 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.description AS c__description, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug FROM contact_type c WHERE (c.slug = ?) LIMIT 1 - (product) |
26 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.description AS c__description, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug FROM contact_type c WHERE (c.id = ?) - (2) |
27 | sfPartialView | Render "sf_app_dir/modules/contact/templates/_form_product.php" |
28 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.name AS a__name, a.created_at AS a__created_at, a.updated_at AS a__updated_at FROM additional a - () |
29 | Doctrine_Connection_Mysql | query : SELECT i.id AS i__id, i.name AS i__name, i.created_at AS i__created_at, i.updated_at AS i__updated_at FROM identification_type i - () |
30 | main | Call "default->executeSlider_banner()" |
31 | sfPartialView | Render "sf_app_dir/modules/default/templates/_slider_banner.php" |
32 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.file AS p__file, p.extension AS p__extension, p.type AS p__type, p.product_id AS p__product_id, p.created_at AS p__created_at, p.updated_at AS p__updated_at FROM product_image p WHERE (p.product_id IN (?)) - (11) |
33 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.file AS p__file, p.extension AS p__extension, p.type AS p__type, p.product_id AS p__product_id, p.created_at AS p__created_at, p.updated_at AS p__updated_at FROM product_image p WHERE (p.id = ?) ORDER BY p.created_at DESC - (113) |
34 | Doctrine_Connection_Statement | execute : SELECT b.product_id AS b__product_id, b.title AS b__title, b.title_en AS b__title_en, b.subtitle AS b__subtitle, b.subtitle_en AS b__subtitle_en, b.button_text AS b__button_text, b.button_link AS b__button_link, b.text_orientation AS b__text_orientation, b.is_active AS b__is_active, b.created_at AS b__created_at, b.updated_at AS b__updated_at FROM banner_product b WHERE (b.product_id = ?) - (11) |
35 | main | Call "products->executeBoxes_coverage()" |
36 | sfPartialView | Render "sf_app_dir/modules/products/templates/_boxes_coverage.php" |
37 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.subtitle AS c__subtitle, c.content AS c__content, c.icon AS c__icon, c.button_text AS c__button_text, c.order_num AS c__order_num, c.group_id AS c__group_id, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug, p.product_id AS p__product_id, p.type_id AS p__type_id, p.created_at AS p__created_at, p.updated_at AS p__updated_at FROM coverage_type c LEFT JOIN product_coverage_types p ON c.id = p.type_id WHERE (p.product_id IN (?)) - (11) |
38 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.subtitle AS c__subtitle, c.content AS c__content, c.icon AS c__icon, c.order_num AS c__order_num, c.button_text AS c__button_text, c.is_active AS c__is_active, c.is_featured AS c__is_featured, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug, c2.coverage_id AS c2__coverage_id, c2.type_id AS c2__type_id, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at FROM coverage c LEFT JOIN coverages_types c2 ON c.id = c2.coverage_id WHERE (c2.type_id IN (?)) - (15) |
39 | main | Call "products->executeBoxes_content()" |
40 | sfPartialView | Render "sf_app_dir/modules/products/templates/_boxes_content.php" |
41 | sfAdminView | Decorate content with "sf_app_dir/templates/layout.php" |
42 | sfAdminView | Render "sf_app_dir/templates/layout.php" |
43 | main | Call "default->executeFooter()" |
44 | Doctrine_Connection_Mysql | query : SELECT c.id AS c__id, c.telephone AS c__telephone, c.telephone_2 AS c__telephone_2, c.cellphone AS c__cellphone, c.cellphone_2 AS c__cellphone_2, c.email AS c__email, c.contact_time AS c__contact_time, c.country_id AS c__country_id, c.province_id AS c__province_id, c.city_id AS c__city_id, c.address AS c__address, c.google_maps_url AS c__google_maps_url, c.zip AS c__zip, c.facebook AS c__facebook, c.twitter AS c__twitter, c.linkedin AS c__linkedin, c.whatsapp AS c__whatsapp FROM config c - () |
45 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
46 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.province_id AS c__province_id, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.slug AS c__slug FROM city c WHERE (c.id = ?) - (380) |
47 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.country_id AS p__country_id, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.slug AS p__slug FROM province p WHERE (p.id = ?) - (119) |
48 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
49 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |