Symfony Profiler

Query Metrics

51 Database Queries

24 Different statements

32.78 ms Query time

11 Invalid entities

140 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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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 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 t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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 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 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 t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.api_gestiform_id = ? ORDER BY t0.date_debut ASC
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.archive AS archive_3, p0_.intitule AS intitule_4, p0_.intitule_officiel AS intitule_officiel_5, p0_.code AS code_6, p0_.code_diplome AS code_diplome_7, p0_.sigle AS sigle_8, p0_.date_debut_valide AS date_debut_valide_9, p0_.date_fin_valide AS date_fin_valide_10, p0_.date_publication_officiel AS date_publication_officiel_11, p0_.plus AS plus_12, p0_.redirection AS redirection_13, p0_.publication AS publication_14, p0_.publication_api AS publication_api_15, p0_.taux_obtention AS taux_obtention_16, p0_.taux_abandon AS taux_abandon_17, p0_.taux_satisfaction AS taux_satisfaction_18, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_19, p0_.taux_employabilite AS taux_employabilite_20, p0_.prerequis AS prerequis_21, p0_.salaire_moyen AS salaire_moyen_22, p0_.livrable AS livrable_23, p0_.alt_banniere AS alt_banniere_24, p0_.alt_vignette AS alt_vignette_25, p0_.tarif_jury AS tarif_jury_26, p0_.tarif_jury2 AS tarif_jury2_27, p0_.cpf AS cpf_28, p0_.code_cpf AS code_cpf_29, p0_.code_rncp_rs AS code_rncp_rs_30, p0_.code_cpf_salarie AS code_cpf_salarie_31, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_32, p0_.code_nsf AS code_nsf_33, p0_.duree AS duree_34, p0_.duree_modulaire AS duree_modulaire_35, p0_.rncp AS rncp_36, p0_.duree_accompagnement AS duree_accompagnement_37, p0_.duree_stage AS duree_stage_38, p0_.duree_center AS duree_center_39, p0_.duree_elearning AS duree_elearning_40, p0_.stage_obligatoire AS stage_obligatoire_41, p0_.formation_permanente AS formation_permanente_42, p0_.sanction_resume AS sanction_resume_43, p0_.sanction_long AS sanction_long_44, p0_.metier AS metier_45, p0_.accessibilite_handicap AS accessibilite_handicap_46, p0_.modalites_delais_acces AS modalites_delais_acces_47, p0_.modaliteevaluationinitial AS modaliteevaluationinitial_48, p0_.modaliteevaluationfinal AS modaliteevaluationfinal_49, p0_.text AS text_50, p0_.objectif AS objectif_51, p0_.debouche AS debouche_52, p0_.condition_admission AS condition_admission_53, p0_.public AS public_54, p0_.detail_examen AS detail_examen_55, p0_.frais_pedagogique AS frais_pedagogique_56, p0_.methodes_mobilisees AS methodes_mobilisees_57, p0_.seo_titre AS seo_titre_58, p0_.seo_description AS seo_description_59, p0_.rythme AS rythme_60, p0_.identifiant_dokelio AS identifiant_dokelio_61, p0_.dokelio_parcours AS dokelio_parcours_62, p0_.contenu_apres AS contenu_apres_63, p0_.contenu_avant AS contenu_avant_64, p0_.path AS path_65, p0_.items AS items_66, p0_.is_default AS is_default_67, p0_.created_by_id AS created_by_id_68, p0_.updated_by_id AS updated_by_id_69, p0_.theme_id AS theme_id_70, p0_.parent_id AS parent_id_71, p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_72, p0_.nsf_id AS nsf_id_73, p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_74, p0_.filiere_id AS filiere_id_75, p0_.niveau_entree_id AS niveau_entree_id_76, p0_.niveau_sortie_id AS niveau_sortie_id_77, p0_.niveau_technique_id AS niveau_technique_id_78, p0_.qualifiant_id AS qualifiant_id_79, p0_.type_formation_id AS type_formation_id_80, p0_.autorite_delivrance_id AS autorite_delivrance_id_81, p0_.mode_formation_id AS mode_formation_id_82, p0_.formateur_id AS formateur_id_83, p0_.banniere_id AS banniere_id_84, p0_.vignette_id AS vignette_id_85 FROM parcours p0_ WHERE p0_.parent_id IS NULL AND p0_.archive = 0
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_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.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = ?
SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.prerequis AS prerequis_27, t0.objectif AS objectif_28, t0.plus AS plus_29, t0.public AS public_30, t0.commentaire AS commentaire_31, t0.certification_commentaire AS certification_commentaire_32, t0.seo_titre AS seo_titre_33, t0.seo_description AS seo_description_34, t0.info_pratique AS info_pratique_35, t0.accessibilite_handicap AS accessibilite_handicap_36, t0.alt_vignette AS alt_vignette_37, t0.description AS description_38, t0.modalites_delais_acces AS modalites_delais_acces_39, t0.alt_banniere AS alt_banniere_40, t0.identifiant_dokelio AS identifiant_dokelio_41, t0.publication AS publication_42, t0.contenu_apres AS contenu_apres_43, t0.contenu_avant AS contenu_avant_44, t0.nbrsessioninter AS nbrsessioninter_45, t0.nbrsessionintra AS nbrsessionintra_46, t0.modes_formation AS modes_formation_47, t0.created_by_id AS created_by_id_48, t0.updated_by_id AS updated_by_id_49, t0.mode_formation_id AS mode_formation_id_50, t0.sous_theme_theme_id AS sous_theme_theme_id_51, t0.theme_tarif_id AS theme_tarif_id_52, t0.niveaumateriel_id AS niveaumateriel_id_53, t0.niveautechnique_id AS niveautechnique_id_54, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_55, t0.banniere_id AS banniere_id_56, t0.vignette_id AS vignette_id_57, t0.api_gestiform_id AS api_gestiform_id_58, t0.type, t1.date_inscription AS date_inscription_59, t1.programme AS programme_60, t1.certification AS certification_61, t1.tarif_vente AS tarif_vente_62, t1.editeur_id AS editeur_id_63, t1.theme_id AS theme_id_64 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_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.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? AND t0.api_gestiform_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ?
SELECT 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 t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.intitule = ? LIMIT 1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ?

#▲	Time	Info
1	0.75 ms	SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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.35 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;
3	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: [`"CALENDRIER" "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 = 'CALENDRIER' AND m1_.module = 'ROLE' AND m1_.code = 'RESOURCE' LIMIT 1;
4	0.22 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;
5	0.19 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5979 AND r0_.resource_id = 5958;
6	0.23 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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;
7	0.22 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;
8	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: [`5980 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5980 AND r0_.resource_id = 5958;
9	0.18 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ? Parameters: [`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;
10	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: [`"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;
11	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: [`6471 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 6471 AND r0_.resource_id = 5958;
12	0.23 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;
13	0.19 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5952 AND r0_.resource_id = 5958;
14	0.16 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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;
15	6.84 ms	DELETE FROM edit_locks WHERE expires_at <= ? Parameters: [`"2025-10-29 20:57:53"`] View formatted query View runnable query Explain query DELETE FROM edit_locks WHERE expires_at <= ? DELETE FROM edit_locks WHERE expires_at <= '2025-10-29 20:57:53';
16	2.74 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: [`"CALENDRIER" "2025-10-29 20:57:53"`] 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 = 'CALENDRIER' AND e0_.expires_at > '2025-10-29 20:57:53' ORDER BY e0_.updated_at DESC LIMIT 1;
17	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 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;
18	0.27 ms	SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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: [`28`] 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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17, t0.adresse_id AS adresse_id_18, t0.photo_id AS photo_id_19, t0.api_gestiform_id AS api_gestiform_id_20, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_21, t1.personal_informations_id AS personal_informations_id_22, t1.rgpd_document_id AS rgpd_document_id_23, t1.responsable_hierarchique_id AS responsable_hierarchique_id_24, t2.mineur AS mineur_25, t2.dossier_actif_id AS dossier_actif_id_26, t2.representant_legal_id AS representant_legal_id_27, t3.prefecture AS prefecture_28, t3.numero_activite AS numero_activite_29, t3.numero_activite2 AS numero_activite2_30, t3.liste_competences AS liste_competences_31, t3.debut_habilitation AS debut_habilitation_32, t3.fin_habilitation AS fin_habilitation_33, t3.jury_uniquement AS jury_uniquement_34, t3.mission_proposee AS mission_proposee_35, t3.statut_id AS statut_id_36, t4.personal_informations_id AS personal_informations_id_37, t4.signature_file_id AS signature_file_id_38 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 = 28;
19	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: [`"CALENDRIER" "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 = 'CALENDRIER' AND m1_.module = 'ROLE' AND m1_.code = 'RESOURCE' LIMIT 1;
20	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_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;
21	0.15 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5979 AND r0_.resource_id = 5958;
22	0.17 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;
23	0.15 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5980 AND r0_.resource_id = 5958;
24	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_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;
25	0.15 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 6471 AND r0_.resource_id = 5958;
26	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: [`"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;
27	0.14 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 5958`] View formatted query View runnable query Explain query SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ? SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = 5952 AND r0_.resource_id = 5958;
28	4.12 ms	DELETE FROM edit_locks WHERE expires_at <= ? Parameters: [`"2025-10-29 20:57:53"`] View formatted query View runnable query Explain query DELETE FROM edit_locks WHERE expires_at <= ? DELETE FROM edit_locks WHERE expires_at <= '2025-10-29 20:57:53';
29	0.49 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: [`"CALENDRIER" "2025-10-29 20:57:53" "/formations/session-parcours"`] 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 = 'CALENDRIER' AND e0_.expires_at > '2025-10-29 20:57:53' AND e0_.resource_url = '/formations/session-parcours' ORDER BY e0_.updated_at DESC LIMIT 1;
30	0.20 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
31	0.54 ms	INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES (?, ?, ?, ?, ?, ?, ?) Parameters: [`"CALENDRIER" "/formations/session-parcours" null "2025-10-29 20:57:53" "2025-10-29 21:02:53" "2025-10-29 20:57:53" 1`] View formatted query View runnable query Explain query INSERT INTO edit_locks ( resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id ) VALUES (?, ?, ?, ?, ?, ?, ?) INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES ('CALENDRIER', '/formations/session-parcours', NULL, '2025-10-29 20:57:53', '2025-10-29 21:02:53', '2025-10-29 20:57:53', 1);
32	4.06 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
33	0.35 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: [`"STATUT" "SESSIONPARCOURS"`] 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 = 'STATUT' AND m1_.module = 'SESSIONPARCOURS' ORDER BY m0_.code ASC;
34	0.36 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.api_gestiform_id = ? ORDER BY t0.date_debut ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.api_gestiform_id = ? ORDER BY t0.date_debut ASC SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.api_gestiform_id = 1 ORDER BY t0.date_debut ASC;
35	0.49 ms	SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.archive AS archive_3, p0_.intitule AS intitule_4, p0_.intitule_officiel AS intitule_officiel_5, p0_.code AS code_6, p0_.code_diplome AS code_diplome_7, p0_.sigle AS sigle_8, p0_.date_debut_valide AS date_debut_valide_9, p0_.date_fin_valide AS date_fin_valide_10, p0_.date_publication_officiel AS date_publication_officiel_11, p0_.plus AS plus_12, p0_.redirection AS redirection_13, p0_.publication AS publication_14, p0_.publication_api AS publication_api_15, p0_.taux_obtention AS taux_obtention_16, p0_.taux_abandon AS taux_abandon_17, p0_.taux_satisfaction AS taux_satisfaction_18, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_19, p0_.taux_employabilite AS taux_employabilite_20, p0_.prerequis AS prerequis_21, p0_.salaire_moyen AS salaire_moyen_22, p0_.livrable AS livrable_23, p0_.alt_banniere AS alt_banniere_24, p0_.alt_vignette AS alt_vignette_25, p0_.tarif_jury AS tarif_jury_26, p0_.tarif_jury2 AS tarif_jury2_27, p0_.cpf AS cpf_28, p0_.code_cpf AS code_cpf_29, p0_.code_rncp_rs AS code_rncp_rs_30, p0_.code_cpf_salarie AS code_cpf_salarie_31, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_32, p0_.code_nsf AS code_nsf_33, p0_.duree AS duree_34, p0_.duree_modulaire AS duree_modulaire_35, p0_.rncp AS rncp_36, p0_.duree_accompagnement AS duree_accompagnement_37, p0_.duree_stage AS duree_stage_38, p0_.duree_center AS duree_center_39, p0_.duree_elearning AS duree_elearning_40, p0_.stage_obligatoire AS stage_obligatoire_41, p0_.formation_permanente AS formation_permanente_42, p0_.sanction_resume AS sanction_resume_43, p0_.sanction_long AS sanction_long_44, p0_.metier AS metier_45, p0_.accessibilite_handicap AS accessibilite_handicap_46, p0_.modalites_delais_acces AS modalites_delais_acces_47, p0_.modaliteevaluationinitial AS modaliteevaluationinitial_48, p0_.modaliteevaluationfinal AS modaliteevaluationfinal_49, p0_.text AS text_50, p0_.objectif AS objectif_51, p0_.debouche AS debouche_52, p0_.condition_admission AS condition_admission_53, p0_.public AS public_54, p0_.detail_examen AS detail_examen_55, p0_.frais_pedagogique AS frais_pedagogique_56, p0_.methodes_mobilisees AS methodes_mobilisees_57, p0_.seo_titre AS seo_titre_58, p0_.seo_description AS seo_description_59, p0_.rythme AS rythme_60, p0_.identifiant_dokelio AS identifiant_dokelio_61, p0_.dokelio_parcours AS dokelio_parcours_62, p0_.contenu_apres AS contenu_apres_63, p0_.contenu_avant AS contenu_avant_64, p0_.path AS path_65, p0_.items AS items_66, p0_.is_default AS is_default_67, p0_.created_by_id AS created_by_id_68, p0_.updated_by_id AS updated_by_id_69, p0_.theme_id AS theme_id_70, p0_.parent_id AS parent_id_71, p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_72, p0_.nsf_id AS nsf_id_73, p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_74, p0_.filiere_id AS filiere_id_75, p0_.niveau_entree_id AS niveau_entree_id_76, p0_.niveau_sortie_id AS niveau_sortie_id_77, p0_.niveau_technique_id AS niveau_technique_id_78, p0_.qualifiant_id AS qualifiant_id_79, p0_.type_formation_id AS type_formation_id_80, p0_.autorite_delivrance_id AS autorite_delivrance_id_81, p0_.mode_formation_id AS mode_formation_id_82, p0_.formateur_id AS formateur_id_83, p0_.banniere_id AS banniere_id_84, p0_.vignette_id AS vignette_id_85 FROM parcours p0_ WHERE p0_.parent_id IS NULL AND p0_.archive = 0 Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.archive AS archive_3, p0_.intitule AS intitule_4, p0_.intitule_officiel AS intitule_officiel_5, p0_.code AS code_6, p0_.code_diplome AS code_diplome_7, p0_.sigle AS sigle_8, p0_.date_debut_valide AS date_debut_valide_9, p0_.date_fin_valide AS date_fin_valide_10, p0_.date_publication_officiel AS date_publication_officiel_11, p0_.plus AS plus_12, p0_.redirection AS redirection_13, p0_.publication AS publication_14, p0_.publication_api AS publication_api_15, p0_.taux_obtention AS taux_obtention_16, p0_.taux_abandon AS taux_abandon_17, p0_.taux_satisfaction AS taux_satisfaction_18, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_19, p0_.taux_employabilite AS taux_employabilite_20, p0_.prerequis AS prerequis_21, p0_.salaire_moyen AS salaire_moyen_22, p0_.livrable AS livrable_23, p0_.alt_banniere AS alt_banniere_24, p0_.alt_vignette AS alt_vignette_25, p0_.tarif_jury AS tarif_jury_26, p0_.tarif_jury2 AS tarif_jury2_27, p0_.cpf AS cpf_28, p0_.code_cpf AS code_cpf_29, p0_.code_rncp_rs AS code_rncp_rs_30, p0_.code_cpf_salarie AS code_cpf_salarie_31, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_32, p0_.code_nsf AS code_nsf_33, p0_.duree AS duree_34, p0_.duree_modulaire AS duree_modulaire_35, p0_.rncp AS rncp_36, p0_.duree_accompagnement AS duree_accompagnement_37, p0_.duree_stage AS duree_stage_38, p0_.duree_center AS duree_center_39, p0_.duree_elearning AS duree_elearning_40, p0_.stage_obligatoire AS stage_obligatoire_41, p0_.formation_permanente AS formation_permanente_42, p0_.sanction_resume AS sanction_resume_43, p0_.sanction_long AS sanction_long_44, p0_.metier AS metier_45, p0_.accessibilite_handicap AS accessibilite_handicap_46, p0_.modalites_delais_acces AS modalites_delais_acces_47, p0_.modaliteevaluationinitial AS modaliteevaluationinitial_48, p0_.modaliteevaluationfinal AS modaliteevaluationfinal_49, p0_.text AS text_50, p0_.objectif AS objectif_51, p0_.debouche AS debouche_52, p0_.condition_admission AS condition_admission_53, p0_.public AS public_54, p0_.detail_examen AS detail_examen_55, p0_.frais_pedagogique AS frais_pedagogique_56, p0_.methodes_mobilisees AS methodes_mobilisees_57, p0_.seo_titre AS seo_titre_58, p0_.seo_description AS seo_description_59, p0_.rythme AS rythme_60, p0_.identifiant_dokelio AS identifiant_dokelio_61, p0_.dokelio_parcours AS dokelio_parcours_62, p0_.contenu_apres AS contenu_apres_63, p0_.contenu_avant AS contenu_avant_64, p0_.path AS path_65, p0_.items AS items_66, p0_.is_default AS is_default_67, p0_.created_by_id AS created_by_id_68, p0_.updated_by_id AS updated_by_id_69, p0_.theme_id AS theme_id_70, p0_.parent_id AS parent_id_71, p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_72, p0_.nsf_id AS nsf_id_73, p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_74, p0_.filiere_id AS filiere_id_75, p0_.niveau_entree_id AS niveau_entree_id_76, p0_.niveau_sortie_id AS niveau_sortie_id_77, p0_.niveau_technique_id AS niveau_technique_id_78, p0_.qualifiant_id AS qualifiant_id_79, p0_.type_formation_id AS type_formation_id_80, p0_.autorite_delivrance_id AS autorite_delivrance_id_81, p0_.mode_formation_id AS mode_formation_id_82, p0_.formateur_id AS formateur_id_83, p0_.banniere_id AS banniere_id_84, p0_.vignette_id AS vignette_id_85 FROM parcours p0_ WHERE p0_.parent_id IS NULL AND p0_.archive = 0 SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.archive AS archive_3, p0_.intitule AS intitule_4, p0_.intitule_officiel AS intitule_officiel_5, p0_.code AS code_6, p0_.code_diplome AS code_diplome_7, p0_.sigle AS sigle_8, p0_.date_debut_valide AS date_debut_valide_9, p0_.date_fin_valide AS date_fin_valide_10, p0_.date_publication_officiel AS date_publication_officiel_11, p0_.plus AS plus_12, p0_.redirection AS redirection_13, p0_.publication AS publication_14, p0_.publication_api AS publication_api_15, p0_.taux_obtention AS taux_obtention_16, p0_.taux_abandon AS taux_abandon_17, p0_.taux_satisfaction AS taux_satisfaction_18, p0_.taux_pour_suite_etude AS taux_pour_suite_etude_19, p0_.taux_employabilite AS taux_employabilite_20, p0_.prerequis AS prerequis_21, p0_.salaire_moyen AS salaire_moyen_22, p0_.livrable AS livrable_23, p0_.alt_banniere AS alt_banniere_24, p0_.alt_vignette AS alt_vignette_25, p0_.tarif_jury AS tarif_jury_26, p0_.tarif_jury2 AS tarif_jury2_27, p0_.cpf AS cpf_28, p0_.code_cpf AS code_cpf_29, p0_.code_rncp_rs AS code_rncp_rs_30, p0_.code_cpf_salarie AS code_cpf_salarie_31, p0_.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_32, p0_.code_nsf AS code_nsf_33, p0_.duree AS duree_34, p0_.duree_modulaire AS duree_modulaire_35, p0_.rncp AS rncp_36, p0_.duree_accompagnement AS duree_accompagnement_37, p0_.duree_stage AS duree_stage_38, p0_.duree_center AS duree_center_39, p0_.duree_elearning AS duree_elearning_40, p0_.stage_obligatoire AS stage_obligatoire_41, p0_.formation_permanente AS formation_permanente_42, p0_.sanction_resume AS sanction_resume_43, p0_.sanction_long AS sanction_long_44, p0_.metier AS metier_45, p0_.accessibilite_handicap AS accessibilite_handicap_46, p0_.modalites_delais_acces AS modalites_delais_acces_47, p0_.modaliteevaluationinitial AS modaliteevaluationinitial_48, p0_.modaliteevaluationfinal AS modaliteevaluationfinal_49, p0_.text AS text_50, p0_.objectif AS objectif_51, p0_.debouche AS debouche_52, p0_.condition_admission AS condition_admission_53, p0_.public AS public_54, p0_.detail_examen AS detail_examen_55, p0_.frais_pedagogique AS frais_pedagogique_56, p0_.methodes_mobilisees AS methodes_mobilisees_57, p0_.seo_titre AS seo_titre_58, p0_.seo_description AS seo_description_59, p0_.rythme AS rythme_60, p0_.identifiant_dokelio AS identifiant_dokelio_61, p0_.dokelio_parcours AS dokelio_parcours_62, p0_.contenu_apres AS contenu_apres_63, p0_.contenu_avant AS contenu_avant_64, p0_.path AS path_65, p0_.items AS items_66, p0_.is_default AS is_default_67, p0_.created_by_id AS created_by_id_68, p0_.updated_by_id AS updated_by_id_69, p0_.theme_id AS theme_id_70, p0_.parent_id AS parent_id_71, p0_.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_72, p0_.nsf_id AS nsf_id_73, p0_.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_74, p0_.filiere_id AS filiere_id_75, p0_.niveau_entree_id AS niveau_entree_id_76, p0_.niveau_sortie_id AS niveau_sortie_id_77, p0_.niveau_technique_id AS niveau_technique_id_78, p0_.qualifiant_id AS qualifiant_id_79, p0_.type_formation_id AS type_formation_id_80, p0_.autorite_delivrance_id AS autorite_delivrance_id_81, p0_.mode_formation_id AS mode_formation_id_82, p0_.formateur_id AS formateur_id_83, p0_.banniere_id AS banniere_id_84, p0_.vignette_id AS vignette_id_85 FROM parcours p0_ WHERE p0_.parent_id IS NULL AND p0_.archive = 0;
36	0.55 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = 2;
37	0.35 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.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = 2;
38	1.30 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = 12;
39	0.23 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.slug AS slug_6, t0.intitule AS intitule_7, t0.postulant AS postulant_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.societe_par_defaut_id AS societe_par_defaut_id_11 FROM api_gestiform t0 WHERE t0.id = 1;
40	0.31 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.total_days AS total_days_7, t0.stage_duration AS stage_duration_8, t0.accompaniment_duration AS accompaniment_duration_9, t0.center_duration AS center_duration_10, t0.jury_duration AS jury_duration_11, t0.strict_mode AS strict_mode_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14, t15.id AS id_16, t15.created_at AS created_at_17, t15.updated_at AS updated_at_18, t15.archive AS archive_19, t15.intitule AS intitule_20, t15.type AS type_21, t15.session_dokelio AS session_dokelio_22, t15.dokelio_parcours AS dokelio_parcours_23, t15.simul_nb_apprenants AS simul_nb_apprenants_24, t15.numero_session AS numero_session_25, t15.duree AS duree_26, t15.date_debut AS date_debut_27, t15.date_debut_affichage AS date_debut_affichage_28, t15.date_fin_affichage AS date_fin_affichage_29, t15.site_partenaire AS site_partenaire_30, t15.guaranteed AS guaranteed_31, t15.permenant AS permenant_32, t15.publie_site AS publie_site_33, t15.dates_larges AS dates_larges_34, t15.created_by_id AS created_by_id_35, t15.updated_by_id AS updated_by_id_36, t15.salle_defaut_id AS salle_defaut_id_37, t15.parcours_id AS parcours_id_38, t15.adresse_partenaire_id AS adresse_partenaire_id_39, t15.statut_id AS statut_id_40, t15.referent_pedagogique_id AS referent_pedagogique_id_41, t15.referent_coach_id AS referent_coach_id_42, t15.referent_administratif_id AS referent_administratif_id_43, t15.referent_handicap_id AS referent_handicap_id_44, t15.planning_id AS planning_id_45, t15.site_id AS site_id_46, t15.api_gestiform_id AS api_gestiform_id_47, t0.parent_id AS parent_id_48, t49.id AS id_50, t49.created_at AS created_at_51, t49.updated_at AS updated_at_52, t49.archive AS archive_53, t49.reference AS reference_54, t49.items_document AS items_document_55, t49.email_logs AS email_logs_56, t49.panier AS panier_57, t49.competences AS competences_58, t49.cart AS cart_59, t49.mode AS mode_60, t49.linkedin AS linkedin_61, t49.portfolio AS portfolio_62, t49.campus AS campus_63, t49.modalite_enseignement AS modalite_enseignement_64, t49.commentaire AS commentaire_65, t49.email_candidature AS email_candidature_66, t49.date_reunion AS date_reunion_67, t49.stop_date AS stop_date_68, t49.candidate_available AS candidate_available_69, t49.rncp AS rncp_70, t49.diplomant AS diplomant_71, t49.delegue_classe AS delegue_classe_72, t49.postulant_available AS postulant_available_73, t49.prospect_available AS prospect_available_74, t49.stagiaire_available AS stagiaire_available_75, t49.alumni_available AS alumni_available_76, t49.news_letter AS news_letter_77, t49.processed AS processed_78, t49.statut_declaration AS statut_declaration_79, t49.a_representant_legal AS a_representant_legal_80, t49.notification_paiement AS notification_paiement_81, t49.engagement_formation AS engagement_formation_82, t49.charte_formation AS charte_formation_83, t49.compte_zoom AS compte_zoom_84, t49.notified AS notified_85, t49.femme_eloigne AS femme_eloigne_86, t49.zrr AS zrr_87, t49.qpv AS qpv_88, t49.participation_reglee AS participation_reglee_89, t49.participation AS participation_90, t49.caution AS caution_91, t49.restea_regler AS restea_regler_92, t49.created_by_id AS created_by_id_93, t49.updated_by_id AS updated_by_id_94, t49.stop_proof_id AS stop_proof_id_95, t49.stop_cause_id AS stop_cause_id_96, t49.stop_type_id AS stop_type_id_97, t49.type_actif_id AS type_actif_id_98, t49.state_id AS state_id_99, t49.dispositif_id AS dispositif_id_100, t49.type_formation_id AS type_formation_id_101, t49.resultat_id AS resultat_id_102, t49.profil_id AS profil_id_103, t49.personal_informations_id AS personal_informations_id_104, t49.adresse_id AS adresse_id_105, t49.planning_id AS planning_id_106, t49.session_id AS session_id_107, t49.societe_id AS societe_id_108, t49.site_id AS site_id_109, t49.dossierannexes_id AS dossierannexes_id_110, t49.apprenant_id AS apprenant_id_111, t49.parcours_id AS parcours_id_112, t49.reorienter_id AS reorienter_id_113, t49.referent_pedagogique_id AS referent_pedagogique_id_114, t49.referent_commercial_id AS referent_commercial_id_115, t49.referent_coach_id AS referent_coach_id_116, t49.referent_administratif_id AS referent_administratif_id_117, t49.entreprise_id AS entreprise_id_118, t49.entreprise_contact_id AS entreprise_contact_id_119, t49.cv_id AS cv_id_120, t49.platforme_id AS platforme_id_121, t49.emergency_contact_id AS emergency_contact_id_122, t49.legal_representative_id AS legal_representative_id_123, t49.etablissement_id AS etablissement_id_124 FROM planning t0 LEFT JOIN session t15 ON t15.planning_id = t0.id LEFT JOIN dossier t49 ON t49.planning_id = t0.id WHERE t0.id = 1;
41	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.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.sendconvocation AS sendconvocation_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7, t0.event_id AS event_id_8, t0.planning_id AS planning_id_9, t0.salle_event_id AS salle_event_id_10, t11.id AS id_12, t11.created_at AS created_at_13, t11.updated_at AS updated_at_14, t11.archive AS archive_15, t11.approuver AS approuver_16, t11.note AS note_17, t11.commentaire AS commentaire_18, t11.created_by_id AS created_by_id_19, t11.updated_by_id AS updated_by_id_20, t11.formateur_id AS formateur_id_21, t11.planning_event_id AS planning_event_id_22, t11.categorie_id AS categorie_id_23, t11.type_id AS type_id_24 FROM planning_event t0 LEFT JOIN apprenant_livrable t11 ON t11.planning_event_id = t0.id WHERE t0.planning_id = 1;
42	0.35 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.start AS start_5, t0.end AS end_6, t0.hours AS hours_7, t0.sendconvocationstagiaire AS sendconvocationstagiaire_8, t0.sendconvocationformateur AS sendconvocationformateur_9, t0.temps_prise_en_compte AS temps_prise_en_compte_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.modalite_id AS modalite_id_13, t0.parent_id AS parent_id_14, t0.session_bloc_module_id AS session_bloc_module_id_15, t0.accompagnement_id AS accompagnement_id_16, t0.module_id AS module_id_17, t0.jury_id AS jury_id_18, t0.stage_id AS stage_id_19 FROM event t0 WHERE t0.id = 1;
43	1.35 ms	SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.prerequis AS prerequis_27, t0.objectif AS objectif_28, t0.plus AS plus_29, t0.public AS public_30, t0.commentaire AS commentaire_31, t0.certification_commentaire AS certification_commentaire_32, t0.seo_titre AS seo_titre_33, t0.seo_description AS seo_description_34, t0.info_pratique AS info_pratique_35, t0.accessibilite_handicap AS accessibilite_handicap_36, t0.alt_vignette AS alt_vignette_37, t0.description AS description_38, t0.modalites_delais_acces AS modalites_delais_acces_39, t0.alt_banniere AS alt_banniere_40, t0.identifiant_dokelio AS identifiant_dokelio_41, t0.publication AS publication_42, t0.contenu_apres AS contenu_apres_43, t0.contenu_avant AS contenu_avant_44, t0.nbrsessioninter AS nbrsessioninter_45, t0.nbrsessionintra AS nbrsessionintra_46, t0.modes_formation AS modes_formation_47, t0.created_by_id AS created_by_id_48, t0.updated_by_id AS updated_by_id_49, t0.mode_formation_id AS mode_formation_id_50, t0.sous_theme_theme_id AS sous_theme_theme_id_51, t0.theme_tarif_id AS theme_tarif_id_52, t0.niveaumateriel_id AS niveaumateriel_id_53, t0.niveautechnique_id AS niveautechnique_id_54, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_55, t0.banniere_id AS banniere_id_56, t0.vignette_id AS vignette_id_57, t0.api_gestiform_id AS api_gestiform_id_58, t0.type, t1.date_inscription AS date_inscription_59, t1.programme AS programme_60, t1.certification AS certification_61, t1.tarif_vente AS tarif_vente_62, t1.editeur_id AS editeur_id_63, t1.theme_id AS theme_id_64 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.prerequis AS prerequis_27, t0.objectif AS objectif_28, t0.plus AS plus_29, t0.public AS public_30, t0.commentaire AS commentaire_31, t0.certification_commentaire AS certification_commentaire_32, t0.seo_titre AS seo_titre_33, t0.seo_description AS seo_description_34, t0.info_pratique AS info_pratique_35, t0.accessibilite_handicap AS accessibilite_handicap_36, t0.alt_vignette AS alt_vignette_37, t0.description AS description_38, t0.modalites_delais_acces AS modalites_delais_acces_39, t0.alt_banniere AS alt_banniere_40, t0.identifiant_dokelio AS identifiant_dokelio_41, t0.publication AS publication_42, t0.contenu_apres AS contenu_apres_43, t0.contenu_avant AS contenu_avant_44, t0.nbrsessioninter AS nbrsessioninter_45, t0.nbrsessionintra AS nbrsessionintra_46, t0.modes_formation AS modes_formation_47, t0.created_by_id AS created_by_id_48, t0.updated_by_id AS updated_by_id_49, t0.mode_formation_id AS mode_formation_id_50, t0.sous_theme_theme_id AS sous_theme_theme_id_51, t0.theme_tarif_id AS theme_tarif_id_52, t0.niveaumateriel_id AS niveaumateriel_id_53, t0.niveautechnique_id AS niveautechnique_id_54, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_55, t0.banniere_id AS banniere_id_56, t0.vignette_id AS vignette_id_57, t0.api_gestiform_id AS api_gestiform_id_58, t0.type, t1.date_inscription AS date_inscription_59, t1.programme AS programme_60, t1.certification AS certification_61, t1.tarif_vente AS tarif_vente_62, t1.editeur_id AS editeur_id_63, t1.theme_id AS theme_id_64 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = ? SELECT t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive AS archive_5, t0.intitule AS intitule_6, t0.duree AS duree_7, t0.publie AS publie_8, t0.cpf AS cpf_9, t0.certifiantes AS certifiantes_10, t0.is_default AS is_default_11, t0.certifiante AS certifiante_12, t0.code AS code_13, t0.modalitepedagogiques AS modalitepedagogiques_14, t0.statistiques AS statistiques_15, t0.modaliteevaluationinitial AS modaliteevaluationinitial_16, t0.modaliteevaluationfinal AS modaliteevaluationfinal_17, t0.path AS path_18, t0.code_cpf AS code_cpf_19, t0.code_cpf_salarie AS code_cpf_salarie_20, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_21, t0.tarif_inter_jour AS tarif_inter_jour_22, t0.tarif_inter_horaire AS tarif_inter_horaire_23, t0.tarif_intra_jour AS tarif_intra_jour_24, t0.tarif_intra_horaire AS tarif_intra_horaire_25, t0.tarif_jury AS tarif_jury_26, t0.prerequis AS prerequis_27, t0.objectif AS objectif_28, t0.plus AS plus_29, t0.public AS public_30, t0.commentaire AS commentaire_31, t0.certification_commentaire AS certification_commentaire_32, t0.seo_titre AS seo_titre_33, t0.seo_description AS seo_description_34, t0.info_pratique AS info_pratique_35, t0.accessibilite_handicap AS accessibilite_handicap_36, t0.alt_vignette AS alt_vignette_37, t0.description AS description_38, t0.modalites_delais_acces AS modalites_delais_acces_39, t0.alt_banniere AS alt_banniere_40, t0.identifiant_dokelio AS identifiant_dokelio_41, t0.publication AS publication_42, t0.contenu_apres AS contenu_apres_43, t0.contenu_avant AS contenu_avant_44, t0.nbrsessioninter AS nbrsessioninter_45, t0.nbrsessionintra AS nbrsessionintra_46, t0.modes_formation AS modes_formation_47, t0.created_by_id AS created_by_id_48, t0.updated_by_id AS updated_by_id_49, t0.mode_formation_id AS mode_formation_id_50, t0.sous_theme_theme_id AS sous_theme_theme_id_51, t0.theme_tarif_id AS theme_tarif_id_52, t0.niveaumateriel_id AS niveaumateriel_id_53, t0.niveautechnique_id AS niveautechnique_id_54, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_55, t0.banniere_id AS banniere_id_56, t0.vignette_id AS vignette_id_57, t0.api_gestiform_id AS api_gestiform_id_58, t0.type, t1.date_inscription AS date_inscription_59, t1.programme AS programme_60, t1.certification AS certification_61, t1.tarif_vente AS tarif_vente_62, t1.editeur_id AS editeur_id_63, t1.theme_id AS theme_id_64 FROM module t0 LEFT JOIN certification t1 ON t0.id = t1.id WHERE t0.id = 7;
44	0.90 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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_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.taux_obtention AS taux_obtention_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.cpf AS cpf_29, t0.code_cpf AS code_cpf_30, t0.code_rncp_rs AS code_rncp_rs_31, t0.code_cpf_salarie AS code_cpf_salarie_32, t0.code_cpf_demandeur_emploi AS code_cpf_demandeur_emploi_33, t0.code_nsf AS code_nsf_34, t0.duree AS duree_35, t0.duree_modulaire AS duree_modulaire_36, t0.rncp AS rncp_37, t0.duree_accompagnement AS duree_accompagnement_38, t0.duree_stage AS duree_stage_39, t0.duree_center AS duree_center_40, t0.duree_elearning AS duree_elearning_41, t0.stage_obligatoire AS stage_obligatoire_42, t0.formation_permanente AS formation_permanente_43, t0.sanction_resume AS sanction_resume_44, t0.sanction_long AS sanction_long_45, t0.metier AS metier_46, t0.accessibilite_handicap AS accessibilite_handicap_47, t0.modalites_delais_acces AS modalites_delais_acces_48, t0.modaliteevaluationinitial AS modaliteevaluationinitial_49, t0.modaliteevaluationfinal AS modaliteevaluationfinal_50, t0.text AS text_51, t0.objectif AS objectif_52, t0.debouche AS debouche_53, t0.condition_admission AS condition_admission_54, t0.public AS public_55, t0.detail_examen AS detail_examen_56, t0.frais_pedagogique AS frais_pedagogique_57, t0.methodes_mobilisees AS methodes_mobilisees_58, t0.seo_titre AS seo_titre_59, t0.seo_description AS seo_description_60, t0.rythme AS rythme_61, t0.identifiant_dokelio AS identifiant_dokelio_62, t0.dokelio_parcours AS dokelio_parcours_63, t0.contenu_apres AS contenu_apres_64, t0.contenu_avant AS contenu_avant_65, t0.path AS path_66, t0.items AS items_67, t0.is_default AS is_default_68, t0.created_by_id AS created_by_id_69, t0.updated_by_id AS updated_by_id_70, t0.theme_id AS theme_id_71, t0.parent_id AS parent_id_72, t0.autorite_delivrance_cpf_id AS autorite_delivrance_cpf_id_73, t0.nsf_id AS nsf_id_74, t0.diplomes_titres_parcours_id AS diplomes_titres_parcours_id_75, t0.filiere_id AS filiere_id_76, t0.niveau_entree_id AS niveau_entree_id_77, t0.niveau_sortie_id AS niveau_sortie_id_78, t0.niveau_technique_id AS niveau_technique_id_79, t0.qualifiant_id AS qualifiant_id_80, t0.type_formation_id AS type_formation_id_81, t0.autorite_delivrance_id AS autorite_delivrance_id_82, t0.mode_formation_id AS mode_formation_id_83, t0.formateur_id AS formateur_id_84, t0.banniere_id AS banniere_id_85, t0.vignette_id AS vignette_id_86 FROM parcours t0 WHERE t0.id = 7;
45	0.30 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.autres_prenoms AS autres_prenoms_7, t0.mobile AS mobile_8, t0.tel_fixe AS tel_fixe_9, t0.ville_naissance AS ville_naissance_10, t0.departement_naissance AS departement_naissance_11, t0.pays_naissance AS pays_naissance_12, t0.nationalite AS nationalite_13, t0.fonction AS fonction_14, t0.handicap_remarques AS handicap_remarques_15, t0.connu_doranco AS connu_doranco_16, t0.nir AS nir_17, t0.num_secu_sociale AS num_secu_sociale_18, t0.reconnaissance_handicap AS reconnaissance_handicap_19, t0.handicap AS handicap_20, t0.rqth AS rqth_21, t0.extension_boe AS extension_boe_22, t0.permis_b AS permis_b_23, t0.vehicule AS vehicule_24, t0.date_naissance AS date_naissance_25, t0.date_carte_sejour AS date_carte_sejour_26, t0.date_obtention_diplome AS date_obtention_diplome_27, t0.nationality AS nationality_28, t0.created_by_id AS created_by_id_29, t0.updated_by_id AS updated_by_id_30, t0.civilite_id AS civilite_id_31, t0.categorie_nationalite_id AS categorie_nationalite_id_32, t0.regime_social_id AS regime_social_id_33 FROM personal_informations t0 WHERE t0.id = 5;
46	0.19 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.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? AND t0.api_gestiform_id = ? LIMIT 1 Parameters: [`"CALENDRIER" "WEEKEND" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? AND t0.api_gestiform_id = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = 'CALENDRIER' AND t0.code = 'WEEKEND' AND t0.api_gestiform_id = 1 LIMIT 1;
47	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.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ? Parameters: [`317`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = 317;
48	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 m1_.code = ? AND m1_.module = ? ORDER BY m0_.code ASC Parameters: [`"JOURSSEMCHOMES" "CALENDRIER"`] 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 = 'JOURSSEMCHOMES' AND m1_.module = 'CALENDRIER' ORDER BY m0_.code ASC;
49	0.29 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.intitule = ? LIMIT 1 Parameters: [`"session_systeme"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.intitule = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.intitule AS intitule_5, t0.type AS type_6, t0.session_dokelio AS session_dokelio_7, t0.dokelio_parcours AS dokelio_parcours_8, t0.simul_nb_apprenants AS simul_nb_apprenants_9, t0.numero_session AS numero_session_10, t0.duree AS duree_11, t0.date_debut AS date_debut_12, t0.date_debut_affichage AS date_debut_affichage_13, t0.date_fin_affichage AS date_fin_affichage_14, t0.site_partenaire AS site_partenaire_15, t0.guaranteed AS guaranteed_16, t0.permenant AS permenant_17, t0.publie_site AS publie_site_18, t0.dates_larges AS dates_larges_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21, t0.salle_defaut_id AS salle_defaut_id_22, t0.parcours_id AS parcours_id_23, t0.adresse_partenaire_id AS adresse_partenaire_id_24, t0.statut_id AS statut_id_25, t0.referent_pedagogique_id AS referent_pedagogique_id_26, t0.referent_coach_id AS referent_coach_id_27, t0.referent_administratif_id AS referent_administratif_id_28, t0.referent_handicap_id AS referent_handicap_id_29, t0.planning_id AS planning_id_30, t0.site_id AS site_id_31, t0.api_gestiform_id AS api_gestiform_id_32 FROM session t0 WHERE t0.intitule = 'session_systeme' LIMIT 1;
50	0.23 ms	SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? LIMIT 1 Parameters: [`"FINANCEURS" "CATEGORIES"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = ? AND t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.module AS module_5, t0.code AS code_6, t0.designation AS designation_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9, t0.api_gestiform_id AS api_gestiform_id_10 FROM masterliste t0 WHERE t0.module = 'FINANCEURS' AND t0.code = 'CATEGORIES' LIMIT 1;
51	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.masterliste_id = ? Parameters: [`104`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ? SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = 104;

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	76
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours	12
App\Entity\Gestiform\Admin\Role	9
App\Entity\Common\Upload	8
App\Entity\Gestiform\Admin\MasterListe\Masterliste	8
App\Entity\Gestiform\Formations\Catalogue\Niveau	8
App\Entity\Gestiform\Formations\Session\Session	3
App\Entity\Gestiform\Formations\Catalogue\Filiere	3
App\Entity\Gestiform\Admin\ApiGestiform	2
App\Entity\Gestiform\Formations\Session\Planning\Planning	2
App\Entity\Gestiform\Users\User	1
App\Entity\Gestiform\Formations\Dossier\PersonalInformations	1
App\Entity\Gestiform\Admin\EditLock	1
App\Entity\Gestiform\Admin\Tiers	1
App\Entity\Gestiform\Formations\Session\Planning\PlanningEvent	1
App\Entity\Gestiform\Formations\Session\Planning\Event	1
App\Entity\Gestiform\Formations\Catalogue\Module\Module	1
App\Entity\Gestiform\Formations\Catalogue\Theme\SousThemeTheme	1
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme	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	The association App\Entity\Gestiform\Formations\Dossier\Dossier#formulaireReponses refers to the owning side field App\Entity\Gestiform\Quiz\QuizReponse#dossier which does not exist.
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\Catalogue\Parcours\Parcours	The field 'App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#tarifJury2' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The association App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours#modeFormation refers to the inverse side field App\Entity\Gestiform\Admin\MasterListe\Masterlistelg#parcours which does not exist.
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme	The mappings App\Entity\Gestiform\Formations\Catalogue\Theme\Theme#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#theme are inconsistent with each other.
App\Entity\Gestiform\Formations\Catalogue\Filiere	No errors.
App\Entity\Gestiform\Formations\Catalogue\Niveau	No errors.
App\Entity\Gestiform\Formations\Session\Session	The association App\Entity\Gestiform\Formations\Session\Session#salleDefaut refers to the inverse side field App\Entity\Gestiform\Admin\Salle#sessions which does not exist.
App\Entity\Gestiform\Admin\Salle	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Planning	No errors.
App\Entity\Gestiform\Admin\Site	No errors.
App\Entity\Gestiform\Formations\Reunion\Reunion	No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueDossier	No errors.
App\Entity\Gestiform\Formations\Session\SessionBlocModule	No errors.
App\Entity\Gestiform\Formations\Actions\BondeCommandeParcour	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\Bloc	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModaliteEvaluation	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteParcours	The field 'App\Entity\Gestiform\Admin\Tarifs\TarifVenteParcours#forfaitAccompagnements' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Common\Document	No errors.
App\Entity\Gestiform\Admin\Profil	No errors.
App\Entity\Gestiform\Admin\Tiers	No errors.
App\Entity\Gestiform\Admin\Societe	No errors.
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes	No errors.
App\Entity\Gestiform\Formations\Entreprise\Entreprise	No errors.
App\Entity\Gestiform\Admin\Platforme	No errors.
App\Entity\Gestiform\Admin\Etablissement	No errors.
App\Entity\Gestiform\Formations\Session\Planning\PlanningEvent	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Event	No errors.
App\Entity\Gestiform\Formations\Session\SalleEvent	The mappings App\Entity\Gestiform\Formations\Session\SalleEvent#salle and App\Entity\Gestiform\Admin\Salle#salleEvents are inconsistent with each other.
App\Entity\Gestiform\Formations\Session\Planning\ApprenantLivrable	No errors.
App\Entity\Common\Convention	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Accompagnement	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Module	The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifInterJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifInterHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifIntraJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifIntraHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\Gestiform\Formations\Catalogue\Module\Module#moduleModaliteEvaluationFinales and App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale#module are inconsistent with each other. The mappings App\Entity\Gestiform\Formations\Catalogue\Module\Module#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#module are inconsistent with each other.
App\Entity\Gestiform\Formations\Session\Planning\Jury	No errors.
App\Entity\Gestiform\Formations\Session\Planning\Stage	No errors.
App\Entity\Gestiform\Formations\Catalogue\Certification	The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifInterJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifInterHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifIntraJour' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifIntraHoraire' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Catalogue\Certification#tarifJury' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The mappings App\Entity\Gestiform\Formations\Catalogue\Certification#moduleModaliteEvaluationFinales and App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale#module are inconsistent with each other. The mappings App\Entity\Gestiform\Formations\Catalogue\Certification#tarifsVenteIntras and App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra#module are inconsistent with each other.
App\Entity\Gestiform\Formations\Catalogue\Theme\SousThemeTheme	No errors.
App\Entity\Gestiform\Formations\Catalogue\Editeur	No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\BlocModule	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Chapitre	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModuleCompetence	No errors.
App\Entity\Gestiform\Formations\Financeur\Financeur	No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale	The association App\Entity\Gestiform\Formations\Catalogue\Module\ModuleModaliteEvaluationFinale#module refers to the inverse side field App\Entity\Gestiform\Formations\Catalogue\Module\Module#modulemodaliteevaluationfinales which does not exist.
App\Entity\Gestiform\Formations\Formateur\FormateurModule	The field 'App\Entity\Gestiform\Formations\Formateur\FormateurModule#note' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Gestiform\Formations\Formateur\FormateurModule#noteAutoEval' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Gestiform\Admin\Tarifs\TarifVente	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteTheme	No errors.
App\Entity\Gestiform\Admin\Tarifs\TarifVenteThemeIntra	No errors.
App\Entity\Gestiform\Formations\Session\FormateurEvent	The field 'App\Entity\Gestiform\Formations\Session\FormateurEvent#nbjoursPrevus' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Gestiform\Formations\Emargement\Emargement	No errors.
App\Entity\Gestiform\Formations\Session\Planning\FormulaireEvent	No errors.

Symfony Profiler

GET https://test.simplyform.lmosoft.com/formations/session-parcours

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping