Query Metrics
4
Database Queries
4
Different statements
1.02 ms
Query time
0
Invalid entities
1
Managed entities
Queries
| #▲ | 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. |