Symfony Profiler

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 = ?

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 = '9566';

SELECT
  p0_.id AS id_0,
  p0_.nom AS nom_1,
  p0_.prenom AS prenom_2
FROM
  personne p0_
WHERE
  p0_.etablissement_id = ?
  AND (
    p0_.statut = ?
    OR p0_.categorie_emploi = ?
    OR (
      p0_.categorie_emploi IS NULL
      AND p0_.poste = ?
    )
  )
  AND p0_.region_id = ?
ORDER BY
  p0_.nom ASC,
  p0_.prenom ASC

SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.prenom AS prenom_2 FROM personne p0_ WHERE p0_.etablissement_id = 55 AND (p0_.statut = 'Vacataire' OR p0_.categorie_emploi = 'formateur' OR (p0_.categorie_emploi IS NULL AND p0_.poste = 'formateur')) AND p0_.region_id = 24 ORDER BY p0_.nom ASC, p0_.prenom ASC;

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

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 = '679094d6f8eb43b1d18a04222015ec9d95c2fe92518f1b6d6f4917803166cc41' LIMIT 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 = ?

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 = 9566 AND e0_.annee = 2026;

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 = ?

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 = 103;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.is_active AS is_active_6,
  t0.type AS type_7,
  t0.quota AS quota_8,
  t0.effectif_fpi AS effectif_fpi_9,
  t0.effectif_fqq AS effectif_fqq_10,
  t0.timetable AS timetable_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.region_id AS region_id_14,
  t0.district_id AS district_id_15
FROM
  etablissement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.is_active AS is_active_6, t0.type AS type_7, t0.quota AS quota_8, t0.effectif_fpi AS effectif_fpi_9, t0.effectif_fqq AS effectif_fqq_10, t0.timetable AS timetable_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.region_id AS region_id_14, t0.district_id AS district_id_15 FROM etablissement t0 WHERE t0.id = 55;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.is_active AS is_active_3,
  t0.created_at AS created_at_4
FROM
  specialite t0
  INNER JOIN personne_specialite ON t0.id = personne_specialite.specialite_id
WHERE
  personne_specialite.personne_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_active AS is_active_3, t0.created_at AS created_at_4 FROM specialite t0 INNER JOIN personne_specialite ON t0.id = personne_specialite.specialite_id WHERE personne_specialite.personne_id = 9566;

SELECT
  r0_.role AS role_0,
  r0_.menu_cle AS menu_cle_1
FROM
  role_menu r0_

SELECT r0_.role AS role_0, r0_.menu_cle AS menu_cle_1 FROM role_menu r0_;

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

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;