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 540

[]

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
  540

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

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

[
  2598
  2594
  2589
  2593
  2581
  2583
  2580
  2570
  2571
  2576
  2577
  2574
  2559
  2560
  2566
  2567
  2562
  2554
  2549
  2538
]

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 (2598, 2594, 2589, 2593, 2581, 2583, 2580, 2570, 2571, 2576, 2577, 2574, 2559, 2560, 2566, 2567, 2562, 2554, 2549, 2538) 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;