Query Metrics
226
Database Queries
30
Different statements
84.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
21.24 ms (25.18%) |
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 ] |
|
19.33 ms (22.91%) |
66 |
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
]
|
|
7.80 ms (9.25%) |
2 |
"COMMIT"
Parameters:
[] |
|
5.93 ms (7.03%) |
23 |
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:
[ 76 5 ] |
|
3.17 ms (3.75%) |
9 |
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:
[
16
]
|
|
2.42 ms (2.87%) |
9 |
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
]
|
|
2.00 ms (2.37%) |
5 |
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.00 ms (2.37%) |
7 |
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:
[
23
]
|
|
1.92 ms (2.28%) |
5 |
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"
]
|
|
1.83 ms (2.17%) |
1 |
SELECT k0_.id AS id_0, k0_.web_id AS web_id_1, k0_.account_id AS account_id_2, k0_.staff_type AS staff_type_3, k0_.is_children_staff AS is_children_staff_4, k0_.is_facility_staff AS is_facility_staff_5, k0_.position_id AS position_id_6, k0_.title_before AS title_before_7, k0_.first_name AS first_name_8, k0_.last_name AS last_name_9, k0_.birth_surname AS birth_surname_10, k0_.birth_place AS birth_place_11, k0_.citizenship AS citizenship_12, k0_.marital_status AS marital_status_13, k0_.health_insurance AS health_insurance_14, k0_.nickname AS nickname_15, k0_.bio AS bio_16, k0_.image_id AS image_id_17, k0_.video_file_id AS video_file_id_18, k0_.video_url AS video_url_19, k0_.email AS email_20, k0_.phone AS phone_21, k0_.phone_emergency AS phone_emergency_22, k0_.birth_date AS birth_date_23, k0_.personal_id AS personal_id_24, k0_.id_card_number AS id_card_number_25, k0_.address_street AS address_street_26, k0_.address_city AS address_city_27, k0_.address_zip AS address_zip_28, k0_.iban AS iban_29, k0_.bank_account AS bank_account_30, k0_.highest_education AS highest_education_31, k0_.registered_unemployed AS registered_unemployed_32, k0_.court_garnishment AS court_garnishment_33, k0_.pension_type AS pension_type_34, k0_.ztp_holder AS ztp_holder_35, k0_.concurrent_employment AS concurrent_employment_36, k0_.shirt_size AS shirt_size_37, k0_.health_restrictions AS health_restrictions_38, k0_.emergency_contact_name AS emergency_contact_name_39, k0_.emergency_contact_phone AS emergency_contact_phone_40, k0_.drivers_license AS drivers_license_41, k0_.medical_qualification AS medical_qualification_42, k0_.medical_cert_valid_until AS medical_cert_valid_until_43, k0_.pedagogical_practice AS pedagogical_practice_44, k0_.criminal_record_provided_at AS criminal_record_provided_at_45, k0_.medical_exam_valid_until AS medical_exam_valid_until_46, k0_.location_id AS location_id_47, k0_.food_handler_cert_valid_until AS food_handler_cert_valid_until_48, k0_.preferred_contract AS preferred_contract_49, k0_.hourly_rate AS hourly_rate_50, k0_.availability AS availability_51, k0_.start_date AS start_date_52, k0_.end_date AS end_date_53, k0_.password_hash AS password_hash_54, k0_.verification_token AS verification_token_55, k0_.is_verified AS is_verified_56, k0_.password_reset_token AS password_reset_token_57, k0_.password_reset_expires AS password_reset_expires_58, k0_.gdpr_consent_at AS gdpr_consent_at_59, k0_.gdpr_consent_text AS gdpr_consent_text_60, k0_.notes AS notes_61, k0_.created_time AS created_time_62, k0_.updated_time AS updated_time_63, k0_.is_active AS is_active_64, k0_.show_on_web AS show_on_web_65, k0_.sort_num AS sort_num_66, k0_.account_id AS account_id_67, k0_.position_id AS position_id_68, k0_.image_id AS image_id_69, k0_.video_file_id AS video_file_id_70, k0_.location_id AS location_id_71 FROM kw_camps_instructors k0_ WHERE k0_.web_id = ? AND k0_.is_active = 1 AND k0_.show_on_web = 1 AND ((k0_.is_children_staff = 1 OR k0_.staff_type = ?)) ORDER BY k0_.sort_num ASC
Parameters:
[ 1 "CHILDREN_STAFF" ] |
|
1.56 ms (1.85%) |
3 |
SELECT t0.id AS id_1, t0.web_id AS web_id_2, t0.type_id AS type_id_3, t0.name AS name_4, t0.slug AS slug_5, t0.description_short AS description_short_6, t0.description AS description_7, t0.parent_info AS parent_info_8, t0.gallery_id AS gallery_id_9, t0.image_id AS image_id_10, t0.page_id AS page_id_11, t0.file_id AS file_id_12, t0.created_time AS created_time_13, t0.updated_time AS updated_time_14, t0.is_hidden AS is_hidden_15, t0.is_archived AS is_archived_16, t0.sort_num AS sort_num_17, t0.web_id AS web_id_18, t0.type_id AS type_id_19, t0.gallery_id AS gallery_id_20, t0.image_id AS image_id_21, t0.page_id AS page_id_22, t0.file_id AS file_id_23 FROM kw_camps t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
1.55 ms (1.83%) |
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:
[
3
]
|
|
1.54 ms (1.82%) |
5 |
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.53 ms (1.82%) |
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:
[ 8 1 1 ] |
|
1.27 ms (1.51%) |
2 |
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:
[
77
]
|
|
1.01 ms (1.19%) |
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
]
|
|
0.96 ms (1.14%) |
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.88 ms (1.05%) |
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.75 ms (0.89%) |
3 |
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:
[
23
]
|
|
0.71 ms (0.85%) |
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 12:32:17" 0 0 ] |
|
0.67 ms (0.79%) |
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.65 ms (0.78%) |
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.62 ms (0.74%) |
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.64%) |
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[o-nas]]>%' AND k0_.web_id = 1
Parameters:
[] |
|
0.53 ms (0.62%) |
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.41 ms (0.48%) |
1 |
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
]
|
|
0.39 ms (0.46%) |
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.39 ms (0.46%) |
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.38 ms (0.46%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.37 ms (0.44%) |
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.