GET https://cms.koenig.ipv64.net/admin/api/users/1

Query Metrics

6 Database Queries
6 Different statements
2.01 ms Query time
0 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.52 ms
(26.06%)
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.36 ms
(18.06%)
1
SELECT t0.firstName AS firstName_1, t0.middleName AS middleName_2, t0.lastName AS lastName_3, t0.birthday AS birthday_4, t0.salutation AS salutation_5, t0.formOfAddress AS formOfAddress_6, t0.newsletter AS newsletter_7, t0.gender AS gender_8, t0.note AS note_9, t0.mainEmail AS mainEmail_10, t0.mainPhone AS mainPhone_11, t0.mainFax AS mainFax_12, t0.mainUrl AS mainUrl_13, t0.id AS id_14, t0.created AS created_15, t0.changed AS changed_16, t0.idTitles AS idTitles_17, t0.avatar AS avatar_18, t0.idUsersCreator AS idUsersCreator_19, t0.idUsersChanger AS idUsersChanger_20 FROM co_contacts t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.36 ms
(17.73%)
1
SELECT t0.settingKey AS settingKey_1, t0.value AS value_2, t0.id AS id_3, t0.roleId AS roleId_4 FROM se_role_settings t0 WHERE t0.roleId = ?
Parameters:
[
  1
]
0.31 ms
(15.38%)
1
SELECT t0.email AS email_1, t0.id AS id_2, t0.idEmailTypes AS idEmailTypes_3 FROM co_emails t0 INNER JOIN co_contact_emails ON t0.id = co_contact_emails.idEmails WHERE co_contact_emails.idContacts = ?
Parameters:
[
  1
]
0.26 ms
(12.70%)
1
SELECT t0.locale AS locale_1, t0.id AS id_2, t0.idContacts AS idContacts_3 FROM co_contact_locales t0 WHERE t0.idContacts = ?
Parameters:
[
  1
]
0.20 ms
(10.07%)
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
]

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\Bundle\SecurityBundle\Entity\User 1
Sulu\Bundle\ContactBundle\Entity\Contact 1
Sulu\Bundle\SecurityBundle\Entity\UserRole 1
Sulu\Bundle\SecurityBundle\Entity\Role 1

Entities Mapping

Class Mapping errors
Sulu\Bundle\SecurityBundle\Entity\User No errors.
Sulu\Bundle\SecurityBundle\Entity\UserRole No errors.
Sulu\Bundle\SecurityBundle\Entity\Role No errors.
Sulu\Bundle\SecurityBundle\Entity\Permission No errors.
Sulu\Bundle\ContactBundle\Entity\Contact No errors.
Sulu\Bundle\SecurityBundle\Entity\UserTwoFactor No errors.
Sulu\Bundle\SecurityBundle\Entity\UserSetting No errors.
Sulu\Bundle\SecurityBundle\Entity\RoleSetting No errors.
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ReferenceBundle\Domain\Model\Reference No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Page\Domain\Model\Page No errors.
Sulu\Bundle\TagBundle\Entity\Tag No errors.
Sulu\Bundle\CategoryBundle\Entity\Category No errors.
Sulu\Route\Domain\Model\Route No errors.
Sulu\Page\Domain\Model\PageDimensionContent No errors.
Sulu\Bundle\MediaBundle\Entity\Media No errors.
Sulu\Bundle\ContactBundle\Entity\ContactLocale No errors.
Sulu\Bundle\ContactBundle\Entity\ContactAddress No errors.
Sulu\Bundle\ContactBundle\Entity\AccountContact No errors.
Sulu\Bundle\ContactBundle\Entity\Url No errors.
Sulu\Bundle\ContactBundle\Entity\Note No errors.
Sulu\Bundle\ContactBundle\Entity\Email No errors.
Sulu\Bundle\ContactBundle\Entity\Phone No errors.
Sulu\Bundle\ContactBundle\Entity\Fax No errors.
Sulu\Bundle\ContactBundle\Entity\SocialMediaProfile No errors.
Sulu\Bundle\ContactBundle\Entity\BankAccount No errors.
Sulu\Bundle\ContactBundle\Entity\EmailType No errors.
Sulu\Article\Domain\Model\Article No errors.
Sulu\Article\Domain\Model\ArticleDimensionContent No errors.
Sulu\Snippet\Domain\Model\Snippet No errors.
Sulu\Snippet\Domain\Model\SnippetDimensionContent No errors.
Sulu\Snippet\Domain\Model\SnippetArea No errors.