Symfony Profiler

Query Metrics

4 Database Queries

2 Different statements

2.55 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.69 ms

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.value AS value_2 FROM language_ui l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.value AS value_2
FROM
  language_ui l0_

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.value AS value_2 FROM language_ui l0_;

#	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	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\RegistrationController->register (line 65)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.33 ms

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.selfregistration AS selfregistration_1,
  g0_.home_text AS home_text_2,
  g0_.footer AS footer_3,
  g0_.tutorial_id AS tutorial_id_4
FROM
  general_parameters g0_
LIMIT
  1

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\GeneralParametersRepository->get (line 25)
7	App\Manager\AdministrationManager->getGeneralParameters (line 53)
8	App\Twig\GeneralParametersExtension->getGeneralParameters (line 20)
9	__TwigTemplate_b36bab7a8eae9dbd31a7a9e5e10732c3->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_d09e29a52f8eeba26c99d95b7344d165->doDisplay (line 57)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\RegistrationController->register (line 65)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.26 ms

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.selfregistration AS selfregistration_1,
  g0_.home_text AS home_text_2,
  g0_.footer AS footer_3,
  g0_.tutorial_id AS tutorial_id_4
FROM
  general_parameters g0_
LIMIT
  1

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\GeneralParametersRepository->get (line 25)
7	App\Manager\AdministrationManager->getGeneralParameters (line 53)
8	App\Twig\GeneralParametersExtension->getGeneralParameters (line 20)
9	__TwigTemplate_b36bab7a8eae9dbd31a7a9e5e10732c3->block_topToHideWhilePlaying (line 319)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b36bab7a8eae9dbd31a7a9e5e10732c3->doDisplay (line 112)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d09e29a52f8eeba26c99d95b7344d165->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\RegistrationController->register (line 65)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.26 ms

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  g0_.id AS id_0,
  g0_.selfregistration AS selfregistration_1,
  g0_.home_text AS home_text_2,
  g0_.footer AS footer_3,
  g0_.tutorial_id AS tutorial_id_4
FROM
  general_parameters g0_
LIMIT
  1

SELECT g0_.id AS id_0, g0_.selfregistration AS selfregistration_1, g0_.home_text AS home_text_2, g0_.footer AS footer_3, g0_.tutorial_id AS tutorial_id_4 FROM general_parameters g0_ LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\GeneralParametersRepository->get (line 25)
7	App\Manager\AdministrationManager->getGeneralParameters (line 53)
8	App\Twig\GeneralParametersExtension->getGeneralParameters (line 20)
9	__TwigTemplate_d09e29a52f8eeba26c99d95b7344d165->block_body (line 126)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_b36bab7a8eae9dbd31a7a9e5e10732c3->doDisplay (line 145)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_d09e29a52f8eeba26c99d95b7344d165->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\RegistrationController->register (line 65)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (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\Entity\LanguageUI	1
App\Entity\GeneralParameters	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\LanguageUI	No errors.
App\Entity\GeneralParameters	No errors.
App\Entity\Game	No errors.

Symfony Profiler

GET https://magicword.luciole.science/register

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping