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 >= '2020-11-01 00:00:00' AND b0_.publish_date <= '2020-11-30 00:00:00') AND (((b0_.date_from IS NULL OR (b0_.date_from <= '2026-04-04 08:08:20' AND b0_.date_to >= '2026-04-04 08:08:20')) AND (b0_.date_to IS NULL OR (b0_.date_to >= '2026-04-04 08:08:20' AND b0_.date_from <= '2026-04-04 08:08:20')))) 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 >= '2020-11-01 00:00:00' AND b0_.publish_date <= '2020-11-30 00:00:00') AND (((b0_.date_from IS NULL OR (b0_.date_from <= '2026-04-04 08:08:20' AND b0_.date_to >= '2026-04-04 08:08:20')) AND (b0_.date_to IS NULL OR (b0_.date_to >= '2026-04-04 08:08:20' AND b0_.date_from <= '2026-04-04 08:08:20')))) 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;

SELECT 
  t0.author_id AS author_id_1, 
  t0.id AS id_2, 
  t0.title AS title_3, 
  t0.slug AS slug_4, 
  t0.excerpt AS excerpt_5, 
  t0.content AS content_6, 
  t0.image_name AS image_name_7, 
  t0.meta_title AS meta_title_8, 
  t0.meta_keywords AS meta_keywords_9, 
  t0.meta_description AS meta_description_10, 
  t0.publish_date AS publish_date_11, 
  t0.date_from AS date_from_12, 
  t0.date_to AS date_to_13, 
  t0.highlight AS highlight_14, 
  t0.created AS created_15, 
  t0.updated AS updated_16, 
  t0.enabled AS enabled_17, 
  t0.author_id AS author_id_18 
FROM 
  blog_post t0 
WHERE 
  t0.enabled = ? 
ORDER BY 
  t0.created DESC 
LIMIT 
  5

SELECT t0.author_id AS author_id_1, t0.id AS id_2, t0.title AS title_3, t0.slug AS slug_4, t0.excerpt AS excerpt_5, t0.content AS content_6, t0.image_name AS image_name_7, t0.meta_title AS meta_title_8, t0.meta_keywords AS meta_keywords_9, t0.meta_description AS meta_description_10, t0.publish_date AS publish_date_11, t0.date_from AS date_from_12, t0.date_to AS date_to_13, t0.highlight AS highlight_14, t0.created AS created_15, t0.updated AS updated_16, t0.enabled AS enabled_17, t0.author_id AS author_id_18 FROM blog_post t0 WHERE t0.enabled = 1 ORDER BY t0.created DESC LIMIT 5;