NÁBYTEK A ZASTÍNĚNÍ NA ZAHRADY A TERASY

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set s jasně zelenými poduš...

4 713 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set s černými poduškami ma...

4 713 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set s béžovými poduškami m...

4 713 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set polyratan černý

7 666 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set polyratan a akáciové d...

5 698 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set ocelový tmavě šedý

5 787 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set masivní akáciové dřevo

7 619 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník černý

11 935 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník černý

11 748 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník bronzový

7 993 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník bílý

10 485 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník bílý

12 350 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník bílý

13 202 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set litý hliník bílý

11 905 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set hliník a textilen čern...

4 193 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set černý ocel

3 356 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný bistro set antracitový plastový

5 202 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný barový set masivní akáciové dřevo

3 906 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný balkonový set litý hliník bronzov...

12 216 Kč

Detail

ZAHRADNÍ JÍDELNÍ SETY

3dílný balkónový set litý hliník bronzov...

12 349 Kč

Detail

Request

Response

User

Settings

app_ckeditor_basePath: /js/ckeditor/
app_default_pagesize: 20
app_lucene_indexes_dir: /var/www/zaplotem.cz/data/indexes
app_sf_guard_plugin_allow_login_with_email: true
app_sf_guard_plugin_routes_register: false
app_sf_guard_plugin_signin_form: UserFormSignin
app_sf_guard_plugin_success_signout_url: '@homepage'
app_shoptySettings_cache:
  class: sfFileCache
  options: { automatic_cleaning_factor: 0, cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/template, lifetime: 1, prefix: /var/www/zaplotem.cz/apps/frontend/template }
app_shoptySettings_cachepaths:
  settings_array: settings.settings_array.cache
  object_array: settings.obj_array.cache
app_shopty_actuality-limit: 5
app_shopty_agmo_cs:
  enable: true
  test: false
  paymentsUrl: 'https://payments.comgate.cz/v1.0/create'
  merchant: 468865
  secret: b1gIOjPixs1gsifQpM6c4oSEH836iQrV
app_shopty_ajax-list: true
app_shopty_autocomplete-pagesize: 5
app_shopty_blog_article:
  small: { width: 200, height: 170 }
  middle: { width: 310, height: 232, method: fill }
  big: { width: 1200, height: 900 }
app_shopty_category-parent-list-products: true
app_shopty_category-products: false
app_shopty_category-tree-open-only-actives: true
app_shopty_cookie-consent: true
app_shopty_gallery:
  small: { width: 200, height: 170 }
  middle: { width: 310, height: 232, method: fill }
  big: { width: 1200, height: 900 }
app_shopty_https: true
app_shopty_invoice-strict: false
app_shopty_langs:
  cs: Česky
app_shopty_memcache:
  enable: true
app_shopty_name: Zaplotem.cz
app_shopty_optionItem:
  big: { width: 376, height: 376 }
  middle: { width: 188, height: 188, method: crop-center }
  small: { width: 80, height: 80, method: crop-center }
app_shopty_presentation:
  big: { width: 550, height: 258 }
  small: { width: 256, height: 120 }
app_shopty_price_bomb:
  small: { width: 200, height: 170, method: fill }
  middle: { width: 310, height: 232, method: fill }
  big: { width: 1200, height: 900 }
app_shopty_product:
  small: { width: 240, height: 180, method: fill }
  middle: { width: 740, height: 555, method: fill }
  big: { width: 1200, height: 1200 }
app_shopty_product-form-ajax: true
app_shopty_product-form-count: input
app_shopty_prosucts-list-odd: 3
app_shopty_shipping:
  big: { width: 160, height: 120 }
  small: { width: 80, height: 60 }
app_shopty_slideshow:
  width: 1120
  height: 450
app_shopty_slot-header: false
app_shopty_vendor:
  width: 150
  height: 50
mod_basket_enabled: true
mod_basket_view_class: sfPHP
mod_category_enabled: true
mod_category_view_class: sfPHP
mod_fulltext_enabled: true
mod_fulltext_view_class: sfPHP
mod_isicsbreadcrumbs_enabled: true
mod_isicsbreadcrumbs_view_class: sfPHP
mod_pagepart_enabled: true
mod_pagepart_view_class: sfPHP
mod_product_enabled: true
mod_product_view_class: sfPHP
mod_sasimplypager_enabled: true
mod_sasimplypager_view_class: sfPHP
mod_url_enabled: true
mod_url_view_class: sfPHP
mod_user_enabled: true
mod_user_view_class: sfPHP
params_coinage-test: false
params_elastic_enable: false
params_elastic_hosts:
  - 'elasticsearch.vsh.tomatom.local:9265'
