POST https://cms.koenig.ipv64.net/admin/preview/update?id=019c6568-0950-703e-b6bb-5473325adc6a&locale=en&provider=pages&targetGroupId=-1&token=b914b78bdfa8c25eb7d666…

Query Metrics

10 Database Queries
7 Different statements
3.08 ms Query time
0 Invalid entities
26 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.55 ms
(17.94%)
1
SELECT p0_.webspaceKey AS webspaceKey_0, p0_.lft AS lft_1, p0_.rgt AS rgt_2, p0_.depth AS depth_3, p0_.uuid AS uuid_4, p0_.created AS created_5, p0_.changed AS changed_6, p1_.title AS title_7, p1_.id AS id_8, p1_.stage AS stage_9, p1_.locale AS locale_10, p1_.ghostLocale AS ghostLocale_11, p1_.availableLocales AS availableLocales_12, p1_.version AS version_13, p1_.shadowLocale AS shadowLocale_14, p1_.shadowLocales AS shadowLocales_15, p1_.templateKey AS templateKey_16, p1_.templateData AS templateData_17, p1_.seoData AS seoData_18, p1_.seoNoIndex AS seoNoIndex_19, p1_.seoNoFollow AS seoNoFollow_20, p1_.seoHideInSitemap AS seoHideInSitemap_21, p1_.excerptData AS excerptData_22, p1_.excerptSegment AS excerptSegment_23, p1_.authored AS authored_24, p1_.lastModified AS lastModified_25, p1_.workflowPlace AS workflowPlace_26, p1_.workflowPublished AS workflowPublished_27, p1_.linkProvider AS linkProvider_28, p1_.linkData AS linkData_29, p1_.created AS created_30, p1_.changed AS changed_31, p0_.parent_id AS parent_id_32, p0_.idUsersCreator AS idUsersCreator_33, p0_.idUsersChanger AS idUsersChanger_34, p1_.route_id AS route_id_35, p1_.pageUuid AS pageUuid_36, p1_.author_id AS author_id_37, p1_.idUsersCreator AS idUsersCreator_38, p1_.idUsersChanger AS idUsersChanger_39 FROM pa_pages p0_ LEFT JOIN pa_page_dimension_contents p1_ ON p0_.uuid = p1_.pageUuid AND (p1_.stage = ? AND p1_.version = ? AND (p1_.locale IS NULL OR p1_.locale = ?)) WHERE p0_.uuid = ?
Parameters:
[
  "draft"
  0
  "en"
  "019c6568-0950-703e-b6bb-5473325adc6a"
]
0.55 ms
(17.74%)
1
SELECT s0_.username AS username_0, s0_.password AS password_1, s0_.locale AS locale_2, s0_.salt AS salt_3, s0_.locked AS locked_4, s0_.enabled AS enabled_5, s0_.lastLogin AS lastLogin_6, s0_.confirmationKey AS confirmationKey_7, s0_.passwordResetToken AS passwordResetToken_8, s0_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_9, s0_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_10, s0_.privateKey AS privateKey_11, s0_.apiKey AS apiKey_12, s0_.email AS email_13, s0_.id AS id_14, s0_.created AS created_15, s0_.changed AS changed_16, s1_.locale AS locale_17, s1_.id AS id_18, s2_.name AS name_19, s2_.role_key AS role_key_20, s2_.securitySystem AS securitySystem_21, s2_.anonymous AS anonymous_22, s2_.id AS id_23, s2_.created AS created_24, s2_.changed AS changed_25, s3_.context AS context_26, s3_.permissions AS permissions_27, s3_.id AS id_28, s0_.idContacts AS idContacts_29, s0_.idUsersCreator AS idUsersCreator_30, s0_.idUsersChanger AS idUsersChanger_31, s1_.idUsers AS idUsers_32, s1_.idRoles AS idRoles_33, s2_.idUsersCreator AS idUsersCreator_34, s2_.idUsersChanger AS idUsersChanger_35, s3_.idRoles AS idRoles_36 FROM se_users s0_ LEFT JOIN se_user_roles s1_ ON s0_.id = s1_.idUsers LEFT JOIN se_roles s2_ ON s1_.idRoles = s2_.id LEFT JOIN se_permissions s3_ ON s2_.id = s3_.idRoles WHERE s0_.id = ?
Parameters:
[
  1
]
0.55 ms
(17.68%)
2
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS idUsersCreator_5, t0.idUsersChanger AS idUsersChanger_6 FROM ta_tags t0 INNER JOIN pa_page_dimension_content_excerpt_tags ON t0.id = pa_page_dimension_content_excerpt_tags.tag_id WHERE pa_page_dimension_content_excerpt_tags.page_dimension_content_id = ?
Parameters:
[
  13
]
0.53 ms
(17.19%)
2
SELECT t0.category_key AS category_key_1, t0.default_locale AS default_locale_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.depth AS depth_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.idCategoriesParent AS idCategoriesParent_9, t0.idUsersCreator AS idUsersCreator_10, t0.idUsersChanger AS idUsersChanger_11 FROM ca_categories t0 INNER JOIN pa_page_dimension_content_excerpt_categories ON t0.id = pa_page_dimension_content_excerpt_categories.category_id WHERE pa_page_dimension_content_excerpt_categories.page_dimension_content_id = ?
Parameters:
[
  13
]
0.43 ms
(14.08%)
2
SELECT t0.name AS name_1, t0.id AS id_2, t0.page_dimension_content_id AS page_dimension_content_id_3 FROM pa_page_dimension_content_navigation_contexts t0 WHERE t0.page_dimension_content_id = ?
Parameters:
[
  13
]
0.27 ms
(8.91%)
1
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idUsers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
  1
]
0.20 ms
(6.46%)
1
SELECT t0.webspace AS webspace_1, t0.locale AS locale_2, t0.slug AS slug_3, t0.resource_key AS resource_key_4, t0.resource_id AS resource_id_5, t0.id AS id_6, t0.parent_id AS parent_id_7 FROM ro_routes t0 WHERE t0.id = ?
Parameters:
[
  3
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Sulu\Bundle\SecurityBundle\Entity\Permission 16
Sulu\Page\Domain\Model\Page 2
Sulu\Page\Domain\Model\PageDimensionContent 2
Sulu\Bundle\SecurityBundle\Entity\User 1
Sulu\Bundle\ContactBundle\Entity\Contact 1
Sulu\Bundle\SecurityBundle\Entity\UserRole 1
Sulu\Bundle\SecurityBundle\Entity\Role 1
Sulu\Route\Domain\Model\Route 1
Sulu\Page\Domain\Model\PageDimensionContentNavigationContext 1