Error 422 Unprocessable Content

POST https://sigrh.metfp.mg/agents/9566/emploi-du-temps/creneau

Query Metrics

12 Database Queries
8 Different statements
6.17 ms Query time
0 Invalid entities
42 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.00 ms
(48.63%)
5
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.statut AS statut_4, t0.im AS im_5, t0.cin AS cin_6, t0.date_naissance AS date_naissance_7, t0.lieu_delivrance AS lieu_delivrance_8, t0.infos AS infos_9, t0.corps AS corps_10, t0.num_decision AS num_decision_11, t0.ref_dossier AS ref_dossier_12, t0.date_reception_dossier AS date_reception_dossier_13, t0.lieu_naissance AS lieu_naissance_14, t0.date_cin AS date_cin_15, t0.sexe AS sexe_16, t0.situation_matrimoniale AS situation_matrimoniale_17, t0.poste AS poste_18, t0.categorie_emploi AS categorie_emploi_19, t0.categorie AS categorie_20, t0.date_diplome AS date_diplome_21, t0.ecole_universite AS ecole_universite_22, t0.date_equivalence AS date_equivalence_23, t0.numero_casier AS numero_casier_24, t0.date_casier AS date_casier_25, t0.adresse AS adresse_26, t0.email AS email_27, t0.telephone AS telephone_28, t0.grade AS grade_29, t0.date_entree AS date_entree_30, t0.anciennete AS anciennete_31, t0.type_matiere AS type_matiere_32, t0.volume_horaire AS volume_horaire_33, t0.competences AS competences_34, t0.matieres AS matieres_35, t0.experience AS experience_36, t0.proximite AS proximite_37, t0.fichier_name AS fichier_name_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.note_anciennete AS note_anciennete_41, t0.note_specialite AS note_specialite_42, t0.note_volume_horaire AS note_volume_horaire_43, t0.note_diplome AS note_diplome_44, t0.note_age AS note_age_45, t0.note_experience AS note_experience_46, t0.note_proximite AS note_proximite_47, t0.note_total AS note_total_48, t0.is_recrute AS is_recrute_49, t0.statut_recrutement AS statut_recrutement_50, t0.indice AS indice_51, t0.recrute_le AS recrute_le_52, t0.rang AS rang_53, t0.region_id AS region_id_54, t0.etablissement_id AS etablissement_id_55, t0.diplome_id AS diplome_id_56, t0.specialite_id AS specialite_id_57, t0.secteur_id AS secteur_id_58, t0.region_residence_id AS region_residence_id_59, t0.district_id AS district_id_60, t0.commune_id AS commune_id_61, t0.fokontany_id AS fokontany_id_62, t0.recrutement_id AS recrutement_id_63, t0.created_by_id AS created_by_id_64, t0.updated_by_id AS updated_by_id_65, t0.import_execution_id AS import_execution_id_66 FROM personne t0 WHERE t0.id = ?
Parameters:
[
  "9566"
]
0.70 ms
(11.33%)
1
SELECT e0_.id AS id_0, e0_.annee AS annee_1, e0_.jour AS jour_2, e0_.heure_debut AS heure_debut_3, e0_.heure_fin AS heure_fin_4, e0_.module AS module_5, e0_.groupe AS groupe_6, e0_.salle AS salle_7, e0_.observation AS observation_8, e0_.created_at AS created_at_9, e0_.personne_id AS personne_id_10, e0_.created_by_id AS created_by_id_11 FROM emploi_du_temps e0_ INNER JOIN personne p1_ ON e0_.personne_id = p1_.id WHERE p1_.etablissement_id = ? AND e0_.annee = ? AND e0_.jour = ? AND p1_.id <> ?
Parameters:
[
  55
  2026
  "lundi"
  9566
]
0.61 ms
(9.92%)
1
UPDATE user_session SET last_activity_at = ? WHERE id = ?
Parameters:
[
  "2026-11-09 13:33:24"
  439
]
0.56 ms
(8.99%)
1
SELECT t0.id AS id_1, t0.session_hash AS session_hash_2, t0.statut AS statut_3, t0.created_at AS created_at_4, t0.last_activity_at AS last_activity_at_5, t0.closed_at AS closed_at_6, t0.ip AS ip_7, t0.user_agent AS user_agent_8, t0.user_id AS user_id_9, t0.closed_by_id AS closed_by_id_10 FROM user_session t0 WHERE t0.session_hash = ? LIMIT 1
Parameters:
[
  "679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41"
]
0.47 ms
(7.55%)
1
SELECT e0_.id AS id_0, e0_.annee AS annee_1, e0_.jour AS jour_2, e0_.heure_debut AS heure_debut_3, e0_.heure_fin AS heure_fin_4, e0_.module AS module_5, e0_.groupe AS groupe_6, e0_.salle AS salle_7, e0_.observation AS observation_8, e0_.created_at AS created_at_9, e0_.personne_id AS personne_id_10, e0_.created_by_id AS created_by_id_11 FROM emploi_du_temps e0_ WHERE e0_.personne_id = ? AND e0_.annee = ?
Parameters:
[
  9566
  2026
]
0.32 ms
(5.14%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.role AS role_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_active AS is_active_7, t0.permissions AS permissions_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_verified AS is_verified_11, t0.region_id AS region_id_12, t0.entity_id AS entity_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
  103
]
0.28 ms
(4.50%)
1
SELECT r0_.role AS role_0, r0_.menu_cle AS menu_cle_1 FROM role_menu r0_
Parameters:
[]
0.24 ms
(3.94%)
1
SELECT t0.id AS id_1, t0.cle AS cle_2, t0.valeur AS valeur_3, t0.modifie_le AS modifie_le_4, t0.modifie_par_id AS modifie_par_id_5 FROM parametre t0
Parameters:
[]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CreneauEmploiDuTemps 15
App\Entity\Personne 8
App\Entity\Diplome 4
App\Entity\Secteur 3
App\Entity\Fokontany 3
App\Entity\PosteBudgetaire 2
App\Entity\User 1
App\Entity\StructureAdministrative 1
App\Entity\UserSession 1
App\Entity\Etablissement 1
App\Entity\Region 1
App\Entity\District 1
App\Entity\Commune 1