Symfony Profiler

Query Metrics

330 Database Queries

59 Different statements

76.86 ms Query time

0 Invalid entities

653 Managed entities

Grouped Statements

Time▼	Count	Info
13.78 ms (17.92%)	32	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.lieu AS lieu_35, t15.modalite_par_defaut AS modalite_par_defaut_36, t15.created_by_id AS created_by_id_37, t15.updated_by_id AS updated_by_id_38, t15.salle_defaut_id AS salle_defaut_id_39, t15.parcours_id AS parcours_id_40, t15.adresse_partenaire_id AS adresse_partenaire_id_41, t15.statut_id AS statut_id_42, t15.referent_pedagogique_id AS referent_pedagogique_id_43, t15.referent_coach_id AS referent_coach_id_44, t15.referent_administratif_id AS referent_administratif_id_45, t15.referent_handicap_id AS referent_handicap_id_46, t15.planning_id AS planning_id_47, t15.site_id AS site_id_48, t15.api_gestiform_id AS api_gestiform_id_49, t0.parent_id AS parent_id_50, t51.id AS id_52, t51.created_at AS created_at_53, t51.updated_at AS updated_at_54, t51.archive AS archive_55, t51.reference AS reference_56, t51.items_document AS items_document_57, t51.email_logs AS email_logs_58, t51.panier AS panier_59, t51.competences AS competences_60, t51.cart AS cart_61, t51.mode AS mode_62, t51.linkedin AS linkedin_63, t51.portfolio AS portfolio_64, t51.campus AS campus_65, t51.modalite_enseignement AS modalite_enseignement_66, t51.commentaire AS commentaire_67, t51.email_candidature AS email_candidature_68, t51.date_reunion AS date_reunion_69, t51.stop_date AS stop_date_70, t51.candidate_available AS candidate_available_71, t51.rncp AS rncp_72, t51.diplomant AS diplomant_73, t51.delegue_classe AS delegue_classe_74, t51.postulant_available AS postulant_available_75, t51.prospect_available AS prospect_available_76, t51.stagiaire_available AS stagiaire_available_77, t51.alumni_available AS alumni_available_78, t51.news_letter AS news_letter_79, t51.processed AS processed_80, t51.statut_declaration AS statut_declaration_81, t51.a_representant_legal AS a_representant_legal_82, t51.notification_paiement AS notification_paiement_83, t51.engagement_formation AS engagement_formation_84, t51.charte_formation AS charte_formation_85, t51.compte_zoom AS compte_zoom_86, t51.notified AS notified_87, t51.femme_eloigne AS femme_eloigne_88, t51.zrr AS zrr_89, t51.qpv AS qpv_90, t51.participation_reglee AS participation_reglee_91, t51.participation AS participation_92, t51.caution AS caution_93, t51.restea_regler AS restea_regler_94, t51.created_by_id AS created_by_id_95, t51.updated_by_id AS updated_by_id_96, t51.stop_proof_id AS stop_proof_id_97, t51.stop_cause_id AS stop_cause_id_98, t51.stop_type_id AS stop_type_id_99, t51.type_actif_id AS type_actif_id_100, t51.state_id AS state_id_101, t51.dispositif_id AS dispositif_id_102, t51.type_formation_id AS type_formation_id_103, t51.resultat_id AS resultat_id_104, t51.profil_id AS profil_id_105, t51.personal_informations_id AS personal_informations_id_106, t51.adresse_id AS adresse_id_107, t51.planning_id AS planning_id_108, t51.session_id AS session_id_109, t51.societe_id AS societe_id_110, t51.site_id AS site_id_111, t51.dossierannexes_id AS dossierannexes_id_112, t51.apprenant_id AS apprenant_id_113, t51.parcours AS parcours_114, t51.reorienter_id AS reorienter_id_115, t51.referent_pedagogique_id AS referent_pedagogique_id_116, t51.referent_commercial_id AS referent_commercial_id_117, t51.referent_coach_id AS referent_coach_id_118, t51.referent_administratif_id AS referent_administratif_id_119, t51.entreprise_id AS entreprise_id_120, t51.entreprise_contact_id AS entreprise_contact_id_121, t51.cv_id AS cv_id_122, t51.platforme_id AS platforme_id_123, t51.emergency_contact_id AS emergency_contact_id_124, t51.legal_representative_id AS legal_representative_id_125, t51.etablissement_id AS etablissement_id_126 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t51 ON t51.planning_id = t0.id WHERE t0.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.lieu AS lieu_35, t15.modalite_par_defaut AS modalite_par_defaut_36, t15.created_by_id AS created_by_id_37, t15.updated_by_id AS updated_by_id_38, t15.salle_defaut_id AS salle_defaut_id_39, t15.parcours_id AS parcours_id_40, t15.adresse_partenaire_id AS adresse_partenaire_id_41, t15.statut_id AS statut_id_42, t15.referent_pedagogique_id AS referent_pedagogique_id_43, t15.referent_coach_id AS referent_coach_id_44, t15.referent_administratif_id AS referent_administratif_id_45, t15.referent_handicap_id AS referent_handicap_id_46, t15.planning_id AS planning_id_47, t15.site_id AS site_id_48, t15.api_gestiform_id AS api_gestiform_id_49, t0.parent_id AS parent_id_50, t51.id AS id_52, t51.created_at AS created_at_53, t51.updated_at AS updated_at_54, t51.archive AS archive_55, t51.reference AS reference_56, t51.items_document AS items_document_57, t51.email_logs AS email_logs_58, t51.panier AS panier_59, t51.competences AS competences_60, t51.cart AS cart_61, t51.mode AS mode_62, t51.linkedin AS linkedin_63, t51.portfolio AS portfolio_64, t51.campus AS campus_65, t51.modalite_enseignement AS modalite_enseignement_66, t51.commentaire AS commentaire_67, t51.email_candidature AS email_candidature_68, t51.date_reunion AS date_reunion_69, t51.stop_date AS stop_date_70, t51.candidate_available AS candidate_available_71, t51.rncp AS rncp_72, t51.diplomant AS diplomant_73, t51.delegue_classe AS delegue_classe_74, t51.postulant_available AS postulant_available_75, t51.prospect_available AS prospect_available_76, t51.stagiaire_available AS stagiaire_available_77, t51.alumni_available AS alumni_available_78, t51.news_letter AS news_letter_79, t51.processed AS processed_80, t51.statut_declaration AS statut_declaration_81, t51.a_representant_legal AS a_representant_legal_82, t51.notification_paiement AS notification_paiement_83, t51.engagement_formation AS engagement_formation_84, t51.charte_formation AS charte_formation_85, t51.compte_zoom AS compte_zoom_86, t51.notified AS notified_87, t51.femme_eloigne AS femme_eloigne_88, t51.zrr AS zrr_89, t51.qpv AS qpv_90, t51.participation_reglee AS participation_reglee_91, t51.participation AS participation_92, t51.caution AS caution_93, t51.restea_regler AS restea_regler_94, t51.created_by_id AS created_by_id_95, t51.updated_by_id AS updated_by_id_96, t51.stop_proof_id AS stop_proof_id_97, t51.stop_cause_id AS stop_cause_id_98, t51.stop_type_id AS stop_type_id_99, t51.type_actif_id AS type_actif_id_100, t51.state_id AS state_id_101, t51.dispositif_id AS dispositif_id_102, t51.type_formation_id AS type_formation_id_103, t51.resultat_id AS resultat_id_104, t51.profil_id AS profil_id_105, t51.personal_informations_id AS personal_informations_id_106, t51.adresse_id AS adresse_id_107, t51.planning_id AS planning_id_108, t51.session_id AS session_id_109, t51.societe_id AS societe_id_110, t51.site_id AS site_id_111, t51.dossierannexes_id AS dossierannexes_id_112, t51.apprenant_id AS apprenant_id_113, t51.parcours AS parcours_114, t51.reorienter_id AS reorienter_id_115, t51.referent_pedagogique_id AS referent_pedagogique_id_116, t51.referent_commercial_id AS referent_commercial_id_117, t51.referent_coach_id AS referent_coach_id_118, t51.referent_administratif_id AS referent_administratif_id_119, t51.entreprise_id AS entreprise_id_120, t51.entreprise_contact_id AS entreprise_contact_id_121, t51.cv_id AS cv_id_122, t51.platforme_id AS platforme_id_123, t51.emergency_contact_id AS emergency_contact_id_124, t51.legal_representative_id AS legal_representative_id_125, t51.etablissement_id AS etablissement_id_126 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t51 ON t51.planning_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.lieu AS lieu_35, t15.modalite_par_defaut AS modalite_par_defaut_36, t15.created_by_id AS created_by_id_37, t15.updated_by_id AS updated_by_id_38, t15.salle_defaut_id AS salle_defaut_id_39, t15.parcours_id AS parcours_id_40, t15.adresse_partenaire_id AS adresse_partenaire_id_41, t15.statut_id AS statut_id_42, t15.referent_pedagogique_id AS referent_pedagogique_id_43, t15.referent_coach_id AS referent_coach_id_44, t15.referent_administratif_id AS referent_administratif_id_45, t15.referent_handicap_id AS referent_handicap_id_46, t15.planning_id AS planning_id_47, t15.site_id AS site_id_48, t15.api_gestiform_id AS api_gestiform_id_49, t0.parent_id AS parent_id_50, t51.id AS id_52, t51.created_at AS created_at_53, t51.updated_at AS updated_at_54, t51.archive AS archive_55, t51.reference AS reference_56, t51.items_document AS items_document_57, t51.email_logs AS email_logs_58, t51.panier AS panier_59, t51.competences AS competences_60, t51.cart AS cart_61, t51.mode AS mode_62, t51.linkedin AS linkedin_63, t51.portfolio AS portfolio_64, t51.campus AS campus_65, t51.modalite_enseignement AS modalite_enseignement_66, t51.commentaire AS commentaire_67, t51.email_candidature AS email_candidature_68, t51.date_reunion AS date_reunion_69, t51.stop_date AS stop_date_70, t51.candidate_available AS candidate_available_71, t51.rncp AS rncp_72, t51.diplomant AS diplomant_73, t51.delegue_classe AS delegue_classe_74, t51.postulant_available AS postulant_available_75, t51.prospect_available AS prospect_available_76, t51.stagiaire_available AS stagiaire_available_77, t51.alumni_available AS alumni_available_78, t51.news_letter AS news_letter_79, t51.processed AS processed_80, t51.statut_declaration AS statut_declaration_81, t51.a_representant_legal AS a_representant_legal_82, t51.notification_paiement AS notification_paiement_83, t51.engagement_formation AS engagement_formation_84, t51.charte_formation AS charte_formation_85, t51.compte_zoom AS compte_zoom_86, t51.notified AS notified_87, t51.femme_eloigne AS femme_eloigne_88, t51.zrr AS zrr_89, t51.qpv AS qpv_90, t51.participation_reglee AS participation_reglee_91, t51.participation AS participation_92, t51.caution AS caution_93, t51.restea_regler AS restea_regler_94, t51.created_by_id AS created_by_id_95, t51.updated_by_id AS updated_by_id_96, t51.stop_proof_id AS stop_proof_id_97, t51.stop_cause_id AS stop_cause_id_98, t51.stop_type_id AS stop_type_id_99, t51.type_actif_id AS type_actif_id_100, t51.state_id AS state_id_101, t51.dispositif_id AS dispositif_id_102, t51.type_formation_id AS type_formation_id_103, t51.resultat_id AS resultat_id_104, t51.profil_id AS profil_id_105, t51.personal_informations_id AS personal_informations_id_106, t51.adresse_id AS adresse_id_107, t51.planning_id AS planning_id_108, t51.session_id AS session_id_109, t51.societe_id AS societe_id_110, t51.site_id AS site_id_111, t51.dossierannexes_id AS dossierannexes_id_112, t51.apprenant_id AS apprenant_id_113, t51.parcours AS parcours_114, t51.reorienter_id AS reorienter_id_115, t51.referent_pedagogique_id AS referent_pedagogique_id_116, t51.referent_commercial_id AS referent_commercial_id_117, t51.referent_coach_id AS referent_coach_id_118, t51.referent_administratif_id AS referent_administratif_id_119, t51.entreprise_id AS entreprise_id_120, t51.entreprise_contact_id AS entreprise_contact_id_121, t51.cv_id AS cv_id_122, t51.platforme_id AS platforme_id_123, t51.emergency_contact_id AS emergency_contact_id_124, t51.legal_representative_id AS legal_representative_id_125, t51.etablissement_id AS etablissement_id_126 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t51 ON t51.planning_id = t0.id WHERE t0.id = 12;
5.44 ms (7.07%)	39	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.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.event_id = ? Parameters: [`24`] View formatted query View runnable query Explain query 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.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.event_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.event_id = 24;
4.18 ms (5.44%)	27	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"`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;
3.73 ms (4.85%)	2	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
3.56 ms (4.63%)	15	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.niveau_emploi AS niveau_emploi_5, t0.classification_convention_collective AS classification_convention_collective_6, t0.description_missions_confiees AS description_missions_confiees_7, t0.emploi_occupe AS emploi_occupe_8, t0.coefficient_hierarchique AS coefficient_hierarchique_9, t0.salaire_brut AS salaire_brut_10, t0.nourriture AS nourriture_11, t0.logement AS logement_12, t0.duree_hebdomadaire AS duree_hebdomadaire_13, t0.date_signature AS date_signature_14, t0.date_effet AS date_effet_15, t0.numero_contrat_precedent AS numero_contrat_precedent_16, t0.numero_externe_dossier AS numero_externe_dossier_17, t0.numero_interne_dossier AS numero_interne_dossier_18, t0.num_projet AS num_projet_19, t0.classification_emploi AS classification_emploi_20, t0.niveau AS niveau_21, t0.duree_periode_essai AS duree_periode_essai_22, t0.competences_adevelopper AS competences_adevelopper_23, t0.temps_stage AS temps_stage_24, t0.conditions_particulieres AS conditions_particulieres_25, t0.objective_programme AS objective_programme_26, t0.objective_du_stage AS objective_du_stage_27, t0.activites_confiees AS activites_confiees_28, t0.lieu_stage AS lieu_stage_29, t0.gratification AS gratification_30, t0.deroulement_heurs AS deroulement_heurs_31, t0.nb_heures AS nb_heures_32, t0.nb_jour AS nb_jour_33, t0.non_conforme AS non_conforme_34, t0.travail_machines_dangereuses AS travail_machines_dangereuses_35, t0.smig AS smig_36, t0.avenant AS avenant_37, t0.tutore AS tutore_38, t0.document_genere AS document_genere_39, t0.regime_specifique AS regime_specifique_40, t0.attestation_eligibilite AS attestation_eligibilite_41, t0.attestation_pieces AS attestation_pieces_42, t0.opco_document AS opco_document_43, t0.opco_convention AS opco_convention_44, t0.commentaire AS commentaire_45, t0.signature_a AS signature_a_46, t0.missions AS missions_47, t0.modalites_encadrement AS modalites_encadrement_48, t0.avantages_offerts AS avantages_offerts_49, t0.start AS start_50, t0.end AS end_51, t0.signature_le AS signature_le_52, t0.created_by_id AS created_by_id_53, t0.updated_by_id AS updated_by_id_54, t0.document_id AS document_id_55, t0.template_id AS template_id_56, t0.dossier_id AS dossier_id_57, t0.employe_id AS employe_id_58, t0.state_id AS state_id_59, t0.entreprise_id AS entreprise_id_60, t0.etablissement_id AS etablissement_id_61, t0.signature_file_id AS signature_file_id_62, t0.signature_entreprise_file_id AS signature_entreprise_file_id_63, t0.tuteur_id AS tuteur_id_64, t0.tuteur1_id AS tuteur1_id_65, t0.tuteur2_id AS tuteur2_id_66, t0.minimum_social_id AS minimum_social_id_67, t0.type_contrat_id AS type_contrat_id_68, t0.type_derogation_id AS type_derogation_id_69, t0.type_id AS type_id_70, t0.nature_contrat_id AS nature_contrat_id_71, t0.stage_id AS stage_id_72, t0.parent_id AS parent_id_73 FROM convention t0 WHERE t0.stage_id = ? Parameters: [`22`] View formatted query View runnable query Explain query 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.niveau_emploi AS niveau_emploi_5, t0.classification_convention_collective AS classification_convention_collective_6, t0.description_missions_confiees AS description_missions_confiees_7, t0.emploi_occupe AS emploi_occupe_8, t0.coefficient_hierarchique AS coefficient_hierarchique_9, t0.salaire_brut AS salaire_brut_10, t0.nourriture AS nourriture_11, t0.logement AS logement_12, t0.duree_hebdomadaire AS duree_hebdomadaire_13, t0.date_signature AS date_signature_14, t0.date_effet AS date_effet_15, t0.numero_contrat_precedent AS numero_contrat_precedent_16, t0.numero_externe_dossier AS numero_externe_dossier_17, t0.numero_interne_dossier AS numero_interne_dossier_18, t0.num_projet AS num_projet_19, t0.classification_emploi AS classification_emploi_20, t0.niveau AS niveau_21, t0.duree_periode_essai AS duree_periode_essai_22, t0.competences_adevelopper AS competences_adevelopper_23, t0.temps_stage AS temps_stage_24, t0.conditions_particulieres AS conditions_particulieres_25, t0.objective_programme AS objective_programme_26, t0.objective_du_stage AS objective_du_stage_27, t0.activites_confiees AS activites_confiees_28, t0.lieu_stage AS lieu_stage_29, t0.gratification AS gratification_30, t0.deroulement_heurs AS deroulement_heurs_31, t0.nb_heures AS nb_heures_32, t0.nb_jour AS nb_jour_33, t0.non_conforme AS non_conforme_34, t0.travail_machines_dangereuses AS travail_machines_dangereuses_35, t0.smig AS smig_36, t0.avenant AS avenant_37, t0.tutore AS tutore_38, t0.document_genere AS document_genere_39, t0.regime_specifique AS regime_specifique_40, t0.attestation_eligibilite AS attestation_eligibilite_41, t0.attestation_pieces AS attestation_pieces_42, t0.opco_document AS opco_document_43, t0.opco_convention AS opco_convention_44, t0.commentaire AS commentaire_45, t0.signature_a AS signature_a_46, t0.missions AS missions_47, t0.modalites_encadrement AS modalites_encadrement_48, t0.avantages_offerts AS avantages_offerts_49, t0.start AS start_50, t0.end AS end_51, t0.signature_le AS signature_le_52, t0.created_by_id AS created_by_id_53, t0.updated_by_id AS updated_by_id_54, t0.document_id AS document_id_55, t0.template_id AS template_id_56, t0.dossier_id AS dossier_id_57, t0.employe_id AS employe_id_58, t0.state_id AS state_id_59, t0.entreprise_id AS entreprise_id_60, t0.etablissement_id AS etablissement_id_61, t0.signature_file_id AS signature_file_id_62, t0.signature_entreprise_file_id AS signature_entreprise_file_id_63, t0.tuteur_id AS tuteur_id_64, t0.tuteur1_id AS tuteur1_id_65, t0.tuteur2_id AS tuteur2_id_66, t0.minimum_social_id AS minimum_social_id_67, t0.type_contrat_id AS type_contrat_id_68, t0.type_derogation_id AS type_derogation_id_69, t0.type_id AS type_id_70, t0.nature_contrat_id AS nature_contrat_id_71, t0.stage_id AS stage_id_72, t0.parent_id AS parent_id_73 FROM convention t0 WHERE t0.stage_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.niveau_emploi AS niveau_emploi_5, t0.classification_convention_collective AS classification_convention_collective_6, t0.description_missions_confiees AS description_missions_confiees_7, t0.emploi_occupe AS emploi_occupe_8, t0.coefficient_hierarchique AS coefficient_hierarchique_9, t0.salaire_brut AS salaire_brut_10, t0.nourriture AS nourriture_11, t0.logement AS logement_12, t0.duree_hebdomadaire AS duree_hebdomadaire_13, t0.date_signature AS date_signature_14, t0.date_effet AS date_effet_15, t0.numero_contrat_precedent AS numero_contrat_precedent_16, t0.numero_externe_dossier AS numero_externe_dossier_17, t0.numero_interne_dossier AS numero_interne_dossier_18, t0.num_projet AS num_projet_19, t0.classification_emploi AS classification_emploi_20, t0.niveau AS niveau_21, t0.duree_periode_essai AS duree_periode_essai_22, t0.competences_adevelopper AS competences_adevelopper_23, t0.temps_stage AS temps_stage_24, t0.conditions_particulieres AS conditions_particulieres_25, t0.objective_programme AS objective_programme_26, t0.objective_du_stage AS objective_du_stage_27, t0.activites_confiees AS activites_confiees_28, t0.lieu_stage AS lieu_stage_29, t0.gratification AS gratification_30, t0.deroulement_heurs AS deroulement_heurs_31, t0.nb_heures AS nb_heures_32, t0.nb_jour AS nb_jour_33, t0.non_conforme AS non_conforme_34, t0.travail_machines_dangereuses AS travail_machines_dangereuses_35, t0.smig AS smig_36, t0.avenant AS avenant_37, t0.tutore AS tutore_38, t0.document_genere AS document_genere_39, t0.regime_specifique AS regime_specifique_40, t0.attestation_eligibilite AS attestation_eligibilite_41, t0.attestation_pieces AS attestation_pieces_42, t0.opco_document AS opco_document_43, t0.opco_convention AS opco_convention_44, t0.commentaire AS commentaire_45, t0.signature_a AS signature_a_46, t0.missions AS missions_47, t0.modalites_encadrement AS modalites_encadrement_48, t0.avantages_offerts AS avantages_offerts_49, t0.start AS start_50, t0.end AS end_51, t0.signature_le AS signature_le_52, t0.created_by_id AS created_by_id_53, t0.updated_by_id AS updated_by_id_54, t0.document_id AS document_id_55, t0.template_id AS template_id_56, t0.dossier_id AS dossier_id_57, t0.employe_id AS employe_id_58, t0.state_id AS state_id_59, t0.entreprise_id AS entreprise_id_60, t0.etablissement_id AS etablissement_id_61, t0.signature_file_id AS signature_file_id_62, t0.signature_entreprise_file_id AS signature_entreprise_file_id_63, t0.tuteur_id AS tuteur_id_64, t0.tuteur1_id AS tuteur1_id_65, t0.tuteur2_id AS tuteur2_id_66, t0.minimum_social_id AS minimum_social_id_67, t0.type_contrat_id AS type_contrat_id_68, t0.type_derogation_id AS type_derogation_id_69, t0.type_id AS type_id_70, t0.nature_contrat_id AS nature_contrat_id_71, t0.stage_id AS stage_id_72, t0.parent_id AS parent_id_73 FROM convention t0 WHERE t0.stage_id = 22;
3.11 ms (4.05%)	25	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.token AS token_5, t0.intitule AS intitule_6, t0.acrrochage AS acrrochage_7, t0.document_genere AS document_genere_8, t0.date_examen AS date_examen_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.admission_id AS admission_id_12, t0.mention_id AS mention_id_13, t0.president_jury_id AS president_jury_id_14, t0.dossier_id AS dossier_id_15, t0.parcours_id AS parcours_id_16, t0.qr_code_id AS qr_code_id_17 FROM diplome t0 WHERE t0.dossier_id = ? Parameters: [`11`] View formatted query View runnable query Explain query 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.token AS token_5, t0.intitule AS intitule_6, t0.acrrochage AS acrrochage_7, t0.document_genere AS document_genere_8, t0.date_examen AS date_examen_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.admission_id AS admission_id_12, t0.mention_id AS mention_id_13, t0.president_jury_id AS president_jury_id_14, t0.dossier_id AS dossier_id_15, t0.parcours_id AS parcours_id_16, t0.qr_code_id AS qr_code_id_17 FROM diplome t0 WHERE t0.dossier_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.token AS token_5, t0.intitule AS intitule_6, t0.acrrochage AS acrrochage_7, t0.document_genere AS document_genere_8, t0.date_examen AS date_examen_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.admission_id AS admission_id_12, t0.mention_id AS mention_id_13, t0.president_jury_id AS president_jury_id_14, t0.dossier_id AS dossier_id_15, t0.parcours_id AS parcours_id_16, t0.qr_code_id AS qr_code_id_17 FROM diplome t0 WHERE t0.dossier_id = 11;
2.89 ms (3.76%)	14	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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.parent_id = ? Parameters: [`24`] View formatted query View runnable query Explain query 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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.parent_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.parent_id = 24;
2.60 ms (3.39%)	13	SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.tarif_jury2 AS tarif_jury2_27, t0.tarif_jury_ttc AS tarif_jury_ttc_28, t0.prerequis AS prerequis_29, t0.objectif AS objectif_30, t0.plus AS plus_31, t0.public AS public_32, t0.commentaire AS commentaire_33, t0.certification_commentaire AS certification_commentaire_34, t0.seo_titre AS seo_titre_35, t0.seo_description AS seo_description_36, t0.info_pratique AS info_pratique_37, t0.accessibilite_handicap AS accessibilite_handicap_38, t0.alt_vignette AS alt_vignette_39, t0.description AS description_40, t0.modalites_delais_acces AS modalites_delais_acces_41, t0.alt_banniere AS alt_banniere_42, t0.identifiant_dokelio AS identifiant_dokelio_43, t0.publication AS publication_44, t0.contenu_apres AS contenu_apres_45, t0.contenu_avant AS contenu_avant_46, t0.tauxObtention AS tauxObtention_47, t0.tauxAbandon AS tauxAbandon_48, t0.tauxSatisfaction AS tauxSatisfaction_49, t0.tauxPourSuiteEtude AS tauxPourSuiteEtude_50, t0.tauxEmployabilite AS tauxEmployabilite_51, t0.salaireMoyen AS salaireMoyen_52, t0.nbrsessioninter AS nbrsessioninter_53, t0.nbrsessionintra AS nbrsessionintra_54, t0.modes_formation AS modes_formation_55, t0.created_by_id AS created_by_id_56, t0.updated_by_id AS updated_by_id_57, t0.mode_formation_id AS mode_formation_id_58, t0.sous_theme_theme_id AS sous_theme_theme_id_59, t0.theme_tarif_id AS theme_tarif_id_60, t0.niveaumateriel_id AS niveaumateriel_id_61, t0.niveautechnique_id AS niveautechnique_id_62, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_63, t0.banniere_id AS banniere_id_64, t0.vignette_id AS vignette_id_65, t0.api_gestiform_id AS api_gestiform_id_66, t0.type, t1.date_inscription AS date_inscription_67, t1.programme AS programme_68, t1.certification AS certification_69, t1.tarif_vente AS tarif_vente_70, t1.editeur_id AS editeur_id_71, t1.theme_id AS theme_id_72 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = ? Parameters: [`106`] View formatted query View runnable query Explain query SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.tarif_jury2 AS tarif_jury2_27, t0.tarif_jury_ttc AS tarif_jury_ttc_28, t0.prerequis AS prerequis_29, t0.objectif AS objectif_30, t0.plus AS plus_31, t0.public AS public_32, t0.commentaire AS commentaire_33, t0.certification_commentaire AS certification_commentaire_34, t0.seo_titre AS seo_titre_35, t0.seo_description AS seo_description_36, t0.info_pratique AS info_pratique_37, t0.accessibilite_handicap AS accessibilite_handicap_38, t0.alt_vignette AS alt_vignette_39, t0.description AS description_40, t0.modalites_delais_acces AS modalites_delais_acces_41, t0.alt_banniere AS alt_banniere_42, t0.identifiant_dokelio AS identifiant_dokelio_43, t0.publication AS publication_44, t0.contenu_apres AS contenu_apres_45, t0.contenu_avant AS contenu_avant_46, t0.tauxObtention AS tauxObtention_47, t0.tauxAbandon AS tauxAbandon_48, t0.tauxSatisfaction AS tauxSatisfaction_49, t0.tauxPourSuiteEtude AS tauxPourSuiteEtude_50, t0.tauxEmployabilite AS tauxEmployabilite_51, t0.salaireMoyen AS salaireMoyen_52, t0.nbrsessioninter AS nbrsessioninter_53, t0.nbrsessionintra AS nbrsessionintra_54, t0.modes_formation AS modes_formation_55, t0.created_by_id AS created_by_id_56, t0.updated_by_id AS updated_by_id_57, t0.mode_formation_id AS mode_formation_id_58, t0.sous_theme_theme_id AS sous_theme_theme_id_59, t0.theme_tarif_id AS theme_tarif_id_60, t0.niveaumateriel_id AS niveaumateriel_id_61, t0.niveautechnique_id AS niveautechnique_id_62, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_63, t0.banniere_id AS banniere_id_64, t0.vignette_id AS vignette_id_65, t0.api_gestiform_id AS api_gestiform_id_66, t0.type, t1.date_inscription AS date_inscription_67, t1.programme AS programme_68, t1.certification AS certification_69, t1.tarif_vente AS tarif_vente_70, t1.editeur_id AS editeur_id_71, t1.theme_id AS theme_id_72 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = ? SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.tarif_jury2 AS tarif_jury2_27, t0.tarif_jury_ttc AS tarif_jury_ttc_28, t0.prerequis AS prerequis_29, t0.objectif AS objectif_30, t0.plus AS plus_31, t0.public AS public_32, t0.commentaire AS commentaire_33, t0.certification_commentaire AS certification_commentaire_34, t0.seo_titre AS seo_titre_35, t0.seo_description AS seo_description_36, t0.info_pratique AS info_pratique_37, t0.accessibilite_handicap AS accessibilite_handicap_38, t0.alt_vignette AS alt_vignette_39, t0.description AS description_40, t0.modalites_delais_acces AS modalites_delais_acces_41, t0.alt_banniere AS alt_banniere_42, t0.identifiant_dokelio AS identifiant_dokelio_43, t0.publication AS publication_44, t0.contenu_apres AS contenu_apres_45, t0.contenu_avant AS contenu_avant_46, t0.tauxObtention AS tauxObtention_47, t0.tauxAbandon AS tauxAbandon_48, t0.tauxSatisfaction AS tauxSatisfaction_49, t0.tauxPourSuiteEtude AS tauxPourSuiteEtude_50, t0.tauxEmployabilite AS tauxEmployabilite_51, t0.salaireMoyen AS salaireMoyen_52, t0.nbrsessioninter AS nbrsessioninter_53, t0.nbrsessionintra AS nbrsessionintra_54, t0.modes_formation AS modes_formation_55, t0.created_by_id AS created_by_id_56, t0.updated_by_id AS updated_by_id_57, t0.mode_formation_id AS mode_formation_id_58, t0.sous_theme_theme_id AS sous_theme_theme_id_59, t0.theme_tarif_id AS theme_tarif_id_60, t0.niveaumateriel_id AS niveaumateriel_id_61, t0.niveautechnique_id AS niveautechnique_id_62, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_63, t0.banniere_id AS banniere_id_64, t0.vignette_id AS vignette_id_65, t0.api_gestiform_id AS api_gestiform_id_66, t0.type, t1.date_inscription AS date_inscription_67, t1.programme AS programme_68, t1.certification AS certification_69, t1.tarif_vente AS tarif_vente_70, t1.editeur_id AS editeur_id_71, t1.theme_id AS theme_id_72 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = 106;
2.60 ms (3.38%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 INNER JOIN parcours_mode_formation ON t0.id = parcours_mode_formation.masterlistelg_id WHERE parcours_mode_formation.parcours_id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 INNER JOIN parcours_mode_formation ON t0.id = parcours_mode_formation.masterlistelg_id WHERE parcours_mode_formation.parcours_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 INNER JOIN parcours_mode_formation ON t0.id = parcours_mode_formation.masterlistelg_id WHERE parcours_mode_formation.parcours_id = 33;
2.38 ms (3.10%)	13	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = 5;
2.30 ms (2.99%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.bloc_id AS bloc_id_8, t0.module_id AS module_id_9 FROM bloc_module t0 WHERE t0.bloc_id = ? Parameters: [`154`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.bloc_id AS bloc_id_8, t0.module_id AS module_id_9 FROM bloc_module t0 WHERE t0.bloc_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.bloc_id AS bloc_id_8, t0.module_id AS module_id_9 FROM bloc_module t0 WHERE t0.bloc_id = 154;
2.10 ms (2.73%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.titre AS titre_5, t0.description AS description_6, t0.open AS open_7, t0.start AS start_8, t0.end AS end_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.session_id AS session_id_12, t0.salle_id AS salle_id_13 FROM reunion t0 WHERE t0.session_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.titre AS titre_5, t0.description AS description_6, t0.open AS open_7, t0.start AS start_8, t0.end AS end_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.session_id AS session_id_12, t0.salle_id AS salle_id_13 FROM reunion t0 WHERE t0.session_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.titre AS titre_5, t0.description AS description_6, t0.open AS open_7, t0.start AS start_8, t0.end AS end_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11, t0.session_id AS session_id_12, t0.salle_id AS salle_id_13 FROM reunion t0 WHERE t0.session_id = 11;
2.01 ms (2.62%)	18	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.nbjours_prevus AS nbjours_prevus_5, t0.consigne AS consigne_6, t0.event_childs AS event_childs_7, t0.sendconvocation AS sendconvocation_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.formateur_id AS formateur_id_11, t0.evenement_id AS evenement_id_12 FROM formateur_event t0 WHERE t0.evenement_id = ? Parameters: [`24`] View formatted query View runnable query Explain query 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.nbjours_prevus AS nbjours_prevus_5, t0.consigne AS consigne_6, t0.event_childs AS event_childs_7, t0.sendconvocation AS sendconvocation_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.formateur_id AS formateur_id_11, t0.evenement_id AS evenement_id_12 FROM formateur_event t0 WHERE t0.evenement_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nbjours_prevus AS nbjours_prevus_5, t0.consigne AS consigne_6, t0.event_childs AS event_childs_7, t0.sendconvocation AS sendconvocation_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.formateur_id AS formateur_id_11, t0.evenement_id AS evenement_id_12 FROM formateur_event t0 WHERE t0.evenement_id = 24;
1.77 ms (2.30%)	13	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: [`5978`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = 5978;
1.72 ms (2.23%)	14	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.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.salle_id AS salle_id_7, t0.event_id AS event_id_8 FROM salle_event t0 WHERE t0.event_id = ? Parameters: [`24`] View formatted query View runnable query Explain query 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.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.salle_id AS salle_id_7, t0.event_id AS event_id_8 FROM salle_event t0 WHERE t0.event_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.salle_id AS salle_id_7, t0.event_id AS event_id_8 FROM salle_event t0 WHERE t0.event_id = 24;
1.35 ms (1.76%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.content AS content_5, t0.apprenants AS apprenants_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.session_id AS session_id_9, t0.event_id AS event_id_10, t0.sender_id AS sender_id_11 FROM group_message t0 WHERE t0.session_id = ? AND t0.apprenants = ? Parameters: [`11 0`] View formatted query View runnable query Explain query 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.content AS content_5, t0.apprenants AS apprenants_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.session_id AS session_id_9, t0.event_id AS event_id_10, t0.sender_id AS sender_id_11 FROM group_message t0 WHERE t0.session_id = ? AND t0.apprenants = ? 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.content AS content_5, t0.apprenants AS apprenants_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.session_id AS session_id_9, t0.event_id AS event_id_10, t0.sender_id AS sender_id_11 FROM group_message t0 WHERE t0.session_id = 11 AND t0.apprenants = 0;
1.32 ms (1.71%)	1	SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN entretien e4_ ON p2_.id = e4_.personne_id WHERE m3_.code IN (?, ?) AND EXISTS (SELECT 1 FROM entretien_masterlistelg e5_ WHERE e5_.entretien_id = e4_.id AND e5_.masterlistelg_id IN (?)) ORDER BY u0_.id ASC Parameters: [`"confirme" "attente" 6599`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN entretien e4_ ON p2_.id = e4_.personne_id WHERE m3_.code IN (?, ?) AND EXISTS ( SELECT 1 FROM entretien_masterlistelg e5_ WHERE e5_.entretien_id = e4_.id AND e5_.masterlistelg_id IN (?) ) ORDER BY u0_.id ASC SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN entretien e4_ ON p2_.id = e4_.personne_id WHERE m3_.code IN ('confirme', 'attente') AND EXISTS (SELECT 1 FROM entretien_masterlistelg e5_ WHERE e5_.entretien_id = e4_.id AND e5_.masterlistelg_id IN (6599)) ORDER BY u0_.id ASC;
1.31 ms (1.71%)	6	SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = ? SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = 1;
1.20 ms (1.56%)	9	SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t0.delegataire = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t0.delegataire = ? SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t0.delegataire = 1;
1.07 ms (1.39%)	13	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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.module_id = ? Parameters: [`106`] View formatted query View runnable query Explain query 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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.module_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.module_id = 106;
0.99 ms (1.28%)	6	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 m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC Parameters: [`"RESOURCE" "ROLE"`] View formatted query View runnable query Explain query 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 m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC 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 m1_.code = 'RESOURCE' AND m1_.module = 'ROLE' ORDER BY m0_.code ASC;
0.96 ms (1.25%)	1	UPDATE planning SET start = ?, end = ?, updated_at = ? WHERE id = ? Parameters: [`"2025-11-03 09:00:00" "2026-11-02 02:00:00" "2026-06-22 13:24:28" 12`] View formatted query View runnable query Explain query UPDATE planning SET start = ?, end = ?, updated_at = ? WHERE id = ? UPDATE planning SET start = '2025-11-03 09:00:00', end = '2026-11-02 02:00:00', updated_at = '2026-06-22 13:24:28' WHERE id = 12;
0.91 ms (1.18%)	3	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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = ? Parameters: [`24`] View formatted query View runnable query Explain query 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.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = 24;
0.90 ms (1.17%)	8	SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? Parameters: [`5979 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5979 AND r0_.resource_id = 5958;
0.88 ms (1.14%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.reference AS reference_5, t0.items_document AS items_document_6, t0.email_logs AS email_logs_7, t0.panier AS panier_8, t0.competences AS competences_9, t0.cart AS cart_10, t0.mode AS mode_11, t0.linkedin AS linkedin_12, t0.portfolio AS portfolio_13, t0.campus AS campus_14, t0.modalite_enseignement AS modalite_enseignement_15, t0.commentaire AS commentaire_16, t0.email_candidature AS email_candidature_17, t0.date_reunion AS date_reunion_18, t0.stop_date AS stop_date_19, t0.candidate_available AS candidate_available_20, t0.rncp AS rncp_21, t0.diplomant AS diplomant_22, t0.delegue_classe AS delegue_classe_23, t0.postulant_available AS postulant_available_24, t0.prospect_available AS prospect_available_25, t0.stagiaire_available AS stagiaire_available_26, t0.alumni_available AS alumni_available_27, t0.news_letter AS news_letter_28, t0.processed AS processed_29, t0.statut_declaration AS statut_declaration_30, t0.a_representant_legal AS a_representant_legal_31, t0.notification_paiement AS notification_paiement_32, t0.engagement_formation AS engagement_formation_33, t0.charte_formation AS charte_formation_34, t0.compte_zoom AS compte_zoom_35, t0.notified AS notified_36, t0.femme_eloigne AS femme_eloigne_37, t0.zrr AS zrr_38, t0.qpv AS qpv_39, t0.participation_reglee AS participation_reglee_40, t0.participation AS participation_41, t0.caution AS caution_42, t0.restea_regler AS restea_regler_43, t0.created_by_id AS created_by_id_44, t0.updated_by_id AS updated_by_id_45, t0.stop_proof_id AS stop_proof_id_46, t0.stop_cause_id AS stop_cause_id_47, t0.stop_type_id AS stop_type_id_48, t0.type_actif_id AS type_actif_id_49, t0.state_id AS state_id_50, t0.dispositif_id AS dispositif_id_51, t0.type_formation_id AS type_formation_id_52, t0.resultat_id AS resultat_id_53, t0.profil_id AS profil_id_54, t0.personal_informations_id AS personal_informations_id_55, t0.adresse_id AS adresse_id_56, t0.planning_id AS planning_id_57, t0.session_id AS session_id_58, t0.societe_id AS societe_id_59, t0.site_id AS site_id_60, t0.dossierannexes_id AS dossierannexes_id_61, t0.apprenant_id AS apprenant_id_62, t0.parcours AS parcours_63, t0.reorienter_id AS reorienter_id_64, t0.referent_pedagogique_id AS referent_pedagogique_id_65, t0.referent_commercial_id AS referent_commercial_id_66, t0.referent_coach_id AS referent_coach_id_67, t0.referent_administratif_id AS referent_administratif_id_68, t0.entreprise_id AS entreprise_id_69, t0.entreprise_contact_id AS entreprise_contact_id_70, t0.cv_id AS cv_id_71, t0.platforme_id AS platforme_id_72, t73.id AS id_74, t73.created_at AS created_at_75, t73.updated_at AS updated_at_76, t73.archive AS archive_77, t73.token AS token_78, t73.intitule AS intitule_79, t73.acrrochage AS acrrochage_80, t73.document_genere AS document_genere_81, t73.date_examen AS date_examen_82, t73.created_by_id AS created_by_id_83, t73.updated_by_id AS updated_by_id_84, t73.admission_id AS admission_id_85, t73.mention_id AS mention_id_86, t73.president_jury_id AS president_jury_id_87, t73.dossier_id AS dossier_id_88, t73.parcours_id AS parcours_id_89, t73.qr_code_id AS qr_code_id_90, t0.emergency_contact_id AS emergency_contact_id_91, t0.legal_representative_id AS legal_representative_id_92, t0.etablissement_id AS etablissement_id_93 FROM dossier t0 LEFT JOIN diplome t73 ON t73.dossier_id = t0.id WHERE t0.session_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.reference AS reference_5, t0.items_document AS items_document_6, t0.email_logs AS email_logs_7, t0.panier AS panier_8, t0.competences AS competences_9, t0.cart AS cart_10, t0.mode AS mode_11, t0.linkedin AS linkedin_12, t0.portfolio AS portfolio_13, t0.campus AS campus_14, t0.modalite_enseignement AS modalite_enseignement_15, t0.commentaire AS commentaire_16, t0.email_candidature AS email_candidature_17, t0.date_reunion AS date_reunion_18, t0.stop_date AS stop_date_19, t0.candidate_available AS candidate_available_20, t0.rncp AS rncp_21, t0.diplomant AS diplomant_22, t0.delegue_classe AS delegue_classe_23, t0.postulant_available AS postulant_available_24, t0.prospect_available AS prospect_available_25, t0.stagiaire_available AS stagiaire_available_26, t0.alumni_available AS alumni_available_27, t0.news_letter AS news_letter_28, t0.processed AS processed_29, t0.statut_declaration AS statut_declaration_30, t0.a_representant_legal AS a_representant_legal_31, t0.notification_paiement AS notification_paiement_32, t0.engagement_formation AS engagement_formation_33, t0.charte_formation AS charte_formation_34, t0.compte_zoom AS compte_zoom_35, t0.notified AS notified_36, t0.femme_eloigne AS femme_eloigne_37, t0.zrr AS zrr_38, t0.qpv AS qpv_39, t0.participation_reglee AS participation_reglee_40, t0.participation AS participation_41, t0.caution AS caution_42, t0.restea_regler AS restea_regler_43, t0.created_by_id AS created_by_id_44, t0.updated_by_id AS updated_by_id_45, t0.stop_proof_id AS stop_proof_id_46, t0.stop_cause_id AS stop_cause_id_47, t0.stop_type_id AS stop_type_id_48, t0.type_actif_id AS type_actif_id_49, t0.state_id AS state_id_50, t0.dispositif_id AS dispositif_id_51, t0.type_formation_id AS type_formation_id_52, t0.resultat_id AS resultat_id_53, t0.profil_id AS profil_id_54, t0.personal_informations_id AS personal_informations_id_55, t0.adresse_id AS adresse_id_56, t0.planning_id AS planning_id_57, t0.session_id AS session_id_58, t0.societe_id AS societe_id_59, t0.site_id AS site_id_60, t0.dossierannexes_id AS dossierannexes_id_61, t0.apprenant_id AS apprenant_id_62, t0.parcours AS parcours_63, t0.reorienter_id AS reorienter_id_64, t0.referent_pedagogique_id AS referent_pedagogique_id_65, t0.referent_commercial_id AS referent_commercial_id_66, t0.referent_coach_id AS referent_coach_id_67, t0.referent_administratif_id AS referent_administratif_id_68, t0.entreprise_id AS entreprise_id_69, t0.entreprise_contact_id AS entreprise_contact_id_70, t0.cv_id AS cv_id_71, t0.platforme_id AS platforme_id_72, t73.id AS id_74, t73.created_at AS created_at_75, t73.updated_at AS updated_at_76, t73.archive AS archive_77, t73.token AS token_78, t73.intitule AS intitule_79, t73.acrrochage AS acrrochage_80, t73.document_genere AS document_genere_81, t73.date_examen AS date_examen_82, t73.created_by_id AS created_by_id_83, t73.updated_by_id AS updated_by_id_84, t73.admission_id AS admission_id_85, t73.mention_id AS mention_id_86, t73.president_jury_id AS president_jury_id_87, t73.dossier_id AS dossier_id_88, t73.parcours_id AS parcours_id_89, t73.qr_code_id AS qr_code_id_90, t0.emergency_contact_id AS emergency_contact_id_91, t0.legal_representative_id AS legal_representative_id_92, t0.etablissement_id AS etablissement_id_93 FROM dossier t0 LEFT JOIN diplome t73 ON t73.dossier_id = t0.id WHERE t0.session_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.reference AS reference_5, t0.items_document AS items_document_6, t0.email_logs AS email_logs_7, t0.panier AS panier_8, t0.competences AS competences_9, t0.cart AS cart_10, t0.mode AS mode_11, t0.linkedin AS linkedin_12, t0.portfolio AS portfolio_13, t0.campus AS campus_14, t0.modalite_enseignement AS modalite_enseignement_15, t0.commentaire AS commentaire_16, t0.email_candidature AS email_candidature_17, t0.date_reunion AS date_reunion_18, t0.stop_date AS stop_date_19, t0.candidate_available AS candidate_available_20, t0.rncp AS rncp_21, t0.diplomant AS diplomant_22, t0.delegue_classe AS delegue_classe_23, t0.postulant_available AS postulant_available_24, t0.prospect_available AS prospect_available_25, t0.stagiaire_available AS stagiaire_available_26, t0.alumni_available AS alumni_available_27, t0.news_letter AS news_letter_28, t0.processed AS processed_29, t0.statut_declaration AS statut_declaration_30, t0.a_representant_legal AS a_representant_legal_31, t0.notification_paiement AS notification_paiement_32, t0.engagement_formation AS engagement_formation_33, t0.charte_formation AS charte_formation_34, t0.compte_zoom AS compte_zoom_35, t0.notified AS notified_36, t0.femme_eloigne AS femme_eloigne_37, t0.zrr AS zrr_38, t0.qpv AS qpv_39, t0.participation_reglee AS participation_reglee_40, t0.participation AS participation_41, t0.caution AS caution_42, t0.restea_regler AS restea_regler_43, t0.created_by_id AS created_by_id_44, t0.updated_by_id AS updated_by_id_45, t0.stop_proof_id AS stop_proof_id_46, t0.stop_cause_id AS stop_cause_id_47, t0.stop_type_id AS stop_type_id_48, t0.type_actif_id AS type_actif_id_49, t0.state_id AS state_id_50, t0.dispositif_id AS dispositif_id_51, t0.type_formation_id AS type_formation_id_52, t0.resultat_id AS resultat_id_53, t0.profil_id AS profil_id_54, t0.personal_informations_id AS personal_informations_id_55, t0.adresse_id AS adresse_id_56, t0.planning_id AS planning_id_57, t0.session_id AS session_id_58, t0.societe_id AS societe_id_59, t0.site_id AS site_id_60, t0.dossierannexes_id AS dossierannexes_id_61, t0.apprenant_id AS apprenant_id_62, t0.parcours AS parcours_63, t0.reorienter_id AS reorienter_id_64, t0.referent_pedagogique_id AS referent_pedagogique_id_65, t0.referent_commercial_id AS referent_commercial_id_66, t0.referent_coach_id AS referent_coach_id_67, t0.referent_administratif_id AS referent_administratif_id_68, t0.entreprise_id AS entreprise_id_69, t0.entreprise_contact_id AS entreprise_contact_id_70, t0.cv_id AS cv_id_71, t0.platforme_id AS platforme_id_72, t73.id AS id_74, t73.created_at AS created_at_75, t73.updated_at AS updated_at_76, t73.archive AS archive_77, t73.token AS token_78, t73.intitule AS intitule_79, t73.acrrochage AS acrrochage_80, t73.document_genere AS document_genere_81, t73.date_examen AS date_examen_82, t73.created_by_id AS created_by_id_83, t73.updated_by_id AS updated_by_id_84, t73.admission_id AS admission_id_85, t73.mention_id AS mention_id_86, t73.president_jury_id AS president_jury_id_87, t73.dossier_id AS dossier_id_88, t73.parcours_id AS parcours_id_89, t73.qr_code_id AS qr_code_id_90, t0.emergency_contact_id AS emergency_contact_id_91, t0.legal_representative_id AS legal_representative_id_92, t0.etablissement_id AS etablissement_id_93 FROM dossier t0 LEFT JOIN diplome t73 ON t73.dossier_id = t0.id WHERE t0.session_id = 11;
0.83 ms (1.08%)	2	SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN formateur_module f4_ ON f1_.id = f4_.formateur_id LEFT JOIN module m5_ ON f4_.module_id = m5_.id LEFT JOIN certification c6_ ON m5_.id = c6_.id WHERE m3_.code IN (?, ?) AND m5_.id = ? ORDER BY u0_.id ASC Parameters: [`"confirme" "attente" 106`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN formateur_module f4_ ON f1_.id = f4_.formateur_id LEFT JOIN module m5_ ON f4_.module_id = m5_.id LEFT JOIN certification c6_ ON m5_.id = c6_.id WHERE m3_.code IN (?, ?) AND m5_.id = ? ORDER BY u0_.id ASC SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, f1_.prefecture AS prefecture_12, f1_.numero_activite AS numero_activite_13, f1_.numero_activite2 AS numero_activite2_14, f1_.liste_competences AS liste_competences_15, f1_.debut_habilitation AS debut_habilitation_16, f1_.fin_habilitation AS fin_habilitation_17, f1_.jury_uniquement AS jury_uniquement_18, f1_.mission_proposee AS mission_proposee_19, u0_.type AS type_20, u0_.created_by_id AS created_by_id_21, u0_.updated_by_id AS updated_by_id_22, u0_.adresse_id AS adresse_id_23, u0_.photo_id AS photo_id_24, u0_.api_gestiform_id AS api_gestiform_id_25, p2_.personal_informations_id AS personal_informations_id_26, p2_.signature_file_id AS signature_file_id_27, f1_.statut_id AS statut_id_28 FROM formateur f1_ INNER JOIN personne p2_ ON f1_.id = p2_.id INNER JOIN user u0_ ON f1_.id = u0_.id INNER JOIN masterlistelg m3_ ON f1_.statut_id = m3_.id LEFT JOIN formateur_module f4_ ON f1_.id = f4_.formateur_id LEFT JOIN module m5_ ON f4_.module_id = m5_.id LEFT JOIN certification c6_ ON m5_.id = c6_.id WHERE m3_.code IN ('confirme', 'attente') AND m5_.id = 106 ORDER BY u0_.id ASC;
0.83 ms (1.07%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.lieu AS lieu_20, t0.modalite_par_defaut AS modalite_par_defaut_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23, t0.salle_defaut_id AS salle_defaut_id_24, t0.parcours_id AS parcours_id_25, t0.adresse_partenaire_id AS adresse_partenaire_id_26, t0.statut_id AS statut_id_27, t0.referent_pedagogique_id AS referent_pedagogique_id_28, t0.referent_coach_id AS referent_coach_id_29, t0.referent_administratif_id AS referent_administratif_id_30, t0.referent_handicap_id AS referent_handicap_id_31, t0.planning_id AS planning_id_32, t0.site_id AS site_id_33, t0.api_gestiform_id AS api_gestiform_id_34 FROM session t0 WHERE t0.id = ? Parameters: [`"11"`] View formatted query View runnable query Explain query 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.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.lieu AS lieu_20, t0.modalite_par_defaut AS modalite_par_defaut_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23, t0.salle_defaut_id AS salle_defaut_id_24, t0.parcours_id AS parcours_id_25, t0.adresse_partenaire_id AS adresse_partenaire_id_26, t0.statut_id AS statut_id_27, t0.referent_pedagogique_id AS referent_pedagogique_id_28, t0.referent_coach_id AS referent_coach_id_29, t0.referent_administratif_id AS referent_administratif_id_30, t0.referent_handicap_id AS referent_handicap_id_31, t0.planning_id AS planning_id_32, t0.site_id AS site_id_33, t0.api_gestiform_id AS api_gestiform_id_34 FROM session t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.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.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.lieu AS lieu_20, t0.modalite_par_defaut AS modalite_par_defaut_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23, t0.salle_defaut_id AS salle_defaut_id_24, t0.parcours_id AS parcours_id_25, t0.adresse_partenaire_id AS adresse_partenaire_id_26, t0.statut_id AS statut_id_27, t0.referent_pedagogique_id AS referent_pedagogique_id_28, t0.referent_coach_id AS referent_coach_id_29, t0.referent_administratif_id AS referent_administratif_id_30, t0.referent_handicap_id AS referent_handicap_id_31, t0.planning_id AS planning_id_32, t0.site_id AS site_id_33, t0.api_gestiform_id AS api_gestiform_id_34 FROM session t0 WHERE t0.id = '11';
0.76 ms (0.99%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = 33;
0.74 ms (0.96%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.numerotation AS numerotation_5, t0.reference AS reference_6, t0.duree AS duree_7, t0.tarif AS tarif_8, t0.montant_total AS montant_total_9, t0.unite AS unite_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.contrat_id AS contrat_id_13, t0.state_id AS state_id_14, t0.signature_file_id AS signature_file_id_15 FROM prestation t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.numerotation AS numerotation_5, t0.reference AS reference_6, t0.duree AS duree_7, t0.tarif AS tarif_8, t0.montant_total AS montant_total_9, t0.unite AS unite_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.contrat_id AS contrat_id_13, t0.state_id AS state_id_14, t0.signature_file_id AS signature_file_id_15 FROM prestation t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.numerotation AS numerotation_5, t0.reference AS reference_6, t0.duree AS duree_7, t0.tarif AS tarif_8, t0.montant_total AS montant_total_9, t0.unite AS unite_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.contrat_id AS contrat_id_13, t0.state_id AS state_id_14, t0.signature_file_id AS signature_file_id_15 FROM prestation t0 WHERE t0.id = 1;
0.70 ms (0.91%)	6	SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE 1=0 Parameters: [] View formatted query View runnable query Explain query SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE 1 = 0 SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE 1=0;
0.61 ms (0.79%)	1	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? GROUP BY d0_.type_actif_id Parameters: [`11`] View formatted query View runnable query Explain query SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? GROUP BY d0_.type_actif_id SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = 11 GROUP BY d0_.type_actif_id;
0.56 ms (0.73%)	1	SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = ? AND e0_.expires_at > ? AND e0_.resource_id = ? ORDER BY e0_.updated_at DESC LIMIT 1 Parameters: [`"CALENDRIER" "2026-06-22 13:24:28" 11`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = ? AND e0_.expires_at > ? AND e0_.resource_id = ? ORDER BY e0_.updated_at DESC LIMIT 1 SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = 'CALENDRIER' AND e0_.expires_at > '2026-06-22 13:24:28' AND e0_.resource_id = 11 ORDER BY e0_.updated_at DESC LIMIT 1;
0.52 ms (0.68%)	1	SELECT COUNT(d0_.id) AS sclr_0 FROM dossier d0_ INNER JOIN masterlistelg m1_ ON d0_.type_actif_id = m1_.id WHERE d0_.session_id = ? AND m1_.code = ? Parameters: [`11 "alumni"`] View formatted query View runnable query Explain query SELECT COUNT(d0_.id) AS sclr_0 FROM dossier d0_ INNER JOIN masterlistelg m1_ ON d0_.type_actif_id = m1_.id WHERE d0_.session_id = ? AND m1_.code = ? SELECT COUNT(d0_.id) AS sclr_0 FROM dossier d0_ INNER JOIN masterlistelg m1_ ON d0_.type_actif_id = m1_.id WHERE d0_.session_id = 11 AND m1_.code = 'alumni';
0.49 ms (0.63%)	2	DELETE FROM edit_locks WHERE expires_at <= ? Parameters: [`"2026-06-22 13:24:28"`] View formatted query View runnable query Explain query DELETE FROM edit_locks WHERE expires_at <= ? DELETE FROM edit_locks WHERE expires_at <= '2026-06-22 13:24:28';
0.45 ms (0.59%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.code_cpf AS code_cpf_6, t0.rncp AS rncp_7, t0.code_rncp_rs AS code_rncp_rs_8, t0.type AS type_9, t0.commentaires AS commentaires_10, t0.detail_evaluation AS detail_evaluation_11, t0.duree AS duree_12, t0.ects AS ects_13, t0.ordre AS ordre_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.parcours_id AS parcours_id_17, t0.parent_id AS parent_id_18 FROM bloc t0 WHERE t0.parcours_id = ? Parameters: [`33`] View formatted query View runnable query Explain query 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_cpf AS code_cpf_6, t0.rncp AS rncp_7, t0.code_rncp_rs AS code_rncp_rs_8, t0.type AS type_9, t0.commentaires AS commentaires_10, t0.detail_evaluation AS detail_evaluation_11, t0.duree AS duree_12, t0.ects AS ects_13, t0.ordre AS ordre_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.parcours_id AS parcours_id_17, t0.parent_id AS parent_id_18 FROM bloc t0 WHERE t0.parcours_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.code_cpf AS code_cpf_6, t0.rncp AS rncp_7, t0.code_rncp_rs AS code_rncp_rs_8, t0.type AS type_9, t0.commentaires AS commentaires_10, t0.detail_evaluation AS detail_evaluation_11, t0.duree AS duree_12, t0.ects AS ects_13, t0.ordre AS ordre_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.parcours_id AS parcours_id_17, t0.parent_id AS parent_id_18 FROM bloc t0 WHERE t0.parcours_id = 33;
0.44 ms (0.58%)	2	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.44 ms (0.57%)	2	SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t2.id = ? Parameters: [`32`] View formatted query View runnable query Explain query SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t2.id = ? SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t2.id = 32;
0.36 ms (0.46%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.presence AS presence_7, t0.absence AS absence_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.event_id AS event_id_11, t0.ampm_id AS ampm_id_12, t0.declaration_id AS declaration_id_13 FROM emargement t0 WHERE t0.event_id = ? Parameters: [`25`] View formatted query View runnable query Explain query 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.presence AS presence_7, t0.absence AS absence_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.event_id AS event_id_11, t0.ampm_id AS ampm_id_12, t0.declaration_id AS declaration_id_13 FROM emargement t0 WHERE t0.event_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.presence AS presence_7, t0.absence AS absence_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.event_id AS event_id_11, t0.ampm_id AS ampm_id_12, t0.declaration_id AS declaration_id_13 FROM emargement t0 WHERE t0.event_id = 25;
0.34 ms (0.44%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? Parameters: [`12`] View formatted query View runnable query Explain query 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.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = 12;
0.34 ms (0.44%)	3	SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t0.statut_id IN (?, ?) Parameters: [`629 624`] View formatted query View runnable query Explain query SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t0.statut_id IN (?, ?) SELECT t2.id AS id_3, t2.created_at AS created_at_4, t2.updated_at AS updated_at_5, t2.archive AS archive_6, t2.email AS email_7, t2.password AS password_8, t2.plain_password AS plain_password_9, t2.roles AS roles_10, t2.enabled AS enabled_11, t2.status AS status_12, t2.rgpd AS rgpd_13, t2.api_token AS api_token_14, t0.prefecture AS prefecture_15, t0.numero_activite AS numero_activite_16, t0.numero_activite2 AS numero_activite2_17, t0.liste_competences AS liste_competences_18, t0.debut_habilitation AS debut_habilitation_19, t0.fin_habilitation AS fin_habilitation_20, t0.jury_uniquement AS jury_uniquement_21, t0.mission_proposee AS mission_proposee_22, t2.created_by_id AS created_by_id_23, t2.updated_by_id AS updated_by_id_24, t2.adresse_id AS adresse_id_25, t2.photo_id AS photo_id_26, t2.api_gestiform_id AS api_gestiform_id_27, t1.personal_informations_id AS personal_informations_id_28, t1.signature_file_id AS signature_file_id_29, t0.statut_id AS statut_id_30, t2.type FROM formateur t0 INNER JOIN personne t1 ON t0.id = t1.id INNER JOIN user t2 ON t0.id = t2.id WHERE t0.statut_id IN (629, 624);
0.28 ms (0.36%)	1	INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"CALENDRIER" "/formations/session-parcours/11" 11 "2026-06-22 13:24:28" "2026-06-22 13:29:28" "2026-06-22 13:24:28" 1`] View formatted query View runnable query Explain query INSERT INTO edit_locks ( resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES ('CALENDRIER', '/formations/session-parcours/11', 11, '2026-06-22 13:24:28', '2026-06-22 13:29:28', '2026-06-22 13:24:28', 1);
0.27 ms (0.36%)	1	SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = ? AND e0_.expires_at > ? AND e0_.resource_url = ? AND e0_.resource_id = ? ORDER BY e0_.updated_at DESC LIMIT 1 Parameters: [`"CALENDRIER" "2026-06-22 13:24:28" "/formations/session-parcours/11" 11`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = ? AND e0_.expires_at > ? AND e0_.resource_url = ? AND e0_.resource_id = ? ORDER BY e0_.updated_at DESC LIMIT 1 SELECT e0_.id AS id_0, e0_.resource_type AS resource_type_1, e0_.resource_url AS resource_url_2, e0_.resource_id AS resource_id_3, e0_.created_at AS created_at_4, e0_.expires_at AS expires_at_5, e0_.updated_at AS updated_at_6, e0_.locked_by_id AS locked_by_id_7 FROM edit_locks e0_ WHERE e0_.resource_type = 'CALENDRIER' AND e0_.expires_at > '2026-06-22 13:24:28' AND e0_.resource_url = '/formations/session-parcours/11' AND e0_.resource_id = 11 ORDER BY e0_.updated_at DESC LIMIT 1;
0.26 ms (0.34%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ? Parameters: [`317`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = 317;
0.24 ms (0.31%)	1	SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t1.id = ? Parameters: [`165`] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t1.id = ? SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.delegataire AS delegataire_32, t0.assurance_chomage AS assurance_chomage_33, t0.rna AS rna_34, t0.effectif AS effectif_35, t0.cart AS cart_36, t0.activite_principale AS activite_principale_37, t0.mission_proposee AS mission_proposee_38, t1.created_by_id AS created_by_id_39, t1.updated_by_id AS updated_by_id_40, t1.logo_id AS logo_id_41, t1.convention_collective_id AS convention_collective_id_42, t1.code_tva_id AS code_tva_id_43, t1.personne_id AS personne_id_44, t1.api_gestiform_id AS api_gestiform_id_45, t0.type_id AS type_id_46, t0.type_employeur_id AS type_employeur_id_47, t0.employeur_specifique_id AS employeur_specifique_id_48, t0.naf_id AS naf_id_49, t0.financeur_entreprise_id AS financeur_entreprise_id_50, t0.adhesion_regime_chomage_public_id AS adhesion_regime_chomage_public_id_51, t0.cachet_id AS cachet_id_52, t1.type FROM entreprise t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t1.id = 165;
0.23 ms (0.30%)	2	SELECT t1.id AS id_4, t1.created_at AS created_at_5, t1.updated_at AS updated_at_6, t1.archive AS archive_7, t1.email AS email_8, t1.password AS password_9, t1.plain_password AS plain_password_10, t1.roles AS roles_11, t1.enabled AS enabled_12, t1.status AS status_13, t1.rgpd AS rgpd_14, t1.api_token AS api_token_15, t1.created_by_id AS created_by_id_16, t1.updated_by_id AS updated_by_id_17, t1.adresse_id AS adresse_id_18, t1.photo_id AS photo_id_19, t1.api_gestiform_id AS api_gestiform_id_20, t0.personal_informations_id AS personal_informations_id_21, t0.signature_file_id AS signature_file_id_22, t1.type, t2.mineur AS mineur_23, t2.dossier_actif_id AS dossier_actif_id_24, t2.representant_legal_id AS representant_legal_id_25, t3.prefecture AS prefecture_26, t3.numero_activite AS numero_activite_27, t3.numero_activite2 AS numero_activite2_28, t3.liste_competences AS liste_competences_29, t3.debut_habilitation AS debut_habilitation_30, t3.fin_habilitation AS fin_habilitation_31, t3.jury_uniquement AS jury_uniquement_32, t3.mission_proposee AS mission_proposee_33, t3.statut_id AS statut_id_34 FROM personne t0 INNER JOIN user t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id WHERE t1.id = ? Parameters: [`28`] View formatted query View runnable query Explain query SELECT t1.id AS id_4, t1.created_at AS created_at_5, t1.updated_at AS updated_at_6, t1.archive AS archive_7, t1.email AS email_8, t1.password AS password_9, t1.plain_password AS plain_password_10, t1.roles AS roles_11, t1.enabled AS enabled_12, t1.status AS status_13, t1.rgpd AS rgpd_14, t1.api_token AS api_token_15, t1.created_by_id AS created_by_id_16, t1.updated_by_id AS updated_by_id_17, t1.adresse_id AS adresse_id_18, t1.photo_id AS photo_id_19, t1.api_gestiform_id AS api_gestiform_id_20, t0.personal_informations_id AS personal_informations_id_21, t0.signature_file_id AS signature_file_id_22, t1.type, t2.mineur AS mineur_23, t2.dossier_actif_id AS dossier_actif_id_24, t2.representant_legal_id AS representant_legal_id_25, t3.prefecture AS prefecture_26, t3.numero_activite AS numero_activite_27, t3.numero_activite2 AS numero_activite2_28, t3.liste_competences AS liste_competences_29, t3.debut_habilitation AS debut_habilitation_30, t3.fin_habilitation AS fin_habilitation_31, t3.jury_uniquement AS jury_uniquement_32, t3.mission_proposee AS mission_proposee_33, t3.statut_id AS statut_id_34 FROM personne t0 INNER JOIN user t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id WHERE t1.id = ? SELECT t1.id AS id_4, t1.created_at AS created_at_5, t1.updated_at AS updated_at_6, t1.archive AS archive_7, t1.email AS email_8, t1.password AS password_9, t1.plain_password AS plain_password_10, t1.roles AS roles_11, t1.enabled AS enabled_12, t1.status AS status_13, t1.rgpd AS rgpd_14, t1.api_token AS api_token_15, t1.created_by_id AS created_by_id_16, t1.updated_by_id AS updated_by_id_17, t1.adresse_id AS adresse_id_18, t1.photo_id AS photo_id_19, t1.api_gestiform_id AS api_gestiform_id_20, t0.personal_informations_id AS personal_informations_id_21, t0.signature_file_id AS signature_file_id_22, t1.type, t2.mineur AS mineur_23, t2.dossier_actif_id AS dossier_actif_id_24, t2.representant_legal_id AS representant_legal_id_25, t3.prefecture AS prefecture_26, t3.numero_activite AS numero_activite_27, t3.numero_activite2 AS numero_activite2_28, t3.liste_competences AS liste_competences_29, t3.debut_habilitation AS debut_habilitation_30, t3.fin_habilitation AS fin_habilitation_31, t3.jury_uniquement AS jury_uniquement_32, t3.mission_proposee AS mission_proposee_33, t3.statut_id AS statut_id_34 FROM personne t0 INNER JOIN user t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id WHERE t1.id = 28;
0.22 ms (0.29%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.intitule_session AS intitule_session_7, t0.mode_formation AS mode_formation_8, t0.code_event AS code_event_9, t0.id_event AS id_event_10, t0.duree AS duree_11, t0.unite AS unite_12, t0.montant AS montant_13, t0.tarif AS tarif_14, t0.start AS start_15, t0.end AS end_16, t0.event_childs AS event_childs_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.statut_id AS statut_id_20, t0.prestation_id AS prestation_id_21 FROM ligne_prestation t0 INNER JOIN ligne_prestation_formateur ON t0.id = ligne_prestation_formateur.ligne_prestation_id WHERE ligne_prestation_formateur.formateur_id = ? Parameters: [`32`] View formatted query View runnable query Explain query 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.intitule_session AS intitule_session_7, t0.mode_formation AS mode_formation_8, t0.code_event AS code_event_9, t0.id_event AS id_event_10, t0.duree AS duree_11, t0.unite AS unite_12, t0.montant AS montant_13, t0.tarif AS tarif_14, t0.start AS start_15, t0.end AS end_16, t0.event_childs AS event_childs_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.statut_id AS statut_id_20, t0.prestation_id AS prestation_id_21 FROM ligne_prestation t0 INNER JOIN ligne_prestation_formateur ON t0.id = ligne_prestation_formateur.ligne_prestation_id WHERE ligne_prestation_formateur.formateur_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.intitule_session AS intitule_session_7, t0.mode_formation AS mode_formation_8, t0.code_event AS code_event_9, t0.id_event AS id_event_10, t0.duree AS duree_11, t0.unite AS unite_12, t0.montant AS montant_13, t0.tarif AS tarif_14, t0.start AS start_15, t0.end AS end_16, t0.event_childs AS event_childs_17, t0.created_by_id AS created_by_id_18, t0.updated_by_id AS updated_by_id_19, t0.statut_id AS statut_id_20, t0.prestation_id AS prestation_id_21 FROM ligne_prestation t0 INNER JOIN ligne_prestation_formateur ON t0.id = ligne_prestation_formateur.ligne_prestation_id WHERE ligne_prestation_formateur.formateur_id = 32;
0.21 ms (0.27%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? LIMIT 1 Parameters: [`"FINANCEURS" "CATEGORIES"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = 'FINANCEURS' AND t0.code = 'CATEGORIES' LIMIT 1;
0.19 ms (0.25%)	2	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.formateur_id AS formateur_id_7, t0.entreprise_id AS entreprise_id_8, t0.contact_id AS contact_id_9 FROM formateur_entreprise t0 WHERE t0.formateur_id = ? Parameters: [`32`] View formatted query View runnable query Explain query 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.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.formateur_id AS formateur_id_7, t0.entreprise_id AS entreprise_id_8, t0.contact_id AS contact_id_9 FROM formateur_entreprise t0 WHERE t0.formateur_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6, t0.formateur_id AS formateur_id_7, t0.entreprise_id AS entreprise_id_8, t0.contact_id AS contact_id_9 FROM formateur_entreprise t0 WHERE t0.formateur_id = 32;
0.19 ms (0.25%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.parent_id = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.parent_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.intitule_officiel AS intitule_officiel_6, t0.code AS code_7, t0.code_diplome AS code_diplome_8, t0.sigle AS sigle_9, t0.date_debut_valide AS date_debut_valide_10, t0.date_fin_valide AS date_fin_valide_11, t0.date_publication_officiel AS date_publication_officiel_12, t0.plus AS plus_13, t0.redirection AS redirection_14, t0.publication AS publication_15, t0.publication_api AS publication_api_16, t0.tauxObtention AS tauxObtention_17, t0.taux_abandon AS taux_abandon_18, t0.taux_satisfaction AS taux_satisfaction_19, t0.taux_pour_suite_etude AS taux_pour_suite_etude_20, t0.taux_employabilite AS taux_employabilite_21, t0.prerequis AS prerequis_22, t0.salaire_moyen AS salaire_moyen_23, t0.livrable AS livrable_24, t0.alt_banniere AS alt_banniere_25, t0.alt_vignette AS alt_vignette_26, t0.tarif_jury AS tarif_jury_27, t0.tarif_jury2 AS tarif_jury2_28, t0.tarif_jury_ttc AS tarif_jury_ttc_29, t0.cpf AS cpf_30, t0.code_cpf AS code_cpf_31, t0.code_rncp_rs AS code_rncp_rs_32, t0.code_cpf_salarie AS code_cpf_salarie_33, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_34, t0.code_nsf AS code_nsf_35, t0.duree AS duree_36, t0.duree_modulaire AS duree_modulaire_37, t0.rncp AS rncp_38, t0.duree_accompagnement AS duree_accompagnement_39, t0.duree_stage AS duree_stage_40, t0.duree_center AS duree_center_41, t0.duree_elearning AS duree_elearning_42, t0.stage_obligatoire AS stage_obligatoire_43, t0.formation_permanente AS formation_permanente_44, t0.sanction_resume AS sanction_resume_45, t0.sanction_long AS sanction_long_46, t0.metier AS metier_47, t0.accessibilite_handicap AS accessibilite_handicap_48, t0.modalites_delais_acces AS modalites_delais_acces_49, t0.modaliteevaluationinitial AS modaliteevaluationinitial_50, t0.modaliteevaluationfinal AS modaliteevaluationfinal_51, t0.text AS text_52, t0.objectif AS objectif_53, t0.debouche AS debouche_54, t0.condition_admission AS condition_admission_55, t0.public AS public_56, t0.detail_examen AS detail_examen_57, t0.frais_pedagogique AS frais_pedagogique_58, t0.methodes_mobilisees AS methodes_mobilisees_59, t0.seo_titre AS seo_titre_60, t0.seo_description AS seo_description_61, t0.rythme AS rythme_62, t0.identifiant_dokelio AS identifiant_dokelio_63, t0.dokelio_parcours AS dokelio_parcours_64, t0.contenu_apres AS contenu_apres_65, t0.contenu_avant AS contenu_avant_66, t0.path AS path_67, t0.items AS items_68, t0.is_default AS is_default_69, t0.created_by_id AS created_by_id_70, t0.updated_by_id AS updated_by_id_71, t0.theme_id AS theme_id_72, t0.parent_id AS parent_id_73, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_74, t0.nsf_id AS nsf_id_75, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_76, t0.parcours AS parcours_77, t0.niveau_entree_id AS niveau_entree_id_78, t0.niveau_sortie_id AS niveau_sortie_id_79, t0.niveau_technique_id AS niveau_technique_id_80, t0.qualifiant_id AS qualifiant_id_81, t0.type_formation_id AS type_formation_id_82, t0.autorite_delivrance_id AS autorite_delivrance_id_83, t0.mode_formation_id AS mode_formation_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.parent_id = 30;
0.18 ms (0.24%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? AND t0.api_gestiform_id = ? LIMIT 1 Parameters: [`"CALENDRIER" "WEEKEND" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? AND t0.api_gestiform_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = 'CALENDRIER' AND t0.code = 'WEEKEND' AND t0.api_gestiform_id = 1 LIMIT 1;
0.18 ms (0.23%)	1	SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.capacite AS capacite_5, s0_.uservituelid AS uservituelid_6, s0_.sallevirtuelleid AS sallevirtuelleid_7, s0_.logocouleur AS logocouleur_8, s0_.lienvirtuel AS lienvirtuel_9, s0_.reservee AS reservee_10, s0_.virtuel AS virtuel_11, s0_.created_by_id AS created_by_id_12, s0_.updated_by_id AS updated_by_id_13, s0_.site_id AS site_id_14, s0_.niveau_materiel_id AS niveau_materiel_id_15 FROM salle s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.capacite AS capacite_5, s0_.uservituelid AS uservituelid_6, s0_.sallevirtuelleid AS sallevirtuelleid_7, s0_.logocouleur AS logocouleur_8, s0_.lienvirtuel AS lienvirtuel_9, s0_.reservee AS reservee_10, s0_.virtuel AS virtuel_11, s0_.created_by_id AS created_by_id_12, s0_.updated_by_id AS updated_by_id_13, s0_.site_id AS site_id_14, s0_.niveau_materiel_id AS niveau_materiel_id_15 FROM salle s0_ SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.capacite AS capacite_5, s0_.uservituelid AS uservituelid_6, s0_.sallevirtuelleid AS sallevirtuelleid_7, s0_.logocouleur AS logocouleur_8, s0_.lienvirtuel AS lienvirtuel_9, s0_.reservee AS reservee_10, s0_.virtuel AS virtuel_11, s0_.created_by_id AS created_by_id_12, s0_.updated_by_id AS updated_by_id_13, s0_.site_id AS site_id_14, s0_.niveau_materiel_id AS niveau_materiel_id_15 FROM salle s0_;
0.16 ms (0.21%)	1	SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.siret AS siret_5, s0_.numero_uai AS numero_uai_6, s0_.virtuel AS virtuel_7, s0_.tel_fixe AS tel_fixe_8, s0_.mobile AS mobile_9, s0_.contact_email AS contact_email_10, s0_.created_by_id AS created_by_id_11, s0_.updated_by_id AS updated_by_id_12, s0_.societe_id AS societe_id_13, s0_.adresse_id AS adresse_id_14, s0_.responsable_site_id AS responsable_site_id_15, s0_.responsable_handicap_id AS responsable_handicap_id_16 FROM site s0_ ORDER BY s0_.intitule ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.siret AS siret_5, s0_.numero_uai AS numero_uai_6, s0_.virtuel AS virtuel_7, s0_.tel_fixe AS tel_fixe_8, s0_.mobile AS mobile_9, s0_.contact_email AS contact_email_10, s0_.created_by_id AS created_by_id_11, s0_.updated_by_id AS updated_by_id_12, s0_.societe_id AS societe_id_13, s0_.adresse_id AS adresse_id_14, s0_.responsable_site_id AS responsable_site_id_15, s0_.responsable_handicap_id AS responsable_handicap_id_16 FROM site s0_ ORDER BY s0_.intitule ASC SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.archive AS archive_3, s0_.intitule AS intitule_4, s0_.siret AS siret_5, s0_.numero_uai AS numero_uai_6, s0_.virtuel AS virtuel_7, s0_.tel_fixe AS tel_fixe_8, s0_.mobile AS mobile_9, s0_.contact_email AS contact_email_10, s0_.created_by_id AS created_by_id_11, s0_.updated_by_id AS updated_by_id_12, s0_.societe_id AS societe_id_13, s0_.adresse_id AS adresse_id_14, s0_.responsable_site_id AS responsable_site_id_15, s0_.responsable_handicap_id AS responsable_handicap_id_16 FROM site s0_ ORDER BY s0_.intitule ASC;
0.15 ms (0.19%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.code AS code_6, t0.alt_banniere AS alt_banniere_7, t0.alt_vignette AS alt_vignette_8, t0.couleur AS couleur_9, t0.commentaire AS commentaire_10, t0.seotitre AS seotitre_11, t0.seodescription AS seodescription_12, t0.path AS path_13, t0.publication AS publication_14, t0.ordre AS ordre_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.vignette_id AS vignette_id_18, t0.banniere_id AS banniere_id_19, t0.tarif_vente_defaut_id AS tarif_vente_defaut_id_20, t0.tarifventeintradefaut_id AS tarifventeintradefaut_id_21 FROM theme t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query 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.alt_banniere AS alt_banniere_7, t0.alt_vignette AS alt_vignette_8, t0.couleur AS couleur_9, t0.commentaire AS commentaire_10, t0.seotitre AS seotitre_11, t0.seodescription AS seodescription_12, t0.path AS path_13, t0.publication AS publication_14, t0.ordre AS ordre_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.vignette_id AS vignette_id_18, t0.banniere_id AS banniere_id_19, t0.tarif_vente_defaut_id AS tarif_vente_defaut_id_20, t0.tarifventeintradefaut_id AS tarifventeintradefaut_id_21 FROM theme t0 WHERE t0.id = ? SELECT t0.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.alt_banniere AS alt_banniere_7, t0.alt_vignette AS alt_vignette_8, t0.couleur AS couleur_9, t0.commentaire AS commentaire_10, t0.seotitre AS seotitre_11, t0.seodescription AS seodescription_12, t0.path AS path_13, t0.publication AS publication_14, t0.ordre AS ordre_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.vignette_id AS vignette_id_18, t0.banniere_id AS banniere_id_19, t0.tarif_vente_defaut_id AS tarif_vente_defaut_id_20, t0.tarifventeintradefaut_id AS tarifventeintradefaut_id_21 FROM theme t0 WHERE t0.id = 2;
0.14 ms (0.18%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.temps_prise_en_compte AS temps_prise_en_compte_5, t0.all_day AS all_day_6, t0.start AS start_7, t0.end AS end_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_id AS type_id_11 FROM accompagnement t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query 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.temps_prise_en_compte AS temps_prise_en_compte_5, t0.all_day AS all_day_6, t0.start AS start_7, t0.end AS end_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_id AS type_id_11 FROM accompagnement t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.temps_prise_en_compte AS temps_prise_en_compte_5, t0.all_day AS all_day_6, t0.start AS start_7, t0.end AS end_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_id AS type_id_11 FROM accompagnement t0 WHERE t0.id = 5;
0.13 ms (0.16%)	1	SELECT m0_.code AS code_0, m0_.id AS id_1 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = ? Parameters: [`"STATUTDOSSIER"`] View formatted query View runnable query Explain query SELECT m0_.code AS code_0, m0_.id AS id_1 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = ? SELECT m0_.code AS code_0, m0_.id AS id_1 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m1_.code = 'STATUTDOSSIER';
0.11 ms (0.15%)	1	SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, e1_.rgpd_signed_at AS rgpd_signed_at_12, u0_.type AS type_13, u0_.created_by_id AS created_by_id_14, u0_.updated_by_id AS updated_by_id_15, u0_.adresse_id AS adresse_id_16, u0_.photo_id AS photo_id_17, u0_.api_gestiform_id AS api_gestiform_id_18, e1_.personal_informations_id AS personal_informations_id_19, e1_.rgpd_document_id AS rgpd_document_id_20, e1_.responsable_hierarchique_id AS responsable_hierarchique_id_21 FROM employe e1_ INNER JOIN user u0_ ON e1_.id = u0_.id WHERE u0_.archive = 0 AND u0_.enabled = 1 Parameters: [] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, e1_.rgpd_signed_at AS rgpd_signed_at_12, u0_.type AS type_13, u0_.created_by_id AS created_by_id_14, u0_.updated_by_id AS updated_by_id_15, u0_.adresse_id AS adresse_id_16, u0_.photo_id AS photo_id_17, u0_.api_gestiform_id AS api_gestiform_id_18, e1_.personal_informations_id AS personal_informations_id_19, e1_.rgpd_document_id AS rgpd_document_id_20, e1_.responsable_hierarchique_id AS responsable_hierarchique_id_21 FROM employe e1_ INNER JOIN user u0_ ON e1_.id = u0_.id WHERE u0_.archive = 0 AND u0_.enabled = 1 SELECT u0_.id AS id_0, u0_.created_at AS created_at_1, u0_.updated_at AS updated_at_2, u0_.archive AS archive_3, u0_.email AS email_4, u0_.password AS password_5, u0_.plain_password AS plain_password_6, u0_.roles AS roles_7, u0_.enabled AS enabled_8, u0_.status AS status_9, u0_.rgpd AS rgpd_10, u0_.api_token AS api_token_11, e1_.rgpd_signed_at AS rgpd_signed_at_12, u0_.type AS type_13, u0_.created_by_id AS created_by_id_14, u0_.updated_by_id AS updated_by_id_15, u0_.adresse_id AS adresse_id_16, u0_.photo_id AS photo_id_17, u0_.api_gestiform_id AS api_gestiform_id_18, e1_.personal_informations_id AS personal_informations_id_19, e1_.rgpd_document_id AS rgpd_document_id_20, e1_.responsable_hierarchique_id AS responsable_hierarchique_id_21 FROM employe e1_ INNER JOIN user u0_ ON e1_.id = u0_.id WHERE u0_.archive = 0 AND u0_.enabled = 1;
0.10 ms (0.14%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.code AS code_6, t0.remise_pourc AS remise_pourc_7, t0.ordre AS ordre_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_formulaire_id AS type_formulaire_id_11, t0.api_gestiform_id AS api_gestiform_id_12 FROM profil t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.code AS code_6, t0.remise_pourc AS remise_pourc_7, t0.ordre AS ordre_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.type_formulaire_id AS type_formulaire_id_11, t0.api_gestiform_id AS api_gestiform_id_12 FROM profil t0 WHERE t0.id = 1;
0.10 ms (0.14%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = 1;
0.09 ms (0.12%)	1	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.theme_id AS theme_id_8, t0.sous_theme_id AS sous_theme_id_9 FROM sous_theme_theme t0 WHERE t0.id = ? Parameters: [`27`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.theme_id AS theme_id_8, t0.sous_theme_id AS sous_theme_id_9 FROM sous_theme_theme t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.ordre AS ordre_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.theme_id AS theme_id_8, t0.sous_theme_id AS sous_theme_id_9 FROM sous_theme_theme t0 WHERE t0.id = 27;

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\Admin\MasterListe\Masterlistelg	114
App\Entity\Gestiform\Formations\Session\Planning\PlanningEvent	93
App\Entity\Gestiform\Formations\Dossier\PersonalInformations	43
App\Entity\Gestiform\Users\User	41
App\Entity\Common\Upload	40
App\Entity\Gestiform\Formations\Session\Planning\Event	39
App\Entity\Common\Adresse	33
App\Entity\Gestiform\Formations\Session\Planning\Planning	32
App\Entity\Gestiform\Formations\Dossier\Dossier	26
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes	26
App\Entity\Gestiform\Admin\MasterListe\Masterliste	17
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\BlocModule	16
App\Entity\Gestiform\Formations\Session\Planning\LignePrestation	15
App\Entity\Gestiform\Formations\Catalogue\Module\Module	13
App\Entity\Gestiform\Admin\Tiers	10
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	9
App\Entity\Gestiform\Admin\Role	9
App\Entity\Gestiform\Formations\Catalogue\Theme\SousThemeTheme	9
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme	7
App\Entity\Gestiform\Formations\Session\Session	6
App\Entity\Gestiform\Formations\Entreprise\Contact	6
App\Entity\Gestiform\Formations\Session\FormateurEvent	5
App\Entity\Gestiform\Formations\Session\Planning\Prestation	5
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\Bloc	4
App\Entity\Gestiform\Admin\Profil	4
App\Entity\Gestiform\Formations\Emargement\Emargement	4
App\Entity\Gestiform\Formations\Dossier\Diplome	4
App\Entity\Gestiform\Formations\Catalogue\Niveau	3
App\Entity\Gestiform\Formations\Entreprise\FormateurEntreprise	3
App\Entity\Gestiform\Admin\ApiGestiform	2
App\Entity\Gestiform\Formations\Session\Planning\ApprenantLivrable	2
App\Entity\Gestiform\Formations\Entreprise\Contrat	2
App\Entity\Gestiform\Admin\Etablissement	2
App\Entity\Gestiform\Admin\EditLock	1
App\Entity\Gestiform\Formations\Catalogue\Editeur	1
App\Entity\Gestiform\Formations\Session\Planning\Accompagnement	1
App\Entity\Gestiform\Formations\Catalogue\Filiere	1
App\Entity\Common\GroupMessage	1
App\Entity\Gestiform\Admin\Site	1
App\Entity\Gestiform\Admin\Salle	1
App\Entity\Gestiform\Formations\Catalogue\Theme\SousTheme	1
App\Entity\Gestiform\Formations\Session\SalleEvent	1

Entities Mapping

Class	Mapping errors
App\Entity\AbstractEntity	No errors.
App\Entity\Gestiform\Users\User	No errors.
App\Entity\Gestiform\Users\Employe	No errors.
App\Entity\Gestiform\Users\Personne	No errors.
App\Entity\Gestiform\Users\Apprenant	No errors.
App\Entity\Gestiform\Users\Formateur	No errors.
App\Entity\Common\Adresse	No errors.
App\Entity\Common\Upload	No errors.
App\Entity\Gestiform\Admin\ApiGestiform	No errors.
App\Entity\Gestiform\Formations\Dossier\PersonalInformations	No errors.
App\Entity\Gestiform\Formations\Dossier\Dossier	No errors.
App\Entity\Gestiform\Formations\Entreprise\Contact	No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterlistelg	No errors.
App\Entity\Common\HistoriqueEmail	No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterliste	No errors.
App\Entity\Gestiform\Formations\Session\Session	No errors.
App\Entity\Gestiform\Admin\Salle	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Planning	No errors.
App\Entity\Gestiform\Admin\Site	No errors.
App\Entity\Gestiform\Formations\Reunion\Reunion	No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueDossier	No errors.
App\Entity\Gestiform\Formations\Session\SessionBlocModule	No errors.
App\Entity\Gestiform\Formations\Actions\BondeCommandeParcour	No errors.
App\Entity\Gestiform\Admin\Role	No errors.
App\Entity\Gestiform\Admin\EditLock	No errors.
App\Entity\Gestiform\Admin\Profil	No errors.
App\Entity\Gestiform\Admin\Tiers	No errors.
App\Entity\Gestiform\Admin\Societe	No errors.
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes	No errors.
App\Entity\Gestiform\Formations\Entreprise\Entreprise	No errors.
App\Entity\Gestiform\Admin\Platforme	No errors.
App\Entity\Gestiform\Admin\Etablissement	No errors.
App\Entity\Gestiform\Formations\Session\Planning\PlanningEvent	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Event	No errors.
App\Entity\Gestiform\Formations\Session\SalleEvent	No errors.
App\Entity\Gestiform\Formations\Session\Planning\ApprenantLivrable	No errors.
App\Entity\Common\Convention	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Accompagnement	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Module	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Jury	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Stage	No errors.
App\Entity\Gestiform\Formations\Catalogue\Certification	No errors.
App\Entity\Gestiform\Formations\Catalogue\Theme\SousThemeTheme	No errors.
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme	No errors.
App\Entity\Gestiform\Formations\Catalogue\Editeur	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\BlocModule	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Chapitre	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModuleCompetence	No errors.
App\Entity\Gestiform\Formations\Financeur\Financeur	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale	No errors.
App\Entity\Gestiform\Formations\Formateur\FormateurModule	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVente	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteTheme	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra	No errors.
App\Entity\Common\Document	No errors.
App\Entity\Gestiform\Formations\Session\FormateurEvent	No errors.
App\Entity\Gestiform\Formations\Emargement\Emargement	No errors.
App\Entity\Gestiform\Formations\Session\Planning\FormulaireEvent	No errors.
App\Entity\Gestiform\Formations\Catalogue\Filiere	No errors.
App\Entity\Gestiform\Formations\Catalogue\Niveau	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\Bloc	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModaliteEvaluation	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteParcours	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\BlocCompetence	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\Livrable	No errors.
App\Entity\Common\GroupMessage	No errors.
App\Entity\Gestiform\Formations\Dossier\Diplome	No errors.
App\Entity\Gestiform\Admin\Entretien\CVdynamique	No errors.
App\Entity\Gestiform\Admin\Entretien\Entretien	No errors.
App\Entity\Gestiform\Formations\Dossier\DossierQuiz	No errors.
App\Entity\Gestiform\Formations\Emargement\EmargementJustificatif	No errors.
App\Entity\Gestiform\Formations\Reunion\ReunionDossier	No errors.
App\Entity\Gestiform\Formations\Reglement\Reglement	No errors.
App\Entity\Gestiform\Formations\Devis\Devis	No errors.
App\Entity\Gestiform\Formations\Financement\Financement	No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueComment	No errors.
App\Entity\Gestiform\Users\HistoriqueChat	No errors.
App\Entity\Gestiform\Formations\Dossier\Avertissement	No errors.
App\Entity\Gestiform\Formations\Facturation\Facturation	No errors.
App\Entity\Gestiform\Formations\Entreprise\FormateurEntreprise	No errors.
App\Entity\Gestiform\Formations\Entreprise\Contrat	No errors.
App\Entity\Gestiform\Formations\Session\Planning\LignePrestation	No errors.
App\Entity\Gestiform\Admin\ModelsDocument\Template	No errors.
App\Entity\Gestiform\Formations\Catalogue\Theme\SousTheme	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Prestation	No errors.

Symfony Profiler

GET https://dev.v4.gestiform.lmosoft.com/formations/session-parcours/11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping