GET https://endaladom2.dot11.cz/cz/jake-svetlo-vybrat

Query Metrics

609 Database Queries
23 Different statements
196.54 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
38.51 ms
(19.59%)
82
SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = ?
Parameters:
[
  "cookie-agree"
]
38.23 ms
(19.45%)
120
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id = ? AND t0.web_id = ? ORDER BY t0.sort_num ASC
Parameters:
[
  1
  1
]
30.02 ms
(15.27%)
123
SELECT k0_.id AS id_0, k0_.project_name AS project_name_1, k0_.domains AS domains_2, k0_.user_id AS user_id_3, k0_.eshop_id AS eshop_id_4, k0_.user_id AS user_id_5, k0_.eshop_id AS eshop_id_6 FROM kw_web k0_ WHERE k0_.domains LIKE ? LIMIT 1
Parameters:
[
  "%endaladom2.dot11.cz%"
]
26.23 ms
(13.35%)
82
SELECT t0.id AS id_1, t0.name AS name_2, t0.phrase AS phrase_3, t0.language_id AS language_id_4, t0.language_id AS language_id_5 FROM kw_phrases t0 WHERE t0.name = ? AND t0.language_id = ? LIMIT 1
Parameters:
[
  "cookie-agree"
  1
]
21.95 ms
(11.17%)
95
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_languages t0 WHERE t0.code = ? AND t0.web_id = ? LIMIT 1
Parameters:
[
  "cz"
  1
]
14.17 ms
(7.21%)
36
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_alt_1 AS name_alt_1_3, t0.name_alt_2 AS name_alt_2_4, t0.name_letter AS name_letter_5, t0.code AS code_6, t0.created_time AS created_time_7, t0.updated_time AS updated_time_8, t0.description_fast AS description_fast_9, t0.description AS description_10, t0.action_text AS action_text_11, t0.quantity AS quantity_12, t0.quantity_in_package AS quantity_in_package_13, t0.weight_g AS weight_g_14, t0.price_purchase AS price_purchase_15, t0.price_sale AS price_sale_16, t0.price_action AS price_action_17, t0.price_without_vat AS price_without_vat_18, t0.price_package_with_vat AS price_package_with_vat_19, t0.stock_show AS stock_show_20, t0.stock_alt AS stock_alt_21, t0.vat_id AS vat_id_22, t0.is_action AS is_action_23, t0.is_new AS is_new_24, t0.is_tip AS is_tip_25, t0.currency_id AS currency_id_26, t0.unit_id AS unit_id_27, t0.gallery_id AS gallery_id_28, t0.producer_id AS producer_id_29, t0.eshop_id AS eshop_id_30, t0.holder_id AS holder_id_31, t0.is_deleted AS is_deleted_32, t0.is_hidden AS is_hidden_33, t0.is_holder AS is_holder_34, t0.sort_num AS sort_num_35, t0.vat_id AS vat_id_36, t0.currency_id AS currency_id_37, t0.unit_id AS unit_id_38, t0.gallery_id AS gallery_id_39, t0.producer_id AS producer_id_40, t0.eshop_id AS eshop_id_41, t0.holder_id AS holder_id_42 FROM kw_eshop_product t0 WHERE t0.id = ?
Parameters:
[
  "33"
]
7.11 ms
(3.62%)
2
"COMMIT"
Parameters:
[]
3.02 ms
(1.54%)
13
SELECT t0.id AS id_1, t0.sub_constant_key AS sub_constant_key_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.global_constant_id AS global_constant_id_6, t0.global_constant_id AS global_constant_id_7 FROM kw_global_sub_configs t0 WHERE t0.global_constant_id = ? AND t0.sub_constant_key = ? LIMIT 1
Parameters:
[
  1
  "page-99"
]
3.00 ms
(1.53%)
13
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.groupper AS groupper_6, t0.type AS type_7, t0.language_id AS language_id_8, t0.web_id AS web_id_9, t0.language_id AS language_id_10, t0.web_id AS web_id_11 FROM kw_global_configs t0 WHERE t0.name = ? AND t0.language_id = ? AND t0.web_id = ? LIMIT 1
Parameters:
[
  "title"
  1
  1
]
2.47 ms
(1.26%)
8
SELECT t0.id AS id_1, t0.variable_id AS variable_id_2, t0.module_id AS module_id_3, t0.content_plain AS content_plain_4, t0.variable_id AS variable_id_5, t0.module_id AS module_id_6 FROM kw_templates_modules_groups_templates_variables_content t0 WHERE t0.module_id = ? AND t0.variable_id = ? LIMIT 1
Parameters:
[
  607
  47
]
2.22 ms
(1.13%)
5
SELECT t0.id AS id_1, t0.namespace AS namespace_2, t0.page_id AS page_id_3, t0.placeholder_id AS placeholder_id_4, t0.template_id AS template_id_5, t0.template_dso_service AS template_dso_service_6, t0.template_dso_method AS template_dso_method_7, t0.article_id AS article_id_8, t0.gallery_id AS gallery_id_9, t0.database_namespace AS database_namespace_10, t0.database_query AS database_query_11, t0.map_id AS map_id_12, t0.mirror_id AS mirror_id_13, t0.language_id AS language_id_14, t0.prevent_changes AS prevent_changes_15, t0.calendar_id AS calendar_id_16, t0.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.page_id = ? AND t0.placeholder_id = ? AND t0.is_active = ? ORDER BY t0.sort_num ASC
Parameters:
[
  99
  1
  1
]
1.73 ms
(0.88%)
7
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_id AS group_id_3, t0.tpl AS tpl_4, t0.kiwi_tpl AS kiwi_tpl_5, t0.group_id AS group_id_6 FROM kw_templates_modules_groups_templates t0 WHERE t0.id = ?
Parameters:
[
  51
]
1.55 ms
(0.79%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.var_name AS var_name_3, t0.is_multilang AS is_multilang_4, t0.type AS type_5, t0.template_id AS template_id_6, t0.template_id AS template_id_7 FROM kw_templates_modules_groups_templates_variables t0 WHERE t0.template_id = ?
Parameters:
[
  51
]
0.99 ms
(0.50%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.primary_lights AS primary_lights_4, t0.secondary_lights AS secondary_lights_5, t0.poradi AS poradi_6, t0.active AS active_7 FROM light_choose t0 WHERE t0.active = ? ORDER BY t0.poradi ASC
Parameters:
[
  1
]
0.98 ms
(0.50%)
3
SELECT t0.id AS id_1, t0.namespace AS namespace_2, t0.page_id AS page_id_3, t0.placeholder_id AS placeholder_id_4, t0.template_id AS template_id_5, t0.template_dso_service AS template_dso_service_6, t0.template_dso_method AS template_dso_method_7, t0.article_id AS article_id_8, t0.gallery_id AS gallery_id_9, t0.database_namespace AS database_namespace_10, t0.database_query AS database_query_11, t0.map_id AS map_id_12, t0.mirror_id AS mirror_id_13, t0.language_id AS language_id_14, t0.prevent_changes AS prevent_changes_15, t0.calendar_id AS calendar_id_16, t0.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.id = ?
Parameters:
[
  607
]
0.98 ms
(0.50%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_templates_modules_groups t0 WHERE t0.id = ?
Parameters:
[
  4
]
0.83 ms
(0.42%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.page_name AS page_name_3, t0.parent_row_id AS parent_row_id_4, t0.prevent_changes AS prevent_changes_5, t0.sort_num AS sort_num_6, t0.layout_id AS layout_id_7, t0.in_menu_display AS in_menu_display_8, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.redirect_id AS redirect_id_11, t0.redirect_suffix AS redirect_suffix_12, t0.is_templates_root AS is_templates_root_13, t0.system_folder AS system_folder_14, t0.opt_one AS opt_one_15, t0.opt_two AS opt_two_16, t0.opt_three AS opt_three_17, t0.web_id AS web_id_18, t0.parent_row_id AS parent_row_id_19, t0.layout_id AS layout_id_20, t0.image_id AS image_id_21, t0.gallery_id AS gallery_id_22, t0.redirect_id AS redirect_id_23, t0.web_id AS web_id_24 FROM kw_tree_page t0 WHERE t0.parent_row_id IS NULL AND t0.web_id = ? ORDER BY t0.sort_num ASC
Parameters:
[
  1
]
0.61 ms
(0.31%)
1
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.page_name AS page_name_2, k0_.parent_row_id AS parent_row_id_3, k0_.prevent_changes AS prevent_changes_4, k0_.sort_num AS sort_num_5, k0_.layout_id AS layout_id_6, k0_.in_menu_display AS in_menu_display_7, k0_.image_id AS image_id_8, k0_.gallery_id AS gallery_id_9, k0_.redirect_id AS redirect_id_10, k0_.redirect_suffix AS redirect_suffix_11, k0_.is_templates_root AS is_templates_root_12, k0_.system_folder AS system_folder_13, k0_.opt_one AS opt_one_14, k0_.opt_two AS opt_two_15, k0_.opt_three AS opt_three_16, k0_.web_id AS web_id_17, k0_.parent_row_id AS parent_row_id_18, k0_.layout_id AS layout_id_19, k0_.image_id AS image_id_20, k0_.gallery_id AS gallery_id_21, k0_.redirect_id AS redirect_id_22, k0_.web_id AS web_id_23 FROM kw_tree_page k0_ WHERE k0_.page_name LIKE '%<![CDATA[jake-svetlo-vybrat]]>%' AND k0_.web_id = 1
Parameters:
[]
0.52 ms
(0.26%)
2
INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "order-store"
  "TEST: Vracim kosik"
  "2025-07-12 21:10:58"
  0
  0
]
0.39 ms
(0.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.group_id AS group_id_3, t0.tpl AS tpl_4, t0.kiwi_tpl AS kiwi_tpl_5, t0.group_id AS group_id_6 FROM kw_templates_templates_groups_templates t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.39 ms
(0.20%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.template_id AS template_id_3, t0.template_id AS template_id_4 FROM kw_templates_templates_groups_templates_placeholders t0 WHERE t0.template_id = ?
Parameters:
[
  1
]
0.37 ms
(0.19%)
2
"START TRANSACTION"
Parameters:
[]
0.26 ms
(0.13%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.added AS added_3, t0.web_id AS web_id_4, t0.web_id AS web_id_5 FROM kw_templates_layouts_groups t0 WHERE t0.id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Kiwi\Page\PageTree No errors.
App\Entity\Security\User\Web No errors.
App\Entity\Security\User\User No errors.
App\Entity\Kiwi\Eshop\Eshops No errors.
App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroupsTemplates No errors.
App\Entity\Kiwi\ImageGallery\GalleryImages No errors.
App\Entity\Kiwi\ImageGallery\ImageFolderTree No errors.
App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroups No errors.
App\Entity\Kiwi\Phrases\Phrases No errors.
App\Entity\Kiwi\Languages\Languages No errors.
App\Entity\Kiwi\Eshop\Logger No errors.
App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroupsTemplatesPlaceholders No errors.
App\Entity\Kiwi\Page\PageTreeModules No errors.
App\Entity\Kiwi\ModuleTemplates\ModuleTemplatesGroupsTemplates No errors.
App\Entity\Kiwi\Article\Article No errors.
App\Entity\Kiwi\GoogleMap\GoogleMaps No errors.
App\Entity\Kiwi\Calendar\Calendars No errors.
App\Entity\Kiwi\ModuleTemplates\ModuleTemplatesGroupsTemplatesVariables No errors.
App\Entity\Kiwi\ModuleTemplates\ModuleTemplatesGroupsTemplatesVariablesContent No errors.
App\Entity\Kiwi\ModuleTemplates\ModuleTemplatesGroups No errors.
App\Custom\Endala\Entity\LightChoose No errors.
App\Entity\Kiwi\Eshop\Product No errors.
App\Entity\Kiwi\Eshop\Vat No errors.
App\Entity\Kiwi\Eshop\Currency No errors.
App\Entity\Kiwi\Eshop\Unit No errors.
App\Entity\Kiwi\Eshop\Producers No errors.
App\Entity\Kiwi\GlobalConfig\GlobalConstants No errors.
App\Entity\Kiwi\GlobalConfig\GlobalSubConstants No errors.