GET https://dockman.verdefulfillmentusa.com/carriers/6

Query Metrics

10 Database Queries
10 Different statements
9.60 ms Query time
1 Invalid entities
9 Managed entities

Queries

Group similar statements

# 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
  • The association App\Entity\Location#configs refers to the owning side field App\Entity\SystemConfig#location which does not exist.
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.