params_redis_enable: false
params_redis_port: 6379
params_redis_server: redis2.vsh.tomatom.local
params_shopty_depoto:
  enable: false
  mode: eet
  username: shopty@client.depoto.cz
  password: dfgfdgfsdgfdg
  server: 'https://server1.depoto.cz.tomatomstage.cz'
  clientId: 1_2rw1go4w8igw84g0ko488cs8c0ws4ccc8sgsc8ckgoo48ccco8
  clientSecret: 3lvk182vjscgcs4ws44sks88skgkowoc00ow084soc0oc0gg88
  checkout: 21
  create-entities: false
params_shopty_domains:
  cs: www.zaplotem.cz
params_shopty_https: true
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /var/www/zaplotem.cz/cache/frontend
sf_app_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev
sf_app_config_dir: /var/www/zaplotem.cz/apps/frontend/config
sf_app_dir: /var/www/zaplotem.cz/apps/frontend
sf_app_i18n_dir: /var/www/zaplotem.cz/apps/frontend/i18n
sf_app_lib_dir: /var/www/zaplotem.cz/apps/frontend/lib
sf_app_module_dir: /var/www/zaplotem.cz/apps/frontend/modules
sf_app_template_dir: /var/www/zaplotem.cz/apps/frontend/templates
sf_apps_dir: /var/www/zaplotem.cz/apps
sf_cache: false
sf_cache_dir: /var/www/zaplotem.cz/cache
sf_charset: utf-8
sf_check_lock: false
sf_cli: false
sf_compressed: false
sf_config_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/config
sf_config_dir: /var/www/zaplotem.cz/config
sf_csrf_secret: 0e50254fe0db747f06706cf67391f39b41cf0d89
sf_data_dir: /var/www/zaplotem.cz/data
sf_debug: true
sf_default_culture: cs
sf_enabled_modules:
  - default
  - sfGuardAuth
  - saSimplyPager
  - isicsBreadcrumbs
  - home
  - category
  - product
  - basket
  - user
  - url
  - page
  - sitemap
  - actuality
  - actualitySingle
  - slideshow
  - setting
  - comment
  - vendor
  - newsletter
  - producer
  - export
  - codes
  - fulltext
  - invoiceExport
  - refundExport
  - ecommerce
  - parameter
  - banner
  - presentation
  - tag
  - pohoda
  - agmo
  - wishlist
  - gopay
  - timeline
  - webpay
  - attachment
  - cofidis
  - foreignContent
  - essox
  - block
  - touchStore
  - depoto
  - fiopay
  - priceBomb
  - blogArticle
  - blogCategory
  - productReview
  - reclamation
  - payu
  - faq
  - shipping
  - gallery
  - landingPage
  - region
  - heurekaKosik
  - voucher
  - fullfillmentcz
  - pagePart
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: home
sf_error_reporting: 24575
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_file_link_format: null
sf_i18n: true
sf_i18n_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/i18n
sf_lib_dir: /var/www/zaplotem.cz/lib
sf_log_dir: /var/www/zaplotem.cz/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: user
sf_module_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /var/www/zaplotem.cz/plugins
sf_psr_logger: false
sf_root_dir: /var/www/zaplotem.cz
sf_secure_action: secure
sf_secure_module: user
sf_standard_helpers:
  - Partial
  - Cache
  - I18N
  - Common
  - jQueryUI
  - Page
  - Category
  - Presentation
  - PagePart
sf_symfony_lib_dir: /var/www/zaplotem.cz/lib/vendor/friendsofsymfony1/symfony1/lib
sf_template_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/template
sf_test_cache_dir: /var/www/zaplotem.cz/cache/frontend/dev/test
sf_test_dir: /var/www/zaplotem.cz/test
sf_upload_dir: /var/www/zaplotem.cz/web/uploads
sf_upload_dir_name: uploads
sf_use_database: true
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/zaplotem.cz/web
symfony.asset.javascripts_included: true
symfony.asset.stylesheets_included: true
symfony.view.slot_names: {  }

Globals

Php

Logs

