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 1740

[]

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
  1740

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 1740;

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 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

[
  42
  36
  37
  35
  33
  32
  14
  15
  17
  19
  21
  23
  24
  26
  27
  28
  29
  10
  11
  8
]

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 (42, 36, 37, 35, 33, 32, 14, 15, 17, 19, 21, 23, 24, 26, 27, 28, 29, 10, 11, 8) ORDER BY p0_.published_at DESC;

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;