POST http://doktormayer.cz/kiwi/sorting-update?q=%2Fkiwi%2Fsorting-update

Response
200 OK
Browse referrer URL
IP
10.0.4.176
Profiled on
Token
6ab043

Query Metrics

8 Database Queries
4 Different statements
25.43 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.12 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: 
[
  7
]
View formatted query    View runnable query    Explain query
2 0.93 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
3 1.21 ms 
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters: 
[
  1
  7
]
View formatted query    View runnable query    Explain query
4 14.10 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 1.66 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
6 0.93 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 1.24 ms 
UPDATE kw_tree_page_modules SET sort_num = ? WHERE id = ?
Parameters: 
[
  2
  8
]
View formatted query    View runnable query    Explain query
8 4.25 ms 
"COMMIT"
Parameters: 
[]
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\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.