Query Metrics
5
Database Queries
5
Different statements
5.12 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.32 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 rp.page_id, l.code AS lang_code FROM kw_routing_paths rp LEFT JOIN kw_languages l ON l.id = rp.language_id WHERE rp.page_id IS NOT NULL AND rp.web_id = ?
Parameters:
[
1
]
|
| 3 | 1.11 ms |
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:
[
1
]
|
| 4 | 0.57 ms |
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.web_id = ?
Parameters:
[
1
]
|
| 5 | 0.92 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_.is_for_all_projects = 1 OR k1_.id = ? GROUP BY k0_.id ORDER BY k0_.id ASC
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\Security\User\Web | No errors. |
| App\Entity\Security\User\User | No errors. |
| App\Entity\Kiwi\Eshop\Eshops | No errors. |
| App\Entity\Kiwi\Page\PageTree | 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\Languages\Languages | No errors. |