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 INNER JOIN article_category ON t0.id = article_category.category_id WHERE article_category.article_id = ?

[
  730
]

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 = 730;

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_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE a0_.is_published = 1 AND c1_.id IN (?) AND a0_.id <> ? GROUP BY a0_.id ORDER BY a0_.published_at DESC LIMIT 3

[
  285
  730
]

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_
  INNER JOIN article_category a2_ ON a0_.id = a2_.article_id
  INNER JOIN category c1_ ON c1_.id = a2_.category_id
WHERE
  a0_.is_published = 1
  AND c1_.id IN (?)
  AND a0_.id <> ?
GROUP BY
  a0_.id
ORDER BY
  a0_.published_at DESC
LIMIT
  3

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_ INNER JOIN article_category a2_ ON a0_.id = a2_.article_id INNER JOIN category c1_ ON c1_.id = a2_.category_id WHERE a0_.is_published = 1 AND c1_.id IN (285) AND a0_.id <> 730 GROUP BY a0_.id ORDER BY a0_.published_at DESC LIMIT 3;

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.content AS content_4, t0.excerpt AS excerpt_5, t0.featured_image AS featured_image_6, t0.is_published AS is_published_7, t0.created_at AS created_at_8, t0.published_at AS published_at_9, t0.updated_at AS updated_at_10 FROM article t0 WHERE t0.slug = ? LIMIT 1

[
  "symfony-assetmapper-adieu-webpack-encore"
]

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.excerpt AS excerpt_5,
  t0.featured_image AS featured_image_6,
  t0.is_published AS is_published_7,
  t0.created_at AS created_at_8,
  t0.published_at AS published_at_9,
  t0.updated_at AS updated_at_10
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.excerpt AS excerpt_5, t0.featured_image AS featured_image_6, t0.is_published AS is_published_7, t0.created_at AS created_at_8, t0.published_at AS published_at_9, t0.updated_at AS updated_at_10 FROM article t0 WHERE t0.slug = 'symfony-assetmapper-adieu-webpack-encore' LIMIT 1;

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.created_at AS created_at_2, c0_.is_approved AS is_approved_3, c0_.user_id AS user_id_4, c0_.article_id AS article_id_5 FROM comment c0_ WHERE c0_.article_id = ? AND c0_.is_approved = 1 ORDER BY c0_.created_at DESC

[
  730
]

SELECT
  c0_.id AS id_0,
  c0_.content AS content_1,
  c0_.created_at AS created_at_2,
  c0_.is_approved AS is_approved_3,
  c0_.user_id AS user_id_4,
  c0_.article_id AS article_id_5
FROM
  comment c0_
WHERE
  c0_.article_id = ?
  AND c0_.is_approved = 1
ORDER BY
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.content AS content_1, c0_.created_at AS created_at_2, c0_.is_approved AS is_approved_3, c0_.user_id AS user_id_4, c0_.article_id AS article_id_5 FROM comment c0_ WHERE c0_.article_id = 730 AND c0_.is_approved = 1 ORDER BY c0_.created_at DESC;

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.article_id AS article_id_5 FROM rating t0 WHERE t0.article_id = ?

[
  730
]

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.article_id AS article_id_5
FROM
  rating t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.article_id AS article_id_5 FROM rating t0 WHERE t0.article_id = 730;

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.article_id = ?

[
  730
]

SELECT
  AVG(r0_.rating) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.article_id = ?

SELECT AVG(r0_.rating) AS sclr_0 FROM rating r0_ WHERE r0_.article_id = 730;