GET https://web.fonctionpublique.gouv.ci/ministere/recherche/redeploiement

Query Metrics

14 Database Queries
11 Different statements
3.02 ms Query time
0 Invalid entities
20 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
0.43 ms
(14.29%)
1
SELECT t0.id AS id_1, t0.libelle_dossier AS libelle_dossier_2, t0.titre_dossier AS titre_dossier_3, t0.presentation_dossier AS presentation_dossier_4, t0.images_dossier AS images_dossier_5, t0.articles_lies AS articles_lies_6, t0.galeries_lies AS galeries_lies_7, t0.videos_lies AS videos_lies_8, t0.audios_lies AS audios_lies_9, t0.documents_lies AS documents_lies_10, t0.statut AS statut_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM grands_dossiers t0
Parameters:
[]
0.40 ms
(13.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.38 ms
(12.43%)
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.37 ms
(12.27%)
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.26 ms
(8.76%)
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.24 ms
(8.09%)
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.21 ms
(6.80%)
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.20 ms
(6.77%)
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.18 ms
(6.00%)
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.17 ms
(5.76%)
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.17 ms
(5.64%)
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\Article 4
App\Entity\Video 4
App\Entity\Flash 3
App\Entity\GrandDossier 2
App\Entity\Ministere 2
App\Entity\CategorieArticle 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\GrandDossier 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\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.