GET http://fabos.dstei.fr/machines/1/historique

Query Metrics

4 Database Queries
4 Different statements
1.02 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.localisation AS localisation_4, t0.photo AS photo_5, t0.statut AS statut_6, t0.granularite AS granularite_7, t0.categorySlug AS categorySlug_8, t0.categoryLabel AS categoryLabel_9, t0.levelSlug AS levelSlug_10, t0.levelLabel AS levelLabel_11, t0.iconSlug AS iconSlug_12, t0.materials AS materials_13, t0.features AS features_14, t0.requirementTitle AS requirementTitle_15, t0.requirementDescription AS requirementDescription_16, t0.popularity AS popularity_17, t0.limiteReservations AS limiteReservations_18, t0.machineToken AS machineToken_19, t0.createdAt AS createdAt_20, t0.updated AS updated_21, t0.lastAuthorizationTime AS lastAuthorizationTime_22 FROM MACHINE t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.22 ms
SELECT t0.id AS id_1, t0.badgeUid AS badgeUid_2, t0.readerToken AS readerToken_3, t0.authorized AS authorized_4, t0.status AS status_5, t0.reason AS reason_6, t0.message AS message_7, t0.color AS color_8, t0.createdAt AS createdAt_9, t0.userId AS userId_10, t0.machineId AS machineId_11, t0.readerId AS readerId_12 FROM ACCESS_RFID_LOG t0 WHERE t0.machineId = ? ORDER BY t0.createdAt DESC
Parameters:
[
  1
]
3 0.29 ms
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.machineId = ? ORDER BY t0.dateDebut DESC
Parameters:
[
  1
]
4 0.19 ms
SELECT t0.id AS id_1, t0.dateDebut AS dateDebut_2, t0.dateFin AS dateFin_3, t0.motif AS motif_4, t0.statut AS statut_5, t0.created AS created_6, t0.userId AS userId_7, t0.machineId AS machineId_8 FROM RESERVATION t0 WHERE t0.machineId = ? ORDER BY t0.dateDebut DESC
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\Machine 1

Entities Mapping

Class Mapping errors
App\Entity\Machine No errors.
App\Entity\MachineBadge No errors.
App\Entity\AccessRfidLog No errors.
App\Entity\Utilisateur No errors.
App\Entity\RfidReader No errors.
App\Entity\LogUtilisation No errors.
App\Entity\Reservation No errors.