ODPOČINEK V ZAHRADĚ

POHOVKY S PODUŠKAMI

Dětské křeslo modré umělá kůže

1 663 Kč

Detail

POHOVKY S PODUŠKAMI

Dětské křeslo růžové umělá kůže

1 656 Kč

Detail

POHOVKY S PODUŠKAMI

Dětské křeslo růžové umělá kůže

2 350 Kč

Detail

POHOVKY S PODUŠKAMI

Dětské křeslo 2 v 1 černé umělá kůže

1 721 Kč

Detail

POHOVKY S PODUŠKAMI

Dětská sedačka s podnožkou růžová umělá ...

2 680 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka z palet s poduš...

8 282 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka s šedými podušk...

14 794 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka s krémovými pod...

11 911 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka s antracitovými...

6 400 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka masivní borovic...

4 972 Kč

Detail

4MÍSTNÉ ZAHRADNÍ POHOVKY

4místná zahradní pohovka masivní borové ...

5 702 Kč

Detail

POHOVKY S PODUŠKAMI

4dílná zahradní sedací souprava s podušk...

15 564 Kč

Detail

POHOVKY S PODUŠKAMI

4dílná zahradní sedací souprava s podušk...

9 532 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní sedací souprava s poduš...

6 868 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka z palet s poduš...

6 670 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka z palet s poduš...

6 094 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka šedá masivní bo...

3 747 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka s šedými podušk...

10 831 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka s poduškami šed...

4 632 Kč

Detail

3MÍSTNÉ ZAHRADNÍ POHOVKY

3místná zahradní pohovka masivní borovic...

