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 1320

[]

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
  1320

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

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

[
  1075
  1035
  1039
  1042
  1043
  1044
  1045
  1048
  1005
  1006
  1025
  1015
  1030
  1018
  1022
  1023
  1024
  1026
  1027
  1028
]

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 (1075, 1035, 1039, 1042, 1043, 1044, 1045, 1048, 1005, 1006, 1025, 1015, 1030, 1018, 1022, 1023, 1024, 1026, 1027, 1028) 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;