Symfony Profiler

SELECT
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.archive AS archive_8,
  t0.email AS email_9,
  t0.password AS password_10,
  t0.plain_password AS plain_password_11,
  t0.roles AS roles_12,
  t0.enabled AS enabled_13,
  t0.status AS status_14,
  t0.rgpd AS rgpd_15,
  t0.api_token AS api_token_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.adresse_id AS adresse_id_19,
  t0.photo_id AS photo_id_20,
  t0.api_gestiform_id AS api_gestiform_id_21,
  t0.type,
  t1.rgpd_signed_at AS rgpd_signed_at_22,
  t1.personal_informations_id AS personal_informations_id_23,
  t1.rgpd_document_id AS rgpd_document_id_24,
  t1.responsable_hierarchique_id AS responsable_hierarchique_id_25,
  t2.mineur AS mineur_26,
  t2.dossier_actif_id AS dossier_actif_id_27,
  t2.representant_legal_id AS representant_legal_id_28,
  t3.prefecture AS prefecture_29,
  t3.numero_activite AS numero_activite_30,
  t3.numero_activite2 AS numero_activite2_31,
  t3.liste_competences AS liste_competences_32,
  t3.debut_habilitation AS debut_habilitation_33,
  t3.fin_habilitation AS fin_habilitation_34,
  t3.jury_uniquement AS jury_uniquement_35,
  t3.mission_proposee AS mission_proposee_36,
  t3.statut_id AS statut_id_37,
  t4.personal_informations_id AS personal_informations_id_38,
  t4.signature_file_id AS signature_file_id_39
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.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 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 = 1;

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.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.civilite AS civilite_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.societe AS societe_10,
  t0.dossier_type AS dossier_type_11,
  t0.message AS message_12,
  t0.type AS type_13,
  t0.profil AS profil_14,
  t0.source_formulaire AS source_formulaire_15,
  t0.source_canal AS source_canal_16,
  t0.first_contact_at AS first_contact_at_17,
  t0.last_contact_at AS last_contact_at_18,
  t0.status AS status_19,
  t0.is_qualified AS is_qualified_20,
  t0.is_won AS is_won_21,
  t0.is_lost AS is_lost_22,
  t0.won_at AS won_at_23,
  t0.lost_at AS lost_at_24,
  t0.lost_reason AS lost_reason_25,
  t0.formation_interet AS formation_interet_26,
  t0.next_contact_date AS next_contact_date_27,
  t0.is_late_lead AS is_late_lead_28,
  t0.created_by_id AS created_by_id_29,
  t0.updated_by_id AS updated_by_id_30,
  t0.dossier_id AS dossier_id_31,
  t0.employe_id AS employe_id_32,
  t0.source_id AS source_id_33,
  t34.id AS id_35,
  t34.created_at AS created_at_36,
  t34.updated_at AS updated_at_37,
  t34.archive AS archive_38,
  t34.type_poste AS type_poste_39,
  t34.titre_poste AS titre_poste_40,
  t34.description_poste AS description_poste_41,
  t34.competences_attendues AS competences_attendues_42,
  t34.conditions AS conditions_43,
  t34.mots_cles AS mots_cles_44,
  t34.date_offre AS date_offre_45,
  t34.statut AS statut_46,
  t34.created_by_id AS created_by_id_47,
  t34.updated_by_id AS updated_by_id_48,
  t34.entreprise_id AS entreprise_id_49,
  t34.contact_id AS contact_id_50,
  t34.employe_id AS employe_id_51,
  t34.lead_id AS lead_id_52
