Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

1.73 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.73 ms (100.00%)	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: [`"606"`] 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 = '606';

Time▼

Count

Info

1.73 ms
(100.00%)

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:

[
  "606"
]

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 = '606';

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\TennisCourtPreferences	No errors.
App\Entity\TennisBookings	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\Cms	No errors.
App\Entity\ComplexReservation	No errors.
App\Entity\CourtSurface	No errors.
App\Entity\TennisVenuesDistances	No errors.
App\Entity\Settings	No errors.
App\Entity\Payments	No errors.
App\Entity\TennisPlayerConnections	No errors.
App\Entity\Weather	No errors.

Symfony Profiler

https://tennisfinder.atts-systems.com/tennisvenues/venue_address/606

Configuration Settings

Theme