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.is_hidden AS is_hidden_2, t0.slug AS slug_3, t0.title AS title_4, t0.description AS description_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.city_id AS city_id_10, t0.source_id AS source_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM news_post t0 WHERE t0.slug = ? LIMIT 1

[
  "quia-aut-voluptas-sed-molestiae"
]

SELECT
  t0.id AS id_1,
  t0.is_hidden AS is_hidden_2,
  t0.slug AS slug_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.content AS content_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.published_at AS published_at_9,
  t0.city_id AS city_id_10,
  t0.source_id AS source_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  news_post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_hidden AS is_hidden_2, t0.slug AS slug_3, t0.title AS title_4, t0.description AS description_5, t0.content AS content_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.city_id AS city_id_10, t0.source_id AS source_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM news_post t0 WHERE t0.slug = 'quia-aut-voluptas-sed-molestiae' LIMIT 1;

with recursive cte as (
                select
                    id,
                    post_id,
                    parent_id,
                    author_id,
                    content,
                    created_at,
                    updated_at
                from
                    news_comment
                where
                    post_id = ?

                union all

                select
                    c.id,
                    c.post_id,
                    c.parent_id,
                    c.author_id,
                    c.content,
                    c.created_at,
                    c.updated_at
                from
                    cte as t
                    join news_comment as c on (t.id = c.parent_id)
            )

            select
                *
            from
                cte as c

[
  642
]

with
  recursive cte as (
    select
      id,
      post_id,
      parent_id,
      author_id,
      content,
      created_at,
      updated_at
    from
      news_comment
    where
      post_id = ?
    union all
    select
      c.id,
      c.post_id,
      c.parent_id,
      c.author_id,
      c.content,
      c.created_at,
      c.updated_at
    from
      cte as t
      join news_comment as c on (t.id = c.parent_id)
  )
select
  *
from
  cte as c

with recursive cte as (
                select
                    id,
                    post_id,
                    parent_id,
                    author_id,
                    content,
                    created_at,
                    updated_at
                from
                    news_comment
                where
                    post_id = 642

                union all

                select
                    c.id,
                    c.post_id,
                    c.parent_id,
                    c.author_id,
                    c.content,
                    c.created_at,
                    c.updated_at
                from
                    cte as t
                    join news_comment as c on (t.id = c.parent_id)
            )

            select
                *
            from
                cte as c
        ;

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_tag t0 INNER JOIN news_post_tag ON t0.id = news_post_tag.tag_id WHERE news_post_tag.post_id = ? ORDER BY t0.name ASC

[
  642
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  news_tag t0
  INNER JOIN news_post_tag ON t0.id = news_post_tag.tag_id
WHERE
  news_post_tag.post_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM news_tag t0 INNER JOIN news_post_tag ON t0.id = news_post_tag.tag_id WHERE news_post_tag.post_id = 642 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.city_id AS city_id_4 FROM news_source t0 WHERE t0.id = ?

[
  466
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.link AS link_3,
  t0.city_id AS city_id_4
FROM
  news_source t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.city_id AS city_id_4 FROM news_source t0 WHERE t0.id = 466;