Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 WHERE t0.slug = ? LIMIT 1

[
  "javascript"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 WHERE t0.slug = 'javascript' LIMIT 1;

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?))

[
  286
]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  article a0_
WHERE
  a0_.is_published = 1
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (286));

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1, a0_.created_at AS created_at_2 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?)) ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 9

[
  286
]

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.published_at AS published_at_1,
  a0_.created_at AS created_at_2
FROM
  article a0_
WHERE
  a0_.is_published = 1
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
ORDER BY
  a0_.published_at DESC,
  a0_.created_at DESC
LIMIT
  9

SELECT DISTINCT a0_.id AS id_0, a0_.published_at AS published_at_1, a0_.created_at AS created_at_2 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (286)) ORDER BY a0_.published_at DESC, a0_.created_at DESC LIMIT 9;

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.featured_image AS featured_image_5, a0_.is_published AS is_published_6, a0_.created_at AS created_at_7, a0_.published_at AS published_at_8, a0_.updated_at AS updated_at_9 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (?)) AND a0_.id IN (?, ?, ?, ?) ORDER BY a0_.published_at DESC, a0_.created_at DESC

[
  286
  722
  723
  728
  731
]

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.slug AS slug_2,
  a0_.content AS content_3,
  a0_.excerpt AS excerpt_4,
  a0_.featured_image AS featured_image_5,
  a0_.is_published AS is_published_6,
  a0_.created_at AS created_at_7,
  a0_.published_at AS published_at_8,
  a0_.updated_at AS updated_at_9
FROM
  article a0_
WHERE
  a0_.is_published = 1
  AND EXISTS (
    SELECT
      1
    FROM
      article_category a1_
    WHERE
      a1_.article_id = a0_.id
      AND a1_.category_id IN (?)
  )
  AND a0_.id IN (?, ?, ?, ?)
ORDER BY
  a0_.published_at DESC,
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.slug AS slug_2, a0_.content AS content_3, a0_.excerpt AS excerpt_4, a0_.featured_image AS featured_image_5, a0_.is_published AS is_published_6, a0_.created_at AS created_at_7, a0_.published_at AS published_at_8, a0_.updated_at AS updated_at_9 FROM article a0_ WHERE a0_.is_published = 1 AND EXISTS (SELECT 1 FROM article_category a1_ WHERE a1_.article_id = a0_.id AND a1_.category_id IN (286)) AND a0_.id IN (722, 723, 728, 731) ORDER BY a0_.published_at DESC, a0_.created_at DESC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC

[]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
ORDER BY
  t0.title ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 ORDER BY t0.title ASC;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

[
  722
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 722;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

[
  723
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 723;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

[
  728
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 728;

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

[
  731
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.color AS color_4,
  t0.description AS description_5,
  t0.level AS level_6
FROM
  category t0
  INNER JOIN article_category ON t0.id = article_category.category_id
WHERE
  article_category.article_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.color AS color_4, t0.description AS description_5, t0.level AS level_6 FROM category t0 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = 731;