https://tennisfinder.atts-systems.com/tenniscourt/availability/scrape/599/2025-04-17

Query Metrics

3 Database Queries
3 Different statements
5.44 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.73 ms
(68.58%)
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 = ?
Parameters:
[
  599
  "2025-04-17"
]
1.26 ms
(23.21%)
1
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:
[
  "599"
]
0.45 ms
(8.21%)
1
SELECT t0.id AS id_1, t0.scrape_day_count AS scrape_day_count_2, t0.future_court_availability_days_count AS future_court_availability_days_count_3, t0.google_api_distance_count AS google_api_distance_count_4 FROM settings t0 WHERE t0.id = ?
Parameters:
[
  "1"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

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