Symfony Profiler

SELECT
  t0.id_affectation AS id_affectation_1,
  t0.libelle_affectation AS libelle_affectation_2,
  t0.code_region AS code_region_3,
  t0.dom AS dom_4,
  t0.tom AS tom_5,
  t0.date_activation AS date_activation_6,
  t0.date_desactivation AS date_desactivation_7,
  t0.r_ser_ident AS r_ser_ident_8,
  t0.libelle_long AS libelle_long_9,
  t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10,
  t0.calendrier_scolaire AS calendrier_scolaire_11,
  t0.date_bascule AS date_bascule_12,
  t0.date_debut_credit AS date_debut_credit_13,
  t0.date_fin_credit AS date_fin_credit_14,
  t0.date_fin_debit AS date_fin_debit_15,
  t0.date_debut_debit AS date_debut_debit_16
FROM
  ref_affectation t0
WHERE
  t0.id_affectation = ?
LIMIT
  1

SELECT t0.id_affectation AS id_affectation_1, t0.libelle_affectation AS libelle_affectation_2, t0.code_region AS code_region_3, t0.dom AS dom_4, t0.tom AS tom_5, t0.date_activation AS date_activation_6, t0.date_desactivation AS date_desactivation_7, t0.r_ser_ident AS r_ser_ident_8, t0.libelle_long AS libelle_long_9, t0.text_DGCS_dr_ds AS text_dgcs_dr_ds_10, t0.calendrier_scolaire AS calendrier_scolaire_11, t0.date_bascule AS date_bascule_12, t0.date_debut_credit AS date_debut_credit_13, t0.date_fin_credit AS date_fin_credit_14, t0.date_fin_debit AS date_fin_debit_15, t0.date_debut_debit AS date_debut_debit_16 FROM ref_affectation t0 WHERE t0.id_affectation = 38 LIMIT 1;

SELECT
  t0.id_information_personnelle AS id_information_personnelle_1,
  t0.id_utilisateur AS id_utilisateur_2,
  t0.civilite AS civilite_3,
  t0.prenom AS prenom_4,
  t0.nom AS nom_5,
  t0.date_de_naissance AS date_de_naissance_6,
  t0.login AS login_7,
  t0.mot_de_passe AS mot_de_passe_8,
  t0.utilisateur_actif AS utilisateur_actif_9,
  t0.fonction AS fonction_10,
  t0.date_fin_droits AS date_fin_droits_11,
  t0.tentative AS tentative_12,
  t0.adresse AS adresse_13,
  t0.grade AS grade_14,
  t0.indice_majore AS indice_majore_15,
  t0.date_blocage AS date_blocage_16,
  t0.token AS token_17,
  t0.jeton_mdp AS jeton_mdp_18,
  t0.courriel_mdp AS courriel_mdp_19,
  t0.navigation AS navigation_20,
  t0.date_maj_mdp AS date_maj_mdp_21,
  t0.id_utilisateur AS id_utilisateur_22,
  t0.id_affectation AS id_affectation_23,
  t0.id_federation AS id_federation_24,
  t0.id_fop AS id_fop_25,
  t0.id_foprinci AS id_foprinci_26,
  t0.id_lieu AS id_lieu_27,
  t0.id_odm_cadre_general AS id_odm_cadre_general_28,
  t0.id_poste AS id_poste_29,
  t0.id_scan AS id_scan_30
FROM
  utilisateur_information t0
WHERE
  t0.id_utilisateur = ?
LIMIT
  1

SELECT t0.id_information_personnelle AS id_information_personnelle_1, t0.id_utilisateur AS id_utilisateur_2, t0.civilite AS civilite_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.date_de_naissance AS date_de_naissance_6, t0.login AS login_7, t0.mot_de_passe AS mot_de_passe_8, t0.utilisateur_actif AS utilisateur_actif_9, t0.fonction AS fonction_10, t0.date_fin_droits AS date_fin_droits_11, t0.tentative AS tentative_12, t0.adresse AS adresse_13, t0.grade AS grade_14, t0.indice_majore AS indice_majore_15, t0.date_blocage AS date_blocage_16, t0.token AS token_17, t0.jeton_mdp AS jeton_mdp_18, t0.courriel_mdp AS courriel_mdp_19, t0.navigation AS navigation_20, t0.date_maj_mdp AS date_maj_mdp_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_affectation AS id_affectation_23, t0.id_federation AS id_federation_24, t0.id_fop AS id_fop_25, t0.id_foprinci AS id_foprinci_26, t0.id_lieu AS id_lieu_27, t0.id_odm_cadre_general AS id_odm_cadre_general_28, t0.id_poste AS id_poste_29, t0.id_scan AS id_scan_30 FROM utilisateur_information t0 WHERE t0.id_utilisateur = 4426 LIMIT 1;

