ZAHRADKÁŘSKÉ POTŘEBY

HUBENÍ PLEVELE A ODPUZOVAČE ZVÍŘAT

Vytrhávač plevele 100 cm hliník

613 Kč

Detail

HUBENÍ PLEVELE A ODPUZOVAČE ZVÍŘAT

Akumulátorová strunová sekačka 20 V 1 5...

2 299 Kč

Detail

GEOTEXTILIE A ZAHRADNÍ TKANINY

ProPlus Síť na přívěsný vozík s elastick...

1 369 Kč

Detail

TEXTÍLIE NA OCHRANU PŘED MRAZEM

Nature Zimní fleecový kryt 70 g/m² zelen...

775 Kč

Detail

GEOTEXTILIE A ZAHRADNÍ TKANINY

Nature Zimní fleecový kryt 70 g/m² zelen...

1 153 Kč

Detail

TEXTÍLIE NA OCHRANU PŘED MRAZEM

Nature Zimní fleecový kryt se zipem 70 g...

812 Kč

Detail

GEOTEXTILIE A ZAHRADNÍ TKANINY

Nature Zimní fleecový kryt se zipem 70 g...

1 125 Kč

Detail

GEOTEXTILIE A ZAHRADNÍ TKANINY

Nature Zimní fleecový kryt se zipem 70 g...

1 355 Kč

Detail

TEXTÍLIE NA OCHRANU PŘED MRAZEM

Nature Zimní fleecový kryt se zipem 70 g...

1 070 Kč

Detail

TEXTÍLIE NA OCHRANU PŘED MRAZEM

Nature Zimní fleecový kryt 30 g/m² bílý ...

803 Kč

Detail

OCHRANNÉ NÁVLEKY A TEXTILIE NA ROSTLINY

Nature Síťovina proti hmyzu 2 x 10 m prů...

1 166 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 /pece-o-rostliny with parameters array ( 'module' => 'url', 'action' => 'forward', 'pece-o-rostliny' => 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)) - (pece-o-rostliny, cs, pece-o-rostliny)
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, pece-o-rostliny)
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 = ?) - (1007)
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 = ?) - (1006)
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 (?)) - (1006)
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 (?)) - (1007)
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 - (1117)
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 - (1117, 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 - (12)
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 - (1024)
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 - (1025)
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 - (1030)
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 - (540)
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 - (1193)
41	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)
42	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)
43	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, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
44	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 60 - (cs, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
45	Doctrine_Connection_Statement	execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IN (61584) 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, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
46	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 60 - (cs, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
47	Doctrine_Connection_Statement	execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IN (55889) 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, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
48	sfPHPView	Render "sf_app_dir/modules/product/templates/listSuccess.php"
49	main	Set slot "ecomm_code"
50	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 - (1007, cs)
51	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 - (1006, cs)
52	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)
53	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 - (1007, cs)
54	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 - (1006, cs)
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 - (0, cs)
56	main	Call "isicsBreadcrumbs->executeShow()"
57	sfPartialView	Render "sf_root_dir/plugins/isicsBreadcrumbsPlugin/modules/isicsBreadcrumbs/templates/_show.php"
58	main	Call "category->executeRoots()"
59	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)
60	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
61	main	Call "category->executeSubCategoryList()"
62	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_subCategoryList.php"
63	main	Call "product->executeList()"
64	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_list.php"
65	main	Call "product->executeResults()"
66	sfPartialView	Render "sf_app_dir/modules/product/templates/_results.php"
67	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)
68	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)
69	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)
70	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, 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)
71	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)
72	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 60 - (cs, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
73	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 (42848, 40485, 28557, 23890, 23891, 23893, 23894, 23895, 23897, 23889, 23770) 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, 1117, 1117, 12, 1024, 1025, 1030, 540, 1193, 1, 1)
74	main	Call "product->executeListItem()"
75	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
76	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 (?)) - (42848)
77	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 = ?) - (1010)
78	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 = ?) - (1006)
79	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 = ?) - (1117)
80	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 (?)) - (42848)
81	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 - (42848, 1)
82	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 - (42848)
83	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 = ?) - (42848, 1)
84	main	Call "product->executePrice()"
85	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
86	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 - (42848)
87	main	Call "product->executeListItem()"
88	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
89	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 (?)) - (40485)
90	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 (?)) - (40485)
91	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 - (40485, 1)
92	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 = ?) - (40485, 1)
93	main	Call "product->executePrice()"
94	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
95	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 - (40485)
96	main	Call "product->executeListItem()"
97	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
98	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 (?)) - (28557)
99	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = ?) - (1117)
100	Doctrine_Connection_Statement	execute : SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.name3 AS p__name3, p.heureka_name AS p__heureka_name, p.heurekask_name AS p__heurekask_name, p.google_name AS p__google_name, p.zbozi_name AS p__zbozi_name, p.glami_name AS p__glami_name, p.glamisk_name AS p__glamisk_name, p.heureka_path AS p__heureka_path, p.heurekask_path AS p__heurekask_path, p.google_path AS p__google_path, p.zbozi_path AS p__zbozi_path, p.glami_path AS p__glami_path, p.glamisk_path AS p__glamisk_path, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.text3 AS p__text3, p.text4 AS p__text4, p.text5 AS p__text5, p.text6 AS p__text6, p.meta_title AS p__meta_title, p.meta_keywords AS p__meta_keywords, p.meta_description AS p__meta_description, p.search_text AS p__search_text, p.lang AS p__lang, p.slug AS p__slug FROM product_translation p WHERE (p.id IN (?)) - (28557)
101	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ? AND i.is_main = ?) ORDER BY i.position ASC - (28557, 1)
102	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 - (28557)
103	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 = ?) - (28557, 1)
104	main	Call "product->executePrice()"
105	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
106	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 - (28557)
107	main	Call "product->executeListItem()"
108	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
109	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 (?)) - (23890)
110	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 = ?) - (12)
111	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 (?)) - (23890)
112	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 - (23890, 1)
113	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (23890)
114	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 = ?) - (23890, 1)
115	main	Call "product->executePrice()"
116	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
117	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 - (23890)
118	main	Call "product->executeListItem()"
119	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
120	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 (?)) - (23891)
121	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 (?)) - (23891)
122	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 - (23891, 1)
123	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (23891)
124	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 = ?) - (23891, 1)
125	main	Call "product->executePrice()"
126	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
127	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 - (23891)
128	main	Call "product->executeListItem()"
129	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
130	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 (?)) - (23893)
131	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 (?)) - (23893)
132	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 - (23893, 1)
133	Doctrine_Connection_Statement	execute : SELECT i.id AS i__id, i.product_id AS i__product_id, i.variant_id AS i__variant_id, i.filename AS i__filename, i.is_main AS i__is_main, i.code AS i__code, i.created_at AS i__created_at, i.updated_at AS i__updated_at, i.position AS i__position, i2.id AS i2__id, i2.text AS i2__text, i2.lang AS i2__lang FROM image i INNER JOIN image_translation i2 ON i.id = i2.id WHERE (i.product_id = ?) ORDER BY i.position ASC - (23893)
134	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 = ?) - (23893, 1)
135	main	Call "product->executePrice()"
136	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
137	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 - (23893)
138	main	Call "product->executeListItem()"
139	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
140	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 (?)) - (23894)
141	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 (?)) - (23894)
142	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 - (23894, 1)
143	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 - (23894)
144	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 = ?) - (23894, 1)
145	main	Call "product->executePrice()"
146	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
147	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 - (23894)
148	main	Call "product->executeListItem()"
149	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
150	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 (?)) - (23895)
151	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 (?)) - (23895)
152	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 - (23895, 1)
153	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 - (23895)
154	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 = ?) - (23895, 1)
155	main	Call "product->executePrice()"
156	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
157	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 - (23895)
158	main	Call "product->executeListItem()"
159	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
160	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 (?)) - (23897)
161	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 (?)) - (23897)
162	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 - (23897, 1)
163	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 - (23897)
164	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 = ?) - (23897, 1)
165	main	Call "product->executePrice()"
166	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
167	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 - (23897)
168	main	Call "product->executeListItem()"
169	sfPartialView	Render "sf_app_dir/modules/product/templates/_listItem.php"
170	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 (?)) - (23889)
171	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 (?)) - (23889)
172	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 - (23889, 1)
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 = ?) ORDER BY i.position ASC - (23889)
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 = ?) - (23889, 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 - (23889)
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 (?)) - (23770)
181	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 = ?) - (12)
182	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 (?)) - (23770)
183	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 - (23770, 1)
184	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 = ?) - (23770, 1)
185	main	Call "product->executePrice()"
186	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_price.php"
187	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 - (23770)
188	main	Set slot "criteo_code"
189	sfPartialView	Render "sf_app_dir/modules/saSimplyPager/templates/_customPager.php"
190	main	Call "saSimplyPager->executePager()"
191	sfPartialView	Render "sf_root_dir/plugins/saSimplyPagerPlugin/modules/saSimplyPager/templates/_pager.php"
192	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_windowBox.php"
193	main	Call "basket->executeWindow()"
194	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_window.php"
195	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)
196	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)
197	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
198	sfPHPView	Render "sf_app_dir/templates/layout.php"
199	main	Get slot "ogimage"
200	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_analytics.php"
201	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)
202	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)
203	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)
204	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_facebook.php"
205	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)
206	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)
207	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gtmNoscript.php"
208	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)
209	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)
210	main	Call "pagePart->executeContent()"
211	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)
212	sfPartialView	Render "sf_app_dir/modules/pagePart/templates/_content.php"
213	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)
214	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)
215	main	Call "fulltext->executeShortForm()"
216	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/fulltext/templates/_shortForm.php"
217	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_previewBox.php"
218	main	Call "basket->executePreview()"
219	sfPartialView	Render "sf_app_dir/modules/basket/templates/_preview.php"
220	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesBox.php"
221	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesUnion.php"
222	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messages.php"
223	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_errors.php"
224	main	Call "category->executeRoots()"
225	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, 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)
226	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
227	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)
228	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)
229	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)
230	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)
231	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)
232	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)
233	main	Call "user->executeSigninFormReg()"
234	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/user/templates/_signinFormReg.php"
235	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gdprModal.php"
236	main	Get slot "ecomm_code"
237	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)
238	sfWebResponse	Send status "HTTP/1.0 200 OK"
239	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	83	260.86	21
Factories	1	5.99	0
Database (Doctrine)	134	499.86	41
Action "url/forward"	1	1148.54	96
Action "product/list"	1	236.42	19
View "Success" for "product/list"	1	620.43	52
Component "isicsBreadcrumbs/show"	1	0.04	0
Partial "isicsBreadcrumbs/_show"	1	0.50	0
Component "category/roots"	2	15.81	1
Partial "category/_roots"	2	12.23	1
Component "category/subCategoryList"	1	0.03	0
Partial "category/_subCategoryList"	1	1.73	0
Component "product/list"	1	0.01	0
Partial "product/_list"	1	453.96	38
Component "product/results"	1	0.02	0
Partial "product/_results"	1	449.41	37
Component "product/listItem"	11	0.23	0
Partial "product/_listItem"	11	352.54	29
Component "product/price"	11	0.28	0
Partial "product/_price"	11	43.16	3
Partial "saSimplyPager/_customPager"	1	2.48	0
Component "saSimplyPager/pager"	1	0.08	0
Partial "saSimplyPager/_pager"	1	0.39	0
Partial "basket/_windowBox"	1	9.37	0
Component "basket/window"	1	0.02	0
Partial "basket/_window"	1	7.43	0
Partial "home/_analytics"	1	13.60	1
Partial "home/_facebook"	1	4.17	0
Partial "home/_gtmNoscript"	1	10.35	0
Component "pagePart/content"	1	4.18	0
Partial "pagePart/_content"	1	4.48	0
Component "fulltext/shortForm"	1	0.01	0
Partial "fulltext/_shortForm"	1	0.38	0
Partial "basket/_previewBox"	1	2.73	0
Component "basket/preview"	1	0.32	0
Partial "basket/_preview"	1	0.65	0
Partial "home/_messagesBox"	1	1.00	0
Partial "home/_messagesUnion"	1	0.69	0
Partial "home/_messages"	1	0.22	0
Partial "home/_errors"	1	0.14	0
Component "user/signinFormReg"	1	1.06	0
Partial "user/_signinFormReg"	1	0.52	0
Partial "home/_gdprModal"	1	0.15	0

