VCHODOVÉ STŘÍŠKY | zaplotem.cz

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 /vchodove-strisky-3 with parameters array ( 'module' => 'url', 'action' => 'forward', 'vchodove-strisky-3' => true,)
3	sfFilterChain	Executing filter "sfRenderingFilter"
4	sfFilterChain	Executing filter "sfGuardRememberMeFilter"
5	sfFilterChain	Executing filter "shoptyAffilFilter"
6	sfFilterChain	Executing filter "shoptyCultureFilter"
7	sfFilterChain	Executing filter "shoptyMetasFilter"
8	Doctrine_Connection_Mysql	exec : SET NAMES 'utf8' - ()
9	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title)
10	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_author)
11	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_description)
12	sfFilterChain	Executing filter "sfExecutionFilter"
13	urlActions	Call "urlActions->executeForward()"
14	Doctrine_Connection_Statement	execute : SELECT u.id AS u__id, u.slug AS u__slug, u.class AS u__class, u.lang AS u__lang, u.version AS u__version FROM url u WHERE ((u.slug = ? AND u.lang = ?) OR (u.slug = ? AND u.lang IS NULL)) - (vchodove-strisky-3, cs, vchodove-strisky-3)
15	Doctrine_Connection_Statement	execute : SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = ? AND c2.slug = ?) - (cs, vchodove-strisky-3)
16	urlActions	Forward to action "product/list"
17	sfFilterChain	Executing filter "sfRenderingFilter"
18	sfFilterChain	Executing filter "sfGuardRememberMeFilter"
19	sfFilterChain	Executing filter "shoptyAffilFilter"
20	sfFilterChain	Executing filter "shoptyCultureFilter"
21	sfFilterChain	Executing filter "shoptyMetasFilter"
22	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_title)
23	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_author)
24	Doctrine_Connection_Statement	execute : SELECT s.id AS s__id, s.name AS s__name, s.type AS s__type, s.is_translated AS s__is_translated, s.widget_options AS s__widget_options, s.value AS s__value, s.setting_group AS s__setting_group, s.slug AS s__slug, s.position AS s__position FROM setting s WHERE (s.slug = ?) LIMIT 1 - (common_meta_description)
25	sfFilterChain	Executing filter "sfExecutionFilter"
26	productActions	Call "productActions->executeList()"
27	Doctrine_Connection_Statement	execute : SELECT 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 = ?) - (1034)
28	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 (?)) - (1034)
29	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)
30	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)
31	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 - (482)
32	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 - (482, 1)
33	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)
34	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)
35	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, 482, 482, 1, 1)
36	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 600 - (cs, 482, 482, 1, 1)
37	Doctrine_Connection_Statement	execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IS NULL AND (p2.lang = ? AND p3.category_id IN (?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price ASC, p4.position ASC - (cs, 482, 482, 1, 1)
38	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 600 - (cs, 482, 482, 1, 1)
39	Doctrine_Connection_Statement	execute : SELECT p.price AS p__price FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p.id IS NULL AND (p2.lang = ? AND p3.category_id IN (?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price DESC, p4.position ASC - (cs, 482, 482, 1, 1)
40	sfPHPView	Render "sf_app_dir/modules/product/templates/listSuccess.php"
41	main	Set slot "ecomm_code"
42	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 - (1034, cs)
43	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs)
44	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (1034, cs)
45	Doctrine_Connection_Statement	execute : SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = ? AND lang = ?) ORDER BY c.position ASC, c2.name ASC - (0, cs)
46	main	Call "isicsBreadcrumbs->executeShow()"
47	sfPartialView	Render "sf_root_dir/plugins/isicsBreadcrumbsPlugin/modules/isicsBreadcrumbs/templates/_show.php"
48	main	Call "category->executeRoots()"
49	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)
50	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
51	main	Call "category->executeSubCategoryList()"
52	main	Call "product->executeList()"
53	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/product/templates/_list.php"
54	main	Call "product->executeResults()"
55	sfPartialView	Render "sf_app_dir/modules/product/templates/_results.php"
56	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)
57	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)
58	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)
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, 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)
60	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)
61	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 600 - (cs, 482, 482, 1, 1)
62	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 IS NULL AND (p2.lang = ? AND p3.category_id IN (?, ?) AND p.is_active = ? AND (p4.is_active = ? OR p4.id IS NULL)) GROUP BY p.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, 482, 482, 1, 1)
63	main	Set slot "criteo_code"
64	sfPartialView	Render "sf_app_dir/modules/saSimplyPager/templates/_customPager.php"
65	main	Call "saSimplyPager->executePager()"
66	sfPartialView	Render "sf_root_dir/plugins/saSimplyPagerPlugin/modules/saSimplyPager/templates/_pager.php"
67	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_windowBox.php"
68	main	Call "basket->executeWindow()"
69	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_window.php"
70	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)
71	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)
72	sfPHPView	Decorate content with "sf_app_dir/templates/layout.php"
73	sfPHPView	Render "sf_app_dir/templates/layout.php"
74	main	Get slot "ogimage"
75	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_analytics.php"
76	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)
77	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)
78	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)
79	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_facebook.php"
80	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)
81	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)
82	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gtmNoscript.php"
83	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)
84	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)
85	main	Call "pagePart->executeContent()"
86	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)
87	sfPartialView	Render "sf_app_dir/modules/pagePart/templates/_content.php"
88	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)
89	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)
90	main	Call "fulltext->executeShortForm()"
91	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/fulltext/templates/_shortForm.php"
92	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/basket/templates/_previewBox.php"
93	main	Call "basket->executePreview()"
94	sfPartialView	Render "sf_app_dir/modules/basket/templates/_preview.php"
95	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesBox.php"
96	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messagesUnion.php"
97	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_messages.php"
98	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_errors.php"
99	main	Call "category->executeRoots()"
100	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)
101	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/category/templates/_roots.php"
102	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)
103	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)
104	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)
105	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)
106	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)
107	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)
108	main	Call "user->executeSigninFormReg()"
109	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/user/templates/_signinFormReg.php"
110	sfPartialView	Render "sf_root_dir/plugins/shoptyFrontendPlugin/modules/home/templates/_gdprModal.php"
111	main	Get slot "ecomm_code"
112	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)
113	sfWebResponse	Send status "HTTP/1.0 200 OK"
114	sfWebResponse	Send header "Content-Type: text/html; charset=utf-8"

SQL queries

type	calls	time (ms)	time (%)
Configuration	39	162.28	42
Factories	1	14.92	3
Database (Doctrine)	54	83.49	21
Action "url/forward"	1	347.37	90
Action "product/list"	1	64.07	16
View "Success" for "product/list"	1	115.24	29
Component "isicsBreadcrumbs/show"	1	0.02	0
Partial "isicsBreadcrumbs/_show"	1	0.33	0
Component "category/roots"	2	8.43	2
Partial "category/_roots"	2	6.50	1
Component "category/subCategoryList"	1	0.01	0
Component "product/list"	1	0.01	0
Partial "product/_list"	1	44.81	11
Component "product/results"	1	0.02	0
Partial "product/_results"	1	29.73	7
Partial "saSimplyPager/_customPager"	1	13.80	3
Component "saSimplyPager/pager"	1	0.06	0
Partial "saSimplyPager/_pager"	1	0.31	0
Partial "basket/_windowBox"	1	6.60	1
Component "basket/window"	1	0.01	0
Partial "basket/_window"	1	5.43	1
Partial "home/_analytics"	1	3.88	1
Partial "home/_facebook"	1	1.29	0
Partial "home/_gtmNoscript"	1	2.46	0
Component "pagePart/content"	1	2.17	0
Partial "pagePart/_content"	1	1.60	0
Component "fulltext/shortForm"	1	0.01	0
Partial "fulltext/_shortForm"	1	0.21	0
Partial "basket/_previewBox"	1	1.54	0
Component "basket/preview"	1	0.14	0
Partial "basket/_preview"	1	0.39	0
Partial "home/_messagesBox"	1	0.66	0
Partial "home/_messagesUnion"	1	0.48	0
Partial "home/_messages"	1	0.15	0
Partial "home/_errors"	1	0.12	0
Component "user/signinFormReg"	1	0.43	0
Partial "user/_signinFormReg"	1	0.40	0
Partial "home/_gdprModal"	1	0.12	0

Doctrine Version: 1.2.4

SET NAMES 'utf8'

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

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

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

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

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c LEFT JOIN category_translation c2 ON c.id = c2.id WHERE (c2.lang = 'cs' AND c2.slug = 'vchodove-strisky-3')

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

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

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

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

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.name AS c__name, c.name2 AS c__name2, c.text AS c__text, c.text2 AS c__text2, c.meta_title AS c__meta_title, c.meta_keywords AS c__meta_keywords, c.meta_description AS c__meta_description, c.lang AS c__lang, c.slug AS c__slug FROM category_translation c WHERE (c.id IN ('1034'))

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

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

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position FROM category c WHERE (c.id = '482') LIMIT 1

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id = '482' AND c.is_active = '1') ORDER BY c.position, name

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.currency_id AS c__currency_id, c.culture AS c__culture, c.name AS c__name, c.send AS c__send, c.position AS c__position FROM country c WHERE (c.culture = 'cs') ORDER BY c.position

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.rate AS c__rate, c.is_main AS c__is_main, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM currency c WHERE (c.id = 'CZK')

0.00s, "doctrine" connection
SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM product p INNER JOIN product_translation p2 ON p.id = p2.id INNER JOIN product_category p3 ON p.id = p3.product_id INNER JOIN availability a ON p.availability_id = a.id LEFT JOIN product_variant p4 ON p.id = p4.product_id LEFT JOIN tag_product t2 ON (p.id = t2.product_id) LEFT JOIN tag t ON t.id = t2.tag_id WHERE p2.lang = 'cs' AND p3.category_id IN ('482', '482') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL) GROUP BY p.id) dctrn_count_query

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 ('482', '482') 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 600

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 IS NULL AND (p2.lang = 'cs' AND p3.category_id IN ('482', '482') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price ASC, p4.position ASC

0.00s, "doctrine" connection
SELECT DISTINCT p5.id FROM product p5 INNER JOIN product_translation p6 ON p5.id = p6.id INNER JOIN product_category p7 ON p5.id = p7.product_id INNER JOIN availability a2 ON p5.availability_id = a2.id LEFT JOIN product_variant p8 ON p5.id = p8.product_id LEFT JOIN tag_product t4 ON (p5.id = t4.product_id) LEFT JOIN tag t3 ON t3.id = t4.tag_id WHERE p6.lang = 'cs' AND p7.category_id IN ('482', '482') 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 600

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 IS NULL AND (p2.lang = 'cs' AND p3.category_id IN ('482', '482') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL)) GROUP BY p.price ORDER BY p.price DESC, p4.position ASC

0.00s, "doctrine" connection
SELECT c.parent_id AS c__parent_id, c2.name AS c2__name FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.id = '1034' 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 = '1034' 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.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id IS NULL AND c.is_active = '1') ORDER BY c.position

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.currency_id AS c__currency_id, c.culture AS c__culture, c.name AS c__name, c.send AS c__send, c.position AS c__position FROM country c WHERE (c.culture = 'cs') ORDER BY c.position

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.rate AS c__rate, c.is_main AS c__is_main, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM currency c WHERE (c.is_main = '1') LIMIT 1

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

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, s.shipping_id AS s__shipping_id, s.category_id AS s__category_id FROM category c LEFT JOIN shipping_category s ON c.id = s.category_id WHERE (s.shipping_id IN ('9'))

0.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 ('482', '482') 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 600

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 IS NULL AND (p2.lang = 'cs' AND p3.category_id IN ('482', '482') AND p.is_active = '1' AND (p4.is_active = '1' OR p4.id IS NULL)) GROUP BY p.id ORDER BY a.position, p.is_recommend DESC, t__0, p.position, p.sold DESC, p.created_at DESC, p2.name ASC, p4.position ASC

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

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

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

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

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

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

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

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

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

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position FROM page_part p WHERE (p.id = '1') LIMIT 1

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.name AS p__name, p.name2 AS p__name2, p.perex AS p__perex, p.text AS p__text, p.text2 AS p__text2, p.lang AS p__lang FROM page_part_translation p WHERE (p.id IN ('1'))

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '1')

0.00s, "doctrine" connection
SELECT c.id AS c__id, c.parent_id AS c__parent_id, c.external_id AS c__external_id, c.depoto_id AS c__depoto_id, c.main_product_id AS c__main_product_id, c.is_active AS c__is_active, c.feed_export AS c__feed_export, c.is_in_filter AS c__is_in_filter, c.show_filter AS c__show_filter, c.css_class AS c__css_class, c.image_filename AS c__image_filename, c.heureka_name AS c__heureka_name, c.heurekask_name AS c__heurekask_name, c.google_name AS c__google_name, c.zbozi_name AS c__zbozi_name, c.glami_name AS c__glami_name, c.glamisk_name AS c__glamisk_name, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.position AS c__position, c2.id AS c2__id, c2.name AS c2__name, c2.name2 AS c2__name2, c2.text AS c2__text, c2.text2 AS c2__text2, c2.meta_title AS c2__meta_title, c2.meta_keywords AS c2__meta_keywords, c2.meta_description AS c2__meta_description, c2.lang AS c2__lang, c2.slug AS c2__slug FROM category c INNER JOIN category_translation c2 ON c.id = c2.id WHERE (c.parent_id IS NULL AND c.is_active = '1') ORDER BY c.position

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '4')

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '7')

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '6')

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '1')

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '2')

0.00s, "doctrine" connection
SELECT p.id AS p__id, p.parent_id AS p__parent_id, p.is_in_menu AS p__is_in_menu, p.is_partial AS p__is_partial, p.feed_export AS p__feed_export, p.is_deletable AS p__is_deletable, p.filename AS p__filename, p.created_at AS p__created_at, p.updated_at AS p__updated_at, p.position AS p__position, p2.id AS p2__id, p2.name AS p2__name, p2.name2 AS p2__name2, p2.perex AS p2__perex, p2.text AS p2__text, p2.menu_name AS p2__menu_name, p2.meta_title AS p2__meta_title, p2.meta_keywords AS p2__meta_keywords, p2.meta_description AS p2__meta_description, p2.lang AS p2__lang, p2.slug AS p2__slug FROM page p INNER JOIN page_translation p2 ON p.id = p2.id WHERE (p.id = '8')

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

0.00s, "doctrine" connection

Configuration

Request

Response

User

Settings

Globals

Php

Symfony

View Layer

Template: product … listSuccess.php

Partial: isicsBreadcrumbs … _show.php

Partial: category … _roots.php

Partial: product … _list.php

Partial: product … _results.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