SELECT
  u0_.nom AS nom_0,
  u0_.prenom AS prenom_1,
  r1_.libelle_poste AS libelle_poste_2,
  r2_.libelle_long AS libelle_long_3,
  u0_.id_federation AS sclr_4,
  (
    SELECT
      c3_.nb_jour_total
    FROM
      conge_droit_annuel c3_
      INNER JOIN conge_type c4_ ON c3_.id_conge_type = c4_.id
    WHERE
      c3_.id_utilisateur = u0_.id_utilisateur
      AND c3_.annee = ?
      AND c3_.archive = ?
      AND c4_.code = ?
  ) AS sclr_5,
  (
    SELECT
      sum(c5_.nb_jour) AS sclr_7
    FROM
      conge c5_
      INNER JOIN conge_type c6_ ON c5_.id_conge_type = c6_.id
    WHERE
      c5_.id_utilisateur = u0_.id_utilisateur
      AND c5_.date_debut >= ?
      AND c5_.date_debut <= ?
      AND c6_.code = ?
      AND c5_.id_workflow IN (?, ?, ?)
  ) AS sclr_6,
  (
    SELECT
      c7_.nb_jour_total
    FROM
      conge_droit_annuel c7_
      INNER JOIN conge_type c8_ ON c7_.id_conge_type = c8_.id
    WHERE
      c7_.id_utilisateur = u0_.id_utilisateur
      AND c7_.annee = ?
      AND c7_.archive = ?
      AND c8_.code = ?
  ) AS sclr_8,
  (
    SELECT
      c9_.nb_jour_total
    FROM
      conge_droit_annuel c9_
      INNER JOIN conge_type c10_ ON c9_.id_conge_type = c10_.id
    WHERE
      c9_.id_utilisateur = u0_.id_utilisateur
      AND c9_.annee = ?
      AND c9_.archive = ?
      AND c10_.code = ?
  ) AS sclr_9,
  (
    SELECT
      sum(c11_.nb_jour) AS sclr_11
    FROM
      conge c11_
      INNER JOIN conge_type c12_ ON c11_.id_conge_type = c12_.id
    WHERE
      c11_.id_utilisateur = u0_.id_utilisateur
      AND c11_.date_debut >= ?
      AND c11_.date_debut <= ?
      AND c12_.code = ?
      AND c11_.id_workflow IN (?, ?, ?)
  ) AS sclr_10,
  (
    SELECT
      sum(c13_.nb_jour) AS sclr_13
    FROM
      conge c13_
      INNER JOIN conge_type c14_ ON c13_.id_conge_type = c14_.id
    WHERE
      c13_.id_utilisateur = u0_.id_utilisateur
      AND c13_.date_debut >= ?
      AND c13_.date_debut <= ?
      AND c14_.code = ?
      AND c13_.id_workflow IN (?, ?, ?)
  ) AS sclr_12,
  (
    SELECT
      sum(c15_.nb_jour) AS sclr_15
    FROM
      conge c15_
      INNER JOIN conge_type c16_ ON c15_.id_conge_type = c16_.id
    WHERE
      c15_.id_utilisateur = u0_.id_utilisateur
      AND c15_.date_debut >= ?
      AND c15_.date_debut <= ?
      AND c16_.code = ?
      AND c15_.id_workflow IN (?, ?, ?)
  ) AS sclr_14,
  (
    SELECT
      c17_.nb_jour_fractionnement
    FROM
      conge_droit_annuel c17_
      INNER JOIN conge_type c18_ ON c17_.id_conge_type = c18_.id
    WHERE
      c17_.id_utilisateur = u0_.id_utilisateur
      AND c17_.annee = ?
      AND c17_.archive = ?
      AND c18_.code = ?
  ) AS sclr_16,
  (
    SELECT
      c19_.nb_jour_total
    FROM
      conge_droit_annuel c19_
      INNER JOIN conge_type c20_ ON c19_.id_conge_type = c20_.id
    WHERE
      c19_.id_utilisateur = u0_.id_utilisateur
      AND c19_.annee = ?
      AND c19_.archive = ?
      AND c20_.code = ?
  ) AS sclr_17,
  (
    SELECT
      sum(c21_.nb_jour) AS sclr_19
    FROM
      conge c21_
      INNER JOIN conge_type c22_ ON c21_.id_conge_type = c22_.id
    WHERE
      c21_.id_utilisateur = u0_.id_utilisateur
      AND c21_.date_debut >= ?
      AND c21_.date_debut <= ?
      AND c22_.code = ?
      AND c21_.id_workflow IN (?, ?, ?)
  ) AS sclr_18,
  (
    SELECT
      c23_.nb_jour_total
    FROM
      conge_droit_annuel c23_
      INNER JOIN conge_type c24_ ON c23_.id_conge_type = c24_.id
    WHERE
      c23_.annee = ?
      AND c23_.id_utilisateur = u0_.id_utilisateur
      AND c23_.archive = ?
      AND c24_.code = ?
  ) AS sclr_20,
  (
    SELECT
      sum(c25_.nb_jour) AS sclr_22
    FROM
      conge c25_
      INNER JOIN conge_type c26_ ON c25_.id_conge_type = c26_.id
    WHERE
      c25_.id_utilisateur = u0_.id_utilisateur
      AND c25_.date_debut >= ?
      AND c25_.date_debut <= ?
      AND c26_.code = ?
      AND c25_.id_workflow IN (?, ?, ?)
  ) AS sclr_21,
  (
    SELECT
      sum(d27_.nb_jour) AS sclr_24
    FROM
      demande_report d27_
    WHERE
      d27_.utilisateur = u0_.id_utilisateur
      AND d27_.annee = ?
      AND d27_.workflow IN (?, ?, ?)
  ) AS sclr_23
FROM
  utilisateur_information u0_
  INNER JOIN ref_poste r1_ ON u0_.id_poste = r1_.id_poste
  INNER JOIN ref_affectation r2_ ON u0_.id_affectation = r2_.id_affectation
WHERE
  u0_.id_utilisateur = ?

SELECT u0_.nom AS nom_0, u0_.prenom AS prenom_1, r1_.libelle_poste AS libelle_poste_2, r2_.libelle_long AS libelle_long_3, u0_.id_federation AS sclr_4, (SELECT c3_.nb_jour_total FROM conge_droit_annuel c3_ INNER JOIN conge_type c4_ ON c3_.id_conge_type = c4_.id WHERE c3_.id_utilisateur = u0_.id_utilisateur AND c3_.annee = 2024 AND c3_.archive = 0 AND c4_.code = 'CAN') AS sclr_5, (SELECT sum(c5_.nb_jour) AS sclr_7 FROM conge c5_ INNER JOIN conge_type c6_ ON c5_.id_conge_type = c6_.id WHERE c5_.id_utilisateur = u0_.id_utilisateur AND c5_.date_debut >= '2024-09-01 00:00:00' AND c5_.date_debut <= '2025-08-31 00:00:00' AND c6_.code = 'CAN' AND c5_.id_workflow IN (17, 21, 31)) AS sclr_6, (SELECT c7_.nb_jour_total FROM conge_droit_annuel c7_ INNER JOIN conge_type c8_ ON c7_.id_conge_type = c8_.id WHERE c7_.id_utilisateur = u0_.id_utilisateur AND c7_.annee = 2024 AND c7_.archive = 0 AND c8_.code = 'RTT') AS sclr_8, (SELECT c9_.nb_jour_total FROM conge_droit_annuel c9_ INNER JOIN conge_type c10_ ON c9_.id_conge_type = c10_.id WHERE c9_.id_utilisateur = u0_.id_utilisateur AND c9_.annee = 2024 AND c9_.archive = 0 AND c10_.code = 'RAA') AS sclr_9, (SELECT sum(c11_.nb_jour) AS sclr_11 FROM conge c11_ INNER JOIN conge_type c12_ ON c11_.id_conge_type = c12_.id WHERE c11_.id_utilisateur = u0_.id_utilisateur AND c11_.date_debut >= '2024-09-01 00:00:00' AND c11_.date_debut <= '2025-08-31 00:00:00' AND c12_.code = 'RAA' AND c11_.id_workflow IN (17, 21, 31)) AS sclr_10, (SELECT sum(c13_.nb_jour) AS sclr_13 FROM conge c13_ INNER JOIN conge_type c14_ ON c13_.id_conge_type = c14_.id WHERE c13_.id_utilisateur = u0_.id_utilisateur AND c13_.date_debut >= '2024-09-01 00:00:00' AND c13_.date_debut <= '2025-08-31 00:00:00' AND c14_.code = 'RTT' AND c13_.id_workflow IN (17, 21, 31)) AS sclr_12, (SELECT sum(c15_.nb_jour) AS sclr_15 FROM conge c15_ INNER JOIN conge_type c16_ ON c15_.id_conge_type = c16_.id WHERE c15_.id_utilisateur = u0_.id_utilisateur AND c15_.date_debut >= '2024-09-01 00:00:00' AND c15_.date_debut <= '2025-08-31 00:00:00' AND c16_.code = 'CEX' AND c15_.id_workflow IN (17, 21, 31)) AS sclr_14, (SELECT c17_.nb_jour_fractionnement FROM conge_droit_annuel c17_ INNER JOIN conge_type c18_ ON c17_.id_conge_type = c18_.id WHERE c17_.id_utilisateur = u0_.id_utilisateur AND c17_.annee = 2024 AND c17_.archive = 0 AND c18_.code = 'CAN') AS sclr_16, (SELECT c19_.nb_jour_total FROM conge_droit_annuel c19_ INNER JOIN conge_type c20_ ON c19_.id_conge_type = c20_.id WHERE c19_.id_utilisateur = u0_.id_utilisateur AND c19_.annee = 2023 AND c19_.archive = 0 AND c20_.code = 'CAN') AS sclr_17, (SELECT sum(c21_.nb_jour) AS sclr_19 FROM conge c21_ INNER JOIN conge_type c22_ ON c21_.id_conge_type = c22_.id WHERE c21_.id_utilisateur = u0_.id_utilisateur AND c21_.date_debut >= '2023-09-01 00:00:00' AND c21_.date_debut <= '2024-08-31 00:00:00' AND c22_.code = 'CAN' AND c21_.id_workflow IN (17, 21, 31)) AS sclr_18, (SELECT c23_.nb_jour_total FROM conge_droit_annuel c23_ INNER JOIN conge_type c24_ ON c23_.id_conge_type = c24_.id WHERE c23_.annee = 2024 AND c23_.id_utilisateur = u0_.id_utilisateur AND c23_.archive = 0 AND c24_.code = 'CET') AS sclr_20, (SELECT sum(c25_.nb_jour) AS sclr_22 FROM conge c25_ INNER JOIN conge_type c26_ ON c25_.id_conge_type = c26_.id WHERE c25_.id_utilisateur = u0_.id_utilisateur AND c25_.date_debut >= '2024-09-01 00:00:00' AND c25_.date_debut <= '2025-08-31 00:00:00' AND c26_.code = 'CET' AND c25_.id_workflow IN (17, 21, 31)) AS sclr_21, (SELECT sum(d27_.nb_jour) AS sclr_24 FROM demande_report d27_ WHERE d27_.utilisateur = u0_.id_utilisateur AND d27_.annee = 2024 AND d27_.workflow IN (17, 21, 31)) AS sclr_23 FROM utilisateur_information u0_ INNER JOIN ref_poste r1_ ON u0_.id_poste = r1_.id_poste INNER JOIN ref_affectation r2_ ON u0_.id_affectation = r2_.id_affectation WHERE u0_.id_utilisateur = 4426;

SELECT
  t0.id_information_personnelle AS id_information_personnelle_1,
  t0.id_utilisateur AS id_utilisateur_2,
  t0.civilite AS civilite_3,
  t0.prenom AS prenom_4,
  t0.nom AS nom_5,
  t0.date_de_naissance AS date_de_naissance_6,
  t0.login AS login_7,
  t0.mot_de_passe AS mot_de_passe_8,
  t0.utilisateur_actif AS utilisateur_actif_9,
  t0.fonction AS fonction_10,
  t0.date_fin_droits AS date_fin_droits_11,
  t0.tentative AS tentative_12,
  t0.adresse AS adresse_13,
  t0.grade AS grade_14,
  t0.indice_majore AS indice_majore_15,
  t0.date_blocage AS date_blocage_16,
  t0.token AS token_17,
  t0.jeton_mdp AS jeton_mdp_18,
  t0.courriel_mdp AS courriel_mdp_19,
  t0.navigation AS navigation_20,
  t0.date_maj_mdp AS date_maj_mdp_21,
  t0.id_utilisateur AS id_utilisateur_22,
  t0.id_affectation AS id_affectation_23,
  t0.id_federation AS id_federation_24,
  t0.id_fop AS id_fop_25,
  t0.id_foprinci AS id_foprinci_26,
  t0.id_lieu AS id_lieu_27,
  t0.id_odm_cadre_general AS id_odm_cadre_general_28,
  t0.id_poste AS id_poste_29,
  t0.id_scan AS id_scan_30
FROM
  utilisateur_information t0
WHERE
  t0.id_information_personnelle = ?

SELECT t0.id_information_personnelle AS id_information_personnelle_1, t0.id_utilisateur AS id_utilisateur_2, t0.civilite AS civilite_3, t0.prenom AS prenom_4, t0.nom AS nom_5, t0.date_de_naissance AS date_de_naissance_6, t0.login AS login_7, t0.mot_de_passe AS mot_de_passe_8, t0.utilisateur_actif AS utilisateur_actif_9, t0.fonction AS fonction_10, t0.date_fin_droits AS date_fin_droits_11, t0.tentative AS tentative_12, t0.adresse AS adresse_13, t0.grade AS grade_14, t0.indice_majore AS indice_majore_15, t0.date_blocage AS date_blocage_16, t0.token AS token_17, t0.jeton_mdp AS jeton_mdp_18, t0.courriel_mdp AS courriel_mdp_19, t0.navigation AS navigation_20, t0.date_maj_mdp AS date_maj_mdp_21, t0.id_utilisateur AS id_utilisateur_22, t0.id_affectation AS id_affectation_23, t0.id_federation AS id_federation_24, t0.id_fop AS id_fop_25, t0.id_foprinci AS id_foprinci_26, t0.id_lieu AS id_lieu_27, t0.id_odm_cadre_general AS id_odm_cadre_general_28, t0.id_poste AS id_poste_29, t0.id_scan AS id_scan_30 FROM utilisateur_information t0 WHERE t0.id_information_personnelle = 2016;

SELECT
  *
FROM
  ref_affectation_calendrier rac
WHERE
  rac.id_aff = ?
  AND rac.date_bascule <= ?
ORDER BY
  rac.date_bascule ASC

SELECT *
            FROM ref_affectation_calendrier rac
            WHERE rac.id_aff = 38
            AND rac.date_bascule <= '2025-06-20'
            ORDER BY rac.date_bascule ASC
        ;

SELECT
  t0.id AS id_1,
  t0.nb_jour_fractionnement AS nb_jour_fractionnement_2,
  t0.nb_jour_total AS nb_jour_total_3,
  t0.annee AS annee_4,
  t0.archive AS archive_5,
  t0.type_calendrier AS type_calendrier_6,
  t0.id_utilisateur AS id_utilisateur_7,
  t0.id_conge_type AS id_conge_type_8
FROM
  conge_droit_annuel t0
WHERE
  t0.id_utilisateur = ?
  AND t0.annee = ?
  AND t0.archive = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nb_jour_fractionnement AS nb_jour_fractionnement_2, t0.nb_jour_total AS nb_jour_total_3, t0.annee AS annee_4, t0.archive AS archive_5, t0.type_calendrier AS type_calendrier_6, t0.id_utilisateur AS id_utilisateur_7, t0.id_conge_type AS id_conge_type_8 FROM conge_droit_annuel t0 WHERE t0.id_utilisateur = 4426 AND t0.annee = 2024 AND t0.archive = 0 LIMIT 1;

SELECT
  c0_.date_debut AS date_debut_0,
  c0_.date_fin AS date_fin_1,
  w1_.id_workflow AS id_workflow_2,
  c0_.nb_jour AS nb_jour_3,
  c2_.libelle AS libelle_4,
  c3_.libelle AS libelle_5,
  c4_.libelle AS libelle_6
FROM
  conge c0_
  INNER JOIN utilisateur u5_ ON c0_.id_utilisateur = u5_.id_utilisateur
  INNER JOIN utilisateur_information u6_ ON (
    c0_.id_utilisateur = u6_.id_utilisateur
  )
  INNER JOIN conge_type c2_ ON c0_.id_conge_type = c2_.id
  INNER JOIN workflow w1_ ON c0_.id_workflow = w1_.id_workflow
  INNER JOIN conge_date_type c3_ ON c0_.id_date_debut_type = c3_.id
  INNER JOIN conge_date_type c4_ ON c0_.id_date_fin_type = c4_.id
WHERE
  c0_.id_utilisateur = ?
  AND c0_.id_workflow IN (?, ?)
  AND (
    c0_.date_debut >= ?
    AND c0_.date_fin <= ?
  )
ORDER BY
  c0_.date_debut ASC

SELECT c0_.date_debut AS date_debut_0, c0_.date_fin AS date_fin_1, w1_.id_workflow AS id_workflow_2, c0_.nb_jour AS nb_jour_3, c2_.libelle AS libelle_4, c3_.libelle AS libelle_5, c4_.libelle AS libelle_6 FROM conge c0_ INNER JOIN utilisateur u5_ ON c0_.id_utilisateur = u5_.id_utilisateur INNER JOIN utilisateur_information u6_ ON (c0_.id_utilisateur = u6_.id_utilisateur) INNER JOIN conge_type c2_ ON c0_.id_conge_type = c2_.id INNER JOIN workflow w1_ ON c0_.id_workflow = w1_.id_workflow INNER JOIN conge_date_type c3_ ON c0_.id_date_debut_type = c3_.id INNER JOIN conge_date_type c4_ ON c0_.id_date_fin_type = c4_.id WHERE c0_.id_utilisateur = 4426 AND c0_.id_workflow IN (17, 21) AND (c0_.date_debut >= '2024-09-01 00:00:00' AND c0_.date_fin <= '2025-08-31 00:00:00') ORDER BY c0_.date_debut ASC;

SELECT
  r0_.r_adm_discipline_id AS r_adm_discipline_id_0,
  r0_.r_adm_diside AS r_adm_diside_1,
  r0_.r_adm_disdde AS r_adm_disdde_2,
  r0_.r_adm_disdfn AS r_adm_disdfn_3,
  r0_.r_adm_disact AS r_adm_disact_4,
  r0_.r_ser_libl AS r_ser_libl_5,
  r0_.r_ser_libc AS r_ser_libc_6,
  r0_.libelle_sport AS libelle_sport_7
FROM
  r_federation r0_
  INNER JOIN ref_federation r1_ ON (
    r1_.r_adm_diside = r0_.r_adm_diside
  )
WHERE
  r1_.id_federation = ?

SELECT r0_.r_adm_discipline_id AS r_adm_discipline_id_0, r0_.r_adm_diside AS r_adm_diside_1, r0_.r_adm_disdde AS r_adm_disdde_2, r0_.r_adm_disdfn AS r_adm_disdfn_3, r0_.r_adm_disact AS r_adm_disact_4, r0_.r_ser_libl AS r_ser_libl_5, r0_.r_ser_libc AS r_ser_libc_6, r0_.libelle_sport AS libelle_sport_7 FROM r_federation r0_ INNER JOIN ref_federation r1_ ON (r1_.r_adm_diside = r0_.r_adm_diside) WHERE r1_.id_federation = 62;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.texte AS texte_2
FROM
  parametrage_texte p0_
WHERE
  p0_.code LIKE ?

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.texte AS texte_2 FROM parametrage_texte p0_ WHERE p0_.code LIKE 'CONGE_COMMENTAIRE_1';

SELECT
  t0.id_utilisateur AS id_utilisateur_1,
  t0.id_role AS id_role_2,
  t0.courriel AS courriel_3,
  t0.p_civ_matcle AS p_civ_matcle_4,
  t0.date_connexion AS date_connexion_5,
  t0.date_creation AS date_creation_6,
  t0.droit_lm_utilisateur AS droit_lm_utilisateur_7,
  t0.telephone_bureau AS telephone_bureau_8,
  t0.telephone_portable AS telephone_portable_9,
  t0.alerte_identifiant AS alerte_identifiant_10,
  t0.restitution_cache AS restitution_cache_11,
  t0.first_pwd AS first_pwd_12,
  t0.fl_superieur_hierarchique AS fl_superieur_hierarchique_13,
  t0.id_role AS id_role_14
FROM
  utilisateur t0
WHERE
  t0.id_utilisateur = ?
LIMIT
  1

SELECT t0.id_utilisateur AS id_utilisateur_1, t0.id_role AS id_role_2, t0.courriel AS courriel_3, t0.p_civ_matcle AS p_civ_matcle_4, t0.date_connexion AS date_connexion_5, t0.date_creation AS date_creation_6, t0.droit_lm_utilisateur AS droit_lm_utilisateur_7, t0.telephone_bureau AS telephone_bureau_8, t0.telephone_portable AS telephone_portable_9, t0.alerte_identifiant AS alerte_identifiant_10, t0.restitution_cache AS restitution_cache_11, t0.first_pwd AS first_pwd_12, t0.fl_superieur_hierarchique AS fl_superieur_hierarchique_13, t0.id_role AS id_role_14 FROM utilisateur t0 WHERE t0.id_utilisateur = 4426 LIMIT 1;