Query Metrics
3
Database Queries
3
Different statements
4.84 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.68 ms |
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:
[
130
]
|
| 2 | 2.17 ms |
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, m3_.crop_x AS crop_x_20, m3_.crop_y AS crop_y_21, m3_.crop_width AS crop_width_22, m3_.crop_height AS crop_height_23, m3_.format_key AS format_key_24, m0_.idMediaTypes AS idMediaTypes_25, m0_.idPreviewImage AS idPreviewImage_26, m0_.idCollections AS idCollections_27, m0_.idUsersCreator AS idUsersCreator_28, m0_.idUsersChanger AS idUsersChanger_29, m1_.idMedia AS idMedia_30, m1_.idUsersCreator AS idUsersCreator_31, m1_.idUsersChanger AS idUsersChanger_32, m2_.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_33, m2_.idFiles AS idFiles_34, m2_.idUsersCreator AS idUsersCreator_35, m2_.idUsersChanger AS idUsersChanger_36, m3_.fileVersion AS fileVersion_37 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) LEFT JOIN me_format_options m3_ ON m2_.id = m3_.fileVersion AND (m3_.format_key = ?) WHERE m0_.id = ?
Parameters:
[ "440x200" "130" ] |
| 3 | 1.98 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:
[ "dev.hebammen-azh.de" "dev" "hebammen-azh" ] |
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\SecurityBundle\Entity\Group | No errors. |
| Sulu\Bundle\ContactBundle\Entity\ContactTitle | 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\FormatOptions | 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\TagBundle\Entity\Tag | No errors. |
| Sulu\Bundle\CategoryBundle\Entity\Category | No errors. |
| Sulu\Bundle\FormBundle\Entity\FormTranslation | No errors. |
| Sulu\Bundle\FormBundle\Entity\FormField | No errors. |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | No errors. |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | No errors. |
| Sulu\Bundle\TrashBundle\Domain\Model\TrashItemTranslation | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\UserGroup | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\Role | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\UserRole | No errors. |
| Sulu\Bundle\SecurityBundle\Entity\UserSetting | No errors. |
| Sulu\Bundle\ContactBundle\Entity\Contact | No errors. |
| Sulu\Bundle\CategoryBundle\Entity\CategoryMeta | No errors. |
| Sulu\Bundle\CategoryBundle\Entity\CategoryTranslation | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Analytics | No errors. |
| Sulu\Bundle\WebsiteBundle\Entity\Domain | No errors. |