Symfony Profiler

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

Query Metrics

SELECT DISTINCT l0_.id AS id_0, l0_.basic_form AS basic_form_1 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= ?) AND (l0_.deleted_at IS NULL) ORDER BY l0_.basic_form ASC LIMIT 50

[
  10
]

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.basic_form AS basic_form_1
FROM
  language_comment l0_
  LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id
  AND (l1_.deleted_at IS NULL)
WHERE
  (l0_.status >= ?)
  AND (l0_.deleted_at IS NULL)
ORDER BY
  l0_.basic_form ASC
LIMIT
  50

SELECT DISTINCT l0_.id AS id_0, l0_.basic_form AS basic_form_1 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= 10) AND (l0_.deleted_at IS NULL) ORDER BY l0_.basic_form ASC LIMIT 50;

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= ?) AND (l0_.deleted_at IS NULL)

[
  10
]

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  language_comment l0_
  LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id
  AND (l1_.deleted_at IS NULL)
WHERE
  (l0_.status >= ?)
  AND (l0_.deleted_at IS NULL)

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= 10) AND (l0_.deleted_at IS NULL);

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5 FROM user t0 WHERE t0.id = ?

[
  4
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_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.display_name AS display_name_5 FROM user t0 WHERE t0.id = 4;

SELECT l0_.id AS id_0, l0_.reference_id AS reference_id_1, l0_.basic_form AS basic_form_2, l0_.status AS status_3, l0_.created_at AS created_at_4, l0_.updated_at AS updated_at_5, l0_.deleted_at AS deleted_at_6, l1_.id AS id_7, l1_.content AS content_8, l1_.language_comment_number AS language_comment_number_9, l1_.created_at AS created_at_10, l1_.updated_at AS updated_at_11, l1_.deleted_at AS deleted_at_12, l0_.created_by_id AS created_by_id_13, l1_.comment_id AS comment_id_14 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= ? AND l0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.basic_form ASC

[
  10
  2871
  387
  325
  3121
  1205
  1385
  1077
  1206
  1422
  2193
  2937
  2648
  3363
  3244
  3378
  349
  607
  2328
  2111
  2128
  3343
  1605
  1279
  1785
  1931
  801
  2284
  803
  544
  2360
  331
  1496
  1296
  2948
  2389
  754
  3060
  2727
  2725
  2773
  3222
  319
  2552
  1291
  1142
  717
  416
  1765
  1971
  290
]

SELECT
  l0_.id AS id_0,
  l0_.reference_id AS reference_id_1,
  l0_.basic_form AS basic_form_2,
  l0_.status AS status_3,
  l0_.created_at AS created_at_4,
  l0_.updated_at AS updated_at_5,
  l0_.deleted_at AS deleted_at_6,
  l1_.id AS id_7,
  l1_.content AS content_8,
  l1_.language_comment_number AS language_comment_number_9,
  l1_.created_at AS created_at_10,
  l1_.updated_at AS updated_at_11,
  l1_.deleted_at AS deleted_at_12,
  l0_.created_by_id AS created_by_id_13,
  l1_.comment_id AS comment_id_14
FROM
  language_comment l0_
  LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id
  AND (l1_.deleted_at IS NULL)
WHERE
  (
    l0_.status >= ?
    AND l0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?
    )
  )
  AND (l0_.deleted_at IS NULL)
ORDER BY
  l0_.basic_form ASC

SELECT l0_.id AS id_0, l0_.reference_id AS reference_id_1, l0_.basic_form AS basic_form_2, l0_.status AS status_3, l0_.created_at AS created_at_4, l0_.updated_at AS updated_at_5, l0_.deleted_at AS deleted_at_6, l1_.id AS id_7, l1_.content AS content_8, l1_.language_comment_number AS language_comment_number_9, l1_.created_at AS created_at_10, l1_.updated_at AS updated_at_11, l1_.deleted_at AS deleted_at_12, l0_.created_by_id AS created_by_id_13, l1_.comment_id AS comment_id_14 FROM language_comment l0_ LEFT JOIN language_comment_item l1_ ON l0_.id = l1_.comment_id AND (l1_.deleted_at IS NULL) WHERE (l0_.status >= 10 AND l0_.id IN (2871, 387, 325, 3121, 1205, 1385, 1077, 1206, 1422, 2193, 2937, 2648, 3363, 3244, 3378, 349, 607, 2328, 2111, 2128, 3343, 1605, 1279, 1785, 1931, 801, 2284, 803, 544, 2360, 331, 1496, 1296, 2948, 2389, 754, 3060, 2727, 2725, 2773, 3222, 319, 2552, 1291, 1142, 717, 416, 1765, 1971, 290)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.basic_form ASC;