Query Metrics
7
Database Queries
6
Different statements
1.75 ms
Query time
1
Invalid entities
66
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.66 ms (37.56%) |
1 |
SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.valeur AS valeur_2, m0_.valeur2 AS valeur2_3, m0_.valeur3 AS valeur3_4, m0_.htmlvaleur AS htmlvaleur_5, m0_.designation AS designation_6, m1_.id AS id_7, m1_.module AS module_8, m1_.code AS code_9, m1_.designation AS designation_10, m0_.masterliste_id AS masterliste_id_11 FROM masterlistelgs m0_ INNER JOIN masterlistes m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[ "NBHRSFORMATION" "NOYAU" "PARAMETRAGE" ] |
||||||||||||||||||||||||
|
0.36 ms (20.64%) |
2 |
SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0 WHERE t0.field = ? LIMIT 1
Parameters:
[
"default_vignette"
]
|
||||||||||||||||||||||||
|
0.25 ms (14.02%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.archive AS archive_4, t0.titlepage AS titlepage_5, t0.link AS link_6, t0.path AS path_7, t0.shortdescription AS shortdescription_8, t0.content AS content_9, t0.rang AS rang_10, t0.layout AS layout_11, t0.visible AS visible_12, t0.publication AS publication_13, t0.creationdate AS creationdate_14, t0.updatedate AS updatedate_15, t0.index_entity_type AS index_entity_type_16, t0.index_entity_id AS index_entity_id_17, t0.icon AS icon_18, t0.color AS color_19, t0.intitule_plus AS intitule_plus_20, t0.colorheader AS colorheader_21, t0.colorleft AS colorleft_22, t0.colorcontent AS colorcontent_23, t0.colorfooter AS colorfooter_24, t0.typeformation_id AS typeformation_id_25, t0.contentseo AS contentseo_26, t0.contentslider AS contentslider_27, t0.contenttemplate_id AS contenttemplate_id_28, t0.parent AS parent_29, t0.typepage_id AS typepage_id_30 FROM content_page t0 WHERE t0.path = ? AND t0.publication = ? LIMIT 1
Parameters:
[ "sitemap" 1 ]
|
||||||||||||||||||||||||
|
0.19 ms (11.01%) |
1 |
SELECT t0.id AS id_1, t0.field AS field_2, t0.value AS value_3, t0.type AS type_4, t0.path AS path_5, t0.dataCreation AS dataCreation_6, t0.dataUpdated AS dataUpdated_7 FROM theme_settings t0
Parameters:
[]
|
||||||||||||||||||||||||
|
0.15 ms (8.78%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.archive AS archive_3, t0.creationdate AS creationdate_4, t0.updatedate AS updatedate_5, t0.keyword AS keyword_6, t0.description AS description_7, t0.robots AS robots_8, t9.id AS id_10, t9.title AS title_11, t9.type AS type_12, t9.archive AS archive_13, t9.titlepage AS titlepage_14, t9.link AS link_15, t9.path AS path_16, t9.shortdescription AS shortdescription_17, t9.content AS content_18, t9.rang AS rang_19, t9.layout AS layout_20, t9.visible AS visible_21, t9.publication AS publication_22, t9.creationdate AS creationdate_23, t9.updatedate AS updatedate_24, t9.index_entity_type AS index_entity_type_25, t9.index_entity_id AS index_entity_id_26, t9.icon AS icon_27, t9.color AS color_28, t9.intitule_plus AS intitule_plus_29, t9.colorheader AS colorheader_30, t9.colorleft AS colorleft_31, t9.colorcontent AS colorcontent_32, t9.colorfooter AS colorfooter_33, t9.typeformation_id AS typeformation_id_34, t9.contentseo AS contentseo_35, t9.contentslider AS contentslider_36, t9.contenttemplate_id AS contenttemplate_id_37, t9.parent AS parent_38, t9.typepage_id AS typepage_id_39 FROM content_seo t0 LEFT JOIN content_page t9 ON t9.contentseo = t0.id WHERE t0.id = ?
Parameters:
[
16420
]
|
||||||||||||||||||||||||
|
0.14 ms (7.99%) |
1 |
SELECT t0.id AS id_1, t0.creationdate AS creationdate_2, t0.updatedate AS updatedate_3, t0.rang AS rang_4, t0.contentpage_id AS contentpage_id_5, t0.contentsection_id AS contentsection_id_6 FROM page_section t0 WHERE t0.contentpage_id = ? ORDER BY t0.rang ASC
Parameters:
[
12412
]
|
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 |
|---|---|
| App\Entity\ThemeSettings | 63 |
| App\Entity\ContentPage | 1 |
| App\Entity\ContentSeo | 1 |
| App\Entity\Masterlistelg | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Masterlistelg | No errors. |
| App\Entity\Masterliste | No errors. |
| App\Entity\ThemeSettings | No errors. |
| App\Entity\ContentPage | No errors. |
| App\Entity\ContentSeo |
|
| App\Entity\ContentSlider | No errors. |
| App\Entity\MenuContentPage | No errors. |
| App\Entity\PageSection | No errors. |
| App\Entity\ContentSection | No errors. |