Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 5
• Events
• Routing
• Cache
• Translation 4
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 5
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT n.* FROM news_article n WHERE n.tags::jsonb @> ?

[
  "["International"]"
]

SELECT
  n.*
FROM
  news_article n
WHERE
  n.tags :: jsonb @ > ?

SELECT n.* FROM news_article n WHERE n.tags::jsonb @> '[\"International\"]';

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ ORDER BY n0_.created_at DESC LIMIT 3

[]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.image AS image_3,
  n0_.excerpt AS excerpt_4,
  n0_.content AS content_5,
  n0_.author AS author_6,
  n0_.comments_count AS comments_count_7,
  n0_.tags AS tags_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.category_id AS category_id_11
FROM
  news_article n0_
ORDER BY
  n0_.created_at DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ ORDER BY n0_.created_at DESC LIMIT 3;

SELECT DISTINCT n0_.id AS id_0, n0_.created_at AS created_at_1 FROM news_article n0_ WHERE n0_.id IN (?) ORDER BY n0_.created_at DESC LIMIT 6

[
  143
]

SELECT
  DISTINCT n0_.id AS id_0,
  n0_.created_at AS created_at_1
FROM
  news_article n0_
WHERE
  n0_.id IN (?)
ORDER BY
  n0_.created_at DESC
LIMIT
  6

SELECT DISTINCT n0_.id AS id_0, n0_.created_at AS created_at_1 FROM news_article n0_ WHERE n0_.id IN (143) ORDER BY n0_.created_at DESC LIMIT 6;

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news_article n0_ WHERE n0_.id IN (?)

[
  143
]

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  news_article n0_
WHERE
  n0_.id IN (?)

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM news_article n0_ WHERE n0_.id IN (143);

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ WHERE n0_.id IN (?) AND n0_.id IN (?) ORDER BY n0_.created_at DESC

[
  143
  143
]

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.image AS image_3,
  n0_.excerpt AS excerpt_4,
  n0_.content AS content_5,
  n0_.author AS author_6,
  n0_.comments_count AS comments_count_7,
  n0_.tags AS tags_8,
  n0_.created_at AS created_at_9,
  n0_.updated_at AS updated_at_10,
  n0_.category_id AS category_id_11
FROM
  news_article n0_
WHERE
  n0_.id IN (?)
  AND n0_.id IN (?)
ORDER BY
  n0_.created_at DESC

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.image AS image_3, n0_.excerpt AS excerpt_4, n0_.content AS content_5, n0_.author AS author_6, n0_.comments_count AS comments_count_7, n0_.tags AS tags_8, n0_.created_at AS created_at_9, n0_.updated_at AS updated_at_10, n0_.category_id AS category_id_11 FROM news_article n0_ WHERE n0_.id IN (143) AND n0_.id IN (143) ORDER BY n0_.created_at DESC;

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.slug AS slug_2 FROM news_category n0_ ORDER BY n0_.name ASC

[]

SELECT
  n0_.id AS id_0,
  n0_.name AS name_1,
  n0_.slug AS slug_2
FROM
  news_category n0_
ORDER BY
  n0_.name ASC

SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.slug AS slug_2 FROM news_category n0_ ORDER BY n0_.name ASC;