Symfony Profiler

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
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_8
    FROM
      (
        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,
          t1_.id AS id_17,
          t1_.name AS name_18,
          t1_.created_at AS created_at_19,
          t1_.created_by AS created_by_20,
          t1_.updated_at AS updated_at_21,
          t1_.updated_by AS updated_by_22,
          t1_.slug AS slug_23
        FROM
          case_study c0_
          INNER JOIN case_study_tag c2_ ON c0_.id = c2_.case_study_id
          INNER JOIN tag t1_ ON t1_.id = c2_.tag_id
        WHERE
          t1_.slug = ?
          AND c0_.published_status = 1
      ) dctrn_result_inner
    ORDER BY
      created_at_8 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_8 FROM (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, t1_.id AS id_17, t1_.name AS name_18, t1_.created_at AS created_at_19, t1_.created_by AS created_by_20, t1_.updated_at AS updated_at_21, t1_.updated_by AS updated_by_22, t1_.slug AS slug_23 FROM case_study c0_ INNER JOIN case_study_tag c2_ ON c0_.id = c2_.case_study_id INNER JOIN tag t1_ ON t1_.id = c2_.tag_id WHERE t1_.slug = 'software-development' AND c0_.published_status = 1) dctrn_result_inner ORDER BY created_at_8 DESC) dctrn_result LIMIT 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
  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_
  INNER JOIN case_study_tag c2_ ON c0_.id = c2_.case_study_id
  INNER JOIN tag t1_ ON t1_.id = c2_.tag_id
WHERE
  t1_.slug = ?
  AND c0_.published_status = 1
  AND c0_.id IN (?, ?)
ORDER BY
  c0_.created_at DESC

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_ INNER JOIN case_study_tag c2_ ON c0_.id = c2_.case_study_id INNER JOIN tag t1_ ON t1_.id = c2_.tag_id WHERE t1_.slug = 'software-development' AND c0_.published_status = 1 AND c0_.id IN (4, 3) ORDER BY c0_.created_at DESC;

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
  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
WHERE
  t0.slug = ?
LIMIT
  1

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 WHERE t0.slug = 'software-development' LIMIT 1;

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.route AS route_2,
  t0.meta_title AS meta_title_3,
  t0.meta_description AS meta_description_4,
  t0.meta_keywords AS meta_keywords_5,
  t0.canonical_url AS canonical_url_6,
  t0.created_at AS created_at_7,
  t0.created_by AS created_by_8,
  t0.updated_at AS updated_at_9,
  t0.updated_by AS updated_by_10
FROM
  seo_meta t0
WHERE
  t0.route = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.route AS route_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.meta_keywords AS meta_keywords_5, t0.canonical_url AS canonical_url_6, t0.created_at AS created_at_7, t0.created_by AS created_by_8, t0.updated_at AS updated_at_9, t0.updated_by AS updated_by_10 FROM seo_meta t0 WHERE t0.route = 'case-study' LIMIT 1;