Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.hour AS hour_2,
  t0.date AS date_3,
  t0.court_cost AS court_cost_4,
  t0.available AS available_5,
  t0.scraped_at AS scraped_at_6,
  t0.court_number AS court_number_7,
  t0.lead_time AS lead_time_8,
  t0.time_first_scrape AS time_first_scrape_9,
  t0.time_court_taken AS time_court_taken_10,
  t0.time_court_released AS time_court_released_11,
  t0.snap_up_time AS snap_up_time_12,
  t0.venue_id AS venue_id_13
FROM
  tennis_court_availability t0
WHERE
  t0.venue_id = ?
  AND t0.date = ?
  AND t0.hour = ?
  AND t0.court_number = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hour AS hour_2, t0.date AS date_3, t0.court_cost AS court_cost_4, t0.available AS available_5, t0.scraped_at AS scraped_at_6, t0.court_number AS court_number_7, t0.lead_time AS lead_time_8, t0.time_first_scrape AS time_first_scrape_9, t0.time_court_taken AS time_court_taken_10, t0.time_court_released AS time_court_released_11, t0.snap_up_time AS snap_up_time_12, t0.venue_id AS venue_id_13 FROM tennis_court_availability t0 WHERE t0.venue_id = 613 AND t0.date = '2025-04-19' AND t0.hour = 7 AND t0.court_number = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.time AS time_3,
  t0.weather AS weather_4,
  t0.location AS location_5,
  t0.rain AS rain_6
FROM
  weather t0
WHERE
  t0.date = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date AS date_2, t0.time AS time_3, t0.weather AS weather_4, t0.location AS location_5, t0.rain AS rain_6 FROM weather t0 WHERE t0.date = '2025-04-19 07:00:00' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.hour AS hour_2,
  t0.date AS date_3,
  t0.court_cost AS court_cost_4,
  t0.available AS available_5,
  t0.scraped_at AS scraped_at_6,
  t0.court_number AS court_number_7,
  t0.lead_time AS lead_time_8,
  t0.time_first_scrape AS time_first_scrape_9,
  t0.time_court_taken AS time_court_taken_10,
  t0.time_court_released AS time_court_released_11,
  t0.snap_up_time AS snap_up_time_12,
  t0.venue_id AS venue_id_13
FROM
  tennis_court_availability t0
WHERE
  t0.venue_id = ?
  AND t0.date = ?

SELECT t0.id AS id_1, t0.hour AS hour_2, t0.date AS date_3, t0.court_cost AS court_cost_4, t0.available AS available_5, t0.scraped_at AS scraped_at_6, t0.court_number AS court_number_7, t0.lead_time AS lead_time_8, t0.time_first_scrape AS time_first_scrape_9, t0.time_court_taken AS time_court_taken_10, t0.time_court_released AS time_court_released_11, t0.snap_up_time AS snap_up_time_12, t0.venue_id AS venue_id_13 FROM tennis_court_availability t0 WHERE t0.venue_id = 613 AND t0.date = '2025-04-19';

SELECT
  t0.id AS id_1,
  t0.venue AS venue_2,
  t0.address AS address_3,
  t0.map_link AS map_link_4,
  t0.web_link AS web_link_5,
  t0.tel_number AS tel_number_6,
  t0.email AS email_7,
  t0.booking_engine AS booking_engine_8,
  t0.london_region AS london_region_9,
  t0.is_active AS is_active_10,
  t0.parking AS parking_11,
  t0.toilet AS toilet_12,
  t0.photo1 AS photo1_13,
  t0.photo2 AS photo2_14,
  t0.address_postcode AS address_postcode_15,
  t0.address_city AS address_city_16,
  t0.address_country AS address_country_17,
  t0.club_description AS club_description_18,
  t0.booking_url AS booking_url_19,
  t0.travel_directions AS travel_directions_20,
  t0.tube_station AS tube_station_21,
  t0.allow_future_reservations AS allow_future_reservations_22,
  t0.last_edited_at AS last_edited_at_23,
  t0.indoor_courts AS indoor_courts_24,
  t0.floodlights AS floodlights_25,
  t0.number_of_courts AS number_of_courts_26,
  t0.details_checked AS details_checked_27,
  t0.members_club AS members_club_28,
  t0.court_surface AS court_surface_29,
  t0.longitude AS longitude_30,
  t0.latitude AS latitude_31,
  t0.short_code AS short_code_32,
  t0.last_edited_by_id AS last_edited_by_id_33
FROM
  tennis_venues t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.venue AS venue_2, t0.address AS address_3, t0.map_link AS map_link_4, t0.web_link AS web_link_5, t0.tel_number AS tel_number_6, t0.email AS email_7, t0.booking_engine AS booking_engine_8, t0.london_region AS london_region_9, t0.is_active AS is_active_10, t0.parking AS parking_11, t0.toilet AS toilet_12, t0.photo1 AS photo1_13, t0.photo2 AS photo2_14, t0.address_postcode AS address_postcode_15, t0.address_city AS address_city_16, t0.address_country AS address_country_17, t0.club_description AS club_description_18, t0.booking_url AS booking_url_19, t0.travel_directions AS travel_directions_20, t0.tube_station AS tube_station_21, t0.allow_future_reservations AS allow_future_reservations_22, t0.last_edited_at AS last_edited_at_23, t0.indoor_courts AS indoor_courts_24, t0.floodlights AS floodlights_25, t0.number_of_courts AS number_of_courts_26, t0.details_checked AS details_checked_27, t0.members_club AS members_club_28, t0.court_surface AS court_surface_29, t0.longitude AS longitude_30, t0.latitude AS latitude_31, t0.short_code AS short_code_32, t0.last_edited_by_id AS last_edited_by_id_33 FROM tennis_venues t0 WHERE t0.id = 613;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.hour AS hour_3,
  t0.flag AS flag_4,
  t0.user_id AS user_id_5
FROM
  client_court_times t0

SELECT t0.id AS id_1, t0.date AS date_2, t0.hour AS hour_3, t0.flag AS flag_4, t0.user_id AS user_id_5 FROM client_court_times t0;