Query Metrics
16
Database Queries
7
Different statements
2.62 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.23 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:
[
79
]
|
| 2 | 0.20 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:
[
"87"
]
|
| 3 | 0.16 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:
[
1
]
|
| 4 | 0.35 ms |
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"
]
|
| 5 | 0.14 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:
[
53
]
|
| 6 | 0.14 ms |
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
]
|
| 7 | 0.14 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:
[
33
]
|
| 8 | 0.15 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:
[
35
]
|
| 9 | 0.14 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:
[
37
]
|
| 10 | 0.14 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:
[
65
]
|
| 11 | 0.14 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:
[
54
]
|
| 12 | 0.14 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:
[
59
]
|
| 13 | 0.14 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:
[
25
]
|
| 14 | 0.13 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:
[
40
]
|
| 15 | 0.13 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:
[
41
]
|
| 16 | 0.15 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:
[
45
]
|
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. |