Symfony Profiler

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

Query Metrics

SELECT DISTINCT l0_.id AS id_0, l0_.ew_id AS sclr_1, l0_.name AS name_2 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id ORDER BY l0_.ew_id ASC, l0_.name ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY

[]

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.ew_id AS sclr_1,
  l0_.name AS name_2
FROM
  list_unit l0_
  LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id
ORDER BY
  l0_.ew_id ASC,
  l0_.name ASC
OFFSET
  0
ROWS
FETCH
  NEXT 20
ROWS
  ONLY

SELECT DISTINCT l0_.id AS id_0, l0_.ew_id AS sclr_1, l0_.name AS name_2 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id ORDER BY l0_.ew_id ASC, l0_.name ASC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY;

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.short_name AS short_name_3, l0_.ew_id AS ew_id_4 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id WHERE l0_.id IN (?, ?, ?, ?, ?) ORDER BY l0_.ew_id ASC, l0_.name ASC

[
  1
  2
  3
  4
  5
]

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.code AS code_2,
  l0_.short_name AS short_name_3,
  l0_.ew_id AS ew_id_4
FROM
  list_unit l0_
  LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id
WHERE
  l0_.id IN (?, ?, ?, ?, ?)
ORDER BY
  l0_.ew_id ASC,
  l0_.name ASC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.code AS code_2, l0_.short_name AS short_name_3, l0_.ew_id AS ew_id_4 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id WHERE l0_.id IN (1, 2, 3, 4, 5) ORDER BY l0_.ew_id ASC, l0_.name ASC;

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id

[]

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  list_unit l0_
  LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM list_unit l0_ LEFT JOIN list_ew l1_ ON l0_.ew_id = l1_.id;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ew_number AS ew_number_4
FROM
  list_ew t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ew_number AS ew_number_4
FROM
  list_ew t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = 2;

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = ?

[
  3
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.ew_number AS ew_number_4
FROM
  list_ew t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.ew_number AS ew_number_4 FROM list_ew t0 WHERE t0.id = 3;