Query Metrics
16
Database Queries
4
Different statements
36.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.16 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:
[
10
]
|
| 2 | 0.64 ms |
"START TRANSACTION"
Parameters:
[] |
| 3 | 0.89 ms |
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters:
[ 1 10 ] |
| 4 | 11.93 ms |
"COMMIT"
Parameters:
[] |
| 5 | 1.22 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:
[
11
]
|
| 6 | 0.72 ms |
"START TRANSACTION"
Parameters:
[] |
| 7 | 1.02 ms |
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters:
[ 2 11 ] |
| 8 | 4.13 ms |
"COMMIT"
Parameters:
[] |
| 9 | 1.21 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:
[
12
]
|
| 10 | 0.77 ms |
"START TRANSACTION"
Parameters:
[] |
| 11 | 0.97 ms |
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters:
[ 3 12 ] |
| 12 | 4.11 ms |
"COMMIT"
Parameters:
[] |
| 13 | 1.22 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:
[
33
]
|
| 14 | 0.83 ms |
"START TRANSACTION"
Parameters:
[] |
| 15 | 1.08 ms |
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters:
[ 4 33 ] |
| 16 | 4.15 ms |
"COMMIT"
Parameters:
[] |
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\PageTreeModules | No errors. |
| App\Entity\Kiwi\Page\PageTree | No errors. |
| App\Entity\Kiwi\LayoutTemplates\LayoutTemplatesGroupsTemplatesPlaceholders | No errors. |
| App\Entity\Kiwi\ModuleTemplates\ModuleTemplatesGroupsTemplates | No errors. |
| App\Entity\Kiwi\Article\Article | No errors. |
| App\Entity\Kiwi\ImageGallery\ImageFolderTree | No errors. |
| App\Entity\Kiwi\GoogleMap\GoogleMaps | No errors. |
| App\Entity\Kiwi\Languages\Languages | No errors. |
| App\Entity\Kiwi\Calendar\Calendars | No errors. |