Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.71 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.31 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.telegram_id AS telegram_id_6, t0.is_verified AS is_verified_7, t8.id AS id_9, t8.published AS published_10, t8.order_id AS order_id_11, t8.first_name AS first_name_12, t8.last_name AS last_name_13, t8.middle_name AS middle_name_14, t8.sport_rank AS sport_rank_15, t8.is_online AS is_online_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.image_name AS image_name_19, t8.image_original_name AS image_original_name_20, t8.image_mime_type AS image_mime_type_21, t8.image_size AS image_size_22, t8.image_dimensions AS image_dimensions_23, t8.user_id AS user_id_24, t25.id AS id_26, t25.first_name AS first_name_27, t25.last_name AS last_name_28, t25.middle_name AS middle_name_29, t25.gender AS gender_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.user_id AS user_id_33 FROM `user` t0 LEFT JOIN trainer t8 ON t8.user_id = t0.id LEFT JOIN manager t25 ON t25.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.telegram_id AS telegram_id_6,
  t0.is_verified AS is_verified_7,
  t8.id AS id_9,
  t8.published AS published_10,
  t8.order_id AS order_id_11,
  t8.first_name AS first_name_12,
  t8.last_name AS last_name_13,
  t8.middle_name AS middle_name_14,
  t8.sport_rank AS sport_rank_15,
  t8.is_online AS is_online_16,
  t8.created_at AS created_at_17,
  t8.updated_at AS updated_at_18,
  t8.image_name AS image_name_19,
  t8.image_original_name AS image_original_name_20,
  t8.image_mime_type AS image_mime_type_21,
  t8.image_size AS image_size_22,
  t8.image_dimensions AS image_dimensions_23,
  t8.user_id AS user_id_24,
  t25.id AS id_26,
  t25.first_name AS first_name_27,
  t25.last_name AS last_name_28,
  t25.middle_name AS middle_name_29,
  t25.gender AS gender_30,
  t25.created_at AS created_at_31,
  t25.updated_at AS updated_at_32,
  t25.user_id AS user_id_33
FROM
  `user` t0
  LEFT JOIN trainer t8 ON t8.user_id = t0.id
  LEFT JOIN manager t25 ON t25.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.telegram_id AS telegram_id_6, t0.is_verified AS is_verified_7, t8.id AS id_9, t8.published AS published_10, t8.order_id AS order_id_11, t8.first_name AS first_name_12, t8.last_name AS last_name_13, t8.middle_name AS middle_name_14, t8.sport_rank AS sport_rank_15, t8.is_online AS is_online_16, t8.created_at AS created_at_17, t8.updated_at AS updated_at_18, t8.image_name AS image_name_19, t8.image_original_name AS image_original_name_20, t8.image_mime_type AS image_mime_type_21, t8.image_size AS image_size_22, t8.image_dimensions AS image_dimensions_23, t8.user_id AS user_id_24, t25.id AS id_26, t25.first_name AS first_name_27, t25.last_name AS last_name_28, t25.middle_name AS middle_name_29, t25.gender AS gender_30, t25.created_at AS created_at_31, t25.updated_at AS updated_at_32, t25.user_id AS user_id_33 FROM `user` t0 LEFT JOIN trainer t8 ON t8.user_id = t0.id LEFT JOIN manager t25 ON t25.user_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 376)
4	Doctrine\ORM\EntityRepository->find (line 87)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 38)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 45)
14	App\Serializer\AdminGroupsContextBuilder->createFromRequest (line 21)
15	ApiPlatform\Serializer\SerializerFilterContextBuilder->createFromRequest (line 44)
16	ApiPlatform\OpenApi\Serializer\SerializerContextBuilder->createFromRequest (line 30)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 76)
18	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 70)
20	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
21	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 70)
22	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 48)
23	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 92)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 161)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 193)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
32	require_once (line 32)
33	require_once (line 5)

1.77 ms

SELECT count(*) AS sclr_0 FROM page p0_ WHERE p0_.type = ?

Parameters:

[
  "main"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(*) AS sclr_0
FROM
  page p0_
WHERE
  p0_.type = ?

SELECT count(*) AS sclr_0 FROM page p0_ WHERE p0_.type = 'main';

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 89)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 66)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 90)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 92)
17	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.42 ms

SELECT p0_.id AS id_0, p0_.type AS type_1 FROM page p0_ WHERE p0_.type = ? ORDER BY p0_.id ASC LIMIT 30

Parameters:

[
  "main"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.type AS type_1
FROM
  page p0_
WHERE
  p0_.type = ?
ORDER BY
  p0_.id ASC
LIMIT
  30

SELECT p0_.id AS id_0, p0_.type AS type_1 FROM page p0_ WHERE p0_.type = 'main' ORDER BY p0_.id ASC LIMIT 30;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getResultForOffset (line 178)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 105)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
9	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 86)
10	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
11	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
12	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
13	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
14	Symfony\Component\Serializer\Serializer->normalize (line 152)
15	Symfony\Component\Serializer\Serializer->serialize (line 131)
16	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
17	ApiPlatform\State\Processor\SerializeProcessor->process (line 92)
18	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	require_once (line 5)

1.20 ms

SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM page_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM page_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 382)
8	App\Entity\Page->findTranslationByLocale (line 190)
9	App\Entity\Page->doTranslate (line 138)
10	App\Entity\Page->translate (line 75)
11	App\Entity\Page->getContent (line 59)
12	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 401)
13	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 102)
14	ApiPlatform\Serializer\AbstractItemNormalizer->getAttributeValue (line 1114)
15	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 200)
16	ApiPlatform\Serializer\AbstractItemNormalizer->normalize (line 204)
17	ApiPlatform\JsonLd\Serializer\ItemNormalizer->normalize (line 128)
18	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
19	Symfony\Component\Serializer\Serializer->normalize (line 152)
20	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
21	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 97)
22	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 55)
23	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 80)
24	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
25	Symfony\Component\Serializer\Serializer->normalize (line 152)
26	Symfony\Component\Serializer\Serializer->serialize (line 131)
27	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
28	ApiPlatform\State\Processor\SerializeProcessor->process (line 92)
29	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 65)
30	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
31	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
32	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
33	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
34	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 190)
35	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
36	Symfony\Component\HttpKernel\Kernel->handle (line 193)
37	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
38	require_once (line 32)
39	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\PageTranslation	2
App\Entity\User	1
App\Entity\Manager	1
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\User	No errors.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Trainer	No errors.
App\Entity\Manager	No errors.
App\Entity\Order	No errors.
App\Entity\LoginToken	No errors.
App\Entity\PowerOfAttorney	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

GET https://gun.nko.ru.com/api/pages?type=main

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping