Query Metrics
16
Database Queries
7
Different statements
2.62 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.40 ms (53.22%) |
10 |
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:
[
33
]
|
|
0.35 ms (13.49%) |
1 |
SELECT p0_.id AS id_0, p0_.intitule AS intitule_1, p0_.domaine AS domaine_2, p0_.duree AS duree_3, p0_.etat AS etat_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.matin_horaire_debut AS matin_horaire_debut_7, p0_.matin_horaire_fin AS matin_horaire_fin_8, p0_.apres_midi_horaire_debut AS apres_midi_horaire_debut_9, p0_.apres_midi_horaire_fin AS apres_midi_horaire_fin_10, p0_.duree_non_compta AS duree_non_compta_11, p0_.facultatif AS facultatif_12, p0_.validation_presences AS validation_presences_13, p0_.demi_journee AS demi_journee_14, p0_.psc1_groupe1 AS psc1_groupe1_15, p0_.psc1_groupe2 AS psc1_groupe2_16, p0_.blocs_id AS blocs_id_17, p0_.formation_id AS formation_id_18, p0_.formateur_id AS formateur_id_19, p0_.salle_id AS salle_id_20 FROM plannings_formations p0_ WHERE p0_.formation_id = ? ORDER BY p0_.date_debut ASC, p0_.demi_journee ASC
Parameters:
[
"87"
]
|
|
0.23 ms (8.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:
[
79
]
|
|
0.20 ms (7.69%) |
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:
[
"87"
]
|
|
0.16 ms (6.13%) |
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:
[
1
]
|
|
0.14 ms (5.44%) |
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:
[
53
]
|
|
0.14 ms (5.41%) |
1 |
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
]
|
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\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\PlagesFormations | No errors. |
| App\Entity\PlanningsTypes | No errors. |
| App\Entity\Agences |
|
| App\Entity\FormateursDisciplines | No errors. |