# |
type |
message |
1 | culturePatternRouting | Match route "root_category" (/:root_category_slug) for /spalnq with parameters array ( 'module' => 'products', 'action' => 'look', 'look' => '1', 'root_category_slug' => 'spalnq',) |
2 | sfFilterChain | Executing filter "sfRenderingFilter" |
3 | sfFilterChain | Executing filter "switchLanguageFilter" |
4 | sfFilterChain | Executing filter "appConfigsFilter" |
5 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
6 | Doctrine_Connection_Mysql | query : SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a - () |
7 | sfFilterChain | Executing filter "sfExecutionFilter" |
8 | productsActions | Call "productsActions->executeLook()" |
9 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.slug = ? AND c4.lang = ? AND c4.is_published = ? ORDER BY c3.position LIMIT 1 - (spalnq, bg, 1) |
10 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE c.id IN ('4') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (spalnq, bg, 1) |
11 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c3.id FROM category c3 LEFT JOIN category_translation c4 ON c3.id = c4.id WHERE c4.lang = ? AND c3.parent_id = ? AND c4.is_published = ? LIMIT 1 - (bg, 4, 1) |
12 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE c.id IN ('20') AND (c2.lang = ? AND c.parent_id = ? AND c2.is_published = ?) - (bg, 4, 1) |
13 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.category_id AS p__category_id, p.price AS p__price, p.promo_price AS p__promo_price, p.stock AS p__stock, p.is_active AS p__is_active, p.is_new AS p__is_new, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.body AS p2__body, p2.tab_title1 AS p2__tab_title1, p2.body1 AS p2__body1, p2.tab_title2 AS p2__tab_title2, p2.body2 AS p2__body2, p2.tab_title3 AS p2__tab_title3, p2.body3 AS p2__body3, p2.tab_title4 AS p2__tab_title4, p2.body4 AS p2__body4, p2.tab_title5 AS p2__tab_title5, p2.body5 AS p2__body5, p2.tab_title6 AS p2__tab_title6, p2.body6 AS p2__body6, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ? AND p.is_active = ?) ORDER BY p.position, p.id - (bg, 4, 1) |
14 | sfPHPView | Render "sf_app_dir/modules/products/templates/lookSuccess.php" |
15 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 485, 1, 1) |
16 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 725, 1, 1) |
17 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 479, 1, 1) |
18 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 619, 1, 1) |
19 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 629, 1, 1) |
20 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 706, 1, 1) |
21 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 497, 1, 1) |
22 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 692, 1, 1) |
23 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 705, 1, 1) |
24 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 699, 1, 1) |
25 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 693, 1, 1) |
26 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 96, 1, 1) |
27 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 509, 1, 1) |
28 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 97, 1, 1) |
29 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 98, 1, 1) |
30 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 99, 1, 1) |
31 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 100, 1, 1) |
32 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 432, 1, 1) |
33 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 433, 1, 1) |
34 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 434, 1, 1) |
35 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 435, 1, 1) |
36 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 438, 1, 1) |
37 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 101, 1, 1) |
38 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 102, 1, 1) |
39 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 103, 1, 1) |
40 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 104, 1, 1) |
41 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 436, 1, 1) |
42 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 105, 1, 1) |
43 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 106, 1, 1) |
44 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 107, 1, 1) |
45 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 431, 1, 1) |
46 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 108, 1, 1) |
47 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 486, 1, 1) |
48 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 487, 1, 1) |
49 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 488, 1, 1) |
50 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 109, 1, 1) |
51 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 489, 1, 1) |
52 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 437, 1, 1) |
53 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 110, 1, 1) |
54 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 111, 1, 1) |
55 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 112, 1, 1) |
56 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 113, 1, 1) |
57 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 114, 1, 1) |
58 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 115, 1, 1) |
59 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 116, 1, 1) |
60 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 267, 1, 1) |
61 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 268, 1, 1) |
62 | Doctrine_Connection_Statement | execute : SELECT f.file AS f__file FROM file f WHERE (f.tbl_name = ? AND f.tbl_id = ? AND f.type = ? AND f.is_active = ?) ORDER BY f.position LIMIT 1 - (product, 465, 1, 1) |
63 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
64 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
65 | main | Call "common->executeTitle()" |
66 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.slug = ?) - (spalnq) |
67 | sfPartialView | Render "sf_app_dir/modules/common/templates/_title.php" |
68 | Doctrine_Connection_Statement | execute : SELECT a.id AS a__id, a.var_key AS a__var_key, a.var_value AS a__var_value FROM app_var a WHERE (a.var_key = ?) - (privacy_policy_link_bg) |
69 | main | Call "common->executeTopMenu()" |
70 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (bg, 1) |
71 | sfPartialView | Render "sf_app_dir/modules/common/templates/_topMenu.php" |
72 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 2) |
73 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 2) |
74 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 1) |
75 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 1) |
76 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 3) |
77 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 3) |
78 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 4) |
79 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 4) |
80 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 5) |
81 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 5) |
82 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 6) |
83 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 6) |
84 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 7) |
85 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 7) |
86 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c.parent_id = ?) ORDER BY c.position - (bg, 8) |
87 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS p__0 FROM product p LEFT JOIN product_translation p2 ON p.id = p2.id WHERE (p2.lang = ? AND p.category_id = ?) - (bg, 8) |
88 | main | Call "common->executeFooter()" |
89 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.stock AS c__stock, c.picture AS c__picture, c.look_picture AS c__look_picture, c.position AS c__position, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c2.id AS c2__id, c2.title AS c2__title, c2.slug AS c2__slug, c2.body AS c2__body, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.is_published AS c2__is_published, c2.lang AS c2__lang FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND (c.parent_id IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (bg, 1) |
90 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE (p.type = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (4, bg, 1) |
91 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = ? AND p4.lang = ? AND p4.is_published = ? ORDER BY p3.position LIMIT 1 - (1, bg, 1) |
92 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE p.id IN ('1') AND (p.type = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (1, bg, 1) |
93 | sfPartialView | Render "sf_app_dir/modules/common/templates/_footer.php" |
94 | main | Call "common->executeNewsletter()" |
95 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p3.id FROM page p3 LEFT JOIN page_translation p4 ON p3.id = p4.id WHERE p3.type = ? AND p4.lang = ? AND p4.is_published = ? ORDER BY p3.position LIMIT 1 - (10, bg, 1) |
96 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.image_id AS p__image_id, p.file_id AS p__file_id, p.picture AS p__picture, p.on_homepage AS p__on_homepage, p.type AS p__type, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p2.id AS p2__id, p2.title AS p2__title, p2.slug AS p2__slug, p2.short_title AS p2__short_title, p2.link AS p2__link, p2.file AS p2__file, p2.body AS p2__body, p2.short_body AS p2__short_body, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.is_published AS p2__is_published, p2.lang AS p2__lang FROM page p LEFT JOIN page_translation p2 ON p.id = p2.id WHERE p.id IN ('20') AND (p.type = ? AND p2.lang = ? AND p2.is_published = ?) ORDER BY p.position - (10, bg, 1) |
97 | sfPartialView | Render "sf_app_dir/modules/common/templates/_newsletter.php" |
98 | sfWebResponse | Send status "HTTP/2.0 200 OK" |
99 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |