https://www.ama64.fr/formations/afficher/presences/64

Query Metrics

26 Database Queries
24 Different statements
10.33 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.16 ms
(30.61%)
1
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:
[
  68
]
2.13 ms
(20.67%)
1
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.formation_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
  64
]
0.69 ms
(6.64%)
3
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:
[
  30
]
0.36 ms
(3.53%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 994 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.32 ms
(3.09%)
1
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:
[
  "64"
]
0.32 ms
(3.07%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 993 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.30 ms
(2.90%)
1
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.colors AS colors_3 FROM formations_etats t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.29 ms
(2.84%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 993
Parameters:
[]
0.25 ms
(2.37%)
1
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.nbre_heures AS nbre_heures_3, t0.etat AS etat_4, t0.num_bloc AS num_bloc_5 FROM blocs t0 WHERE t0.id = ?
Parameters:
[
  54
]
0.21 ms
(2.02%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 994
Parameters:
[]
0.20 ms
(1.96%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 990 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.20 ms
(1.93%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 992 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.19 ms
(1.79%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 989 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.18 ms
(1.77%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 995 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.17 ms
(1.69%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 991 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.17 ms
(1.64%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 990
Parameters:
[]
0.17 ms
(1.63%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 988 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.16 ms
(1.54%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 991
Parameters:
[]
0.15 ms
(1.50%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 987
Parameters:
[]
0.15 ms
(1.47%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 992
Parameters:
[]
0.15 ms
(1.45%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 989
Parameters:
[]
0.14 ms
(1.40%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 987 AND p0_.presences = 2 AND p0_.etat = 1
Parameters:
[]
0.13 ms
(1.29%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 995
Parameters:
[]
0.12 ms
(1.20%)
1
SELECT p0_.id AS id_0, p0_.date_creation AS date_creation_1, p0_.etat AS etat_2, p0_.presences AS presences_3, p0_.demi_journee AS demi_journee_4, p0_.justification AS justification_5, p0_.duree AS duree_6, p0_.psc1_groupe AS psc1_groupe_7, p0_.planning_id AS planning_id_8, p0_.stagiaire_id AS stagiaire_id_9, p0_.absence_justification_id AS absence_justification_id_10 FROM plages_formations p0_ WHERE p0_.planning_id = 988
Parameters:
[]

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\Sites No errors.
App\Entity\Formations No errors.
App\Entity\PlanningsFormations
  • The mappings App\Entity\PlanningsFormations#salle and App\Entity\Salles#planningFormation are inconsistent with each other.
App\Entity\FormationsEtats No errors.
App\Entity\PlagesFormations No errors.
App\Entity\Blocs No errors.
App\Entity\Formateurs 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\Stagiaires No errors.
App\Entity\PlagesFormationsMotifsAbsences No errors.
App\Entity\PlanningsTypes 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.