Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

23.07 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.56 ms
(58.77%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = ?

Parameters:

[
  "98026f26-24b0-44b6-b846-f53a3f6ca05b"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.filename AS filename_3,
  t0.s3_filename AS s3_filename_4,
  t0.extension AS extension_5,
  t0.size AS size_6,
  t0.created_at AS created_at_7
FROM
  file t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.filename AS filename_3, t0.s3_filename AS s3_filename_4, t0.extension AS extension_5, t0.size AS size_6, t0.created_at AS created_at_7 FROM file t0 WHERE t0.id = '98026f26-24b0-44b6-b846-f53a3f6ca05b';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\File\Domain\Model\File::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\File\Domain\Model\File->__get (line 94)
8	App\File\Domain\Model\File->getExtension (line 24)
9	App\File\Application\Factory\CreateFileDto->make (line 112)
10	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->{closure:App\Contacts\UI\Api\Mapper\ContactsSettingsMapper::mapFounders():109} (line 1)
11	array_map (line 108)
12	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->mapFounders (line 91)
13	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->map (line 42)
14	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 32)
15	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
16	ApiPlatform\State\CallableProvider->provide (line 79)
17	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
18	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
20	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
23	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
24	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
25	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
26	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
27	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
28	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
33	require_once (line 5)

3.98 ms
(17.24%)

SELECT t0.id AS id_1, t0.singleton_key AS singleton_key_2, t0.address AS address_3, t0.email AS email_4, t0.box_office_hours AS box_office_hours_5, t0.box_office_break_hours AS box_office_break_hours_6, t0.box_office_phone AS box_office_phone_7, t0.administration_hours AS administration_hours_8, t0.administration_break_hours AS administration_break_hours_9, t0.administration_weekend AS administration_weekend_10, t0.production_hours AS production_hours_11, t0.production_break_hours AS production_break_hours_12, t0.production_weekend AS production_weekend_13, t0.founder_url AS founder_url_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.founder_logo_id AS founder_logo_id_17 FROM contacts_settings t0 WHERE t0.singleton_key = ? ORDER BY t0.created_at DESC LIMIT 1

Parameters:

[
  "master"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.singleton_key AS singleton_key_2,
  t0.address AS address_3,
  t0.email AS email_4,
  t0.box_office_hours AS box_office_hours_5,
  t0.box_office_break_hours AS box_office_break_hours_6,
  t0.box_office_phone AS box_office_phone_7,
  t0.administration_hours AS administration_hours_8,
  t0.administration_break_hours AS administration_break_hours_9,
  t0.administration_weekend AS administration_weekend_10,
  t0.production_hours AS production_hours_11,
  t0.production_break_hours AS production_break_hours_12,
  t0.production_weekend AS production_weekend_13,
  t0.founder_url AS founder_url_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.founder_logo_id AS founder_logo_id_17
FROM
  contacts_settings t0
WHERE
  t0.singleton_key = ?
ORDER BY
  t0.created_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.singleton_key AS singleton_key_2, t0.address AS address_3, t0.email AS email_4, t0.box_office_hours AS box_office_hours_5, t0.box_office_break_hours AS box_office_break_hours_6, t0.box_office_phone AS box_office_phone_7, t0.administration_hours AS administration_hours_8, t0.administration_break_hours AS administration_break_hours_9, t0.administration_weekend AS administration_weekend_10, t0.production_hours AS production_hours_11, t0.production_break_hours AS production_break_hours_12, t0.production_weekend AS production_weekend_13, t0.founder_url AS founder_url_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.founder_logo_id AS founder_logo_id_17 FROM contacts_settings t0 WHERE t0.singleton_key = 'master' ORDER BY t0.created_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 23)
5	App\Contacts\Infrastructure\Repository\ContactsSettingsRepository->findSingleton (line 30)
6	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
7	ApiPlatform\State\CallableProvider->provide (line 79)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
9	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
11	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
14	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
16	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
17	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
18	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
24	require_once (line 5)

1.62 ms
(7.01%)

SELECT t0.id AS id_1, t0.site AS site_2, t0.url AS url_3, t0.settings_id AS settings_id_4 FROM contacts_social_link t0 WHERE t0.settings_id = ?

Parameters:

[
  "4d1eb767-9a12-4101-9622-8620ac483e88"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site AS site_2,
  t0.url AS url_3,
  t0.settings_id AS settings_id_4
FROM
  contacts_social_link t0
WHERE
  t0.settings_id = ?

SELECT t0.id AS id_1, t0.site AS site_2, t0.url AS url_3, t0.settings_id AS settings_id_4 FROM contacts_social_link t0 WHERE t0.settings_id = '4d1eb767-9a12-4101-9622-8620ac483e88';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 54)
8	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 32)
10	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
11	ApiPlatform\State\CallableProvider->provide (line 79)
12	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
16	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
18	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
20	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
21	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
22	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
23	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 5)

1.35 ms
(5.85%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.url AS url_3, t0.description AS description_4, t0.settings_id AS settings_id_5, t0.logo_id AS logo_id_6 FROM contacts_founder t0 WHERE t0.settings_id = ?

Parameters:

[
  "4d1eb767-9a12-4101-9622-8620ac483e88"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.url AS url_3,
  t0.description AS description_4,
  t0.settings_id AS settings_id_5,
  t0.logo_id AS logo_id_6
FROM
  contacts_founder t0
WHERE
  t0.settings_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.url AS url_3, t0.description AS description_4, t0.settings_id AS settings_id_5, t0.logo_id AS logo_id_6 FROM contacts_founder t0 WHERE t0.settings_id = '4d1eb767-9a12-4101-9622-8620ac483e88';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 105)
8	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->mapFounders (line 91)
9	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->map (line 42)
10	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 32)
11	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
12	ApiPlatform\State\CallableProvider->provide (line 79)
13	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
14	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
16	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
17	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
18	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
19	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
20	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
21	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
22	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
23	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
24	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
29	require_once (line 5)

1.31 ms
(5.69%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.hours AS hours_3, t0.break_hours AS break_hours_4, t0.weekend AS weekend_5, t0.settings_id AS settings_id_6 FROM contacts_artist_season_schedule t0 WHERE t0.settings_id = ?

Parameters:

[
  "4d1eb767-9a12-4101-9622-8620ac483e88"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.hours AS hours_3,
  t0.break_hours AS break_hours_4,
  t0.weekend AS weekend_5,
  t0.settings_id AS settings_id_6
FROM
  contacts_artist_season_schedule t0
WHERE
  t0.settings_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.hours AS hours_3, t0.break_hours AS break_hours_4, t0.weekend AS weekend_5, t0.settings_id AS settings_id_6 FROM contacts_artist_season_schedule t0 WHERE t0.settings_id = '4d1eb767-9a12-4101-9622-8620ac483e88';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 75)
8	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 32)
10	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
11	ApiPlatform\State\CallableProvider->provide (line 79)
12	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
16	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
18	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
20	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
21	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
22	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
23	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	require_once (line 5)

1.26 ms
(5.44%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.person_name AS person_name_4, t0.phone AS phone_5, t0.email AS email_6, t0.settings_id AS settings_id_7 FROM contacts_main_contact t0 WHERE t0.settings_id = ?

Parameters:

[
  "4d1eb767-9a12-4101-9622-8620ac483e88"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.title AS title_3,
  t0.person_name AS person_name_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.settings_id AS settings_id_7
FROM
  contacts_main_contact t0
WHERE
  t0.settings_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.title AS title_3, t0.person_name AS person_name_4, t0.phone AS phone_5, t0.email AS email_6, t0.settings_id AS settings_id_7 FROM contacts_main_contact t0 WHERE t0.settings_id = '4d1eb767-9a12-4101-9622-8620ac483e88';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 159)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 87)
8	App\Contacts\UI\Api\Mapper\ContactsSettingsMapper->map (line 42)
9	App\Shared\Application\Mapper\ResourceMapperFactory->map (line 32)
10	App\Contacts\UI\Api\State\ContactsSettingsProvider->provide (line 43)
11	ApiPlatform\State\CallableProvider->provide (line 79)
12	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 50)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
16	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
17	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
18	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
19	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 102)
20	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
21	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
22	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
23	ApiPlatform\Symfony\Controller\MainController->__invoke (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 193)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 32)
28	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\Contacts\Domain\Model\ContactsSocialLink	5
App\Contacts\Domain\Model\ContactsMainContact	4
App\Contacts\Domain\Model\ContactsArtistSeasonSchedule	2
App\Contacts\Domain\Model\ContactsFounder	2
App\File\Domain\Model\File	2
App\Contacts\Domain\Model\ContactsSettings	1

Entities Mapping

Class	Mapping errors
App\Contacts\Domain\Model\ContactsSettings	No errors.
App\File\Domain\Model\File	No errors.
App\Contacts\Domain\Model\ContactsSocialLink	No errors.
App\Contacts\Domain\Model\ContactsArtistSeasonSchedule	No errors.
App\Contacts\Domain\Model\ContactsMainContact	No errors.
App\Contacts\Domain\Model\ContactsFounder	No errors.

Symfony Profiler

GET https://api-theatre.rassamahin.ru/api/contacts

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping