GET https://test.simplyform.lmosoft.com/formations/dossier/65/get-chats

Query Metrics

22 Database Queries
6 Different statements
4.61 ms Query time
3 Invalid entities
49 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 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.personal_informations_id AS personal_informations_id_21, t2.mineur AS mineur_22, t2.dossier_actif_id AS dossier_actif_id_23, t2.representant_legal_id AS representant_legal_id_24, t3.prefecture AS prefecture_25, t3.numero_activite AS numero_activite_26, t3.numero_activite2 AS numero_activite2_27, t3.liste_competences AS liste_competences_28, t3.debut_habilitation AS debut_habilitation_29, t3.fin_habilitation AS fin_habilitation_30, t3.jury_uniquement AS jury_uniquement_31, t3.mission_proposee AS mission_proposee_32, t3.statut_id AS statut_id_33, t4.personal_informations_id AS personal_informations_id_34, t4.signature_file_id AS signature_file_id_35 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.38 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"
]
3 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:
[
  "CLIENT_ID"
  "CONNECTEURS"
  "opco"
]
4 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:
[
  "CLIENT_SECRET"
  "CONNECTEURS"
  "opco"
]
5 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:
[
  "TOKEN_URI"
  "CONNECTEURS"
  "opco"
]
6 0.14 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:
[
  "API_BASE_URI"
  "CONNECTEURS"
  "opco"
]
7 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:
[
  "API_KEY"
  "CONNECTEURS"
  "opco"
]
8 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:
[
  "SIREN"
  "CONNECTEURS"
  "opco"
]
9 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:
[
  "DOSSIER"
  "ROLE"
  "RESOURCE"
]
10 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_USER"
  "ROLE"
  "USER"
]
11 0.18 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  6471
  5956
]
12 0.17 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.code AS code_5, t0.designation AS designation_6, t0.valeur AS valeur_7, t0.valeur2 AS valeur2_8, t0.htmlvaleur AS htmlvaleur_9, t0.valeur3 AS valeur3_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12, t0.masterliste_id AS masterliste_id_13, t0.api_gestiform_id AS api_gestiform_id_14 FROM masterlistelg t0 WHERE t0.id = ?
Parameters:
[
  5976
]
13 0.19 ms
SELECT m0_.id AS id_0, m0_.created_at AS created_at_1, m0_.updated_at AS updated_at_2, m0_.archive AS archive_3, m0_.code AS code_4, m0_.designation AS designation_5, m0_.valeur AS valeur_6, m0_.valeur2 AS valeur2_7, m0_.htmlvaleur AS htmlvaleur_8, m0_.valeur3 AS valeur3_9, m1_.id AS id_10, m1_.created_at AS created_at_11, m1_.updated_at AS updated_at_12, m1_.archive AS archive_13, m1_.module AS module_14, m1_.code AS code_15, m1_.designation AS designation_16, m0_.created_by_id AS created_by_id_17, m0_.updated_by_id AS updated_by_id_18, m0_.masterliste_id AS masterliste_id_19, m0_.api_gestiform_id AS api_gestiform_id_20, m1_.created_by_id AS created_by_id_21, m1_.updated_by_id AS updated_by_id_22, m1_.api_gestiform_id AS api_gestiform_id_23 FROM masterlistelg m0_ INNER JOIN masterliste m1_ ON m0_.masterliste_id = m1_.id WHERE m0_.code = ? AND m1_.module = ? AND m1_.code = ? LIMIT 1
Parameters:
[
  "ROLE_ADMIN"
  "ROLE"
  "USER"
]
14 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
  5956
]
15 0.14 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"
]
16 0.13 ms
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.updated_at AS updated_at_2, r0_.archive AS archive_3, r0_.date_fin AS date_fin_4, r0_.created_by_id AS created_by_id_5, r0_.updated_by_id AS updated_by_id_6, r0_.name_id AS name_id_7, r0_.name_ids AS name_ids_8, r0_.resource_id AS resource_id_9, r0_.permission_id AS permission_id_10, r0_.utlisateur_id AS utlisateur_id_11 FROM role r0_ WHERE r0_.name_id = ? AND r0_.resource_id = ?
Parameters:
[
  5979
  5956
]
17 0.13 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.archive AS archive_4, t0.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
]
18 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_MEMBRE"
  "ROLE"
  "USER"
]
19 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
  5956
]
20 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.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
]
21 0.41 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.reference AS reference_5, t0.items_document AS items_document_6, t0.panier AS panier_7, t0.competences AS competences_8, t0.cart AS cart_9, t0.mode AS mode_10, t0.linkedin AS linkedin_11, t0.portfolio AS portfolio_12, t0.campus AS campus_13, t0.modalite_enseignement AS modalite_enseignement_14, t0.commentaire AS commentaire_15, t0.email_candidature AS email_candidature_16, t0.date_reunion AS date_reunion_17, t0.stop_date AS stop_date_18, t0.candidate_available AS candidate_available_19, t0.rncp AS rncp_20, t0.diplomant AS diplomant_21, t0.delegue_classe AS delegue_classe_22, t0.postulant_available AS postulant_available_23, t0.prospect_available AS prospect_available_24, t0.stagiaire_available AS stagiaire_available_25, t0.alumni_available AS alumni_available_26, t0.news_letter AS news_letter_27, t0.processed AS processed_28, t0.statut_declaration AS statut_declaration_29, t0.a_representant_legal AS a_representant_legal_30, t0.notification_paiement AS notification_paiement_31, t0.engagement_formation AS engagement_formation_32, t0.charte_formation AS charte_formation_33, t0.compte_zoom AS compte_zoom_34, t0.notified AS notified_35, t0.femme_eloigne AS femme_eloigne_36, t0.zrr AS zrr_37, t0.qpv AS qpv_38, t0.participation_reglee AS participation_reglee_39, t0.participation AS participation_40, t0.caution AS caution_41, t0.restea_regler AS restea_regler_42, t0.created_by_id AS created_by_id_43, t0.updated_by_id AS updated_by_id_44, t0.stop_proof_id AS stop_proof_id_45, t0.stop_cause_id AS stop_cause_id_46, t0.stop_type_id AS stop_type_id_47, t0.type_actif_id AS type_actif_id_48, t0.state_id AS state_id_49, t0.dispositif_id AS dispositif_id_50, t0.type_formation_id AS type_formation_id_51, t0.resultat_id AS resultat_id_52, t0.profil_id AS profil_id_53, t0.personal_informations_id AS personal_informations_id_54, t0.adresse_id AS adresse_id_55, t0.planning_id AS planning_id_56, t0.session_id AS session_id_57, t0.societe_id AS societe_id_58, t0.site_id AS site_id_59, t0.dossierannexes_id AS dossierannexes_id_60, t0.apprenant_id AS apprenant_id_61, t0.parcours_id AS parcours_id_62, t0.reorienter_id AS reorienter_id_63, t0.referent_pedagogique_id AS referent_pedagogique_id_64, t0.referent_commercial_id AS referent_commercial_id_65, t0.referent_coach_id AS referent_coach_id_66, t0.referent_administratif_id AS referent_administratif_id_67, t0.entreprise_id AS entreprise_id_68, t0.entreprise_contact_id AS entreprise_contact_id_69, t0.cv_id AS cv_id_70, t0.platforme_id AS platforme_id_71, t72.id AS id_73, t72.created_at AS created_at_74, t72.updated_at AS updated_at_75, t72.archive AS archive_76, t72.intitule AS intitule_77, t72.acrrochage AS acrrochage_78, t72.date_examen AS date_examen_79, t72.created_by_id AS created_by_id_80, t72.updated_by_id AS updated_by_id_81, t72.admission_id AS admission_id_82, t72.mention_id AS mention_id_83, t72.president_jury_id AS president_jury_id_84, t72.dossier_id AS dossier_id_85, t72.parcours_id AS parcours_id_86, t0.emergency_contact_id AS emergency_contact_id_87, t0.legal_representative_id AS legal_representative_id_88, t0.etablissement_id AS etablissement_id_89 FROM dossier t0 LEFT JOIN diplome t72 ON t72.dossier_id = t0.id WHERE t0.id = ?
Parameters:
[
  "65"
]
22 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.message AS message_5, t0.type AS type_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8, t0.dossier_id AS dossier_id_9 FROM historique_chat t0 WHERE t0.dossier_id = ?
Parameters:
[
  65
]

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 19
App\Entity\Gestiform\Admin\Role 6
App\Entity\Gestiform\Admin\MasterListe\Masterliste 5
App\Entity\Gestiform\Users\User 3
App\Entity\Common\Adresse 2
App\Entity\Gestiform\Admin\ApiGestiform 2
App\Entity\Gestiform\Formations\Dossier\PersonalInformations 2
App\Entity\Gestiform\Admin\Tiers 2
App\Entity\Gestiform\Formations\Dossier\Dossier 1
App\Entity\Gestiform\Admin\Profil 1
App\Entity\Gestiform\Formations\Session\Planning\Planning 1
App\Entity\Gestiform\Formations\Session\Session 1
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes 1
App\Entity\Gestiform\Formations\Catalogue\Parcours\Parcours 1
App\Entity\Gestiform\Formations\Entreprise\Contact 1
App\Entity\Gestiform\Admin\Etablissement 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\Gestiform\Admin\MasterListe\Masterliste No errors.
App\Entity\Gestiform\Admin\Role No errors.
App\Entity\Gestiform\Admin\Profil No errors.
App\Entity\Gestiform\Formations\Session\Planning\Planning 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\Tiers No errors.
App\Entity\Gestiform\Admin\Societe No errors.
App\Entity\Gestiform\Admin\Site No errors.
App\Entity\Gestiform\Formations\Dossier\DossierAnnexes 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\Entreprise\Entreprise No errors.
App\Entity\Gestiform\Admin\Platforme No errors.
App\Entity\Gestiform\Formations\Dossier\Diplome No errors.
App\Entity\Gestiform\Admin\Etablissement No errors.
App\Entity\Common\Document No errors.
App\Entity\Common\HistoriqueEmail No errors.
App\Entity\Gestiform\Formations\Emargement\EmargementJustificatif No errors.
App\Entity\Gestiform\Admin\Cursus\CVdynamique No errors.
App\Entity\Gestiform\Admin\Cursus\Entretien No errors.
App\Entity\Gestiform\Admin\Cursus\CursusReponses No errors.
App\Entity\Gestiform\Quiz\QuizReponse 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\Financement\Financement No errors.
App\Entity\Gestiform\Formations\Dossier\DossierQuiz No errors.
App\Entity\Gestiform\Formations\Dossier\HistoriqueComment No errors.
App\Entity\Gestiform\Users\HistoriqueChat No errors.
App\Entity\Gestiform\Formations\Dossier\Avertissement No errors.
App\Entity\Gestiform\Formations\Facturation\Facturation No errors.