Query Metrics
276
Database Queries
35
Different statements
124.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
22.42 ms (18.02%) |
11 |
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:
[
202
]
|
|
20.17 ms (16.22%) |
72 |
SELECT t0.id AS id_1, t0.project_name AS project_name_2, t0.domains AS domains_3, t0.user_id AS user_id_4, t0.eshop_id AS eshop_id_5, t0.has_camps AS has_camps_6, t0.has_facilities AS has_facilities_7, t0.canonical_domain AS canonical_domain_8, t0.robots_txt AS robots_txt_9, t0.is_active AS is_active_10, t0.sitemap_cached_at AS sitemap_cached_at_11, t0.user_id AS user_id_12, t0.eshop_id AS eshop_id_13 FROM kw_web t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
|
19.39 ms (15.58%) |
56 |
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:
[ 3 1 ] |
|
8.21 ms (6.60%) |
2 |
"COMMIT"
Parameters:
[] |
|
7.72 ms (6.21%) |
22 |
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:
[ 256 5 ] |
|
4.11 ms (3.31%) |
13 |
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.module_type AS module_type_6, t0.group_id AS group_id_7 FROM kw_templates_modules_groups_templates t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
3.69 ms (2.97%) |
10 |
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:
[
3
]
|
|
3.56 ms (2.86%) |
11 |
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.is_for_all_projects AS is_for_all_projects_3 FROM kw_languages k0_ LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id WHERE k0_.is_for_all_projects = 1 OR k1_.id = ? GROUP BY k0_.id ORDER BY k0_.id ASC
Parameters:
[
1
]
|
|
2.81 ms (2.26%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.name_alt AS name_alt_3, t0.folder_id AS folder_id_4, t0.prevent_changes AS prevent_changes_5, t0.width AS width_6, t0.height AS height_7, t0.extension AS extension_8, t0.alt_name AS alt_name_9, t0.alt_desc_1 AS alt_desc_1_10, t0.alt_desc_2 AS alt_desc_2_11, t0.parent_id AS parent_id_12, t0.type AS type_13, t0.sort_num AS sort_num_14, t0.folder_id AS folder_id_15, t0.parent_id AS parent_id_16 FROM kw_tree_image_gallery_images t0 WHERE t0.id = ?
Parameters:
[
144
]
|
|
2.81 ms (2.26%) |
6 |
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.code AS code_2, k0_.is_for_all_projects AS is_for_all_projects_3 FROM kw_languages k0_ LEFT JOIN kw_language_webs k2_ ON k0_.id = k2_.language_id LEFT JOIN kw_web k1_ ON k1_.id = k2_.web_id WHERE k0_.code = ? AND (k0_.is_for_all_projects = 1 OR k1_.id = ?) LIMIT 1
Parameters:
[ "cz" 1 ] |
|
2.64 ms (2.12%) |
5 |
SELECT k0_.id AS id_0, k0_.camp_id AS camp_id_1, k0_.location_id AS location_id_2, k0_.theme AS theme_3, k0_.slug AS slug_4, k0_.code AS code_5, k0_.date_from AS date_from_6, k0_.date_to AS date_to_7, k0_.capacity_total AS capacity_total_8, k0_.price_base AS price_base_9, k0_.deposit_amount AS deposit_amount_10, k0_.deposit_due AS deposit_due_11, k0_.final_payment_due AS final_payment_due_12, k0_.program AS program_13, k0_.gallery_id AS gallery_id_14, k0_.external_gallery_url AS external_gallery_url_15, k0_.external_gallery_password AS external_gallery_password_16, k0_.created_time AS created_time_17, k0_.updated_time AS updated_time_18, k0_.is_hidden AS is_hidden_19, k0_.is_cancelled AS is_cancelled_20, k0_.sort_num AS sort_num_21, k0_.camp_id AS camp_id_22, k0_.location_id AS location_id_23, k0_.gallery_id AS gallery_id_24 FROM kw_camps_terms k0_ WHERE (k0_.camp_id = ? AND k0_.is_hidden = 0 AND k0_.is_cancelled = 0) AND k0_.date_from >= ? ORDER BY k0_.date_from ASC
Parameters:
[ 7 "2026-10-20 11:57:25" ] |
|
2.38 ms (1.91%) |
6 |
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"
]
|
|
2.30 ms (1.85%) |
5 |
SELECT t0.id AS id_1, t0.camp_id AS camp_id_2, t0.camp_type_id AS camp_type_id_3, t0.term_id AS term_id_4, t0.customer_id AS customer_id_5, t0.enrollment_item_id AS enrollment_item_id_6, t0.author_name AS author_name_7, t0.rating AS rating_8, t0.comment AS comment_9, t0.lang AS lang_10, t0.is_approved AS is_approved_11, t0.submitted_at AS submitted_at_12, t0.camp_id AS camp_id_13, t0.camp_type_id AS camp_type_id_14, t0.term_id AS term_id_15, t0.customer_id AS customer_id_16, t0.enrollment_item_id AS enrollment_item_id_17 FROM kw_camps_reviews t0 WHERE t0.camp_type_id = ? AND t0.is_approved = ? ORDER BY t0.submitted_at DESC LIMIT 10
Parameters:
[ 1 1 ] |
|
2.16 ms (1.73%) |
7 |
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:
[
202
]
|
|
2.13 ms (1.71%) |
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.blog_id AS blog_id_17, t0.article_group_id AS article_group_id_18, t0.is_active AS is_active_19, t0.sort_num AS sort_num_20, t0.page_id AS page_id_21, t0.placeholder_id AS placeholder_id_22, t0.template AS template_23, t0.article_id AS article_id_24, t0.gallery_id AS gallery_id_25, t0.map_id AS map_id_26, t0.mirror_id AS mirror_id_27, t0.language_id AS language_id_28, t0.calendar_id AS calendar_id_29, t0.blog_id AS blog_id_30, t0.article_group_id AS article_group_id_31 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:
[ 3 1 1 ] |
|
1.79 ms (1.44%) |
6 |
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 ] |
|
1.75 ms (1.40%) |
5 |
SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.lang AS lang_4, t0.slug AS slug_5 FROM kw_camps_slug_index t0 WHERE t0.entity_type = ? AND t0.lang = ? AND t0.slug = ? LIMIT 1
Parameters:
[ "camp" "cz" "kouzelne-leto" ] |
|
1.62 ms (1.30%) |
6 |
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.04 ms (0.84%) |
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[tabory]]>%' AND k0_.web_id = 1
Parameters:
[] |
|
1.00 ms (0.80%) |
1 |
SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.type_id AS type_id_2, k0_.name AS name_3, k0_.slug AS slug_4, k0_.description_short AS description_short_5, k0_.description AS description_6, k0_.parent_info AS parent_info_7, k0_.gallery_id AS gallery_id_8, k0_.image_id AS image_id_9, k0_.page_id AS page_id_10, k0_.file_id AS file_id_11, k0_.created_time AS created_time_12, k0_.updated_time AS updated_time_13, k0_.is_hidden AS is_hidden_14, k0_.is_archived AS is_archived_15, k0_.sort_num AS sort_num_16, k0_.web_id AS web_id_17, k0_.type_id AS type_id_18, k0_.gallery_id AS gallery_id_19, k0_.image_id AS image_id_20, k0_.page_id AS page_id_21, k0_.file_id AS file_id_22 FROM kw_camps k0_ WHERE k0_.web_id = ? AND k0_.is_hidden = 0 AND k0_.is_archived = 0 ORDER BY k0_.sort_num ASC
Parameters:
[
1
]
|
|
0.98 ms (0.79%) |
1 |
SELECT t0.id AS id_1, t0.web_id AS web_id_2, t0.name AS name_3, t0.code AS code_4, t0.description AS description_5, t0.image_id AS image_id_6, t0.gallery_id AS gallery_id_7, t0.page_id AS page_id_8, t0.file_id AS file_id_9, t0.icon AS icon_10, t0.is_hidden AS is_hidden_11, t0.sort_num AS sort_num_12, t0.web_id AS web_id_13, t0.image_id AS image_id_14, t0.gallery_id AS gallery_id_15, t0.page_id AS page_id_16, t0.file_id AS file_id_17 FROM kw_camps_types t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.95 ms (0.76%) |
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.92 ms (0.74%) |
2 |
INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "order-store" "TEST: Vracim kosik" "2026-10-20 11:57:24" 0 0 ] |
|
0.78 ms (0.62%) |
1 |
SELECT age_category_id, COUNT(*) AS cnt FROM kw_camps_enrollment_items WHERE term_id = ? AND is_cancelled = 0 GROUP BY age_category_id
Parameters:
[
7
]
|
|
0.77 ms (0.62%) |
2 |
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.blog_id AS blog_id_17, t0.article_group_id AS article_group_id_18, t0.is_active AS is_active_19, t0.sort_num AS sort_num_20, t0.page_id AS page_id_21, t0.placeholder_id AS placeholder_id_22, t0.template AS template_23, t0.article_id AS article_id_24, t0.gallery_id AS gallery_id_25, t0.map_id AS map_id_26, t0.mirror_id AS mirror_id_27, t0.language_id AS language_id_28, t0.calendar_id AS calendar_id_29, t0.blog_id AS blog_id_30, t0.article_group_id AS article_group_id_31 FROM kw_tree_page_modules t0 WHERE t0.id = ?
Parameters:
[
44
]
|
|
0.75 ms (0.60%) |
1 |
SELECT t0.id AS id_1, t0.term_id AS term_id_2, t0.age_category_id AS age_category_id_3, t0.capacity AS capacity_4, t0.term_id AS term_id_5, t0.age_category_id AS age_category_id_6 FROM kw_camps_term_capacities t0 WHERE t0.term_id = ?
Parameters:
[
7
]
|
|
0.75 ms (0.60%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image_id AS image_id_3, t0.image_mobile_id AS image_mobile_id_4, t0.video_id AS video_id_5, t0.article_id AS article_id_6, t0.module_id AS module_id_7, t0.style AS style_8, t0.sort_num AS sort_num_9, t0.image_id AS image_id_10, t0.image_mobile_id AS image_mobile_id_11, t0.video_id AS video_id_12, t0.article_id AS article_id_13, t0.module_id AS module_id_14 FROM kw_carousel_images t0 WHERE t0.module_id = ? ORDER BY t0.sort_num ASC
Parameters:
[
261
]
|
|
0.72 ms (0.58%) |
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.71 ms (0.57%) |
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.69 ms (0.56%) |
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.63 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.article_name AS article_name_2, t0.article_id AS article_id_3, t0.group_id AS group_id_4, t0.sort_num AS sort_num_5, t0.article_id AS article_id_6, t0.group_id AS group_id_7 FROM kw_articles_groups_articles t0 WHERE t0.group_id = ? ORDER BY t0.sort_num DESC
Parameters:
[
14
]
|
|
0.62 ms (0.50%) |
1 |
SELECT t0.id AS id_1, t0.version_num AS version_num_2, t0.last_update AS last_update_3 FROM kw_images_cache_version t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.54 ms (0.43%) |
1 |
SELECT k0_.id AS id_0, k0_.camp_id AS camp_id_1, k0_.camp_type_id AS camp_type_id_2, k0_.term_id AS term_id_3, k0_.customer_id AS customer_id_4, k0_.enrollment_item_id AS enrollment_item_id_5, k0_.author_name AS author_name_6, k0_.rating AS rating_7, k0_.comment AS comment_8, k0_.lang AS lang_9, k0_.is_approved AS is_approved_10, k0_.submitted_at AS submitted_at_11, k0_.camp_id AS camp_id_12, k0_.camp_type_id AS camp_type_id_13, k0_.term_id AS term_id_14, k0_.customer_id AS customer_id_15, k0_.enrollment_item_id AS enrollment_item_id_16 FROM kw_camps_reviews k0_ WHERE k0_.is_approved = 1 ORDER BY k0_.submitted_at DESC LIMIT 10
Parameters:
[] |
|
0.48 ms (0.39%) |
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.id = ?
Parameters:
[
16
]
|
|
0.43 ms (0.34%) |
2 |
"START TRANSACTION"
Parameters:
[] |
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.