Query Metrics

44 Database Queries
17 Different statements
16.05 ms Query time
0 Invalid entities
239 Managed entities

Queries

Group similar statements

# Time Info
1 0.28 ms
SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  1
]
2 0.40 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:
[
  "MODELETEMPLATE"
  "ROLE"
  "RESOURCE"
]
3 0.18 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"
]
4 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
  5968
]
5 0.72 ms
SELECT t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.archive AS archive_8, t0.email AS email_9, t0.password AS password_10, t0.plain_password AS plain_password_11, t0.roles AS roles_12, t0.enabled AS enabled_13, t0.status AS status_14, t0.rgpd AS rgpd_15, t0.api_token AS api_token_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.adresse_id AS adresse_id_19, t0.photo_id AS photo_id_20, t0.api_gestiform_id AS api_gestiform_id_21, t0.type, t1.rgpd_signed_at AS rgpd_signed_at_22, t1.personal_informations_id AS personal_informations_id_23, t1.rgpd_document_id AS rgpd_document_id_24, t1.responsable_hierarchique_id AS responsable_hierarchique_id_25, t2.mineur AS mineur_26, t2.dossier_actif_id AS dossier_actif_id_27, t2.representant_legal_id AS representant_legal_id_28, t3.prefecture AS prefecture_29, t3.numero_activite AS numero_activite_30, t3.numero_activite2 AS numero_activite2_31, t3.liste_competences AS liste_competences_32, t3.debut_habilitation AS debut_habilitation_33, t3.fin_habilitation AS fin_habilitation_34, t3.jury_uniquement AS jury_uniquement_35, t3.mission_proposee AS mission_proposee_36, t3.statut_id AS statut_id_37, t4.personal_informations_id AS personal_informations_id_38, t4.signature_file_id AS signature_file_id_39 FROM user t0 LEFT JOIN employe t1 ON t0.id = t1.id LEFT JOIN apprenant t2 ON t0.id = t2.id LEFT JOIN formateur t3 ON t0.id = t3.id LEFT JOIN personne t4 ON t0.id = t4.id WHERE t0.id = ?
Parameters:
[
  68
]
6 0.27 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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
]
7 0.18 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"
]
8 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:
[
  5980
  5968
]
9 0.12 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"
]
10 0.10 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
  5968
]
11 0.09 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ?
Parameters:
[
  5976
]
12 0.10 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_MEMBRE"
  "ROLE"
  "USER"
]
13 0.09 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  5952
  5968
]
14 0.09 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ?
Parameters:
[
  5977
]
15 2.83 ms
DELETE FROM edit_locks WHERE expires_at <= ?
Parameters:
[
  "2026-05-29 18:47:49"
]
16 1.07 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:
[
  "MODELETEMPLATE"
  "2026-05-29 18:47:49"
]
17 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:
[
  "RESOURCE"
  "ROLE"
]
18 0.12 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:
[
  "MODELETEMPLATE"
  "ROLE"
  "RESOURCE"
]
19 0.09 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_SUPER_ADMIN"
  "ROLE"
  "USER"
]
20 0.08 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  5979
  5968
]
21 0.10 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_ADMIN"
  "ROLE"
  "USER"
]
22 0.07 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  5980
  5968
]
23 0.08 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_USER"
  "ROLE"
  "USER"
]
24 0.08 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  6471
  5968
]
25 0.08 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_MEMBRE"
  "ROLE"
  "USER"
]
26 0.07 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  5952
  5968
]
27 0.21 ms
DELETE FROM edit_locks WHERE expires_at <= ?
Parameters:
[
  "2026-05-29 18:47:49"
]
28 0.34 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:
[
  "MODELETEMPLATE"
  "2026-05-29 18:47:49"
  "/admin/template/CONTRATS-CONVENTIONS-REGLEMENTS-CHARTES/contenu/115"
]
29 0.12 ms
"START TRANSACTION"
Parameters:
[]
30 0.30 ms
INSERT INTO edit_locks (resource_type, resource_url, resource_id, created_at, expires_at, updated_at, locked_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "MODELETEMPLATE"
  "/admin/template/CONTRATS-CONVENTIONS-REGLEMENTS-CHARTES/contenu/115"
  null
  "2026-05-29 18:47:49"
  "2026-05-29 18:52:49"
  "2026-05-29 18:47:49"
  1
]
31 1.66 ms
"COMMIT"
Parameters:
[]
32 0.24 ms
SELECT t1.id AS id_2, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.archive AS archive_5, t1.raison_sociale AS raison_sociale_6, t1.siret AS siret_7, t1.site_web AS site_web_8, t1.numero_uai AS numero_uai_9, t1.code_ape AS code_ape_10, t1.assurance AS assurance_11, t1.domaine AS domaine_12, t1.code_banque AS code_banque_13, t1.num_compte AS num_compte_14, t1.iban AS iban_15, t1.domiciliation AS domiciliation_16, t1.email AS email_17, t1.prevoyance AS prevoyance_18, t1.num_tva AS num_tva_19, t1.description AS description_20, t1.cfa_entreprise AS cfa_entreprise_21, t1.sous_traitant AS sous_traitant_22, t1.prive AS prive_23, t1.num_activite AS num_activite_24, t1.mobile AS mobile_25, t1.fax AS fax_26, t1.fixe AS fixe_27, t1.siren AS siren_28, t1.forme_juridique AS forme_juridique_29, t1.urssaf AS urssaf_30, t1.caisse_retraite AS caisse_retraite_31, t0.signature_email AS signature_email_32, t0.code_adherent AS code_adherent_33, t0.width_logo_header AS width_logo_header_34, t0.height_logo_header AS height_logo_header_35, t0.width_logo_footer AS width_logo_footer_36, t0.height_logo_footer AS height_logo_footer_37, t0.par_defaut AS par_defaut_38, t0.defaut_alternance AS defaut_alternance_39, t1.created_by_id AS created_by_id_40, t1.updated_by_id AS updated_by_id_41, t1.logo_id AS logo_id_42, t1.convention_collective_id AS convention_collective_id_43, t1.code_tva_id AS code_tva_id_44, t1.personne_id AS personne_id_45, t1.api_gestiform_id AS api_gestiform_id_46, t0.type_id AS type_id_47, t0.financeur_modele_absence_id AS financeur_modele_absence_id_48, t0.financeur_modele_retard_id AS financeur_modele_retard_id_49, t0.referent_handicap_id AS referent_handicap_id_50, t0.representant_id AS representant_id_51, t0.cachet_id AS cachet_id_52, t0.piedpage_id AS piedpage_id_53, t0.image_rib_id AS image_rib_id_54, t1.type FROM societe t0 INNER JOIN tiers t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  39
]
33 0.79 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.title AS title_6, t0.code AS code_7, t0.description AS description_8, t0.conseil_regional AS conseil_regional_9, t0.avec_entete AS avec_entete_10, t0.specifique AS specifique_11, t0.code_specifique AS code_specifique_12, t0.subtitle AS subtitle_13, t0.content AS content_14, t0.default_template AS default_template_15, t0.signe AS signe_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.categorie_id AS categorie_id_19, t0.societe_id AS societe_id_20, t0.type_id AS type_id_21, t0.usage_id AS usage_id_22, t0.api_gestiform_id AS api_gestiform_id_23 FROM template t0 WHERE t0.id = ?
Parameters:
[
  "115"
]
34 0.27 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"
]
35 0.22 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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 = ?
Parameters:
[
  "CONNECTEURS"
]
36 0.14 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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:
[
  "MODULEDOCUMENT"
  "TYPE"
]
37 0.10 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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:
[
  106
]
38 0.09 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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:
[
  "MODULEDOCUMENT"
  "TYPE"
]
39 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.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 INNER JOIN template_masterliste ON t0.id = template_masterliste.masterliste_id WHERE template_masterliste.template_id = ?
Parameters:
[
  115
]
40 1.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.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:
[
  287
]
41 0.30 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.masterliste_id = ?
Parameters:
[
  315
]
42 0.20 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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:
[
  291
]
43 1.26 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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:
[
  289
]
44 0.40 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "gestiform_admin_template_details_contenu"
  "TRIGGER"
  "METHOD"
]

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 205
App\Entity\Gestiform\Admin\MasterListe\Masterliste 15
App\Entity\Gestiform\Admin\Role 9
App\Entity\Gestiform\Users\User 2
App\Entity\Common\Upload 2
App\Entity\Gestiform\Admin\ApiGestiform 2
App\Entity\Gestiform\Formations\Dossier\PersonalInformations 1
App\Entity\Gestiform\Admin\EditLock 1
App\Entity\Gestiform\Admin\ModelsDocument\Template 1
App\Entity\Gestiform\Admin\Tiers 1

Entities Mapping

Class Mapping errors
App\Entity\AbstractEntity No errors.
App\Entity\Gestiform\Users\User No errors.
App\Entity\Gestiform\Users\Employe No errors.
App\Entity\Gestiform\Users\Personne No errors.
App\Entity\Gestiform\Users\Apprenant No errors.
App\Entity\Gestiform\Users\Formateur No errors.
App\Entity\Common\Adresse No errors.
App\Entity\Common\Upload No errors.
App\Entity\Gestiform\Admin\ApiGestiform No errors.
App\Entity\Gestiform\Formations\Dossier\PersonalInformations No errors.
App\Entity\Gestiform\Formations\Dossier\Dossier No errors.
App\Entity\Gestiform\Formations\Entreprise\Contact No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterlistelg No errors.
App\Entity\Common\HistoriqueEmail No errors.
App\Entity\Gestiform\Admin\MasterListe\Masterliste No errors.
App\Entity\Gestiform\Admin\Role No errors.
App\Entity\Common\Document No errors.
App\Entity\Gestiform\Admin\Entretien\CVdynamique No errors.
App\Entity\Gestiform\Admin\Entretien\Entretien No errors.
App\Entity\Gestiform\Formations\Dossier\DossierQuiz No errors.
App\Entity\Gestiform\Admin\EditLock No errors.
App\Entity\Gestiform\Admin\Tiers No errors.
App\Entity\Gestiform\Admin\Societe No errors.
App\Entity\Gestiform\Formations\Financeur\Financeur No errors.
App\Entity\Gestiform\Admin\ModelsDocument\Template No errors.
App\Entity\Gestiform\Admin\ModelsDocument\AttachmentTemplate No errors.
App\Entity\Gestiform\Formations\Formateur\FormateurModule No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours No errors.
App\Entity\Gestiform\Formations\Entreprise\FormateurEntreprise No errors.
App\Entity\Gestiform\Formations\Entreprise\Contrat No errors.
App\Entity\Gestiform\Formations\Session\Planning\LignePrestation No errors.
App\Entity\Gestiform\Formations\Session\FormateurEvent No errors.
App\Entity\Gestiform\Formations\Session\Planning\ApprenantLivrable No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueComment No errors.
App\Entity\Gestiform\Admin\Profil No errors.
App\Entity\Gestiform\Formations\Session\Planning\Planning No errors.
App\Entity\Gestiform\Formations\Session\Session No errors.
App\Entity\Gestiform\Admin\Site No errors.
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes No errors.
App\Entity\Gestiform\Formations\Emargement\EmargementJustificatif No errors.
App\Entity\Gestiform\Formations\Reunion\ReunionDossier No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueDossier No errors.
App\Entity\Gestiform\Formations\Reglement\Reglement No errors.
App\Entity\Common\Convention No errors.
App\Entity\Gestiform\Formations\Devis\Devis No errors.
App\Entity\Gestiform\Formations\Entreprise\Entreprise No errors.
App\Entity\Gestiform\Formations\Financement\Financement No errors.
App\Entity\Gestiform\Admin\Platforme No errors.
App\Entity\Gestiform\Users\HistoriqueChat No errors.
App\Entity\Gestiform\Formations\Dossier\Diplome No errors.
App\Entity\Gestiform\Formations\Dossier\Avertissement No errors.
App\Entity\Gestiform\Admin\Etablissement No errors.
App\Entity\Gestiform\Formations\Facturation\Facturation No errors.
App\Entity\Gestiform\Formations\Session\Planning\Event No errors.
App\Entity\Gestiform\Quiz\Quiz No errors.
App\Entity\Common\Attachment No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\Module No errors.
App\Entity\Gestiform\Formations\Catalogue\Module\ModuleCompetence No errors.
App\Entity\Gestiform\Formations\Catalogue\Parcours\Bloc\BlocCompetence No errors.
App\Entity\Gestiform\Admin\Salle No errors.
App\Entity\Gestiform\Formations\Catalogue\Theme\Theme No errors.
App\Entity\Gestiform\Formations\Dossier\ApprenantReponse No errors.
App\Entity\Gestiform\Formations\Actions\Action No errors.
App\Entity\Gestiform\Formations\Financeur\CodeAbsence No errors.
App\Entity\Gestiform\Formations\Financeur\CodeRetard No errors.
App\Entity\Gestiform\Formations\Financeur\PerimetreFinancement No errors.