Query Metrics
1
Database Queries
1
Different statements
0.64 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.64 ms |
SELECT a0_.id AS id_0, a0_.scheduled_date AS scheduled_date_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.direction AS direction_4, a0_.status AS status_5, a0_.po_number AS po_number_6, a0_.trailer_number AS trailer_number_7, a0_.driver_name AS driver_name_8, a0_.unit_count AS unit_count_9, a0_.unit_type AS unit_type_10, a0_.notes AS notes_11, a0_.created_at AS created_at_12, a0_.checked_in_at AS checked_in_at_13, a0_.completed_at AS completed_at_14, d1_.id AS id_15, d1_.door_number AS door_number_16, d1_.label AS label_17, d1_.type AS type_18, d1_.status AS status_19, d1_.has_leveler AS has_leveler_20, d1_.temp_controlled AS temp_controlled_21, d1_.max_trailer_length_ft AS max_trailer_length_ft_22, d1_.notes AS notes_23, c2_.id AS id_24, c2_.name AS name_25, c2_.scac_code AS scac_code_26, c2_.contact_name AS contact_name_27, c2_.contact_email AS contact_email_28, c2_.contact_phone AS contact_phone_29, c2_.active AS active_30, c2_.notes AS notes_31, a0_.dock_door_id AS dock_door_id_32, a0_.carrier_id AS carrier_id_33 FROM appointments a0_ INNER JOIN dock_doors d1_ ON a0_.dock_door_id = d1_.id INNER JOIN carriers c2_ ON a0_.carrier_id = c2_.id WHERE a0_.scheduled_date = ? ORDER BY a0_.start_time ASC, d1_.door_number ASC
Parameters:
[
"2026-04-02"
]
|
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Appointment | No errors. |
| App\Entity\DockDoor | No errors. |
| App\Entity\Carrier | No errors. |