Query Metrics
26
Database Queries
12
Different statements
22.74 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.54 ms |
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
]
|
| 2 | 1.20 ms |
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[ck-haul]]>%' AND k0_.web_id = 1
Parameters:
[] |
| 3 | 0.89 ms |
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
]
|
| 4 | 0.65 ms |
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
]
|
| 5 | 0.79 ms |
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"
]
|
| 6 | 0.42 ms |
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 | 1.09 ms |
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 ] |
| 8 | 0.36 ms |
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 | 0.30 ms |
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-disagree-button"
]
|
| 10 | 0.27 ms |
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
]
|
| 11 | 0.35 ms |
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 ] |
| 12 | 0.32 ms |
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-disagree-button" 1 ] |
| 13 | 0.33 ms |
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-button"
]
|
| 14 | 0.30 ms |
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
]
|
| 15 | 0.33 ms |
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 ] |
| 16 | 0.26 ms |
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-button" 1 ] |
| 17 | 0.23 ms |
"START TRANSACTION"
Parameters:
[] |
| 18 | 0.75 ms |
INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "order-store" "TEST: Vracim kosik" "2026-10-20 17:11:10" 0 0 ] |
| 19 | 5.51 ms |
"COMMIT"
Parameters:
[] |
| 20 | 0.18 ms |
"START TRANSACTION"
Parameters:
[] |
| 21 | 0.30 ms |
INSERT INTO kw_eshop_logger (log_key, message, created_time, is_error, is_sent) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "order-store" "TEST: Aktualni spedice " "2026-10-20 17:11:10" 0 0 ] |
| 22 | 3.54 ms |
"COMMIT"
Parameters:
[] |
| 23 | 0.80 ms |
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
]
|
| 24 | 1.20 ms |
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:
[ 30 1 1 ] |
| 25 | 0.44 ms |
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:
[ 30 2 1 ] |
| 26 | 0.37 ms |
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:
[ 30 3 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\Blog\Blog | No errors. |
| App\Entity\Kiwi\Article\ArticleGroups | No errors. |