Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.content AS content_3,
          b0_.excerpt AS excerpt_4,
          b0_.featured_image AS featured_image_5,
          b0_.image_alt AS image_alt_6,
          b0_.status AS status_7,
          b0_.published_at AS published_at_8,
          b0_.created_at AS created_at_9,
          b0_.updated_at AS updated_at_10,
          b0_.tags AS tags_11,
          b0_.reading_time AS reading_time_12,
          b0_.view_count AS view_count_13,
          b0_.is_featured AS is_featured_14,
          b0_.allow_comments AS allow_comments_15,
          b0_.seo_title AS seo_title_16,
          b0_.seo_description AS seo_description_17,
          b0_.seo_keywords AS seo_keywords_18,
          b0_.seo_no_index AS seo_no_index_19,
          b0_.seo_no_follow AS seo_no_follow_20
        FROM
          blog_post b0_
          LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
          LEFT JOIN user u2_ ON b0_.author_id = u2_.id
        WHERE
          b0_.status = ?
          AND b0_.published_at <= ?
        ORDER BY
          b0_.published_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33' ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      published_at_8
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.slug AS slug_2,
          b0_.content AS content_3,
          b0_.excerpt AS excerpt_4,
          b0_.featured_image AS featured_image_5,
          b0_.image_alt AS image_alt_6,
          b0_.status AS status_7,
          b0_.published_at AS published_at_8,
          b0_.created_at AS created_at_9,
          b0_.updated_at AS updated_at_10,
          b0_.tags AS tags_11,
          b0_.reading_time AS reading_time_12,
          b0_.view_count AS view_count_13,
          b0_.is_featured AS is_featured_14,
          b0_.allow_comments AS allow_comments_15,
          b0_.seo_title AS seo_title_16,
          b0_.seo_description AS seo_description_17,
          b0_.seo_keywords AS seo_keywords_18,
          b0_.seo_no_index AS seo_no_index_19,
          b0_.seo_no_follow AS seo_no_follow_20
        FROM
          blog_post b0_
          LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
          LEFT JOIN user u2_ ON b0_.author_id = u2_.id
        WHERE
          b0_.status = ?
          AND b0_.published_at <= ?
      ) dctrn_result_inner
    ORDER BY
      published_at_8 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, published_at_8 FROM (SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33') dctrn_result_inner ORDER BY published_at_8 DESC) dctrn_result LIMIT 12;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.published_at DESC

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33' AND b0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12) ORDER BY b0_.published_at DESC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?
  AND b0_.is_featured = ?
ORDER BY
  b0_.published_at DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33' AND b0_.is_featured = 1 ORDER BY b0_.published_at DESC LIMIT 3;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.color AS color_4,
  b0_.icon AS icon_5,
  b0_.image AS image_6,
  b0_.is_active AS is_active_7,
  b0_.sort_order AS sort_order_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.seo_title AS seo_title_11,
  b0_.seo_description AS seo_description_12,
  b0_.seo_keywords AS seo_keywords_13,
  COUNT(b1_.id) AS sclr_14
FROM
  blog_category b0_
  LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id
  LEFT JOIN user u2_ ON b1_.author_id = u2_.id
WHERE
  b0_.is_active = ?
  AND (
    b1_.status = ?
    OR b1_.status IS NULL
  )
  AND (
    b1_.published_at <= ?
    OR b1_.published_at IS NULL
  )
GROUP BY
  b0_.id
ORDER BY
  b0_.sort_order ASC,
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.color AS color_4, b0_.icon AS icon_5, b0_.image AS image_6, b0_.is_active AS is_active_7, b0_.sort_order AS sort_order_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.seo_title AS seo_title_11, b0_.seo_description AS seo_description_12, b0_.seo_keywords AS seo_keywords_13, COUNT(b1_.id) AS sclr_14 FROM blog_category b0_ LEFT JOIN blog_post b1_ ON b0_.id = b1_.category_id LEFT JOIN user u2_ ON b1_.author_id = u2_.id WHERE b0_.is_active = 1 AND (b1_.status = 'published' OR b1_.status IS NULL) AND (b1_.published_at <= '2025-12-14 13:01:33' OR b1_.published_at IS NULL) GROUP BY b0_.id ORDER BY b0_.sort_order ASC, b0_.name ASC;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.content AS content_3,
  b0_.excerpt AS excerpt_4,
  b0_.featured_image AS featured_image_5,
  b0_.image_alt AS image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.created_at AS created_at_9,
  b0_.updated_at AS updated_at_10,
  b0_.tags AS tags_11,
  b0_.reading_time AS reading_time_12,
  b0_.view_count AS view_count_13,
  b0_.is_featured AS is_featured_14,
  b0_.allow_comments AS allow_comments_15,
  b0_.seo_title AS seo_title_16,
  b0_.seo_description AS seo_description_17,
  b0_.seo_keywords AS seo_keywords_18,
  b0_.seo_no_index AS seo_no_index_19,
  b0_.seo_no_follow AS seo_no_follow_20,
  b0_.author_id AS author_id_21,
  b0_.category_id AS category_id_22
FROM
  blog_post b0_
  LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id
  LEFT JOIN user u2_ ON b0_.author_id = u2_.id
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?
ORDER BY
  b0_.view_count DESC,
  b0_.published_at DESC
LIMIT
  5

SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.slug AS slug_2, b0_.content AS content_3, b0_.excerpt AS excerpt_4, b0_.featured_image AS featured_image_5, b0_.image_alt AS image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.tags AS tags_11, b0_.reading_time AS reading_time_12, b0_.view_count AS view_count_13, b0_.is_featured AS is_featured_14, b0_.allow_comments AS allow_comments_15, b0_.seo_title AS seo_title_16, b0_.seo_description AS seo_description_17, b0_.seo_keywords AS seo_keywords_18, b0_.seo_no_index AS seo_no_index_19, b0_.seo_no_follow AS seo_no_follow_20, b0_.author_id AS author_id_21, b0_.category_id AS category_id_22 FROM blog_post b0_ LEFT JOIN blog_category b1_ ON b0_.category_id = b1_.id LEFT JOIN user u2_ ON b0_.author_id = u2_.id WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33' ORDER BY b0_.view_count DESC, b0_.published_at DESC LIMIT 5;

SELECT
  b0_.tags AS tags_0
FROM
  blog_post b0_
WHERE
  b0_.status = ?
  AND b0_.published_at <= ?

SELECT b0_.tags AS tags_0 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at <= '2025-12-14 13:01:33';