Symfony Profiler

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

Query Metrics

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lecture l0_ WHERE l0_.is_published = ? AND l0_.category_id = ?

[
  1
  2
]

SELECT
  count(DISTINCT l0_.id) AS sclr_0
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
  AND l0_.category_id = ?

SELECT count(DISTINCT l0_.id) AS sclr_0 FROM lecture l0_ WHERE l0_.is_published = 1 AND l0_.category_id = 2;

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, l1_.id AS id_7, l1_.title AS title_8, l1_.slug AS slug_9, l1_.content AS content_10, l1_.excerpt AS excerpt_11, l1_.is_published AS is_published_12, l1_.order_number AS order_number_13, l1_.created_at AS created_at_14, l1_.updated_at AS updated_at_15, l1_.category_id AS category_id_16 FROM category c0_ LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id ORDER BY c0_.name ASC

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.description AS description_3,
  c0_.color AS color_4,
  c0_.created_at AS created_at_5,
  c0_.updated_at AS updated_at_6,
  l1_.id AS id_7,
  l1_.title AS title_8,
  l1_.slug AS slug_9,
  l1_.content AS content_10,
  l1_.excerpt AS excerpt_11,
  l1_.is_published AS is_published_12,
  l1_.order_number AS order_number_13,
  l1_.created_at AS created_at_14,
  l1_.updated_at AS updated_at_15,
  l1_.category_id AS category_id_16
FROM
  category c0_
  LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.description AS description_3, c0_.color AS color_4, c0_.created_at AS created_at_5, c0_.updated_at AS updated_at_6, l1_.id AS id_7, l1_.title AS title_8, l1_.slug AS slug_9, l1_.content AS content_10, l1_.excerpt AS excerpt_11, l1_.is_published AS is_published_12, l1_.order_number AS order_number_13, l1_.created_at AS created_at_14, l1_.updated_at AS updated_at_15, l1_.category_id AS category_id_16 FROM category c0_ LEFT JOIN lecture l1_ ON c0_.id = l1_.category_id ORDER BY c0_.name ASC;

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.excerpt AS excerpt_4, l0_.is_published AS is_published_5, l0_.order_number AS order_number_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8, l0_.category_id AS category_id_9 FROM lecture l0_ WHERE l0_.is_published = ? AND l0_.category_id = ? AND l0_.id IN (?, ?, ?, ?, ?, ?) ORDER BY l0_.order_number ASC, l0_.created_at DESC

[
  1
  2
  43
  44
  45
  46
  47
  48
]

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2,
  l0_.content AS content_3,
  l0_.excerpt AS excerpt_4,
  l0_.is_published AS is_published_5,
  l0_.order_number AS order_number_6,
  l0_.created_at AS created_at_7,
  l0_.updated_at AS updated_at_8,
  l0_.category_id AS category_id_9
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
  AND l0_.category_id = ?
  AND l0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  l0_.order_number ASC,
  l0_.created_at DESC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2, l0_.content AS content_3, l0_.excerpt AS excerpt_4, l0_.is_published AS is_published_5, l0_.order_number AS order_number_6, l0_.created_at AS created_at_7, l0_.updated_at AS updated_at_8, l0_.category_id AS category_id_9 FROM lecture l0_ WHERE l0_.is_published = 1 AND l0_.category_id = 2 AND l0_.id IN (43, 44, 45, 46, 47, 48) ORDER BY l0_.order_number ASC, l0_.created_at DESC;

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2 FROM lecture l0_ WHERE l0_.is_published = ? ORDER BY l0_.order_number ASC, l0_.title ASC

[
  1
]

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
ORDER BY
  l0_.order_number ASC,
  l0_.title ASC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2 FROM lecture l0_ WHERE l0_.is_published = 1 ORDER BY l0_.order_number ASC, l0_.title ASC;

SELECT DISTINCT l0_.id AS id_0, l0_.order_number AS order_number_1, l0_.created_at AS created_at_2 FROM lecture l0_ WHERE l0_.is_published = ? AND l0_.category_id = ? ORDER BY l0_.order_number ASC, l0_.created_at DESC LIMIT 6 OFFSET 6

[
  1
  2
]

SELECT
  DISTINCT l0_.id AS id_0,
  l0_.order_number AS order_number_1,
  l0_.created_at AS created_at_2
FROM
  lecture l0_
WHERE
  l0_.is_published = ?
  AND l0_.category_id = ?
ORDER BY
  l0_.order_number ASC,
  l0_.created_at DESC
LIMIT
  6
OFFSET
  6

SELECT DISTINCT l0_.id AS id_0, l0_.order_number AS order_number_1, l0_.created_at AS created_at_2 FROM lecture l0_ WHERE l0_.is_published = 1 AND l0_.category_id = 2 ORDER BY l0_.order_number ASC, l0_.created_at DESC LIMIT 6 OFFSET 6;

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM category t0 WHERE t0.id = ?

[
  "2"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.color AS color_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.color AS color_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM category t0 WHERE t0.id = '2';