#	type	message
1	shoptyRouting	Connect sfRoute "url_one" (/*)
2	shoptyRouting	Match route "url_one" (/*) for /nabytek-3 with parameters array ( 'module' => 'url', 'action' => 'forward', 'nabytek-3' => 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)) - (nabytek-3, cs, nabytek-3)
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, nabytek-3)
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 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)
28	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)
29	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 - (1082)
30	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)
31	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)
32	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, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
33	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 13420 - (cs, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
34	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 IS NULL 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, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
35	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 13420 - (cs, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
36	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 IS NULL 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, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
37	sfPHPView	Render "sf_app_dir/modules/product/templates/listSuccess.php"
38	main	Set slot "ecomm_code"
39	main	Call "isicsBreadcrumbs->executeShow()"
40	sfPartialView	Render "sf_root_dir/plugins/isicsBreadcrumbsPlugin/modules/isicsBreadcrumbs/templates/_show.php"
41	main	Call "category->executeRoots()"
42	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)
43	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
44	main	Call "category->executeSubCategoryList()"
45	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 - (1082, 1)
46	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_subCategoryList.php"
47	main	Call "product->executeList()"
48	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_list.php"
49	main	Call "product->executeResults()"
50	sfPartialView	Render "sf_app_dir/modules/product/templates/_results.php"
51	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)
52	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)
53	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)
54	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)
55	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)
56	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 13420 - (cs, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
57	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 (3072, 3068, 3066, 3053, 3040, 3022, 3001, 2997, 2996, 2990, 2983, 2984, 2982, 2981, 2971, 2967, 2959, 2922, 2897, 2898) 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, 1082, 1082, 43, 411, 475, 1263, 1264, 1265, 1266, 477, 1267, 1268, 1269, 1270, 1271, 1272, 1277, 1278, 1279, 1280, 478, 1273, 1274, 1275, 1276, 1281, 1282, 1283, 1239, 407, 457, 1061, 458, 459, 1062, 1073, 409, 1303, 1300, 1105, 1048, 1049, 1292, 1052, 1293, 1051, 1050, 412, 1288, 1289, 1290, 1291, 1261, 404, 1240, 1249, 1250, 1248, 1246, 1251, 1247, 1256, 1245, 403, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1241, 87, 938, 152, 148, 415, 418, 439, 479, 1, 1087, 80, 1060, 83, 445, 1059, 987, 85, 48, 1086, 1390, 1391, 1392, 1393, 1044, 480, 1388, 1164, 1167, 1166, 1162, 1163, 1165, 1168, 485, 481, 995, 1384, 1383, 1401, 1402, 1386, 1385, 1399, 1400, 1387, 1395, 1396, 1398, 1397, 486, 487, 1088, 1, 1)
58	main	Call "product->executeListItem()"
59	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
60	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 (?)) - (3072)
61	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)
62	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)
63	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 (?)) - (411)
64	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 (?)) - (3072)
65	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 - (3072, 1)
66	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 = ?) - (3072, 1)
67	main	Call "product->executePrice()"
68	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
69	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 - (3072)
70	main	Call "product->executeListItem()"
71	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
72	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 (?)) - (3068)
73	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 (?)) - (3068)
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 = ? AND i.is_main = ?) ORDER BY i.position ASC - (3068, 1)
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 = ?) - (3068, 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 - (3068)
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 (?)) - (3066)
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 (?)) - (3066)
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 - (3066, 1)
84	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 = ?) - (3066, 1)
85	main	Call "product->executePrice()"
86	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
87	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 - (3066)
88	main	Call "product->executeListItem()"
89	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
90	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 (?)) - (3053)
91	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 (?)) - (3053)
92	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 - (3053, 1)
93	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 = ?) - (3053, 1)
94	main	Call "product->executePrice()"
95	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
96	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 - (3053)
97	main	Call "product->executeListItem()"
98	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
99	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 (?)) - (3040)
100	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 (?)) - (3040)
101	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 - (3040, 1)
102	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 = ?) - (3040, 1)
103	main	Call "product->executePrice()"
104	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
105	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 - (3040)
106	main	Call "product->executeListItem()"
107	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
108	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 (?)) - (3022)
109	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 (?)) - (3022)
110	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 - (3022, 1)
111	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 = ?) - (3022, 1)
112	main	Call "product->executePrice()"
113	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
114	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 - (3022)
115	main	Call "product->executeListItem()"
116	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
117	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 (?)) - (3001)
118	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 (?)) - (3001)
119	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 - (3001, 1)
120	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 = ?) - (3001, 1)
121	main	Call "product->executePrice()"
122	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
123	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 - (3001)
124	main	Call "product->executeListItem()"
125	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
126	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 (?)) - (2997)
127	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 (?)) - (2997)
128	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 - (2997, 1)
129	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 = ?) - (2997, 1)
130	main	Call "product->executePrice()"
131	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
132	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 - (2997)
133	main	Call "product->executeListItem()"
134	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
135	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 (?)) - (2996)
136	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 (?)) - (2996)
137	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 - (2996, 1)
138	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 = ?) - (2996, 1)
139	main	Call "product->executePrice()"
140	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
141	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 - (2996)
142	main	Call "product->executeListItem()"
143	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
144	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 (?)) - (2990)
145	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 (?)) - (2990)
146	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 - (2990, 1)
147	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 = ?) - (2990, 1)
148	main	Call "product->executePrice()"
149	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
150	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 - (2990)
151	main	Call "product->executeListItem()"
152	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
153	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 (?)) - (2983)
154	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 (?)) - (2983)
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 = ? AND i.is_main = ?) ORDER BY i.position ASC - (2983, 1)
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 = ?) - (2983, 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 - (2983)
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 (?)) - (2984)
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 (?)) - (2984)
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 - (2984, 1)
165	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 = ?) - (2984, 1)
166	main	Call "product->executePrice()"
167	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
168	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 - (2984)
169	main	Call "product->executeListItem()"
170	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
171	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 (?)) - (2982)
172	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 (?)) - (2982)
173	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 - (2982, 1)
174	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 = ?) - (2982, 1)
175	main	Call "product->executePrice()"
176	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
177	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 - (2982)
178	main	Call "product->executeListItem()"
179	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
180	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 (?)) - (2981)
181	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 (?)) - (2981)
182	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 - (2981, 1)
183	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 = ?) - (2981, 1)
184	main	Call "product->executePrice()"
185	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
186	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 - (2981)
187	main	Call "product->executeListItem()"
188	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
189	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 (?)) - (2971)
190	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 (?)) - (2971)
191	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 - (2971, 1)
192	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 = ?) - (2971, 1)
193	main	Call "product->executePrice()"
194	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
195	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 - (2971)
196	main	Call "product->executeListItem()"
197	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
198	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 (?)) - (2967)
199	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 (?)) - (2967)
200	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 - (2967, 1)
201	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 = ?) - (2967, 1)
202	main	Call "product->executePrice()"
203	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
204	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 - (2967)
205	main	Call "product->executeListItem()"
206	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
207	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 (?)) - (2959)
208	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 (?)) - (2959)
209	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 - (2959, 1)
210	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 = ?) - (2959, 1)
211	main	Call "product->executePrice()"
212	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
213	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 - (2959)
214	main	Call "product->executeListItem()"
215	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
216	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 (?)) - (2922)
217	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 (?)) - (2922)
218	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 - (2922, 1)
219	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 = ?) - (2922, 1)
220	main	Call "product->executePrice()"
221	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
222	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 - (2922)
223	main	Call "product->executeListItem()"
224	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
225	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 (?)) - (2897)
226	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 (?)) - (2897)
227	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 - (2897, 1)
228	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 = ?) - (2897, 1)
229	main	Call "product->executePrice()"
230	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
231	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 - (2897)
232	main	Call "product->executeListItem()"
233	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
234	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 (?)) - (2898)
235	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 (?)) - (2898)
236	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 - (2898, 1)
237	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 = ?) - (2898, 1)
238	main	Call "product->executePrice()"
239	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
240	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 - (2898)
241	main	Set slot "criteo_code"
242	sfPartialView	Render "sf_app_dir/modules/saSimplyPager/templates/_customPager.php"
243	main	Call "saSimplyPager->executePager()"
244	sfPartialView	Render "sf_root_dir/plugins/saSimplyPagerPlugin/modules/saSimplyPager/templates/_pager.php"
245	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_windowBox.php"
246	main	Call "basket->executeWindow()"
247	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_window.php"
248	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)
249	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)
250	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
251	sfPHPView	Render "sf_app_dir/templates/layout.php"
252	main	Get slot "ogimage"
253	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_analytics.php"
254	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)
255	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)
256	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)
257	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_facebook.php"
258	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)
259	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)
260	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gtmNoscript.php"
261	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)
262	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)
263	main	Call "pagePart->executeContent()"
264	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)
265	sfPartialView	Render "sf_app_dir/modules/pagePart/templates/_content.php"
266	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)
267	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)
268	main	Call "fulltext->executeShortForm()"
269	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/fulltext/templates/_shortForm.php"
270	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_previewBox.php"
271	main	Call "basket->executePreview()"
272	sfPartialView	Render "sf_app_dir/modules/basket/templates/_preview.php"
273	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesBox.php"
274	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesUnion.php"
275	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messages.php"
276	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_errors.php"
277	main	Call "category->executeRoots()"
278	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)
279	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
280	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)
281	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)
282	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)
283	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)
284	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)
285	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)
286	main	Call "user->executeSigninFormReg()"
287	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/user/templates/_signinFormReg.php"
288	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gdprModal.php"
289	main	Get slot "ecomm_code"
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 - (html_footer)
291	sfWebResponse	Send status "HTTP/1.0 200 OK"
292	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	119	167.03	5
Factories	1	3.67	0
Database (Doctrine)	151	2391.87	84
Action "url/forward"	1	2795.19	98
Action "product/list"	1	1734.42	61
View "Success" for "product/list"	1	903.51	31
Component "isicsBreadcrumbs/show"	1	0.02	0
Partial "isicsBreadcrumbs/_show"	1	0.21	0
Component "category/roots"	2	8.62	0
Partial "category/_roots"	2	6.47	0
Component "category/subCategoryList"	1	3.53	0
Partial "category/_subCategoryList"	1	1.44	0
Component "product/list"	1	0.01	0
Partial "product/_list"	1	839.03	29
Component "product/results"	1	0.02	0
Partial "product/_results"	1	836.06	29
Component "product/listItem"	20	0.25	0
Partial "product/_listItem"	20	209.86	7
Component "product/price"	20	0.36	0
Partial "product/_price"	20	33.09	1
Partial "saSimplyPager/_customPager"	1	1.60	0
Component "saSimplyPager/pager"	1	0.06	0
Partial "saSimplyPager/_pager"	1	0.35	0
Partial "basket/_windowBox"	1	3.70	0
Component "basket/window"	1	0.01	0
Partial "basket/_window"	1	2.57	0
Partial "home/_analytics"	1	3.31	0
Partial "home/_facebook"	1	1.23	0
Partial "home/_gtmNoscript"	1	2.25	0
Component "pagePart/content"	1	1.82	0
Partial "pagePart/_content"	1	1.50	0
Component "fulltext/shortForm"	1	0.01	0
Partial "fulltext/_shortForm"	1	0.18	0
Partial "basket/_previewBox"	1	1.46	0
Component "basket/preview"	1	0.12	0
Partial "basket/_preview"	1	0.35	0
Partial "home/_messagesBox"	1	0.65	0
Partial "home/_messagesUnion"	1	0.46	0
Partial "home/_messages"	1	0.14	0
Partial "home/_errors"	1	0.11	0
Component "user/signinFormReg"	1	0.48	0
Partial "user/_signinFormReg"	1	0.51	0
Partial "home/_gdprModal"	1	0.12	0

Doctrine Version: 1.2.4

SET NAMES 'utf8'

0.00s, "doctrine" connection
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 = 'common_title') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_meta_author') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_meta_description') LIMIT 1

0.00s, "doctrine" connection
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 = 'nabytek-3' AND u.lang = 'cs') OR (u.slug = 'nabytek-3' AND u.lang IS NULL))

0.00s, "doctrine" connection
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 = 'cs' AND c2.slug = 'nabytek-3')

0.00s, "doctrine" connection
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 = 'common_title') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_meta_author') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_meta_description') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_title_suffix') LIMIT 1

0.00s, "doctrine" connection
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 = 'common_title_separator') LIMIT 1

0.00s, "doctrine" connection
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') LIMIT 1

0.00s, "doctrine" connection
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 = 'cs') ORDER BY c.position

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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 = 'cs' AND p3.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL) GROUP BY p.id) dctrn_count_query

0.55s, "doctrine" connection
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 = 'cs' AND p7.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p5.is_active = '1' AND (p8.is_active = '1' OR p8.id IS NULL) GROUP BY p5.price ORDER BY p5.price ASC LIMIT 1 OFFSET 13420

0.60s, "doctrine" connection
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 IS NULL AND (p2.lang = 'cs' AND p3.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price ASC, p4.position ASC

0.00s, "doctrine" connection
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 = 'cs' AND p7.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p5.is_active = '1' AND (p8.is_active = '1' OR p8.id IS NULL) GROUP BY p5.price ORDER BY p5.price DESC LIMIT 1 OFFSET 13420

0.55s, "doctrine" connection
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 IS NULL AND (p2.lang = 'cs' AND p3.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price DESC, p4.position ASC

0.00s, "doctrine" connection
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 = '1') ORDER BY c.position

0.00s, "doctrine" connection
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 = '1082' AND c.is_active = '1') ORDER BY c.position, name

0.00s, "doctrine" connection
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 = 'cs') ORDER BY c.position

0.00s, "doctrine" connection
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 = '1') LIMIT 1

0.00s, "doctrine" connection
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 = 'cs' AND s3.country_id = 'cz' AND (s.weight_from <= '0' AND (s.weight_to >= '0' OR s.weight_to = 0)) AND (s.price_from <= '0' AND (s.price_to >= '0' OR s.price_to = 0)) AND (s4.category_id IS NULL OR s4.category_id IN (0))) ORDER BY s.position ASC

0.00s, "doctrine" connection
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'))

0.00s, "doctrine" connection
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 = 'cs' AND s3.country_id = 'cz' AND (s.weight_from <= '0' AND (s.weight_to >= '0' OR s.weight_to = 0)) AND (s.price_from <= '0' AND (s.price_to >= '0' OR s.price_to = 0)) AND (s4.category_id IS NULL OR s.id IN (9)) AND s.free_price != '0') ORDER BY s.free_price ASC

0.00s, "doctrine" connection
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 = 'cs' AND p7.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p5.is_active = '1' AND (p8.is_active = '1' 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 13420

0.58s, "doctrine" connection
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 (3072, 3068, 3066, 3053, 3040, 3022, 3001, 2997, 2996, 2990, 2983, 2984, 2982, 2981, 2971, 2967, 2959, 2922, 2897, 2898) AND (p2.lang = 'cs' AND p3.category_id IN ('1082', '1082', '43', '411', '475', '1263', '1264', '1265', '1266', '477', '1267', '1268', '1269', '1270', '1271', '1272', '1277', '1278', '1279', '1280', '478', '1273', '1274', '1275', '1276', '1281', '1282', '1283', '1239', '407', '457', '1061', '458', '459', '1062', '1073', '409', '1303', '1300', '1105', '1048', '1049', '1292', '1052', '1293', '1051', '1050', '412', '1288', '1289', '1290', '1291', '1261', '404', '1240', '1249', '1250', '1248', '1246', '1251', '1247', '1256', '1245', '403', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90', '1241', '87', '938', '152', '148', '415', '418', '439', '479', '1', '1087', '80', '1060', '83', '445', '1059', '987', '85', '48', '1086', '1390', '1391', '1392', '1393', '1044', '480', '1388', '1164', '1167', '1166', '1162', '1163', '1165', '1168', '485', '481', '995', '1384', '1383', '1401', '1402', '1386', '1385', '1399', '1400', '1387', '1395', '1396', '1398', '1397', '486', '487', '1088') AND p.is_active = '1' AND (p4.is_active = '1' 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

0.00s, "doctrine" connection
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 ('3072'))

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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 ('411'))

0.00s, "doctrine" connection
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 ('3072'))

0.00s, "doctrine" connection
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 = '3072' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3072' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3072')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3068'))

0.00s, "doctrine" connection
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 ('3068'))

0.00s, "doctrine" connection
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 = '3068' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3068' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3068')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3066'))

0.00s, "doctrine" connection
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 ('3066'))

0.00s, "doctrine" connection
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 = '3066' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3066' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3066')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3053'))

0.00s, "doctrine" connection
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 ('3053'))

0.00s, "doctrine" connection
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 = '3053' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3053' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3053')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3040'))

0.00s, "doctrine" connection
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 ('3040'))

0.00s, "doctrine" connection
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 = '3040' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3040' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3040')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3022'))

0.00s, "doctrine" connection
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 ('3022'))

0.00s, "doctrine" connection
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 = '3022' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3022' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3022')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('3001'))

0.00s, "doctrine" connection
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 ('3001'))

0.00s, "doctrine" connection
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 = '3001' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '3001' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('3001')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2997'))

0.00s, "doctrine" connection
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 ('2997'))

0.00s, "doctrine" connection
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 = '2997' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2997' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2997')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2996'))

0.00s, "doctrine" connection
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 ('2996'))

0.00s, "doctrine" connection
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 = '2996' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2996' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2996')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2990'))

0.00s, "doctrine" connection
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 ('2990'))

0.00s, "doctrine" connection
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 = '2990' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2990' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2990')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2983'))

0.00s, "doctrine" connection
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 ('2983'))

0.00s, "doctrine" connection
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 = '2983' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2983' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2983')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2984'))

0.00s, "doctrine" connection
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 ('2984'))

0.00s, "doctrine" connection
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 = '2984' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2984' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2984')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2982'))

0.00s, "doctrine" connection
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 ('2982'))

0.00s, "doctrine" connection
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 = '2982' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2982' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2982')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2981'))

0.00s, "doctrine" connection
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 ('2981'))

0.00s, "doctrine" connection
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 = '2981' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2981' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2981')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2971'))

0.00s, "doctrine" connection
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 ('2971'))

0.00s, "doctrine" connection
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 = '2971' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2971' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2971')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2967'))

0.00s, "doctrine" connection
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 ('2967'))

0.00s, "doctrine" connection
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 = '2967' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2967' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2967')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2959'))

0.00s, "doctrine" connection
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 ('2959'))

0.00s, "doctrine" connection
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 = '2959' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2959' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2959')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2922'))

0.00s, "doctrine" connection
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 ('2922'))

0.00s, "doctrine" connection
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 = '2922' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2922' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2922')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2897'))

0.00s, "doctrine" connection
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 ('2897'))

0.00s, "doctrine" connection
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 = '2897' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2897' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2897')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 ('2898'))

0.00s, "doctrine" connection
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 ('2898'))

0.00s, "doctrine" connection
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 = '2898' AND i.is_main = '1') ORDER BY i.position ASC

0.00s, "doctrine" connection
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 = '2898' AND t.is_active = '1')

0.00s, "doctrine" connection
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 ('2898')) ORDER BY p.position ASC

0.00s, "doctrine" connection
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 = 'basket_window_text1') LIMIT 1

0.00s, "doctrine" connection
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 = 'basket_window_text2') LIMIT 1

0.00s, "doctrine" connection
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 = 'analytics_type') LIMIT 1

0.00s, "doctrine" connection
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 = 'analitycs_id') LIMIT 1

0.00s, "doctrine" connection
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 = 'google_ads_id') LIMIT 1

0.00s, "doctrine" connection
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 = 'facebook_pixel_id') LIMIT 1

0.00s, "doctrine" connection
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 = 'html_header') LIMIT 1

0.00s, "doctrine" connection
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 = 'analytics_type') LIMIT 1

0.00s, "doctrine" connection
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 = 'analitycs_id') LIMIT 1

0.00s, "doctrine" connection
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 = '1') LIMIT 1

0.00s, "doctrine" connection
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'))

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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 = '1') ORDER BY c.position

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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')

0.00s, "doctrine" connection
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 = 'html_footer') LIMIT 1

0.00s, "doctrine" connection

NÁBYTEK A ZASTÍNĚNÍ NA ZAHRADY A TERASY

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: product … listSuccess.php

Partial: isicsBreadcrumbs … _show.php

Partial: category … _roots.php

Partial: category … _subCategoryList.php

Partial: product … _list.php

Partial: product … _results.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: product … _listItem.php

Partial: product … _price.php

Partial: saSimplyPager … _customPager.php

Partial: saSimplyPager … _pager.php

Partial: basket … _windowBox.php

Partial: basket … _window.php

Partial: home … _analytics.php

Partial: home … _facebook.php

Partial: home … _gtmNoscript.php

Partial: pagePart … _content.php

Partial: fulltext … _shortForm.php

Partial: basket … _previewBox.php

Partial: basket … _preview.php

Partial: home … _messagesBox.php

Partial: home … _messagesUnion.php

Partial: home … _messages.php

Partial: home … _errors.php

Partial: category … _roots.php

Partial: user … _signinFormReg.php

Partial: home … _gdprModal.php

Logs

Timers

SQL queries

Doctrine Version: 1.2.4