Error 500 Internal Server Error

GET https://mercure-qualite-web-test.autobilan-systems.com/admin/planification-audits

Browse referrer URL
IP
86.228.222.67
Profiled on
Token
d7164a
Forwarded to ErrorController (b92c59)

Query Metrics

4 Database Queries
4 Different statements
159.65 ms Query time
1 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
85.42 ms
(53.51%) 		1 
SELECT t0_.IDPlanningTache AS IDPlanningTache_0, t0_.SiegeOuDomicile AS SiegeOuDomicile_1, t0_.FKFormation AS FKFormation_2, t0_.FKCentre AS FKCentre_3, t0_.DateHeureDebut AS DateHeureDebut_4, t0_.DateHeureFin AS DateHeureFin_5, t0_.Titre AS Titre_6, t0_.Description AS Description_7, t0_.DateHeureMajMYSQL AS DateHeureMajMYSQL_8, t0_.id_session_formation AS id_session_formation_9, t0_.FKPlanningType AS FKPlanningType_10, t0_.FKUser AS FKUser_11, t0_.FKAudit AS FKAudit_12 FROM t_planningtache t0_ WHERE t0_.FKUser = ? AND t0_.DateHeureDebut >= ? ORDER BY t0_.DateHeureDebut ASC
Parameters: 
[
  1419
  "2026-04-21 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
39.58 ms
(24.79%) 		1 
SELECT t0.id AS id_1, t0.date_de_soumission AS date_de_soumission_2, t0.date_demander AS date_demander_3, t0.temp_trajet_avant_rdv AS temp_trajet_avant_rdv_4, t0.temp_trajet_apres_rdv AS temp_trajet_apres_rdv_5, t0.centre_id AS centre_id_6, t0.controleur_id AS controleur_id_7, t0.type_audit_id AS type_audit_id_8, t0.auditeur_id AS auditeur_id_9 FROM aut_plannification_date_audit_superviseur t0 WHERE t0.auditeur_id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
18.97 ms
(11.88%) 		1 
SELECT t0.IDCentre AS IDCentre_1, t0.NumeroAgrementCentre AS NumeroAgrementCentre_2, t0.LoginCentre AS LoginCentre_3, t0.MotDePasseCrypte AS MotDePasseCrypte_4, t0.estVL AS estVL_5, t0.LogoCentre AS LogoCentre_6, t0.DateCreationInstallation AS DateCreationInstallation_7, t0.EnseigneCommerciale AS EnseigneCommerciale_8, t0.DateAgrementCentre AS DateAgrementCentre_9, t0.SurfaceTerrain AS SurfaceTerrain_10, t0.SurfaceZonesCouvertes AS SurfaceZonesCouvertes_11, t0.SurfaceZoneControle AS SurfaceZoneControle_12, t0.SurfaceBureaux AS SurfaceBureaux_13, t0.SurfaceSalleAttente AS SurfaceSalleAttente_14, t0.SurfaceParking AS SurfaceParking_15, t0.NombrePlacesParking AS NombrePlacesParking_16, t0.HauteurPorte AS HauteurPorte_17, t0.NombreLignesDeControle AS NombreLignesDeControle_18, t0.FKAdresseCNPA AS FKAdresseCNPA_19, t0.AdresseFacturationEstAdresseCentre AS AdresseFacturationEstAdresseCentre_20, t0.PL_NumeroAccreditationCentre AS PL_NumeroAccreditationCentre_21, t0.PL_DateAccreditationCentre AS PL_DateAccreditationCentre_22, t0.PL_SurfaceLocalArchives AS PL_SurfaceLocalArchives_23, t0.PL_NombrePlacesParkingEntree AS PL_NombrePlacesParkingEntree_24, t0.PL_NombrePlacesParkingSortie AS PL_NombrePlacesParkingSortie_25, t0.PL_ZoneDeControleLongueur AS PL_ZoneDeControleLongueur_26, t0.PL_ZoneDeControleLargeur AS PL_ZoneDeControleLargeur_27, t0.VL_HauteurPontEtOuFosse AS VL_HauteurPontEtOuFosse_28, t0.FK_VL_AdresseChauffage AS FK_VL_AdresseChauffage_29, t0.FKConciliateur AS FKConciliateur_30, t0.FKSociete AS FKSociete_31, t0.estActif AS estActif_32, t0.CommandeAutorisee AS CommandeAutorisee_33, t0.ID_CentreGroupe AS ID_CentreGroupe_34, t0.DateMiseEnServiceESIControl AS DateMiseEnServiceESIControl_35, t0.DateHeureMajMYSQL AS DateHeureMajMYSQL_36, t0.date_affectation_auditeur AS date_affectation_auditeur_37, t0.FKAdresseCentre AS FKAdresseCentre_38, t39.id AS id_40, t39.numero_compte_comptable AS numero_compte_comptable_41, t39.tarif_pv_reg AS tarif_pv_reg_42, t39.tarif_pv_vol AS tarif_pv_vol_43, t39.remise_expedition_paragon AS remise_expedition_paragon_44, t39.remise_produit AS remise_produit_45, t39.nom_facturation AS nom_facturation_46, t39.logo AS logo_47, t39.mercure_access AS mercure_access_48, t39.contrat AS contrat_49, t39.id_doc_contrant AS id_doc_contrant_50, t39.fichier_contrat AS fichier_contrat_51, t39.duree_contrat AS duree_contrat_52, t39.date_contrat AS date_contrat_53, t39.date_fin_contrat AS date_fin_contrat_54, t39.avenant AS avenant_55, t39.id_doc_avenant AS id_doc_avenant_56, t39.fichier_avenant AS fichier_avenant_57, t39.forfait_avenant AS forfait_avenant_58, t39.date_avenant AS date_avenant_59, t39.date_fin_avenant AS date_fin_avenant_60, t39.maintenance AS maintenance_61, t39.id_doc_maintenance AS id_doc_maintenance_62, t39.fichier_maintenance AS fichier_maintenance_63, t39.duree_maintenance AS duree_maintenance_64, t39.date_maintenance AS date_maintenance_65, t39.date_fin_maintenance AS date_fin_maintenance_66, t39.fichier_annexe AS fichier_annexe_67, t39.date_annexe AS date_annexe_68, t39.date_fin_annexe AS date_fin_annexe_69, t39.tarif_rel2ans_auto AS tarif_rel2ans_auto_70, t39.tarif_rel4ans AS tarif_rel4ans_71, t39.numero_compte_comptable_rel AS numero_compte_comptable_rel_72, t39.mode_reglement_compta AS mode_reglement_compta_73, t39.tarif_rel2ans_cent AS tarif_rel2ans_cent_74, t39.tarif_sms AS tarif_sms_75, t39.tarif_pay_ligne AS tarif_pay_ligne_76, t39.audit_compris AS audit_compris_77, t39.contrat_signe AS contrat_signe_78, t39.duree_contrat_signe AS duree_contrat_signe_79, t39.date_debut_contrat_signe AS date_debut_contrat_signe_80, t39.tvacentre AS tvacentre_81, t39.abs_group AS abs_group_82, t39.Centre AS Centre_83, t39.commercial_contrat_id AS commercial_contrat_id_84, t0.personnel_id AS personnel_id_85 FROM t_centre t0 LEFT JOIN bo_parametre_centre t39 ON t39.Centre = t0.IDCentre WHERE t0.personnel_id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
15.68 ms
(9.82%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.email AS email_4, t0.login AS login_5, t0.password AS password_6, t0.auditeur AS auditeur_7, t0.formateur AS formateur_8, t0.etat AS etat_9, t0.image AS image_10, t0.create_at AS create_at_11, t0.create_by AS create_by_12, t0.comptable AS comptable_13, t0.informatique AS informatique_14, t0.commercial AS commercial_15, t0.hotline AS hotline_16, t0.direction AS direction_17, t0.administratif AS administratif_18, t0.telephone AS telephone_19, t0.id_rise_up AS id_rise_up_20, t0.superviseur_audit AS superviseur_audit_21, t0.initial AS initial_22, t0.fonction_id AS fonction_id_23, t0.FKUser AS FKUser_24 FROM bo_personnel_abs t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace

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\TPlanningtache 8
App\Entity\PersonnelAbs 1
App\Entity\FonctionAbs 1
App\Entity\TUser 1
App\Entity\TPlanningtype 1
App\Entity\TAudit 1

Entities Mapping

Class Mapping errors
App\Entity\PersonnelAbs No errors.
App\Entity\FonctionAbs No errors.
App\Entity\TUser No errors.
App\Entity\DroitsAbs No errors.
App\Entity\FormationSession No errors.
App\Entity\TCentre No errors.
App\Entity\TPlanningtache No errors.
App\Entity\TPlanningtype No errors.
App\Entity\TAudit No errors.
App\Entity\PlannificationDateAuditSuperviseur No errors.
App\Entity\TAudittype No errors.
App\Entity\TContactadresse No errors.
App\Entity\ParametreCentre No errors.
App\Entity\Formation No errors.
App\Entity\FormationInscription
  • The association App\Entity\FormationInscription#User refers to the inverse side field App\Entity\TUser#formationInscriptions which does not exist.
  • The association App\Entity\FormationInscription#Centre refers to the inverse side field App\Entity\TCentre#formationInscriptions which does not exist.