Symfony Profiler

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

Query Metrics

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_3 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_) dctrn_result_inner ORDER BY published_at_3 DESC) dctrn_result LIMIT 20 OFFSET 40

[]

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_3
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.link AS link_1,
          p0_.title AS title_2,
          p0_.published_at AS published_at_3,
          p0_.heading AS heading_4,
          p0_.language AS language_5,
          p0_.banner_link AS banner_link_6,
          p0_.tags AS tags_7
        FROM
          post p0_
      ) dctrn_result_inner
    ORDER BY
      published_at_3 DESC
  ) dctrn_result
LIMIT
  20
OFFSET
  40

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_3 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_) dctrn_result_inner ORDER BY published_at_3 DESC) dctrn_result LIMIT 20 OFFSET 40;

SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7, p0_.source_id AS source_id_8 FROM post p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.published_at DESC

[
  3499
  3502
  3503
  3491
  3494
  3489
  3480
  3481
  3482
  3484
  3485
  3487
  3488
  3471
  3472
  3479
  3464
  3467
  3468
  3470
]

SELECT
  p0_.id AS id_0,
  p0_.link AS link_1,
  p0_.title AS title_2,
  p0_.published_at AS published_at_3,
  p0_.heading AS heading_4,
  p0_.language AS language_5,
  p0_.banner_link AS banner_link_6,
  p0_.tags AS tags_7,
  p0_.source_id AS source_id_8
FROM
  post p0_
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  p0_.published_at DESC

SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7, p0_.source_id AS source_id_8 FROM post p0_ WHERE p0_.id IN (3499, 3502, 3503, 3491, 3494, 3489, 3480, 3481, 3482, 3484, 3485, 3487, 3488, 3471, 3472, 3479, 3464, 3467, 3468, 3470) ORDER BY p0_.published_at DESC;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_ ORDER BY p0_.published_at DESC) dctrn_result) dctrn_table

[]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          p0_.id AS id_0,
          p0_.link AS link_1,
          p0_.title AS title_2,
          p0_.published_at AS published_at_3,
          p0_.heading AS heading_4,
          p0_.language AS language_5,
          p0_.banner_link AS banner_link_6,
          p0_.tags AS tags_7
        FROM
          post p0_
        ORDER BY
          p0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.link AS link_1, p0_.title AS title_2, p0_.published_at AS published_at_3, p0_.heading AS heading_4, p0_.language AS language_5, p0_.banner_link AS banner_link_6, p0_.tags AS tags_7 FROM post p0_ ORDER BY p0_.published_at DESC) dctrn_result) dctrn_table;

SELECT DISTINCT p0_.language AS language_0 FROM post p0_ WHERE p0_.language IS NOT NULL

[]

SELECT
  DISTINCT p0_.language AS language_0
FROM
  post p0_
WHERE
  p0_.language IS NOT NULL

SELECT DISTINCT p0_.language AS language_0 FROM post p0_ WHERE p0_.language IS NOT NULL;