Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Configuration

Query Metrics

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 = ?

[
  2
]

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 = ?

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 = 2;

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

[
  "297"
]

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

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 = '297' ORDER BY t0_.last_activity_at DESC;

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

[
  297
]

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

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 = 297 ORDER BY a0_.created DESC;

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

[
  6
  4
]

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

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 = 6 AND a0_.id > 4 ORDER BY a0_.id ASC;

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 = ?

[
  6
]

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 = ?

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 = 6;

SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_run_status t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  agent_run_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_run_status t0 WHERE t0.id = 3;

SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_skill_type t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  agent_skill_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM agent_skill_type t0 WHERE t0.id = 2;