Query Metrics
9
Database Queries
7
Different statements
2.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.61 ms (27.36%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.body AS body_3, t0.cta_link AS cta_link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.slug AS slug_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.image AS image_10, t0.published AS published_11, t0.cta_name AS cta_name_12, t0.body_secondly AS body_secondly_13, t0.catch_phrase AS catch_phrase_14, t0.subtitle AS subtitle_15, t0.content_image AS content_image_16, t0.video_url AS video_url_17, t0.author_id AS author_id_18, t0.category_id AS category_id_19 FROM article t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"rencontre-avec-sandrine-cristin-referente-periscolaire-a-marseille"
]
|
|
0.39 ms (17.52%) |
1 |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.body AS body_2, a0_.cta_link AS cta_link_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.slug AS slug_6, a0_.meta_title AS meta_title_7, a0_.meta_description AS meta_description_8, a0_.image AS image_9, a0_.published AS published_10, a0_.cta_name AS cta_name_11, a0_.body_secondly AS body_secondly_12, a0_.catch_phrase AS catch_phrase_13, a0_.subtitle AS subtitle_14, a0_.content_image AS content_image_15, a0_.video_url AS video_url_16, a0_.author_id AS author_id_17, a0_.category_id AS category_id_18 FROM article a0_ WHERE a0_.published = 1 AND a0_.id <> ? ORDER BY a0_.created_at DESC LIMIT 3
Parameters:
[
1016
]
|
|
0.33 ms (14.85%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.firstname AS firstname_3, t0.description AS description_4, t0.link_social_media AS link_social_media_5, t0.image AS image_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM author t0 WHERE t0.id = ?
Parameters:
[
197
]
|
|
0.28 ms (12.74%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM category t0 WHERE t0.id = ?
Parameters:
[
195
]
|
|
0.27 ms (12.16%) |
1 |
SELECT m0_.id AS id_0, m0_.section AS section_1, m0_.label AS label_2, m0_.url AS url_3, m0_.position AS position_4, m0_.visible AS visible_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM mega_menu_item m0_ WHERE m0_.visible = 1 ORDER BY m0_.section ASC, m0_.position ASC
Parameters:
[] |
|
0.18 ms (7.87%) |
1 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM notification_bar t0 WHERE t0.active = ? ORDER BY t0.updated_at DESC LIMIT 1
Parameters:
[
1
]
|
|
0.17 ms (7.50%) |
1 |
SELECT m0_.id AS id_0, m0_.section AS section_1, m0_.image AS image_2, m0_.title AS title_3, m0_.description AS description_4, m0_.cta_text AS cta_text_5, m0_.cta_link AS cta_link_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8 FROM mega_menu_promo m0_
Parameters:
[] |
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\Article | No errors. |
| App\Entity\Author | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\MegaMenuItem | No errors. |
| App\Entity\MegaMenuPromo | No errors. |
| App\Entity\NotificationBar | No errors. |