Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.78 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.71 ms
(40.02%)

SELECT t0.name AS name_1, t0.description AS description_2, t0.value AS value_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM settings t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "preregisters_enabled"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.value AS value_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.deleted_at AS deleted_at_7
FROM
  settings t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.description AS description_2, t0.value AS value_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7 FROM settings t0 WHERE t0.name = 'preregisters_enabled' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 280)
4	App\Controller\PreRegisterController->checkPreregistersEnabled (line 134)
5	App\Controller\PreRegisterController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.61 ms
(34.41%)

SELECT r0_.name AS name_0, r0_.id AS id_1, r0_.created_at AS created_at_2, r0_.updated_at AS updated_at_3, r0_.deleted_at AS deleted_at_4 FROM resident_schools r0_ WHERE r0_.deleted_at IS NULL ORDER BY r0_.name DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.name AS name_0,
  r0_.id AS id_1,
  r0_.created_at AS created_at_2,
  r0_.updated_at AS updated_at_3,
  r0_.deleted_at AS deleted_at_4
FROM
  resident_schools r0_
WHERE
  r0_.deleted_at IS NULL
ORDER BY
  r0_.name DESC

SELECT r0_.name AS name_0, r0_.id AS id_1, r0_.created_at AS created_at_2, r0_.updated_at AS updated_at_3, r0_.deleted_at AS deleted_at_4 FROM resident_schools r0_ WHERE r0_.deleted_at IS NULL ORDER BY r0_.name DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
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 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 201)
24	App\Controller\PreRegisterController->index (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.46 ms
(25.56%)

SELECT h0_.type AS type_0, h0_.description AS description_1, h0_.id AS id_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.deleted_at AS deleted_at_5 FROM housing_types h0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.type AS type_0,
  h0_.description AS description_1,
  h0_.id AS id_2,
  h0_.created_at AS created_at_3,
  h0_.updated_at AS updated_at_4,
  h0_.deleted_at AS deleted_at_5
FROM
  housing_types h0_

SELECT h0_.type AS type_0, h0_.description AS description_1, h0_.id AS id_2, h0_.created_at AS created_at_3, h0_.updated_at AS updated_at_4, h0_.deleted_at AS deleted_at_5 FROM housing_types h0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
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 232)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 423)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 201)
24	App\Controller\PreRegisterController->index (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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\ResidentSchool	5
App\Entity\HousingType	4
App\Entity\Setting	1

Entities Mapping

Class	Mapping errors
App\Entity\Setting	No errors.
App\Entity\ResidentSchool	No errors.
App\Entity\HousingType	No errors.
App\Entity\Resident	No errors.
App\Entity\PreRegister	No errors.
App\Entity\Housing	No errors.
App\Entity\HousingTypeRent	No errors.
App\Entity\HousingTypeCharge	No errors.

Symfony Profiler

GET https://inscriptions.la-rez.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping