Query Metrics

60 Database Queries
9 Different statements
78.81 ms Query time
0 Invalid entities
436 Managed entities

Grouped Statements

Show all queries

Time Count Info
22.89 ms
(29.04%)
1
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.titre AS titre_2, m0_.cible AS cible_3, m0_.ordre AS ordre_4, m0_.parent AS parent_5 FROM menu_jeune m0_ WHERE m0_.parent = ? AND m0_.id <= ? ORDER BY m0_.ordre ASC
Parameters:
[
  0
  11
]
19.95 ms
(25.31%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.description AS description_1, e0_.conditions AS conditions_2, e0_.visuel AS visuel_3, e0_.updated_visuel_at AS updated_visuel_at_4, e0_.credit_photographique AS credit_photographique_5, e0_.date AS date_6, e0_.date_format_texte AS date_format_texte_7, e0_.lieu AS lieu_8, e0_.adresse AS adresse_9, e0_.longitude AS longitude_10, e0_.latitude AS latitude_11, e0_.mots_cles AS mots_cles_12, e0_.inscription AS inscription_13, e0_.horaires AS horaires_14, e0_.titre AS titre_15, e0_.contenu AS contenu_16, e0_.jeune AS jeune_17, e0_.professionnel AS professionnel_18, e0_.slug AS slug_19, e0_.publie AS publie_20, e0_.created_by AS created_by_21, e0_.updated_by AS updated_by_22, e0_.created_date AS created_date_23, e0_.update_date AS update_date_24, e0_.compteur_affichage AS compteur_affichage_25, e0_.compteur_visite AS compteur_visite_26, e0_.commune_id AS commune_id_27 FROM evenement e0_ WHERE e0_.publie = ? AND e0_.date >= CURRENT_DATE AND e0_.jeune = ? ORDER BY e0_.date ASC
Parameters:
[
  1
  1
]
17.27 ms
(21.92%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.couleur AS couleur_4, t0.pictogramme AS pictogramme_5, t0.menu_jeune_id AS menu_jeune_id_6 FROM thematique t0
Parameters:
[]
12.57 ms
(15.95%)
52
SELECT t0.id AS id_1, t0.type AS type_2, t0.titre AS titre_3, t0.cible AS cible_4, t0.ordre AS ordre_5, t0.parent AS parent_6 FROM menu_jeune t0 WHERE t0.parent = ? ORDER BY t0.ordre ASC
Parameters:
[
  0
]
3.26 ms
(4.14%)
1
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.accroche AS accroche_4, a0_.a_la_une AS a_la_une_5, a0_.titre AS titre_6, a0_.contenu AS contenu_7, a0_.jeune AS jeune_8, a0_.professionnel AS professionnel_9, a0_.slug AS slug_10, a0_.publie AS publie_11, a0_.created_by AS created_by_12, a0_.updated_by AS updated_by_13, a0_.created_date AS created_date_14, a0_.update_date AS update_date_15, a0_.compteur_affichage AS compteur_affichage_16, a0_.compteur_visite AS compteur_visite_17 FROM article a0_ WHERE a0_.jeune = ? AND a0_.publie = ? ORDER BY a0_.created_date DESC
Parameters:
[
  1
  1
]
1.43 ms
(1.82%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.lien_video_youtube AS lien_video_youtube_3, t0.lien_chaine_youtube AS lien_chaine_youtube_4, t0.europe_direct_id AS europe_direct_id_5 FROM accueil t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.59 ms
(0.74%)
1
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.date_fin_publication AS date_fin_publication_5, a0_.a_la_une AS a_la_une_6, a0_.titre AS titre_7, a0_.contenu AS contenu_8, a0_.jeune AS jeune_9, a0_.professionnel AS professionnel_10, a0_.slug AS slug_11, a0_.publie AS publie_12, a0_.created_by AS created_by_13, a0_.updated_by AS updated_by_14, a0_.created_date AS created_date_15, a0_.update_date AS update_date_16, a0_.compteur_affichage AS compteur_affichage_17, a0_.compteur_visite AS compteur_visite_18 FROM actualite a0_ WHERE a0_.jeune = ? AND a0_.publie = ? AND a0_.date_debut_publication <= CURRENT_DATE AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) AND a0_.a_la_une = ? ORDER BY a0_.date_debut_publication DESC
Parameters:
[
  1
  1
  1
]
0.51 ms
(0.65%)
1
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.date_fin_publication AS date_fin_publication_5, a0_.a_la_une AS a_la_une_6, a0_.titre AS titre_7, a0_.contenu AS contenu_8, a0_.jeune AS jeune_9, a0_.professionnel AS professionnel_10, a0_.slug AS slug_11, a0_.publie AS publie_12, a0_.created_by AS created_by_13, a0_.updated_by AS updated_by_14, a0_.created_date AS created_date_15, a0_.update_date AS update_date_16, a0_.compteur_affichage AS compteur_affichage_17, a0_.compteur_visite AS compteur_visite_18 FROM actualite a0_ WHERE a0_.jeune = ? AND a0_.publie = ? AND a0_.date_debut_publication <= CURRENT_DATE AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) ORDER BY a0_.date_debut_publication DESC
Parameters:
[
  1
  1
]
0.34 ms
(0.43%)
1
SELECT a0_.id AS id_0, a0_.visuel AS visuel_1, a0_.updated_visuel_at AS updated_visuel_at_2, a0_.credit_photographique AS credit_photographique_3, a0_.accroche AS accroche_4, a0_.a_la_une AS a_la_une_5, a0_.titre AS titre_6, a0_.contenu AS contenu_7, a0_.jeune AS jeune_8, a0_.professionnel AS professionnel_9, a0_.slug AS slug_10, a0_.publie AS publie_11, a0_.created_by AS created_by_12, a0_.updated_by AS updated_by_13, a0_.created_date AS created_date_14, a0_.update_date AS update_date_15, a0_.compteur_affichage AS compteur_affichage_16, a0_.compteur_visite AS compteur_visite_17 FROM article a0_ WHERE a0_.jeune = ? AND a0_.a_la_une = ? AND a0_.publie = ? ORDER BY a0_.created_date DESC
Parameters:
[
  1
  1
  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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\MenuJeune 206
App\Entity\Article 205
App\Entity\ContenuQualification\Thematique 11
App\Entity\Actualite 7
App\Entity\Evenement 4
App\Entity\Commune 2
App\Entity\Accueil 1