Query Metrics
3
Database Queries
3
Different statements
5.44 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.26 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:
[
"599"
]
|
2 | 0.45 ms |
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"
]
|
3 | 3.73 ms |
SELECT t0.id AS id_1, t0.hour AS hour_2, t0.date AS date_3, t0.court_cost AS court_cost_4, t0.available AS available_5, t0.scraped_at AS scraped_at_6, t0.court_number AS court_number_7, t0.lead_time AS lead_time_8, t0.time_first_scrape AS time_first_scrape_9, t0.time_court_taken AS time_court_taken_10, t0.time_court_released AS time_court_released_11, t0.snap_up_time AS snap_up_time_12, t0.venue_id AS venue_id_13 FROM tennis_court_availability t0 WHERE t0.venue_id = ? AND t0.date = ?
Parameters:
[ 599 "2025-04-17" ] |
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 |
|
App\Entity\TennisVenues |
|
App\Entity\TennisCourtAvailability |
|
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. |