Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.81 ms Query time

0 Invalid entities

30 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.64 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.color AS color_4, c0_.position AS position_5, c0_.category_id AS category_id_6 FROM categories_types c0_ INNER JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c1_.slug = ? ORDER BY c0_.id ASC

Parameters:

[
  "biens"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.is_active AS is_active_3,
  c0_.color AS color_4,
  c0_.position AS position_5,
  c0_.category_id AS category_id_6
FROM
  categories_types c0_
  INNER JOIN categories c1_ ON c0_.category_id = c1_.id
WHERE
  c1_.slug = ?
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.color AS color_4, c0_.position AS position_5, c0_.category_id AS category_id_6 FROM categories_types c0_ INNER JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c1_.slug = 'biens' ORDER BY c0_.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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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 202)
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\Component\Form\Form->createView (line 895)
21	App\Controller\RegistrationController->index (line 748)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.36 ms

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.color AS color_4, c0_.position AS position_5, c0_.category_id AS category_id_6 FROM categories_types c0_ INNER JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c1_.slug = ? ORDER BY c0_.position ASC

Parameters:

[
  "situations"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.is_active AS is_active_3,
  c0_.color AS color_4,
  c0_.position AS position_5,
  c0_.category_id AS category_id_6
FROM
  categories_types c0_
  INNER JOIN categories c1_ ON c0_.category_id = c1_.id
WHERE
  c1_.slug = ?
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.is_active AS is_active_3, c0_.color AS color_4, c0_.position AS position_5, c0_.category_id AS category_id_6 FROM categories_types c0_ INNER JOIN categories c1_ ON c0_.category_id = c1_.id WHERE c1_.slug = 'situations' ORDER BY c0_.position 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
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\Component\Form\Form->createView (line 895)
21	App\Controller\RegistrationController->index (line 748)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.28 ms

SELECT i0_.id AS id_0, i0_.range AS range_1, i0_.slug AS slug_2, i0_.position AS position_3 FROM income_range i0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.range AS range_1,
  i0_.slug AS slug_2,
  i0_.position AS position_3
FROM
  income_range i0_

SELECT i0_.id AS id_0, i0_.range AS range_1, i0_.slug AS slug_2, i0_.position AS position_3 FROM income_range i0_;

#	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 35)
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\Component\Form\Form->createView (line 895)
21	App\Controller\RegistrationController->index (line 748)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.53 ms

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.slug AS slug_3, f0_.is_active AS is_active_4 FROM footer f0_ WHERE f0_.is_active = ? ORDER BY f0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.content AS content_2,
  f0_.slug AS slug_3,
  f0_.is_active AS is_active_4
FROM
  footer f0_
WHERE
  f0_.is_active = ?
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.content AS content_2, f0_.slug AS slug_3, f0_.is_active AS is_active_4 FROM footer f0_ WHERE f0_.is_active = 1 ORDER BY 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\FooterRepository->findAllOrderedForFooter (line 26)
7	App\Controller\MenuController->footerMenu (line 14)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
15	__TwigTemplate_4d26bea9d1522082612cd65f4d395f91->doDisplay (line 53)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_22a3b98b759a90ba7db4f7bbcf3e2efd->doDisplay (line 225)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_f6cb3ce1fc4ffdd862be84520a575721->doDisplay (line 56)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
28	App\Controller\RegistrationController->index (line 747)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 191)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
33	require_once (line 32)
34	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\CategoriesTypes	14
App\Entity\IncomeRange	10
App\Entity\Footer	4
App\Entity\Categories	2

Entities Mapping

Class	Mapping errors
App\Entity\CategoriesTypes	No errors.
App\Entity\Categories	No errors.
App\Entity\IncomeRange	No errors.
App\Entity\Document	No errors.
App\Entity\Renter	No errors.
App\Entity\Contact	No errors.
App\Entity\Address	No errors.
App\Entity\Blog	No errors.
App\Entity\Footer	No errors.
App\Entity\PageContent	No errors.
App\Entity\User	No errors.
App\Entity\Leases	No errors.
App\Entity\Guarantor	No errors.
App\Entity\Company	No errors.

Symfony Profiler

GET https://preprod.scoringbyserenia.com/inscription

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping