| # |
type |
message |
| 1 |  shoptyRouting | Connect sfRoute "url_one" (/*) |
| 2 | shoptyRouting | Match route "url_one" (/*) for /stoly-do-zahrady with parameters array ( 'module' => 'url', 'action' => 'forward', 'stoly-do-zahrady' => true,) |
| 3 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 4 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
| 5 | sfFilterChain | Executing filter "shoptyAffilFilter" |
| 6 | sfFilterChain | Executing filter "shoptyCultureFilter" |
| 7 | sfFilterChain | Executing filter "shoptyMetasFilter" |
| 8 | Doctrine_Connection_Mysql | exec : SET NAMES 'utf8' - () |
| 9 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title) |
| 10 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_author) |
| 11 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_description) |
| 12 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 13 | urlActions | Call "urlActions->executeForward()" |
| 14 | Doctrine_Connection_Statement | execute : SELECT u.id AS u__id, u.slug AS u__slug, u.class AS u__class, u.lang AS u__lang, u.version AS u__version FROM url u WHERE ((u.slug = ? AND u.lang = ?) OR (u.slug = ? AND u.lang IS NULL)) - (stoly-do-zahrady, cs, stoly-do-zahrady) |
| 15 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c2.slug = ?) - (cs, stoly-do-zahrady) |
| 16 | urlActions | Forward to action "product/list" |
| 17 | sfFilterChain | Executing filter "sfRenderingFilter" |
| 18 | sfFilterChain | Executing filter "sfGuardRememberMeFilter" |
| 19 | sfFilterChain | Executing filter "shoptyAffilFilter" |
| 20 | sfFilterChain | Executing filter "shoptyCultureFilter" |
| 21 | sfFilterChain | Executing filter "shoptyMetasFilter" |
| 22 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title) |
| 23 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_author) |
| 24 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_description) |
| 25 | sfFilterChain | Executing filter "sfExecutionFilter" |
| 26 | productActions | Call "productActions->executeList()" |
| 27 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (43) |
| 28 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (1082) |
| 29 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.name2 AS c__name2, c.text AS c__text, c.text2 AS c__text2, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN (?)) - (1082) |
| 30 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.name AS c__name, c.name2 AS c__name2, c.text AS c__text, c.text2 AS c__text2, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN (?)) - (43) |
| 31 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title_suffix) |
| 32 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title_separator) |
| 33 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) LIMIT 1 - (1240) |
| 34 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.currency_id AS c__currency_id, c.culture AS c__culture, c.name AS c__name, c.send AS c__send, c.position AS c__position FROM country c WHERE (c.culture = ?) ORDER BY c.position - (cs) |
| 35 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.rate AS c__rate, c.is_main AS c__is_main, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM currency c WHERE (c.id = ?) - (CZK) |
| 36 | Doctrine_Connection_Statement | execute : SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p2.lang = ? AND p3.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL) GROUP BY p.id) dctrn_count_query - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 37 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p5.id FROM product p5 INNER JOIN product_translation p6 ON p5.id = p6.id INNER JOIN product_category p7 ON p5.id = p7.product_id INNER JOIN availability a2 ON p5.availability_id = a2.id LEFT JOIN product_variant p8 ON p5.id = p8.product_id LEFT JOIN tag_product t4 ON (p5.id = t4.product_id) LEFT JOIN tag t3 ON t3.id = t4.tag_id WHERE p6.lang = ? AND p7.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p5.is_active = ? AND (p8.is_active = ? OR p8.id IS NULL) GROUP BY p5.price ORDER BY p5.price ASC LIMIT 1 OFFSET 100 - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 38 | Doctrine_Connection_Statement | execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IN (15128) AND (p2.lang = ? AND p3.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price ASC, p4.position ASC - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 39 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p5.id FROM product p5 INNER JOIN product_translation p6 ON p5.id = p6.id INNER JOIN product_category p7 ON p5.id = p7.product_id INNER JOIN availability a2 ON p5.availability_id = a2.id LEFT JOIN product_variant p8 ON p5.id = p8.product_id LEFT JOIN tag_product t4 ON (p5.id = t4.product_id) LEFT JOIN tag t3 ON t3.id = t4.tag_id WHERE p6.lang = ? AND p7.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p5.is_active = ? AND (p8.is_active = ? OR p8.id IS NULL) GROUP BY p5.price ORDER BY p5.price DESC LIMIT 1 OFFSET 100 - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 40 | Doctrine_Connection_Statement | execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IN (47562) AND (p2.lang = ? AND p3.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price DESC, p4.position ASC - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 41 | sfPHPView | Render "sf_app_dir/modules/product/templates/listSuccess.php" |
| 42 | main | Set slot "ecomm_code" |
| 43 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (43, cs) |
| 44 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (1082, cs) |
| 45 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs) |
| 46 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (43, cs) |
| 47 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (1082, cs) |
| 48 | Doctrine_Connection_Statement | execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs) |
| 49 | main | Call "isicsBreadcrumbs->executeShow()" |
| 50 | sfPartialView | Render "sf_root_dir/plugins/isicsBreadcrumbsPlugin/modules/isicsBreadcrumbs/templates/_show.php" |
| 51 | main | Call "category->executeRoots()" |
| 52 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id IS NULL AND c.is_active = ?) ORDER BY c.position - (1) |
| 53 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php" |
| 54 | main | Call "category->executeSubCategoryList()" |
| 55 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id = ? AND c.is_active = ?) ORDER BY c.position, name - (1240, 1) |
| 56 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_subCategoryList.php" |
| 57 | main | Call "product->executeList()" |
| 58 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_list.php" |
| 59 | main | Call "product->executeResults()" |
| 60 | sfPartialView | Render "sf_app_dir/modules/product/templates/_results.php" |
| 61 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.currency_id AS c__currency_id, c.culture AS c__culture, c.name AS c__name, c.send AS c__send, c.position AS c__position FROM country c WHERE (c.culture = ?) ORDER BY c.position - (cs) |
| 62 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.rate AS c__rate, c.is_main AS c__is_main, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM currency c WHERE (c.is_main = ?) LIMIT 1 - (1) |
| 63 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.price AS s__price, s.free_price AS s__free_price, s.price_from AS s__price_from, s.price_to AS s__price_to, s.weight_from AS s__weight_from, s.weight_to AS s__weight_to, s.const AS s__const, s.comgate_carrier_id AS s__comgate_carrier_id, s.mailstep_carrier_id AS s__mailstep_carrier_id, s.eskladek_transport_id AS s__eskladek_transport_id, s.heureka_id AS s__heureka_id, s.carrier_const AS s__carrier_const, s.image_filename AS s__image_filename, s.track_url AS s__track_url, s.depoto_id AS s__depoto_id, s.external_id AS s__external_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s.position AS s__position, s2.id AS s2__id, s2.name AS s2__name, s2.text AS s2__text, s2.lang AS s2__lang, s3.shipping_id AS s3__shipping_id, s3.country_id AS s3__country_id, s4.shipping_id AS s4__shipping_id, s4.category_id AS s4__category_id FROM shipping s INNER JOIN shipping_translation s2 ON s.id = s2.id INNER JOIN shipping_country s3 ON s.id = s3.shipping_id LEFT JOIN shipping_category s4 ON s.id = s4.shipping_id WHERE (s2.lang = ? AND s3.country_id = ? AND (s.weight_from <= ? AND (s.weight_to >= ? OR s.weight_to = 0)) AND (s.price_from <= ? AND (s.price_to >= ? OR s.price_to = 0)) AND (s4.category_id IS NULL OR s4.category_id IN (0))) ORDER BY s.position ASC - (cs, cz, 0, 0, 0, 0) |
| 64 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, s.shipping_id AS s__shipping_id, s.category_id AS s__category_id FROM category c LEFT JOIN shipping_category s ON c.id = s.category_id WHERE (s.shipping_id IN (?)) - (9) |
| 65 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.price AS s__price, s.free_price AS s__free_price, s.price_from AS s__price_from, s.price_to AS s__price_to, s.weight_from AS s__weight_from, s.weight_to AS s__weight_to, s.const AS s__const, s.comgate_carrier_id AS s__comgate_carrier_id, s.mailstep_carrier_id AS s__mailstep_carrier_id, s.eskladek_transport_id AS s__eskladek_transport_id, s.heureka_id AS s__heureka_id, s.carrier_const AS s__carrier_const, s.image_filename AS s__image_filename, s.track_url AS s__track_url, s.depoto_id AS s__depoto_id, s.external_id AS s__external_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s.position AS s__position, s2.id AS s2__id, s2.name AS s2__name, s2.text AS s2__text, s2.lang AS s2__lang, s3.shipping_id AS s3__shipping_id, s3.country_id AS s3__country_id, s4.shipping_id AS s4__shipping_id, s4.category_id AS s4__category_id FROM shipping s INNER JOIN shipping_translation s2 ON s.id = s2.id INNER JOIN shipping_country s3 ON s.id = s3.shipping_id LEFT JOIN shipping_category s4 ON s.id = s4.shipping_id WHERE (s2.lang = ? AND s3.country_id = ? AND (s.weight_from <= ? AND (s.weight_to >= ? OR s.weight_to = 0)) AND (s.price_from <= ? AND (s.price_to >= ? OR s.price_to = 0)) AND (s4.category_id IS NULL OR s.id IN (9)) AND s.free_price != ?) ORDER BY s.free_price ASC - (cs, cz, 0, 0, 0, 0, 0) |
| 66 | Doctrine_Connection_Statement | execute : SELECT DISTINCT p5.id, IF(t3.position IS NULL, 999, MIN(t3.position)) AS t3__0 FROM product p5 INNER JOIN product_translation p6 ON p5.id = p6.id INNER JOIN product_category p7 ON p5.id = p7.product_id INNER JOIN availability a2 ON p5.availability_id = a2.id LEFT JOIN product_variant p8 ON p5.id = p8.product_id LEFT JOIN tag_product t4 ON (p5.id = t4.product_id) LEFT JOIN tag t3 ON t3.id = t4.tag_id WHERE p6.lang = ? AND p7.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p5.is_active = ? AND (p8.is_active = ? OR p8.id IS NULL) GROUP BY p5.id ORDER BY a2.position, p5.is_recommend DESC, t3__0, p5.position, p5.sold DESC, p5.created_at DESC, p6.name ASC LIMIT 20 OFFSET 100 - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 67 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.vat_id AS p__vat_id, p.producer_id AS p__producer_id, p.supplier_id AS p__supplier_id, p.availability_id AS p__availability_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.main_category_id AS p__main_category_id, p.code AS p__code, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.is_active AS p__is_active, p.is_recommend AS p__is_recommend, p.is_synch AS p__is_synch, p.private_note AS p__private_note, p.ean AS p__ean, p.weight AS p__weight, p.position AS p__position, p.created_at AS p__created_at, p.updated_at AS p__updated_at, IF(t.position IS NULL, 999, MIN(t.position)) AS t__0 FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IN (47445, 47447, 47448, 47449, 47430, 47431, 47435, 47436, 47438, 47437, 47439, 47420, 47423, 47427, 47428, 47419, 47411, 47400, 47402, 47403) AND (p2.lang = ? AND p3.category_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.id ORDER BY a.position, p.is_recommend DESC, t__0, p.position, p.sold DESC, p.created_at DESC, p2.name ASC, p4.position ASC - (cs, 1240, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1, 1) |
| 68 | main | Call "product->executeListItem()" |
| 69 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 70 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47445) |
| 71 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (1240) |
| 72 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47445) |
| 73 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47445, 1) |
| 74 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47445) |
| 75 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47445, 1) |
| 76 | main | Call "product->executePrice()" |
| 77 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 78 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47445) |
| 79 | main | Call "product->executeListItem()" |
| 80 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 81 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47447) |
| 82 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47447) |
| 83 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47447, 1) |
| 84 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47447) |
| 85 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47447, 1) |
| 86 | main | Call "product->executePrice()" |
| 87 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 88 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47447) |
| 89 | main | Call "product->executeListItem()" |
| 90 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 91 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47448) |
| 92 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47448) |
| 93 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47448, 1) |
| 94 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47448) |
| 95 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47448, 1) |
| 96 | main | Call "product->executePrice()" |
| 97 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 98 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47448) |
| 99 | main | Call "product->executeListItem()" |
| 100 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 101 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47449) |
| 102 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47449) |
| 103 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47449, 1) |
| 104 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47449) |
| 105 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47449, 1) |
| 106 | main | Call "product->executePrice()" |
| 107 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 108 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47449) |
| 109 | main | Call "product->executeListItem()" |
| 110 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 111 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47430) |
| 112 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47430) |
| 113 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47430, 1) |
| 114 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47430) |
| 115 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47430, 1) |
| 116 | main | Call "product->executePrice()" |
| 117 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 118 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47430) |
| 119 | main | Call "product->executeListItem()" |
| 120 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 121 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47431) |
| 122 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47431) |
| 123 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47431, 1) |
| 124 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47431) |
| 125 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47431, 1) |
| 126 | main | Call "product->executePrice()" |
| 127 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 128 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47431) |
| 129 | main | Call "product->executeListItem()" |
| 130 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 131 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47435) |
| 132 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47435) |
| 133 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47435, 1) |
| 134 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47435) |
| 135 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47435, 1) |
| 136 | main | Call "product->executePrice()" |
| 137 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 138 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47435) |
| 139 | main | Call "product->executeListItem()" |
| 140 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 141 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47436) |
| 142 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (1240) |
| 143 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47436) |
| 144 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47436, 1) |
| 145 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47436) |
| 146 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47436, 1) |
| 147 | main | Call "product->executePrice()" |
| 148 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 149 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47436) |
| 150 | main | Call "product->executeListItem()" |
| 151 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 152 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47437) |
| 153 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47437) |
| 154 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47437, 1) |
| 155 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47437) |
| 156 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47437, 1) |
| 157 | main | Call "product->executePrice()" |
| 158 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 159 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47437) |
| 160 | main | Call "product->executeListItem()" |
| 161 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 162 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47438) |
| 163 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47438) |
| 164 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47438, 1) |
| 165 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47438) |
| 166 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47438, 1) |
| 167 | main | Call "product->executePrice()" |
| 168 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 169 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47438) |
| 170 | main | Call "product->executeListItem()" |
| 171 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 172 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47439) |
| 173 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47439) |
| 174 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47439, 1) |
| 175 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47439) |
| 176 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47439, 1) |
| 177 | main | Call "product->executePrice()" |
| 178 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 179 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47439) |
| 180 | main | Call "product->executeListItem()" |
| 181 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 182 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47420) |
| 183 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47420) |
| 184 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47420, 1) |
| 185 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47420) |
| 186 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47420, 1) |
| 187 | main | Call "product->executePrice()" |
| 188 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 189 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47420) |
| 190 | main | Call "product->executeListItem()" |
| 191 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 192 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47423) |
| 193 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47423) |
| 194 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47423, 1) |
| 195 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47423) |
| 196 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47423, 1) |
| 197 | main | Call "product->executePrice()" |
| 198 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 199 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47423) |
| 200 | main | Call "product->executeListItem()" |
| 201 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 202 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47427) |
| 203 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47427) |
| 204 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47427, 1) |
| 205 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47427) |
| 206 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47427, 1) |
| 207 | main | Call "product->executePrice()" |
| 208 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 209 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47427) |
| 210 | main | Call "product->executeListItem()" |
| 211 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 212 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47428) |
| 213 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47428) |
| 214 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47428, 1) |
| 215 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47428) |
| 216 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47428, 1) |
| 217 | main | Call "product->executePrice()" |
| 218 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 219 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47428) |
| 220 | main | Call "product->executeListItem()" |
| 221 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 222 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47419) |
| 223 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47419) |
| 224 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47419, 1) |
| 225 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47419) |
| 226 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47419, 1) |
| 227 | main | Call "product->executePrice()" |
| 228 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 229 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47419) |
| 230 | main | Call "product->executeListItem()" |
| 231 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 232 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47411) |
| 233 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47411) |
| 234 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47411, 1) |
| 235 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47411) |
| 236 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47411, 1) |
| 237 | main | Call "product->executePrice()" |
| 238 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 239 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47411) |
| 240 | main | Call "product->executeListItem()" |
| 241 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 242 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47400) |
| 243 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47400) |
| 244 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47400, 1) |
| 245 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47400) |
| 246 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47400, 1) |
| 247 | main | Call "product->executePrice()" |
| 248 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 249 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47400) |
| 250 | main | Call "product->executeListItem()" |
| 251 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 252 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47402) |
| 253 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47402) |
| 254 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47402, 1) |
| 255 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47402) |
| 256 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47402, 1) |
| 257 | main | Call "product->executePrice()" |
| 258 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 259 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47402) |
| 260 | main | Call "product->executeListItem()" |
| 261 | sfPartialView | Render "sf_app_dir/modules/product/templates/_listItem.php" |
| 262 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (47403) |
| 263 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (47403) |
| 264 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (47403, 1) |
| 265 | Doctrine_Connection_Statement | execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (47403) |
| 266 | Doctrine_Connection_Statement | execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (47403, 1) |
| 267 | main | Call "product->executePrice()" |
| 268 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php" |
| 269 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (47403) |
| 270 | main | Set slot "criteo_code" |
| 271 | sfPartialView | Render "sf_app_dir/modules/saSimplyPager/templates/_customPager.php" |
| 272 | main | Call "saSimplyPager->executePager()" |
| 273 | sfPartialView | Render "sf_root_dir/plugins/saSimplyPagerPlugin/modules/saSimplyPager/templates/_pager.php" |
| 274 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_windowBox.php" |
| 275 | main | Call "basket->executeWindow()" |
| 276 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_window.php" |
| 277 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (basket_window_text1) |
| 278 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (basket_window_text2) |
| 279 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
| 280 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
| 281 | main | Get slot "ogimage" |
| 282 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_analytics.php" |
| 283 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (analytics_type) |
| 284 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (analitycs_id) |
| 285 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (google_ads_id) |
| 286 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_facebook.php" |
| 287 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (facebook_pixel_id) |
| 288 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (html_header) |
| 289 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gtmNoscript.php" |
| 290 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (analytics_type) |
| 291 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (analitycs_id) |
| 292 | main | Call "pagePart->executeContent()" |
| 293 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM page_part p WHERE (p.id = ?) LIMIT 1 - (1) |
| 294 | sfPartialView | Render "sf_app_dir/modules/pagePart/templates/_content.php" |
| 295 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.lang AS p__lang FROM page_part_translation p WHERE (p.id IN (?)) - (1) |
| 296 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (1) |
| 297 | main | Call "fulltext->executeShortForm()" |
| 298 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/fulltext/templates/_shortForm.php" |
| 299 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_previewBox.php" |
| 300 | main | Call "basket->executePreview()" |
| 301 | sfPartialView | Render "sf_app_dir/modules/basket/templates/_preview.php" |
| 302 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesBox.php" |
| 303 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesUnion.php" |
| 304 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messages.php" |
| 305 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_errors.php" |
| 306 | main | Call "category->executeRoots()" |
| 307 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id IS NULL AND c.is_active = ?) ORDER BY c.position - (1) |
| 308 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php" |
| 309 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (4) |
| 310 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (7) |
| 311 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (6) |
| 312 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (1) |
| 313 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (2) |
| 314 | Doctrine_Connection_Statement | execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, 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, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (8) |
| 315 | main | Call "user->executeSigninFormReg()" |
| 316 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/user/templates/_signinFormReg.php" |
| 317 | sfPartialView | Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gdprModal.php" |
| 318 | main | Get slot "ecomm_code" |
| 319 | Doctrine_Connection_Statement | execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (html_footer) |
| 320 | sfWebResponse | Send status "HTTP/1.0 200 OK" |
| 321 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
config
view
logs
12288.0 KB
616 ms
180
