GET http://doktormayer.cz/kiwi/navigator/level/2?q=%2Fkiwi%2Fnavigator%2Flevel%2F2

Response
200 OK
Browse referrer URL
IP
10.0.4.176
Profiled on
Token
28af4d

Query Metrics

33 Database Queries
14 Different statements
38.72 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.37 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: 
[
  2
]
View formatted query    View runnable query    Explain query
2 1.08 ms 
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: 
[]
View formatted query    View runnable query    Explain query
3 0.85 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
]
View formatted query    View runnable query    Explain query
4 0.89 ms 
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
]
View formatted query    View runnable query    Explain query
5 1.19 ms 
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: 
[]
View formatted query    View runnable query    Explain query
6 1.14 ms 
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
]
View formatted query    View runnable query    Explain query
7 1.09 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
]
View formatted query    View runnable query    Explain query
8 1.42 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.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.page_id = ? AND t0.placeholder_id = ? ORDER BY t0.sort_num ASC
Parameters: 
[
  2
  1
]
View formatted query    View runnable query    Explain query
9 1.01 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
10 1.03 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_modules_groups t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
11 1.01 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_modules_groups t0 WHERE t0.id = ?
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
12 1.10 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_modules_groups t0 WHERE t0.id = ?
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
13 1.59 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.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.page_id = ? AND t0.placeholder_id = ? ORDER BY t0.sort_num ASC
Parameters: 
[
  2
  2
]
View formatted query    View runnable query    Explain query
14 1.21 ms 
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: 
[
  5
]
View formatted query    View runnable query    Explain query
15 1.24 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 1.30 ms 
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: 
[
  6
]
View formatted query    View runnable query    Explain query
17 1.28 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 1.20 ms 
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: 
[
  7
]
View formatted query    View runnable query    Explain query
19 1.22 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 1.24 ms 
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: 
[
  13
]
View formatted query    View runnable query    Explain query
21 1.17 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
22 1.49 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.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.page_id = ? AND t0.placeholder_id = ? ORDER BY t0.sort_num ASC
Parameters: 
[
  2
  3
]
View formatted query    View runnable query    Explain query
23 1.17 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
24 1.40 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.is_active AS is_active_17, t0.sort_num AS sort_num_18, t0.page_id AS page_id_19, t0.placeholder_id AS placeholder_id_20, t0.template AS template_21, t0.article_id AS article_id_22, t0.gallery_id AS gallery_id_23, t0.map_id AS map_id_24, t0.mirror_id AS mirror_id_25, t0.language_id AS language_id_26, t0.calendar_id AS calendar_id_27 FROM kw_tree_page_modules t0 WHERE t0.id = ?
Parameters: 
[
  8
]
View formatted query    View runnable query    Explain query
25 1.21 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
]
View formatted query    View runnable query    Explain query
26 1.29 ms 
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: 
[
  4
]
View formatted query    View runnable query    Explain query
27 1.05 ms 
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_modules_groups_templates k0_ INNER JOIN kw_templates_modules_groups k1_ ON k0_.group_id = k1_.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
28 0.92 ms 
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
]
View formatted query    View runnable query    Explain query
29 1.17 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.content_prefix AS content_prefix_4, t0.content_suffix AS content_suffix_5, t0.groupper AS groupper_6, t0.type AS type_7, t0.language_id AS language_id_8, t0.web_id AS web_id_9, t0.language_id AS language_id_10, t0.web_id AS web_id_11 FROM kw_global_configs t0 WHERE t0.web_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
30 1.13 ms 
SELECT k0_.id AS id_0, k0_.sub_constant_key AS sub_constant_key_1, k0_.content AS content_2, k0_.content_prefix AS content_prefix_3, k0_.content_suffix AS content_suffix_4, k0_.global_constant_id AS global_constant_id_5, k0_.global_constant_id AS global_constant_id_6 FROM kw_global_sub_configs k0_ INNER JOIN kw_global_configs k1_ ON k0_.global_constant_id = k1_.id WHERE k0_.sub_constant_key = ? AND k1_.web_id = ?
Parameters: 
[
  "page-2"
  1
]
View formatted query    View runnable query    Explain query
31 0.95 ms 
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
]
View formatted query    View runnable query    Explain query
32 1.32 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.parent_row_id = ? AND t0.web_id = ? AND t0.system_folder = ? AND t0.is_templates_root = ? ORDER BY t0.sort_num ASC
Parameters: 
[
  2
  1
  0
  0
]
View formatted query    View runnable query    Explain query
33 1.00 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.user_id AS user_id_6, t0.eshop_id AS eshop_id_7 FROM kw_web t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query

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\Kiwi\LayoutTemplates\LayoutTemplatesGroupsTemplates No errors.
App\Entity\Kiwi\ImageGallery\GalleryImages No errors.
App\Entity\Kiwi\ImageGallery\ImageFolderTree No errors.
App\Entity\Security\User\Web No errors.
App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroups No errors.
App\Entity\Kiwi\Languages\Languages 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\ModuleTemplates\ModuleTemplatesGroups No errors.
App\Entity\Kiwi\Souborovnik\SouborovnikSoubory No errors.
App\Entity\Kiwi\GlobalConfig\GlobalConstants No errors.
App\Entity\Kiwi\GlobalConfig\GlobalSubConstants No errors.
App\Entity\Security\User\User No errors.
App\Entity\Kiwi\Eshop\Eshops No errors.