Symfony Profiler

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

Query Metrics

SELECT a0_.id AS id_0, a0_.is_published AS is_published_1, a0_.is_rejected AS is_rejected_2, a0_.title AS title_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.author AS author_8, a0_.image_name AS image_name_9, a0_.image_size AS image_size_10, a0_.vue_count AS vue_count_11 FROM article a0_ LEFT JOIN commentaire c1_ ON a0_.id = c1_.article_id WHERE a0_.is_published = ? AND (SELECT COUNT(*) FROM commentaire c2_ WHERE c2_.article_id = a0_.id) > 0 GROUP BY a0_.id ORDER BY COUNT(c1_.id) DESC, a0_.published_at DESC LIMIT 3

[
  1
]

SELECT
  a0_.id AS id_0,
  a0_.is_published AS is_published_1,
  a0_.is_rejected AS is_rejected_2,
  a0_.title AS title_3,
  a0_.content AS content_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.published_at AS published_at_7,
  a0_.author AS author_8,
  a0_.image_name AS image_name_9,
  a0_.image_size AS image_size_10,
  a0_.vue_count AS vue_count_11
FROM
  article a0_
  LEFT JOIN commentaire c1_ ON a0_.id = c1_.article_id
WHERE
  a0_.is_published = ?
  AND (
    SELECT
      COUNT(*)
    FROM
      commentaire c2_
    WHERE
      c2_.article_id = a0_.id
  ) > 0
GROUP BY
  a0_.id
ORDER BY
  COUNT(c1_.id) DESC,
  a0_.published_at DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.is_published AS is_published_1, a0_.is_rejected AS is_rejected_2, a0_.title AS title_3, a0_.content AS content_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.published_at AS published_at_7, a0_.author AS author_8, a0_.image_name AS image_name_9, a0_.image_size AS image_size_10, a0_.vue_count AS vue_count_11 FROM article a0_ LEFT JOIN commentaire c1_ ON a0_.id = c1_.article_id WHERE a0_.is_published = 1 AND (SELECT COUNT(*) FROM commentaire c2_ WHERE c2_.article_id = a0_.id) > 0 GROUP BY a0_.id ORDER BY COUNT(c1_.id) DESC, a0_.published_at DESC LIMIT 3;

SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_rejected AS is_rejected_3, t0.title AS title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.author AS author_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.vue_count AS vue_count_12 FROM article t0 WHERE t0.is_published = ? ORDER BY t0.published_at DESC

[
  1
]

SELECT
  t0.id AS id_1,
  t0.is_published AS is_published_2,
  t0.is_rejected AS is_rejected_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.published_at AS published_at_8,
  t0.author AS author_9,
  t0.image_name AS image_name_10,
  t0.image_size AS image_size_11,
  t0.vue_count AS vue_count_12
FROM
  article t0
WHERE
  t0.is_published = ?
ORDER BY
  t0.published_at DESC

SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_rejected AS is_rejected_3, t0.title AS title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.author AS author_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.vue_count AS vue_count_12 FROM article t0 WHERE t0.is_published = 1 ORDER BY t0.published_at DESC;

SELECT b0_.id AS id_0, b0_.setting_key AS setting_key_1, b0_.hero_image_name AS hero_image_name_2, b0_.hero_image_size AS hero_image_size_3, b0_.updated_at AS updated_at_4 FROM blog_settings b0_ WHERE b0_.setting_key = ?

[
  "blog_hero"
]

SELECT
  b0_.id AS id_0,
  b0_.setting_key AS setting_key_1,
  b0_.hero_image_name AS hero_image_name_2,
  b0_.hero_image_size AS hero_image_size_3,
  b0_.updated_at AS updated_at_4
FROM
  blog_settings b0_
WHERE
  b0_.setting_key = ?

SELECT b0_.id AS id_0, b0_.setting_key AS setting_key_1, b0_.hero_image_name AS hero_image_name_2, b0_.hero_image_size AS hero_image_size_3, b0_.updated_at AS updated_at_4 FROM blog_settings b0_ WHERE b0_.setting_key = 'blog_hero';

SELECT COUNT(*) FROM article t0 WHERE t0.is_published = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  article t0
WHERE
  t0.is_published = ?

SELECT COUNT(*) FROM article t0 WHERE t0.is_published = 1;

SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_rejected AS is_rejected_3, t0.title AS title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.author AS author_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.vue_count AS vue_count_12 FROM article t0 WHERE t0.is_published = ? ORDER BY t0.vue_count DESC LIMIT 5

[
  1
]

SELECT
  t0.id AS id_1,
  t0.is_published AS is_published_2,
  t0.is_rejected AS is_rejected_3,
  t0.title AS title_4,
  t0.content AS content_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.published_at AS published_at_8,
  t0.author AS author_9,
  t0.image_name AS image_name_10,
  t0.image_size AS image_size_11,
  t0.vue_count AS vue_count_12
FROM
  article t0
WHERE
  t0.is_published = ?
ORDER BY
  t0.vue_count DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.is_published AS is_published_2, t0.is_rejected AS is_rejected_3, t0.title AS title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.published_at AS published_at_8, t0.author AS author_9, t0.image_name AS image_name_10, t0.image_size AS image_size_11, t0.vue_count AS vue_count_12 FROM article t0 WHERE t0.is_published = 1 ORDER BY t0.vue_count DESC LIMIT 5;