Query Metrics
2
Database Queries
2
Different statements
2.91 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.89 ms (64.77%) |
1 |
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC, w1_.id ASC
Parameters:
[ "pqna.preprod.seven-group.com/{localization}" "dev" "pqna" ] |
1.03 ms (35.23%) |
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, s0_.enterprise AS enterprise_17, s0_.actorType AS actorType_18, s0_.isVisibleProfile AS isVisibleProfile_19, s0_.typologie_structure AS typologie_structure_20, s0_.fonction AS fonction_21, s0_.typologie_acteur_value AS typologie_acteur_value_22, s0_.idUsersCreator AS idUsersCreator_23, s0_.idUsersChanger AS idUsersChanger_24, s0_.idContacts AS idContacts_25 FROM se_users s0_ WHERE s0_.idContacts = ?
Parameters:
[
9
]
|
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 |
---|---|
Sulu\Bundle\FormBundle\Entity\Form | No errors. |
Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
Sulu\Bundle\FormBundle\Entity\Dynamic | No errors. |
Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
Sulu\Bundle\SecurityBundle\Entity\User | No errors. |
App\Entity\User | No errors. |
Sulu\Bundle\ContactBundle\Entity\Contact | No errors. |
App\Entity\Contact | No errors. |
Sulu\Bundle\SecurityBundle\Entity\UserRole | No errors. |
Sulu\Bundle\SecurityBundle\Entity\UserGroup | No errors. |
Sulu\Bundle\SecurityBundle\Entity\UserSetting | No errors. |
Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |