Query Metrics
3
Database Queries
3
Different statements
1.83 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.95 ms (52.04%) |
1 |
UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = ?
Parameters:
[
519
]
|
0.50 ms (27.06%) |
1 |
SELECT m0_.collection_key AS collection_key_0 FROM me_media m1_ INNER JOIN me_collections m0_ ON m1_.idCollections = m0_.id WHERE m1_.id = ?
Parameters:
[
509
]
|
0.38 ms (20.90%) |
1 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.version AS version_3, m1_.id AS id_4, m1_.created AS created_5, m1_.changed AS changed_6, m2_.name AS name_7, m2_.version AS version_8, m2_.subVersion AS subVersion_9, m2_.size AS size_10, m2_.downloadCounter AS downloadCounter_11, m2_.storageOptions AS storageOptions_12, m2_.mimeType AS mimeType_13, m2_.properties AS properties_14, m2_.focusPointX AS focusPointX_15, m2_.focusPointY AS focusPointY_16, m2_.id AS id_17, m2_.created AS created_18, m2_.changed AS changed_19, m0_.idMediaTypes AS idMediaTypes_20, m0_.idPreviewImage AS idPreviewImage_21, m0_.idCollections AS idCollections_22, m0_.idUsersCreator AS idUsersCreator_23, m0_.idUsersChanger AS idUsersChanger_24, m1_.idMedia AS idMedia_25, m1_.idUsersCreator AS idUsersCreator_26, m1_.idUsersChanger AS idUsersChanger_27, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_28, m2_.idFiles AS idFiles_29, m2_.idUsersCreator AS idUsersCreator_30, m2_.idUsersChanger AS idUsersChanger_31 FROM me_media m0_ LEFT JOIN me_files m1_ ON m0_.id = m1_.idMedia LEFT JOIN me_file_versions m2_ ON m1_.id = m2_.idFiles AND (m1_.version = m2_.version) WHERE m0_.id = ?
Parameters:
[
"509"
]
|
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\MediaBundle\Entity\Collection | No errors. |
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem | No errors. |
Sulu\Bundle\FormBundle\Entity\Form | No errors. |
Sulu\Bundle\ContactBundle\Entity\ContactTitle | No errors. |
Sulu\Bundle\SecurityBundle\Entity\Group | No errors. |
Sulu\Bundle\MediaBundle\Entity\Media | No errors. |
Sulu\Bundle\MediaBundle\Entity\File | No errors. |
Sulu\Bundle\MediaBundle\Entity\FileVersion | No errors. |
Sulu\Bundle\MediaBundle\Entity\MediaType | No errors. |
Sulu\Bundle\SecurityBundle\Entity\User | 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\MediaBundle\Entity\FormatOptions | No errors. |
Sulu\Bundle\TagBundle\Entity\Tag | No errors. |
Sulu\Bundle\CategoryBundle\Entity\Category | No errors. |