Symfony Profiler

Query Metrics

52 Database Queries

16 Different statements

9.39 ms Query time

0 Invalid entities

94 Managed entities

Queries


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 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 = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
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 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 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 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 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 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 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 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 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 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 = ?
DELETE FROM edit_locks WHERE expires_at <= ?
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 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 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 = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
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 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 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 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 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 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 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 = ?
DELETE FROM edit_locks WHERE expires_at <= ?
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
"START TRANSACTION"
INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
"COMMIT"
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_.type AS type_5, s0_.session_dokelio AS session_dokelio_6, s0_.dokelio_parcours AS dokelio_parcours_7, s0_.simul_nb_apprenants AS simul_nb_apprenants_8, s0_.numero_session AS numero_session_9, s0_.duree AS duree_10, s0_.date_debut AS date_debut_11, s0_.date_debut_affichage AS date_debut_affichage_12, s0_.date_fin_affichage AS date_fin_affichage_13, s0_.site_partenaire AS site_partenaire_14, s0_.guaranteed AS guaranteed_15, s0_.permenant AS permenant_16, s0_.publie_site AS publie_site_17, s0_.dates_larges AS dates_larges_18, s0_.lieu AS lieu_19, s0_.modalite_par_defaut AS modalite_par_defaut_20, s0_.created_by_id AS created_by_id_21, s0_.updated_by_id AS updated_by_id_22, s0_.salle_defaut_id AS salle_defaut_id_23, s0_.parcours_id AS parcours_id_24, s0_.adresse_partenaire_id AS adresse_partenaire_id_25, s0_.statut_id AS statut_id_26, s0_.referent_pedagogique_id AS referent_pedagogique_id_27, s0_.referent_coach_id AS referent_coach_id_28, s0_.referent_administratif_id AS referent_administratif_id_29, s0_.referent_handicap_id AS referent_handicap_id_30, s0_.planning_id AS planning_id_31, s0_.site_id AS site_id_32, s0_.api_gestiform_id AS api_gestiform_id_33 FROM session s0_ LEFT JOIN planning p1_ ON s0_.planning_id = p1_.id WHERE (s0_.date_debut BETWEEN ? AND ?) OR (p1_.end BETWEEN ? AND ?)
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 d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id
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 (d0_.created_at BETWEEN ? AND ?) AND 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 = ?
SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id
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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ?
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 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 d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id
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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ?
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 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 d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id
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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ?
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 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 d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id
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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ?
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 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 = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1

#▲	Time	Info
1	0.29 ms	SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.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;
2	0.31 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"DOSSIER" "ROLE" "RESOURCE"`] 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 = 'DOSSIER' AND m1_.module = 'ROLE' AND m1_.code = 'RESOURCE' LIMIT 1;
3	0.19 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_SUPER_ADMIN" "ROLE" "USER"`] 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 = 'ROLE_SUPER_ADMIN' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
4	0.16 ms	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 5956`] 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 = 5956;
5	0.17 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ? Parameters: [`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;
6	0.16 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_ADMIN" "ROLE" "USER"`] 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 = 'ROLE_ADMIN' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
7	0.11 ms	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: [`5980 5956`] 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 = 5980 AND r0_.resource_id = 5956;
8	0.09 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ? Parameters: [`5976`] 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 = 5976;
9	0.10 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_USER" "ROLE" "USER"`] 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 = 'ROLE_USER' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
10	0.09 ms	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: [`6471 5956`] 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 = 6471 AND r0_.resource_id = 5956;
11	0.09 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_MEMBRE" "ROLE" "USER"`] 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 = 'ROLE_MEMBRE' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
12	0.08 ms	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: [`5952 5956`] 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 = 5952 AND r0_.resource_id = 5956;
13	0.08 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ? Parameters: [`5977`] 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 = 5977;
14	0.35 ms	DELETE FROM edit_locks WHERE expires_at <= ? Parameters: [`"2026-06-10 17:53:52"`] View formatted query View runnable query Explain query DELETE FROM edit_locks WHERE expires_at <= ? DELETE FROM edit_locks WHERE expires_at <= '2026-06-10 17:53:52';
15	0.38 ms	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 Parameters: [`"DOSSIER" "2026-06-10 17:53:52"`] 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 > ? 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 = 'DOSSIER' AND e0_.expires_at > '2026-06-10 17:53:52' ORDER BY e0_.updated_at DESC LIMIT 1;
16	0.13 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE 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;
17	0.11 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"DOSSIER" "ROLE" "RESOURCE"`] 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 = 'DOSSIER' AND m1_.module = 'ROLE' AND m1_.code = 'RESOURCE' LIMIT 1;
18	0.11 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_SUPER_ADMIN" "ROLE" "USER"`] 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 = 'ROLE_SUPER_ADMIN' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
19	0.08 ms	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 5956`] 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 = 5956;
20	0.09 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_ADMIN" "ROLE" "USER"`] 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 = 'ROLE_ADMIN' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
21	0.11 ms	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: [`5980 5956`] 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 = 5980 AND r0_.resource_id = 5956;
22	0.08 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_USER" "ROLE" "USER"`] 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 = 'ROLE_USER' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
23	0.08 ms	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: [`6471 5956`] 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 = 6471 AND r0_.resource_id = 5956;
24	0.08 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"ROLE_MEMBRE" "ROLE" "USER"`] 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 = 'ROLE_MEMBRE' AND m1_.module = 'ROLE' AND m1_.code = 'USER' LIMIT 1;
25	0.07 ms	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: [`5952 5956`] 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 = 5952 AND r0_.resource_id = 5956;
26	0.13 ms	DELETE FROM edit_locks WHERE expires_at <= ? Parameters: [`"2026-06-10 17:53:52"`] View formatted query View runnable query Explain query DELETE FROM edit_locks WHERE expires_at <= ? DELETE FROM edit_locks WHERE expires_at <= '2026-06-10 17:53:52';
27	0.20 ms	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 Parameters: [`"DOSSIER" "2026-06-10 17:53:52" "/formations/statistics/session-stats"`] 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 = ? 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 = 'DOSSIER' AND e0_.expires_at > '2026-06-10 17:53:52' AND e0_.resource_url = '/formations/statistics/session-stats' ORDER BY e0_.updated_at DESC LIMIT 1;
28	0.09 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
29	0.25 ms	INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"DOSSIER" "/formations/statistics/session-stats" null "2026-06-10 17:53:52" "2026-06-10 17:58:52" "2026-06-10 17:53:52" 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 ('DOSSIER', '/formations/statistics/session-stats', NULL, '2026-06-10 17:53:52', '2026-06-10 17:58:52', '2026-06-10 17:53:52', 1);
30	2.15 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
31	0.39 ms	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_.type AS type_5, s0_.session_dokelio AS session_dokelio_6, s0_.dokelio_parcours AS dokelio_parcours_7, s0_.simul_nb_apprenants AS simul_nb_apprenants_8, s0_.numero_session AS numero_session_9, s0_.duree AS duree_10, s0_.date_debut AS date_debut_11, s0_.date_debut_affichage AS date_debut_affichage_12, s0_.date_fin_affichage AS date_fin_affichage_13, s0_.site_partenaire AS site_partenaire_14, s0_.guaranteed AS guaranteed_15, s0_.permenant AS permenant_16, s0_.publie_site AS publie_site_17, s0_.dates_larges AS dates_larges_18, s0_.lieu AS lieu_19, s0_.modalite_par_defaut AS modalite_par_defaut_20, s0_.created_by_id AS created_by_id_21, s0_.updated_by_id AS updated_by_id_22, s0_.salle_defaut_id AS salle_defaut_id_23, s0_.parcours_id AS parcours_id_24, s0_.adresse_partenaire_id AS adresse_partenaire_id_25, s0_.statut_id AS statut_id_26, s0_.referent_pedagogique_id AS referent_pedagogique_id_27, s0_.referent_coach_id AS referent_coach_id_28, s0_.referent_administratif_id AS referent_administratif_id_29, s0_.referent_handicap_id AS referent_handicap_id_30, s0_.planning_id AS planning_id_31, s0_.site_id AS site_id_32, s0_.api_gestiform_id AS api_gestiform_id_33 FROM session s0_ LEFT JOIN planning p1_ ON s0_.planning_id = p1_.id WHERE (s0_.date_debut BETWEEN ? AND ?) OR (p1_.end BETWEEN ? AND ?) Parameters: [`"2026-01-01 00:00:00" "2026-12-31 23:59:59" "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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_.type AS type_5, s0_.session_dokelio AS session_dokelio_6, s0_.dokelio_parcours AS dokelio_parcours_7, s0_.simul_nb_apprenants AS simul_nb_apprenants_8, s0_.numero_session AS numero_session_9, s0_.duree AS duree_10, s0_.date_debut AS date_debut_11, s0_.date_debut_affichage AS date_debut_affichage_12, s0_.date_fin_affichage AS date_fin_affichage_13, s0_.site_partenaire AS site_partenaire_14, s0_.guaranteed AS guaranteed_15, s0_.permenant AS permenant_16, s0_.publie_site AS publie_site_17, s0_.dates_larges AS dates_larges_18, s0_.lieu AS lieu_19, s0_.modalite_par_defaut AS modalite_par_defaut_20, s0_.created_by_id AS created_by_id_21, s0_.updated_by_id AS updated_by_id_22, s0_.salle_defaut_id AS salle_defaut_id_23, s0_.parcours_id AS parcours_id_24, s0_.adresse_partenaire_id AS adresse_partenaire_id_25, s0_.statut_id AS statut_id_26, s0_.referent_pedagogique_id AS referent_pedagogique_id_27, s0_.referent_coach_id AS referent_coach_id_28, s0_.referent_administratif_id AS referent_administratif_id_29, s0_.referent_handicap_id AS referent_handicap_id_30, s0_.planning_id AS planning_id_31, s0_.site_id AS site_id_32, s0_.api_gestiform_id AS api_gestiform_id_33 FROM session s0_ LEFT JOIN planning p1_ ON s0_.planning_id = p1_.id WHERE ( s0_.date_debut BETWEEN ? AND ? ) OR ( p1_.end BETWEEN ? AND ? ) 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_.type AS type_5, s0_.session_dokelio AS session_dokelio_6, s0_.dokelio_parcours AS dokelio_parcours_7, s0_.simul_nb_apprenants AS simul_nb_apprenants_8, s0_.numero_session AS numero_session_9, s0_.duree AS duree_10, s0_.date_debut AS date_debut_11, s0_.date_debut_affichage AS date_debut_affichage_12, s0_.date_fin_affichage AS date_fin_affichage_13, s0_.site_partenaire AS site_partenaire_14, s0_.guaranteed AS guaranteed_15, s0_.permenant AS permenant_16, s0_.publie_site AS publie_site_17, s0_.dates_larges AS dates_larges_18, s0_.lieu AS lieu_19, s0_.modalite_par_defaut AS modalite_par_defaut_20, s0_.created_by_id AS created_by_id_21, s0_.updated_by_id AS updated_by_id_22, s0_.salle_defaut_id AS salle_defaut_id_23, s0_.parcours_id AS parcours_id_24, s0_.adresse_partenaire_id AS adresse_partenaire_id_25, s0_.statut_id AS statut_id_26, s0_.referent_pedagogique_id AS referent_pedagogique_id_27, s0_.referent_coach_id AS referent_coach_id_28, s0_.referent_administratif_id AS referent_administratif_id_29, s0_.referent_handicap_id AS referent_handicap_id_30, s0_.planning_id AS planning_id_31, s0_.site_id AS site_id_32, s0_.api_gestiform_id AS api_gestiform_id_33 FROM session s0_ LEFT JOIN planning p1_ ON s0_.planning_id = p1_.id WHERE (s0_.date_debut BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') OR (p1_.end BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59');
32	0.30 ms	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';
33	0.14 ms	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id Parameters: [`5 "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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 = ? AND ( d0_.created_at BETWEEN ? AND ? ) 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 = 5 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') GROUP BY d0_.type_actif_id;
34	0.10 ms	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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ? Parameters: [`5 "2026-01-01 00:00:00" "2026-12-31 23:59:59" "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 ( d0_.created_at BETWEEN ? AND ? ) 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 = 5 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND m1_.code = 'alumni';
35	0.09 ms	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';
36	0.12 ms	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id Parameters: [`7 "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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 = ? AND ( d0_.created_at BETWEEN ? AND ? ) 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 = 7 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') GROUP BY d0_.type_actif_id;
37	0.08 ms	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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ? Parameters: [`7 "2026-01-01 00:00:00" "2026-12-31 23:59:59" "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 ( d0_.created_at BETWEEN ? AND ? ) 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 = 7 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND m1_.code = 'alumni';
38	0.20 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.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: [`7`] 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 = 7;
39	0.14 ms	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';
40	0.10 ms	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id Parameters: [`9 "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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 = ? AND ( d0_.created_at BETWEEN ? AND ? ) 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 = 9 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') GROUP BY d0_.type_actif_id;
41	0.09 ms	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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ? Parameters: [`9 "2026-01-01 00:00:00" "2026-12-31 23:59:59" "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 ( d0_.created_at BETWEEN ? AND ? ) 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 = 9 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND m1_.code = 'alumni';
42	0.15 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.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: [`31`] 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 = 31;
43	0.09 ms	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';
44	0.08 ms	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id Parameters: [`11 "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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 = ? AND ( d0_.created_at BETWEEN ? AND ? ) 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 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') GROUP BY d0_.type_actif_id;
45	0.08 ms	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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ? Parameters: [`11 "2026-01-01 00:00:00" "2026-12-31 23:59:59" "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 ( d0_.created_at BETWEEN ? AND ? ) 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 (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND m1_.code = 'alumni';
46	0.13 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.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;
47	0.08 ms	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';
48	0.08 ms	SELECT d0_.type_actif_id AS sclr_0, COUNT(d0_.id) AS sclr_1 FROM dossier d0_ WHERE d0_.session_id = ? AND (d0_.created_at BETWEEN ? AND ?) GROUP BY d0_.type_actif_id Parameters: [`15 "2026-01-01 00:00:00" "2026-12-31 23:59:59"`] 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 = ? AND ( d0_.created_at BETWEEN ? AND ? ) 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 = 15 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') GROUP BY d0_.type_actif_id;
49	0.08 ms	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 (d0_.created_at BETWEEN ? AND ?) AND m1_.code = ? Parameters: [`15 "2026-01-01 00:00:00" "2026-12-31 23:59:59" "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 ( d0_.created_at BETWEEN ? AND ? ) 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 = 15 AND (d0_.created_at BETWEEN '2026-01-01 00:00:00' AND '2026-12-31 23:59:59') AND m1_.code = 'alumni';
50	0.14 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.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: [`6`] 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 = 6;
51	0.20 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"NBHRSFORMATION" "NOYAU" "PARAMETRAGE"`] 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;
52	0.15 ms	SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1 Parameters: [`"gestiform_formations_statistics_session_stats" "TRIGGER" "METHOD"`] 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 = 'gestiform_formations_statistics_session_stats' AND m1_.module = 'TRIGGER' AND m1_.code = 'METHOD' LIMIT 1;

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	47
App\Entity\Gestiform\Admin\Role	9
App\Entity\Common\Upload	6
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	6
App\Entity\Gestiform\Formations\Session\Session	5
App\Entity\Gestiform\Formations\Session\Planning\Planning	5
App\Entity\Gestiform\Admin\MasterListe\Masterliste	4
App\Entity\Gestiform\Formations\Catalogue\Niveau	4
App\Entity\Gestiform\Admin\ApiGestiform	2
App\Entity\Gestiform\Admin\EditLock	2
App\Entity\Gestiform\Formations\Catalogue\Filiere	2
App\Entity\Gestiform\Users\User	1
App\Entity\Gestiform\Formations\Dossier\PersonalInformations	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\Admin\Role	No errors.
App\Entity\Gestiform\Admin\EditLock	No errors.
App\Entity\Gestiform\Formations\Session\Session	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Planning	No errors.
App\Entity\Gestiform\Admin\Salle	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	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\Formations\Catalogue\Theme\Theme	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\Common\Document	No errors.

Symfony Profiler

GET https://dev.v4.gestiform.lmosoft.com/formations/statistics/session-stats?dateDebut=2026-01-01&dateFin=2026-12-31

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping