GET https://gorgouille.fr/blog/article/les-JO-limpides_12

Query Metrics

16 Database Queries
13 Different statements
2.64 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.30 ms
SELECT t0.id AS id_1, t0.sur_titre AS sur_titre_2, t0.titre AS titre_3, t0.sous_titre AS sous_titre_4, t0.chapeau AS chapeau_5, t0.texte AS texte_6, t0.date_crea AS date_crea_7, t0.date_modif AS date_modif_8, t0.date_publication AS date_publication_9, t0.en_ligne AS en_ligne_10, t0.auteur_id AS auteur_id_11 FROM blog_publication t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
2 0.21 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.14 ms
SELECT t0.id AS id_1, t0.case1_id AS case1_id_2, t0.case2_id AS case2_id_3 FROM blog_chapeau t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.20 ms
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = ? ORDER BY b0_.ordre ASC, b1_.ordre ASC
Parameters:
[
  1
]
5 0.14 ms
SELECT b0_.id AS id_0, b0_.sur_titre AS sur_titre_1, b0_.titre AS titre_2, b0_.sous_titre AS sous_titre_3, b0_.chapeau AS chapeau_4, b0_.texte AS texte_5, b0_.date_crea AS date_crea_6, b0_.date_modif AS date_modif_7, b0_.date_publication AS date_publication_8, b0_.en_ligne AS en_ligne_9, b0_.auteur_id AS auteur_id_10 FROM blog_publication b0_ WHERE b0_.en_ligne = 1 ORDER BY b0_.date_publication DESC LIMIT 3
Parameters:
[]
6 0.15 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM blog_about t0
Parameters:
[]
7 0.12 ms
SELECT t0.id AS id_1, t0.url_img AS url_img_2, t0.titre AS titre_3, t0.lien AS lien_4 FROM blog_reseaux t0
Parameters:
[]
8 0.13 ms
SELECT DISTINCT b0_.date_publication AS date_publication_0 FROM blog_publication b0_ WHERE b0_.date_publication IS NOT NULL ORDER BY b0_.date_publication DESC
Parameters:
[]
9 0.14 ms
SELECT b0_.id AS id_0, b0_.url AS url_1, b0_.titre AS titre_2, b0_.legende AS legende_3, b0_.ordre AS ordre_4 FROM blog_image b0_ ORDER BY b0_.id DESC LIMIT 1
Parameters:
[]
10 0.23 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
11 0.19 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
Parameters:
[
  38
]
12 0.12 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
Parameters:
[
  20
]
13 0.11 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
Parameters:
[
  40
]
14 0.18 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = ?
Parameters:
[
  12
]
15 0.14 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = ?
Parameters:
[
  12
]
16 0.12 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.societe AS societe_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.cgu AS cgu_10, t0.actif AS actif_11, t0.code_verif AS code_verif_12, t0.date_crea AS date_crea_13, t0.date_modif AS date_modif_14, t0.color AS color_15 FROM secur_user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\BlogPublication No errors.
App\Entity\SecurUser No errors.
App\Entity\BlogImage No errors.
App\Entity\BlogRubrique No errors.
App\Entity\BlogHeader No errors.
App\Entity\BlogChapeau No errors.
App\Entity\BlogAbout No errors.
App\Entity\BlogReseaux No errors.
App\Entity\Medias No errors.