Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.client_name AS client_name_3,
  t0.featured_image AS featured_image_4,
  t0.content AS content_5,
  t0.visuals AS visuals_6,
  t0.testimonials AS testimonials_7,
  t0.published_status AS published_status_8,
  t0.created_at AS created_at_9,
  t0.created_by AS created_by_10,
  t0.updated_at AS updated_at_11,
  t0.updated_by AS updated_by_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14,
  t0.meta_keywords AS meta_keywords_15,
  t0.slug AS slug_16,
  t0.featured AS featured_17
FROM
  case_study t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.client_name AS client_name_3, t0.featured_image AS featured_image_4, t0.content AS content_5, t0.visuals AS visuals_6, t0.testimonials AS testimonials_7, t0.published_status AS published_status_8, t0.created_at AS created_at_9, t0.created_by AS created_by_10, t0.updated_at AS updated_at_11, t0.updated_by AS updated_by_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.meta_keywords AS meta_keywords_15, t0.slug AS slug_16, t0.featured AS featured_17 FROM case_study t0 WHERE t0.slug = 'test-nikhil' 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 c1_.id) AS sclr_7,
  COUNT(DISTINCT b2_.id) AS sclr_8
FROM
  category c0_
  LEFT JOIN case_study_category c3_ ON c0_.id = c3_.category_id
  LEFT JOIN case_study c1_ ON c1_.id = c3_.case_study_id
  LEFT JOIN blog_category b4_ ON c0_.id = b4_.category_id
  LEFT JOIN blog b2_ ON b2_.id = b4_.blog_id
GROUP BY
  c0_.id
HAVING
  COUNT(DISTINCT c1_.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 c1_.id) AS sclr_7, COUNT(DISTINCT b2_.id) AS sclr_8 FROM category c0_ LEFT JOIN case_study_category c3_ ON c0_.id = c3_.category_id LEFT JOIN case_study c1_ ON c1_.id = c3_.case_study_id LEFT JOIN blog_category b4_ ON c0_.id = b4_.category_id LEFT JOIN blog b2_ ON b2_.id = b4_.blog_id GROUP BY c0_.id HAVING COUNT(DISTINCT c1_.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 case_study_tag c2_ ON t0_.id = c2_.tag_id
  INNER JOIN case_study c1_ ON c1_.id = c2_.case_study_id
WHERE
  c1_.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 case_study_tag c2_ ON t0_.id = c2_.tag_id INNER JOIN case_study c1_ ON c1_.id = c2_.case_study_id WHERE c1_.published_status = 1 GROUP BY t0_.id ORDER BY t0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.client_name AS client_name_2,
  c0_.featured_image AS featured_image_3,
  c0_.content AS content_4,
  c0_.visuals AS visuals_5,
  c0_.testimonials AS testimonials_6,
  c0_.published_status AS published_status_7,
  c0_.created_at AS created_at_8,
  c0_.created_by AS created_by_9,
  c0_.updated_at AS updated_at_10,
  c0_.updated_by AS updated_by_11,
  c0_.meta_title AS meta_title_12,
  c0_.meta_description AS meta_description_13,
  c0_.meta_keywords AS meta_keywords_14,
  c0_.slug AS slug_15,
  c0_.featured AS featured_16
FROM
  case_study c0_
WHERE
  c0_.published_status = 1
ORDER BY
  c0_.created_at DESC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.client_name AS client_name_2, c0_.featured_image AS featured_image_3, c0_.content AS content_4, c0_.visuals AS visuals_5, c0_.testimonials AS testimonials_6, c0_.published_status AS published_status_7, c0_.created_at AS created_at_8, c0_.created_by AS created_by_9, c0_.updated_at AS updated_at_10, c0_.updated_by AS updated_by_11, c0_.meta_title AS meta_title_12, c0_.meta_description AS meta_description_13, c0_.meta_keywords AS meta_keywords_14, c0_.slug AS slug_15, c0_.featured AS featured_16 FROM case_study c0_ WHERE c0_.published_status = 1 ORDER BY c0_.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 case_study_category ON t0.id = case_study_category.category_id
WHERE
  case_study_category.case_study_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 case_study_category ON t0.id = case_study_category.category_id WHERE case_study_category.case_study_id = 6;

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 case_study_tag ON t0.id = case_study_tag.tag_id
WHERE
  case_study_tag.case_study_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 case_study_tag ON t0.id = case_study_tag.tag_id WHERE case_study_tag.case_study_id = 6;

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 case_study_category ON t0.id = case_study_category.category_id
WHERE
  case_study_category.case_study_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 case_study_category ON t0.id = case_study_category.category_id WHERE case_study_category.case_study_id = 4;

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 case_study_category ON t0.id = case_study_category.category_id
WHERE
  case_study_category.case_study_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 case_study_category ON t0.id = case_study_category.category_id WHERE case_study_category.case_study_id = 3;