FROM
  lead_simplyform t0
  LEFT JOIN offre_emploi t34 ON t34.lead_id = t0.id
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.nom AS nom_5, t0.prenom AS prenom_6, t0.civilite AS civilite_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.societe AS societe_10, t0.dossier_type AS dossier_type_11, t0.message AS message_12, t0.type AS type_13, t0.profil AS profil_14, t0.source_formulaire AS source_formulaire_15, t0.source_canal AS source_canal_16, t0.first_contact_at AS first_contact_at_17, t0.last_contact_at AS last_contact_at_18, t0.status AS status_19, t0.is_qualified AS is_qualified_20, t0.is_won AS is_won_21, t0.is_lost AS is_lost_22, t0.won_at AS won_at_23, t0.lost_at AS lost_at_24, t0.lost_reason AS lost_reason_25, t0.formation_interet AS formation_interet_26, t0.next_contact_date AS next_contact_date_27, t0.is_late_lead AS is_late_lead_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.dossier_id AS dossier_id_31, t0.employe_id AS employe_id_32, t0.source_id AS source_id_33, t34.id AS id_35, t34.created_at AS created_at_36, t34.updated_at AS updated_at_37, t34.archive AS archive_38, t34.type_poste AS type_poste_39, t34.titre_poste AS titre_poste_40, t34.description_poste AS description_poste_41, t34.competences_attendues AS competences_attendues_42, t34.conditions AS conditions_43, t34.mots_cles AS mots_cles_44, t34.date_offre AS date_offre_45, t34.statut AS statut_46, t34.created_by_id AS created_by_id_47, t34.updated_by_id AS updated_by_id_48, t34.entreprise_id AS entreprise_id_49, t34.contact_id AS contact_id_50, t34.employe_id AS employe_id_51, t34.lead_id AS lead_id_52 FROM lead_simplyform t0 LEFT JOIN offre_emploi t34 ON t34.lead_id = t0.id WHERE t0.id = '2';

SELECT
  t1.id AS id_2,
  t1.created_at AS created_at_3,
  t1.updated_at AS updated_at_4,
  t1.archive AS archive_5,
  t1.email AS email_6,
  t1.password AS password_7,
  t1.plain_password AS plain_password_8,
  t1.roles AS roles_9,
  t1.enabled AS enabled_10,
  t1.status AS status_11,
  t1.rgpd AS rgpd_12,
  t1.api_token AS api_token_13,
  t0.rgpd_signed_at AS rgpd_signed_at_14,
  t1.created_by_id AS created_by_id_15,
  t1.updated_by_id AS updated_by_id_16,
  t1.adresse_id AS adresse_id_17,
  t1.photo_id AS photo_id_18,
  t1.api_gestiform_id AS api_gestiform_id_19,
  t0.personal_informations_id AS personal_informations_id_20,
  t0.rgpd_document_id AS rgpd_document_id_21,
  t0.responsable_hierarchique_id AS responsable_hierarchique_id_22,
  t1.type
FROM
  employe t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.enabled = ?

SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.email AS email_6, t1.password AS password_7, t1.plain_password AS plain_password_8, t1.roles AS roles_9, t1.enabled AS enabled_10, t1.status AS status_11, t1.rgpd AS rgpd_12, t1.api_token AS api_token_13, t0.rgpd_signed_at AS rgpd_signed_at_14, t1.created_by_id AS created_by_id_15, t1.updated_by_id AS updated_by_id_16, t1.adresse_id AS adresse_id_17, t1.photo_id AS photo_id_18, t1.api_gestiform_id AS api_gestiform_id_19, t0.personal_informations_id AS personal_informations_id_20, t0.rgpd_document_id AS rgpd_document_id_21, t0.responsable_hierarchique_id AS responsable_hierarchique_id_22, t1.type FROM employe t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.enabled = 1;

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.sendTo AS sendTo_5,
  t0.sendFrom AS sendFrom_6,
  t0.objet AS objet_7,
  t0.content AS content_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.dossier_id AS dossier_id_11,
  t0.personne_id AS personne_id_12,
  t0.employe_id AS employe_id_13,
  t0.template_id AS template_id_14,
  t0.event_id AS event_id_15,
  t0.formulaire_id AS formulaire_id_16
FROM
  historique_email t0
WHERE
  t0.sendTo = ?
ORDER BY
  t0.created_at DESC
LIMIT
  25

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.sendTo AS sendTo_5, t0.sendFrom AS sendFrom_6, t0.objet AS objet_7, t0.content AS content_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.dossier_id AS dossier_id_11, t0.personne_id AS personne_id_12, t0.employe_id AS employe_id_13, t0.template_id AS template_id_14, t0.event_id AS event_id_15, t0.formulaire_id AS formulaire_id_16 FROM historique_email t0 WHERE t0.sendTo = 'alexfontainecc@hotmail.com' ORDER BY t0.created_at DESC LIMIT 25;

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.archive AS archive_3,
  m0_.code AS code_4,
  m0_.designation AS designation_5,
  m0_.valeur AS valeur_6,
  m0_.valeur2 AS valeur2_7,
  m0_.htmlvaleur AS htmlvaleur_8,
  m0_.valeur3 AS valeur3_9,
  m1_.id AS id_10,
  m1_.created_at AS created_at_11,
  m1_.updated_at AS updated_at_12,
  m1_.archive AS archive_13,
  m1_.module AS module_14,
  m1_.code AS code_15,
  m1_.designation AS designation_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_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_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
  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.module AS module_5,
  t0.code AS code_6,
  t0.designation AS designation_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.api_gestiform_id AS api_gestiform_id_10
FROM
  masterliste t0
WHERE
  t0.module = ?
  AND t0.code = ?
LIMIT
  1

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.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = 'FINANCEURS' AND t0.code = 'CATEGORIES' LIMIT 1;

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.code AS code_5,
  t0.designation AS designation_6,
  t0.valeur AS valeur_7,
  t0.valeur2 AS valeur2_8,
  t0.htmlvaleur AS htmlvaleur_9,
  t0.valeur3 AS valeur3_10,
  t0.created_by_id AS created_by_id_11,
  t0.updated_by_id AS updated_by_id_12,
  t0.masterliste_id AS masterliste_id_13,
  t0.api_gestiform_id AS api_gestiform_id_14
FROM
  masterlistelg t0
WHERE
  t0.masterliste_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.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = 104;

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.reference AS reference_5,
  t0.items_document AS items_document_6,
  t0.email_logs AS email_logs_7,
  t0.panier AS panier_8,
  t0.competences AS competences_9,
  t0.cart AS cart_10,
  t0.mode AS mode_11,
  t0.linkedin AS linkedin_12,
  t0.portfolio AS portfolio_13,
  t0.campus AS campus_14,
  t0.modalite_enseignement AS modalite_enseignement_15,
  t0.commentaire AS commentaire_16,
  t0.email_candidature AS email_candidature_17,
  t0.date_reunion AS date_reunion_18,
  t0.stop_date AS stop_date_19,
  t0.candidate_available AS candidate_available_20,
  t0.rncp AS rncp_21,
  t0.diplomant AS diplomant_22,
  t0.delegue_classe AS delegue_classe_23,
  t0.postulant_available AS postulant_available_24,
  t0.prospect_available AS prospect_available_25,
  t0.stagiaire_available AS stagiaire_available_26,
  t0.alumni_available AS alumni_available_27,
  t0.news_letter AS news_letter_28,
  t0.processed AS processed_29,
  t0.statut_declaration AS statut_declaration_30,
  t0.a_representant_legal AS a_representant_legal_31,
  t0.notification_paiement AS notification_paiement_32,
  t0.engagement_formation AS engagement_formation_33,
  t0.charte_formation AS charte_formation_34,
  t0.compte_zoom AS compte_zoom_35,
  t0.notified AS notified_36,
  t0.femme_eloigne AS femme_eloigne_37,
  t0.zrr AS zrr_38,
  t0.qpv AS qpv_39,
  t0.participation_reglee AS participation_reglee_40,
  t0.participation AS participation_41,
  t0.caution AS caution_42,
  t0.restea_regler AS restea_regler_43,
  t0.created_by_id AS created_by_id_44,
  t0.updated_by_id AS updated_by_id_45,
  t0.stop_proof_id AS stop_proof_id_46,
  t0.stop_cause_id AS stop_cause_id_47,
  t0.stop_type_id AS stop_type_id_48,
  t0.type_actif_id AS type_actif_id_49,
  t0.state_id AS state_id_50,
  t0.dispositif_id AS dispositif_id_51,
  t0.type_formation_id AS type_formation_id_52,
  t0.resultat_id AS resultat_id_53,
  t0.profil_id AS profil_id_54,
  t0.personal_informations_id AS personal_informations_id_55,
  t0.adresse_id AS adresse_id_56,
  t0.planning_id AS planning_id_57,
  t0.session_id AS session_id_58,
  t0.societe_id AS societe_id_59,
  t0.site_id AS site_id_60,
  t0.dossierannexes_id AS dossierannexes_id_61,
  t0.apprenant_id AS apprenant_id_62,
  t0.parcours AS parcours_63,
  t0.reorienter_id AS reorienter_id_64,
  t0.referent_pedagogique_id AS referent_pedagogique_id_65,
  t0.referent_commercial_id AS referent_commercial_id_66,
  t0.referent_coach_id AS referent_coach_id_67,
  t0.referent_administratif_id AS referent_administratif_id_68,
  t0.entreprise_id AS entreprise_id_69,
  t0.entreprise_contact_id AS entreprise_contact_id_70,
  t0.cv_id AS cv_id_71,
  t0.platforme_id AS platforme_id_72,
  t73.id AS id_74,
  t73.created_at AS created_at_75,
  t73.updated_at AS updated_at_76,
  t73.archive AS archive_77,
  t73.token AS token_78,
  t73.intitule AS intitule_79,
  t73.acrrochage AS acrrochage_80,
  t73.document_genere AS document_genere_81,
  t73.date_examen AS date_examen_82,
  t73.created_by_id AS created_by_id_83,
  t73.updated_by_id AS updated_by_id_84,
  t73.admission_id AS admission_id_85,
  t73.mention_id AS mention_id_86,
  t73.president_jury_id AS president_jury_id_87,
  t73.dossier_id AS dossier_id_88,
  t73.parcours_id AS parcours_id_89,
  t73.qr_code_id AS qr_code_id_90,
  t0.emergency_contact_id AS emergency_contact_id_91,
  t0.legal_representative_id AS legal_representative_id_92,
  t0.etablissement_id AS etablissement_id_93
FROM
  dossier t0
  LEFT JOIN diplome t73 ON t73.dossier_id = t0.id
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.reference AS reference_5, t0.items_document AS items_document_6, t0.email_logs AS email_logs_7, t0.panier AS panier_8, t0.competences AS competences_9, t0.cart AS cart_10, t0.mode AS mode_11, t0.linkedin AS linkedin_12, t0.portfolio AS portfolio_13, t0.campus AS campus_14, t0.modalite_enseignement AS modalite_enseignement_15, t0.commentaire AS commentaire_16, t0.email_candidature AS email_candidature_17, t0.date_reunion AS date_reunion_18, t0.stop_date AS stop_date_19, t0.candidate_available AS candidate_available_20, t0.rncp AS rncp_21, t0.diplomant AS diplomant_22, t0.delegue_classe AS delegue_classe_23, t0.postulant_available AS postulant_available_24, t0.prospect_available AS prospect_available_25, t0.stagiaire_available AS stagiaire_available_26, t0.alumni_available AS alumni_available_27, t0.news_letter AS news_letter_28, t0.processed AS processed_29, t0.statut_declaration AS statut_declaration_30, t0.a_representant_legal AS a_representant_legal_31, t0.notification_paiement AS notification_paiement_32, t0.engagement_formation AS engagement_formation_33, t0.charte_formation AS charte_formation_34, t0.compte_zoom AS compte_zoom_35, t0.notified AS notified_36, t0.femme_eloigne AS femme_eloigne_37, t0.zrr AS zrr_38, t0.qpv AS qpv_39, t0.participation_reglee AS participation_reglee_40, t0.participation AS participation_41, t0.caution AS caution_42, t0.restea_regler AS restea_regler_43, t0.created_by_id AS created_by_id_44, t0.updated_by_id AS updated_by_id_45, t0.stop_proof_id AS stop_proof_id_46, t0.stop_cause_id AS stop_cause_id_47, t0.stop_type_id AS stop_type_id_48, t0.type_actif_id AS type_actif_id_49, t0.state_id AS state_id_50, t0.dispositif_id AS dispositif_id_51, t0.type_formation_id AS type_formation_id_52, t0.resultat_id AS resultat_id_53, t0.profil_id AS profil_id_54, t0.personal_informations_id AS personal_informations_id_55, t0.adresse_id AS adresse_id_56, t0.planning_id AS planning_id_57, t0.session_id AS session_id_58, t0.societe_id AS societe_id_59, t0.site_id AS site_id_60, t0.dossierannexes_id AS dossierannexes_id_61, t0.apprenant_id AS apprenant_id_62, t0.parcours AS parcours_63, t0.reorienter_id AS reorienter_id_64, t0.referent_pedagogique_id AS referent_pedagogique_id_65, t0.referent_commercial_id AS referent_commercial_id_66, t0.referent_coach_id AS referent_coach_id_67, t0.referent_administratif_id AS referent_administratif_id_68, t0.entreprise_id AS entreprise_id_69, t0.entreprise_contact_id AS entreprise_contact_id_70, t0.cv_id AS cv_id_71, t0.platforme_id AS platforme_id_72, t73.id AS id_74, t73.created_at AS created_at_75, t73.updated_at AS updated_at_76, t73.archive AS archive_77, t73.token AS token_78, t73.intitule AS intitule_79, t73.acrrochage AS acrrochage_80, t73.document_genere AS document_genere_81, t73.date_examen AS date_examen_82, t73.created_by_id AS created_by_id_83, t73.updated_by_id AS updated_by_id_84, t73.admission_id AS admission_id_85, t73.mention_id AS mention_id_86, t73.president_jury_id AS president_jury_id_87, t73.dossier_id AS dossier_id_88, t73.parcours_id AS parcours_id_89, t73.qr_code_id AS qr_code_id_90, t0.emergency_contact_id AS emergency_contact_id_91, t0.legal_representative_id AS legal_representative_id_92, t0.etablissement_id AS etablissement_id_93 FROM dossier t0 LEFT JOIN diplome t73 ON t73.dossier_id = t0.id WHERE t0.id = 2;

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.intitule AS intitule_5,
  t0.code AS code_6,
  t0.remise_pourc AS remise_pourc_7,
  t0.ordre AS ordre_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.type_formulaire_id AS type_formulaire_id_11,
  t0.api_gestiform_id AS api_gestiform_id_12
FROM
  profil 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.intitule AS intitule_5, t0.code AS code_6, t0.remise_pourc AS remise_pourc_7, t0.ordre AS ordre_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_formulaire_id AS type_formulaire_id_11, t0.api_gestiform_id AS api_gestiform_id_12 FROM profil t0 WHERE t0.id = 4;

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.code AS code_5,
  t0.designation AS designation_6,
  t0.valeur AS valeur_7,
  t0.valeur2 AS valeur2_8,
  t0.htmlvaleur AS htmlvaleur_9,
  t0.valeur3 AS valeur3_10,
  t0.created_by_id AS created_by_id_11,
  t0.updated_by_id AS updated_by_id_12,
  t0.masterliste_id AS masterliste_id_13,
  t0.api_gestiform_id AS api_gestiform_id_14
FROM
  masterlistelg 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.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = 6;

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.code AS code_5,
  t0.designation AS designation_6,
  t0.valeur AS valeur_7,
  t0.valeur2 AS valeur2_8,
  t0.htmlvaleur AS htmlvaleur_9,
  t0.valeur3 AS valeur3_10,
  t0.created_by_id AS created_by_id_11,
  t0.updated_by_id AS updated_by_id_12,
  t0.masterliste_id AS masterliste_id_13,
  t0.api_gestiform_id AS api_gestiform_id_14
FROM
  masterlistelg 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.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = 6110;

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.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.autres_prenoms AS autres_prenoms_7,
  t0.mobile AS mobile_8,
  t0.tel_fixe AS tel_fixe_9,
  t0.ville_naissance AS ville_naissance_10,
  t0.departement_naissance AS departement_naissance_11,
  t0.pays_naissance AS pays_naissance_12,
  t0.nationalite AS nationalite_13,
  t0.fonction AS fonction_14,
  t0.handicap_remarques AS handicap_remarques_15,
  t0.connu_doranco AS connu_doranco_16,
  t0.nir AS nir_17,
  t0.num_secu_sociale AS num_secu_sociale_18,
  t0.reconnaissance_handicap AS reconnaissance_handicap_19,
  t0.handicap AS handicap_20,
  t0.rqth AS rqth_21,
  t0.extension_boe AS extension_boe_22,
  t0.permis_b AS permis_b_23,
  t0.vehicule AS vehicule_24,
  t0.date_naissance AS date_naissance_25,
  t0.date_carte_sejour AS date_carte_sejour_26,
  t0.date_obtention_diplome AS date_obtention_diplome_27,
  t0.nationality AS nationality_28,
  t0.created_by_id AS created_by_id_29,
  t0.updated_by_id AS updated_by_id_30,
  t0.civilite_id AS civilite_id_31,
  t0.categorie_nationalite_id AS categorie_nationalite_id_32,
  t0.regime_social_id AS regime_social_id_33
FROM
  personal_informations 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.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = 28;

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.intitule AS intitule_5,
  t0.intitule_officiel AS intitule_officiel_6,
  t0.code AS code_7,
  t0.code_diplome AS code_diplome_8,
  t0.sigle AS sigle_9,
  t0.date_debut_valide AS date_debut_valide_10,
  t0.date_fin_valide AS date_fin_valide_11,
  t0.date_publication_officiel AS date_publication_officiel_12,
  t0.plus AS plus_13,
  t0.redirection AS redirection_14,
  t0.publication AS publication_15,
  t0.publication_api AS publication_api_16,
  t0.tauxObtention AS tauxObtention_17,
  t0.taux_abandon AS taux_abandon_18,
  t0.taux_satisfaction AS taux_satisfaction_19,
  t0.taux_pour_suite_etude AS taux_pour_suite_etude_20,
  t0.taux_employabilite AS taux_employabilite_21,
  t0.prerequis AS prerequis_22,
  t0.salaire_moyen AS salaire_moyen_23,
  t0.livrable AS livrable_24,
  t0.alt_banniere AS alt_banniere_25,
  t0.alt_vignette AS alt_vignette_26,
  t0.tarif_jury AS tarif_jury_27,
  t0.tarif_jury2 AS tarif_jury2_28,
  t0.tarif_jury_ttc AS tarif_jury_ttc_29,
  t0.cpf AS cpf_30,
  t0.code_cpf AS code_cpf_31,
  t0.code_rncp_rs AS code_rncp_rs_32,
  t0.code_cpf_salarie AS code_cpf_salarie_33,
  t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34,
  t0.code_nsf AS code_nsf_35,
  t0.duree AS duree_36,
  t0.duree_modulaire AS duree_modulaire_37,
  t0.rncp AS rncp_38,
  t0.duree_accompagnement AS duree_accompagnement_39,
  t0.duree_stage AS duree_stage_40,
  t0.duree_center AS duree_center_41,
  t0.duree_elearning AS duree_elearning_42,
  t0.stage_obligatoire AS stage_obligatoire_43,
  t0.formation_permanente AS formation_permanente_44,
  t0.sanction_resume AS sanction_resume_45,
  t0.sanction_long AS sanction_long_46,
  t0.metier AS metier_47,
  t0.accessibilite_handicap AS accessibilite_handicap_48,
  t0.modalites_delais_acces AS modalites_delais_acces_49,
  t0.modaliteevaluationinitial AS modaliteevaluationinitial_50,
  t0.modaliteevaluationfinal AS modaliteevaluationfinal_51,
  t0.text AS text_52,
  t0.objectif AS objectif_53,
  t0.debouche AS debouche_54,
  t0.condition_admission AS condition_admission_55,
  t0.public AS public_56,
  t0.detail_examen AS detail_examen_57,
  t0.frais_pedagogique AS frais_pedagogique_58,
  t0.methodes_mobilisees AS methodes_mobilisees_59,
  t0.seo_titre AS seo_titre_60,
  t0.seo_description AS seo_description_61,
  t0.rythme AS rythme_62,
  t0.identifiant_dokelio AS identifiant_dokelio_63,
  t0.dokelio_parcours AS dokelio_parcours_64,
  t0.contenu_apres AS contenu_apres_65,
  t0.contenu_avant AS contenu_avant_66,
  t0.path AS path_67,
  t0.items AS items_68,
  t0.is_default AS is_default_69,
  t0.created_by_id AS created_by_id_70,
  t0.updated_by_id AS updated_by_id_71,
  t0.theme_id AS theme_id_72,
  t0.parent_id AS parent_id_73,
  t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74,
  t0.nsf_id AS nsf_id_75,
  t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76,
  t0.parcours AS parcours_77,
  t0.niveau_entree_id AS niveau_entree_id_78,
  t0.niveau_sortie_id AS niveau_sortie_id_79,
  t0.niveau_technique_id AS niveau_technique_id_80,
  t0.qualifiant_id AS qualifiant_id_81,
  t0.type_formation_id AS type_formation_id_82,
  t0.autorite_delivrance_id AS autorite_delivrance_id_83,
  t0.mode_formation_id AS mode_formation_id_84,
  t0.banniere_id AS banniere_id_85,
  t0.vignette_id AS vignette_id_86
FROM
  parcours t0
WHERE
  t0.id = ?