Symfony Profiler

SELECT 
  s0_.Id AS Id_0, 
  s0_.name AS name_1, 
  s0_.mollie_live AS mollie_live_2, 
  s0_.mollie_test AS mollie_test_3, 
  s0_.url AS url_4, 
  s0_.aliases AS aliases_5, 
  s0_.template_folder AS template_folder_6, 
  s0_.email AS email_7, 
  s0_.email_bcc AS email_bcc_8, 
  s0_.filter_by_venue AS filter_by_venue_9, 
  s0_.master_site AS master_site_10, 
  s0_.sendy_brand AS sendy_brand_11, 
  s0_.advertising_brand AS advertising_brand_12, 
  s0_.date_created AS date_created_13, 
  s0_.date_updated AS date_updated_14, 
  s0_.LocationId AS LocationId_15, 
  s0_.ListId AS ListId_16 
FROM 
  sites s0_ 
WHERE 
  s0_.url = ?

SELECT s0_.Id AS Id_0, s0_.name AS name_1, s0_.mollie_live AS mollie_live_2, s0_.mollie_test AS mollie_test_3, s0_.url AS url_4, s0_.aliases AS aliases_5, s0_.template_folder AS template_folder_6, s0_.email AS email_7, s0_.email_bcc AS email_bcc_8, s0_.filter_by_venue AS filter_by_venue_9, s0_.master_site AS master_site_10, s0_.sendy_brand AS sendy_brand_11, s0_.advertising_brand AS advertising_brand_12, s0_.date_created AS date_created_13, s0_.date_updated AS date_updated_14, s0_.LocationId AS LocationId_15, s0_.ListId AS ListId_16 FROM sites s0_ WHERE s0_.url = 'basiliek.devel.ticketing.nu';

SELECT 
  t0.Id AS Id_1, 
  t0.name AS name_2, 
  t0.address AS address_3, 
  t0.postal_code AS postal_code_4, 
  t0.city AS city_5, 
  t0.streetnr AS streetnr_6, 
  t0.date_created AS date_created_7, 
  t0.date_updated AS date_updated_8 
FROM 
  locations t0 
WHERE 
  t0.Id = ?

SELECT t0.Id AS Id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.streetnr AS streetnr_6, t0.date_created AS date_created_7, t0.date_updated AS date_updated_8 FROM locations t0 WHERE t0.Id = 8;

SELECT 
  e0_.Id AS Id_0, 
  e0_.slug AS slug_1, 
  e0_.icon AS icon_2, 
  e0_.social_link AS social_link_3, 
  e0_.artist_name AS artist_name_4, 
  e0_.age_group AS age_group_5, 
  e0_.tier AS tier_6, 
  e0_.advertising AS advertising_7, 
  e0_.max_sales AS max_sales_8, 
  e0_.current_sales AS current_sales_9, 
  e0_.created_at AS created_at_10, 
  e0_.updated_at AS updated_at_11, 
  e0_.project AS project_12, 
  e0_.conference AS conference_13, 
  e0_.multi_day AS multi_day_14, 
  e0_.private_event AS private_event_15, 
  e1_.Id AS Id_16, 
  e1_.date_start AS date_start_17, 
  e1_.date_end AS date_end_18, 
  e1_.hidden AS hidden_19, 
  e1_.hidden_calendar AS hidden_calendar_20, 
  e1_.soldout AS soldout_21, 
  e1_.places_active AS places_active_22, 
  e1_.type AS type_23, 
  e1_.project_type AS project_type_24, 
  e1_.max_sales AS max_sales_25, 
  e2_.Id AS Id_26, 
  e2_.title AS title_27, 
  e2_.short_description AS short_description_28, 
  e2_.description AS description_29, 
  e2_.special_title AS special_title_30, 
  s3_.Id AS Id_31, 
  s3_.position AS position_32, 
  e1_.EventId AS EventId_33, 
  e1_.LocationId AS LocationId_34, 
  e2_.LanguageId AS LanguageId_35, 
  e2_.EventsId AS EventsId_36, 
  s3_.EventsId AS EventsId_37, 
  s3_.SitesId AS SitesId_38 
FROM 
  events e0_ 
  LEFT JOIN event_dates e1_ ON e0_.Id = e1_.EventId 
  LEFT JOIN event_description e2_ ON e0_.Id = e2_.EventsId 
  LEFT JOIN sites_to_events s3_ ON e0_.Id = s3_.EventsId 
WHERE 
  (
    e1_.date_start >= ? 
    AND s3_.SitesId = ?
  ) 
  AND (
    (
      e1_.date_start >= ? 
      AND s3_.SitesId = ? 
      AND e1_.LocationId = ?
    )
  ) 
  AND (e0_.project = 1) 
ORDER BY 
  e1_.date_start DESC, 
  e2_.title ASC

SELECT e0_.Id AS Id_0, e0_.slug AS slug_1, e0_.icon AS icon_2, e0_.social_link AS social_link_3, e0_.artist_name AS artist_name_4, e0_.age_group AS age_group_5, e0_.tier AS tier_6, e0_.advertising AS advertising_7, e0_.max_sales AS max_sales_8, e0_.current_sales AS current_sales_9, e0_.created_at AS created_at_10, e0_.updated_at AS updated_at_11, e0_.project AS project_12, e0_.conference AS conference_13, e0_.multi_day AS multi_day_14, e0_.private_event AS private_event_15, e1_.Id AS Id_16, e1_.date_start AS date_start_17, e1_.date_end AS date_end_18, e1_.hidden AS hidden_19, e1_.hidden_calendar AS hidden_calendar_20, e1_.soldout AS soldout_21, e1_.places_active AS places_active_22, e1_.type AS type_23, e1_.project_type AS project_type_24, e1_.max_sales AS max_sales_25, e2_.Id AS Id_26, e2_.title AS title_27, e2_.short_description AS short_description_28, e2_.description AS description_29, e2_.special_title AS special_title_30, s3_.Id AS Id_31, s3_.position AS position_32, e1_.EventId AS EventId_33, e1_.LocationId AS LocationId_34, e2_.LanguageId AS LanguageId_35, e2_.EventsId AS EventsId_36, s3_.EventsId AS EventsId_37, s3_.SitesId AS SitesId_38 FROM events e0_ LEFT JOIN event_dates e1_ ON e0_.Id = e1_.EventId LEFT JOIN event_description e2_ ON e0_.Id = e2_.EventsId LEFT JOIN sites_to_events s3_ ON e0_.Id = s3_.EventsId WHERE (e1_.date_start >= '2024-11-06 00:00:00' AND s3_.SitesId = 3) AND ((e1_.date_start >= '2024-11-06 00:00:00' AND s3_.SitesId = 3 AND e1_.LocationId = 8)) AND (e0_.project = 1) ORDER BY e1_.date_start DESC, e2_.title ASC;