Symfony Profiler

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  period p0_
  INNER JOIN event e1_ ON p0_.event_id = e1_.id
WHERE
  (
    e1_.published = 1
    AND (
      (
        p0_.period_end IS NOT NULL
        AND p0_.period_end > ?
      )
      OR (
        p0_.period_start IS NOT NULL
        AND p0_.period_start > ?
      )
    )
  )
  OR (
    p0_.all_day = 1
    AND p0_.period_start > ?
  )

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM period p0_ INNER JOIN event e1_ ON p0_.event_id = e1_.id WHERE (e1_.published = 1 AND ((p0_.period_end IS NOT NULL AND p0_.period_end > '2026-05-15 00:01:00') OR (p0_.period_start IS NOT NULL AND p0_.period_start > '2026-05-15 00:01:00'))) OR (p0_.all_day = 1 AND p0_.period_start > '2026-05-15 00:01:00');

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.period_start AS period_start_1,
  e1_.priority AS priority_2,
  e1_.name AS name_3
FROM
  period p0_
  INNER JOIN event e1_ ON p0_.event_id = e1_.id
WHERE
  (
    e1_.published = 1
    AND (
      (
        p0_.period_end IS NOT NULL
        AND p0_.period_end > ?
      )
      OR (
        p0_.period_start IS NOT NULL
        AND p0_.period_start > ?
      )
    )
  )
  OR (
    p0_.all_day = 1
    AND p0_.period_start > ?
  )
ORDER BY
  p0_.period_start ASC,
  e1_.priority DESC,
  e1_.name ASC
LIMIT
  30

SELECT DISTINCT p0_.id AS id_0, p0_.period_start AS period_start_1, e1_.priority AS priority_2, e1_.name AS name_3 FROM period p0_ INNER JOIN event e1_ ON p0_.event_id = e1_.id WHERE (e1_.published = 1 AND ((p0_.period_end IS NOT NULL AND p0_.period_end > '2026-05-15 00:01:00') OR (p0_.period_start IS NOT NULL AND p0_.period_start > '2026-05-15 00:01:00'))) OR (p0_.all_day = 1 AND p0_.period_start > '2026-05-15 00:01:00') ORDER BY p0_.period_start ASC, e1_.priority DESC, e1_.name ASC LIMIT 30;