Symfony Profiler

SELECT 
  count(DISTINCT b0_.id) AS sclr_0 
FROM 
  blog_post b0_ 
WHERE 
  (
    b0_.publish_date >= ? 
    AND b0_.publish_date <= ?
  ) 
  AND (
    (
      (
        b0_.date_from IS NULL 
        OR (
          b0_.date_from <= ? 
          AND b0_.date_to >= ?
        )
      ) 
      AND (
        b0_.date_to IS NULL 
        OR (
          b0_.date_to >= ? 
          AND b0_.date_from <= ?
        )
      )
    )
  ) 
  AND b0_.enabled = 1

SELECT count(DISTINCT b0_.id) AS sclr_0 FROM blog_post b0_ WHERE (b0_.publish_date >= '2024-06-01 00:00:00' AND b0_.publish_date <= '2024-06-30 00:00:00') AND (((b0_.date_from IS NULL OR (b0_.date_from <= '2026-04-04 14:09:06' AND b0_.date_to >= '2026-04-04 14:09:06')) AND (b0_.date_to IS NULL OR (b0_.date_to >= '2026-04-04 14:09:06' AND b0_.date_from <= '2026-04-04 14:09:06')))) AND b0_.enabled = 1;

SELECT 
  DISTINCT b0_.id AS id_0, 
  b0_.publish_date AS publish_date_1 
FROM 
  blog_post b0_ 
WHERE 
  (
    b0_.publish_date >= ? 
    AND b0_.publish_date <= ?
  ) 
  AND (
    (
      (
        b0_.date_from IS NULL 
        OR (
          b0_.date_from <= ? 
          AND b0_.date_to >= ?
        )
      ) 
      AND (
        b0_.date_to IS NULL 
        OR (
          b0_.date_to >= ? 
          AND b0_.date_from <= ?
        )
      )
    )
  ) 
  AND b0_.enabled = 1 
ORDER BY 
  b0_.publish_date DESC 
LIMIT 
  9

SELECT DISTINCT b0_.id AS id_0, b0_.publish_date AS publish_date_1 FROM blog_post b0_ WHERE (b0_.publish_date >= '2024-06-01 00:00:00' AND b0_.publish_date <= '2024-06-30 00:00:00') AND (((b0_.date_from IS NULL OR (b0_.date_from <= '2026-04-04 14:09:06' AND b0_.date_to >= '2026-04-04 14:09:06')) AND (b0_.date_to IS NULL OR (b0_.date_to >= '2026-04-04 14:09:06' AND b0_.date_from <= '2026-04-04 14:09:06')))) AND b0_.enabled = 1 ORDER BY b0_.publish_date DESC LIMIT 9;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.unique_name AS unique_name_3, 
  t0.slug AS slug_4, 
  t0.created AS created_5, 
  t0.updated AS updated_6, 
  t0.enabled AS enabled_7 
FROM 
  blog_category t0 
WHERE 
  t0.enabled = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unique_name AS unique_name_3, t0.slug AS slug_4, t0.created AS created_5, t0.updated AS updated_6, t0.enabled AS enabled_7 FROM blog_category t0 WHERE t0.enabled = 1;