Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.archive AS archive_4,
  t0.ordre AS ordre_5,
  t0.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7,
  t0.theme_id AS theme_id_8,
  t0.sous_theme_id AS sous_theme_id_9
FROM
  sous_theme_theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.theme_id AS theme_id_8, t0.sous_theme_id AS sous_theme_id_9 FROM sous_theme_theme t0 WHERE t0.id = 12;

SELECT
  m0_.intitule AS intitule_0,
  m0_.duree AS duree_1,
  m0_.publie AS publie_2,
  m0_.cpf AS cpf_3,
  m0_.certifiantes AS certifiantes_4,
  m0_.is_default AS is_default_5,
  m0_.certifiante AS certifiante_6,
  m0_.code AS code_7,
  m0_.modalitepedagogiques AS modalitepedagogiques_8,
  m0_.statistiques AS statistiques_9,
  m0_.modaliteevaluationinitial AS modaliteevaluationinitial_10,
  m0_.path AS path_11,
  m0_.code_cpf AS code_cpf_12,
  m0_.code_cpf_salarie AS code_cpf_salarie_13,
  m0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_14,
  m0_.tarif_inter_jour AS tarif_inter_jour_15,
  m0_.tarif_inter_horaire AS tarif_inter_horaire_16,
  m0_.tarif_intra_jour AS tarif_intra_jour_17,
  m0_.tarif_intra_horaire AS tarif_intra_horaire_18,
  m0_.tarif_jury AS tarif_jury_19,
  m0_.prerequis AS prerequis_20,
  m0_.objectif AS objectif_21,
  m0_.plus AS plus_22,
  m0_.public AS public_23,
  m0_.commentaire AS commentaire_24,
  m0_.certification_commentaire AS certification_commentaire_25,
  m0_.seo_titre AS seo_titre_26,
  m0_.seo_description AS seo_description_27,
  m0_.info_pratique AS info_pratique_28,
  m0_.alt_vignette AS alt_vignette_29,
  m0_.description AS description_30,
  m0_.alt_banniere AS alt_banniere_31,
  m0_.identifiant_dokelio AS identifiant_dokelio_32,
  m0_.publication AS publication_33,
  m0_.contenu_apres AS contenu_apres_34,
  m0_.contenu_avant AS contenu_avant_35,
  m0_.nbrsessioninter AS nbrsessioninter_36,
  m0_.nbrsessionintra AS nbrsessionintra_37,
  m0_.id AS id_38,
  m0_.created_at AS created_at_39,
  m0_.updated_at AS updated_at_40,
  m0_.archive AS archive_41,
  c1_.date_inscription AS date_inscription_42,
  c1_.programme AS programme_43,
  c1_.certification AS certification_44,
  c1_.tarif_vente AS tarif_vente_45,
  m0_.type AS type_46,
  m0_.created_by_id AS created_by_id_47,
  m0_.updated_by_id AS updated_by_id_48,
  m0_.mode_formation_id AS mode_formation_id_49,
  m0_.sous_theme_theme_id AS sous_theme_theme_id_50,
  m0_.theme_tarif_id AS theme_tarif_id_51,
  m0_.niveaumateriel_id AS niveaumateriel_id_52,
  m0_.niveautechnique_id AS niveautechnique_id_53,
  m0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_54,
  m0_.banniere_id AS banniere_id_55,
  m0_.vignette_id AS vignette_id_56,
  m0_.api_gestiform_id AS api_gestiform_id_57,
  c1_.editeur_id AS editeur_id_58,
  c1_.theme_id AS theme_id_59
FROM
  module m0_
  LEFT JOIN certification c1_ ON m0_.id = c1_.id

SELECT m0_.intitule AS intitule_0, m0_.duree AS duree_1, m0_.publie AS publie_2, m0_.cpf AS cpf_3, m0_.certifiantes AS certifiantes_4, m0_.is_default AS is_default_5, m0_.certifiante AS certifiante_6, m0_.code AS code_7, m0_.modalitepedagogiques AS modalitepedagogiques_8, m0_.statistiques AS statistiques_9, m0_.modaliteevaluationinitial AS modaliteevaluationinitial_10, m0_.path AS path_11, m0_.code_cpf AS code_cpf_12, m0_.code_cpf_salarie AS code_cpf_salarie_13, m0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_14, m0_.tarif_inter_jour AS tarif_inter_jour_15, m0_.tarif_inter_horaire AS tarif_inter_horaire_16, m0_.tarif_intra_jour AS tarif_intra_jour_17, m0_.tarif_intra_horaire AS tarif_intra_horaire_18, m0_.tarif_jury AS tarif_jury_19, m0_.prerequis AS prerequis_20, m0_.objectif AS objectif_21, m0_.plus AS plus_22, m0_.public AS public_23, m0_.commentaire AS commentaire_24, m0_.certification_commentaire AS certification_commentaire_25, m0_.seo_titre AS seo_titre_26, m0_.seo_description AS seo_description_27, m0_.info_pratique AS info_pratique_28, m0_.alt_vignette AS alt_vignette_29, m0_.description AS description_30, m0_.alt_banniere AS alt_banniere_31, m0_.identifiant_dokelio AS identifiant_dokelio_32, m0_.publication AS publication_33, m0_.contenu_apres AS contenu_apres_34, m0_.contenu_avant AS contenu_avant_35, m0_.nbrsessioninter AS nbrsessioninter_36, m0_.nbrsessionintra AS nbrsessionintra_37, m0_.id AS id_38, m0_.created_at AS created_at_39, m0_.updated_at AS updated_at_40, m0_.archive AS archive_41, c1_.date_inscription AS date_inscription_42, c1_.programme AS programme_43, c1_.certification AS certification_44, c1_.tarif_vente AS tarif_vente_45, m0_.type AS type_46, m0_.created_by_id AS created_by_id_47, m0_.updated_by_id AS updated_by_id_48, m0_.mode_formation_id AS mode_formation_id_49, m0_.sous_theme_theme_id AS sous_theme_theme_id_50, m0_.theme_tarif_id AS theme_tarif_id_51, m0_.niveaumateriel_id AS niveaumateriel_id_52, m0_.niveautechnique_id AS niveautechnique_id_53, m0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_54, m0_.banniere_id AS banniere_id_55, m0_.vignette_id AS vignette_id_56, m0_.api_gestiform_id AS api_gestiform_id_57, c1_.editeur_id AS editeur_id_58, c1_.theme_id AS theme_id_59 FROM module m0_ LEFT JOIN certification c1_ ON m0_.id = c1_.id;

SELECT
  t0.nom AS nom_1,
  t0.prenom AS prenom_2,
  t0.autres_prenoms AS autres_prenoms_3,
  t0.mobile AS mobile_4,
  t0.tel_fixe AS tel_fixe_5,
  t0.ville_naissance AS ville_naissance_6,
  t0.departement_naissance AS departement_naissance_7,
  t0.pays_naissance AS pays_naissance_8,
  t0.nationalite AS nationalite_9,
  t0.fonction AS fonction_10,
  t0.handicap_remarques AS handicap_remarques_11,
  t0.connu_doranco AS connu_doranco_12,
  t0.nir AS nir_13,
  t0.num_secu_sociale AS num_secu_sociale_14,
  t0.reconnaissance_handicap AS reconnaissance_handicap_15,
  t0.handicap AS handicap_16,
  t0.rqth AS rqth_17,
  t0.extension_boe AS extension_boe_18,
  t0.permis_b AS permis_b_19,
  t0.vehicule AS vehicule_20,
  t0.date_naissance AS date_naissance_21,
  t0.date_carte_sejour AS date_carte_sejour_22,
  t0.nationality AS nationality_23,
  t0.id AS id_24,
  t0.created_at AS created_at_25,
  t0.updated_at AS updated_at_26,
  t0.archive AS archive_27,
  t0.created_by_id AS created_by_id_28,
  t0.updated_by_id AS updated_by_id_29,
  t0.civilite_id AS civilite_id_30,
  t0.categorie_nationalite_id AS categorie_nationalite_id_31,
  t0.regime_social_id AS regime_social_id_32
FROM
  personal_informations t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.prenom AS prenom_2, t0.autres_prenoms AS autres_prenoms_3, t0.mobile AS mobile_4, t0.tel_fixe AS tel_fixe_5, t0.ville_naissance AS ville_naissance_6, t0.departement_naissance AS departement_naissance_7, t0.pays_naissance AS pays_naissance_8, t0.nationalite AS nationalite_9, t0.fonction AS fonction_10, t0.handicap_remarques AS handicap_remarques_11, t0.connu_doranco AS connu_doranco_12, t0.nir AS nir_13, t0.num_secu_sociale AS num_secu_sociale_14, t0.reconnaissance_handicap AS reconnaissance_handicap_15, t0.handicap AS handicap_16, t0.rqth AS rqth_17, t0.extension_boe AS extension_boe_18, t0.permis_b AS permis_b_19, t0.vehicule AS vehicule_20, t0.date_naissance AS date_naissance_21, t0.date_carte_sejour AS date_carte_sejour_22, t0.nationality AS nationality_23, t0.id AS id_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.archive AS archive_27, t0.created_by_id AS created_by_id_28, t0.updated_by_id AS updated_by_id_29, t0.civilite_id AS civilite_id_30, t0.categorie_nationalite_id AS categorie_nationalite_id_31, t0.regime_social_id AS regime_social_id_32 FROM personal_informations t0 WHERE t0.id = 5;

SELECT
  t0.intitule AS intitule_1,
  t0.code AS code_2,
  t0.alt_banniere AS alt_banniere_3,
  t0.alt_vignette AS alt_vignette_4,
  t0.couleur AS couleur_5,
  t0.commentaire AS commentaire_6,
  t0.seotitre AS seotitre_7,
  t0.seodescription AS seodescription_8,
  t0.path AS path_9,
  t0.publication AS publication_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.archive AS archive_14,
  t0.ordre AS ordre_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17,
  t0.vignette_id AS vignette_id_18,
  t0.banniere_id AS banniere_id_19,
  t0.tarif_vente_defaut_id AS tarif_vente_defaut_id_20,
  t0.tarifventeintradefaut_id AS tarifventeintradefaut_id_21
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.intitule AS intitule_1, t0.code AS code_2, t0.alt_banniere AS alt_banniere_3, t0.alt_vignette AS alt_vignette_4, t0.couleur AS couleur_5, t0.commentaire AS commentaire_6, t0.seotitre AS seotitre_7, t0.seodescription AS seodescription_8, t0.path AS path_9, t0.publication AS publication_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.archive AS archive_14, t0.ordre AS ordre_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.vignette_id AS vignette_id_18, t0.banniere_id AS banniere_id_19, t0.tarif_vente_defaut_id AS tarif_vente_defaut_id_20, t0.tarifventeintradefaut_id AS tarifventeintradefaut_id_21 FROM theme t0 WHERE t0.id = 1;

SELECT
  e0_.start AS start_0,
  e0_.end AS end_1,
  e0_.hours AS hours_2,
  e0_.sendconvocationstagiaire AS sendconvocationstagiaire_3,
  e0_.sendconvocationformateur AS sendconvocationformateur_4,
  e0_.temps_prise_en_compte AS temps_prise_en_compte_5,
  e0_.id AS id_6,
  e0_.created_at AS created_at_7,
  e0_.updated_at AS updated_at_8,
  e0_.archive AS archive_9,
  e0_.created_by_id AS created_by_id_10,
  e0_.updated_by_id AS updated_by_id_11,
  e0_.modalite_id AS modalite_id_12,
  e0_.parent_id AS parent_id_13,
  e0_.session_bloc_module_id AS session_bloc_module_id_14,
  e0_.accompagnement_id AS accompagnement_id_15,
  e0_.module_id AS module_id_16,
  e0_.jury_id AS jury_id_17,
  e0_.stage_id AS stage_id_18
FROM
  event e0_
WHERE
  e0_.start <= CURRENT_TIMESTAMP
  AND e0_.parent_id IS NULL
  AND e0_.module_id IS NOT NULL

SELECT e0_.start AS start_0, e0_.end AS end_1, e0_.hours AS hours_2, e0_.sendconvocationstagiaire AS sendconvocationstagiaire_3, e0_.sendconvocationformateur AS sendconvocationformateur_4, e0_.temps_prise_en_compte AS temps_prise_en_compte_5, e0_.id AS id_6, e0_.created_at AS created_at_7, e0_.updated_at AS updated_at_8, e0_.archive AS archive_9, e0_.created_by_id AS created_by_id_10, e0_.updated_by_id AS updated_by_id_11, e0_.modalite_id AS modalite_id_12, e0_.parent_id AS parent_id_13, e0_.session_bloc_module_id AS session_bloc_module_id_14, e0_.accompagnement_id AS accompagnement_id_15, e0_.module_id AS module_id_16, e0_.jury_id AS jury_id_17, e0_.stage_id AS stage_id_18 FROM event e0_ WHERE e0_.start <= CURRENT_TIMESTAMP AND e0_.parent_id IS NULL AND e0_.module_id IS NOT NULL;

SELECT
  p0_.intitule AS intitule_0,
  p0_.code AS code_1,
  p0_.remise_pourc AS remise_pourc_2,
  p0_.id AS id_3,
  p0_.created_at AS created_at_4,
  p0_.updated_at AS updated_at_5,
  p0_.archive AS archive_6,
  p0_.ordre AS ordre_7,
  p0_.created_by_id AS created_by_id_8,
  p0_.updated_by_id AS updated_by_id_9,
  p0_.type_formulaire_id AS type_formulaire_id_10,
  p0_.api_gestiform_id AS api_gestiform_id_11
FROM
  profil p0_
WHERE
  p0_.archive = 0
ORDER BY
  p0_.intitule ASC

SELECT p0_.intitule AS intitule_0, p0_.code AS code_1, p0_.remise_pourc AS remise_pourc_2, p0_.id AS id_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.archive AS archive_6, p0_.ordre AS ordre_7, p0_.created_by_id AS created_by_id_8, p0_.updated_by_id AS updated_by_id_9, p0_.type_formulaire_id AS type_formulaire_id_10, p0_.api_gestiform_id AS api_gestiform_id_11 FROM profil p0_ WHERE p0_.archive = 0 ORDER BY p0_.intitule ASC;

SELECT
  p0_.intitule AS intitule_0,
  p0_.intitule_officiel AS intitule_officiel_1,
  p0_.code AS code_2,
  p0_.code_diplome AS code_diplome_3,
  p0_.sigle AS sigle_4,
  p0_.date_debut_valide AS date_debut_valide_5,
  p0_.date_fin_valide AS date_fin_valide_6,
  p0_.date_publication_officiel AS date_publication_officiel_7,
  p0_.plus AS plus_8,
  p0_.redirection AS redirection_9,
  p0_.publication AS publication_10,
  p0_.publication_api AS publication_api_11,
  p0_.taux_obtention AS taux_obtention_12,
  p0_.taux_abandon AS taux_abandon_13,
  p0_.taux_satisfaction AS taux_satisfaction_14,
  p0_.taux_pour_suite_etude AS taux_pour_suite_etude_15,
  p0_.taux_employabilite AS taux_employabilite_16,
  p0_.prerequis AS prerequis_17,
  p0_.salaire_moyen AS salaire_moyen_18,
  p0_.livrable AS livrable_19,
  p0_.alt_banniere AS alt_banniere_20,
  p0_.alt_vignette AS alt_vignette_21,
  p0_.tarif_jury AS tarif_jury_22,
  p0_.tarif_jury2 AS tarif_jury2_23,
  p0_.cpf AS cpf_24,
  p0_.code_cpf AS code_cpf_25,
  p0_.code_rncp_rs AS code_rncp_rs_26,
  p0_.code_cpf_salarie AS code_cpf_salarie_27,
  p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_28,
  p0_.code_nsf AS code_nsf_29,
  p0_.duree AS duree_30,
  p0_.duree_modulaire AS duree_modulaire_31,
  p0_.rncp AS rncp_32,
  p0_.duree_accompagnement AS duree_accompagnement_33,
  p0_.duree_stage AS duree_stage_34,
  p0_.duree_center AS duree_center_35,
  p0_.duree_elearning AS duree_elearning_36,
  p0_.stage_obligatoire AS stage_obligatoire_37,
  p0_.formation_permanente AS formation_permanente_38,
  p0_.sanction_resume AS sanction_resume_39,
  p0_.sanction_long AS sanction_long_40,
  p0_.metier AS metier_41,
  p0_.text AS text_42,
  p0_.objectif AS objectif_43,
  p0_.debouche AS debouche_44,
  p0_.condition_admission AS condition_admission_45,
  p0_.public AS public_46,
  p0_.detail_examen AS detail_examen_47,
  p0_.frais_pedagogique AS frais_pedagogique_48,
  p0_.seo_titre AS seo_titre_49,
  p0_.seo_description AS seo_description_50,
  p0_.rythme AS rythme_51,
  p0_.identifiant_dokelio AS identifiant_dokelio_52,
  p0_.dokelio_parcours AS dokelio_parcours_53,
  p0_.contenu_apres AS contenu_apres_54,
  p0_.contenu_avant AS contenu_avant_55,
  p0_.path AS path_56,
  p0_.items AS items_57,
  p0_.is_default AS is_default_58,
  p0_.id AS id_59,
  p0_.created_at AS created_at_60,
  p0_.updated_at AS updated_at_61,
  p0_.archive AS archive_62,
  p0_.created_by_id AS created_by_id_63,
  p0_.updated_by_id AS updated_by_id_64,
  p0_.theme_id AS theme_id_65,
  p0_.parent_id AS parent_id_66,
  p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_67,
  p0_.nsf_id AS nsf_id_68,
  p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_69,
  p0_.filiere_id AS filiere_id_70,
  p0_.niveau_entree_id AS niveau_entree_id_71,
  p0_.niveau_sortie_id AS niveau_sortie_id_72,
  p0_.niveau_technique_id AS niveau_technique_id_73,
  p0_.qualifiant_id AS qualifiant_id_74,
  p0_.type_formation_id AS type_formation_id_75,
  p0_.autorite_delivrance_id AS autorite_delivrance_id_76,
  p0_.mode_formation_id AS mode_formation_id_77,
  p0_.formateur_id AS formateur_id_78,
  p0_.banniere_id AS banniere_id_79,
  p0_.vignette_id AS vignette_id_80
FROM
  parcours p0_
WHERE
  p0_.id = ?

SELECT p0_.intitule AS intitule_0, p0_.intitule_officiel AS intitule_officiel_1, p0_.code AS code_2, p0_.code_diplome AS code_diplome_3, p0_.sigle AS sigle_4, p0_.date_debut_valide AS date_debut_valide_5, p0_.date_fin_valide AS date_fin_valide_6, p0_.date_publication_officiel AS date_publication_officiel_7, p0_.plus AS plus_8, p0_.redirection AS redirection_9, p0_.publication AS publication_10, p0_.publication_api AS publication_api_11, p0_.taux_obtention AS taux_obtention_12, p0_.taux_abandon AS taux_abandon_13, p0_.taux_satisfaction AS taux_satisfaction_14, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_15, p0_.taux_employabilite AS taux_employabilite_16, p0_.prerequis AS prerequis_17, p0_.salaire_moyen AS salaire_moyen_18, p0_.livrable AS livrable_19, p0_.alt_banniere AS alt_banniere_20, p0_.alt_vignette AS alt_vignette_21, p0_.tarif_jury AS tarif_jury_22, p0_.tarif_jury2 AS tarif_jury2_23, p0_.cpf AS cpf_24, p0_.code_cpf AS code_cpf_25, p0_.code_rncp_rs AS code_rncp_rs_26, p0_.code_cpf_salarie AS code_cpf_salarie_27, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_28, p0_.code_nsf AS code_nsf_29, p0_.duree AS duree_30, p0_.duree_modulaire AS duree_modulaire_31, p0_.rncp AS rncp_32, p0_.duree_accompagnement AS duree_accompagnement_33, p0_.duree_stage AS duree_stage_34, p0_.duree_center AS duree_center_35, p0_.duree_elearning AS duree_elearning_36, p0_.stage_obligatoire AS stage_obligatoire_37, p0_.formation_permanente AS formation_permanente_38, p0_.sanction_resume AS sanction_resume_39, p0_.sanction_long AS sanction_long_40, p0_.metier AS metier_41, p0_.text AS text_42, p0_.objectif AS objectif_43, p0_.debouche AS debouche_44, p0_.condition_admission AS condition_admission_45, p0_.public AS public_46, p0_.detail_examen AS detail_examen_47, p0_.frais_pedagogique AS frais_pedagogique_48, p0_.seo_titre AS seo_titre_49, p0_.seo_description AS seo_description_50, p0_.rythme AS rythme_51, p0_.identifiant_dokelio AS identifiant_dokelio_52, p0_.dokelio_parcours AS dokelio_parcours_53, p0_.contenu_apres AS contenu_apres_54, p0_.contenu_avant AS contenu_avant_55, p0_.path AS path_56, p0_.items AS items_57, p0_.is_default AS is_default_58, p0_.id AS id_59, p0_.created_at AS created_at_60, p0_.updated_at AS updated_at_61, p0_.archive AS archive_62, p0_.created_by_id AS created_by_id_63, p0_.updated_by_id AS updated_by_id_64, p0_.theme_id AS theme_id_65, p0_.parent_id AS parent_id_66, p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_67, p0_.nsf_id AS nsf_id_68, p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_69, p0_.filiere_id AS filiere_id_70, p0_.niveau_entree_id AS niveau_entree_id_71, p0_.niveau_sortie_id AS niveau_sortie_id_72, p0_.niveau_technique_id AS niveau_technique_id_73, p0_.qualifiant_id AS qualifiant_id_74, p0_.type_formation_id AS type_formation_id_75, p0_.autorite_delivrance_id AS autorite_delivrance_id_76, p0_.mode_formation_id AS mode_formation_id_77, p0_.formateur_id AS formateur_id_78, p0_.banniere_id AS banniere_id_79, p0_.vignette_id AS vignette_id_80 FROM parcours p0_ WHERE p0_.id = NULL;

SELECT
  t1.email AS email_4,
  t1.password AS password_5,
  t1.roles AS roles_6,
  t1.enabled AS enabled_7,
  t1.status AS status_8,
  t1.rgpd AS rgpd_9,
  t1.id AS id_10,
  t1.created_at AS created_at_11,
  t1.updated_at AS updated_at_12,
  t1.archive AS archive_13,
  t1.created_by_id AS created_by_id_14,
  t1.updated_by_id AS updated_by_id_15,
  t1.adresse_id AS adresse_id_16,
  t1.photo_id AS photo_id_17,
  t1.api_gestiform_id AS api_gestiform_id_18,
  t0.personal_informations_id AS personal_informations_id_19,
  t0.signature_file_id AS signature_file_id_20,
  t1.type,
  t2.mineur AS mineur_21,
  t2.dossier_actif_id AS dossier_actif_id_22,
  t2.representant_legal_id AS representant_legal_id_23,
  t3.prefecture AS prefecture_24,
  t3.numero_activite AS numero_activite_25,
  t3.numero_activite2 AS numero_activite2_26,
  t3.liste_competences AS liste_competences_27,
  t3.debut_habilitation AS debut_habilitation_28,
  t3.fin_habilitation AS fin_habilitation_29,
  t3.jury_uniquement AS jury_uniquement_30,
  t3.mission_proposee AS mission_proposee_31,
  t3.statut_id AS statut_id_32
FROM
  personne t0
  INNER JOIN user t1 ON t0.id = t1.id
  LEFT JOIN apprenant t2 ON t0.id = t2.id
  LEFT JOIN formateur t3 ON t0.id = t3.id
WHERE
  t1.id = ?

SELECT t1.email AS email_4, t1.password AS password_5, t1.roles AS roles_6, t1.enabled AS enabled_7, t1.status AS status_8, t1.rgpd AS rgpd_9, t1.id AS id_10, t1.created_at AS created_at_11, t1.updated_at AS updated_at_12, t1.archive AS archive_13, t1.created_by_id AS created_by_id_14, t1.updated_by_id AS updated_by_id_15, t1.adresse_id AS adresse_id_16, t1.photo_id AS photo_id_17, t1.api_gestiform_id AS api_gestiform_id_18, t0.personal_informations_id AS personal_informations_id_19, t0.signature_file_id AS signature_file_id_20, t1.type, t2.mineur AS mineur_21, t2.dossier_actif_id AS dossier_actif_id_22, t2.representant_legal_id AS representant_legal_id_23, t3.prefecture AS prefecture_24, t3.numero_activite AS numero_activite_25, t3.numero_activite2 AS numero_activite2_26, t3.liste_competences AS liste_competences_27, t3.debut_habilitation AS debut_habilitation_28, t3.fin_habilitation AS fin_habilitation_29, t3.jury_uniquement AS jury_uniquement_30, t3.mission_proposee AS mission_proposee_31, t3.statut_id AS statut_id_32 FROM personne t0 INNER JOIN user t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id WHERE t1.id = 28;

SELECT
  s0_.intitule AS intitule_0,
  s0_.type AS type_1,
  s0_.session_dokelio AS session_dokelio_2,
  s0_.dokelio_parcours AS dokelio_parcours_3,
  s0_.simul_nb_apprenants AS simul_nb_apprenants_4,
  s0_.numero_session AS numero_session_5,
  s0_.duree AS duree_6,
  s0_.date_debut AS date_debut_7,
  s0_.date_debut_affichage AS date_debut_affichage_8,
  s0_.date_fin_affichage AS date_fin_affichage_9,
  s0_.site_partenaire AS site_partenaire_10,
  s0_.publie_site AS publie_site_11,
  s0_.dates_larges AS dates_larges_12,
  s0_.id AS id_13,
  s0_.created_at AS created_at_14,
  s0_.updated_at AS updated_at_15,
  s0_.archive AS archive_16,
  s0_.created_by_id AS created_by_id_17,
  s0_.updated_by_id AS updated_by_id_18,
  s0_.salle_defaut_id AS salle_defaut_id_19,
  s0_.parcours_id AS parcours_id_20,
  s0_.adresse_partenaire_id AS adresse_partenaire_id_21,
  s0_.statut_id AS statut_id_22,
  s0_.referent_pedagogique_id AS referent_pedagogique_id_23,
  s0_.referent_coach_id AS referent_coach_id_24,
  s0_.referent_administratif_id AS referent_administratif_id_25,
  s0_.referent_handicap_id AS referent_handicap_id_26,
  s0_.planning_id AS planning_id_27,
  s0_.site_id AS site_id_28,
  s0_.api_gestiform_id AS api_gestiform_id_29
FROM
  session s0_
WHERE
  s0_.id = ?

SELECT s0_.intitule AS intitule_0, s0_.type AS type_1, s0_.session_dokelio AS session_dokelio_2, s0_.dokelio_parcours AS dokelio_parcours_3, s0_.simul_nb_apprenants AS simul_nb_apprenants_4, s0_.numero_session AS numero_session_5, s0_.duree AS duree_6, s0_.date_debut AS date_debut_7, s0_.date_debut_affichage AS date_debut_affichage_8, s0_.date_fin_affichage AS date_fin_affichage_9, s0_.site_partenaire AS site_partenaire_10, s0_.publie_site AS publie_site_11, s0_.dates_larges AS dates_larges_12, s0_.id AS id_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15, s0_.archive AS archive_16, s0_.created_by_id AS created_by_id_17, s0_.updated_by_id AS updated_by_id_18, s0_.salle_defaut_id AS salle_defaut_id_19, s0_.parcours_id AS parcours_id_20, s0_.adresse_partenaire_id AS adresse_partenaire_id_21, s0_.statut_id AS statut_id_22, s0_.referent_pedagogique_id AS referent_pedagogique_id_23, s0_.referent_coach_id AS referent_coach_id_24, s0_.referent_administratif_id AS referent_administratif_id_25, s0_.referent_handicap_id AS referent_handicap_id_26, s0_.planning_id AS planning_id_27, s0_.site_id AS site_id_28, s0_.api_gestiform_id AS api_gestiform_id_29 FROM session s0_ WHERE s0_.id = NULL;

SELECT
  t0.email AS email_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.enabled AS enabled_8,
  t0.status AS status_9,
  t0.rgpd AS rgpd_10,
  t0.id AS id_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.archive AS archive_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.adresse_id AS adresse_id_17,
  t0.photo_id AS photo_id_18,
  t0.api_gestiform_id AS api_gestiform_id_19,
  t0.type,
  t1.personal_informations_id AS personal_informations_id_20,
  t2.mineur AS mineur_21,
  t2.dossier_actif_id AS dossier_actif_id_22,
  t2.representant_legal_id AS representant_legal_id_23,
  t3.prefecture AS prefecture_24,
  t3.numero_activite AS numero_activite_25,
  t3.numero_activite2 AS numero_activite2_26,
  t3.liste_competences AS liste_competences_27,
  t3.debut_habilitation AS debut_habilitation_28,
  t3.fin_habilitation AS fin_habilitation_29,
  t3.jury_uniquement AS jury_uniquement_30,
  t3.mission_proposee AS mission_proposee_31,
  t3.statut_id AS statut_id_32,
  t4.personal_informations_id AS personal_informations_id_33,
  t4.signature_file_id AS signature_file_id_34
FROM
  user t0
  LEFT JOIN employe t1 ON t0.id = t1.id
  LEFT JOIN apprenant t2 ON t0.id = t2.id
  LEFT JOIN formateur t3 ON t0.id = t3.id
  LEFT JOIN personne t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.enabled AS enabled_8, t0.status AS status_9, t0.rgpd AS rgpd_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.archive AS archive_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.adresse_id AS adresse_id_17, t0.photo_id AS photo_id_18, t0.api_gestiform_id AS api_gestiform_id_19, t0.type, t1.personal_informations_id AS personal_informations_id_20, t2.mineur AS mineur_21, t2.dossier_actif_id AS dossier_actif_id_22, t2.representant_legal_id AS representant_legal_id_23, t3.prefecture AS prefecture_24, t3.numero_activite AS numero_activite_25, t3.numero_activite2 AS numero_activite2_26, t3.liste_competences AS liste_competences_27, t3.debut_habilitation AS debut_habilitation_28, t3.fin_habilitation AS fin_habilitation_29, t3.jury_uniquement AS jury_uniquement_30, t3.mission_proposee AS mission_proposee_31, t3.statut_id AS statut_id_32, t4.personal_informations_id AS personal_informations_id_33, t4.signature_file_id AS signature_file_id_34 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = 61;

SELECT
  m0_.code AS code_0,
  m0_.designation AS designation_1,
  m0_.valeur AS valeur_2,
  m0_.valeur2 AS valeur2_3,
  m0_.htmlvaleur AS htmlvaleur_4,
  m0_.valeur3 AS valeur3_5,
  m0_.id AS id_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.archive AS archive_9,
  m1_.module AS module_10,
  m1_.code AS code_11,
  m1_.designation AS designation_12,
  m1_.id AS id_13,
  m1_.created_at AS created_at_14,
  m1_.updated_at AS updated_at_15,
  m1_.archive AS archive_16,
  m0_.created_by_id AS created_by_id_17,
  m0_.updated_by_id AS updated_by_id_18,
  m0_.masterliste_id AS masterliste_id_19,
  m0_.api_gestiform_id AS api_gestiform_id_20,
  m1_.created_by_id AS created_by_id_21,
  m1_.updated_by_id AS updated_by_id_22,
  m1_.api_gestiform_id AS api_gestiform_id_23
FROM
  masterlistelg m0_
  INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id
WHERE
  m0_.code = ?
  AND m1_.module = ?
  AND m1_.code = ?
LIMIT
  1

SELECT m0_.code AS code_0, m0_.designation AS designation_1, m0_.valeur AS valeur_2, m0_.valeur2 AS valeur2_3, m0_.htmlvaleur AS htmlvaleur_4, m0_.valeur3 AS valeur3_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.archive AS archive_9, m1_.module AS module_10, m1_.code AS code_11, m1_.designation AS designation_12, m1_.id AS id_13, m1_.created_at AS created_at_14, m1_.updated_at AS updated_at_15, m1_.archive AS archive_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;

SELECT
  m0_.code AS code_0,
  m0_.designation AS designation_1,
  m0_.valeur AS valeur_2,
  m0_.valeur2 AS valeur2_3,
  m0_.htmlvaleur AS htmlvaleur_4,
  m0_.valeur3 AS valeur3_5,
  m0_.id AS id_6,
  m0_.created_at AS created_at_7,
  m0_.updated_at AS updated_at_8,
  m0_.archive AS archive_9,
  m1_.module AS module_10,
  m1_.code AS code_11,
  m1_.designation AS designation_12,
  m1_.id AS id_13,
  m1_.created_at AS created_at_14,
  m1_.updated_at AS updated_at_15,
  m1_.archive AS archive_16,
  m0_.created_by_id AS created_by_id_17,
  m0_.updated_by_id AS updated_by_id_18,
  m0_.masterliste_id AS masterliste_id_19,
  m0_.api_gestiform_id AS api_gestiform_id_20,
  m1_.created_by_id AS created_by_id_21,
  m1_.updated_by_id AS updated_by_id_22,
  m1_.api_gestiform_id AS api_gestiform_id_23
FROM
  masterlistelg m0_
  INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id
WHERE
  m1_.code = ?
  AND m1_.module = ?
ORDER BY
  m0_.code ASC

SELECT m0_.code AS code_0, m0_.designation AS designation_1, m0_.valeur AS valeur_2, m0_.valeur2 AS valeur2_3, m0_.htmlvaleur AS htmlvaleur_4, m0_.valeur3 AS valeur3_5, m0_.id AS id_6, m0_.created_at AS created_at_7, m0_.updated_at AS updated_at_8, m0_.archive AS archive_9, m1_.module AS module_10, m1_.code AS code_11, m1_.designation AS designation_12, m1_.id AS id_13, m1_.created_at AS created_at_14, m1_.updated_at AS updated_at_15, m1_.archive AS archive_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = 'CIVILITE' AND m1_.module = 'NOYAU' ORDER BY m0_.code ASC;