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 500

[]

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
  500

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

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

[
  2679
  2681
  2669
  2670
  2647
  2662
  2649
  2652
  2663
  2664
  2653
  2654
  2656
  2660
  2661
  2644
  2645
  2646
  2642
  2643
]

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 (2679, 2681, 2669, 2670, 2647, 2662, 2649, 2652, 2663, 2664, 2653, 2654, 2656, 2660, 2661, 2644, 2645, 2646, 2642, 2643) 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;