Symfony Profiler

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

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

SELECT
  t0.r_adm_discipline_id AS r_adm_discipline_id_1,
  t0.r_adm_diside AS r_adm_diside_2,
  t0.r_adm_disdde AS r_adm_disdde_3,
  t0.r_adm_disdfn AS r_adm_disdfn_4,
  t0.r_adm_disact AS r_adm_disact_5,
  t0.r_ser_libl AS r_ser_libl_6,
  t0.r_ser_libc AS r_ser_libc_7,
  t0.libelle_sport AS libelle_sport_8
FROM
  r_federation t0
WHERE
  t0.r_adm_diside = ?
LIMIT
  1

SELECT t0.r_adm_discipline_id AS r_adm_discipline_id_1, t0.r_adm_diside AS r_adm_diside_2, t0.r_adm_disdde AS r_adm_disdde_3, t0.r_adm_disdfn AS r_adm_disdfn_4, t0.r_adm_disact AS r_adm_disact_5, t0.r_ser_libl AS r_ser_libl_6, t0.r_ser_libc AS r_ser_libc_7, t0.libelle_sport AS libelle_sport_8 FROM r_federation t0 WHERE t0.r_adm_diside = 'NAT' LIMIT 1;

select
  *
from
  utilisateur us
  INNER JOIN utilisateur_information ui ON us.id_utilisateur = ui.id_utilisateur
  and ui.utilisateur_actif = true
  and (
    (
      us.id_role = 1
      or us.id_role = 3
      or us.id_role = 10
    )
    or (
      (
        us.id_role = 4
        or us.id_role = 11
      )
      and ui.id_affectation = 31
    )
    or (
      (
        us.id_role = 5
        or us.id_role = 8
        or us.id_role = 2
      )
      and ui.id_federation = 43
    )
  )

select * from utilisateur us
                INNER JOIN utilisateur_information ui ON us.id_utilisateur = ui.id_utilisateur
                and ui.utilisateur_actif=true and 
                ((us.id_role = 1 or us.id_role = 3 or us.id_role = 10 ) or 
                ((us.id_role=4 or us.id_role=11 ) and ui.id_affectation=31) or  
                (( us.id_role=5 or us.id_role=8 or us.id_role=2)  and ui.id_federation=43));

SELECT
  t0.id_role AS id_role_1,
  t0.libelle_role AS libelle_role_2,
  t0.description_role AS description_role_3,
  t0.ref_rh AS ref_rh_4
FROM
  ref_role t0
WHERE
  t0.id_role = ?

SELECT t0.id_role AS id_role_1, t0.libelle_role AS libelle_role_2, t0.description_role AS description_role_3, t0.ref_rh AS ref_rh_4 FROM ref_role t0 WHERE t0.id_role = 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 = ?

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 = 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_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 = 2456;

SELECT
  t0.id_poste AS id_poste_1,
  t0.libelle_poste AS libelle_poste_2
FROM
  ref_poste t0
WHERE
  t0.id_poste = ?

SELECT t0.id_poste AS id_poste_1, t0.libelle_poste AS libelle_poste_2 FROM ref_poste t0 WHERE t0.id_poste = 4;

SELECT
  t0.id_federation AS id_federation_1,
  t0.saison_sportive_federation AS saison_sportive_federation_2,
  t0.sport_federation AS sport_federation_3,
  t0.r_adm_diside AS r_adm_diside_4,
  t0.federation_active AS federation_active_5,
  t0.droit_ref_federation AS droit_ref_federation_6,
  t0.text_DTG_dtn AS text_dtg_dtn_7
FROM
  ref_federation t0
WHERE
  t0.id_federation = ?

SELECT t0.id_federation AS id_federation_1, t0.saison_sportive_federation AS saison_sportive_federation_2, t0.sport_federation AS sport_federation_3, t0.r_adm_diside AS r_adm_diside_4, t0.federation_active AS federation_active_5, t0.droit_ref_federation AS droit_ref_federation_6, t0.text_DTG_dtn AS text_dtg_dtn_7 FROM ref_federation t0 WHERE t0.id_federation = 43;