Query Metrics
60
Database Queries
9
Different statements
14.19 ms
Query time
0
Invalid entities
449
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.83 ms (48.13%) |
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.37 ms (23.75%) |
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.31 ms (9.21%) |
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.93 ms (6.56%) |
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 ] |
|
0.88 ms (6.17%) |
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.27 ms (1.88%) |
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 ] |
|
0.26 ms (1.82%) |
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 ] |
|
0.19 ms (1.37%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.menu_jeune AS menu_jeune_4, t0.couleur AS couleur_5, t0.pictogramme AS pictogramme_6 FROM thematique t0
Parameters:
[] |
|
0.16 ms (1.11%) |
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
]
|
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 | 205 |
| App\Entity\Article | 204 |
| App\Entity\Evenement | 13 |
| App\Entity\ContenuQualification\Thematique | 11 |
| App\Entity\Actualite | 11 |
| App\Entity\Commune | 4 |
| App\Entity\Accueil | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Accueil | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\AccesRapide | No errors. |
| App\Entity\MenuJeune | No errors. |
| App\Entity\Evenement | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\ContenuQualification\Age | No errors. |
| App\Entity\ContenuQualification\Situation | No errors. |
| App\Entity\ContenuQualification\Thematique | No errors. |
| App\Entity\ContenuQualification\Departement | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Jeune | No errors. |
| App\Entity\HistoriqueThematique | No errors. |
| App\Entity\ActualiteDocument | No errors. |
| App\Entity\ArticleComplement | No errors. |
| App\Entity\ArticleDocument | No errors. |
| App\Entity\Favori | No errors. |
| App\Entity\Organisme | No errors. |