# |
type |
message |
1 | sfPatternRouting | Match route "product" (/productos/:slug) for /productos/tercero-simple with parameters array ( 'module' => 'products', 'action' => 'showProduct', 'slug' => 'tercero-simple',) |
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 - (tercero-simple) |
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 - (tercero-simple) |
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 - (tercero-simple) |
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 - (tercero-simple) |
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 = ?) - (3) |
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 (?)) - (5) |
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 - (101) |
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 = ?) - (5) |
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 (?)) - (5) |
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 (?)) - (10) |
39 | main | Call "products->executeTable_details()" |
40 | 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.id AS c2__id, c2.name AS c2__name, c2.subtitle AS c2__subtitle, c2.content AS c2__content, c2.icon AS c2__icon, c2.button_text AS c2__button_text, c2.order_num AS c2__order_num, c2.group_id AS c2__group_id, c2.created_at AS c2__created_at, c2.updated_at AS c2__updated_at, c2.slug AS c2__slug, c4.id AS c4__id, c4.name AS c4__name, c4.subtitle AS c4__subtitle, c4.content AS c4__content, c4.icon AS c4__icon, c4.button_text AS c4__button_text, c4.order_num AS c4__order_num, c4.as_checkbox AS c4__as_checkbox, c4.created_at AS c4__created_at, c4.updated_at AS c4__updated_at, c4.slug AS c4__slug, 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, p3.id AS p3__id, p3.name AS p3__name, p3.box_content AS p3__box_content, p3.box_action_type AS p3__box_action_type, p3.box_action AS p3__box_action, p3.title_subtitle AS p3__title_subtitle, p3.subtitle AS p3__subtitle, p3.title_content AS p3__title_content, p3.content AS p3__content, p3.as_icons AS p3__as_icons, p3.icon AS p3__icon, p3.order_num AS p3__order_num, p3.category_id AS p3__category_id, p3.sub_category_id AS p3__sub_category_id, p3.button_text AS p3__button_text, p3.button_link AS p3__button_link, p3.show_details AS p3__show_details, p3.show_plans AS p3__show_plans, p3.reference AS p3__reference, p3.is_active AS p3__is_active, p3.is_featured AS p3__is_featured, p3.created_at AS p3__created_at, p3.updated_at AS p3__updated_at, p3.slug AS p3__slug FROM coverage c LEFT JOIN coverages_types c3 ON (c.id = c3.coverage_id) LEFT JOIN coverage_type c2 ON c2.id = c3.type_id LEFT JOIN coverage_group c4 ON c2.group_id = c4.id LEFT JOIN product_coverage_types p2 ON (c2.id = p2.type_id) LEFT JOIN product p ON p.id = p2.product_id LEFT JOIN product_coverage_groups p4 ON (c4.id = p4.group_id) LEFT JOIN product p3 ON p3.id = p4.product_id WHERE (c.is_active = ? AND (p.id = 5 OR p3.id = 5) AND (p.is_active = 1 OR p3.is_active = 1)) ORDER BY c.id ASC - (1) |
41 | sfPartialView | Render "sf_app_dir/modules/products/templates/_table_details.php" |
42 | main | Call "products->executeBoxes_content()" |
43 | sfPartialView | Render "sf_app_dir/modules/products/templates/_boxes_content.php" |
44 | sfAdminView | Decorate content with "sf_app_dir/templates/layout.php" |
45 | sfAdminView | Render "sf_app_dir/templates/layout.php" |
46 | main | Call "default->executeFooter()" |
47 | 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 - () |
48 | sfPartialView | Render "sf_app_dir/modules/default/templates/_footer.php" |
49 | 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) |
50 | 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) |
51 | sfWebResponse | Send status "HTTP/1.1 200 OK" |
52 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |