Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

54 Database Queries

5 Different statements

37.00 ms Query time

3 Invalid entities

Queries

Group similar statements


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.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.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 = ? 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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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.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 = ? AND t0.date = ? AND t0.hour = ? AND t0.court_number = ? 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

#▲	Time	Info
1	1.72 ms	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 = ? Parameters: [`601`] View formatted query View runnable query Explain query 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 = 601;
2	0.56 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
3	1.40 ms	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 = ? Parameters: [`601 "2025-05-15"`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15';
4	1.13 ms	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 Parameters: [`601 "2025-05-15" 7 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 7 AND t0.court_number = 1 LIMIT 1;
5	0.72 ms	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 Parameters: [`601 "2025-05-15" 7 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 7 AND t0.court_number = 2 LIMIT 1;
6	0.44 ms	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 Parameters: [`"2025-05-15 07:00:00"`] View formatted query View runnable query Explain query 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-05-15 07:00:00' LIMIT 1;
7	0.84 ms	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 Parameters: [`601 "2025-05-15" 8 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 8 AND t0.court_number = 1 LIMIT 1;
8	0.79 ms	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 Parameters: [`601 "2025-05-15" 8 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 8 AND t0.court_number = 2 LIMIT 1;
9	0.30 ms	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 Parameters: [`"2025-05-15 08:00:00"`] View formatted query View runnable query Explain query 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-05-15 08:00:00' LIMIT 1;
10	0.77 ms	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 Parameters: [`601 "2025-05-15" 9 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 9 AND t0.court_number = 1 LIMIT 1;
11	0.92 ms	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 Parameters: [`601 "2025-05-15" 9 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 9 AND t0.court_number = 2 LIMIT 1;
12	0.32 ms	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 Parameters: [`"2025-05-15 09:00:00"`] View formatted query View runnable query Explain query 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-05-15 09:00:00' LIMIT 1;
13	0.82 ms	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 Parameters: [`601 "2025-05-15" 10 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 10 AND t0.court_number = 1 LIMIT 1;
14	0.88 ms	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 Parameters: [`601 "2025-05-15" 10 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 10 AND t0.court_number = 2 LIMIT 1;
15	0.26 ms	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 Parameters: [`"2025-05-15 10:00:00"`] View formatted query View runnable query Explain query 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-05-15 10:00:00' LIMIT 1;
16	0.81 ms	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 Parameters: [`601 "2025-05-15" 11 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 11 AND t0.court_number = 1 LIMIT 1;
17	0.83 ms	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 Parameters: [`601 "2025-05-15" 11 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 11 AND t0.court_number = 2 LIMIT 1;
18	0.33 ms	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 Parameters: [`"2025-05-15 11:00:00"`] View formatted query View runnable query Explain query 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-05-15 11:00:00' LIMIT 1;
19	0.87 ms	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 Parameters: [`601 "2025-05-15" 12 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 12 AND t0.court_number = 1 LIMIT 1;
20	0.88 ms	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 Parameters: [`601 "2025-05-15" 12 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 12 AND t0.court_number = 2 LIMIT 1;
21	0.28 ms	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 Parameters: [`"2025-05-15 12:00:00"`] View formatted query View runnable query Explain query 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-05-15 12:00:00' LIMIT 1;
22	0.78 ms	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 Parameters: [`601 "2025-05-15" 13 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 13 AND t0.court_number = 1 LIMIT 1;
23	0.81 ms	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 Parameters: [`601 "2025-05-15" 13 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 13 AND t0.court_number = 2 LIMIT 1;
24	0.28 ms	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 Parameters: [`"2025-05-15 13:00:00"`] View formatted query View runnable query Explain query 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-05-15 13:00:00' LIMIT 1;
25	0.82 ms	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 Parameters: [`601 "2025-05-15" 14 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 14 AND t0.court_number = 1 LIMIT 1;
26	0.82 ms	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 Parameters: [`601 "2025-05-15" 14 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 14 AND t0.court_number = 2 LIMIT 1;
27	0.34 ms	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 Parameters: [`"2025-05-15 14:00:00"`] View formatted query View runnable query Explain query 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-05-15 14:00:00' LIMIT 1;
28	0.88 ms	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 Parameters: [`601 "2025-05-15" 15 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 15 AND t0.court_number = 1 LIMIT 1;
29	0.79 ms	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 Parameters: [`601 "2025-05-15" 15 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 15 AND t0.court_number = 2 LIMIT 1;
30	0.28 ms	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 Parameters: [`"2025-05-15 15:00:00"`] View formatted query View runnable query Explain query 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-05-15 15:00:00' LIMIT 1;
31	0.84 ms	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 Parameters: [`601 "2025-05-15" 16 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 16 AND t0.court_number = 1 LIMIT 1;
32	0.90 ms	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 Parameters: [`601 "2025-05-15" 16 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 16 AND t0.court_number = 2 LIMIT 1;
33	0.27 ms	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 Parameters: [`"2025-05-15 16:00:00"`] View formatted query View runnable query Explain query 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-05-15 16:00:00' LIMIT 1;
34	0.82 ms	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 Parameters: [`601 "2025-05-15" 17 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 17 AND t0.court_number = 1 LIMIT 1;
35	0.94 ms	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 Parameters: [`601 "2025-05-15" 17 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 17 AND t0.court_number = 2 LIMIT 1;
36	0.31 ms	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 Parameters: [`"2025-05-15 17:00:00"`] View formatted query View runnable query Explain query 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-05-15 17:00:00' LIMIT 1;
37	0.85 ms	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 Parameters: [`601 "2025-05-15" 18 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 18 AND t0.court_number = 1 LIMIT 1;
38	0.82 ms	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 Parameters: [`601 "2025-05-15" 18 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 18 AND t0.court_number = 2 LIMIT 1;
39	0.28 ms	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 Parameters: [`"2025-05-15 18:00:00"`] View formatted query View runnable query Explain query 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-05-15 18:00:00' LIMIT 1;
40	0.92 ms	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 Parameters: [`601 "2025-05-15" 19 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 19 AND t0.court_number = 1 LIMIT 1;
41	0.73 ms	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 Parameters: [`601 "2025-05-15" 19 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 19 AND t0.court_number = 2 LIMIT 1;
42	0.30 ms	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 Parameters: [`"2025-05-15 19:00:00"`] View formatted query View runnable query Explain query 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-05-15 19:00:00' LIMIT 1;
43	0.75 ms	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 Parameters: [`601 "2025-05-15" 20 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 20 AND t0.court_number = 1 LIMIT 1;
44	0.72 ms	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 Parameters: [`601 "2025-05-15" 20 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 20 AND t0.court_number = 2 LIMIT 1;
45	0.27 ms	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 Parameters: [`"2025-05-15 20:00:00"`] View formatted query View runnable query Explain query 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-05-15 20:00:00' LIMIT 1;
46	0.86 ms	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 Parameters: [`601 "2025-05-15" 21 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 21 AND t0.court_number = 1 LIMIT 1;
47	0.79 ms	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 Parameters: [`601 "2025-05-15" 21 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 21 AND t0.court_number = 2 LIMIT 1;
48	0.25 ms	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 Parameters: [`"2025-05-15 21:00:00"`] View formatted query View runnable query Explain query 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-05-15 21:00:00' LIMIT 1;
49	0.81 ms	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 Parameters: [`601 "2025-05-15" 22 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 22 AND t0.court_number = 1 LIMIT 1;
50	0.74 ms	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 Parameters: [`601 "2025-05-15" 22 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 22 AND t0.court_number = 2 LIMIT 1;
51	0.28 ms	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 Parameters: [`"2025-05-15 22:00:00"`] View formatted query View runnable query Explain query 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-05-15 22:00:00' LIMIT 1;
52	0.69 ms	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 Parameters: [`601 "2025-05-15" 23 1`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 23 AND t0.court_number = 1 LIMIT 1;
53	0.88 ms	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 Parameters: [`601 "2025-05-15" 23 2`] View formatted query View runnable query Explain query 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 = 601 AND t0.date = '2025-05-15' AND t0.hour = 23 AND t0.court_number = 2 LIMIT 1;
54	0.28 ms	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 Parameters: [`"2025-05-15 23:00:00"`] View formatted query View runnable query Explain query 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-05-15 23:00:00' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\ClientCourtTimes	No errors.
App\Entity\AceifyClientSelector	No errors.
App\Entity\User	The association App\Entity\User#tennisCourtAvailabilities refers to the owning side field App\Entity\TennisCourtAvailability#player which does not exist. The field App\Entity\User#aceifyClientSelector is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\AceifyClientSelector#client does not contain the required 'mappedBy="aceifyClientSelector"' attribute. If association App\Entity\User#aceifyClientSelector is many-to-one, then the inversed side App\Entity\AceifyClientSelector#client has to be one-to-many.
App\Entity\TennisVenues	The association App\Entity\TennisVenues#tennisBookings refers to the owning side field App\Entity\TennisBookings#venue which does not exist.
App\Entity\TennisCourtAvailability	The association App\Entity\TennisCourtAvailability#venue refers to the inverse side field App\Entity\TennisVenues#tennisAvailabilities which does not exist.
App\Entity\TennisVenuesDistances	No errors.
App\Entity\Settings	No errors.
App\Entity\TennisCourtPreferences	No errors.
App\Entity\TennisBookings	No errors.
App\Entity\Cms	No errors.
App\Entity\ComplexReservation	No errors.
App\Entity\CourtSurface	No errors.
App\Entity\Payments	No errors.
App\Entity\TennisPlayerConnections	No errors.
App\Entity\Weather	No errors.

Symfony Profiler

https://tennisfinder.atts-systems.com/tenniscourt/availability/tennis_court_availability_daily_detail/index/601/2025-05-15

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping