Query Metrics
7
Database Queries
6
Different statements
14.04 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.93 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.person_id AS person_id_7 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
104
]
|
2 | 1.38 ms |
SELECT t0.id AS id_1, t0.station_name AS station_name_2, t0.station_address AS station_address_3, t0.phone_numbers AS phone_numbers_4, t0.created_at AS created_at_5, t0.operating_hrs AS operating_hrs_6, t0.is_mobile AS is_mobile_7, t0.organization_id AS organization_id_8, t0.created_by AS created_by_9 FROM station t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"15"
]
|
3 | 1.26 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
104
]
|
4 | 1.32 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
104
]
|
5 | 0.62 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 1.52 ms |
INSERT INTO delivery (parcel_count, is_cancelled, cancelled_at, is_loaded, loaded_at, is_received, is_received_fully, received_parcels, received_at, created_at, is_verified, origin_station, destination, cancelled_by, loaded_by, received_by, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 0 0 null 0 null 0 0 0 null "2025-03-18 12:02:50" 0 1 15 null null null 104 ] |
7 | 7.00 ms |
"COMMIT"
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\Person | No errors. |
App\Entity\Station | No errors. |
App\Entity\Organization | No errors. |
App\Entity\UserStation | No errors. |
App\Entity\Delivery |
|