Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

116.12 ms Query time

2 Invalid entities

143 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

104.89 ms
(90.33%)

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.activated AS activated_3, f0_.sort AS sort_4, f0_.lang_id AS lang_id_5 FROM faq f0_ INNER JOIN language l1_ ON f0_.lang_id = l1_.id WHERE f0_.activated = ? AND l1_.name = ? ORDER BY f0_.sort ASC, f0_.id ASC

Parameters:

[
  1
  "RU"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.question AS question_1,
  f0_.answer AS answer_2,
  f0_.activated AS activated_3,
  f0_.sort AS sort_4,
  f0_.lang_id AS lang_id_5
FROM
  faq f0_
  INNER JOIN language l1_ ON f0_.lang_id = l1_.id
WHERE
  f0_.activated = ?
  AND l1_.name = ?
ORDER BY
  f0_.sort ASC,
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.answer AS answer_2, f0_.activated AS activated_3, f0_.sort AS sort_4, f0_.lang_id AS lang_id_5 FROM faq f0_ INNER JOIN language l1_ ON f0_.lang_id = l1_.id WHERE f0_.activated = 1 AND l1_.name = 'RU' ORDER BY f0_.sort ASC, f0_.id ASC;

#	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	App\Repository\FaqRepository->findActiveByLanguageName (line 48)
7	App\Repository\FaqRepository->findActiveByLocale (line 26)
8	App\Controller\MainController->feedback (line 107)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

11.23 ms
(9.67%)

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 439)
29	Twig\Template->yield (line 402)
30	__TwigTemplate_f4aeb2427c5ad15ab7f23bff44e841f8->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->feedback (line 106)
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

Entities Mapping

Class	Mapping errors
App\Entity\Faq	No errors.
App\Entity\Language	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\PageTranslate	No errors.
App\Entity\Event\EventTranslate	No errors.
App\Entity\Event\EventGroupTranslate	No errors.
App\Entity\Event\EventOrganizationTranslate	No errors.
App\Entity\Event\EventTab	No errors.
App\Entity\SpeakerTranslate	No errors.
App\Entity\Banner	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\Poll\Poll	No errors.
App\Entity\Event\EventGroup	No errors.
App\Entity\Speaker	No errors.
App\Entity\Event\EventOrganization	No errors.
App\Entity\Page	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/feedback

Configuration Settings

Theme

Page Width