Query Metrics
3
Database Queries
3
Different statements
13.73 ms
Query time
0
Invalid entities
10
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 8.89 ms |
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.style AS style_4, m1_.lft AS lft_5, m1_.rgt AS rgt_6, m1_.depth AS depth_7, m1_.collection_key AS collection_key_8, m1_.id AS id_9, m1_.created AS created_10, m1_.changed AS changed_11, m2_.version AS version_12, m2_.id AS id_13, m2_.created AS created_14, m2_.changed AS changed_15, m3_.name AS name_16, m3_.version AS version_17, m3_.subVersion AS subVersion_18, m3_.size AS size_19, m3_.downloadCounter AS downloadCounter_20, m3_.storageOptions AS storageOptions_21, m3_.mimeType AS mimeType_22, m3_.properties AS properties_23, m3_.focusPointX AS focusPointX_24, m3_.focusPointY AS focusPointY_25, m3_.id AS id_26, m3_.created AS created_27, m3_.changed AS changed_28, m4_.crop_x AS crop_x_29, m4_.crop_y AS crop_y_30, m4_.crop_width AS crop_width_31, m4_.crop_height AS crop_height_32, m4_.format_key AS format_key_33, m5_.title AS title_34, m5_.description AS description_35, m5_.copyright AS copyright_36, m5_.credits AS credits_37, m5_.locale AS locale_38, m5_.id AS id_39, m6_.title AS title_40, m6_.description AS description_41, m6_.copyright AS copyright_42, m6_.credits AS credits_43, m6_.locale AS locale_44, m6_.id AS id_45, s7_.username AS username_46, s7_.password AS password_47, s7_.locale AS locale_48, s7_.salt AS salt_49, s7_.locked AS locked_50, s7_.enabled AS enabled_51, s7_.lastLogin AS lastLogin_52, s7_.confirmationKey AS confirmationKey_53, s7_.passwordResetToken AS passwordResetToken_54, s7_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_55, s7_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_56, s7_.privateKey AS privateKey_57, s7_.apiKey AS apiKey_58, s7_.email AS email_59, s7_.id AS id_60, s7_.created AS created_61, s7_.changed AS changed_62, c8_.firstName AS firstName_63, c8_.middleName AS middleName_64, c8_.lastName AS lastName_65, c8_.birthday AS birthday_66, c8_.salutation AS salutation_67, c8_.formOfAddress AS formOfAddress_68, c8_.newsletter AS newsletter_69, c8_.gender AS gender_70, c8_.note AS note_71, c8_.mainEmail AS mainEmail_72, c8_.mainPhone AS mainPhone_73, c8_.mainFax AS mainFax_74, c8_.mainUrl AS mainUrl_75, c8_.id AS id_76, c8_.created AS created_77, c8_.changed AS changed_78, s9_.username AS username_79, s9_.password AS password_80, s9_.locale AS locale_81, s9_.salt AS salt_82, s9_.locked AS locked_83, s9_.enabled AS enabled_84, s9_.lastLogin AS lastLogin_85, s9_.confirmationKey AS confirmationKey_86, s9_.passwordResetToken AS passwordResetToken_87, s9_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_88, s9_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_89, s9_.privateKey AS privateKey_90, s9_.apiKey AS apiKey_91, s9_.email AS email_92, s9_.id AS id_93, s9_.created AS created_94, s9_.changed AS changed_95, c10_.firstName AS firstName_96, c10_.middleName AS middleName_97, c10_.lastName AS lastName_98, c10_.birthday AS birthday_99, c10_.salutation AS salutation_100, c10_.formOfAddress AS formOfAddress_101, c10_.newsletter AS newsletter_102, c10_.gender AS gender_103, c10_.note AS note_104, c10_.mainEmail AS mainEmail_105, c10_.mainPhone AS mainPhone_106, c10_.mainFax AS mainFax_107, c10_.mainUrl AS mainUrl_108, c10_.id AS id_109, c10_.created AS created_110, c10_.changed AS changed_111, m11_.type AS type_112, m11_.id AS id_113, m11_.created AS created_114, m11_.changed AS changed_115, m0_.idPreviewImage AS idPreviewImage_116, m0_.idCollections AS idCollections_117, m0_.idUsersCreator AS idUsersCreator_118, m0_.idUsersChanger AS idUsersChanger_119, m1_.idCollectionsMetaDefault AS idCollectionsMetaDefault_120, m1_.idCollectionTypes AS idCollectionTypes_121, m1_.idCollectionsParent AS idCollectionsParent_122, m1_.idUsersCreator AS idUsersCreator_123, m1_.idUsersChanger AS idUsersChanger_124, m2_.idMedia AS idMedia_125, m2_.idUsersCreator AS idUsersCreator_126, m2_.idUsersChanger AS idUsersChanger_127, m3_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_128, m3_.idFiles AS idFiles_129, m3_.idUsersCreator AS idUsersCreator_130, m3_.idUsersChanger AS idUsersChanger_131, m4_.fileVersion AS fileVersion_132, m5_.idFileVersions AS idFileVersions_133, m6_.idFileVersions AS idFileVersions_134, s7_.idContacts AS idContacts_135, s7_.idUsersCreator AS idUsersCreator_136, s7_.idUsersChanger AS idUsersChanger_137, c8_.idTitles AS idTitles_138, c8_.avatar AS avatar_139, c8_.idUsersCreator AS idUsersCreator_140, c8_.idUsersChanger AS idUsersChanger_141, s9_.idContacts AS idContacts_142, s9_.idUsersCreator AS idUsersCreator_143, s9_.idUsersChanger AS idUsersChanger_144, c10_.idTitles AS idTitles_145, c10_.avatar AS avatar_146, c10_.idUsersCreator AS idUsersCreator_147, c10_.idUsersChanger AS idUsersChanger_148, m11_.idPreviewImage AS idPreviewImage_149, m11_.idCollections AS idCollections_150, m11_.idUsersCreator AS idUsersCreator_151, m11_.idUsersChanger AS idUsersChanger_152 FROM me_media m0_ LEFT JOIN me_collections m1_ ON m0_.idCollections = m1_.id LEFT JOIN me_files m2_ ON m0_.id = m2_.idMedia LEFT JOIN me_file_versions m3_ ON m2_.id = m3_.idFiles LEFT JOIN me_format_options m4_ ON m3_.id = m4_.fileVersion LEFT JOIN me_file_version_meta m5_ ON m3_.id = m5_.idFileVersions LEFT JOIN me_file_version_meta m6_ ON m3_.idFileVersionsMetaDefault = m6_.id LEFT JOIN se_users s7_ ON m0_.idUsersCreator = s7_.id LEFT JOIN co_contacts c8_ ON s7_.idContacts = c8_.id LEFT JOIN se_users s9_ ON m0_.idUsersChanger = s9_.id LEFT JOIN co_contacts c10_ ON s9_.idContacts = c10_.id LEFT JOIN me_media m11_ ON m0_.idPreviewImage = m11_.id WHERE m0_.id = ?
Parameters:
[
"17"
]
|
||||||||||||||||||||||||||||
| 2 | 1.41 ms |
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:
[
2
]
|
||||||||||||||||||||||||||||
| 3 | 3.43 ms |
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
Parameters:
[ "www.i.actions-croisees08.fr" "dev" "action_croisee" ] |
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\User | 2 |
| Sulu\Bundle\MediaBundle\Entity\Media | 1 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | 1 |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | 1 |
| Sulu\Bundle\MediaBundle\Entity\File | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |