Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.featured_image AS featured_image_4,
  t0.published_status AS published_status_5,
  t0.created_at AS created_at_6,
  t0.created_by AS created_by_7,
  t0.updated_at AS updated_at_8,
  t0.updated_by AS updated_by_9,
  t0.meta_title AS meta_title_10,
  t0.meta_description AS meta_description_11,
  t0.meta_keywords AS meta_keywords_12,
  t0.slug AS slug_13,
  t0.short_description AS short_description_14,
  t0.author_id AS author_id_15
FROM
  blog t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.featured_image AS featured_image_4, t0.published_status AS published_status_5, t0.created_at AS created_at_6, t0.created_by AS created_by_7, t0.updated_at AS updated_at_8, t0.updated_by AS updated_by_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.meta_keywords AS meta_keywords_12, t0.slug AS slug_13, t0.short_description AS short_description_14, t0.author_id AS author_id_15 FROM blog t0 WHERE t0.slug = 'the-rise-of-quantum-computing-a-beginners-guide' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.created_at AS created_at_2,
  c0_.created_by AS created_by_3,
  c0_.updated_at AS updated_at_4,
  c0_.updated_by AS updated_by_5,
  c0_.slug AS slug_6,
  COUNT(DISTINCT b1_.id) AS sclr_7,
  COUNT(DISTINCT c2_.id) AS sclr_8
FROM
  category c0_
  LEFT JOIN blog_category b3_ ON c0_.id = b3_.category_id
  LEFT JOIN blog b1_ ON b1_.id = b3_.blog_id
  LEFT JOIN case_study_category c4_ ON c0_.id = c4_.category_id
  LEFT JOIN case_study c2_ ON c2_.id = c4_.case_study_id
GROUP BY
  c0_.id
HAVING
  COUNT(DISTINCT b1_.id) > 0

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.created_by AS created_by_3, c0_.updated_at AS updated_at_4, c0_.updated_by AS updated_by_5, c0_.slug AS slug_6, COUNT(DISTINCT b1_.id) AS sclr_7, COUNT(DISTINCT c2_.id) AS sclr_8 FROM category c0_ LEFT JOIN blog_category b3_ ON c0_.id = b3_.category_id LEFT JOIN blog b1_ ON b1_.id = b3_.blog_id LEFT JOIN case_study_category c4_ ON c0_.id = c4_.category_id LEFT JOIN case_study c2_ ON c2_.id = c4_.case_study_id GROUP BY c0_.id HAVING COUNT(DISTINCT b1_.id) > 0;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.created_at AS created_at_2,
  t0_.created_by AS created_by_3,
  t0_.updated_at AS updated_at_4,
  t0_.updated_by AS updated_by_5,
  t0_.slug AS slug_6
FROM
  tag t0_
  INNER JOIN blog_tag b2_ ON t0_.id = b2_.tag_id
  INNER JOIN blog b1_ ON b1_.id = b2_.blog_id
WHERE
  b1_.published_status = 1
GROUP BY
  t0_.id
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.created_at AS created_at_2, t0_.created_by AS created_by_3, t0_.updated_at AS updated_at_4, t0_.updated_by AS updated_by_5, t0_.slug AS slug_6 FROM tag t0_ INNER JOIN blog_tag b2_ ON t0_.id = b2_.tag_id INNER JOIN blog b1_ ON b1_.id = b2_.blog_id WHERE b1_.published_status = 1 GROUP BY t0_.id ORDER BY t0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.content AS content_2,
  b0_.featured_image AS featured_image_3,
  b0_.published_status AS published_status_4,
  b0_.created_at AS created_at_5,
  b0_.created_by AS created_by_6,
  b0_.updated_at AS updated_at_7,
  b0_.updated_by AS updated_by_8,
  b0_.meta_title AS meta_title_9,
  b0_.meta_description AS meta_description_10,
  b0_.meta_keywords AS meta_keywords_11,
  b0_.slug AS slug_12,
  b0_.short_description AS short_description_13,
  b0_.author_id AS author_id_14
FROM
  blog b0_
WHERE
  b0_.published_status = 1
ORDER BY
  b0_.created_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.content AS content_2, b0_.featured_image AS featured_image_3, b0_.published_status AS published_status_4, b0_.created_at AS created_at_5, b0_.created_by AS created_by_6, b0_.updated_at AS updated_at_7, b0_.updated_by AS updated_by_8, b0_.meta_title AS meta_title_9, b0_.meta_description AS meta_description_10, b0_.meta_keywords AS meta_keywords_11, b0_.slug AS slug_12, b0_.short_description AS short_description_13, b0_.author_id AS author_id_14 FROM blog b0_ WHERE b0_.published_status = 1 ORDER BY b0_.created_at DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  category t0
  INNER JOIN blog_category ON t0.id = blog_category.category_id
WHERE
  blog_category.blog_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 7;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.created_by AS created_by_6,
  t0.updated_at AS updated_at_7,
  t0.updated_by AS updated_by_8,
  t0.name AS name_9
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6, t0.updated_at AS updated_at_7, t0.updated_by AS updated_by_8, t0.name AS name_9 FROM user t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  tag t0
  INNER JOIN blog_tag ON t0.id = blog_tag.tag_id
WHERE
  blog_tag.blog_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM tag t0 INNER JOIN blog_tag ON t0.id = blog_tag.tag_id WHERE blog_tag.blog_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  category t0
  INNER JOIN blog_category ON t0.id = blog_category.category_id
WHERE
  blog_category.blog_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.created_by AS created_by_4,
  t0.updated_at AS updated_at_5,
  t0.updated_by AS updated_by_6,
  t0.slug AS slug_7
FROM
  category t0
  INNER JOIN blog_category ON t0.id = blog_category.category_id
WHERE
  blog_category.blog_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.created_by AS created_by_4, t0.updated_at AS updated_at_5, t0.updated_by AS updated_by_6, t0.slug AS slug_7 FROM category t0 INNER JOIN blog_category ON t0.id = blog_category.category_id WHERE blog_category.blog_id = 8;