| # |
type |
message |
| 1 | sfPatternRouting | Match route "catalog_category" (/catalog/:slug) for /catalog/zaklepki-fasty-chexiya.html with parameters array ( 'module' => 'catalog', 'action' => 'index', 'slug' => 'zaklepki-fasty-chexiya',) |
| 2 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 3 | sfFilterChain | Executing filter "ipGeoFilter" |
| 4 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 5 | catalogActions | Call "catalogActions->executeIndex()" |
| 6 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
| 7 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.image AS c__image, c.title AS c__title, c.full_title AS c__full_title, c.keywords AS c__keywords, c.description AS c__description, c.show_text AS c__show_text, c.text AS c__text, c.template_id AS c__template_id, c.is_noindex AS c__is_noindex, c.is_disable AS c__is_disable, c.comment AS c__comment, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug, c2.id AS c2__id, c2.category_id AS c2__category_id, c2.position AS c2__position, c2.image AS c2__image, c2.title AS c2__title, c2.full_title AS c2__full_title, c2.keywords AS c2__keywords, c2.description AS c2__description, c2.manufacturer_id AS c2__manufacturer_id, c2.show_text AS c2__show_text, c2.text AS c2__text, c2.price_prefix AS c2__price_prefix, c2.price_code AS c2__price_code, c2.price_postfix AS c2__price_postfix, c2.is_noindex AS c2__is_noindex, c2.is_disable AS c2__is_disable, c2.comment AS c2__comment, c2.slug AS c2__slug, c3.id AS c3__id, c3.category_id AS c3__category_id, c3.code AS c3__code, c3.title AS c3__title, c3.price AS c3__price, c3.special_price AS c3__special_price, c3.is_special AS c3__is_special, c3.is_disable AS c3__is_disable, c4.id AS c4__id, c4.image AS c4__image, c4.title AS c4__title, c4.full_title AS c4__full_title, c4.country AS c4__country, c4.description AS c4__description, c4.text AS c4__text, c4.is_disable AS c4__is_disable, c4.slug AS c4__slug, c5.id AS c5__id, c5.parent_id AS c5__parent_id, c5.image AS c5__image, c5.title AS c5__title, c5.full_title AS c5__full_title, c5.keywords AS c5__keywords, c5.description AS c5__description, c5.show_text AS c5__show_text, c5.text AS c5__text, c5.template_id AS c5__template_id, c5.is_noindex AS c5__is_noindex, c5.is_disable AS c5__is_disable, c5.comment AS c5__comment, c5.lft AS c5__lft, c5.rgt AS c5__rgt, c5.level AS c5__level, c5.slug AS c5__slug FROM catalog_category c LEFT JOIN catalog_product c2 ON c.id = c2.category_id AND (c2.is_disable = 0) LEFT JOIN catalog_product_price c3 ON c2.price_code = c3.code AND (c3.is_disable = 0) LEFT JOIN catalog_manufacturer c4 ON c2.manufacturer_id = c4.id AND (c4.is_disable = 0) LEFT JOIN catalog_category c5 ON c.id = c5.parent_id AND (c5.is_disable = 0) WHERE (c.slug = ? AND c.is_disable = 0) ORDER BY c.lft, c5.lft, c2.position, c2.position ASC - (zaklepki-fasty-chexiya) |
| 8 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.image AS c__image, c.title AS c__title, c.full_title AS c__full_title, c.keywords AS c__keywords, c.description AS c__description, c.show_text AS c__show_text, c.text AS c__text, c.template_id AS c__template_id, c.is_noindex AS c__is_noindex, c.is_disable AS c__is_disable, c.comment AS c__comment, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS c__level, c.slug AS c__slug, c2.id AS c2__id, c2.parent_id AS c2__parent_id, c2.image AS c2__image, c2.title AS c2__title, c2.full_title AS c2__full_title, c2.keywords AS c2__keywords, c2.description AS c2__description, c2.show_text AS c2__show_text, c2.text AS c2__text, c2.template_id AS c2__template_id, c2.is_noindex AS c2__is_noindex, c2.is_disable AS c2__is_disable, c2.comment AS c2__comment, c2.lft AS c2__lft, c2.rgt AS c2__rgt, c2.level AS c2__level, c2.slug AS c2__slug, c3.id AS c3__id, c3.category_id AS c3__category_id, c3.position AS c3__position, c3.image AS c3__image, c3.title AS c3__title, c3.full_title AS c3__full_title, c3.keywords AS c3__keywords, c3.description AS c3__description, c3.manufacturer_id AS c3__manufacturer_id, c3.show_text AS c3__show_text, c3.text AS c3__text, c3.price_prefix AS c3__price_prefix, c3.price_code AS c3__price_code, c3.price_postfix AS c3__price_postfix, c3.is_noindex AS c3__is_noindex, c3.is_disable AS c3__is_disable, c3.comment AS c3__comment, c3.slug AS c3__slug FROM catalog_category c LEFT JOIN catalog_category c2 ON c.id = c2.parent_id AND (c2.is_disable = 0) LEFT JOIN catalog_product c3 ON c.id = c3.category_id AND ((c3.is_disable = 0 AND c3.show_text = 1)) WHERE (c.lft <= ? AND c.rgt >= ?) ORDER BY c.lft, c2.lft, c3.position, c3.position ASC - (183, 188) |
| 9 | sfPHPView | Render "sf_app_dir/modules/catalog/templates/indexSuccess.php" |
| 10 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree.php" |
| 11 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 12 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 13 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 14 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 15 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 16 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 17 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 18 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 19 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 20 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 21 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 22 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 23 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 24 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 25 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 26 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 27 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 28 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 29 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 30 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 31 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 32 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 33 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 34 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 35 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 36 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 37 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 38 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 39 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 40 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 41 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 42 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 43 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 44 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 45 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 46 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 47 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 48 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 49 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 50 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 51 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 52 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 53 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 54 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 55 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 56 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 57 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 58 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 59 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 60 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 61 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 62 | sfPartialView | Render "sf_app_dir/modules/catalog/templates/_tree_node.php" |
| 63 | main | Call "special->executeRandomSpec()" |
| 64 | Doctrine_Connection_Mysql | query : SELECT c.id AS c__id, c.product_id AS c__product_id, c.image AS c__image, c.title AS c__title, c.text AS c__text, c.price_prefix AS c__price_prefix, c.price_code AS c__price_code, c.price_postfix AS c__price_postfix, c.is_main AS c__is_main, c.is_disable AS c__is_disable, c.position AS c__position, c2.id AS c2__id, c2.category_id AS c2__category_id, c2.position AS c2__position, c2.image AS c2__image, c2.title AS c2__title, c2.full_title AS c2__full_title, c2.keywords AS c2__keywords, c2.description AS c2__description, c2.manufacturer_id AS c2__manufacturer_id, c2.show_text AS c2__show_text, c2.text AS c2__text, c2.price_prefix AS c2__price_prefix, c2.price_code AS c2__price_code, c2.price_postfix AS c2__price_postfix, c2.is_noindex AS c2__is_noindex, c2.is_disable AS c2__is_disable, c2.comment AS c2__comment, c2.slug AS c2__slug, c3.id AS c3__id, c3.parent_id AS c3__parent_id, c3.image AS c3__image, c3.title AS c3__title, c3.full_title AS c3__full_title, c3.keywords AS c3__keywords, c3.description AS c3__description, c3.show_text AS c3__show_text, c3.text AS c3__text, c3.template_id AS c3__template_id, c3.is_noindex AS c3__is_noindex, c3.is_disable AS c3__is_disable, c3.comment AS c3__comment, c3.lft AS c3__lft, c3.rgt AS c3__rgt, c3.level AS c3__level, c3.slug AS c3__slug, RAND() AS c__0 FROM catalog_product_special c LEFT JOIN catalog_product c2 ON c.product_id = c2.id AND (c2.is_disable = 0) LEFT JOIN catalog_category c3 ON c2.category_id = c3.id WHERE (c.is_disable = 0) ORDER BY c__0 LIMIT 3 - () |
| 65 | Doctrine_Connection_Mysql | query : SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM catalog_product_special c LEFT JOIN catalog_product c2 ON c.product_id = c2.id AND (c2.is_disable = 0) LEFT JOIN catalog_category c3 ON c2.category_id = c3.id WHERE c.is_disable = 0 GROUP BY c.id) dctrn_count_query - () |
| 66 | sfPartialView | Render "sf_app_dir/modules/special/templates/_randomSpec.php" |
| 67 | sfPartialView | Render "sf_app_dir/modules/special/templates/_special.php" |
| 68 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.category_id AS c__category_id, c.code AS c__code, c.title AS c__title, c.price AS c__price, c.special_price AS c__special_price, c.is_special AS c__is_special, c.is_disable AS c__is_disable FROM catalog_product_price c WHERE (c.code = ?) - (СО-199) |
| 69 | sfPartialView | Render "sf_app_dir/modules/special/templates/_special.php" |
| 70 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.category_id AS c__category_id, c.code AS c__code, c.title AS c__title, c.price AS c__price, c.special_price AS c__special_price, c.is_special AS c__is_special, c.is_disable AS c__is_disable FROM catalog_product_price c WHERE (c.code = ?) - (013800) |
| 71 | sfPartialView | Render "sf_app_dir/modules/special/templates/_special.php" |
| 72 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.category_id AS c__category_id, c.code AS c__code, c.title AS c__title, c.price AS c__price, c.special_price AS c__special_price, c.is_special AS c__is_special, c.is_disable AS c__is_disable FROM catalog_product_price c WHERE (c.code = ?) - (GM-245 5500) |
| 73 | main | Call "promo->executeBanners()" |
| 74 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.uri AS p__uri, p.image AS p__image, p.title AS p__title, p.link AS p__link, p.is_nofollow AS p__is_nofollow, p.is_disable AS p__is_disable, RAND() AS p__0 FROM promo_banner p WHERE (p.uri LIKE ? AND p.is_disable = ?) ORDER BY p__0 - (%/catalog/zaklepki-fasty-chexiya.html, 0) |
| 75 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.uri AS p__uri, p.title AS p__title, p.is_anchor AS p__is_anchor, p.text AS p__text, p.link AS p__link, p.is_disable AS p__is_disable, RAND() AS p__0 FROM promo_link p WHERE (p.uri LIKE ? AND p.is_disable = ?) ORDER BY p__0 - (%/catalog/zaklepki-fasty-chexiya.html, 0) |
| 76 | sfPartialView | Render "sf_app_dir/modules/promo/templates/_banners.php" |
| 77 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 78 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 79 | main | Call "page->executeTopMenu()" |
| 80 | Doctrine_Connection_Mysql | query : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image AS p__image, p.title AS p__title, p.full_title AS p__full_title, p.description AS p__description, p.text AS p__text, p.is_noindex AS p__is_noindex, p.is_disable AS p__is_disable, p.comment AS p__comment, p.lft AS p__lft, p.rgt AS p__rgt, p.level AS p__level, p.slug AS p__slug FROM page p WHERE (p.is_disable = 0 AND p.level = 1) ORDER BY p.lft - () |
| 81 | sfPartialView | Render "sf_app_dir/modules/page/templates/_topMenu.php" |
| 82 | main | Set slot "footer-menu" |
| 83 | sfPartialView | Render "sf_app_dir/modules/page/templates/_headercontakt.php" |
| 84 | sfPartialView | Render "sf_app_dir/modules/search/templates/_panel.php" |
| 85 | sfPartialView | Render "sf_app_dir/modules/page/templates/_topaddress.php" |
| 86 | sfPartialView | Render "sf_app_dir/modules/page/templates/_footer_copyright.php" |
| 87 | main | Get slot "footer-menu" |
| 88 | sfPartialView | Render "sf_app_dir/modules/page/templates/_footer_address.php" |
| 89 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
| 90 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |