Query Metrics
18
Database Queries
9
Different statements
17.48 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.77 ms (27.28%) |
10 |
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
]
|
|
4.05 ms (23.20%) |
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"
]
|
|
3.85 ms (22.04%) |
1 |
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
]
|
|
3.62 ms (20.69%) |
1 |
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
]
|
|
0.34 ms (1.96%) |
1 |
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 ] |
|
0.34 ms (1.92%) |
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.22 ms (1.25%) |
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.id = ?
Parameters:
[
"1302"
]
|
|
0.15 ms (0.84%) |
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
]
|
|
0.14 ms (0.82%) |
1 |
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
]
|
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 |
|
| 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 |
|
| App\Entity\PlagesFormations | No errors. |
| App\Entity\Agences |
|
| App\Entity\FormateursDisciplines | No errors. |
| App\Entity\SitesInformations | No errors. |