Query Metrics
38
Database Queries
30
Different statements
11.08 ms
Query time
0
Invalid entities
1091
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
2.02 ms (18.25%) |
1 |
SELECT m0_.id AS id_0, m0_.civilite AS civilite_1, m0_.nom AS nom_2, m0_.prenom AS prenom_3, m0_.email AS email_4, m0_.pays AS pays_5, m0_.ville AS ville_6, m0_.adresse AS adresse_7, m0_.objet AS objet_8, m0_.message AS message_9, m0_.created_at AS created_at_10, m0_.updated_at AS updated_at_11, m0_.statut AS statut_12 FROM messages m0_ WHERE m0_.statut IS NULL OR m0_.statut = ? ORDER BY m0_.created_at DESC
Parameters:
[
"non_lu"
]
|
|
0.90 ms (8.14%) |
2 |
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.titre AS titre_2, b0_.url AS url_3, b0_.image AS image_4, b0_.statut AS statut_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7 FROM backgrounds b0_ WHERE b0_.statut = ? LIMIT 1
Parameters:
[
"active"
]
|
|
0.61 ms (5.48%) |
3 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.titre AS titre_2, c0_.description AS description_3, c0_.image AS image_4, c0_.statut AS statut_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM chiffres c0_ WHERE c0_.statut = ? ORDER BY c0_.id ASC LIMIT 5
Parameters:
[
"oui"
]
|
|
0.51 ms (4.59%) |
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.48 ms (4.35%) |
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.46 ms (4.19%) |
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.45 ms (4.03%) |
2 |
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.43 ms (3.90%) |
2 |
SELECT i0_.id AS id_0, i0_.titre_images_articles AS titre_images_articles_1, i0_.sources_images_articles AS sources_images_articles_2, i0_.statut_images_articles AS statut_images_articles_3, i0_.id_article AS id_article_4, i0_.created_at AS created_at_5, i0_.updated_at AS updated_at_6 FROM images_articles i0_ ORDER BY i0_.id DESC
Parameters:
[] |
|
0.33 ms (3.01%) |
1 |
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.poste AS poste_2, m0_.biographie_texte AS biographie_texte_3, m0_.biographie_pdf AS biographie_pdf_4, m0_.mot AS mot_5, m0_.photo AS photo_6, m0_.cv AS cv_7, m0_.statut AS statut_8, m0_.created_at AS created_at_9, m0_.updated_at AS updated_at_10 FROM ministres m0_ WHERE m0_.statut = ? LIMIT 1
Parameters:
[
"en_fonction"
]
|
|
0.33 ms (2.94%) |
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 LIMIT 4
Parameters:
[
"Oui"
]
|
|
0.32 ms (2.87%) |
1 |
SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.libelle AS libelle_2, s0_.texte AS texte_3, s0_.image AS image_4, s0_.lien AS lien_5, s0_.nom_directeur AS nom_directeur_6, s0_.image_directeur AS image_directeur_7, s0_.statut AS statut_8, s0_.created_at AS created_at_9, s0_.updated_at AS updated_at_10 FROM structures s0_ WHERE s0_.statut = ? ORDER BY s0_.id ASC LIMIT 6
Parameters:
[
"active"
]
|
|
0.30 ms (2.75%) |
1 |
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.statut AS statut_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4 FROM types_publications t0_ WHERE t0_.statut = ? ORDER BY t0_.id ASC LIMIT 6
Parameters:
[
"active"
]
|
|
0.29 ms (2.59%) |
1 |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.poste AS poste_2, c0_.type AS type_3, c0_.photo AS photo_4, c0_.statut AS statut_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM cabinets c0_ WHERE c0_.statut = ? ORDER BY c0_.nom ASC
Parameters:
[
"active"
]
|
|
0.28 ms (2.50%) |
1 |
SELECT c0_.id AS id_0, c0_.expediteur AS expediteur_1, c0_.date AS date_2, c0_.objet AS objet_3, c0_.email AS email_4, c0_.nature AS nature_5, c0_.message AS message_6, c0_.nom_du_courier AS nom_du_courier_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9 FROM couriers c0_ ORDER BY c0_.created_at DESC LIMIT 5
Parameters:
[] |
|
0.27 ms (2.42%) |
1 |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.libelle AS libelle_2, p0_.description AS description_3, p0_.source AS source_4, p0_.cover AS cover_5, p0_.id_categorie_publication AS id_categorie_publication_6, p0_.statut AS statut_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM publications p0_ WHERE p0_.statut = ? ORDER BY p0_.id DESC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.26 ms (2.37%) |
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.24 ms (2.16%) |
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 (2.01%) |
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:
[] |
|
0.22 ms (1.99%) |
1 |
SELECT c0_.id AS id_0, c0_.libelle AS libelle_1, c0_.statut AS statut_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4 FROM categories_videos c0_ WHERE c0_.statut = ? ORDER BY c0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.22 ms (1.97%) |
1 |
SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.titre AS titre_2, s0_.texte AS texte_3, s0_.statut AS statut_4, s0_.image AS image_5, s0_.lien AS lien_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8 FROM services s0_ WHERE s0_.statut = ? ORDER BY s0_.id ASC
Parameters:
[
"active"
]
|
|
0.22 ms (1.96%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.libelle AS libelle_2, c0_.statut AS statut_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5 FROM categories_publications c0_ WHERE c0_.statut = ? ORDER BY c0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.22 ms (1.95%) |
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.21 ms (1.90%) |
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.20 ms (1.81%) |
1 |
SELECT t0_.id AS id_0, t0_.libelle AS libelle_1, t0_.status_type AS status_type_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4 FROM types_structures t0_ WHERE t0_.status_type = ? ORDER BY t0_.id ASC LIMIT 6
Parameters:
[
"active"
]
|
|
0.20 ms (1.80%) |
1 |
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.motsCles AS motsCles_2, s0_.categorie AS categorie_3, s0_.statut AS statut_4 FROM sites s0_ WHERE s0_.statut = ?
Parameters:
[
"oui"
]
|
|
0.20 ms (1.79%) |
1 |
SELECT d0_.id AS id_0, d0_.libelle AS libelle_1, d0_.parametre AS parametre_2, d0_.texte AS texte_3, d0_.image AS image_4, d0_.statut AS statut_5, d0_.created_at AS created_at_6, d0_.updated_at AS updated_at_7 FROM directions d0_ WHERE d0_.statut = ? ORDER BY d0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
|
0.20 ms (1.77%) |
1 |
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.source AS source_2, a0_.cover AS cover_3, a0_.statut AS statut_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6 FROM audios a0_ WHERE a0_.statut = ? ORDER BY a0_.created_at DESC
Parameters:
[
"active"
]
|
|
0.18 ms (1.59%) |
1 |
SELECT i0_.id AS id_0, i0_.etat AS etat_1 FROM intros i0_ WHERE i0_.etat = ? LIMIT 1
Parameters:
[
"1"
]
|
|
0.17 ms (1.52%) |
1 |
SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.titre AS titre_2, s0_.texte AS texte_3, s0_.statut AS statut_4, s0_.image AS image_5, s0_.lien AS lien_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8 FROM services s0_ WHERE s0_.statut = ? OR s0_.statut = ? ORDER BY s0_.id ASC
Parameters:
[ "oui" "active" ] |
|
0.16 ms (1.42%) |
1 |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.titre AS titre_2, c0_.description AS description_3, c0_.image AS image_4, c0_.statut AS statut_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7 FROM chiffres c0_ WHERE c0_.statut = ? ORDER BY c0_.id ASC LIMIT 6
Parameters:
[
"oui"
]
|
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\Message | 1025 |
| App\Entity\ImageArticle | 17 |
| App\Entity\Publication | 6 |
| App\Entity\CategoriePublication | 6 |
| App\Entity\Chiffre | 5 |
| App\Entity\Courier | 5 |
| App\Entity\Video | 4 |
| App\Entity\Article | 4 |
| App\Entity\Service | 4 |
| App\Entity\Flash | 3 |
| App\Entity\GrandDossier | 2 |
| App\Entity\CategorieArticle | 2 |
| App\Entity\Ministere | 2 |
| App\Entity\CategorieVideo | 2 |
| App\Entity\Agenda | 1 |
| App\Entity\Contact | 1 |
| App\Entity\Reseau | 1 |
| App\Entity\Intro | 1 |
bd_gouvci entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Background | No errors. |
| App\Entity\Chiffre | No errors. |
| App\Entity\Agenda | No errors. |
| App\Entity\GrandDossier | No errors. |
| App\Entity\ImageArticle | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Flash | No errors. |
| App\Entity\Reseau | No errors. |
| App\Entity\CategorieArticle | No errors. |
| App\Entity\Ministere | No errors. |
| App\Entity\TypeStructure | No errors. |
| App\Entity\TypePublication | No errors. |
| App\Entity\CategoriePublication | No errors. |
| App\Entity\Gouvci\Sites | No errors. |
| App\Entity\Direction | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Cabinet | No errors. |
| App\Entity\CategorieVideo | No errors. |
| App\Entity\Courier | No errors. |
| App\Entity\Message | No errors. |
| App\Entity\Ministre | No errors. |
| App\Entity\Newsletter | No errors. |
| App\Entity\Structure | No errors. |
| App\Entity\Audio | No errors. |
| App\Entity\Intro | No errors. |
bd_gouvci entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Newsletter | No errors. |