Query Metrics
6
Database Queries
6
Different statements
2.42 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.97 ms |
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.type AS type_4, t0.type_file AS type_file_5, t0.file AS file_6, t0.title AS title_7, t0.path AS path_8, t0.extension AS extension_9, t0.size AS size_10, t0.deleted_at AS deleted_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.language_id AS language_id_14 FROM media t0 WHERE t0.file = ? LIMIT 1
Parameters:
[
"cacp-672cde09a42ad.jpg"
]
|
||||||||||||||||||||||||||||
2 | 0.40 ms |
SELECT t0.id AS id_1, t0.origin AS origin_2, t0.id_origin AS id_origin_3, t0.is_connected AS is_connected_4, t0.is_public AS is_public_5, t0.type AS type_6, t0.is_show_title AS is_show_title_7, t0.is_slideshow AS is_slideshow_8, t0.position AS position_9, t0.name AS name_10, t0.legende AS legende_11, t0.is_generic AS is_generic_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.language_id AS language_id_15, t0.parent_id AS parent_id_16, t17.id AS id_18, t17.origin AS origin_19, t17.id_origin AS id_origin_20, t17.is_connected AS is_connected_21, t17.is_public AS is_public_22, t17.type AS type_23, t17.is_show_title AS is_show_title_24, t17.is_slideshow AS is_slideshow_25, t17.position AS position_26, t17.name AS name_27, t17.legende AS legende_28, t17.is_generic AS is_generic_29, t17.created_at AS created_at_30, t17.updated_at AS updated_at_31, t17.language_id AS language_id_32, t17.parent_id AS parent_id_33 FROM bloc t0 LEFT JOIN bloc t17 ON t0.parent_id = t17.id WHERE t0.id = ?
Parameters:
[
"183"
]
|
||||||||||||||||||||||||||||
3 | 0.37 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.bloc_id AS bloc_id_3, t0.media_id AS media_id_4, t5.id AS id_6, t5.origin AS origin_7, t5.id_origin AS id_origin_8, t5.type AS type_9, t5.type_file AS type_file_10, t5.file AS file_11, t5.title AS title_12, t5.path AS path_13, t5.extension AS extension_14, t5.size AS size_15, t5.deleted_at AS deleted_at_16, t5.created_at AS created_at_17, t5.updated_at AS updated_at_18, t5.language_id AS language_id_19 FROM bloc_images t0 LEFT JOIN media t5 ON t0.media_id = t5.id WHERE t0.bloc_id IN (?)
Parameters:
[
183
]
|
||||||||||||||||||||||||||||
4 | 0.21 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.bloc_id AS bloc_id_4 FROM bloc_links t0 WHERE t0.bloc_id IN (?)
Parameters:
[
183
]
|
||||||||||||||||||||||||||||
5 | 0.25 ms |
SELECT t0.id AS id_1, t0.text AS text_2, t0.position_media AS position_media_3, t0.bloc_id AS bloc_id_4, t0.media_id AS media_id_5, t6.id AS id_7, t6.origin AS origin_8, t6.id_origin AS id_origin_9, t6.type AS type_10, t6.type_file AS type_file_11, t6.file AS file_12, t6.title AS title_13, t6.path AS path_14, t6.extension AS extension_15, t6.size AS size_16, t6.deleted_at AS deleted_at_17, t6.created_at AS created_at_18, t6.updated_at AS updated_at_19, t6.language_id AS language_id_20 FROM bloc_text t0 LEFT JOIN media t6 ON t0.media_id = t6.id WHERE t0.bloc_id IN (?)
Parameters:
[
183
]
|
||||||||||||||||||||||||||||
6 | 0.23 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.is_public AS is_public_3, t0.is_enable AS is_enable_4, t0.is_show_in_mosaic AS is_show_in_mosaic_5, t0.publication_at AS publication_at_6, t0.deleted_at AS deleted_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.brand_type_id AS brand_type_id_10, t0.draft_id AS draft_id_11 FROM brand t0 WHERE t0.id = ?
Parameters:
[
"46"
]
|
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 |
---|---|
App\Entity\Media | No errors. |
App\Entity\Language | No errors. |
App\Entity\Blocs\BlocImages | No errors. |
App\Entity\Blocs\Bloc | No errors. |
App\Entity\Blocs\BlocLinks | No errors. |
App\Entity\Blocs\BlocText | No errors. |
App\Entity\Brand\Brand | No errors. |
App\Entity\Brand\BrandType | No errors. |
App\Entity\Brand\BrandLang | No errors. |
App\Entity\Brand\BrandAttachment | No errors. |
App\Entity\Brand\BrandDocument | No errors. |
App\Entity\Brand\DomainBrand | No errors. |
App\Entity\User\UserBrandAccess | No errors. |
App\Entity\User\UserBrandAccessRequestDetail | No errors. |
App\Entity\User\UserFavorites | No errors. |
App\Entity\Pages\PageBrand | No errors. |
App\Entity\Brand\BrandKeyword | No errors. |