Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 16
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Serializer
• EasyAdmin
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_tag t0 WHERE t0.name = ? LIMIT 1

[
  "Necessitatibus"
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  news_tag t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_tag t0 WHERE t0.name = 'Necessitatibus' LIMIT 1;

SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8, n0_.city_id AS city_id_9, n0_.source_id AS source_id_10, n0_.created_by_id AS created_by_id_11, n0_.updated_by_id AS updated_by_id_12 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (?)) ORDER BY n0_.id DESC LIMIT 12

[
  374
]

SELECT
  n0_.id AS id_0,
  n0_.is_hidden AS is_hidden_1,
  n0_.slug AS slug_2,
  n0_.title AS title_3,
  n0_.description AS description_4,
  n0_.content AS content_5,
  n0_.created_at AS created_at_6,
  n0_.updated_at AS updated_at_7,
  n0_.published_at AS published_at_8,
  n0_.city_id AS city_id_9,
  n0_.source_id AS source_id_10,
  n0_.created_by_id AS created_by_id_11,
  n0_.updated_by_id AS updated_by_id_12
FROM
  news_post n0_
WHERE
  EXISTS (
    SELECT
      1
    FROM
      news_post_tag n1_
    WHERE
      n1_.post_id = n0_.id
      AND n1_.tag_id IN (?)
  )
ORDER BY
  n0_.id DESC
LIMIT
  12

SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8, n0_.city_id AS city_id_9, n0_.source_id AS source_id_10, n0_.created_by_id AS created_by_id_11, n0_.updated_by_id AS updated_by_id_12 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (374)) ORDER BY n0_.id DESC LIMIT 12;

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (?)) ORDER BY n0_.id DESC) dctrn_result) dctrn_table

[
  374
]

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.is_hidden AS is_hidden_1,
          n0_.slug AS slug_2,
          n0_.title AS title_3,
          n0_.description AS description_4,
          n0_.content AS content_5,
          n0_.created_at AS created_at_6,
          n0_.updated_at AS updated_at_7,
          n0_.published_at AS published_at_8
        FROM
          news_post n0_
        WHERE
          EXISTS (
            SELECT
              1
            FROM
              news_post_tag n1_
            WHERE
              n1_.post_id = n0_.id
              AND n1_.tag_id IN (?)
          )
        ORDER BY
          n0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.is_hidden AS is_hidden_1, n0_.slug AS slug_2, n0_.title AS title_3, n0_.description AS description_4, n0_.content AS content_5, n0_.created_at AS created_at_6, n0_.updated_at AS updated_at_7, n0_.published_at AS published_at_8 FROM news_post n0_ WHERE EXISTS (SELECT 1 FROM news_post_tag n1_ WHERE n1_.post_id = n0_.id AND n1_.tag_id IN (374)) ORDER BY n0_.id DESC) dctrn_result) dctrn_table;