Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.archive AS archive_4,
  t0.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 = '56';

"COMMIT"

"COMMIT";

SELECT
  m0_.id AS id_0,
  m0_.created_at AS created_at_1,
  m0_.updated_at AS updated_at_2,
  m0_.archive AS archive_3,
  m0_.code AS code_4,
  m0_.designation AS designation_5,
  m0_.valeur AS valeur_6,
  m0_.valeur2 AS valeur2_7,
  m0_.htmlvaleur AS htmlvaleur_8,
  m0_.valeur3 AS valeur3_9,
  m1_.id AS id_10,
  m1_.created_at AS created_at_11,
  m1_.updated_at AS updated_at_12,
  m1_.archive AS archive_13,
  m1_.module AS module_14,
  m1_.code AS code_15,
  m1_.designation AS designation_16,
  m0_.created_by_id AS created_by_id_17,
  m0_.updated_by_id AS updated_by_id_18,
  m0_.masterliste_id AS masterliste_id_19,
  m0_.api_gestiform_id AS api_gestiform_id_20,
  m1_.created_by_id AS created_by_id_21,
  m1_.updated_by_id AS updated_by_id_22,
  m1_.api_gestiform_id AS api_gestiform_id_23
FROM
  masterlistelg m0_
  INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id
WHERE
  m0_.code = ?
  AND m1_.module = ?
  AND m1_.code = ?
LIMIT
  1

SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = 'NBHRSFORMATION' AND m1_.module = 'NOYAU' AND m1_.code = 'PARAMETRAGE' LIMIT 1;

SELECT
  e0_.id AS id_0,
  e0_.created_at AS created_at_1,
  e0_.updated_at AS updated_at_2,
  e0_.archive AS archive_3,
  e0_.start AS start_4,
  e0_.end AS end_5,
  e0_.hours AS hours_6,
  e0_.sendconvocationstagiaire AS sendconvocationstagiaire_7,
  e0_.sendconvocationformateur AS sendconvocationformateur_8,
  e0_.temps_prise_en_compte AS temps_prise_en_compte_9,
  e0_.created_by_id AS created_by_id_10,
  e0_.updated_by_id AS updated_by_id_11,
  e0_.modalite_id AS modalite_id_12,
  e0_.parent_id AS parent_id_13,
  e0_.session_bloc_module_id AS session_bloc_module_id_14,
  e0_.accompagnement_id AS accompagnement_id_15,
  e0_.module_id AS module_id_16,
  e0_.jury_id AS jury_id_17,
  e0_.stage_id AS stage_id_18
FROM
  event e0_
  INNER JOIN planning_event p1_ ON e0_.id = p1_.event_id
  INNER JOIN planning p2_ ON p1_.planning_id = p2_.id
WHERE
  e0_.parent_id IS NULL
  AND p2_.id <> ?
  AND DATE_FORMAT(e0_.start, '%Y-%m-%d') = ?
  AND e0_.module_id IS NOT NULL

SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.archive AS archive_3, e0_.start AS start_4, e0_.end AS end_5, e0_.hours AS hours_6, e0_.sendconvocationstagiaire AS sendconvocationstagiaire_7, e0_.sendconvocationformateur AS sendconvocationformateur_8, e0_.temps_prise_en_compte AS temps_prise_en_compte_9, e0_.created_by_id AS created_by_id_10, e0_.updated_by_id AS updated_by_id_11, e0_.modalite_id AS modalite_id_12, e0_.parent_id AS parent_id_13, e0_.session_bloc_module_id AS session_bloc_module_id_14, e0_.accompagnement_id AS accompagnement_id_15, e0_.module_id AS module_id_16, e0_.jury_id AS jury_id_17, e0_.stage_id AS stage_id_18 FROM event e0_ INNER JOIN planning_event p1_ ON e0_.id = p1_.event_id INNER JOIN planning p2_ ON p1_.planning_id = p2_.id WHERE e0_.parent_id IS NULL AND p2_.id <> 56 AND DATE_FORMAT(e0_.start, '%Y-%m-%d') = '2026-08-17' AND e0_.module_id IS NOT NULL;

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

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;

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

DELETE FROM
  edit_locks
WHERE
  expires_at <= ?

DELETE FROM edit_locks WHERE expires_at <= '2026-06-22 13:05:20';

SELECT
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.archive AS archive_8,
  t0.email AS email_9,
  t0.password AS password_10,
  t0.plain_password AS plain_password_11,
  t0.roles AS roles_12,
  t0.enabled AS enabled_13,
  t0.status AS status_14,
  t0.rgpd AS rgpd_15,
  t0.api_token AS api_token_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.adresse_id AS adresse_id_19,
  t0.photo_id AS photo_id_20,
  t0.api_gestiform_id AS api_gestiform_id_21,
  t0.type,
  t1.rgpd_signed_at AS rgpd_signed_at_22,
  t1.personal_informations_id AS personal_informations_id_23,
  t1.rgpd_document_id AS rgpd_document_id_24,
  t1.responsable_hierarchique_id AS responsable_hierarchique_id_25,
  t2.mineur AS mineur_26,
  t2.dossier_actif_id AS dossier_actif_id_27,
  t2.representant_legal_id AS representant_legal_id_28,
  t3.prefecture AS prefecture_29,
  t3.numero_activite AS numero_activite_30,
  t3.numero_activite2 AS numero_activite2_31,
  t3.liste_competences AS liste_competences_32,
  t3.debut_habilitation AS debut_habilitation_33,
  t3.fin_habilitation AS fin_habilitation_34,
  t3.jury_uniquement AS jury_uniquement_35,
  t3.mission_proposee AS mission_proposee_36,
  t3.statut_id AS statut_id_37,
  t4.personal_informations_id AS personal_informations_id_38,
  t4.signature_file_id AS signature_file_id_39
FROM
  user t0
  LEFT JOIN employe t1 ON t0.id = t1.id
  LEFT JOIN apprenant t2 ON t0.id = t2.id
  LEFT JOIN formateur t3 ON t0.id = t3.id
  LEFT JOIN personne t4 ON t0.id = t4.id
WHERE
  t0.id = ?

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

SELECT
  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 > ?
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:05:20' ORDER BY e0_.updated_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.archive AS archive_4,
  t0.code AS code_5,
  t0.designation AS designation_6,
  t0.valeur AS valeur_7,
  t0.valeur2 AS valeur2_8,
  t0.htmlvaleur AS htmlvaleur_9,
  t0.valeur3 AS valeur3_10,
  t0.created_by_id AS created_by_id_11,
  t0.updated_by_id AS updated_by_id_12,
  t0.masterliste_id AS masterliste_id_13,
  t0.api_gestiform_id AS api_gestiform_id_14
FROM
  masterlistelg t0
WHERE
  t0.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;

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

UPDATE
  edit_locks
SET
  expires_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE edit_locks SET expires_at = '2026-06-22 13:10:20', updated_at = '2026-06-22 13:05:20' WHERE id = 6369;

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 = ?
ORDER BY
  e0_.updated_at DESC
LIMIT
  1