Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 2
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• Debug
• Configuration

Query Metrics

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.is_private AS is_private_3, u0_.is_locked AS is_locked_4, u0_.linked_type AS linked_type_5, u0_.linked_id AS linked_id_6, u0_.linked_ref AS linked_ref_7, u0_.created_at AS created_at_8, u0_.last_message_at AS last_message_at_9, u1_.id AS id_10, u1_.joined_at AS joined_at_11, u1_.last_read_at AS last_read_at_12, u1_.is_admin AS is_admin_13, u0_.created_by_id AS created_by_id_14, u1_.room_id AS room_id_15, u1_.user_id AS user_id_16 FROM user_chat_room u0_ LEFT JOIN user_chat_participant u1_ ON u0_.id = u1_.room_id AND (u1_.user_id = ?) WHERE u0_.is_private = 0 OR u1_.id IS NOT NULL ORDER BY u0_.last_message_at DESC, u0_.created_at DESC

[
  1
]

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.description AS description_2,
  u0_.is_private AS is_private_3,
  u0_.is_locked AS is_locked_4,
  u0_.linked_type AS linked_type_5,
  u0_.linked_id AS linked_id_6,
  u0_.linked_ref AS linked_ref_7,
  u0_.created_at AS created_at_8,
  u0_.last_message_at AS last_message_at_9,
  u1_.id AS id_10,
  u1_.joined_at AS joined_at_11,
  u1_.last_read_at AS last_read_at_12,
  u1_.is_admin AS is_admin_13,
  u0_.created_by_id AS created_by_id_14,
  u1_.room_id AS room_id_15,
  u1_.user_id AS user_id_16
FROM
  user_chat_room u0_
  LEFT JOIN user_chat_participant u1_ ON u0_.id = u1_.room_id
  AND (u1_.user_id = ?)
WHERE
  u0_.is_private = 0
  OR u1_.id IS NOT NULL
ORDER BY
  u0_.last_message_at DESC,
  u0_.created_at DESC

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.description AS description_2, u0_.is_private AS is_private_3, u0_.is_locked AS is_locked_4, u0_.linked_type AS linked_type_5, u0_.linked_id AS linked_id_6, u0_.linked_ref AS linked_ref_7, u0_.created_at AS created_at_8, u0_.last_message_at AS last_message_at_9, u1_.id AS id_10, u1_.joined_at AS joined_at_11, u1_.last_read_at AS last_read_at_12, u1_.is_admin AS is_admin_13, u0_.created_by_id AS created_by_id_14, u1_.room_id AS room_id_15, u1_.user_id AS user_id_16 FROM user_chat_room u0_ LEFT JOIN user_chat_participant u1_ ON u0_.id = u1_.room_id AND (u1_.user_id = 1) WHERE u0_.is_private = 0 OR u1_.id IS NOT NULL ORDER BY u0_.last_message_at DESC, u0_.created_at DESC;

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.legacy_id AS legacy_id_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.last_seen_at AS last_seen_at_11, t0.phone AS phone_12, t0.dashboard_type AS dashboard_type_13, t0.seen_version_id AS seen_version_id_14, t0.calendar_slot_min AS calendar_slot_min_15, t0.calendar_slot_max AS calendar_slot_max_16, t0.work_hours_start AS work_hours_start_17, t0.work_hours_end AS work_hours_end_18 FROM `user` t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.legacy_id AS legacy_id_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.last_login_at AS last_login_at_10,
  t0.last_seen_at AS last_seen_at_11,
  t0.phone AS phone_12,
  t0.dashboard_type AS dashboard_type_13,
  t0.seen_version_id AS seen_version_id_14,
  t0.calendar_slot_min AS calendar_slot_min_15,
  t0.calendar_slot_max AS calendar_slot_max_16,
  t0.work_hours_start AS work_hours_start_17,
  t0.work_hours_end AS work_hours_end_18
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.roles AS roles_5, t0.password AS password_6, t0.legacy_id AS legacy_id_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.last_seen_at AS last_seen_at_11, t0.phone AS phone_12, t0.dashboard_type AS dashboard_type_13, t0.seen_version_id AS seen_version_id_14, t0.calendar_slot_min AS calendar_slot_min_15, t0.calendar_slot_max AS calendar_slot_max_16, t0.work_hours_start AS work_hours_start_17, t0.work_hours_end AS work_hours_end_18 FROM `user` t0 WHERE t0.id = 1;