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 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_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;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_5
    FROM
      (
        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,
          c1_.id AS id_14,
          c1_.name AS name_15,
          c1_.created_at AS created_at_16,
          c1_.created_by AS created_by_17,
          c1_.updated_at AS updated_at_18,
          c1_.updated_by AS updated_by_19,
          c1_.slug AS slug_20
        FROM
          blog b0_
          INNER JOIN blog_category b2_ ON b0_.id = b2_.blog_id
          INNER JOIN category c1_ ON c1_.id = b2_.category_id
        WHERE
          c1_.slug = ?
          AND b0_.published_status = 1
      ) dctrn_result_inner
    ORDER BY
      created_at_5 DESC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_5 FROM (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, c1_.id AS id_14, c1_.name AS name_15, c1_.created_at AS created_at_16, c1_.created_by AS created_by_17, c1_.updated_at AS updated_at_18, c1_.updated_by AS updated_by_19, c1_.slug AS slug_20 FROM blog b0_ INNER JOIN blog_category b2_ ON b0_.id = b2_.blog_id INNER JOIN category c1_ ON c1_.id = b2_.category_id WHERE c1_.slug = 'programming-languages' AND b0_.published_status = 1) dctrn_result_inner ORDER BY created_at_5 DESC) dctrn_result LIMIT 6;

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_
  INNER JOIN blog_category b2_ ON b0_.id = b2_.blog_id
  INNER JOIN category c1_ ON c1_.id = b2_.category_id
WHERE
  c1_.slug = ?
  AND b0_.published_status = 1
  AND b0_.id IN (?)
ORDER BY
  b0_.created_at DESC

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_ INNER JOIN blog_category b2_ ON b0_.id = b2_.blog_id INNER JOIN category c1_ ON c1_.id = b2_.category_id WHERE c1_.slug = 'programming-languages' AND b0_.published_status = 1 AND b0_.id IN (8) ORDER BY b0_.created_at DESC;

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
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 category t0 WHERE t0.slug = 'programming-languages' 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 = ?
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 = 'blogs' LIMIT 1;

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;