https://ama64.gca-digital.fr/formations/plannings/modifier/87/1302

Query Metrics

18 Database Queries
9 Different statements
17.48 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.34 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.organisation AS organisation_7, t0.etat AS etat_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  79
]
2 4.05 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.etat AS etat_5, t0.heure_convoc1er_jour AS heure_convoc1er_jour_6, t0.site_id AS site_id_7, t0.bloc_id AS bloc_id_8, t0.referent_id AS referent_id_9, t0.formateur_referent_id AS formateur_referent_id_10, t0.cfc_id AS cfc_id_11, t0.assistant_id AS assistant_id_12, t0.proviseurs_id AS proviseurs_id_13 FROM formations t0 WHERE t0.id = ?
Parameters:
[
  "87"
]
3 0.22 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.domaine AS domaine_3, t0.duree AS duree_4, t0.etat AS etat_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.matin_horaire_debut AS matin_horaire_debut_8, t0.matin_horaire_fin AS matin_horaire_fin_9, t0.apres_midi_horaire_debut AS apres_midi_horaire_debut_10, t0.apres_midi_horaire_fin AS apres_midi_horaire_fin_11, t0.duree_non_compta AS duree_non_compta_12, t0.facultatif AS facultatif_13, t0.validation_presences AS validation_presences_14, t0.demi_journee AS demi_journee_15, t0.psc1_groupe1 AS psc1_groupe1_16, t0.psc1_groupe2 AS psc1_groupe2_17, t0.blocs_id AS blocs_id_18, t0.formation_id AS formation_id_19, t0.formateur_id AS formateur_id_20, t0.salle_id AS salle_id_21 FROM plannings_formations t0 WHERE t0.id = ?
Parameters:
[
  "1302"
]
4 3.85 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.etat AS etat_4, t0.email AS email_5, t0.affichage_agences_toutes AS affichage_agences_toutes_6, t0.agence_id AS agence_id_7, t0.discipline_id AS discipline_id_8 FROM formateurs t0 WHERE t0.id = ?
Parameters:
[
  59
]
5 0.15 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  10
]
6 0.14 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.google_map AS google_map_7, t0.etat AS etat_8, t0.map AS map_9, t0.observations AS observations_10, t0.agence_id AS agence_id_11 FROM sites t0 WHERE t0.id = ?
Parameters:
[
  89
]
7 0.15 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3, t0.site_id AS site_id_4 FROM salles t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 3.62 ms
SELECT s0_.id AS id_0, s0_.intitule AS intitule_1, s0_.etat AS etat_2, s0_.site_id AS site_id_3 FROM salles s0_ WHERE s0_.site_id = 89 AND s0_.etat = ?
Parameters:
[
  1
]
9 0.34 ms
SELECT f0_.id AS id_0, f0_.nom AS nom_1, f0_.prenom AS prenom_2, f0_.etat AS etat_3, f0_.email AS email_4, f0_.affichage_agences_toutes AS affichage_agences_toutes_5, f0_.agence_id AS agence_id_6, f0_.discipline_id AS discipline_id_7 FROM formateurs f0_ LEFT JOIN agences a1_ ON f0_.agence_id = a1_.id WHERE a1_.id = ? OR f0_.affichage_agences_toutes = ? ORDER BY f0_.nom ASC, f0_.prenom ASC
Parameters:
[
  74
  1
]
10 0.14 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  7
]
11 0.12 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  12
]
12 0.13 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  9
]
13 0.11 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  16
]
14 3.66 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  15
]
15 0.12 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  8
]
16 0.11 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  17
]
17 0.11 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  11
]
18 0.12 ms
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
  13
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\PlanningsFormations
  • The mappings App\Entity\PlanningsFormations#salle and App\Entity\Salles#planningFormation are inconsistent with each other.
App\Entity\Formateurs No errors.
App\Entity\Formations No errors.
App\Entity\Sites No errors.
App\Entity\Blocs No errors.
App\Entity\CFC No errors.
App\Entity\Assistants No errors.
App\Entity\Proviseurs No errors.
App\Entity\Convocations No errors.
App\Entity\InscriptionsFormations No errors.
App\Entity\Evaluations No errors.
App\Entity\StagiairesAbsences No errors.
App\Entity\Salles
  • The association App\Entity\Salles#planningFormation refers to the owning side field App\Entity\PlanningsFormations#salles which does not exist.
App\Entity\PlagesFormations No errors.
App\Entity\Agences
  • The association App\Entity\Agences#stagiaires refers to the owning side field App\Entity\Stagiaires#agences which does not exist.
App\Entity\FormateursDisciplines No errors.
App\Entity\SitesInformations No errors.