Query Metrics
5
Database Queries
5
Different statements
2.78 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.20 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 2 | 0.37 ms |
SELECT DISTINCT v0_.id AS id_0, v0_.entered_at AS entered_at_1 FROM vehicle_on_site v0_ ORDER BY v0_.entered_at DESC LIMIT 20
Parameters:
[] |
| 3 | 0.56 ms |
SELECT v0_.id AS id_0, v0_.license_plate AS license_plate_1, v0_.entered_at AS entered_at_2, v0_.departed_at AS departed_at_3, v0_.entry_camera AS entry_camera_4, v0_.exit_camera AS exit_camera_5, v0_.owner_first_name AS owner_first_name_6, v0_.owner_last_name AS owner_last_name_7, v0_.owner_patronymic AS owner_patronymic_8, v0_.additional_info AS additional_info_9, v0_.macroscop_car_id AS macroscop_car_id_10, v0_.manually_confirmed_departed AS manually_confirmed_departed_11, v0_.manually_confirmed_departed_at AS manually_confirmed_departed_at_12, v0_.manual_confirm_note AS manual_confirm_note_13, v0_.metadata AS metadata_14, v0_.last_event_id AS last_event_id_15, v0_.created_at AS created_at_16, v0_.updated_at AS updated_at_17 FROM vehicle_on_site v0_ WHERE v0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY v0_.entered_at DESC
Parameters:
[ 20 19 18 17 16 15 14 13 12 11 10 9 8 7 6 5 4 3 2 ] |
| 4 | 0.28 ms |
SELECT count(v0_.id) AS sclr_0 FROM vehicle_on_site v0_
Parameters:
[] |
| 5 | 0.38 ms |
SELECT COUNT(*) FROM email_recipients_send 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\VehicleOnSite | No errors. |
| App\Entity\EmailRecipientsSend | No errors. |