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

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

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.name AS name_5,
  t0.original_name AS original_name_6,
  t0.directory AS directory_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  upload 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.name AS name_5, t0.original_name AS original_name_6, t0.directory AS directory_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM upload t0 WHERE t0.id = 84;

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.titre AS titre_5,
  t0.valide AS valide_6,
  t0.created_by_id AS created_by_id_7,
  t0.updated_by_id AS updated_by_id_8,
  t0.document_id AS document_id_9,
  t0.dossier_id AS dossier_id_10,
  t0.entreprise_id AS entreprise_id_11,
  t0.personne_id AS personne_id_12,
  t0.parcours_id AS parcours_id_13,
  t0.module_id AS module_id_14,
  t0.template_id AS template_id_15,
  t0.type_document_id AS type_document_id_16,
  t0.module_competence_id AS module_competence_id_17,
  t0.bloc_competence_id AS bloc_competence_id_18,
  t0.employe_id AS employe_id_19
FROM
  document t0
WHERE
  t0.module_competence_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.titre AS titre_5, t0.valide AS valide_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.document_id AS document_id_9, t0.dossier_id AS dossier_id_10, t0.entreprise_id AS entreprise_id_11, t0.personne_id AS personne_id_12, t0.parcours_id AS parcours_id_13, t0.module_id AS module_id_14, t0.template_id AS template_id_15, t0.type_document_id AS type_document_id_16, t0.module_competence_id AS module_competence_id_17, t0.bloc_competence_id AS bloc_competence_id_18, t0.employe_id AS employe_id_19 FROM document t0 WHERE t0.module_competence_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.start AS start_5,
  t0.end AS end_6,
  t0.total_days AS total_days_7,
  t0.stage_duration AS stage_duration_8,
  t0.accompaniment_duration AS accompaniment_duration_9,
  t0.center_duration AS center_duration_10,
  t0.jury_duration AS jury_duration_11,
  t0.strict_mode AS strict_mode_12,
  t0.created_by_id AS created_by_id_13,
  t0.updated_by_id AS updated_by_id_14,
  t15.id AS id_16,
  t15.created_at AS created_at_17,
  t15.updated_at AS updated_at_18,
  t15.archive AS archive_19,
  t15.intitule AS intitule_20,
  t15.type AS type_21,
  t15.session_dokelio AS session_dokelio_22,
  t15.dokelio_parcours AS dokelio_parcours_23,
  t15.simul_nb_apprenants AS simul_nb_apprenants_24,
  t15.numero_session AS numero_session_25,
  t15.duree AS duree_26,
  t15.date_debut AS date_debut_27,
  t15.date_debut_affichage AS date_debut_affichage_28,
  t15.date_fin_affichage AS date_fin_affichage_29,
  t15.site_partenaire AS site_partenaire_30,
  t15.guaranteed AS guaranteed_31,
  t15.permenant AS permenant_32,
  t15.publie_site AS publie_site_33,
  t15.dates_larges AS dates_larges_34,
  t15.lieu AS lieu_35,
  t15.modalite_par_defaut AS modalite_par_defaut_36,
  t15.created_by_id AS created_by_id_37,
  t15.updated_by_id AS updated_by_id_38,
  t15.salle_defaut_id AS salle_defaut_id_39,
  t15.parcours_id AS parcours_id_40,
  t15.adresse_partenaire_id AS adresse_partenaire_id_41,
  t15.statut_id AS statut_id_42,
  t15.referent_pedagogique_id AS referent_pedagogique_id_43,
  t15.referent_coach_id AS referent_coach_id_44,
  t15.referent_administratif_id AS referent_administratif_id_45,
  t15.referent_handicap_id AS referent_handicap_id_46,
  t15.planning_id AS planning_id_47,
  t15.site_id AS site_id_48,
  t15.api_gestiform_id AS api_gestiform_id_49,
  t0.parent_id AS parent_id_50,
  t51.id AS id_52,
  t51.created_at AS created_at_53,
  t51.updated_at AS updated_at_54,
  t51.archive AS archive_55,
  t51.reference AS reference_56,
  t51.items_document AS items_document_57,
  t51.email_logs AS email_logs_58,
  t51.panier AS panier_59,
  t51.competences AS competences_60,
  t51.cart AS cart_61,
  t51.mode AS mode_62,
  t51.linkedin AS linkedin_63,
  t51.portfolio AS portfolio_64,
  t51.campus AS campus_65,
  t51.modalite_enseignement AS modalite_enseignement_66,
  t51.commentaire AS commentaire_67,
  t51.email_candidature AS email_candidature_68,
  t51.date_reunion AS date_reunion_69,
  t51.stop_date AS stop_date_70,
  t51.candidate_available AS candidate_available_71,
  t51.rncp AS rncp_72,
  t51.diplomant AS diplomant_73,
  t51.delegue_classe AS delegue_classe_74,
  t51.postulant_available AS postulant_available_75,
  t51.prospect_available AS prospect_available_76,
  t51.stagiaire_available AS stagiaire_available_77,
  t51.alumni_available AS alumni_available_78,
  t51.news_letter AS news_letter_79,
  t51.processed AS processed_80,
  t51.statut_declaration AS statut_declaration_81,
  t51.a_representant_legal AS a_representant_legal_82,
  t51.notification_paiement AS notification_paiement_83,
  t51.engagement_formation AS engagement_formation_84,
  t51.charte_formation AS charte_formation_85,
  t51.compte_zoom AS compte_zoom_86,
  t51.notified AS notified_87,
  t51.femme_eloigne AS femme_eloigne_88,
  t51.zrr AS zrr_89,
  t51.qpv AS qpv_90,
  t51.participation_reglee AS participation_reglee_91,
  t51.participation AS participation_92,
  t51.caution AS caution_93,
  t51.restea_regler AS restea_regler_94,
  t51.created_by_id AS created_by_id_95,
  t51.updated_by_id AS updated_by_id_96,
  t51.stop_proof_id AS stop_proof_id_97,
  t51.stop_cause_id AS stop_cause_id_98,
  t51.stop_type_id AS stop_type_id_99,
  t51.type_actif_id AS type_actif_id_100,
  t51.state_id AS state_id_101,
  t51.dispositif_id AS dispositif_id_102,
  t51.type_formation_id AS type_formation_id_103,
  t51.resultat_id AS resultat_id_104,
  t51.profil_id AS profil_id_105,
  t51.personal_informations_id AS personal_informations_id_106,
  t51.adresse_id AS adresse_id_107,
  t51.planning_id AS planning_id_108,
  t51.session_id AS session_id_109,
  t51.societe_id AS societe_id_110,
  t51.site_id AS site_id_111,
  t51.dossierannexes_id AS dossierannexes_id_112,
  t51.apprenant_id AS apprenant_id_113,
  t51.parcours_id AS parcours_id_114,
  t51.reorienter_id AS reorienter_id_115,
  t51.referent_pedagogique_id AS referent_pedagogique_id_116,
  t51.referent_commercial_id AS referent_commercial_id_117,
  t51.referent_coach_id AS referent_coach_id_118,
  t51.referent_administratif_id AS referent_administratif_id_119,
  t51.entreprise_id AS entreprise_id_120,
  t51.entreprise_contact_id AS entreprise_contact_id_121,
  t51.cv_id AS cv_id_122,
  t51.platforme_id AS platforme_id_123,
  t51.emergency_contact_id AS emergency_contact_id_124,
  t51.legal_representative_id AS legal_representative_id_125,
  t51.etablissement_id AS etablissement_id_126
FROM
  planning t0
  LEFT JOIN session t15 ON t15.planning_id = t0.id
  LEFT JOIN dossier t51 ON t51.planning_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.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.lieu AS lieu_35, t15.modalite_par_defaut AS modalite_par_defaut_36, t15.created_by_id AS created_by_id_37, t15.updated_by_id AS updated_by_id_38, t15.salle_defaut_id AS salle_defaut_id_39, t15.parcours_id AS parcours_id_40, t15.adresse_partenaire_id AS adresse_partenaire_id_41, t15.statut_id AS statut_id_42, t15.referent_pedagogique_id AS referent_pedagogique_id_43, t15.referent_coach_id AS referent_coach_id_44, t15.referent_administratif_id AS referent_administratif_id_45, t15.referent_handicap_id AS referent_handicap_id_46, t15.planning_id AS planning_id_47, t15.site_id AS site_id_48, t15.api_gestiform_id AS api_gestiform_id_49, t0.parent_id AS parent_id_50, t51.id AS id_52, t51.created_at AS created_at_53, t51.updated_at AS updated_at_54, t51.archive AS archive_55, t51.reference AS reference_56, t51.items_document AS items_document_57, t51.email_logs AS email_logs_58, t51.panier AS panier_59, t51.competences AS competences_60, t51.cart AS cart_61, t51.mode AS mode_62, t51.linkedin AS linkedin_63, t51.portfolio AS portfolio_64, t51.campus AS campus_65, t51.modalite_enseignement AS modalite_enseignement_66, t51.commentaire AS commentaire_67, t51.email_candidature AS email_candidature_68, t51.date_reunion AS date_reunion_69, t51.stop_date AS stop_date_70, t51.candidate_available AS candidate_available_71, t51.rncp AS rncp_72, t51.diplomant AS diplomant_73, t51.delegue_classe AS delegue_classe_74, t51.postulant_available AS postulant_available_75, t51.prospect_available AS prospect_available_76, t51.stagiaire_available AS stagiaire_available_77, t51.alumni_available AS alumni_available_78, t51.news_letter AS news_letter_79, t51.processed AS processed_80, t51.statut_declaration AS statut_declaration_81, t51.a_representant_legal AS a_representant_legal_82, t51.notification_paiement AS notification_paiement_83, t51.engagement_formation AS engagement_formation_84, t51.charte_formation AS charte_formation_85, t51.compte_zoom AS compte_zoom_86, t51.notified AS notified_87, t51.femme_eloigne AS femme_eloigne_88, t51.zrr AS zrr_89, t51.qpv AS qpv_90, t51.participation_reglee AS participation_reglee_91, t51.participation AS participation_92, t51.caution AS caution_93, t51.restea_regler AS restea_regler_94, t51.created_by_id AS created_by_id_95, t51.updated_by_id AS updated_by_id_96, t51.stop_proof_id AS stop_proof_id_97, t51.stop_cause_id AS stop_cause_id_98, t51.stop_type_id AS stop_type_id_99, t51.type_actif_id AS type_actif_id_100, t51.state_id AS state_id_101, t51.dispositif_id AS dispositif_id_102, t51.type_formation_id AS type_formation_id_103, t51.resultat_id AS resultat_id_104, t51.profil_id AS profil_id_105, t51.personal_informations_id AS personal_informations_id_106, t51.adresse_id AS adresse_id_107, t51.planning_id AS planning_id_108, t51.session_id AS session_id_109, t51.societe_id AS societe_id_110, t51.site_id AS site_id_111, t51.dossierannexes_id AS dossierannexes_id_112, t51.apprenant_id AS apprenant_id_113, t51.parcours_id AS parcours_id_114, t51.reorienter_id AS reorienter_id_115, t51.referent_pedagogique_id AS referent_pedagogique_id_116, t51.referent_commercial_id AS referent_commercial_id_117, t51.referent_coach_id AS referent_coach_id_118, t51.referent_administratif_id AS referent_administratif_id_119, t51.entreprise_id AS entreprise_id_120, t51.entreprise_contact_id AS entreprise_contact_id_121, t51.cv_id AS cv_id_122, t51.platforme_id AS platforme_id_123, t51.emergency_contact_id AS emergency_contact_id_124, t51.legal_representative_id AS legal_representative_id_125, t51.etablissement_id AS etablissement_id_126 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t51 ON t51.planning_id = t0.id WHERE t0.id = 33;

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.type AS type_6,
  t0.evaluations AS evaluations_7,
  t0.aevaluer AS aevaluer_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  competence 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.type AS type_6, t0.evaluations AS evaluations_7, t0.aevaluer AS aevaluer_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM competence t0 WHERE t0.id = 19;

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.modalite_evaluations AS modalite_evaluations_5,
  t0.duree AS duree_6,
  t0.ordre AS ordre_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.competence_id AS competence_id_10,
  t0.module_id AS module_id_11,
  t0.quiz_id AS quiz_id_12
FROM
  module_competence t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.ordre ASC,
  t0.id ASC

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.modalite_evaluations AS modalite_evaluations_5, t0.duree AS duree_6, t0.ordre AS ordre_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.competence_id AS competence_id_10, t0.module_id AS module_id_11, t0.quiz_id AS quiz_id_12 FROM module_competence t0 WHERE t0.module_id = 1 ORDER BY t0.ordre ASC, t0.id ASC;

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
  INNER JOIN module_competence_procede_evaluations ON t0.id = module_competence_procede_evaluations.masterlistelg_id
WHERE
  module_competence_procede_evaluations.module_competence_competence_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 INNER JOIN module_competence_procede_evaluations ON t0.id = module_competence_procede_evaluations.masterlistelg_id WHERE module_competence_procede_evaluations.module_competence_competence_id = 1;

SELECT
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.archive AS archive_5,
  t0.intitule AS intitule_6,
  t0.duree AS duree_7,
  t0.publie AS publie_8,
  t0.cpf AS cpf_9,
  t0.certifiantes AS certifiantes_10,
  t0.is_default AS is_default_11,
  t0.certifiante AS certifiante_12,
  t0.code AS code_13,
  t0.modalitepedagogiques AS modalitepedagogiques_14,
  t0.statistiques AS statistiques_15,
  t0.modaliteevaluationinitial AS modaliteevaluationinitial_16,
  t0.modaliteevaluationfinal AS modaliteevaluationfinal_17,
  t0.path AS path_18,
  t0.code_cpf AS code_cpf_19,
  t0.code_cpf_salarie AS code_cpf_salarie_20,
  t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21,
  t0.tarif_inter_jour AS tarif_inter_jour_22,
  t0.tarif_inter_horaire AS tarif_inter_horaire_23,
  t0.tarif_intra_jour AS tarif_intra_jour_24,
  t0.tarif_intra_horaire AS tarif_intra_horaire_25,
  t0.tarif_jury AS tarif_jury_26,
  t0.tarif_jury2 AS tarif_jury2_27,
  t0.tarif_jury_ttc AS tarif_jury_ttc_28,
  t0.prerequis AS prerequis_29,
  t0.objectif AS objectif_30,
  t0.plus AS plus_31,
  t0.public AS public_32,
  t0.commentaire AS commentaire_33,
  t0.certification_commentaire AS certification_commentaire_34,
  t0.seo_titre AS seo_titre_35,
  t0.seo_description AS seo_description_36,
  t0.info_pratique AS info_pratique_37,
  t0.accessibilite_handicap AS accessibilite_handicap_38,
  t0.alt_vignette AS alt_vignette_39,
  t0.description AS description_40,
  t0.modalites_delais_acces AS modalites_delais_acces_41,
  t0.alt_banniere AS alt_banniere_42,
  t0.identifiant_dokelio AS identifiant_dokelio_43,
  t0.publication AS publication_44,
  t0.contenu_apres AS contenu_apres_45,
  t0.contenu_avant AS contenu_avant_46,
  t0.tauxObtention AS tauxObtention_47,
  t0.tauxAbandon AS tauxAbandon_48,
  t0.tauxSatisfaction AS tauxSatisfaction_49,
  t0.tauxPourSuiteEtude AS tauxPourSuiteEtude_50,
  t0.tauxEmployabilite AS tauxEmployabilite_51,
  t0.salaireMoyen AS salaireMoyen_52,
  t0.nbrsessioninter AS nbrsessioninter_53,
  t0.nbrsessionintra AS nbrsessionintra_54,
  t0.modes_formation AS modes_formation_55,
  t0.created_by_id AS created_by_id_56,
  t0.updated_by_id AS updated_by_id_57,
  t0.mode_formation_id AS mode_formation_id_58,
  t0.sous_theme_theme_id AS sous_theme_theme_id_59,
  t0.theme_tarif_id AS theme_tarif_id_60,
  t0.niveaumateriel_id AS niveaumateriel_id_61,
  t0.niveautechnique_id AS niveautechnique_id_62,
  t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_63,
  t0.banniere_id AS banniere_id_64,
  t0.vignette_id AS vignette_id_65,
  t0.api_gestiform_id AS api_gestiform_id_66,
  t0.type,
  t1.date_inscription AS date_inscription_67,
  t1.programme AS programme_68,
  t1.certification AS certification_69,
  t1.tarif_vente AS tarif_vente_70,
  t1.editeur_id AS editeur_id_71,
  t1.theme_id AS theme_id_72
FROM
  module t0
  LEFT JOIN certification t1 ON t0.id = t1.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.tarif_jury2 AS tarif_jury2_27, t0.tarif_jury_ttc AS tarif_jury_ttc_28, t0.prerequis AS prerequis_29, t0.objectif AS objectif_30, t0.plus AS plus_31, t0.public AS public_32, t0.commentaire AS commentaire_33, t0.certification_commentaire AS certification_commentaire_34, t0.seo_titre AS seo_titre_35, t0.seo_description AS seo_description_36, t0.info_pratique AS info_pratique_37, t0.accessibilite_handicap AS accessibilite_handicap_38, t0.alt_vignette AS alt_vignette_39, t0.description AS description_40, t0.modalites_delais_acces AS modalites_delais_acces_41, t0.alt_banniere AS alt_banniere_42, t0.identifiant_dokelio AS identifiant_dokelio_43, t0.publication AS publication_44, t0.contenu_apres AS contenu_apres_45, t0.contenu_avant AS contenu_avant_46, t0.tauxObtention AS tauxObtention_47, t0.tauxAbandon AS tauxAbandon_48, t0.tauxSatisfaction AS tauxSatisfaction_49, t0.tauxPourSuiteEtude AS tauxPourSuiteEtude_50, t0.tauxEmployabilite AS tauxEmployabilite_51, t0.salaireMoyen AS salaireMoyen_52, t0.nbrsessioninter AS nbrsessioninter_53, t0.nbrsessionintra AS nbrsessionintra_54, t0.modes_formation AS modes_formation_55, t0.created_by_id AS created_by_id_56, t0.updated_by_id AS updated_by_id_57, t0.mode_formation_id AS mode_formation_id_58, t0.sous_theme_theme_id AS sous_theme_theme_id_59, t0.theme_tarif_id AS theme_tarif_id_60, t0.niveaumateriel_id AS niveaumateriel_id_61, t0.niveautechnique_id AS niveautechnique_id_62, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_63, t0.banniere_id AS banniere_id_64, t0.vignette_id AS vignette_id_65, t0.api_gestiform_id AS api_gestiform_id_66, t0.type, t1.date_inscription AS date_inscription_67, t1.programme AS programme_68, t1.certification AS certification_69, t1.tarif_vente AS tarif_vente_70, t1.editeur_id AS editeur_id_71, t1.theme_id AS theme_id_72 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.code = 'GES1' 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.modalite_evaluations AS modalite_evaluations_5,
  t0.duree AS duree_6,
  t0.ordre AS ordre_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9,
  t0.competence_id AS competence_id_10,
  t0.module_id AS module_id_11,
  t0.quiz_id AS quiz_id_12
FROM
  module_competence t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.ordre ASC

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.modalite_evaluations AS modalite_evaluations_5, t0.duree AS duree_6, t0.ordre AS ordre_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.competence_id AS competence_id_10, t0.module_id AS module_id_11, t0.quiz_id AS quiz_id_12 FROM module_competence t0 WHERE t0.module_id = 1 ORDER BY t0.ordre ASC;

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.raison_sociale AS raison_sociale_6,
  t1.siret AS siret_7,
  t1.site_web AS site_web_8,
  t1.numero_uai AS numero_uai_9,
  t1.code_ape AS code_ape_10,
  t1.assurance AS assurance_11,
  t1.domaine AS domaine_12,
  t1.code_banque AS code_banque_13,
  t1.num_compte AS num_compte_14,
  t1.iban AS iban_15,
  t1.domiciliation AS domiciliation_16,
  t1.email AS email_17,
  t1.prevoyance AS prevoyance_18,
  t1.num_tva AS num_tva_19,
  t1.description AS description_20,
  t1.cfa_entreprise AS cfa_entreprise_21,
  t1.sous_traitant AS sous_traitant_22,
  t1.prive AS prive_23,
  t1.num_activite AS num_activite_24,
  t1.mobile AS mobile_25,
  t1.fax AS fax_26,
  t1.fixe AS fixe_27,
  t1.siren AS siren_28,
  t1.forme_juridique AS forme_juridique_29,
  t1.urssaf AS urssaf_30,
  t1.caisse_retraite AS caisse_retraite_31,
  t0.intitule AS intitule_32,
  t0.alt AS alt_33,
  t0.commentaire AS commentaire_34,
  t0.detail AS detail_35,
  t0.lien AS lien_36,
  t0.seotitre AS seotitre_37,
  t0.seodescription AS seodescription_38,
  t0.keywords AS keywords_39,
  t0.remise AS remise_40,
  t1.created_by_id AS created_by_id_41,
  t1.updated_by_id AS updated_by_id_42,
  t1.logo_id AS logo_id_43,
  t1.convention_collective_id AS convention_collective_id_44,
  t1.code_tva_id AS code_tva_id_45,
  t1.personne_id AS personne_id_46,
  t1.api_gestiform_id AS api_gestiform_id_47,
  t0.category_id AS category_id_48,
  t0.financement_opco_id AS financement_opco_id_49,
  t0.type_id AS type_id_50,
  t1.type
FROM
  financeur t0
  INNER JOIN tiers t1 ON t0.id = t1.id
  INNER JOIN module_financeur ON t0.id = module_financeur.financeur_id
WHERE
  module_financeur.module_id = ?

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.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.intitule AS intitule_32, t0.alt AS alt_33, t0.commentaire AS commentaire_34, t0.detail AS detail_35, t0.lien AS lien_36, t0.seotitre AS seotitre_37, t0.seodescription AS seodescription_38, t0.keywords AS keywords_39, t0.remise AS remise_40, t1.created_by_id AS created_by_id_41, t1.updated_by_id AS updated_by_id_42, t1.logo_id AS logo_id_43, t1.convention_collective_id AS convention_collective_id_44, t1.code_tva_id AS code_tva_id_45, t1.personne_id AS personne_id_46, t1.api_gestiform_id AS api_gestiform_id_47, t0.category_id AS category_id_48, t0.financement_opco_id AS financement_opco_id_49, t0.type_id AS type_id_50, t1.type FROM financeur t0 INNER JOIN tiers t1 ON t0.id = t1.id INNER JOIN module_financeur ON t0.id = module_financeur.financeur_id WHERE module_financeur.module_id = 1;

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;