Symfony Profiler

Query Metrics

63 Database Queries

13 Different statements

44.82 ms Query time

7 Invalid entities

16 Managed entities

Queries


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.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74, t0.testing_mode AS testing_mode_75 FROM company_details t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ?
SELECT COUNT(*) as count
        FROM photo_locations
        WHERE public_private = "Public"
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ?
SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ?
SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1
SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC
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.48 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.57 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.62 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-31"`] 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-31';
4	1.05 ms	SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74, t0.testing_mode AS testing_mode_75 FROM company_details t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74, t0.testing_mode AS testing_mode_75 FROM company_details t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_email AS company_email_3, t0.company_tel AS company_tel_4, t0.company_mobile AS company_mobile_5, t0.company_address_street AS company_address_street_6, t0.company_address_town AS company_address_town_7, t0.company_address_city AS company_address_city_8, t0.company_address_postal_code AS company_address_postal_code_9, t0.company_address_country AS company_address_country_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.twitter AS twitter_14, t0.favicon_live AS favicon_live_15, t0.favicon_dev AS favicon_dev_16, t0.currency AS currency_17, t0.company_email_password AS company_email_password_18, t0.company_email_import_directory AS company_email_import_directory_19, t0.company_email_import_processed_directory AS company_email_import_processed_directory_20, t0.weather_location AS weather_location_21, t0.company_website AS company_website_22, t0.company_address_longitude AS company_address_longitude_23, t0.company_address_latitude AS company_address_latitude_24, t0.company_time_zone AS company_time_zone_25, t0.company_qr_code AS company_qr_code_26, t0.footer_display_products AS footer_display_products_27, t0.footer_display_social_media AS footer_display_social_media_28, t0.footer_display_address AS footer_display_address_29, t0.footer_display_tel_numbers AS footer_display_tel_numbers_30, t0.footer_display_contact_details AS footer_display_contact_details_31, t0.header_display_login AS header_display_login_32, t0.contact_first_name AS contact_first_name_33, t0.contact_last_name AS contact_last_name_34, t0.home_page_photos_only AS home_page_photos_only_35, t0.database_password AS database_password_36, t0.sql_database AS sql_database_37, t0.header_display_tand_cs AS header_display_tand_cs_38, t0.header_display_products AS header_display_products_39, t0.header_display_sub_products AS header_display_sub_products_40, t0.footer_display_sub_products AS footer_display_sub_products_41, t0.include_contact_form_home_page AS include_contact_form_home_page_42, t0.multi_lingual AS multi_lingual_43, t0.enable_user_registration AS enable_user_registration_44, t0.include_qrcode_home_page AS include_qrcode_home_page_45, t0.header_display_contact_details AS header_display_contact_details_46, t0.header_display_business_contacts AS header_display_business_contacts_47, t0.header_display_weather AS header_display_weather_48, t0.header_display_facebook_pages AS header_display_facebook_pages_49, t0.header_display_competitors AS header_display_competitors_50, t0.facebook_reviews_history_show_months AS facebook_reviews_history_show_months_51, t0.title_useful_links AS title_useful_links_52, t0.header_display_photos AS header_display_photos_53, t0.title_products AS title_products_54, t0.title_sub_products AS title_sub_products_55, t0.company_address_map_link AS company_address_map_link_56, t0.company_address_instructions AS company_address_instructions_57, t0.registration_email AS registration_email_58, t0.user_include_home_address AS user_include_home_address_59, t0.user_include_business_address AS user_include_business_address_60, t0.user_include_personal_details AS user_include_personal_details_61, t0.user_include_job_details AS user_include_job_details_62, t0.website_contacts_email_alert AS website_contacts_email_alert_63, t0.website_contacts_auto_reply AS website_contacts_auto_reply_64, t0.contact_from_response AS contact_from_response_65, t0.default_user_password AS default_user_password_66, t0.contact_from_response_duplicate_verified AS contact_from_response_duplicate_verified_67, t0.contact_from_response_duplicate_unverified AS contact_from_response_duplicate_unverified_68, t0.header_display_tel_numbers AS header_display_tel_numbers_69, t0.header_display_address AS header_display_address_70, t0.user_import_divert_business_contacts AS user_import_divert_business_contacts_71, t0.user_import_divert_competitor AS user_import_divert_competitor_72, t0.user_import_divert_target_partner AS user_import_divert_target_partner_73, t0.photo_locations_sort AS photo_locations_sort_74, t0.testing_mode AS testing_mode_75 FROM company_details t0 WHERE t0.id = 1;
5	0.82 ms	SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC Parameters: [`"Main" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9 FROM product t0 WHERE t0.category = ? AND t0.is_active = ? ORDER BY t0.ranking ASC SELECT t0.id AS id_1, t0.product AS product_2, t0.ranking AS ranking_3, t0.is_active AS is_active_4, t0.include_in_footer AS include_in_footer_5, t0.category AS category_6, t0.include_in_contact_form AS include_in_contact_form_7, t0.notes AS notes_8, t0.new_client_email AS new_client_email_9 FROM product t0 WHERE t0.category = 'Main' AND t0.is_active = 1 ORDER BY t0.ranking ASC;
6	0.39 ms	SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ? Parameters: [`"Public"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ? SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = 'Public';
7	0.32 ms	SELECT COUNT() as count FROM photo_locations WHERE public_private = "Public" Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() as count FROM photo_locations WHERE public_private = "Public" SELECT COUNT(*) as count FROM photo_locations WHERE public_private = "Public" ;
8	0.23 ms	SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ? Parameters: [`"Public"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = ? SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 WHERE t0.public_private = 'Public';
9	0.16 ms	SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0 SELECT t0.id AS id_1, t0.location AS location_2, t0.enabled_users AS enabled_users_3, t0.date AS date_4, t0.public_private AS public_private_5 FROM photo_locations t0;
10	0.45 ms	SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = ? SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.is_active = 1;
11	0.25 ms	SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1 Parameters: [`"English"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = ? LIMIT 1 SELECT t0.id AS id_1, t0.language AS language_2, t0.abbreviation AS abbreviation_3, t0.icon AS icon_4, t0.is_active AS is_active_5, t0.linked_in_other AS linked_in_other_6, t0.ranking AS ranking_7 FROM languages t0 WHERE t0.language = 'English' LIMIT 1;
12	0.72 ms	SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC Parameters: [] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC SELECT l0_.id AS id_0, l0_.language AS language_1, l0_.abbreviation AS abbreviation_2, l0_.icon AS icon_3, l0_.is_active AS is_active_4, l0_.linked_in_other AS linked_in_other_5, l0_.ranking AS ranking_6 FROM languages l0_ WHERE l0_.is_active = 1 ORDER BY l0_.ranking ASC;
13	1.66 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-31" 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-31' AND t0.hour = 7 AND t0.court_number = 1 LIMIT 1;
14	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-31" 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-31' AND t0.hour = 7 AND t0.court_number = 2 LIMIT 1;
15	0.54 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-31 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-31 07:00:00' LIMIT 1;
16	1.26 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-31" 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-31' AND t0.hour = 8 AND t0.court_number = 1 LIMIT 1;
17	1.18 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-31" 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-31' AND t0.hour = 8 AND t0.court_number = 2 LIMIT 1;
18	0.40 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-31 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-31 08:00:00' LIMIT 1;
19	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-31" 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-31' AND t0.hour = 9 AND t0.court_number = 1 LIMIT 1;
20	1.17 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-31" 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-31' AND t0.hour = 9 AND t0.court_number = 2 LIMIT 1;
21	0.38 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-31 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-31 09:00:00' LIMIT 1;
22	1.15 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-31" 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-31' AND t0.hour = 10 AND t0.court_number = 1 LIMIT 1;
23	1.12 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-31" 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-31' AND t0.hour = 10 AND t0.court_number = 2 LIMIT 1;
24	0.36 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-31 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-31 10:00:00' LIMIT 1;
25	1.09 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-31" 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-31' AND t0.hour = 11 AND t0.court_number = 1 LIMIT 1;
26	1.24 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-31" 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-31' AND t0.hour = 11 AND t0.court_number = 2 LIMIT 1;
27	1.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-31 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-31 11:00:00' LIMIT 1;
28	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-31" 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-31' AND t0.hour = 12 AND t0.court_number = 1 LIMIT 1;
29	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-31" 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-31' AND t0.hour = 12 AND t0.court_number = 2 LIMIT 1;
30	0.24 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-31 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-31 12:00:00' LIMIT 1;
31	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-31" 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-31' AND t0.hour = 13 AND t0.court_number = 1 LIMIT 1;
32	0.65 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-31" 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-31' AND t0.hour = 13 AND t0.court_number = 2 LIMIT 1;
33	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-31 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-31 13:00:00' LIMIT 1;
34	0.80 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-31" 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-31' AND t0.hour = 14 AND t0.court_number = 1 LIMIT 1;
35	0.80 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-31" 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-31' AND t0.hour = 14 AND t0.court_number = 2 LIMIT 1;
36	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-31 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-31 14:00:00' LIMIT 1;
37	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-31" 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-31' AND t0.hour = 15 AND t0.court_number = 1 LIMIT 1;
38	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-31" 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-31' AND t0.hour = 15 AND t0.court_number = 2 LIMIT 1;
39	0.23 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-31 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-31 15:00:00' LIMIT 1;
40	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-31" 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-31' AND t0.hour = 16 AND t0.court_number = 1 LIMIT 1;
41	0.80 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-31" 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-31' AND t0.hour = 16 AND t0.court_number = 2 LIMIT 1;
42	0.24 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-31 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-31 16:00:00' LIMIT 1;
43	0.71 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-31" 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-31' AND t0.hour = 17 AND t0.court_number = 1 LIMIT 1;
44	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-31" 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-31' AND t0.hour = 17 AND t0.court_number = 2 LIMIT 1;
45	0.22 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-31 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-31 17:00:00' LIMIT 1;
46	0.71 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-31" 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-31' AND t0.hour = 18 AND t0.court_number = 1 LIMIT 1;
47	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-31" 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-31' AND t0.hour = 18 AND t0.court_number = 2 LIMIT 1;
48	0.23 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-31 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-31 18:00:00' LIMIT 1;
49	0.80 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-31" 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-31' AND t0.hour = 19 AND t0.court_number = 1 LIMIT 1;
50	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-31" 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-31' AND t0.hour = 19 AND t0.court_number = 2 LIMIT 1;
51	0.22 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-31 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-31 19:00:00' LIMIT 1;
52	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-31" 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-31' AND t0.hour = 20 AND t0.court_number = 1 LIMIT 1;
53	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-31" 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-31' AND t0.hour = 20 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-31 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-31 20:00:00' LIMIT 1;
55	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-31" 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-31' AND t0.hour = 21 AND t0.court_number = 1 LIMIT 1;
56	0.80 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-31" 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-31' AND t0.hour = 21 AND t0.court_number = 2 LIMIT 1;
57	0.24 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-31 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-31 21:00:00' LIMIT 1;
58	0.76 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-31" 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-31' AND t0.hour = 22 AND t0.court_number = 1 LIMIT 1;
59	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-31" 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-31' AND t0.hour = 22 AND t0.court_number = 2 LIMIT 1;
60	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-31 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-31 22:00:00' LIMIT 1;
61	0.67 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-31" 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-31' AND t0.hour = 23 AND t0.court_number = 1 LIMIT 1;
62	0.95 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-31" 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-31' AND t0.hour = 23 AND t0.court_number = 2 LIMIT 1;
63	0.23 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-31 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-31 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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Languages	8
App\Entity\Product	5
App\Entity\TennisVenues	1
App\Entity\User	1
App\Entity\CompanyDetails	1

Entities Mapping

Class	Mapping errors
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\User	The association App\Entity\User#enabledUsers refers to the inverse side field App\Entity\User#photoLocations which does not exist.
App\Entity\TennisCourtPreferences	The association App\Entity\TennisCourtPreferences#user refers to the inverse side field App\Entity\User#tennisCourtPreferences which does not exist.
App\Entity\TennisBookings	The association App\Entity\TennisBookings#player1 refers to the inverse side field App\Entity\User#tennisBookings which does not exist. The association App\Entity\TennisBookings#player3 refers to the inverse side field App\Entity\User#tennisBookings3 which does not exist. The association App\Entity\TennisBookings#player4 refers to the inverse side field App\Entity\User#tennisBookings4 which does not exist. The association App\Entity\TennisBookings#player2 refers to the inverse side field App\Entity\User#tennisBookings2 which does not exist.
App\Entity\ClientCourtTimes	No errors.
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\CompanyDetails	No errors.
App\Entity\Product	The field App\Entity\Product#websiteContacts is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\WebsiteContacts#productsRequested does not contain the required 'mappedBy="websiteContacts"' attribute.
App\Entity\WebsiteContacts	No errors.
App\Entity\PhotoLocations	The mappings App\Entity\PhotoLocations#photos and App\Entity\Photos#location are inconsistent with each other.
App\Entity\Languages	No errors.
App\Entity\Weather	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping