Query Metrics
14
Database Queries
11
Different statements
4.25 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.72 ms (16.82%) |
1 |
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.titre AS titre_3, t0.texte AS texte_4, t0.statut AS statut_5, t0.image AS image_6, t0.lien AS lien_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM services t0
Parameters:
[] |
|
0.71 ms (16.80%) |
2 |
SELECT g0_.id AS id_0, g0_.libelle_dossier AS libelle_dossier_1, g0_.titre_dossier AS titre_dossier_2, g0_.presentation_dossier AS presentation_dossier_3, g0_.images_dossier AS images_dossier_4, g0_.articles_lies AS articles_lies_5, g0_.galeries_lies AS galeries_lies_6, g0_.videos_lies AS videos_lies_7, g0_.audios_lies AS audios_lies_8, g0_.documents_lies AS documents_lies_9, g0_.statut AS statut_10, g0_.created_at AS created_at_11, g0_.updated_at AS updated_at_12 FROM grands_dossiers g0_ WHERE g0_.statut = ? ORDER BY g0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.51 ms (12.04%) |
2 |
SELECT a0_.id AS id_0, a0_.libelle_event AS libelle_event_1, a0_.date_debut_event AS date_debut_event_2, a0_.date_fin_event AS date_fin_event_3, a0_.heure_event AS heure_event_4, a0_.statut AS statut_5, a0_.created_at AS created_at_6, a0_.updated_at AS updated_at_7 FROM agendas a0_ WHERE a0_.date_debut_event <= ? AND a0_.date_fin_event >= ? ORDER BY a0_.date_debut_event ASC
Parameters:
[ "2026-05-31" "2026-05-31" ] |
|
0.46 ms (10.77%) |
2 |
SELECT v0_.id AS id_0, v0_.titre AS titre_1, v0_.code_lien AS code_lien_2, v0_.statut AS statut_3, v0_.id_categorie_video AS id_categorie_video_4, v0_.type AS type_5, v0_.intro AS intro_6, v0_.created_at AS created_at_7, v0_.updated_at AS updated_at_8 FROM videos v0_ WHERE v0_.statut = ? ORDER BY v0_.id DESC LIMIT 4
Parameters:
[
"oui"
]
|
|
0.35 ms (8.21%) |
1 |
SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.libelle AS libelle_2, f0_.statut AS statut_3, f0_.important AS important_4, f0_.created_at AS created_at_5, f0_.updated_at AS updated_at_6 FROM flashes f0_ WHERE f0_.statut = ? ORDER BY f0_.created_at DESC
Parameters:
[
"oui"
]
|
|
0.31 ms (7.25%) |
1 |
SELECT a0_.id AS id_0, a0_.titre_article AS titre_article_1, a0_.sous_titre_article AS sous_titre_article_2, a0_.texte_article AS texte_article_3, a0_.statut_article AS statut_article_4, a0_.a_la_une AS a_la_une_5, a0_.img_article AS img_article_6, a0_.date_article AS date_article_7, a0_.id_categorie_article AS id_categorie_article_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10 FROM articles a0_ WHERE a0_.statut_article = ? ORDER BY a0_.date_article DESC
Parameters:
[
"Oui"
]
|
|
0.29 ms (6.78%) |
1 |
SELECT c0_.id AS id_0, c0_.libelle_ministere AS libelle_ministere_1, c0_.logo_ministere AS logo_ministere_2, c0_.logo_blanc_noir AS logo_blanc_noir_3, c0_.adresse AS adresse_4, c0_.telephone AS telephone_5, c0_.fax AS fax_6, c0_.e_mail AS e_mail_7, c0_.gmaps AS gmaps_8, c0_.statut AS statut_9, c0_.created_at AS created_at_10, c0_.updated_at AS updated_at_11 FROM contacts c0_ WHERE c0_.statut = ? LIMIT 1
Parameters:
[
"active"
]
|
|
0.25 ms (5.93%) |
1 |
SELECT n0_.id AS id_0, n0_.nom AS nom_1, n0_.email AS email_2, n0_.statut AS statut_3 FROM newsletters n0_ WHERE n0_.statut = ? ORDER BY n0_.id DESC
Parameters:
[
"actif"
]
|
|
0.23 ms (5.29%) |
1 |
SELECT m0_.id AS id_0, m0_.libelle AS libelle_1, m0_.parametre AS parametre_2, m0_.texte AS texte_3, m0_.image AS image_4, m0_.statut AS statut_5, m0_.created_at AS created_at_6, m0_.updated_at AS updated_at_7 FROM ministeres m0_ WHERE m0_.statut = ? ORDER BY m0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.22 ms (5.15%) |
1 |
SELECT c0_.id AS id_0, c0_.libelle_categorie AS libelle_categorie_1, c0_.statut_categorie AS statut_categorie_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM categories_articles c0_ WHERE c0_.statut_categorie = ? ORDER BY c0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.21 ms (4.96%) |
1 |
SELECT r0_.id AS id_0, r0_.facebook AS facebook_1, r0_.twitter AS twitter_2, r0_.instagram AS instagram_3, r0_.tiktok AS tiktok_4, r0_.linkedin AS linkedin_5, r0_.youtube AS youtube_6, r0_.created_at AS created_at_7, r0_.updated_at AS updated_at_8 FROM reseaux r0_ LIMIT 1
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| bd_gouvci | doctrine.dbal.bd_gouvci_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| bd_gouvci | doctrine.orm.bd_gouvci_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Service | 4 |
| App\Entity\Article | 4 |
| App\Entity\Video | 4 |
| App\Entity\Flash | 3 |
| App\Entity\Ministere | 2 |
| App\Entity\CategorieArticle | 2 |
| App\Entity\GrandDossier | 2 |
| App\Entity\Contact | 1 |
| App\Entity\Reseau | 1 |
| App\Entity\Agenda | 1 |
bd_gouvci entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Service | No errors. |
| App\Entity\Flash | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\Ministere | No errors. |
| App\Entity\CategorieArticle | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\GrandDossier | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Reseau | No errors. |
| App\Entity\Agenda | No errors. |
| App\Entity\Video | No errors. |
bd_gouvci entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Newsletter | No errors. |