3 719 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 /pro-odpocinek with parameters array ( 'module' => 'url', 'action' => 'forward', 'pro-odpocinek' => 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)) - (pro-odpocinek, cs, pro-odpocinek)
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, pro-odpocinek)
16	urlActions	Forward to action "product/list"
17	sfFilterChain	Executing filter "sfRenderingFilter"
18	sfFilterChain	Executing filter "sfGuardRememberMeFilter"
19	sfFilterChain	Executing filter "shoptyAffilFilter"
20	sfFilterChain	Executing filter "shoptyCultureFilter"
21	sfFilterChain	Executing filter "shoptyMetasFilter"
22	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title)
23	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_author)
24	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_description)
25	sfFilterChain	Executing filter "sfExecutionFilter"
26	productActions	Call "productActions->executeList()"
27	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (43)
28	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (1082)
29	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.name AS c__name, c.name2 AS c__name2, c.text AS c__text, c.text2 AS c__text2, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN (?)) - (1082)
30	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.name AS c__name, c.name2 AS c__name2, c.text AS c__text, c.text2 AS c__text2, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN (?)) - (43)
31	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title_suffix)
32	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title_separator)
33	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) LIMIT 1 - (1005)
34	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 - (1005, 1)
35	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 = ?) ORDER BY c.position, name - (1298)
36	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 = ?) ORDER BY c.position, name - (419)
37	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 = ?) ORDER BY c.position, name - (1296)
38	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 = ?) ORDER BY c.position, name - (1297)
39	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 = ?) ORDER BY c.position, name - (1301)
40	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 = ?) ORDER BY c.position, name - (1302)
41	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 = ?) ORDER BY c.position, name - (1299)
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 = ?) ORDER BY c.position, name - (417)
43	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 = ?) ORDER BY c.position, name - (414)
44	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 = ?) ORDER BY c.position, name - (1009)
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 = ?) ORDER BY c.position, name - (90)
46	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)
47	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)
48	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, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
49	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 1660 - (cs, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
50	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, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
51	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 1660 - (cs, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
52	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, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
53	sfPHPView	Render "sf_app_dir/modules/product/templates/listSuccess.php"
54	main	Set slot "ecomm_code"
55	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (43, cs)
56	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (1082, cs)
57	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs)
58	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (43, cs)
59	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (1082, cs)
60	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs)
61	main	Call "isicsBreadcrumbs->executeShow()"
62	sfPartialView	Render "sf_root_dir/plugins/isicsBreadcrumbsPlugin/modules/isicsBreadcrumbs/templates/_show.php"
63	main	Call "category->executeRoots()"
64	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, 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)
65	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
66	main	Call "category->executeSubCategoryList()"
67	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_subCategoryList.php"
68	main	Call "product->executeList()"
69	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_list.php"
70	main	Call "product->executeResults()"
71	sfPartialView	Render "sf_app_dir/modules/product/templates/_results.php"
72	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)
73	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)
74	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)
75	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)
76	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)
77	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 1660 - (cs, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
78	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 (15546, 15547, 15548, 15538, 15515, 5081, 5013, 4975, 4969, 4966, 4965, 4472, 4463, 4089, 4074, 4066, 4012, 4006, 3978, 3956) 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, 1005, 1005, 1298, 419, 1296, 1297, 1301, 1302, 1299, 417, 414, 1009, 90, 1, 1)
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 (?)) - (15546)
82	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)
83	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 = ?) - (1298)
84	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 = ?) - (1005)
85	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 (?)) - (15546)
86	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 - (15546, 1)
87	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (15546)
88	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 = ?) - (15546, 1)
89	main	Call "product->executePrice()"
90	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
91	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 - (15546)
92	main	Call "product->executeListItem()"
93	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
94	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 (?)) - (15547)
95	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 (?)) - (15547)
96	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 - (15547, 1)
97	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (15547)
98	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 = ?) - (15547, 1)
99	main	Call "product->executePrice()"
100	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
101	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 - (15547)
102	main	Call "product->executeListItem()"
103	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
104	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 (?)) - (15548)
105	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 (?)) - (15548)
106	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 - (15548, 1)
107	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (15548)
108	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 = ?) - (15548, 1)
109	main	Call "product->executePrice()"
110	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
111	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 - (15548)
112	main	Call "product->executeListItem()"
113	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
114	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 (?)) - (15538)
115	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 (?)) - (15538)
116	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 - (15538, 1)
117	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (15538)
118	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 = ?) - (15538, 1)
119	main	Call "product->executePrice()"
120	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
121	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 - (15538)
122	main	Call "product->executeListItem()"
123	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
124	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 (?)) - (15515)
125	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 (?)) - (15515)
126	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 - (15515, 1)
127	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (15515)
128	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 = ?) - (15515, 1)
129	main	Call "product->executePrice()"
130	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
131	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 - (15515)
132	main	Call "product->executeListItem()"
133	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
134	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 (?)) - (5081)
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 FROM category c WHERE (c.id = ?) - (1298)
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 (?)) - (5081)
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 - (5081, 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 = ?) - (5081, 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 - (5081)
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 (?)) - (5013)
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 (?)) - (5013)
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 - (5013, 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 = ?) - (5013, 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 - (5013)
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 (?)) - (4975)
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 (?)) - (4975)
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 - (4975, 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 = ?) - (4975, 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 - (4975)
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 (?)) - (4969)
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 (?)) - (4969)
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 - (4969, 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 = ?) - (4969, 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 - (4969)
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 (?)) - (4966)
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 (?)) - (4966)
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 - (4966, 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 = ?) - (4966, 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 - (4966)
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 (?)) - (4965)
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 (?)) - (4965)
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 - (4965, 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 = ?) - (4965, 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 - (4965)
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 (?)) - (4472)
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 (?)) - (4472)
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 - (4472, 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 = ?) - (4472, 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 - (4472)
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 (?)) - (4463)
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 (?)) - (4463)
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 - (4463, 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 = ?) - (4463, 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 - (4463)
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 (?)) - (4089)
208	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 = ?) - (1298)
209	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 (?)) - (4089)
210	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 - (4089, 1)
211	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 = ?) - (4089, 1)
212	main	Call "product->executePrice()"
213	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
214	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 - (4089)
215	main	Call "product->executeListItem()"
216	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
217	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 (?)) - (4074)
218	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 (?)) - (4074)
219	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 - (4074, 1)
220	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 = ?) - (4074, 1)
221	main	Call "product->executePrice()"
222	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
223	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 - (4074)
224	main	Call "product->executeListItem()"
225	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
226	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 (?)) - (4066)
227	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 (?)) - (4066)
228	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 - (4066, 1)
229	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 = ?) - (4066, 1)
230	main	Call "product->executePrice()"
231	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
232	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 - (4066)
233	main	Call "product->executeListItem()"
234	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
235	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 (?)) - (4012)
236	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 (?)) - (4012)
237	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 - (4012, 1)
238	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 = ?) - (4012, 1)
239	main	Call "product->executePrice()"
240	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
241	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 - (4012)
242	main	Call "product->executeListItem()"
243	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
244	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 (?)) - (4006)
245	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 (?)) - (4006)
246	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 - (4006, 1)
247	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 = ?) - (4006, 1)
248	main	Call "product->executePrice()"
249	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
250	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 - (4006)
251	main	Call "product->executeListItem()"
252	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
253	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 (?)) - (3978)
254	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 (?)) - (3978)
255	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (3978, 1)
256	Doctrine_Connection_Statement	execute : SELECT t.id AS t__id, t.const AS t__const, t.type AS t__type, t.is_active AS t__is_active, t.created_at AS t__created_at, t.updated_at AS t__updated_at, t.position AS t__position, t2.tag_id AS t2__tag_id, t2.product_id AS t2__product_id FROM tag t INNER JOIN tag_product t2 ON t.id = t2.tag_id WHERE (t2.product_id = ? AND t.is_active = ?) - (3978, 1)
257	main	Call "product->executePrice()"
258	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
259	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.product_id AS p__product_id, p.external_id AS p__external_id, p.depoto_id AS p__depoto_id, p.availability_id AS p__availability_id, p.code AS p__code, p.ean AS p__ean, p.standard_price AS p__standard_price, p.before_price AS p__before_price, p.purchase_price AS p__purchase_price, p.price AS p__price, p.stock AS p__stock, p.depots AS p__depots, p.sold AS p__sold, p.is_active AS p__is_active, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM product_variant p WHERE (p.product_id IN (?)) ORDER BY p.position ASC - (3978)
260	main	Call "product->executeListItem()"
261	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
262	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, p.product_id AS p__product_id, p.category_id AS p__category_id FROM category c LEFT JOIN product_category p ON c.id = p.category_id WHERE (p.product_id IN (?)) - (3956)
263	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (3956)
264	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (3956, 1)
265	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 = ?) - (3956, 1)
266	main	Call "product->executePrice()"
267	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
268	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 - (3956)
269	main	Set slot "criteo_code"
270	sfPartialView	Render "sf_app_dir/modules/saSimplyPager/templates/_customPager.php"
271	main	Call "saSimplyPager->executePager()"
272	sfPartialView	Render "sf_root_dir/plugins/saSimplyPagerPlugin/modules/saSimplyPager/templates/_pager.php"
273	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_windowBox.php"
274	main	Call "basket->executeWindow()"
275	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_window.php"
276	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)
277	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (basket_window_text2)
278	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
279	sfPHPView	Render "sf_app_dir/templates/layout.php"
280	main	Get slot "ogimage"
281	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_analytics.php"
282	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)
283	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (analitycs_id)
284	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (google_ads_id)
285	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_facebook.php"
286	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)
287	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (html_header)
288	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gtmNoscript.php"
289	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)
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 - (analitycs_id)
291	main	Call "pagePart->executeContent()"
292	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)
293	sfPartialView	Render "sf_app_dir/modules/pagePart/templates/_content.php"
294	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)
295	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)
296	main	Call "fulltext->executeShortForm()"
297	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/fulltext/templates/_shortForm.php"
298	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_previewBox.php"
299	main	Call "basket->executePreview()"
300	sfPartialView	Render "sf_app_dir/modules/basket/templates/_preview.php"
301	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesBox.php"
302	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesUnion.php"
303	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messages.php"
304	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_errors.php"
305	main	Call "category->executeRoots()"
306	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)
307	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
308	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)
309	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (7)
310	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (6)
311	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (1)
312	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (2)
313	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = ?) - (8)
314	main	Call "user->executeSigninFormReg()"
315	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/user/templates/_signinFormReg.php"
316	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gdprModal.php"
317	main	Get slot "ecomm_code"
318	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)
319	sfWebResponse	Send status "HTTP/1.0 200 OK"
320	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	119	258.48	17
Factories	1	7.62	0
Database (Doctrine)	179	699.31	48
Action "url/forward"	1	1359.86	93
Action "product/list"	1	380.05	26
View "Success" for "product/list"	1	695.97	48
Component "isicsBreadcrumbs/show"	1	0.03	0
Partial "isicsBreadcrumbs/_show"	1	0.48	0
Component "category/roots"	2	14.54	1
Partial "category/_roots"	2	9.06	0
Component "category/subCategoryList"	1	0.02	0
Partial "category/_subCategoryList"	1	1.52	0
Component "product/list"	1	0.01	0
Partial "product/_list"	1	564.34	39
Component "product/results"	1	0.02	0
Partial "product/_results"	1	561.20	38
Component "product/listItem"	20	0.39	0
Partial "product/_listItem"	20	410.54	28
Component "product/price"	20	0.66	0
Partial "product/_price"	20	68.71	4
Partial "saSimplyPager/_customPager"	1	1.85	0
Component "saSimplyPager/pager"	1	0.06	0
Partial "saSimplyPager/_pager"	1	0.36	0
Partial "basket/_windowBox"	1	4.62	0
Component "basket/window"	1	0.01	0
Partial "basket/_window"	1	3.50	0
Partial "home/_analytics"	1	7.36	0
Partial "home/_facebook"	1	4.52	0
Partial "home/_gtmNoscript"	1	3.85	0
Component "pagePart/content"	1	2.89	0
Partial "pagePart/_content"	1	2.84	0
Component "fulltext/shortForm"	1	0.02	0
Partial "fulltext/_shortForm"	1	0.33	0
Partial "basket/_previewBox"	1	2.43	0
Component "basket/preview"	1	0.23	0
Partial "basket/_preview"	1	0.56	0
Partial "home/_messagesBox"	1	1.01	0
Partial "home/_messagesUnion"	1	0.74	0
Partial "home/_messages"	1	0.19	0
Partial "home/_errors"	1	0.20	0
Component "user/signinFormReg"	1	0.52	0
Partial "user/_signinFormReg"	1	0.50	0
Partial "home/_gdprModal"	1	0.13	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.01s, "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.01s, "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 = 'pro-odpocinek' AND u.lang = 'cs') OR (u.slug = 'pro-odpocinek' AND u.lang IS NULL))