Doctrine Version: 1.2.4

SET NAMES 'utf8'

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = 'common_title') LIMIT 1

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = 'common_meta_author') LIMIT 1

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = 'common_meta_description') LIMIT 1

0.00s, "doctrine" connection
SELECT u.id AS u__id, u.slug AS u__slug, u.class AS u__class, u.lang AS u__lang, u.version AS u__version FROM url u WHERE ((u.slug = 'pece-o-rostliny' AND u.lang = 'cs') OR (u.slug = 'pece-o-rostliny' AND u.lang IS NULL))

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 LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'cs' AND c2.slug = 'pece-o-rostliny')

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

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

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

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

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = 'common_title_suffix') LIMIT 1

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = 'common_title_separator') LIMIT 1

0.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 = '1117') 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, 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 = '1117' 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 = '12') 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 = '1024') 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 = '1025') 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 = '1030') ORDER BY c.position, name

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 INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id = '540') 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 = '1193') 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.01s, "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 ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL) GROUP BY p.id) dctrn_count_query

0.03s, "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 ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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 60

0.02s, "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 IN (61584) AND (p2.lang = 'cs' AND p3.category_id IN ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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.01s, "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 ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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 60

0.01s, "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 IN (55889) AND (p2.lang = 'cs' AND p3.category_id IN ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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.01s, "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 = '1007' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.01s, "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 = '1006' 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 = '1007' 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 = '1006' AND lang = 'cs') ORDER BY c.position ASC, c2.name ASC

