Symfony Profiler

Query Metrics

86 Database Queries

7 Different statements

32.67 ms Query time

0 Invalid entities

186 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

28.34 ms
(86.76%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM object_category_translations t0 WHERE t0.translatable_id = ?

Parameters:

[
  18
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  object_category_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM object_category_translations t0 WHERE t0.translatable_id = 18;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 188)
9	App\Entity\ObjectCategory->findTranslationByLocale (line 136)
10	App\Entity\ObjectCategory->doTranslate (line 73)
11	App\Entity\ObjectCategory->translate (line 298)
12	App\Entity\ObjectCategory->getName (line 310)
13	App\Entity\ObjectCategory->__toString (line 54)
14	Symfony\Bridge\Doctrine\Form\Type\DoctrineType::createChoiceLabel (line 158)
15	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 233)
16	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 123)
17	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
18	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 202)
19	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
20	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
21	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
24	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
25	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
26	Symfony\Component\Form\Form->createView (line 891)
27	Symfony\Component\Form\Form->createView (line 44)
28	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
29	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
30	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
31	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
32	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
35	Symfony\Component\HttpKernel\Kernel->handle (line 38)
36	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
37	frankenphp_handle_request (line 45)
38	Runtime\FrankenPhpSymfony\Runner->run (line 29)
39	require_once (line 5)

1.25 ms
(3.83%)

SELECT o0_.id AS id_0, o0_.ulid AS ulid_1, o0_.color AS color_2, o0_.icon_filename AS icon_filename_3, o0_.sort_order AS sort_order_4, o0_.is_active AS is_active_5, o0_.keywords AS keywords_6, o0_.side AS side_7, o0_.color_active AS color_active_8, o0_.color_icon AS color_icon_9, o0_.color_icon_active AS color_icon_active_10, o0_.icon AS icon_11, o0_.title AS title_12, o0_.is_quick_access AS is_quick_access_13, o0_.visible AS visible_14, o0_.created_at AS created_at_15, o0_.updated_at AS updated_at_16, o0_.parent_id AS parent_id_17 FROM object_categories o0_ WHERE o0_.parent_id IS NOT NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.ulid AS ulid_1,
  o0_.color AS color_2,
  o0_.icon_filename AS icon_filename_3,
  o0_.sort_order AS sort_order_4,
  o0_.is_active AS is_active_5,
  o0_.keywords AS keywords_6,
  o0_.side AS side_7,
  o0_.color_active AS color_active_8,
  o0_.color_icon AS color_icon_9,
  o0_.color_icon_active AS color_icon_active_10,
  o0_.icon AS icon_11,
  o0_.title AS title_12,
  o0_.is_quick_access AS is_quick_access_13,
  o0_.visible AS visible_14,
  o0_.created_at AS created_at_15,
  o0_.updated_at AS updated_at_16,
  o0_.parent_id AS parent_id_17
FROM
  object_categories o0_
WHERE
  o0_.parent_id IS NOT NULL

SELECT o0_.id AS id_0, o0_.ulid AS ulid_1, o0_.color AS color_2, o0_.icon_filename AS icon_filename_3, o0_.sort_order AS sort_order_4, o0_.is_active AS is_active_5, o0_.keywords AS keywords_6, o0_.side AS side_7, o0_.color_active AS color_active_8, o0_.color_icon AS color_icon_9, o0_.color_icon_active AS color_icon_active_10, o0_.icon AS icon_11, o0_.title AS title_12, o0_.is_quick_access AS is_quick_access_13, o0_.visible AS visible_14, o0_.created_at AS created_at_15, o0_.updated_at AS updated_at_16, o0_.parent_id AS parent_id_17 FROM object_categories o0_ WHERE o0_.parent_id IS NOT NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 202)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 44)
21	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 38)
29	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
30	frankenphp_handle_request (line 45)
31	Runtime\FrankenPhpSymfony\Runner->run (line 29)
32	require_once (line 5)

