Query Metrics
7
Database Queries
7
Different statements
4.34 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.27 ms |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles AND (m4_.version = m3_.version) LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id WHERE m0_.id IN (?) ORDER BY m0_.id ASC
Parameters:
[
143
]
|
| 2 | 0.35 ms |
SELECT t0.lft AS lft_1, t0.rgt AS rgt_2, t0.depth AS depth_3, t0.name AS name_4, t0.externalId AS externalId_5, t0.number AS number_6, t0.corporation AS corporation_7, t0.note AS note_8, t0.uid AS uid_9, t0.registerNumber AS registerNumber_10, t0.placeOfJurisdiction AS placeOfJurisdiction_11, t0.mainEmail AS mainEmail_12, t0.mainPhone AS mainPhone_13, t0.mainFax AS mainFax_14, t0.mainUrl AS mainUrl_15, t0.id AS id_16, t0.created AS created_17, t0.changed AS changed_18, t0.idContactsMain AS idContactsMain_19, t0.idAccountsParent AS idAccountsParent_20, t0.logo AS logo_21, t0.idUsersCreator AS idUsersCreator_22, t0.idUsersChanger AS idUsersChanger_23, t0.media AS media_24, t0.logoAlt AS logoAlt_25 FROM co_accounts t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
| 3 | 0.20 ms |
SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = ?
Parameters:
[
41
]
|
| 4 | 0.21 ms |
SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = ?
Parameters:
[
41
]
|
| 5 | 0.20 ms |
SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = ?
Parameters:
[
41
]
|
| 6 | 1.57 ms |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subVersion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadCounter_22, m4_.storageOptions AS storageOptions_23, m4_.mimeType AS mimeType_24, m4_.properties AS properties_25, m4_.focusPointX AS focusPointX_26, m4_.focusPointY AS focusPointY_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, t5_.name AS name_31, t5_.id AS id_32, t5_.created AS created_33, t5_.changed AS changed_34, m6_.title AS title_35, m6_.description AS description_36, m6_.copyright AS copyright_37, m6_.credits AS credits_38, m6_.locale AS locale_39, m6_.id AS id_40, m7_.title AS title_41, m7_.description AS description_42, m7_.copyright AS copyright_43, m7_.credits AS credits_44, m7_.locale AS locale_45, m7_.id AS id_46, m8_.locale AS locale_47, m8_.id AS id_48, m9_.locale AS locale_49, m9_.id AS id_50, s10_.username AS username_51, s10_.password AS password_52, s10_.locale AS locale_53, s10_.salt AS salt_54, s10_.locked AS locked_55, s10_.enabled AS enabled_56, s10_.lastLogin AS lastLogin_57, s10_.confirmationKey AS confirmationKey_58, s10_.passwordResetToken AS passwordResetToken_59, s10_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_60, s10_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_61, s10_.privateKey AS privateKey_62, s10_.apiKey AS apiKey_63, s10_.email AS email_64, s10_.id AS id_65, s10_.created AS created_66, s10_.changed AS changed_67, c11_.firstName AS firstName_68, c11_.middleName AS middleName_69, c11_.lastName AS lastName_70, c11_.birthday AS birthday_71, c11_.salutation AS salutation_72, c11_.formOfAddress AS formOfAddress_73, c11_.newsletter AS newsletter_74, c11_.gender AS gender_75, c11_.note AS note_76, c11_.mainEmail AS mainEmail_77, c11_.mainPhone AS mainPhone_78, c11_.mainFax AS mainFax_79, c11_.mainUrl AS mainUrl_80, c11_.id AS id_81, c11_.created AS created_82, c11_.changed AS changed_83, s12_.username AS username_84, s12_.password AS password_85, s12_.locale AS locale_86, s12_.salt AS salt_87, s12_.locked AS locked_88, s12_.enabled AS enabled_89, s12_.lastLogin AS lastLogin_90, s12_.confirmationKey AS confirmationKey_91, s12_.passwordResetToken AS passwordResetToken_92, s12_.passwordResetTokenExpiresAt AS passwordResetTokenExpiresAt_93, s12_.passwordResetTokenEmailsSent AS passwordResetTokenEmailsSent_94, s12_.privateKey AS privateKey_95, s12_.apiKey AS apiKey_96, s12_.email AS email_97, s12_.id AS id_98, s12_.created AS created_99, s12_.changed AS changed_100, c13_.firstName AS firstName_101, c13_.middleName AS middleName_102, c13_.lastName AS lastName_103, c13_.birthday AS birthday_104, c13_.salutation AS salutation_105, c13_.formOfAddress AS formOfAddress_106, c13_.newsletter AS newsletter_107, c13_.gender AS gender_108, c13_.note AS note_109, c13_.mainEmail AS mainEmail_110, c13_.mainPhone AS mainPhone_111, c13_.mainFax AS mainFax_112, c13_.mainUrl AS mainUrl_113, c13_.id AS id_114, c13_.created AS created_115, c13_.changed AS changed_116, m0_.idMediaTypes AS idMediaTypes_117, m0_.idPreviewImage AS idPreviewImage_118, m0_.idCollections AS idCollections_119, m0_.idUsersCreator AS idUsersCreator_120, m0_.idUsersChanger AS idUsersChanger_121, m2_.idCollectionsMetaDefault AS idCollectionsMetaDefault_122, m2_.idCollectionTypes AS idCollectionTypes_123, m2_.idCollectionsParent AS idCollectionsParent_124, m2_.idUsersCreator AS idUsersCreator_125, m2_.idUsersChanger AS idUsersChanger_126, m3_.idMedia AS idMedia_127, m3_.idUsersCreator AS idUsersCreator_128, m3_.idUsersChanger AS idUsersChanger_129, m4_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_130, m4_.idFiles AS idFiles_131, m4_.idUsersCreator AS idUsersCreator_132, m4_.idUsersChanger AS idUsersChanger_133, t5_.idUsersCreator AS idUsersCreator_134, t5_.idUsersChanger AS idUsersChanger_135, m6_.idFileVersions AS idFileVersions_136, m7_.idFileVersions AS idFileVersions_137, m8_.idFileVersions AS idFileVersions_138, m9_.idFileVersions AS idFileVersions_139, s10_.idContacts AS idContacts_140, s10_.idUsersCreator AS idUsersCreator_141, s10_.idUsersChanger AS idUsersChanger_142, c11_.idTitles AS idTitles_143, c11_.avatar AS avatar_144, c11_.idUsersCreator AS idUsersCreator_145, c11_.idUsersChanger AS idUsersChanger_146, s12_.idContacts AS idContacts_147, s12_.idUsersCreator AS idUsersCreator_148, s12_.idUsersChanger AS idUsersChanger_149, c13_.idTitles AS idTitles_150, c13_.avatar AS avatar_151, c13_.idUsersCreator AS idUsersCreator_152, c13_.idUsersChanger AS idUsersChanger_153 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id INNER JOIN me_files m3_ ON m0_.id = m3_.idMedia INNER JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles AND (m4_.version = m3_.version) LEFT JOIN me_file_version_tags m14_ ON m4_.id = m14_.idFileVersions LEFT JOIN ta_tags t5_ ON t5_.id = m14_.idTags LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.id ASC
Parameters:
[ 89 96 94 93 95 86 85 81 83 88 87 91 90 84 116 ] |
| 7 | 0.54 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, w1_.id ASC
Parameters:
[ "preprod.fereol-depannage.com" "dev" "fereol" ] |
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\SecurityBundle\Entity\Group | No errors. |
| Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
| Sulu\Bundle\MediaBundle\Entity\Collection | No errors. |
| Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
| Sulu\Bundle\FormBundle\Entity\Form | No errors. |
| Sulu\Bundle\MediaBundle\Entity\Media | No errors. |
| Sulu\Bundle\MediaBundle\Entity\MediaType | No errors. |
| Sulu\Bundle\MediaBundle\Entity\File | No errors. |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | No errors. |
| Sulu\Bundle\TagBundle\Entity\Tag | No errors. |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | No errors. |
| Sulu\Bundle\MediaBundle\Entity\FileVersionContentLanguage | No errors. |
| Sulu\Bundle\MediaBundle\Entity\FileVersionPublishLanguage | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\User | No errors. |
| Sulu\Bundle\ContactBundle\Entity\Contact | No errors. |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | No errors. |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | No errors. |
| Sulu\Bundle\MediaBundle\Entity\FormatOptions | No errors. |
| Sulu\Bundle\CategoryBundle\Entity\Category | 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\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\Account | No errors. |
| App\Entity\Account | No errors. |
| Sulu\Bundle\ContactBundle\Entity\AccountAddress | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |