Query Metrics
178
Database Queries
27
Different statements
216.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
34.25 ms (15.83%) |
35 |
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 ] |
|
24.30 ms (11.23%) |
21 |
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:
[
"%farline.dot11.cz%"
]
|
|
23.78 ms (10.99%) |
22 |
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"
]
|
|
22.56 ms (10.43%) |
18 |
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:
[ 11 1 ] |
|
16.77 ms (7.75%) |
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
]
|
|
13.93 ms (6.44%) |
1 |
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:
[ 13 1 1 ] |
|
13.15 ms (6.08%) |
22 |
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 ] |
|
9.74 ms (4.50%) |
1 |
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.name_alt_1 AS name_alt_1_2, k0_.name_alt_2 AS name_alt_2_3, k0_.name_letter AS name_letter_4, k0_.code AS code_5, k0_.created_time AS created_time_6, k0_.updated_time AS updated_time_7, k0_.description_fast AS description_fast_8, k0_.description AS description_9, k0_.action_text AS action_text_10, k0_.quantity AS quantity_11, k0_.quantity_in_package AS quantity_in_package_12, k0_.weight_g AS weight_g_13, k0_.price_purchase AS price_purchase_14, k0_.price_sale AS price_sale_15, k0_.price_action AS price_action_16, k0_.price_without_vat AS price_without_vat_17, k0_.price_package_with_vat AS price_package_with_vat_18, k0_.stock_show AS stock_show_19, k0_.stock_alt AS stock_alt_20, k0_.vat_id AS vat_id_21, k0_.is_action AS is_action_22, k0_.is_new AS is_new_23, k0_.is_tip AS is_tip_24, k0_.currency_id AS currency_id_25, k0_.unit_id AS unit_id_26, k0_.gallery_id AS gallery_id_27, k0_.producer_id AS producer_id_28, k0_.eshop_id AS eshop_id_29, k0_.holder_id AS holder_id_30, k0_.is_deleted AS is_deleted_31, k0_.is_hidden AS is_hidden_32, k0_.is_holder AS is_holder_33, k0_.sort_num AS sort_num_34, k0_.vat_id AS vat_id_35, k0_.currency_id AS currency_id_36, k0_.unit_id AS unit_id_37, k0_.gallery_id AS gallery_id_38, k0_.producer_id AS producer_id_39, k0_.eshop_id AS eshop_id_40, k0_.holder_id AS holder_id_41 FROM kw_eshop_co_product_category k1_ LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id) LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id) WHERE k0_.is_deleted = 0 AND k0_.eshop_id = 1 AND k0_.stock_alt >= 0 AND k0_.is_action = 1 GROUP BY k0_.id ORDER BY k0_.id DESC LIMIT 21
Parameters:
[] |
|
8.88 ms (4.11%) |
1 |
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.name_alt_1 AS name_alt_1_2, k0_.name_alt_2 AS name_alt_2_3, k0_.name_letter AS name_letter_4, k0_.code AS code_5, k0_.created_time AS created_time_6, k0_.updated_time AS updated_time_7, k0_.description_fast AS description_fast_8, k0_.description AS description_9, k0_.action_text AS action_text_10, k0_.quantity AS quantity_11, k0_.quantity_in_package AS quantity_in_package_12, k0_.weight_g AS weight_g_13, k0_.price_purchase AS price_purchase_14, k0_.price_sale AS price_sale_15, k0_.price_action AS price_action_16, k0_.price_without_vat AS price_without_vat_17, k0_.price_package_with_vat AS price_package_with_vat_18, k0_.stock_show AS stock_show_19, k0_.stock_alt AS stock_alt_20, k0_.vat_id AS vat_id_21, k0_.is_action AS is_action_22, k0_.is_new AS is_new_23, k0_.is_tip AS is_tip_24, k0_.currency_id AS currency_id_25, k0_.unit_id AS unit_id_26, k0_.gallery_id AS gallery_id_27, k0_.producer_id AS producer_id_28, k0_.eshop_id AS eshop_id_29, k0_.holder_id AS holder_id_30, k0_.is_deleted AS is_deleted_31, k0_.is_hidden AS is_hidden_32, k0_.is_holder AS is_holder_33, k0_.sort_num AS sort_num_34, k0_.vat_id AS vat_id_35, k0_.currency_id AS currency_id_36, k0_.unit_id AS unit_id_37, k0_.gallery_id AS gallery_id_38, k0_.producer_id AS producer_id_39, k0_.eshop_id AS eshop_id_40, k0_.holder_id AS holder_id_41 FROM kw_eshop_co_product_category k1_ LEFT JOIN kw_eshop_product k0_ ON (k0_.id = k1_.product_id) LEFT JOIN kw_eshop_co_product_params k2_ ON (k2_.product_id = k0_.id) WHERE k0_.is_deleted = 0 AND k0_.eshop_id = 1 AND k0_.stock_alt >= 0 AND k0_.is_action = 1 GROUP BY k0_.id ORDER BY k0_.id DESC
Parameters:
[] |
|
8.77 ms (4.05%) |
2 |
"COMMIT"
Parameters:
[] |
|
7.48 ms (3.46%) |
4 |
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:
[
1
]
|
|
7.44 ms (3.44%) |
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 ] |
|
7.03 ms (3.25%) |
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-13" ] |
|
3.11 ms (1.44%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.lat AS lat_3, t0.lng AS lng_4, t0.zoom AS zoom_5, t0.system_map AS system_map_6, t0.web_id AS web_id_7, t0.web_id AS web_id_8 FROM kw_google_maps t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2.24 ms (1.04%) |
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:
[
1
]
|
|
2.24 ms (1.04%) |
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:
[
1
]
|
|
1.71 ms (0.79%) |
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
]
|
|
1.42 ms (0.65%) |
2 |
SELECT t0.id AS id_1, t0.map_id AS map_id_2, t0.name AS name_3, t0.description AS description_4, t0.lat AS lat_5, t0.lng AS lng_6, t0.original_image AS original_image_7, t0.ico_id AS ico_id_8, t0.map_id AS map_id_9, t0.ico_id AS ico_id_10 FROM kw_google_maps_points t0 WHERE t0.map_id = ?
Parameters:
[
1
]
|
|
1.36 ms (0.63%) |
2 |
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:
[
14
]
|
|
1.00 ms (0.46%) |
2 |
INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "order-store" "TEST: Vracim kosik" "2026-01-20 12:43:01" 0 0 ] |
|
0.89 ms (0.41%) |
1 |
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:
[ 81 9 ] |
|
0.84 ms (0.39%) |
1 |
SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.file_id AS file_id_3, t0.sort_num AS sort_num_4, t0.article_id AS article_id_5, t0.file_id AS file_id_6 FROM kw_articles_files t0 WHERE t0.article_id = ? ORDER BY t0.id ASC
Parameters:
[
12
]
|
|
0.82 ms (0.38%) |
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[akcni-nabidky]]>%' AND k0_.web_id = 1
Parameters:
[] |
|
0.72 ms (0.33%) |
1 |
SELECT t0.id AS id_1, t0.created_time AS created_time_2, t0.updated_time AS updated_time_3, t0.name AS name_4, t0.content AS content_5, t0.image_id AS image_id_6, t0.gallery_id AS gallery_id_7, t0.page_id AS page_id_8, t0.map_id AS map_id_9, t0.file_id AS file_id_10, t0.image_id AS image_id_11, t0.gallery_id AS gallery_id_12, t0.page_id AS page_id_13, t0.map_id AS map_id_14, t0.file_id AS file_id_15 FROM kw_articles t0 WHERE t0.id = ?
Parameters:
[
12
]
|
|
0.65 ms (0.30%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.63 ms (0.29%) |
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
]
|
|
0.59 ms (0.27%) |
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
]
|
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.