Query Metrics
35
Database Queries
10
Different statements
19.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.99 ms (25.12%) |
1 |
SELECT a0_.important AS important_0, a0_.id AS id_1, a0_.tmp_old_ids AS tmp_old_ids_2, a0_.name AS name_3, a0_.title AS title_4, a0_.slug AS slug_5, a0_.chapo AS chapo_6, a0_.content AS content_7, a0_.tmp_keywords AS tmp_keywords_8, a0_.priority AS priority_9, a0_.published AS published_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.type_id AS type_id_13 FROM article a0_ INNER JOIN article_type a1_ ON a0_.type_id = a1_.id WHERE a1_.name = ? AND a0_.published = 1 ORDER BY a0_.priority DESC, a0_.created_at DESC LIMIT 9
Parameters:
[
"a-la-une"
]
|
|
3.39 ms (17.05%) |
16 |
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
3.05 ms (15.35%) |
1 |
SELECT a0_.important AS important_0, a0_.id AS id_1, a0_.tmp_old_ids AS tmp_old_ids_2, a0_.name AS name_3, a0_.title AS title_4, a0_.slug AS slug_5, a0_.chapo AS chapo_6, a0_.content AS content_7, a0_.tmp_keywords AS tmp_keywords_8, a0_.priority AS priority_9, a0_.published AS published_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.type_id AS type_id_13 FROM article a0_ INNER JOIN article_type a1_ ON a0_.type_id = a1_.id WHERE a1_.name = ? AND a0_.published = 1 ORDER BY a0_.priority DESC, a0_.created_at DESC LIMIT 8
Parameters:
[
"article-fond"
]
|
|
2.73 ms (13.76%) |
9 |
SELECT t0.id AS id_1, t0.tmp_old_id AS tmp_old_id_2, t0.name AS name_3, t0.description AS description_4, t0.size AS size_5, t0.role AS role_6, t0.types AS types_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.picto_theme AS picto_theme_10 FROM media t0 INNER JOIN media_article ON t0.id = media_article.media_id WHERE media_article.article_id = ?
Parameters:
[
686
]
|
|
2.43 ms (12.22%) |
1 |
SELECT p0_.id AS id_0, p0_.period_start AS period_start_1, p0_.period_end AS period_end_2, p0_.all_day AS all_day_3, p0_.event_id AS event_id_4 FROM period p0_ INNER JOIN event e1_ ON p0_.event_id = e1_.id WHERE e1_.published = 1 AND ((p0_.period_start IS NOT NULL AND p0_.period_start >= ?) OR (p0_.period_end IS NOT NULL AND p0_.period_end >= ?) OR (p0_.all_day IS NOT NULL AND p0_.period_start >= ?)) ORDER BY p0_.period_start ASC, e1_.priority DESC, e1_.name ASC LIMIT 10
Parameters:
[ "2026-05-02 12:38:06" "2026-05-02 12:38:06" "2026-05-02 00:00:01" ] |
|
1.81 ms (9.11%) |
1 |
SELECT a0_.important AS important_0, a0_.id AS id_1, a0_.tmp_old_ids AS tmp_old_ids_2, a0_.name AS name_3, a0_.title AS title_4, a0_.slug AS slug_5, a0_.chapo AS chapo_6, a0_.content AS content_7, a0_.tmp_keywords AS tmp_keywords_8, a0_.priority AS priority_9, a0_.published AS published_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.type_id AS type_id_13 FROM article a0_ INNER JOIN article_type a1_ ON a0_.type_id = a1_.id WHERE a1_.name = ? AND a0_.published = 1 ORDER BY a0_.priority DESC, a0_.created_at DESC LIMIT 4
Parameters:
[
"publication"
]
|
|
0.59 ms (2.95%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"ovow2306_ici-grenoble-sf-dev"
]
|
|
0.35 ms (1.79%) |
2 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.priority AS priority_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.theme_picto AS theme_picto_6 FROM theme t0_ ORDER BY t0_.priority DESC, t0_.name ASC
Parameters:
[] |
|
0.27 ms (1.34%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.26 ms (1.30%) |
1 |
SELECT t0.id AS id_1, t0.tmp_old_ids AS tmp_old_ids_2, t0.name AS name_3, t0.title AS title_4, t0.slug AS slug_5, t0.chapo AS chapo_6, t0.content AS content_7, t0.tmp_keywords AS tmp_keywords_8, t0.priority AS priority_9, t0.published AS published_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM page t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"home"
]
|
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\ArticleType | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Period | No errors. |
| App\Entity\Event | No errors. |
| App\Entity\Theme | No errors. |
| App\Entity\QuestionAnswer | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\SubscriberList | No errors. |
| App\Entity\Subscriber | No errors. |