Query Metrics

44 Database Queries
10 Different statements
22.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.99 ms
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"
]
2 3.05 ms
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"
]
3 1.81 ms
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"
]
4 0.26 ms
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"
]
5 2.43 ms
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"
]
6 0.14 ms
SELECT DATABASE()
Parameters:
[]
7 0.59 ms
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"
]
8 0.12 ms
SELECT DATABASE()
Parameters:
[]
9 0.26 ms
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:
[]
10 0.23 ms
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
]
11 0.21 ms
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:
[
  15
]
12 0.21 ms
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:
[
  16
]
13 0.21 ms
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:
[
  3
]
14 0.21 ms
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:
[
  9
]
15 0.21 ms
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:
[
  11
]
16 0.21 ms
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:
[
  13
]
17 0.21 ms
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:
[
  1
]
18 0.21 ms
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:
[
  2
]
19 0.21 ms
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:
[
  4
]
20 0.21 ms
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:
[
  5
]
21 0.21 ms
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:
[
  6
]
22 0.21 ms
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:
[
  7
]
23 0.21 ms
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:
[
  10
]
24 0.21 ms
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:
[
  12
]
25 0.21 ms
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:
[
  14
]
26 0.31 ms
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
]
27 0.27 ms
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:
[
  699
]
28 0.36 ms
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:
[
  694
]
29 0.30 ms
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:
[
  672
]
30 0.29 ms
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:
[
  577
]
31 0.29 ms
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:
[
  454
]
32 0.31 ms
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:
[
  696
]
33 0.30 ms
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:
[
  438
]
34 0.30 ms
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:
[
  690
]
35 0.10 ms
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:
[]
36 0.30 ms
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:
[
  211
]
37 0.28 ms
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:
[
  429
]
38 0.28 ms
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:
[
  119
]
39 0.27 ms
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:
[
  495
]
40 0.28 ms
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:
[
  25
]
41 0.26 ms
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:
[
  1
]
42 0.27 ms
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:
[
  606
]
43 0.30 ms
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:
[
  514
]
44 0.11 ms
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"
]

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.