Symfony Profiler

SELECT
  t0.title AS title_1,
  t0.slug AS slug_2,
  t0.image_path AS image_path_3,
  t0.location AS location_4,
  t0.description AS description_5,
  t0.starts_at AS starts_at_6,
  t0.ends_at AS ends_at_7,
  t0.participants_count AS participants_count_8,
  t0.private AS private_9,
  t0.position AS position_10,
  t0.status AS status_11,
  t0.publish_at AS publish_at_12,
  t0.event_type AS event_type_13,
  t0.visibility AS visibility_14,
  t0.short_description AS short_description_15,
  t0.date_mode AS date_mode_16,
  t0.recurrence AS recurrence_17,
  t0.all_day AS all_day_18,
  t0.timezone AS timezone_19,
  t0.reminder AS reminder_20,
  t0.show_in_calendar AS show_in_calendar_21,
  t0.arrival_time AS arrival_time_22,
  t0.location_type AS location_type_23,
  t0.address AS address_24,
  t0.city AS city_25,
  t0.postal_code AS postal_code_26,
  t0.latitude AS latitude_27,
  t0.longitude AS longitude_28,
  t0.online_url AS online_url_29,
  t0.access_instructions AS access_instructions_30,
  t0.meeting_point AS meeting_point_31,
  t0.gallery AS gallery_32,
  t0.registration_required AS registration_required_33,
  t0.capacity AS capacity_34,
  t0.waitlist AS waitlist_35,
  t0.show_participants AS show_participants_36,
  t0.allow_guest_invites AS allow_guest_invites_37,
  t0.comments_enabled AS comments_enabled_38,
  t0.email_updates AS email_updates_39,
  t0.id AS id_40,
  t0.created_at AS created_at_41,
  t0.updated_at AS updated_at_42,
  t0.deleted_at AS deleted_at_43,
  t0.category_id AS category_id_44,
  t0.organizer_id AS organizer_id_45
FROM
  event t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.title AS title_1, t0.slug AS slug_2, t0.image_path AS image_path_3, t0.location AS location_4, t0.description AS description_5, t0.starts_at AS starts_at_6, t0.ends_at AS ends_at_7, t0.participants_count AS participants_count_8, t0.private AS private_9, t0.position AS position_10, t0.status AS status_11, t0.publish_at AS publish_at_12, t0.event_type AS event_type_13, t0.visibility AS visibility_14, t0.short_description AS short_description_15, t0.date_mode AS date_mode_16, t0.recurrence AS recurrence_17, t0.all_day AS all_day_18, t0.timezone AS timezone_19, t0.reminder AS reminder_20, t0.show_in_calendar AS show_in_calendar_21, t0.arrival_time AS arrival_time_22, t0.location_type AS location_type_23, t0.address AS address_24, t0.city AS city_25, t0.postal_code AS postal_code_26, t0.latitude AS latitude_27, t0.longitude AS longitude_28, t0.online_url AS online_url_29, t0.access_instructions AS access_instructions_30, t0.meeting_point AS meeting_point_31, t0.gallery AS gallery_32, t0.registration_required AS registration_required_33, t0.capacity AS capacity_34, t0.waitlist AS waitlist_35, t0.show_participants AS show_participants_36, t0.allow_guest_invites AS allow_guest_invites_37, t0.comments_enabled AS comments_enabled_38, t0.email_updates AS email_updates_39, t0.id AS id_40, t0.created_at AS created_at_41, t0.updated_at AS updated_at_42, t0.deleted_at AS deleted_at_43, t0.category_id AS category_id_44, t0.organizer_id AS organizer_id_45 FROM event t0 WHERE t0.slug = 'match-de-foot-amical-2' LIMIT 1;

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_.status = 'published'
      OR (
        e0_.status = 'scheduled'
        AND e0_.publish_at <= ?
      )
    )
  )
  AND e0_.private = ?
ORDER BY
  e0_.position ASC,
  e0_.starts_at ASC
LIMIT
  5

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_.status = 'published' OR (e0_.status = 'scheduled' AND e0_.publish_at <= '2026-11-06 17:14:07'))) AND e0_.private = 0 ORDER BY e0_.position ASC, e0_.starts_at ASC LIMIT 5;

SELECT
  t0.status AS status_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.event_id AS event_id_5,
  t0.user_id AS user_id_6
FROM
  event_registration t0
WHERE
  t0.event_id = ?
  AND t0.status = ?
ORDER BY
  t0.created_at ASC

SELECT t0.status AS status_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.event_id AS event_id_5, t0.user_id AS user_id_6 FROM event_registration t0 WHERE t0.event_id = '01a1679a-9a98-1ee8-0d07-0c4d57c469f2' AND t0.status = 'going' ORDER BY t0.created_at ASC;

SET
  TIME ZONE 'Europe/Paris'

SET TIME ZONE 'Europe/Paris';

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
WHERE
  t0.id = ?

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 WHERE t0.id = '01a1679a-9a97-5220-6c26-b67fe96a2e78';

SELECT
  COUNT(*)
FROM
  event_registration t0
WHERE
  t0.event_id = ?
  AND t0.status = ?

SELECT COUNT(*) FROM event_registration t0 WHERE t0.event_id = '01a1679a-9a98-1ee8-0d07-0c4d57c469f2' AND t0.status = 'waitlist';