Query Metrics
12
Database Queries
12
Different statements
2.68 ms
Query time
3
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.52 ms (19.59%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.33 ms (12.30%) |
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 = ? AND s0_.id IN (?)
Parameters:
[ 1 [ "2" ] ] |
|
0.27 ms (10.20%) |
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.23 ms (8.63%) |
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 = ?) AND f0_.id IN (?) ORDER BY f0_.nom ASC, f0_.prenom ASC
Parameters:
[ 74 1 [ "25" ] ] |
|
0.23 ms (8.52%) |
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:
[
"1306"
]
|
|
0.22 ms (8.04%) |
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.21 ms (7.74%) |
1 |
UPDATE plannings_formations SET date_debut = ?, matin_horaire_debut = ?, matin_horaire_fin = ?, apres_midi_horaire_debut = ?, apres_midi_horaire_fin = ? WHERE id = ?
Parameters:
[ "2026-05-11" "09:15:00" "12:15:00" "13:30:00" "16:30:00" 1306 ] |
|
0.17 ms (6.21%) |
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:
[
25
]
|
|
0.15 ms (5.76%) |
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
]
|
|
0.15 ms (5.46%) |
1 |
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.etat AS etat_3 FROM formateurs_disciplines t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
0.15 ms (5.45%) |
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.06 ms (2.09%) |
1 |
"START TRANSACTION"
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\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. |