Symfony Profiler

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

SELECT
  COUNT(e0_.id) AS sclr_0
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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'
  AND e1_.slug = ?

SELECT COUNT(e0_.id) AS sclr_0 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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public' AND e1_.slug = 'culture';

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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'
  AND e1_.slug = ?
ORDER BY
  e0_.starts_at ASC
LIMIT
  10

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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public' AND e1_.slug = 'culture' ORDER BY e0_.starts_at ASC LIMIT 10;

SELECT
  COUNT(e0_.id) AS sclr_0
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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'

SELECT COUNT(e0_.id) AS sclr_0 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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public';

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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'
ORDER BY
  e0_.starts_at ASC
LIMIT
  4

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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public' ORDER BY e0_.starts_at ASC LIMIT 4;

SELECT
  COUNT(e0_.id) AS sclr_0
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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'

SELECT COUNT(e0_.id) AS sclr_0 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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public';

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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND COALESCE(e0_.ends_at, e0_.starts_at) >= ?
  AND e0_.visibility = 'public'
ORDER BY
  e0_.starts_at ASC
LIMIT
  300

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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 18:10:36'))) AND COALESCE(e0_.ends_at, e0_.starts_at) >= '2026-11-06 00:00:00' AND e0_.visibility = 'public' ORDER BY e0_.starts_at ASC LIMIT 300;

SELECT
  t0.email AS email_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.status AS status_7,
  t0.reset_code_hash AS reset_code_hash_8,
  t0.reset_code_expires_at AS reset_code_expires_at_9,
  t0.reset_code_attempts AS reset_code_attempts_10,
  t0.email_verification_code_hash AS email_verification_code_hash_11,
  t0.email_verification_expires_at AS email_verification_expires_at_12,
  t0.email_verification_attempts AS email_verification_attempts_13,
  t0.avatar_path AS avatar_path_14,
  t0.birth_date AS birth_date_15,
  t0.gender AS gender_16,
  t0.preferred_locale AS preferred_locale_17,
  t0.country AS country_18,
  t0.bio AS bio_19,
  t0.city AS city_20,
  t0.interests AS interests_21,
  t0.id AS id_22,
  t0.created_at AS created_at_23,
  t0.updated_at AS updated_at_24,
  t0.deleted_at AS deleted_at_25
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.status AS status_7, t0.reset_code_hash AS reset_code_hash_8, t0.reset_code_expires_at AS reset_code_expires_at_9, t0.reset_code_attempts AS reset_code_attempts_10, t0.email_verification_code_hash AS email_verification_code_hash_11, t0.email_verification_expires_at AS email_verification_expires_at_12, t0.email_verification_attempts AS email_verification_attempts_13, t0.avatar_path AS avatar_path_14, t0.birth_date AS birth_date_15, t0.gender AS gender_16, t0.preferred_locale AS preferred_locale_17, t0.country AS country_18, t0.bio AS bio_19, t0.city AS city_20, t0.interests AS interests_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25 FROM "user" t0 WHERE t0.id = '01a1a778-ceb6-e2e1-889a-503922adfd8b';

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.color AS color_3,
  t0.position AS position_4,
  t0.id AS id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  event_category t0
ORDER BY
  t0.position ASC

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.color AS color_3, t0.position AS position_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM event_category t0 ORDER BY t0.position ASC;