Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.23 ms Query time

5 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.24 ms

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 FROM country c0_ WHERE (c0_.slug = ?) AND (c0_.deleted_at IS NULL)

Parameters:

[
  "RU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.locales AS locales_2,
  c0_.active AS active_3,
  c0_.enable AS enable_4,
  c0_.code AS code_5,
  c0_.commission AS commission_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.currency_id AS currency_id_8
FROM
  country c0_
WHERE
  (c0_.slug = ?)
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.locales AS locales_2, c0_.active AS active_3, c0_.enable AS enable_4, c0_.code AS code_5, c0_.commission AS commission_6, c0_.deleted_at AS deleted_at_7, c0_.currency_id AS currency_id_8 FROM country c0_ WHERE (c0_.slug = 'RU') AND (c0_.deleted_at IS NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 48)
7	App\Geo\Repository\CountryRepository->findOneByCode (line 29)
8	App\Geo\Service\CountryService->getCountry (line 34)
9	App\Locale\Event\Subscriber\RequestSubscriber->onKernelRequest (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.74 ms

SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.entity AS entity_2, s0_.entity_id AS entity_id_3, s0_.created_at AS created_at_4 FROM slug s0_ WHERE s0_.value = ?

Parameters:

[
  "111-portugaliya"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.value AS value_1,
  s0_.entity AS entity_2,
  s0_.entity_id AS entity_id_3,
  s0_.created_at AS created_at_4
FROM
  slug s0_
WHERE
  s0_.value = ?

SELECT s0_.id AS id_0, s0_.value AS value_1, s0_.entity AS entity_2, s0_.entity_id AS entity_id_3, s0_.created_at AS created_at_4 FROM slug s0_ WHERE s0_.value = '111-portugaliya';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 37)
7	App\Core\Repository\SlugRepository->findOneBySlug (line 62)
8	App\Core\ValueResolver\EntitySlugResolver->getEntity (line 46)
9	App\Core\ValueResolver\EntitySlugResolver->resolve (line 60)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
11	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
12	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.57 ms

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.location_confirm AS location_confirm_3, t0.split_type AS split_type_4, t0.commission AS commission_5, t0.type AS type_6, t0.count_artists AS count_artists_7, t0.count_musicians AS count_musicians_8, t0.live AS live_9, t0.pre_sale AS pre_sale_10, t0.duration AS duration_11, t0.status AS status_12, t0.sell_status AS sell_status_13, t0.recommended_age AS recommended_age_14, t0.age_restrictions AS age_restrictions_15, t0.social AS social_16, t0.locale AS locale_17, t0.tax AS tax_18, t0.free_places AS free_places_19, t0.buyed_tickets AS buyed_tickets_20, t0.favorites_count AS favorites_count_21, t0.min_sell_goal AS min_sell_goal_22, t0.max_sell_goal AS max_sell_goal_23, t0.active AS active_24, t0.sell AS sell_25, t0.date AS date_26, t0.start_date AS start_date_27, t0.end_date AS end_date_28, t0.doors AS doors_29, t0.start_sale_at AS start_sale_at_30, t0.end_sale_at AS end_sale_at_31, t0.created_at AS created_at_32, t0.slug AS slug_33, t0.deleted_at AS deleted_at_34, t0.moderation_status AS moderation_status_35, t0.creator_id AS creator_id_36, t0.location_id AS location_id_37, t0.country_id AS country_id_38, t0.city_id AS city_id_39, t0.currency_id AS currency_id_40, t0.cover_id AS cover_id_41, t0.gallery_id AS gallery_id_42, t0.video_gallery_id AS video_gallery_id_43 FROM event t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  "61"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hash AS hash_2,
  t0.location_confirm AS location_confirm_3,
  t0.split_type AS split_type_4,
  t0.commission AS commission_5,
  t0.type AS type_6,
  t0.count_artists AS count_artists_7,
  t0.count_musicians AS count_musicians_8,
  t0.live AS live_9,
  t0.pre_sale AS pre_sale_10,
  t0.duration AS duration_11,
  t0.status AS status_12,
  t0.sell_status AS sell_status_13,
  t0.recommended_age AS recommended_age_14,
  t0.age_restrictions AS age_restrictions_15,
  t0.social AS social_16,
  t0.locale AS locale_17,
  t0.tax AS tax_18,
  t0.free_places AS free_places_19,
  t0.buyed_tickets AS buyed_tickets_20,
  t0.favorites_count AS favorites_count_21,
  t0.min_sell_goal AS min_sell_goal_22,
  t0.max_sell_goal AS max_sell_goal_23,
  t0.active AS active_24,
  t0.sell AS sell_25,
  t0.date AS date_26,
  t0.start_date AS start_date_27,
  t0.end_date AS end_date_28,
  t0.doors AS doors_29,
  t0.start_sale_at AS start_sale_at_30,
  t0.end_sale_at AS end_sale_at_31,
  t0.created_at AS created_at_32,
  t0.slug AS slug_33,
  t0.deleted_at AS deleted_at_34,
  t0.moderation_status AS moderation_status_35,
  t0.creator_id AS creator_id_36,
  t0.location_id AS location_id_37,
  t0.country_id AS country_id_38,
  t0.city_id AS city_id_39,
  t0.currency_id AS currency_id_40,
  t0.cover_id AS cover_id_41,
  t0.gallery_id AS gallery_id_42,
  t0.video_gallery_id AS video_gallery_id_43
FROM
  event t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.hash AS hash_2, t0.location_confirm AS location_confirm_3, t0.split_type AS split_type_4, t0.commission AS commission_5, t0.type AS type_6, t0.count_artists AS count_artists_7, t0.count_musicians AS count_musicians_8, t0.live AS live_9, t0.pre_sale AS pre_sale_10, t0.duration AS duration_11, t0.status AS status_12, t0.sell_status AS sell_status_13, t0.recommended_age AS recommended_age_14, t0.age_restrictions AS age_restrictions_15, t0.social AS social_16, t0.locale AS locale_17, t0.tax AS tax_18, t0.free_places AS free_places_19, t0.buyed_tickets AS buyed_tickets_20, t0.favorites_count AS favorites_count_21, t0.min_sell_goal AS min_sell_goal_22, t0.max_sell_goal AS max_sell_goal_23, t0.active AS active_24, t0.sell AS sell_25, t0.date AS date_26, t0.start_date AS start_date_27, t0.end_date AS end_date_28, t0.doors AS doors_29, t0.start_sale_at AS start_sale_at_30, t0.end_sale_at AS end_sale_at_31, t0.created_at AS created_at_32, t0.slug AS slug_33, t0.deleted_at AS deleted_at_34, t0.moderation_status AS moderation_status_35, t0.creator_id AS creator_id_36, t0.location_id AS location_id_37, t0.country_id AS country_id_38, t0.city_id AS city_id_39, t0.currency_id AS currency_id_40, t0.cover_id AS cover_id_41, t0.gallery_id AS gallery_id_42, t0.video_gallery_id AS video_gallery_id_43 FROM event t0 WHERE t0.id = '61' AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 65)
6	App\Core\ValueResolver\EntitySlugResolver->getEntity (line 46)
7	App\Core\ValueResolver\EntitySlugResolver->resolve (line 60)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.68 ms

SELECT t0.id AS id_1, t0.legal_status AS legal_status_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.yandex AS yandex_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.bank_account AS bank_account_10, t0.created_at AS created_at_11, t0.active AS active_12, t0.verified AS verified_13, t0.locale AS locale_14, t0.payment_account_id AS payment_account_id_15, t0.deleted_at AS deleted_at_16, t0.hash AS hash_17, t0.photo_id AS photo_id_18, t0.city_id AS city_id_19, t0.country_id AS country_id_20, t0.type, t0.artist_role AS artist_role_21, t0.age AS age_22, t0.social AS social_23, t0.social AS social_24 FROM user t0 WHERE t0.id = ? AND t0.type IN ('system', 'new', 'artist', 'location', 'manager', 'organizer', 'label') AND ((t0.deleted_at IS NULL))

Parameters:

[
  142
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.legal_status AS legal_status_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.yandex AS yandex_7,
  t0.last_name AS last_name_8,
  t0.phone AS phone_9,
  t0.bank_account AS bank_account_10,
  t0.created_at AS created_at_11,
  t0.active AS active_12,
  t0.verified AS verified_13,
  t0.locale AS locale_14,
  t0.payment_account_id AS payment_account_id_15,
  t0.deleted_at AS deleted_at_16,
  t0.hash AS hash_17,
  t0.photo_id AS photo_id_18,
  t0.city_id AS city_id_19,
  t0.country_id AS country_id_20,
  t0.type,
  t0.artist_role AS artist_role_21,
  t0.age AS age_22,
  t0.social AS social_23,
  t0.social AS social_24
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'system', 'new', 'artist', 'location',
    'manager', 'organizer', 'label'
  )
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.legal_status AS legal_status_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.yandex AS yandex_7, t0.last_name AS last_name_8, t0.phone AS phone_9, t0.bank_account AS bank_account_10, t0.created_at AS created_at_11, t0.active AS active_12, t0.verified AS verified_13, t0.locale AS locale_14, t0.payment_account_id AS payment_account_id_15, t0.deleted_at AS deleted_at_16, t0.hash AS hash_17, t0.photo_id AS photo_id_18, t0.city_id AS city_id_19, t0.country_id AS country_id_20, t0.type, t0.artist_role AS artist_role_21, t0.age AS age_22, t0.social AS social_23, t0.social AS social_24 FROM user t0 WHERE t0.id = 142 AND t0.type IN ('system', 'new', 'artist', 'location', 'manager', 'organizer', 'label') AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 820)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3102)
4	Doctrine\ORM\UnitOfWork->createEntity (line 173)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 65)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 270)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
10	Doctrine\ORM\EntityManager->find (line 197)
11	Doctrine\ORM\EntityRepository->find (line 65)
12	App\Core\ValueResolver\EntitySlugResolver->getEntity (line 46)
13	App\Core\ValueResolver\EntitySlugResolver->resolve (line 60)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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.

Entities Mapping

Class	Mapping errors
App\Geo\Entity\Country	If association App\Geo\Entity\Country#currency is many-to-one, then the inversed side App\Price\Entity\Currency#countries has to be one-to-many.
App\Price\Entity\Currency	No errors.
App\Geo\Entity\City	No errors.
App\Geo\Entity\CountryRequisite	No errors.
App\Geo\Entity\CountryTranslation	No errors.
App\Core\Entity\Slug	No errors.
App\Event\Entity\Event	The mappings App\Event\Entity\Event#eventContacts and App\Event\Entity\EventContact#event are inconsistent with each other.
App\User\Entity\User	No errors.
App\Location\Entity\Location	No errors.
App\Storage\Entity\File	No errors.
App\Storage\Entity\Image	No errors.
App\Storage\Entity\Gallery	The mappings App\Storage\Entity\Gallery#galleryMedias and App\Storage\Entity\GalleryMedia#gallery are inconsistent with each other.
App\User\Entity\SystemUser	No errors.
App\User\Entity\NewUser	No errors.
App\User\Entity\ArtistUser	No errors.
App\User\Entity\LocationUser	No errors.
App\User\Entity\ManagerUser	No errors.
App\User\Entity\OrganizerUser	No errors.
App\User\Entity\LabelUser	No errors.
App\User\Entity\UserRequisite	No errors.
App\Band\Entity\Band	The association App\Band\Entity\Band#country refers to the inverse side field App\Geo\Entity\Country#bands which does not exist.
App\Band\Entity\BandInvite	No errors.
App\Event\Entity\EventContact	The association App\Event\Entity\EventContact#event refers to the inverse side field App\Event\Entity\Event#EventContacts which does not exist.
App\Core\Entity\Genre	No errors.
App\Event\Entity\EventBand	No errors.
App\Event\Entity\EventManager	No errors.
App\Event\Entity\EventInvite	No errors.
App\Event\Entity\EventSplit	No errors.
App\Event\Entity\EventPartner	No errors.
App\Event\Entity\EventHall	No errors.
App\Event\Entity\EventZone	No errors.
App\Event\Entity\EventPrice	No errors.
App\Payment\Entity\UserPayment	No errors.
App\Review\Entity\Review	No errors.
App\Event\Entity\EventTicketType	No errors.
App\Event\Entity\EventTranslation	No errors.

Symfony Profiler

GET https://dev.back.garmon.io/api/core/entity/check/111-portugaliya

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping