Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.71 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.71 ms (100.00%)	1	SELECT t0.id AS id_1, t0.company_email AS company_email_2, t0.company_tel AS company_tel_3, t0.company_address AS company_address_4, t0.company_address_coordinates AS company_address_coordinates_5, t0.cms1_en AS cms1_en_6, t0.cms2_en AS cms2_en_7, t0.cms3_en AS cms3_en_8, t0.cms4_en AS cms4_en_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.invite_player_email AS invite_player_email_14, t0.club_admin_guide AS club_admin_guide_15, t0.user_faqs AS user_faqs_16, t0.club_description AS club_description_17, t0.company_name AS company_name_18 FROM cms t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.company_email AS company_email_2, t0.company_tel AS company_tel_3, t0.company_address AS company_address_4, t0.company_address_coordinates AS company_address_coordinates_5, t0.cms1_en AS cms1_en_6, t0.cms2_en AS cms2_en_7, t0.cms3_en AS cms3_en_8, t0.cms4_en AS cms4_en_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.invite_player_email AS invite_player_email_14, t0.club_admin_guide AS club_admin_guide_15, t0.user_faqs AS user_faqs_16, t0.club_description AS club_description_17, t0.company_name AS company_name_18 FROM cms t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.company_email AS company_email_2, t0.company_tel AS company_tel_3, t0.company_address AS company_address_4, t0.company_address_coordinates AS company_address_coordinates_5, t0.cms1_en AS cms1_en_6, t0.cms2_en AS cms2_en_7, t0.cms3_en AS cms3_en_8, t0.cms4_en AS cms4_en_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.invite_player_email AS invite_player_email_14, t0.club_admin_guide AS club_admin_guide_15, t0.user_faqs AS user_faqs_16, t0.club_description AS club_description_17, t0.company_name AS company_name_18 FROM cms t0 WHERE t0.id = 1;

Time▼

Count

Info

0.71 ms
(100.00%)

SELECT t0.id AS id_1, t0.company_email AS company_email_2, t0.company_tel AS company_tel_3, t0.company_address AS company_address_4, t0.company_address_coordinates AS company_address_coordinates_5, t0.cms1_en AS cms1_en_6, t0.cms2_en AS cms2_en_7, t0.cms3_en AS cms3_en_8, t0.cms4_en AS cms4_en_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.invite_player_email AS invite_player_email_14, t0.club_admin_guide AS club_admin_guide_15, t0.user_faqs AS user_faqs_16, t0.club_description AS club_description_17, t0.company_name AS company_name_18 FROM cms t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.company_email AS company_email_2,
  t0.company_tel AS company_tel_3,
  t0.company_address AS company_address_4,
  t0.company_address_coordinates AS company_address_coordinates_5,
  t0.cms1_en AS cms1_en_6,
  t0.cms2_en AS cms2_en_7,
  t0.cms3_en AS cms3_en_8,
  t0.cms4_en AS cms4_en_9,
  t0.twitter AS twitter_10,
  t0.facebook AS facebook_11,
  t0.linked_in AS linked_in_12,
  t0.instagram AS instagram_13,
  t0.invite_player_email AS invite_player_email_14,
  t0.club_admin_guide AS club_admin_guide_15,
  t0.user_faqs AS user_faqs_16,
  t0.club_description AS club_description_17,
  t0.company_name AS company_name_18
FROM
  cms t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_email AS company_email_2, t0.company_tel AS company_tel_3, t0.company_address AS company_address_4, t0.company_address_coordinates AS company_address_coordinates_5, t0.cms1_en AS cms1_en_6, t0.cms2_en AS cms2_en_7, t0.cms3_en AS cms3_en_8, t0.cms4_en AS cms4_en_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.linked_in AS linked_in_12, t0.instagram AS instagram_13, t0.invite_player_email AS invite_player_email_14, t0.club_admin_guide AS club_admin_guide_15, t0.user_faqs AS user_faqs_16, t0.club_description AS club_description_17, t0.company_name AS company_name_18 FROM cms t0 WHERE t0.id = 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\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\TennisVenues	The association App\Entity\TennisVenues#tennisBookings refers to the owning side field App\Entity\TennisBookings#venue which does not exist.
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/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Configuration Settings

Theme