Symfony Profiler

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

Query Metrics

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, u1_.full_name AS full_name_6, u1_.username AS username_7, u1_.telegram AS telegram_8, u1_.roles AS roles_9, u1_.name AS name_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.email AS email_13, u1_.email_verified_at AS email_verified_at_14, u1_.language AS language_15, u1_.password AS password_16, u1_.guid AS guid_17, u1_.is_verified AS is_verified_18, u1_.id AS id_19, u1_.date_created AS date_created_20, u1_.date_updated AS date_updated_21, s2_.id AS id_22, s2_.name AS name_23, s0_.author_id AS author_id_24, u1_.telegram_user_id AS telegram_user_id_25 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.published_at DESC, s2_.name ASC

[
  "2025-12-22 18:06:12"
  111
  112
  113
  114
  115
  116
  117
  118
  119
  120
]

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.summary AS summary_3,
  s0_.content AS content_4,
  s0_.published_at AS published_at_5,
  u1_.full_name AS full_name_6,
  u1_.username AS username_7,
  u1_.telegram AS telegram_8,
  u1_.roles AS roles_9,
  u1_.name AS name_10,
  u1_.first_name AS first_name_11,
  u1_.last_name AS last_name_12,
  u1_.email AS email_13,
  u1_.email_verified_at AS email_verified_at_14,
  u1_.language AS language_15,
  u1_.password AS password_16,
  u1_.guid AS guid_17,
  u1_.is_verified AS is_verified_18,
  u1_.id AS id_19,
  u1_.date_created AS date_created_20,
  u1_.date_updated AS date_updated_21,
  s2_.id AS id_22,
  s2_.name AS name_23,
  s0_.author_id AS author_id_24,
  u1_.telegram_user_id AS telegram_user_id_25
FROM
  symfony_demo_post s0_
  INNER JOIN user u1_ ON s0_.author_id = u1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.published_at DESC,
  s2_.name ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, u1_.full_name AS full_name_6, u1_.username AS username_7, u1_.telegram AS telegram_8, u1_.roles AS roles_9, u1_.name AS name_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.email AS email_13, u1_.email_verified_at AS email_verified_at_14, u1_.language AS language_15, u1_.password AS password_16, u1_.guid AS guid_17, u1_.is_verified AS is_verified_18, u1_.id AS id_19, u1_.date_created AS date_created_20, u1_.date_updated AS date_updated_21, s2_.id AS id_22, s2_.name AS name_23, s0_.author_id AS author_id_24, u1_.telegram_user_id AS telegram_user_id_25 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2025-12-22 18:06:12' AND s0_.id IN (111, 112, 113, 114, 115, 116, 117, 118, 119, 120) ORDER BY s0_.published_at DESC, s2_.name ASC;

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? ORDER BY s0_.published_at DESC LIMIT 10 OFFSET 20

[
  "2025-12-22 18:06:12"
]

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.published_at AS published_at_1
FROM
  symfony_demo_post s0_
  INNER JOIN user u1_ ON s0_.author_id = u1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?
ORDER BY
  s0_.published_at DESC
LIMIT
  10
OFFSET
  20

SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2025-12-22 18:06:12' ORDER BY s0_.published_at DESC LIMIT 10 OFFSET 20;

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ?

[
  "2025-12-22 18:06:12"
]

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  symfony_demo_post s0_
  INNER JOIN user u1_ ON s0_.author_id = u1_.id
  LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id
  LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id
WHERE
  s0_.published_at <= ?

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= '2025-12-22 18:06:12';