0.79 ms
(2.43%)

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.color AS color_3, t0.icon_filename AS icon_filename_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.keywords AS keywords_7, t0.side AS side_8, t0.color_active AS color_active_9, t0.color_icon AS color_icon_10, t0.color_icon_active AS color_icon_active_11, t0.icon AS icon_12, t0.title AS title_13, t0.is_quick_access AS is_quick_access_14, t0.visible AS visible_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.parent_id AS parent_id_18 FROM object_categories t0 INNER JOIN poi_object_category ON t0.id = poi_object_category.object_category_id WHERE poi_object_category.poi_id = ?

Parameters:

[
  221
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ulid AS ulid_2,
  t0.color AS color_3,
  t0.icon_filename AS icon_filename_4,
  t0.sort_order AS sort_order_5,
  t0.is_active AS is_active_6,
  t0.keywords AS keywords_7,
  t0.side AS side_8,
  t0.color_active AS color_active_9,
  t0.color_icon AS color_icon_10,
  t0.color_icon_active AS color_icon_active_11,
  t0.icon AS icon_12,
  t0.title AS title_13,
  t0.is_quick_access AS is_quick_access_14,
  t0.visible AS visible_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.parent_id AS parent_id_18
FROM
  object_categories t0
  INNER JOIN poi_object_category ON t0.id = poi_object_category.object_category_id
WHERE
  poi_object_category.poi_id = ?

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.color AS color_3, t0.icon_filename AS icon_filename_4, t0.sort_order AS sort_order_5, t0.is_active AS is_active_6, t0.keywords AS keywords_7, t0.side AS side_8, t0.color_active AS color_active_9, t0.color_icon AS color_icon_10, t0.color_icon_active AS color_icon_active_11, t0.icon AS icon_12, t0.title AS title_13, t0.is_quick_access AS is_quick_access_14, t0.visible AS visible_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.parent_id AS parent_id_18 FROM object_categories t0 INNER JOIN poi_object_category ON t0.id = poi_object_category.object_category_id WHERE poi_object_category.poi_id = 221;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1085)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1014)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2726)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 276)
9	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->countNumElements (line 226)
10	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configureToManyAssociation (line 142)
11	EasyCorp\Bundle\EasyAdminBundle\Field\Configurator\AssociationConfigurator->configure (line 102)
12	EasyCorp\Bundle\EasyAdminBundle\Factory\FieldFactory->processFields (line 43)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->processFields (line 222)
14	EasyCorp\Bundle\EasyAdminBundle\Controller\AbstractCrudController->edit (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 38)
18	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
19	frankenphp_handle_request (line 45)
20	Runtime\FrankenPhpSymfony\Runner->run (line 29)
21	require_once (line 5)

0.73 ms
(2.23%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.full_name AS full_name_6, t0.is_active AS is_active_7, t0.last_login_at AS last_login_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM users t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.full_name AS full_name_6,
  t0.is_active AS is_active_7,
  t0.last_login_at AS last_login_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.full_name AS full_name_6, t0.is_active AS is_active_7, t0.last_login_at AS last_login_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM users t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
15	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 38)
25	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
26	frankenphp_handle_request (line 45)
27	Runtime\FrankenPhpSymfony\Runner->run (line 29)
28	require_once (line 5)

0.65 ms
(2.00%)

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.image_filename AS image_filename_3, t0.information_url AS information_url_4, t0.assistant_video_filename AS assistant_video_filename_5, t0.is_active AS is_active_6, t0.last_sync_at AS last_sync_at_7, t0.keywords AS keywords_8, t0.objectname AS objectname_9, t0.qr_code_base64 AS qr_code_base64_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.routes AS routes_13, t0.priority AS priority_14, t0.icon_filename AS icon_filename_15, t0.closes AS closes_16, t0.terminal_letter AS terminal_letter_17, t0.floor AS floor_18, t0.show_icon_map AS show_icon_map_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.camera_id AS camera_id_22 FROM pois t0 WHERE t0.id = ?

Parameters:

