Query Metrics

13 Database Queries
9 Different statements
5.53 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.37 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.titre AS titre_3, t0.introduction AS introduction_4, t0.image AS image_5 FROM actualites t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "10"
]
2 0.88 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.color AS color_3, t0.image AS image_4, t0.pages_id AS pages_id_5, t0.stages_id AS stages_id_6, t0.actualites_id AS actualites_id_7 FROM sections t0 WHERE t0.actualites_id = ?
Parameters:
[
  10
]
3 0.40 ms
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.titre AS titre_2, a0_.introduction AS introduction_3, a0_.image AS image_4 FROM actualites a0_ WHERE a0_.id <> ? ORDER BY a0_.date DESC LIMIT 4
Parameters:
[
  "10"
]
4 0.27 ms
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.titre AS titre_2, a0_.introduction AS introduction_3, a0_.image AS image_4 FROM actualites a0_ WHERE a0_.date < ? ORDER BY a0_.date DESC LIMIT 1
Parameters:
[
  "2025-04-03 00:00:00"
]
5 0.21 ms
SELECT a0_.id AS id_0, a0_.date AS date_1, a0_.titre AS titre_2, a0_.introduction AS introduction_3, a0_.image AS image_4 FROM actualites a0_ WHERE a0_.date > ? ORDER BY a0_.date ASC LIMIT 1
Parameters:
[
  "2025-04-03 00:00:00"
]
6 0.26 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.color AS color_3, t0.image AS image_4, t0.pages_id AS pages_id_5, t0.stages_id AS stages_id_6, t0.actualites_id AS actualites_id_7 FROM sections t0 WHERE t0.actualites_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  10
]
7 0.81 ms
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.sections_id AS sections_id_3 FROM lignes t0 WHERE t0.sections_id = ?
Parameters:
[
  5
]
8 0.73 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.lignes_id AS lignes_id_3 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  24
]
9 0.73 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.image AS image_4, t0.document AS document_5, t0.lien AS lien_6, t0.citation AS citation_7, t0.auteur AS auteur_8, t0.types_contenus_id AS types_contenus_id_9, t0.blocs_id AS blocs_id_10 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  28
]
10 0.25 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.lignes_id AS lignes_id_3 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  25
]
11 0.22 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.image AS image_4, t0.document AS document_5, t0.lien AS lien_6, t0.citation AS citation_7, t0.auteur AS auteur_8, t0.types_contenus_id AS types_contenus_id_9, t0.blocs_id AS blocs_id_10 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  29
]
12 0.20 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.lignes_id AS lignes_id_3 FROM blocs t0 WHERE t0.lignes_id = ?
Parameters:
[
  26
]
13 0.21 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3, t0.image AS image_4, t0.document AS document_5, t0.lien AS lien_6, t0.citation AS citation_7, t0.auteur AS auteur_8, t0.types_contenus_id AS types_contenus_id_9, t0.blocs_id AS blocs_id_10 FROM contenus t0 WHERE t0.blocs_id = ?
Parameters:
[
  30
]

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\Actualites No errors.
App\Entity\Sections No errors.
App\Entity\Pages No errors.
App\Entity\Stage No errors.
App\Entity\Lignes No errors.
App\Entity\Blocs No errors.
App\Entity\Contenus No errors.
App\Entity\TypesContenus No errors.