Symfony Profiler

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

SELECT
  e0_.title AS title_0,
  e0_.slug AS slug_1,
  e0_.image_path AS image_path_2,
  e0_.location AS location_3,
  e0_.description AS description_4,
  e0_.starts_at AS starts_at_5,
  e0_.ends_at AS ends_at_6,
  e0_.participants_count AS participants_count_7,
  e0_.private AS private_8,
  e0_.position AS position_9,
  e0_.status AS status_10,
  e0_.publish_at AS publish_at_11,
  e0_.event_type AS event_type_12,
  e0_.visibility AS visibility_13,
  e0_.short_description AS short_description_14,
  e0_.date_mode AS date_mode_15,
  e0_.recurrence AS recurrence_16,
  e0_.all_day AS all_day_17,
  e0_.timezone AS timezone_18,
  e0_.reminder AS reminder_19,
  e0_.show_in_calendar AS show_in_calendar_20,
  e0_.arrival_time AS arrival_time_21,
  e0_.location_type AS location_type_22,
  e0_.address AS address_23,
  e0_.city AS city_24,
  e0_.postal_code AS postal_code_25,
  e0_.latitude AS latitude_26,
  e0_.longitude AS longitude_27,
  e0_.online_url AS online_url_28,
  e0_.access_instructions AS access_instructions_29,
  e0_.meeting_point AS meeting_point_30,
  e0_.gallery AS gallery_31,
  e0_.registration_required AS registration_required_32,
  e0_.capacity AS capacity_33,
  e0_.waitlist AS waitlist_34,
  e0_.show_participants AS show_participants_35,
  e0_.allow_guest_invites AS allow_guest_invites_36,
  e0_.comments_enabled AS comments_enabled_37,
  e0_.email_updates AS email_updates_38,
  e0_.id AS id_39,
  e0_.created_at AS created_at_40,
  e0_.updated_at AS updated_at_41,
  e0_.deleted_at AS deleted_at_42,
  e1_.name AS name_43,
  e1_.slug AS slug_44,
  e1_.color AS color_45,
  e1_.position AS position_46,
  e1_.id AS id_47,
  e1_.created_at AS created_at_48,
  e1_.updated_at AS updated_at_49,
  e0_.category_id AS category_id_50,
  e0_.organizer_id AS organizer_id_51
FROM
  event e0_
  LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id
WHERE
  e0_.deleted_at IS NULL
  AND e0_.private = false
  AND e0_.show_in_calendar = true
  AND (
    (
      e0_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND e0_.starts_at >= ?
  AND e0_.starts_at < ?
ORDER BY
  e0_.starts_at ASC

SELECT e0_.title AS title_0, e0_.slug AS slug_1, e0_.image_path AS image_path_2, e0_.location AS location_3, e0_.description AS description_4, e0_.starts_at AS starts_at_5, e0_.ends_at AS ends_at_6, e0_.participants_count AS participants_count_7, e0_.private AS private_8, e0_.position AS position_9, e0_.status AS status_10, e0_.publish_at AS publish_at_11, e0_.event_type AS event_type_12, e0_.visibility AS visibility_13, e0_.short_description AS short_description_14, e0_.date_mode AS date_mode_15, e0_.recurrence AS recurrence_16, e0_.all_day AS all_day_17, e0_.timezone AS timezone_18, e0_.reminder AS reminder_19, e0_.show_in_calendar AS show_in_calendar_20, e0_.arrival_time AS arrival_time_21, e0_.location_type AS location_type_22, e0_.address AS address_23, e0_.city AS city_24, e0_.postal_code AS postal_code_25, e0_.latitude AS latitude_26, e0_.longitude AS longitude_27, e0_.online_url AS online_url_28, e0_.access_instructions AS access_instructions_29, e0_.meeting_point AS meeting_point_30, e0_.gallery AS gallery_31, e0_.registration_required AS registration_required_32, e0_.capacity AS capacity_33, e0_.waitlist AS waitlist_34, e0_.show_participants AS show_participants_35, e0_.allow_guest_invites AS allow_guest_invites_36, e0_.comments_enabled AS comments_enabled_37, e0_.email_updates AS email_updates_38, e0_.id AS id_39, e0_.created_at AS created_at_40, e0_.updated_at AS updated_at_41, e0_.deleted_at AS deleted_at_42, e1_.name AS name_43, e1_.slug AS slug_44, e1_.color AS color_45, e1_.position AS position_46, e1_.id AS id_47, e1_.created_at AS created_at_48, e1_.updated_at AS updated_at_49, e0_.category_id AS category_id_50, e0_.organizer_id AS organizer_id_51 FROM event e0_ LEFT JOIN event_category e1_ ON e0_.category_id = e1_.id WHERE e0_.deleted_at IS NULL AND e0_.private = false AND e0_.show_in_calendar = true AND ((e0_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 23:42:52'))) AND e0_.starts_at >= '2027-10-01 00:00:00' AND e0_.starts_at < '2027-11-01 00:00:00' ORDER BY e0_.starts_at ASC;