Symfony Profiler

[
  "route" => "app_carrier_show"
  "route_parameters" => [
    "_route" => "app_carrier_show"
    "_controller" => "App\Controller\CarrierController::show"
    "id" => "6"
  ]
  "request_uri" => "https://dockman.verdefulfillmentusa.com/carriers/6"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "host" => "127.0.0.1"
    "port" => 3386
    "dbname" => "dockscheduler"
    "user" => "dockman"
    "password" => "<redacted>"
    "charset" => "utf8mb4"
    "idle_connection_ttl" => 600
    "driverOptions" => []
    "serverVersion" => "8.0"
    "defaultTableOptions" => []
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 32
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "asmith"
]

[
  "sql" => "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"
  "params" => [
    1 => "dbe09210cc0728cb2cddc18e"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#789
      +name: "STRING"
    }
  ]
]

[
  "sql" => "UPDATE user_sessions SET last_active_at = ? WHERE id = ?"
  "params" => [
    1 => "2026-05-27 21:00:18"
    2 => 29
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#789
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "token" => Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken {#824
    -user: App\Entity\User {#527 …}
    -roleNames: [
      "ROLE_USER"
      "ROLE_LOCATION_MANAGER"
      "ROLE_SCHEDULER"
      "ROLE_DOCK_WORKER"
    ]
    -attributes: []
    -firewallName: "main"
  }
  "authenticator" => "App\Security\SessionAuthenticator"
]

[
  "authenticator" => "App\Security\SessionAuthenticator"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "6"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#520
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]