Symfony Profiler

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

Query Metrics

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.status AS status_2, m1_.id AS id_3, m1_.lastname AS lastname_4, m1_.firstname AS firstname_5, c2_.shortcut AS shortcut_6, GROUP_CONCAT(m3_.identifier SEPARATOR ', ') AS sclr_7 FROM member_license m0_ INNER JOIN `member` m1_ ON (m1_.id = m0_.member_id) INNER JOIN club c2_ ON (c2_.id = m0_.club_id) LEFT JOIN member_transponders m3_ ON (m3_.member_id = m0_.member_id) WHERE m0_.status = ? AND m0_.valid_from = ? AND m0_.valid_until = ? GROUP BY m0_.id, m0_.code, m1_.id, m1_.lastname, m1_.firstname, c2_.shortcut ORDER BY c2_.shortcut ASC, m1_.lastname ASC

[
  2
  "2025-06-01"
  "2026-05-31"
]

SELECT
  m0_.id AS id_0,
  m0_.code AS code_1,
  m0_.status AS status_2,
  m1_.id AS id_3,
  m1_.lastname AS lastname_4,
  m1_.firstname AS firstname_5,
  c2_.shortcut AS shortcut_6,
  GROUP_CONCAT(m3_.identifier SEPARATOR ', ') AS sclr_7
FROM
  member_license m0_
  INNER JOIN `member` m1_ ON (m1_.id = m0_.member_id)
  INNER JOIN club c2_ ON (c2_.id = m0_.club_id)
  LEFT JOIN member_transponders m3_ ON (m3_.member_id = m0_.member_id)
WHERE
  m0_.status = ?
  AND m0_.valid_from = ?
  AND m0_.valid_until = ?
GROUP BY
  m0_.id,
  m0_.code,
  m1_.id,
  m1_.lastname,
  m1_.firstname,
  c2_.shortcut
ORDER BY
  c2_.shortcut ASC,
  m1_.lastname ASC

SELECT m0_.id AS id_0, m0_.code AS code_1, m0_.status AS status_2, m1_.id AS id_3, m1_.lastname AS lastname_4, m1_.firstname AS firstname_5, c2_.shortcut AS shortcut_6, GROUP_CONCAT(m3_.identifier SEPARATOR ', ') AS sclr_7 FROM member_license m0_ INNER JOIN `member` m1_ ON (m1_.id = m0_.member_id) INNER JOIN club c2_ ON (c2_.id = m0_.club_id) LEFT JOIN member_transponders m3_ ON (m3_.member_id = m0_.member_id) WHERE m0_.status = 2 AND m0_.valid_from = '2025-06-01' AND m0_.valid_until = '2026-05-31' GROUP BY m0_.id, m0_.code, m1_.id, m1_.lastname, m1_.firstname, c2_.shortcut ORDER BY c2_.shortcut ASC, m1_.lastname ASC;