0.01s, "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.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.03s, "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.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 s4.category_id IN (0))) ORDER BY s.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, s.shipping_id AS s__shipping_id, s.category_id AS s__category_id FROM category c LEFT JOIN shipping_category s ON c.id = s.category_id WHERE (s.shipping_id IN ('9'))

0.00s, "doctrine" connection
SELECT s.id AS s__id, s.price AS s__price, s.free_price AS s__free_price, s.price_from AS s__price_from, s.price_to AS s__price_to, s.weight_from AS s__weight_from, s.weight_to AS s__weight_to, s.const AS s__const, s.comgate_carrier_id AS s__comgate_carrier_id, s.mailstep_carrier_id AS s__mailstep_carrier_id, s.eskladek_transport_id AS s__eskladek_transport_id, s.heureka_id AS s__heureka_id, s.carrier_const AS s__carrier_const, s.image_filename AS s__image_filename, s.track_url AS s__track_url, s.depoto_id AS s__depoto_id, s.external_id AS s__external_id, s.created_at AS s__created_at, s.updated_at AS s__updated_at, s.position AS s__position, s2.id AS s2__id, s2.name AS s2__name, s2.text AS s2__text, s2.lang AS s2__lang, s3.shipping_id AS s3__shipping_id, s3.country_id AS s3__country_id, s4.shipping_id AS s4__shipping_id, s4.category_id AS s4__category_id FROM shipping s INNER JOIN shipping_translation s2 ON s.id = s2.id INNER JOIN shipping_country s3 ON s.id = s3.shipping_id LEFT JOIN shipping_category s4 ON s.id = s4.shipping_id WHERE (s2.lang = 'cs' AND s3.country_id = 'cz' AND (s.weight_from <= '0' AND (s.weight_to >= '0' OR s.weight_to = 0)) AND (s.price_from <= '0' AND (s.price_to >= '0' OR s.price_to = 0)) AND (s4.category_id IS NULL OR s.id IN (9)) AND s.free_price != '0') ORDER BY s.free_price ASC

0.00s, "doctrine" connection
SELECT DISTINCT p5.id, IF(t3.position IS NULL, 999, MIN(t3.position)) AS t3__0 FROM product p5 INNER JOIN product_translation p6 ON p5.id = p6.id INNER JOIN product_category p7 ON p5.id = p7.product_id INNER JOIN availability a2 ON p5.availability_id = a2.id LEFT JOIN product_variant p8 ON p5.id = p8.product_id LEFT JOIN tag_product t4 ON (p5.id = t4.product_id) LEFT JOIN tag t3 ON t3.id = t4.tag_id WHERE p6.lang = 'cs' AND p7.category_id IN ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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 60

0.01s, "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 (42848, 40485, 28557, 23890, 23891, 23893, 23894, 23895, 23897, 23889, 23770) AND (p2.lang = 'cs' AND p3.category_id IN ('1117', '1117', '12', '1024', '1025', '1030', '540', '1193') 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 ('42848'))

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

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

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

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

0.01s, "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 = '42848' 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 = '42848') 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 = '42848' 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 ('42848')) 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 ('40485'))

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

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

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

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

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

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

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

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

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

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

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

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 = '23893' 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 = '23893') 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 = '23893' AND t.is_active = '1')

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

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

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

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

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

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

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 = '23897' 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 = '23897') ORDER BY i.position ASC

0.01s, "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 = '23897' 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 ('23897')) 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 ('23889'))

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

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

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

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

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 = '23770' 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 = '23770' 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 ('23770')) 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.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 = '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.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 = '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.01s, "doctrine" connection

ZAHRADKÁŘSKÉ POTŘEBY

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: 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