# |
type |
message |
1 | culturePatternRouting | Match route "root_category_i18n" (/:root_category_slug/:sf_culture) for /living-room/en with parameters array ( 'module' => 'products', 'action' => 'look', 'look' => '1', 'root_category_slug' => 'living-room', 'sf_culture' => 'en',) |
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 - (living-room, en, 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 ('1') AND (c2.slug = ? AND c2.lang = ? AND c2.is_published = ?) ORDER BY c.position - (living-room, en, 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 - (en, 1, 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 ('10') AND (c2.lang = ? AND c.parent_id = ? AND c2.is_published = ?) - (en, 1, 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 - (en, 1, 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, 483, 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, 620, 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, 628, 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, 691, 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, 495, 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, 481, 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, 587, 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, 393, 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, 703, 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, 25, 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, 701, 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, 26, 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, 27, 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, 31, 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, 32, 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, 30, 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, 33, 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, 34, 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, 35, 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, 36, 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, 37, 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, 38, 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, 39, 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, 40, 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, 41, 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, 42, 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, 43, 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, 392, 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, 242, 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, 243, 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, 244, 1, 1) |
46 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
47 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
48 | main | Call "common->executeTitle()" |
49 | 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 = ?) - (living-room) |
50 | sfPartialView | Render "sf_app_dir/modules/common/templates/_title.php" |
51 | 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_en) |
52 | main | Call "common->executeTopMenu()" |
53 | 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 - (en, 1) |
54 | sfPartialView | Render "sf_app_dir/modules/common/templates/_topMenu.php" |
55 | 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 - (en, 2) |
56 | 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 = ?) - (en, 2) |
57 | 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 - (en, 1) |
58 | 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 = ?) - (en, 1) |
59 | 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 - (en, 3) |
60 | 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 = ?) - (en, 3) |
61 | 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 - (en, 4) |
62 | 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 = ?) - (en, 4) |
63 | 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 - (en, 5) |
64 | 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 = ?) - (en, 5) |
65 | 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 - (en, 6) |
66 | 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 = ?) - (en, 6) |
67 | 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 - (en, 7) |
68 | 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 = ?) - (en, 7) |
69 | 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 - (en, 8) |
70 | 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 = ?) - (en, 8) |
71 | main | Call "common->executeFooter()" |
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 IS NULL OR c.parent_id = 0) AND c2.is_published = ?) ORDER BY c.position - (en, 1) |
73 | 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, en, 1) |
74 | 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, en, 1) |
75 | 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, en, 1) |
76 | sfPartialView | Render "sf_app_dir/modules/common/templates/_footer.php" |
77 | main | Call "common->executeNewsletter()" |
78 | 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, en, 1) |
79 | 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, en, 1) |
80 | sfPartialView | Render "sf_app_dir/modules/common/templates/_newsletter.php" |
81 | sfWebResponse | Send status "HTTP/2.0 200 OK" |
82 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |