Symfony Profiler

[
  "route" => "agent_run_messages"
  "route_parameters" => [
    "_route" => "agent_run_messages"
    "_controller" => "App\Controller\AgentRunController::getMessages"
    "id" => "297"
    "afterId" => "4"
  ]
  "request_uri" => "http://mgr2.managedhosting.partners/ticket/297/agent/messages/after/4"
  "method" => "GET"
]

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

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

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "host" => "mhp-ri-202602-cluster.cluster-chimqudqxxd8.ap-southeast-2.rds.amazonaws.com"
    "port" => 3306
    "user" => "www_mgr2"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "mgr2_managedhosting_partners"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.reset_token AS reset_token_7, t0.display_timezone AS display_timezone_8, t0.notify_staging_refresh AS notify_staging_refresh_9, t0.notify_staging_update AS notify_staging_update_10, t0.default_response_preference AS default_response_preference_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "jd@managedhosting.partners"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DebugHandlersListener::configure"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ValidateRequestListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::setDefaultLocale"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelRequest"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::configureLogoutUrlGenerator"
]

[
  "event" => "kernel.request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelRequest"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Bundle\FrameworkBundle\DataCollector\RouterDataCollector::onKernelController"
]

[
  "event" => "kernel.controller"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelController"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.status AS status_3, t0_.created AS created_4, t0_.source AS source_5, t0_.from_email AS from_email_6, t0_.from_name AS from_name_7, t0_.email_message_id AS email_message_id_8, t0_.last_activity_at AS last_activity_at_9, t0_.assigned_to_id AS assigned_to_id_10, t0_.client_user_id AS client_user_id_11, t0_.company_id AS company_id_12 FROM ticket t0_ LEFT JOIN user u1_ ON t0_.client_user_id = u1_.id LEFT JOIN company c2_ ON u1_.company_id = c2_.id WHERE t0_.id = ? ORDER BY t0_.last_activity_at DESC"
  "params" => [
    1 => "297"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\Security\Http\EventListener\IsGrantedAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelControllerArguments"
]

[
  "event" => "kernel.controller_arguments"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::onControllerArguments"
]

[
  "event" => "debug.security.authorization.vote"
  "listener" => "Symfony\Bundle\SecurityBundle\EventListener\VoteListener::onVoterVote"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.sqs_queue_url AS sqs_queue_url_1, a0_.fargate_task_arn AS fargate_task_arn_2, a0_.skill_payload AS skill_payload_3, a0_.created AS created_4, a0_.updated AS updated_5, a0_.ticket_id AS ticket_id_6, a0_.skill_type_id AS skill_type_id_7, a0_.status_id AS status_id_8, a0_.started_by_id AS started_by_id_9 FROM agent_run a0_ WHERE a0_.ticket_id = ? ORDER BY a0_.created DESC"
  "params" => [
    1 => 297
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.content AS content_1, a0_.created AS created_2, a0_.agent_run_id AS agent_run_id_3, a0_.role_id AS role_id_4, a0_.message_type_id AS message_type_id_5 FROM agent_message a0_ INNER JOIN agent_message_role a1_ ON a0_.role_id = a1_.id INNER JOIN agent_message_type a2_ ON a0_.message_type_id = a2_.id WHERE a0_.agent_run_id = ? AND a0_.id > ? ORDER BY a0_.id ASC"
  "params" => [
    1 => 6
    2 => 4
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.sqs_queue_url AS sqs_queue_url_2, t0.fargate_task_arn AS fargate_task_arn_3, t0.skill_payload AS skill_payload_4, t0.created AS created_5, t0.updated AS updated_6, t0.ticket_id AS ticket_id_7, t0.skill_type_id AS skill_type_id_8, t0.status_id AS status_id_9, t0.started_by_id AS started_by_id_10 FROM agent_run t0 WHERE t0.id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_run_status t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_skill_type t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "_security_main"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\AssetMapper\AssetMapperDevServerSubscriber::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\Security\Http\Firewall\ContextListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ResponseListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\DataCollector\RequestDataCollector::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\CacheAttributeListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ProfilerListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\ErrorListener::removeCspHeader"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Bundle\WebProfilerBundle\EventListener\WebDebugToolbarListener::onKernelResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\DisallowRobotsIndexingListener::onResponse"
]

[
  "event" => "kernel.response"
  "listener" => "Symfony\Component\HttpKernel\EventListener\SessionListener::onKernelResponse"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\RouterListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener::onKernelFinishRequest"
]

[
  "event" => "kernel.finish_request"
  "listener" => "Symfony\Component\HttpKernel\EventListener\LocaleAwareListener::onKernelFinishRequest"
]