GET http://fabos.dstei.fr/leaderboard

Query Metrics

11 Database Queries
8 Different statements
2.12 ms Query time
0 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.42 ms
(19.74%)
2
SELECT t0.id AS id_1, t0.dateDebut AS dateDebut_2, t0.dateFin AS dateFin_3, t0.duree AS duree_4, t0.source AS source_5, t0.createdAt AS createdAt_6, t0.machineId AS machineId_7, t0.userId AS userId_8 FROM LOG_UTILISATION t0 WHERE t0.userId = ?
Parameters:
[
  1
]
0.39 ms
(18.22%)
2
SELECT COUNT(*) FROM PROGRESSION t0 WHERE t0.userId = ? AND t0.completed = ?
Parameters:
[
  1
  1
]
0.38 ms
(17.99%)
1
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 ORDER BY t0.tempsPresenceTotal DESC LIMIT 20
Parameters:
[]
0.37 ms
(17.37%)
2
SELECT COUNT(*) FROM UTILISATEUR_BADGE t0 WHERE t0.utilisateurId = ?
Parameters:
[
  1
]
0.15 ms
(7.09%)
1
SELECT COUNT(*) FROM FORMATION t0
Parameters:
[]
0.14 ms
(6.65%)
1
SELECT COUNT(*) FROM MACHINE t0
Parameters:
[]
0.14 ms
(6.52%)
1
SELECT COUNT(*) FROM RESERVATION t0
Parameters:
[]
0.14 ms
(6.42%)
1
SELECT COUNT(*) FROM UTILISATEUR t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Utilisateur 2

Entities Mapping