Query Metrics
64
Database Queries
9
Different statements
14.91 ms
Query time
5
Invalid entities
188
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.76 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
1
]
|
2 | 0.44 ms |
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
Parameters:
[ "NBHRSFORMATION" "NOYAU" "PARAMETRAGE" ] |
3 | 0.27 ms |
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 = ?
Parameters:
[
"2"
]
|
4 | 0.17 ms |
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 = ?
Parameters:
[
"1"
]
|
5 | 0.32 ms |
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.archive AS archive_3, o0_.soumis_tva AS soumis_tva_4, o0_.ordre AS ordre_5, o0_.created_by_id AS created_by_id_6, o0_.updated_by_id AS updated_by_id_7, o0_.formation_id AS formation_id_8, o0_.dispositif_id AS dispositif_id_9, o0_.profil AS profil_10, o0_.api_gestiform_id AS api_gestiform_id_11 FROM offre_formation o0_ LEFT JOIN masterlistelg m1_ ON o0_.formation_id = m1_.id WHERE o0_.profil = ? GROUP BY o0_.dispositif_id
Parameters:
[
2
]
|
6 | 0.18 ms |
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 = ?
Parameters:
[
11
]
|
7 | 0.30 ms |
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 = ?
Parameters:
[
13
]
|
8 | 0.14 ms |
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 = ?
Parameters:
[
14
]
|
9 | 0.13 ms |
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 = ?
Parameters:
[
19
]
|
10 | 0.13 ms |
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 = ?
Parameters:
[
23
]
|
11 | 0.13 ms |
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 = ?
Parameters:
[
24
]
|
12 | 0.11 ms |
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 = ?
Parameters:
[
25
]
|
13 | 0.14 ms |
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 = ?
Parameters:
[
26
]
|
14 | 0.11 ms |
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 = ?
Parameters:
[
27
]
|
15 | 0.11 ms |
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 = ?
Parameters:
[
6110
]
|
16 | 0.50 ms |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.archive AS archive_3, p0_.intitule AS intitule_4, p0_.intitule_officiel AS intitule_officiel_5, p0_.code AS code_6, p0_.code_diplome AS code_diplome_7, p0_.sigle AS sigle_8, p0_.date_debut_valide AS date_debut_valide_9, p0_.date_fin_valide AS date_fin_valide_10, p0_.date_publication_officiel AS date_publication_officiel_11, p0_.plus AS plus_12, p0_.redirection AS redirection_13, p0_.publication AS publication_14, p0_.publication_api AS publication_api_15, p0_.taux_obtention AS taux_obtention_16, p0_.taux_abandon AS taux_abandon_17, p0_.taux_satisfaction AS taux_satisfaction_18, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_19, p0_.taux_employabilite AS taux_employabilite_20, p0_.prerequis AS prerequis_21, p0_.salaire_moyen AS salaire_moyen_22, p0_.livrable AS livrable_23, p0_.alt_banniere AS alt_banniere_24, p0_.alt_vignette AS alt_vignette_25, p0_.tarif_jury AS tarif_jury_26, p0_.tarif_jury2 AS tarif_jury2_27, p0_.cpf AS cpf_28, p0_.code_cpf AS code_cpf_29, p0_.code_rncp_rs AS code_rncp_rs_30, p0_.code_cpf_salarie AS code_cpf_salarie_31, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_32, p0_.code_nsf AS code_nsf_33, p0_.duree AS duree_34, p0_.duree_modulaire AS duree_modulaire_35, p0_.rncp AS rncp_36, p0_.duree_accompagnement AS duree_accompagnement_37, p0_.duree_stage AS duree_stage_38, p0_.duree_center AS duree_center_39, p0_.duree_elearning AS duree_elearning_40, p0_.stage_obligatoire AS stage_obligatoire_41, p0_.formation_permanente AS formation_permanente_42, p0_.sanction_resume AS sanction_resume_43, p0_.sanction_long AS sanction_long_44, p0_.metier AS metier_45, p0_.text AS text_46, p0_.objectif AS objectif_47, p0_.debouche AS debouche_48, p0_.condition_admission AS condition_admission_49, p0_.public AS public_50, p0_.detail_examen AS detail_examen_51, p0_.frais_pedagogique AS frais_pedagogique_52, p0_.seo_titre AS seo_titre_53, p0_.seo_description AS seo_description_54, p0_.rythme AS rythme_55, p0_.identifiant_dokelio AS identifiant_dokelio_56, p0_.dokelio_parcours AS dokelio_parcours_57, p0_.contenu_apres AS contenu_apres_58, p0_.contenu_avant AS contenu_avant_59, p0_.path AS path_60, p0_.items AS items_61, p0_.is_default AS is_default_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_.parent_id IS NOT NULL AND p0_.archive = 0 AND p0_.type_formation_id = ?
Parameters:
[
1
]
|
17 | 0.43 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
74
]
|
18 | 0.19 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
68
]
|
19 | 0.15 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
64
]
|
20 | 0.31 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
72
]
|
21 | 0.34 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
13
]
|
22 | 0.31 ms |
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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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 = ?
Parameters:
[
122
]
|
23 | 0.49 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
31
]
|
24 | 0.38 ms |
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.acrrochage AS acrrochage_6, t0.date_examen AS date_examen_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.admission_id AS admission_id_10, t0.mention_id AS mention_id_11, t0.president_jury_id AS president_jury_id_12, t0.dossier_id AS dossier_id_13, t0.parcours_id AS parcours_id_14 FROM diplome t0 WHERE t0.dossier_id = ?
Parameters:
[
65
]
|
25 | 0.47 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
45
]
|
26 | 0.26 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
113
]
|
27 | 0.23 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
118
]
|
28 | 0.22 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
119
]
|
29 | 0.16 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
17
]
|
30 | 0.23 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
50
]
|
31 | 0.17 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
130
]
|
32 | 0.14 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
134
]
|
33 | 0.26 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
162
]
|
34 | 0.17 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
139
]
|
35 | 2.34 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
142
]
|
36 | 0.18 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
147
]
|
37 | 0.14 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
151
]
|
38 | 0.13 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
156
]
|
39 | 0.13 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
187
]
|
40 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
189
]
|
41 | 0.13 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
193
]
|
42 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
213
]
|
43 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
216
]
|
44 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
224
]
|
45 | 0.10 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
230
]
|
46 | 0.10 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
326
]
|
47 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
329
]
|
48 | 0.10 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
337
]
|
49 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
340
]
|
50 | 0.10 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
346
]
|
51 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
349
]
|
52 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
358
]
|
53 | 0.10 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
399
]
|
54 | 0.14 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
400
]
|
55 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
401
]
|
56 | 0.11 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
403
]
|
57 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
405
]
|
58 | 0.30 ms |
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.publie_site AS publie_site_31, t15.dates_larges AS dates_larges_32, t15.created_by_id AS created_by_id_33, t15.updated_by_id AS updated_by_id_34, t15.salle_defaut_id AS salle_defaut_id_35, t15.parcours_id AS parcours_id_36, t15.adresse_partenaire_id AS adresse_partenaire_id_37, t15.statut_id AS statut_id_38, t15.referent_pedagogique_id AS referent_pedagogique_id_39, t15.referent_coach_id AS referent_coach_id_40, t15.referent_administratif_id AS referent_administratif_id_41, t15.referent_handicap_id AS referent_handicap_id_42, t15.planning_id AS planning_id_43, t15.site_id AS site_id_44, t15.api_gestiform_id AS api_gestiform_id_45, t0.parent_id AS parent_id_46, t47.id AS id_48, t47.created_at AS created_at_49, t47.updated_at AS updated_at_50, t47.archive AS archive_51, t47.reference AS reference_52, t47.items_document AS items_document_53, t47.panier AS panier_54, t47.competences AS competences_55, t47.cart AS cart_56, t47.mode AS mode_57, t47.linkedin AS linkedin_58, t47.portfolio AS portfolio_59, t47.campus AS campus_60, t47.modalite_enseignement AS modalite_enseignement_61, t47.commentaire AS commentaire_62, t47.email_candidature AS email_candidature_63, t47.date_reunion AS date_reunion_64, t47.stop_date AS stop_date_65, t47.candidate_available AS candidate_available_66, t47.rncp AS rncp_67, t47.diplomant AS diplomant_68, t47.delegue_classe AS delegue_classe_69, t47.postulant_available AS postulant_available_70, t47.prospect_available AS prospect_available_71, t47.stagiaire_available AS stagiaire_available_72, t47.alumni_available AS alumni_available_73, t47.news_letter AS news_letter_74, t47.processed AS processed_75, t47.statut_declaration AS statut_declaration_76, t47.a_representant_legal AS a_representant_legal_77, t47.notification_paiement AS notification_paiement_78, t47.engagement_formation AS engagement_formation_79, t47.charte_formation AS charte_formation_80, t47.compte_zoom AS compte_zoom_81, t47.notified AS notified_82, t47.femme_eloigne AS femme_eloigne_83, t47.zrr AS zrr_84, t47.qpv AS qpv_85, t47.participation_reglee AS participation_reglee_86, t47.participation AS participation_87, t47.caution AS caution_88, t47.restea_regler AS restea_regler_89, t47.created_by_id AS created_by_id_90, t47.updated_by_id AS updated_by_id_91, t47.stop_proof_id AS stop_proof_id_92, t47.stop_cause_id AS stop_cause_id_93, t47.stop_type_id AS stop_type_id_94, t47.type_actif_id AS type_actif_id_95, t47.state_id AS state_id_96, t47.dispositif_id AS dispositif_id_97, t47.type_formation_id AS type_formation_id_98, t47.resultat_id AS resultat_id_99, t47.profil_id AS profil_id_100, t47.personal_informations_id AS personal_informations_id_101, t47.adresse_id AS adresse_id_102, t47.planning_id AS planning_id_103, t47.session_id AS session_id_104, t47.societe_id AS societe_id_105, t47.site_id AS site_id_106, t47.dossierannexes_id AS dossierannexes_id_107, t47.apprenant_id AS apprenant_id_108, t47.parcours_id AS parcours_id_109, t47.reorienter_id AS reorienter_id_110, t47.referent_pedagogique_id AS referent_pedagogique_id_111, t47.referent_commercial_id AS referent_commercial_id_112, t47.referent_coach_id AS referent_coach_id_113, t47.referent_administratif_id AS referent_administratif_id_114, t47.entreprise_id AS entreprise_id_115, t47.entreprise_contact_id AS entreprise_contact_id_116, t47.cv_id AS cv_id_117, t47.platforme_id AS platforme_id_118, t47.emergency_contact_id AS emergency_contact_id_119, t47.legal_representative_id AS legal_representative_id_120, t47.etablissement_id AS etablissement_id_121 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t47 ON t47.planning_id = t0.id WHERE t0.id = ?
Parameters:
[
66
]
|
59 | 0.15 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
473
]
|
60 | 0.15 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
474
]
|
61 | 0.13 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
480
]
|
62 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
481
]
|
63 | 0.12 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
483
]
|
64 | 0.13 ms |
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.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.publie_site AS publie_site_16, t0.dates_larges AS dates_larges_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.salle_defaut_id AS salle_defaut_id_20, t0.parcours_id AS parcours_id_21, t0.adresse_partenaire_id AS adresse_partenaire_id_22, t0.statut_id AS statut_id_23, t0.referent_pedagogique_id AS referent_pedagogique_id_24, t0.referent_coach_id AS referent_coach_id_25, t0.referent_administratif_id AS referent_administratif_id_26, t0.referent_handicap_id AS referent_handicap_id_27, t0.planning_id AS planning_id_28, t0.site_id AS site_id_29, t0.api_gestiform_id AS api_gestiform_id_30 FROM session t0 WHERE t0.parcours_id = ?
Parameters:
[
488
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours | 64 |
App\Entity\Gestiform\Admin\MasterListe\Masterlistelg | 35 |
App\Entity\Gestiform\Formations\Catalogue\Niveau | 15 |
App\Entity\Gestiform\Users\User | 14 |
App\Entity\Gestiform\Formations\Catalogue\Filiere | 11 |
App\Entity\Gestiform\Admin\OffreFormation | 10 |
App\Entity\Gestiform\Formations\Session\Session | 8 |
App\Entity\Gestiform\Formations\Session\Planning\Planning | 8 |
App\Entity\Gestiform\Formations\Dossier\PersonalInformations | 7 |
App\Entity\Gestiform\Admin\MasterListe\Masterliste | 3 |
App\Entity\Common\Adresse | 2 |
App\Entity\Gestiform\Admin\ApiGestiform | 2 |
App\Entity\Gestiform\Admin\Tiers | 2 |
App\Entity\Gestiform\Admin\Profil | 1 |
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme | 1 |
App\Entity\Gestiform\Formations\Dossier\Dossier | 1 |
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes | 1 |
App\Entity\Gestiform\Formations\Entreprise\Contact | 1 |
App\Entity\Gestiform\Admin\Etablissement | 1 |
App\Entity\Gestiform\Admin\Site | 1 |