Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Mercure
• Configuration

Query Metrics

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.is_private AS is_private_3, r0_.password AS password_4, r0_.created_at AS created_at_5, r0_.owner_id AS owner_id_6 FROM room r0_ WHERE r0_.is_private = ? ORDER BY r0_.created_at DESC LIMIT 10

[
  0
]

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.slug AS slug_2,
  r0_.is_private AS is_private_3,
  r0_.password AS password_4,
  r0_.created_at AS created_at_5,
  r0_.owner_id AS owner_id_6
FROM
  room r0_
WHERE
  r0_.is_private = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  10

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.slug AS slug_2, r0_.is_private AS is_private_3, r0_.password AS password_4, r0_.created_at AS created_at_5, r0_.owner_id AS owner_id_6 FROM room r0_ WHERE r0_.is_private = 0 ORDER BY r0_.created_at DESC LIMIT 10;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM "user" t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5
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.username AS username_5 FROM "user" t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM "user" t0 INNER JOIN room_user ON t0.id = room_user.user_id WHERE room_user.room_id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5
FROM
  "user" t0
  INNER JOIN room_user ON t0.id = room_user.user_id
WHERE
  room_user.room_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5 FROM "user" t0 INNER JOIN room_user ON t0.id = room_user.user_id WHERE room_user.room_id = 2;