[
  "221"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ulid AS ulid_2,
  t0.image_filename AS image_filename_3,
  t0.information_url AS information_url_4,
  t0.assistant_video_filename AS assistant_video_filename_5,
  t0.is_active AS is_active_6,
  t0.last_sync_at AS last_sync_at_7,
  t0.keywords AS keywords_8,
  t0.objectname AS objectname_9,
  t0.qr_code_base64 AS qr_code_base64_10,
  t0.latitude AS latitude_11,
  t0.longitude AS longitude_12,
  t0.routes AS routes_13,
  t0.priority AS priority_14,
  t0.icon_filename AS icon_filename_15,
  t0.closes AS closes_16,
  t0.terminal_letter AS terminal_letter_17,
  t0.floor AS floor_18,
  t0.show_icon_map AS show_icon_map_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.camera_id AS camera_id_22
FROM
  pois t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ulid AS ulid_2, t0.image_filename AS image_filename_3, t0.information_url AS information_url_4, t0.assistant_video_filename AS assistant_video_filename_5, t0.is_active AS is_active_6, t0.last_sync_at AS last_sync_at_7, t0.keywords AS keywords_8, t0.objectname AS objectname_9, t0.qr_code_base64 AS qr_code_base64_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.routes AS routes_13, t0.priority AS priority_14, t0.icon_filename AS icon_filename_15, t0.closes AS closes_16, t0.terminal_letter AS terminal_letter_17, t0.floor AS floor_18, t0.show_icon_map AS show_icon_map_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.camera_id AS camera_id_22 FROM pois t0 WHERE t0.id = '221';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 161)
7	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->getEntityInstance (line 123)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->doCreate (line 73)
9	EasyCorp\Bundle\EasyAdminBundle\Factory\EntityFactory->create (line 254)
10	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getEntityDto (line 65)
11	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 141)
12	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 38)
20	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
21	frankenphp_handle_request (line 45)
22	Runtime\FrankenPhpSymfony\Runner->run (line 29)
23	require_once (line 5)

0.59 ms
(1.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM poi_translations t0 WHERE t0.translatable_id = ?

Parameters:

[
  221
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.locale AS locale_3,
  t0.translatable_id AS translatable_id_4
FROM
  poi_translations t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM poi_translations t0 WHERE t0.translatable_id = 221;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 380)
8	Doctrine\ORM\PersistentCollection->get (line 188)
9	App\Entity\Poi->findTranslationByLocale (line 136)
10	App\Entity\Poi->doTranslate (line 73)
11	App\Entity\Poi->translate (line 260)
12	App\Entity\Poi->getName (line 404)
13	App\Entity\Poi->__toString (line 95)
14	EasyCorp\Bundle\EasyAdminBundle\Dto\EntityDto->toString (line 185)
15	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->getI18nDto (line 67)
16	EasyCorp\Bundle\EasyAdminBundle\Factory\AdminContextFactory->create (line 141)
17	EasyCorp\Bundle\EasyAdminBundle\EventListener\AdminRouterSubscriber->onKernelRequestPrettyUrls (line 115)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 38)
25	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
26	frankenphp_handle_request (line 45)
27	Runtime\FrankenPhpSymfony\Runner->run (line 29)
28	require_once (line 5)

0.31 ms
(0.94%)

SELECT t0.id AS id_1, t0.entity_name AS entity_name_2, t0.file_name AS file_name_3, t0.file_size AS file_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM instruction t0 WHERE t0.entity_name = ? LIMIT 1

Parameters:

[
  "Poi"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.entity_name AS entity_name_2,
  t0.file_name AS file_name_3,
  t0.file_size AS file_size_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  instruction t0
WHERE
  t0.entity_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entity_name AS entity_name_2, t0.file_name AS file_name_3, t0.file_size AS file_size_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM instruction t0 WHERE t0.entity_name = 'Poi' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 30)
5	App\Twig\Extension\InstructionExtension->getInstructionVideoUrl (line 84)
6	__TwigTemplate_1205882eccb46d93d747614e3356183d->block_page_actions (line 446)
7	Twig\Template->yieldBlock (line 1881)
8	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_page_actions_wrapper (line 446)
9	Twig\Template->yieldBlock (line 1792)
10	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_content_header (line 446)
11	Twig\Template->yieldBlock (line 1749)
12	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_content_header_wrapper (line 446)
13	Twig\Template->yieldBlock (line 1704)
14	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_content (line 446)
15	Twig\Template->yieldBlock (line 1220)
16	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_main_content_wrapper (line 446)
17	Twig\Template->yieldBlock (line 924)
18	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_wrapper (line 446)
19	Twig\Template->yieldBlock (line 754)
20	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_wrapper_wrapper (line 446)
21	Twig\Template->yieldBlock (line 492)
22	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->block_body (line 446)
23	Twig\Template->yieldBlock (line 155)
24	__TwigTemplate_679d567571bb8fd20cf9dcdb394fa3fc->doDisplay (line 402)
25	Twig\Template->yield (line 70)
26	__TwigTemplate_9f257eacc311065632acd6dc627caa60->doDisplay (line 402)
27	Twig\Template->yield (line 54)
28	__TwigTemplate_1205882eccb46d93d747614e3356183d->doDisplay (line 402)
29	Twig\Template->yield (line 358)
30	Twig\Template->display (line 373)
31	Twig\Template->render (line 51)
32	Twig\TemplateWrapper->render (line 333)
33	Twig\Environment->render (line 49)
34	EasyCorp\Bundle\EasyAdminBundle\EventListener\CrudResponseListener->onKernelView (line 115)
35	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
36	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
37	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
38	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 188)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
41	Symfony\Component\HttpKernel\Kernel->handle (line 38)
42	Runtime\FrankenPhpSymfony\Runner->Runtime\FrankenPhpSymfony\{closure} (line 1)
43	frankenphp_handle_request (line 45)
44	Runtime\FrankenPhpSymfony\Runner->run (line 29)
45	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\ObjectCategory	103
App\Entity\ObjectCategoryTranslation	80
App\Entity\User	1
App\Entity\Poi	1
App\Entity\PoiTranslation	1

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\AvatarCategory	No errors.
App\Entity\RussPassImage	No errors.
App\Entity\Session	No errors.
App\Entity\AvatarVideo	No errors.
App\Entity\Poi	No errors.
App\Entity\Schedule	No errors.
App\Entity\Log	No errors.
App\Entity\TerminalStatistic	No errors.
App\Entity\SearchQuery	No errors.
App\Entity\RussPassBaseObject	No errors.
App\Entity\RussPassRestaurant	No errors.
App\Entity\ObjectCategory	No errors.
App\Entity\ObjectCategoryTranslation	No errors.
App\Entity\ContentGroup	No errors.
App\Entity\PanoramaPoint	No errors.
App\Entity\SearchSuggestion	No errors.
App\Entity\AvatarVideoTranslation	No errors.
App\Entity\User	No errors.
App\Entity\SearchClickThrough	No errors.
App\Entity\StaticMedia	No errors.
App\Entity\Panorama	No errors.
App\Entity\ContentItem	No errors.
App\Entity\Bugs	No errors.
App\Entity\Terminal	No errors.
App\Entity\RussPassEvent	No errors.
App\Entity\Feedback	No errors.
App\Entity\Building	No errors.
App\Entity\ContactInfo	No errors.
App\Entity\Instruction	No errors.
App\Entity\Event	No errors.
App\Entity\EventTranslation	No errors.
App\Entity\Camera	No errors.
App\Entity\Map	No errors.
App\Entity\RussPassTag	No errors.
App\Entity\TerminalGroup	No errors.
App\Entity\EventImage	No errors.
App\Entity\TerminalStatusEvent	No errors.
App\Entity\MapImage	No errors.
App\Entity\PanoramaImage	No errors.
App\Entity\TransitionCategory	No errors.
App\Entity\PoiTranslation	No errors.
App\Entity\ScheduleContent	No errors.
App\Entity\ContentGroupPosition	No errors.
App\Entity\InformationVideo	No errors.
App\Entity\Media	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://mash-central-back.test.itlabs.top/admin/poi/221/edit?query=Curve670

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping