Query Metrics
3
Database Queries
3
Different statements
2.45 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.15 ms (46.98%) |
1 |
UPDATE me_file_versions SET downloadCounter = downloadCounter + 1 WHERE id = ?
Parameters:
[
42
]
|
||||||||||||||||||||||||||
|
0.71 ms (28.87%) |
1 |
SELECT m0_.type AS type_0, m0_.id AS id_1, m0_.created AS created_2, m0_.changed AS changed_3, m1_.version AS version_4, m1_.id AS id_5, m1_.created AS created_6, m1_.changed AS changed_7, m2_.name AS name_8, m2_.version AS version_9, m2_.subVersion AS subVersion_10, m2_.size AS size_11, m2_.downloadCounter AS downloadCounter_12, m2_.storageOptions AS storageOptions_13, m2_.mimeType AS mimeType_14, m2_.properties AS properties_15, m2_.focusPointX AS focusPointX_16, m2_.focusPointY AS focusPointY_17, m2_.id AS id_18, m2_.created AS created_19, m2_.changed AS changed_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:
[
"28"
]
|
||||||||||||||||||||||||||
|
0.59 ms (24.15%) |
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:
[
28
]
|
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\MediaBundle\Entity\Media | 1 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 1 |
| Sulu\Bundle\SecurityBundle\Entity\User | 1 |
| Sulu\Bundle\MediaBundle\Entity\File | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 1 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 1 |