Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

116.12 ms Query time

1 Invalid entities

143 Managed entities

Queries

Group similar statements

#▲

Time

Info

104.89 ms

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

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width