0.02s, "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 = 'pro-odpocinek')

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.01s, "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.01s, "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.01s, "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 ('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 ('43'))

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.01s, "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 = '1005') 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, 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 = '1005' AND c.is_active = '1') ORDER BY c.position, name

0.01s, "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 = '1298') ORDER BY c.position, name

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 = '419') ORDER BY c.position, name

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 = '1296') ORDER BY c.position, name

0.01s, "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 = '1297') ORDER BY c.position, name

0.01s, "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 = '1301') ORDER BY c.position, name

0.01s, "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 = '1302') ORDER BY c.position, name

0.01s, "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 = '1299') ORDER BY c.position, name

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 = '417') ORDER BY c.position, name

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 = '414') ORDER BY c.position, name

0.01s, "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 = '1009') ORDER BY c.position, name

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 = '90') ORDER BY c.position, name

0.01s, "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.01s, "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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL) GROUP BY p.id) dctrn_count_query

0.07s, "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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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 1660

0.06s, "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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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 1660

0.07s, "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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '43' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '1082' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '0' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '43' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '1082' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '0' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.01s, "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.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.01s, "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.01s, "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 ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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 1660

0.08s, "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 (15546, 15547, 15548, 15538, 15515, 5081, 5013, 4975, 4969, 4966, 4965, 4472, 4463, 4089, 4074, 4066, 4012, 4006, 3978, 3956) AND (p2.lang = 'cs' AND p3.category_id IN ('1005', '1005', '1298', '419', '1296', '1297', '1301', '1302', '1299', '417', '414', '1009', '90') 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.01s, "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 ('15546'))

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.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 = '1298')

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 = '1005')

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 ('15546'))

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 = '15546' AND i.is_main = '1') ORDER BY i.position ASC

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 = '15546') 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 = '15546' 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 ('15546')) ORDER BY p.position ASC

0.01s, "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 ('15547'))

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 ('15547'))

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 = '15547' AND i.is_main = '1') ORDER BY i.position ASC

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 = '15547') 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 = '15547' 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 ('15547')) 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 ('15548'))

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 ('15548'))

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 = '15548' AND i.is_main = '1') ORDER BY i.position ASC

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 = '15548') 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 = '15548' 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 ('15548')) 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 ('15538'))

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 ('15538'))

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 = '15538' AND i.is_main = '1') ORDER BY i.position ASC

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 = '15538') 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 = '15538' 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 ('15538')) 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 ('15515'))

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 ('15515'))

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 = '15515' AND i.is_main = '1') ORDER BY i.position ASC

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 = '15515') 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 = '15515' 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 ('15515')) 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 ('5081'))

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 = '1298')

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 ('5081'))

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 = '5081' 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 = '5081' 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 ('5081')) 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 ('5013'))

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 ('5013'))

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 = '5013' 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 = '5013' 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 ('5013')) 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 ('4975'))

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 ('4975'))

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 = '4975' 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 = '4975' 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 ('4975')) 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 ('4969'))

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 ('4969'))

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 = '4969' 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 = '4969' 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 ('4969')) 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 ('4966'))

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 ('4966'))

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 = '4966' 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 = '4966' 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 ('4966')) 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 ('4965'))

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 ('4965'))

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 = '4965' 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 = '4965' 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 ('4965')) 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 ('4472'))

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 ('4472'))

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 = '4472' 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 = '4472' 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 ('4472')) 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 ('4463'))

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 ('4463'))

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 = '4463' 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 = '4463' 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 ('4463')) 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 ('4089'))

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 = '1298')

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 ('4089'))

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 = '4089' 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 = '4089' 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 ('4089')) 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 ('4074'))

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 ('4074'))

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 = '4074' 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 = '4074' 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 ('4074')) 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 ('4066'))

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 ('4066'))

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 = '4066' 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 = '4066' 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 ('4066')) 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 ('4012'))

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 ('4012'))

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 = '4012' 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 = '4012' 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 ('4012')) 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 ('4006'))

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 ('4006'))

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 = '4006' 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 = '4006' 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 ('4006')) 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 ('3978'))

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 ('3978'))

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 = '3978' 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 = '3978' 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 ('3978')) ORDER BY p.position ASC

0.01s, "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 ('3956'))

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 ('3956'))

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 = '3956' 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 = '3956' 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 ('3956')) 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

ODPOČINEK V ZAHRADĚ

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