Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

68.02 ms Query time

2 Invalid entities

144 Managed entities

Queries

Group similar statements

#▲

Time

Info

58.39 ms

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.is_activated AS is_activated_4 FROM page t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "personal-data-processing-agreement"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.created_at AS created_at_3,
  t0.is_activated AS is_activated_4
FROM
  page t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.created_at AS created_at_3, t0.is_activated AS is_activated_4 FROM page t0 WHERE t0.slug = 'personal-data-processing-agreement' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\MainController->page (line 115)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

9.63 ms

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2
FROM
  specialty s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2 FROM specialty s0_;

#	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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 478)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 233)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 111)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 109)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 892)
19	Symfony\Component\Form\Form->createView (line 895)
20	App\Controller\AuthController->registerModalForm (line 174)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
24	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
25	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
26	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
27	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
28	__TwigTemplate_8fe72738aa2f63b96607b3221990da5b->doDisplay (line 497)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_08066d41be642f9641baa14135787f44->doDisplay (line 54)
31	Twig\Template->yield (line 402)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 373)
34	Twig\TemplateWrapper->render (line 51)
35	Twig\Environment->render (line 333)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
39	App\Controller\MainController->page (line 119)
40	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
41	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
42	Symfony\Component\HttpKernel\Kernel->handle (line 193)
43	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
44	require_once (line 32)
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\Specialty	143
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\PageTranslate	No errors.
App\Entity\Specialty	No errors.
App\Entity\User\User	The association App\Entity\User\User#tests refers to the owning side field App\Entity\Test\Test#user which does not exist.
App\Entity\ImageEmbeddableClass	No errors.
App\Entity\Event\Event	No errors.
App\Entity\Language	No errors.
App\Entity\User\UserEventRegister	No errors.
App\Entity\Certificate\CustomCertificate	No errors.
App\Entity\User\UserCertificate	No errors.
App\Entity\Test\Test	No errors.
App\Entity\User\UserPoll	No errors.
App\Entity\User\UserPollAnswer	No errors.
App\Entity\User\UserTest	No errors.
App\Entity\User\UserTestAnswer	No errors.
App\Entity\City	No errors.
App\Entity\User\UserOrganization	No errors.
App\Entity\Feedback	No errors.
App\Entity\Event\EventTranslate	No errors.
App\Entity\Poll\Poll	No errors.
App\Entity\Event\EventTab	No errors.
App\Entity\Event\EventGroup	No errors.
App\Entity\Speaker	No errors.
App\Entity\Event\EventOrganization	No errors.
App\Entity\Event\EventGroupTranslate	No errors.
App\Entity\Event\EventOrganizationTranslate	No errors.
App\Entity\SpeakerTranslate	No errors.
App\Entity\Banner	No errors.
App\Entity\Faq	No errors.
App\Entity\Certificate\CustomCertificateElement	No errors.
App\Entity\Test\TestQuestion	No errors.
App\Entity\Poll\PollQuestion	No errors.
App\Entity\Poll\PollOption	No errors.
App\Entity\Test\TestAnswer	The association App\Entity\Test\TestAnswer#test refers to the inverse side field App\Entity\Test\Test#testAnswers which does not exist.
App\Entity\Country	No errors.
App\Entity\Event\ChatReportJob	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://vconfe.ru/_fragment?_path=_format%3Dhtml%26_locale%3Dru%26_controller%3DApp%255CController%255CAuthController%253A%253AforgotPasswordModalForm

Configuration Settings

Theme

Page Width