Query Metrics
81
Database Queries
6
Different statements
21.71 ms
Query time
0
Invalid entities
107
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.35 ms (38.44%) |
30 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.updated_image_at AS updated_image_at_4, t0.contenu AS contenu_5, t0.date_debut_publication AS date_debut_publication_6, t0.date_fin_publication AS date_fin_publication_7, t0.visible_page_accueil AS visible_page_accueil_8, t0.slug AS slug_9, t0.created_date AS created_date_10, t0.update_date AS update_date_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.publication AS publication_14, t0.cible_id AS cible_id_15 FROM article t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
6.22 ms (28.63%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.image AS image_2, a0_.updated_image_at AS updated_image_at_3, a0_.date_debut_publication AS date_debut_publication_4, a0_.descriptif AS descriptif_5, a0_.date_fin_publication AS date_fin_publication_6, a0_.a_la_une AS a_la_une_7, a0_.slug AS slug_8, a0_.created_date AS created_date_9, a0_.update_date AS update_date_10, a0_.created_by AS created_by_11, a0_.updated_by AS updated_by_12, a0_.publication AS publication_13, a0_.thematique_id AS thematique_id_14, a0_.cible_id AS cible_id_15 FROM actualite a0_ WHERE a0_.cible_id IN (?, ?) AND a0_.a_la_une = ? AND a0_.publication = ? AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) ORDER BY a0_.date_debut_publication DESC
Parameters:
[ 4 6 1 1 ] |
|
4.78 ms (22.01%) |
33 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ordre AS ordre_3, t0.parent_id AS parent_id_4, t0.article_id AS article_id_5 FROM menu t0 WHERE t0.parent_id = ? ORDER BY t0.ordre ASC
Parameters:
[
0
]
|
|
1.89 ms (8.72%) |
15 |
SELECT t0.slug AS slug_1, t0.id AS id_2, t0.nom AS nom_3, t0.created_date AS created_date_4, t0.update_date AS update_date_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM thematique t0 WHERE t0.id = ?
Parameters:
[
36
]
|
|
0.28 ms (1.31%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.image AS image_2, a0_.updated_image_at AS updated_image_at_3, a0_.contenu AS contenu_4, a0_.date_debut_publication AS date_debut_publication_5, a0_.date_fin_publication AS date_fin_publication_6, a0_.visible_page_accueil AS visible_page_accueil_7, a0_.slug AS slug_8, a0_.created_date AS created_date_9, a0_.update_date AS update_date_10, a0_.created_by AS created_by_11, a0_.updated_by AS updated_by_12, a0_.publication AS publication_13, a0_.cible_id AS cible_id_14 FROM article a0_ WHERE a0_.publication = ? AND a0_.cible_id IN (?, ?) AND a0_.visible_page_accueil = ? ORDER BY a0_.created_date DESC LIMIT 3
Parameters:
[ 1 4 6 1 ] |
|
0.19 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.code_video AS code_video_2, t0.created_date AS created_date_3, t0.update_date AS update_date_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.temoignages_id AS temoignages_id_7, t0.pourquoi_pas_toi_id AS pourquoi_pas_toi_id_8, t0.je_prends_rdv_id AS je_prends_rdv_id_9, t0.boite_aoutils1_id AS boite_aoutils1_id_10, t0.boite_aoutils2_id AS boite_aoutils2_id_11, t0.boite_aoutils3_id AS boite_aoutils3_id_12 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\Menu | 34 |
| App\Entity\Article | 33 |
| App\Entity\Actualite | 22 |
| App\Entity\Thematique | 15 |
| App\Entity\CiblePublic | 2 |
| App\Entity\Accueil | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Article | No errors. |
| App\Entity\CiblePublic | No errors. |
| App\Entity\MotCle | No errors. |
| App\Entity\ArticleFichierJoint | No errors. |
| App\Entity\Accueil | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\AccueilPro | No errors. |
| App\Entity\VerrouillageContenu | No errors. |
| App\Entity\RemembermeToken | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Actualite | No errors. |
| App\Entity\DomaineInformation | No errors. |
| App\Entity\DomaineAction | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\DomaineMobilite | No errors. |
| App\Entity\EvenementAgenda | No errors. |
| App\Entity\Reseaux | No errors. |
| App\Entity\MenuPro | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Thematique | No errors. |
| App\Entity\ActualiteFichierJoint | No errors. |