GET http://fabos.dstei.fr/formations/1

Query Metrics

6 Database Queries
5 Different statements
1.43 ms Query time
0 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 0.32 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image AS image_4, t0.categorie AS categorie_5, t0.niveau AS niveau_6, t0.duree AS duree_7, t0.formateur AS formateur_8, t0.placesTotales AS placesTotales_9, t0.objectifs AS objectifs_10, t0.prerequis AS prerequis_11, t0.materielFourni AS materielFourni_12, t0.badgeId AS badgeId_13 FROM FORMATION t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.27 ms
SELECT t0.id AS id_1, t0.score AS score_2, t0.completed AS completed_3, t0.dateDebut AS dateDebut_4, t0.dateEnd AS dateEnd_5, t0.userId AS userId_6, t0.formationId AS formationId_7 FROM PROGRESSION t0 WHERE t0.formationId = ? ORDER BY t0.dateDebut DESC
Parameters:
[
  1
]
3 0.17 ms
SELECT t0.id AS id_1, t0.score AS score_2, t0.completed AS completed_3, t0.dateDebut AS dateDebut_4, t0.dateEnd AS dateEnd_5, t0.userId AS userId_6, t0.formationId AS formationId_7 FROM PROGRESSION t0
Parameters:
[]
4 0.25 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.firstName AS firstName_5, t0.lastName AS lastName_6, t0.numeroId AS numeroId_7, t0.statut AS statut_8, t0.identifiantRfid AS identifiantRfid_9, t0.tempsPresenceTotal AS tempsPresenceTotal_10, t0.isVerified AS isVerified_11, t0.createdAt AS createdAt_12, t0.derniereConnexion AS derniereConnexion_13, t0.notificationEmail AS notificationEmail_14, t0.notificationPush AS notificationPush_15, t0.rappelReservation AS rappelReservation_16, t0.theme AS theme_17, t0.langue AS langue_18 FROM UTILISATEUR t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.26 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.firstName AS firstName_5, t0.lastName AS lastName_6, t0.numeroId AS numeroId_7, t0.statut AS statut_8, t0.identifiantRfid AS identifiantRfid_9, t0.tempsPresenceTotal AS tempsPresenceTotal_10, t0.isVerified AS isVerified_11, t0.createdAt AS createdAt_12, t0.derniereConnexion AS derniereConnexion_13, t0.notificationEmail AS notificationEmail_14, t0.notificationPush AS notificationPush_15, t0.rappelReservation AS rappelReservation_16, t0.theme AS theme_17, t0.langue AS langue_18 FROM UTILISATEUR t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.icone AS icone_4, t0.createdAt AS createdAt_5 FROM BADGE t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Progression 2
App\Entity\Utilisateur 2
App\Entity\Formation 1
App\Entity\Badge 1

Entities Mapping

Class Mapping errors
App\Entity\Formation No errors.
App\Entity\Badge No errors.
App\Entity\Progression No errors.
App\Entity\Utilisateur No errors.
App\Entity\UtilisateurRole No errors.
App\Entity\MachineBadge No errors.