Query Metrics
10
Database Queries
10
Different statements
9.60 ms
Query time
1
Invalid entities
9
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.81 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.name AS name_3, t0.email AS email_4, t0.password AS password_5, t0.microsoft_id AS microsoft_id_6, t0.require_password_reset AS require_password_reset_7, t0.active AS active_8, t0.last_login_at AS last_login_at_9, t0.created_at AS created_at_10 FROM users t0 WHERE t0.id = ?
Parameters:
[
32
]
|
| 2 | 0.71 ms |
SELECT t0.id AS id_1, t0.role AS role_2, t0.user_id AS user_id_3, t0.location_id AS location_id_4 FROM user_roles t0 WHERE t0.user_id = ?
Parameters:
[
32
]
|
| 3 | 0.51 ms |
SELECT t0.id AS id_1, t0.selector AS selector_2, t0.hashed_verifier AS hashed_verifier_3, t0.ip_address AS ip_address_4, t0.user_agent AS user_agent_5, t0.auth_method AS auth_method_6, t0.created_at AS created_at_7, t0.last_active_at AS last_active_at_8, t0.expires_at AS expires_at_9, t0.last_secure_op_at AS last_secure_op_at_10, t0.remembered AS remembered_11, t0.user_id AS user_id_12 FROM user_sessions t0 WHERE t0.selector = ? LIMIT 1
Parameters:
[
"dbe09210cc0728cb2cddc18e"
]
|
| 4 | 0.36 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 0.83 ms |
UPDATE user_sessions SET last_active_at = ? WHERE id = ?
Parameters:
[ "2026-05-27 21:00:18" 29 ] |
| 6 | 4.44 ms |
"COMMIT"
Parameters:
[] |
| 7 | 0.51 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.scac_code AS scac_code_3, t0.contact_name AS contact_name_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.active AS active_7, t0.notes AS notes_8 FROM carriers t0 WHERE t0.id = ?
Parameters:
[
"6"
]
|
| 8 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.address AS address_4, t0.city AS city_5, t0.state AS state_6, t0.zip AS zip_7, t0.active AS active_8 FROM locations t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 9 | 0.57 ms |
SELECT t0.id AS id_1, t0.scheduled_date AS scheduled_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.direction AS direction_5, t0.status AS status_6, t0.trailer_number AS trailer_number_7, t0.load_type AS load_type_8, t0.weight_lbs AS weight_lbs_9, t0.origin_name AS origin_name_10, t0.origin_zip AS origin_zip_11, t0.destination_name AS destination_name_12, t0.destination_zip AS destination_zip_13, t0.notes AS notes_14, t0.created_at AS created_at_15, t0.checked_in_at AS checked_in_at_16, t0.completed_at AS completed_at_17, t0.location_id AS location_id_18, t0.dock_door_id AS dock_door_id_19, t0.carrier_id AS carrier_id_20 FROM appointments t0 WHERE t0.carrier_id = ?
Parameters:
[
6
]
|
| 10 | 0.40 ms |
SELECT t0.id AS id_1, t0.door_number AS door_number_2, t0.label AS label_3, t0.type AS type_4, t0.status AS status_5, t0.has_leveler AS has_leveler_6, t0.temp_controlled AS temp_controlled_7, t0.max_trailer_length_ft AS max_trailer_length_ft_8, t0.notes AS notes_9, t0.location_id AS location_id_10 FROM dock_doors t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Appointment | 3 |
| App\Entity\User | 1 |
| App\Entity\UserRole | 1 |
| App\Entity\Location | 1 |
| App\Entity\UserSession | 1 |
| App\Entity\Carrier | 1 |
| App\Entity\DockDoor | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\UserRole | No errors. |
| App\Entity\UserSession | No errors. |
| App\Entity\Token | No errors. |
| App\Entity\Invitation | No errors. |
| App\Entity\UserMfaMethod | No errors. |
| App\Entity\Location |
|
| App\Entity\Carrier | No errors. |
| App\Entity\Appointment | No errors. |
| App\Entity\DockDoor | No errors. |
| App\Entity\SystemConfig | No errors. |
| App\Entity\AppointmentReference | No errors. |
| App\Entity\AppointmentUnitCount | No errors. |
| App\Entity\AppointmentLog | No errors. |
| App\Entity\AppointmentDocument | No errors. |