Query Metrics
70
Database Queries
6
Different statements
13.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.55 ms (57.90%) |
33 |
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
]
|
|
2.91 ms (22.35%) |
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.08 ms (8.29%) |
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_.publication = ? AND (a0_.date_fin_publication >= CURRENT_DATE OR a0_.date_fin_publication IS NULL) ORDER BY a0_.date_debut_publication DESC LIMIT 3
Parameters:
[ 4 6 1 ] |
|
0.80 ms (6.11%) |
1 |
SELECT t0.id AS id_1, t0.intitule AS intitule_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 FROM mot_cle t0 INNER JOIN actualite_mot_cle ON t0.id = actualite_mot_cle.mot_cle_id WHERE actualite_mot_cle.actualite_id = ?
Parameters:
[
181
]
|
|
0.47 ms (3.62%) |
1 |
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.date_debut_publication AS date_debut_publication_5, t0.descriptif AS descriptif_6, t0.date_fin_publication AS date_fin_publication_7, t0.a_la_une AS a_la_une_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.thematique_id AS thematique_id_15, t0.cible_id AS cible_id_16 FROM actualite t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"inclusion-donne-ton-opinion-en-repondant-au-sondage-provox"
]
|
|
0.23 ms (1.73%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.fichier AS fichier_3, t0.updated_fichier_at AS updated_fichier_at_4, t0.actualite_id AS actualite_id_5 FROM actualite_fichier_joint t0 WHERE t0.actualite_id = ?
Parameters:
[
181
]
|
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\Actualite | No errors. |
| App\Entity\Thematique | No errors. |
| App\Entity\CiblePublic | No errors. |
| App\Entity\MotCle | No errors. |
| App\Entity\ActualiteFichierJoint | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\ArticleFichierJoint | 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\DomaineInformation | No errors. |
| App\Entity\Accueil | 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. |