Query Metrics
26
Database Queries
24
Different statements
10.33 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.16 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:
[
68
]
|
2 | 0.32 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:
[
"64"
]
|
3 | 0.30 ms |
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
]
|
4 | 2.13 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.formation_id = ? ORDER BY t0.date_debut ASC
Parameters:
[
64
]
|
5 | 0.32 ms |
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:
[] |
6 | 0.29 ms |
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:
[] |
7 | 0.36 ms |
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:
[] |
8 | 0.21 ms |
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:
[] |
9 | 0.19 ms |
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:
[] |
10 | 0.15 ms |
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:
[] |
11 | 0.20 ms |
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:
[] |
12 | 0.17 ms |
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:
[] |
13 | 0.20 ms |
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:
[] |
14 | 0.15 ms |
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:
[] |
15 | 0.14 ms |
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:
[] |
16 | 0.15 ms |
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:
[] |
17 | 0.17 ms |
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:
[] |
18 | 0.16 ms |
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:
[] |
19 | 0.17 ms |
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:
[] |
20 | 0.12 ms |
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:
[] |
21 | 0.18 ms |
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:
[] |
22 | 0.13 ms |
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:
[] |
23 | 0.25 ms |
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
]
|
24 | 0.21 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:
[
30
]
|
25 | 0.26 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:
[
24
]
|
26 | 0.23 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:
[
57
]
|
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. |