Symfony Profiler

Query Metrics

5 Database Queries

2 Different statements

1.88 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.36 ms
(72.41%)

SELECT t0.booking_enabled AS booking_enabled_1, t0.online_payment_enabled AS online_payment_enabled_2, t0.match_enabled AS match_enabled_3, t0.tournament_enabled AS tournament_enabled_4, t0.event_enabled AS event_enabled_5, t0.subscription_enabled AS subscription_enabled_6, t0.coaching_enabled AS coaching_enabled_7, t0.school_enabled AS school_enabled_8, t0.team_building_enabled AS team_building_enabled_9, t0.shop_enabled AS shop_enabled_10, t0.license_enabled AS license_enabled_11, t0.default_booking_duration_minutes AS default_booking_duration_minutes_12, t0.min_booking_duration_minutes AS min_booking_duration_minutes_13, t0.max_booking_duration_minutes AS max_booking_duration_minutes_14, t0.booking_slot_step_minutes AS booking_slot_step_minutes_15, t0.booking_lead_time_minutes AS booking_lead_time_minutes_16, t0.booking_cancellation_limit_minutes AS booking_cancellation_limit_minutes_17, t0.no_refund_before_start_minutes AS no_refund_before_start_minutes_18, t0.allow_guest_booking AS allow_guest_booking_19, t0.require_payment_upfront AS require_payment_upfront_20, t0.default_locale AS default_locale_21, t0.default_currency AS default_currency_22, t0.metadata AS metadata_23, t0.id AS id_24, t0.token AS token_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.club_id AS club_id_28 FROM club_settings t0 WHERE t0.club_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.booking_enabled AS booking_enabled_1,
  t0.online_payment_enabled AS online_payment_enabled_2,
  t0.match_enabled AS match_enabled_3,
  t0.tournament_enabled AS tournament_enabled_4,
  t0.event_enabled AS event_enabled_5,
  t0.subscription_enabled AS subscription_enabled_6,
  t0.coaching_enabled AS coaching_enabled_7,
  t0.school_enabled AS school_enabled_8,
  t0.team_building_enabled AS team_building_enabled_9,
  t0.shop_enabled AS shop_enabled_10,
  t0.license_enabled AS license_enabled_11,
  t0.default_booking_duration_minutes AS default_booking_duration_minutes_12,
  t0.min_booking_duration_minutes AS min_booking_duration_minutes_13,
  t0.max_booking_duration_minutes AS max_booking_duration_minutes_14,
  t0.booking_slot_step_minutes AS booking_slot_step_minutes_15,
  t0.booking_lead_time_minutes AS booking_lead_time_minutes_16,
  t0.booking_cancellation_limit_minutes AS booking_cancellation_limit_minutes_17,
  t0.no_refund_before_start_minutes AS no_refund_before_start_minutes_18,
  t0.allow_guest_booking AS allow_guest_booking_19,
  t0.require_payment_upfront AS require_payment_upfront_20,
  t0.default_locale AS default_locale_21,
  t0.default_currency AS default_currency_22,
  t0.metadata AS metadata_23,
  t0.id AS id_24,
  t0.token AS token_25,
  t0.created_at AS created_at_26,
  t0.updated_at AS updated_at_27,
  t0.club_id AS club_id_28
FROM
  club_settings t0
WHERE
  t0.club_id = ?

SELECT t0.booking_enabled AS booking_enabled_1, t0.online_payment_enabled AS online_payment_enabled_2, t0.match_enabled AS match_enabled_3, t0.tournament_enabled AS tournament_enabled_4, t0.event_enabled AS event_enabled_5, t0.subscription_enabled AS subscription_enabled_6, t0.coaching_enabled AS coaching_enabled_7, t0.school_enabled AS school_enabled_8, t0.team_building_enabled AS team_building_enabled_9, t0.shop_enabled AS shop_enabled_10, t0.license_enabled AS license_enabled_11, t0.default_booking_duration_minutes AS default_booking_duration_minutes_12, t0.min_booking_duration_minutes AS min_booking_duration_minutes_13, t0.max_booking_duration_minutes AS max_booking_duration_minutes_14, t0.booking_slot_step_minutes AS booking_slot_step_minutes_15, t0.booking_lead_time_minutes AS booking_lead_time_minutes_16, t0.booking_cancellation_limit_minutes AS booking_cancellation_limit_minutes_17, t0.no_refund_before_start_minutes AS no_refund_before_start_minutes_18, t0.allow_guest_booking AS allow_guest_booking_19, t0.require_payment_upfront AS require_payment_upfront_20, t0.default_locale AS default_locale_21, t0.default_currency AS default_currency_22, t0.metadata AS metadata_23, t0.id AS id_24, t0.token AS token_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.club_id AS club_id_28 FROM club_settings t0 WHERE t0.club_id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2462)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	App\Repository\ClubRepository->findActiveClubs (line 32)
12	App\Repository\ClubRepository->findVisibleClubsForPublic (line 62)
13	App\Controller\Public\ClubController->index (line 30)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 191)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 32)
19	require_once (line 5)

0.52 ms
(27.59%)

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.description AS description_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.address AS address_5, c0_.city AS city_6, c0_.postal_code AS postal_code_7, c0_.country AS country_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.timezone AS timezone_11, c0_.currency AS currency_12, c0_.status AS status_13, c0_.logo_url AS logo_url_14, c0_.cover_url AS cover_url_15, c0_.id AS id_16, c0_.token AS token_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.organization_id AS organization_id_20 FROM club c0_ WHERE c0_.status = ? ORDER BY c0_.name ASC

Parameters:

[
  "ACTIVE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.description AS description_2,
  c0_.email AS email_3,
  c0_.phone AS phone_4,
  c0_.address AS address_5,
  c0_.city AS city_6,
  c0_.postal_code AS postal_code_7,
  c0_.country AS country_8,
  c0_.latitude AS latitude_9,
  c0_.longitude AS longitude_10,
  c0_.timezone AS timezone_11,
  c0_.currency AS currency_12,
  c0_.status AS status_13,
  c0_.logo_url AS logo_url_14,
  c0_.cover_url AS cover_url_15,
  c0_.id AS id_16,
  c0_.token AS token_17,
  c0_.created_at AS created_at_18,
  c0_.updated_at AS updated_at_19,
  c0_.organization_id AS organization_id_20
FROM
  club c0_
WHERE
  c0_.status = ?
ORDER BY
  c0_.name ASC

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.description AS description_2, c0_.email AS email_3, c0_.phone AS phone_4, c0_.address AS address_5, c0_.city AS city_6, c0_.postal_code AS postal_code_7, c0_.country AS country_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.timezone AS timezone_11, c0_.currency AS currency_12, c0_.status AS status_13, c0_.logo_url AS logo_url_14, c0_.cover_url AS cover_url_15, c0_.id AS id_16, c0_.token AS token_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.organization_id AS organization_id_20 FROM club c0_ WHERE c0_.status = 'ACTIVE' ORDER BY c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ClubRepository->findActiveClubs (line 32)
7	App\Repository\ClubRepository->findVisibleClubsForPublic (line 62)
8	App\Controller\Public\ClubController->index (line 30)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

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\Club	4
App\Entity\ClubSettings	4
App\Entity\Organization	1

Entities Mapping

Class	Mapping errors
App\Entity\Club	No errors.
App\Entity\Organization	No errors.
App\Entity\ClubSettings	No errors.
App\Entity\Court	No errors.
App\Entity\ClubStaff	No errors.
App\Entity\UserHomeClub	No errors.

Symfony Profiler

GET https://alpha.winwin-padel.com/clubs

Configuration Settings

Theme

Page Width