Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.content AS content_2,
  c0_.teaser AS teaser_3,
  c0_.date_from AS date_from_4,
  c0_.date_to AS date_to_5,
  c0_.time_from AS time_from_6,
  c0_.time_to AS time_to_7,
  c0_.published_from AS published_from_8,
  c0_.published_to AS published_to_9,
  c0_.url_link AS url_link_10,
  c0_.location AS location_11,
  c0_.organizer AS organizer_12,
  c0_.phone AS phone_13,
  c0_.email AS email_14,
  c0_.published AS published_15,
  c0_.slug AS slug_16,
  c0_.contact_person AS contact_person_17,
  c0_.created_by AS created_by_18,
  c0_.icon AS icon_19,
  c0_.category AS category_20,
  c0_.e_search AS e_search_21,
  c0_.visibility AS visibility_22,
  c0_.created_at AS created_at_23,
  c0_.edited_at AS edited_at_24,
  c0_.last_check_at AS last_check_at_25,
  c0_.next_check_at AS next_check_at_26
FROM
  cms_event c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('event')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Event'
  )
WHERE
  c1_.site_id = ?
  AND c0_.date_from <= ?
  AND c0_.date_from >= ?
ORDER BY
  c0_.date_from DESC
LIMIT
  100

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.content AS content_2, c0_.teaser AS teaser_3, c0_.date_from AS date_from_4, c0_.date_to AS date_to_5, c0_.time_from AS time_from_6, c0_.time_to AS time_to_7, c0_.published_from AS published_from_8, c0_.published_to AS published_to_9, c0_.url_link AS url_link_10, c0_.location AS location_11, c0_.organizer AS organizer_12, c0_.phone AS phone_13, c0_.email AS email_14, c0_.published AS published_15, c0_.slug AS slug_16, c0_.contact_person AS contact_person_17, c0_.created_by AS created_by_18, c0_.icon AS icon_19, c0_.category AS category_20, c0_.e_search AS e_search_21, c0_.visibility AS visibility_22, c0_.created_at AS created_at_23, c0_.edited_at AS edited_at_24, c0_.last_check_at AS last_check_at_25, c0_.next_check_at AS next_check_at_26 FROM cms_event c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('event') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Event') WHERE c1_.site_id = '1' AND c0_.date_from <= '2026-01-01 00:00:00' AND c0_.date_from >= '2025-01-01 23:59:59' ORDER BY c0_.date_from DESC LIMIT 100;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  cms_event c0_
  LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id
  AND c1_.item_type IN ('event')
  LEFT JOIN cms_language_info c2_ ON (
    c0_.id = c2_.entity_id
    AND c2_.entity_name = 'Event'
  )
WHERE
  c1_.site_id = ?
  AND c0_.date_from <= ?
  AND c0_.date_from >= ?

SELECT COUNT(c0_.id) AS sclr_0 FROM cms_event c0_ LEFT JOIN cms_site_items c1_ ON c0_.id = c1_.item_id AND c1_.item_type IN ('event') LEFT JOIN cms_language_info c2_ ON (c0_.id = c2_.entity_id AND c2_.entity_name = 'Event') WHERE c1_.site_id = '1' AND c0_.date_from <= '2026-01-01 00:00:00' AND c0_.date_from >= '2025-01-01 23:59:59';