Query Metrics
7
Database Queries
6
Different statements
4.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.32 ms (26.63%) |
2 |
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.web_id = ?
Parameters:
[
1
]
|
|
0.86 ms (17.48%) |
1 |
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 = ? AND t0.system_folder = ? AND t0.is_templates_root = ? ORDER BY t0.sort_num ASC
Parameters:
[ 1 0 0 ] |
|
0.83 ms (16.81%) |
1 |
SELECT k0_.id AS id_0, k0_.name AS name_1, k0_.group_id AS group_id_2, k0_.tpl AS tpl_3, k0_.kiwi_tpl AS kiwi_tpl_4, k0_.group_id AS group_id_5 FROM kw_templates_templates_groups_templates k0_ INNER JOIN kw_templates_layouts_groups k1_ ON k0_.group_id = k1_.id
Parameters:
[] |
|
0.66 ms (13.36%) |
1 |
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:
[
0
]
|
|
0.66 ms (13.28%) |
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.61 ms (12.43%) |
1 |
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.user_id AS user_id_6, t0.eshop_id AS eshop_id_7 FROM kw_web 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroupsTemplates | No errors. |
| App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroups | No errors. |
| App\Entity\Security\User\Web | No errors. |
| App\Entity\Kiwi\Languages\Languages | No errors. |
| App\Entity\Kiwi\Page\PageTree | No errors. |
| App\Entity\Kiwi\ImageGallery\GalleryImages | No errors. |
| App\Entity\Kiwi\ImageGallery\ImageFolderTree | No errors. |
| App\Entity\Security\User\User | No errors. |
| App\Entity\Kiwi\Eshop\Eshops | No errors. |