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

Query Metrics

5 Database Queries
5 Different statements
1.31 ms Query time
0 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.41 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.20 ms
SELECT t0.id AS id_1, t0.requiredForAccess AS requiredForAccess_2, t0.createdAt AS createdAt_3, t0.machineId AS machineId_4, t0.badgeId AS badgeId_5 FROM MACHINE_BADGE t0 WHERE t0.machineId = ?
Parameters:
[
  1
]
3 0.28 ms
SELECT COUNT(*) FROM ACCESS_RFID_LOG t0 WHERE t0.machineId = ?
Parameters:
[
  1
]
4 0.26 ms
SELECT COUNT(*) FROM LOG_UTILISATION t0 WHERE t0.machineId = ?
Parameters:
[
  1
]
5 0.16 ms
SELECT COUNT(*) FROM RESERVATION t0 WHERE t0.machineId = ?
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\Badge No errors.
App\Entity\AccessRfidLog No errors.
App\Entity\LogUtilisation No errors.
App\Entity\Reservation No errors.