GET https://web.fonctionpublique.gouv.ci/

Query Metrics

38 Database Queries
30 Different statements
11.08 ms Query time
0 Invalid entities
1091 Managed entities

Grouped Statements

Show all queries

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.