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_.excerpt AS excerpt_3,
          b0_.content AS content_4,
          b0_.cover_image_path AS cover_image_path_5,
          b0_.cover_image_alt AS cover_image_alt_6,
          b0_.status AS status_7,
          b0_.published_at AS published_at_8,
          b0_.meta_description AS meta_description_9,
          b0_.created_at AS created_at_10,
          b0_.updated_at AS updated_at_11
        FROM
          blog_post b0_
        WHERE
          b0_.status = ?
          AND b0_.published_at IS NOT NULL
          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_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.cover_image_path AS cover_image_path_5, b0_.cover_image_alt AS cover_image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.meta_description AS meta_description_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2026-06-07 05:05:20' ORDER BY b0_.published_at DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0;

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_.excerpt AS excerpt_3,
          b0_.content AS content_4,
          b0_.cover_image_path AS cover_image_path_5,
          b0_.cover_image_alt AS cover_image_alt_6,
          b0_.status AS status_7,
          b0_.published_at AS published_at_8,
          b0_.meta_description AS meta_description_9,
          b0_.created_at AS created_at_10,
          b0_.updated_at AS updated_at_11
        FROM
          blog_post b0_
        WHERE
          b0_.status = ?
          AND b0_.published_at IS NOT NULL
          AND b0_.published_at <= ?
      ) dctrn_result_inner
    ORDER BY
      published_at_8 DESC
  ) dctrn_result
LIMIT
  9

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_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.cover_image_path AS cover_image_path_5, b0_.cover_image_alt AS cover_image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.meta_description AS meta_description_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2026-06-07 05:05:20') dctrn_result_inner ORDER BY published_at_8 DESC) dctrn_result LIMIT 9;

SELECT
  b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.slug AS slug_2,
  b0_.excerpt AS excerpt_3,
  b0_.content AS content_4,
  b0_.cover_image_path AS cover_image_path_5,
  b0_.cover_image_alt AS cover_image_alt_6,
  b0_.status AS status_7,
  b0_.published_at AS published_at_8,
  b0_.meta_description AS meta_description_9,
  b0_.created_at AS created_at_10,
  b0_.updated_at AS updated_at_11
FROM
  blog_post b0_
WHERE
  b0_.status = ?
  AND b0_.published_at IS NOT NULL
  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_.excerpt AS excerpt_3, b0_.content AS content_4, b0_.cover_image_path AS cover_image_path_5, b0_.cover_image_alt AS cover_image_alt_6, b0_.status AS status_7, b0_.published_at AS published_at_8, b0_.meta_description AS meta_description_9, b0_.created_at AS created_at_10, b0_.updated_at AS updated_at_11 FROM blog_post b0_ WHERE b0_.status = 'published' AND b0_.published_at IS NOT NULL AND b0_.published_at <= '2026-06-07 05:05:20' AND b0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9) ORDER BY b0_.published_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  blog_tag t0
  INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id
WHERE
  blog_post_tag.blog_post_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM blog_tag t0 INNER JOIN blog_post_tag ON t0.id = blog_post_tag.blog_tag_id WHERE blog_post_tag.blog_post_id = 9;