Query Metrics
26
Database Queries
24
Different statements
10.33 ms
Query time
3
Invalid entities
Grouped Statements
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 |
|
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 |
|
App\Entity\Stagiaires | No errors. |
App\Entity\PlagesFormationsMotifsAbsences | No errors. |
App\Entity\PlanningsTypes | No errors. |
App\Entity\Agences |
|
App\Entity\FormateursDisciplines | No errors. |