Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.00 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.61 ms
(61.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.contact AS contact_4 FROM centre t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.contact AS contact_4
FROM
  centre t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.contact AS contact_4 FROM centre t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 25)
5	App\Repository\CentreRepository->findAll (line 140)
6	App\Form\ApplicationRequestType->buildForm (line 96)
7	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
8	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
9	Symfony\Component\Form\FormFactory->createNamedBuilder (line 41)
10	Symfony\Component\Form\FormFactory->createBuilder (line 26)
11	Symfony\Component\Form\FormFactory->create (line 323)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 47)
13	App\Controller\ApplicationRequestController->index (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.22 ms
(22.23%)

SELECT w0_.id AS id_0, w0_.name AS name_1 FROM workgroup w0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1
FROM
  workgroup w0_

SELECT w0_.id AS id_0, w0_.name AS name_1 FROM workgroup w0_;

#	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 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 82)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 96)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 94)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
20	Symfony\Component\Form\FormBuilder->create (line 207)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 160)
22	Symfony\Component\Form\FormBuilder->getForm (line 26)
23	Symfony\Component\Form\FormFactory->create (line 323)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 47)
25	App\Controller\ApplicationRequestController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.16 ms
(16.32%)

SELECT h0_.id AS id_0, h0_.name AS name_1 FROM hobby h0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1
FROM
  hobby h0_

SELECT h0_.id AS id_0, h0_.name AS name_1 FROM hobby h0_;

#	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 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 82)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 96)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 94)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
20	Symfony\Component\Form\FormBuilder->create (line 207)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 160)
22	Symfony\Component\Form\FormBuilder->getForm (line 26)
23	Symfony\Component\Form\FormFactory->create (line 323)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 47)
25	App\Controller\ApplicationRequestController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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.

Entities Mapping

Class	Mapping errors
App\Entity\Centre	No errors.
App\Entity\User	No errors.
App\Entity\ApplicationRequest	No errors.
App\Entity\Workgroup	No errors.
App\Entity\Hobby	No errors.

Symfony Profiler

GET https://stage-int.plrg.pl/dolacz/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping