Symfony Profiler

Query Metrics

11 Database Queries

11 Different statements

31.14 ms Query time

2 Invalid entities

8293 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.82 ms
(70.06%)

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ ORDER BY m0_.nombre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.provincia_id AS provincia_id_2
FROM
  municipio m0_
ORDER BY
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ ORDER BY m0_.nombre 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 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 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\ResolvedFormType->buildView (line 109)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 892)
21	Symfony\Component\Form\Form->createView (line 895)
22	App\Service\FilterManager->build (line 53)
23	App\Controller\AldeaController->index (line 41)
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)

1.63 ms
(5.24%)

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nombre_1 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, p1_.id AS id_2, p1_.nombre AS nombre_3 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ?) dctrn_result_inner ORDER BY nombre_1 ASC) dctrn_result LIMIT 20

Parameters:

[
  5016
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      nombre_1
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.nombre AS nombre_1,
          p1_.id AS id_2,
          p1_.nombre AS nombre_3
        FROM
          aldea a0_
          LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
          LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
          LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
          LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
        WHERE
          p1_.municipio_id = ?
      ) dctrn_result_inner
    ORDER BY
      nombre_1 ASC
  ) dctrn_result
LIMIT
  20

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, nombre_1 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, p1_.id AS id_2, p1_.nombre AS nombre_3 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016) dctrn_result_inner ORDER BY nombre_1 ASC) dctrn_result LIMIT 20;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_05f8acf9241a670b3f12ae066c431fb3->doDisplay (line 83)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_0a973508acba37e704e315c6abdf080a->block_content (line 200)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_55490eacf10ce755c4315e0aef303578->block_layout (line 172)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_5648c975ed053af6d0b21a8f88563eb7->doDisplay (line 80)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_55490eacf10ce755c4315e0aef303578->doDisplay (line 59)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_0a973508acba37e704e315c6abdf080a->doDisplay (line 59)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\AldeaController->index (line 48)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

1.56 ms
(5.01%)

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2 FROM provincia p0_ ORDER BY p0_.nombre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2
FROM
  provincia p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.comunidad_autonoma_id AS comunidad_autonoma_id_2 FROM provincia p0_ ORDER BY p0_.nombre 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 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 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\ResolvedFormType->buildView (line 109)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 892)
21	Symfony\Component\Form\Form->createView (line 895)
22	App\Service\FilterManager->build (line 53)
23	App\Controller\AldeaController->index (line 41)
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)

1.12 ms
(3.61%)

SELECT t0.id AS id_1, t0.recurso AS recurso_2, t0.accion AS accion_3, t0.recurso_orden AS recurso_orden_4, t0.accion_orden AS accion_orden_5, t0.role AS role_6 FROM permiso t0 INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id WHERE perfil_permiso.perfil_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.recurso AS recurso_2,
  t0.accion AS accion_3,
  t0.recurso_orden AS recurso_orden_4,
  t0.accion_orden AS accion_orden_5,
  t0.role AS role_6
FROM
  permiso t0
  INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id
WHERE
  perfil_permiso.perfil_id = ?

SELECT t0.id AS id_1, t0.recurso AS recurso_2, t0.accion AS accion_3, t0.recurso_orden AS recurso_orden_4, t0.accion_orden AS accion_orden_5, t0.role AS role_6 FROM permiso t0 INNER JOIN perfil_permiso ON t0.id = perfil_permiso.permiso_id WHERE perfil_permiso.perfil_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Usuario->getRoles (line 119)
8	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 318)
9	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.88 ms
(2.82%)

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.municipio_id AS municipio_id_2 FROM parroquia p0_ ORDER BY p0_.nombre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.nombre AS nombre_1,
  p0_.municipio_id AS municipio_id_2
FROM
  parroquia p0_
ORDER BY
  p0_.nombre ASC

SELECT p0_.id AS id_0, p0_.nombre AS nombre_1, p0_.municipio_id AS municipio_id_2 FROM parroquia p0_ ORDER BY p0_.nombre 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 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 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\ResolvedFormType->buildView (line 109)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 892)
21	Symfony\Component\Form\Form->createView (line 895)
22	App\Service\FilterManager->build (line 53)
23	App\Controller\AldeaController->index (line 41)
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.88 ms
(2.81%)

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ? ORDER BY a0_.nombre ASC) dctrn_result) dctrn_table

Parameters:

[
  5016
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          a0_.id AS id_0,
          a0_.nombre AS nombre_1
        FROM
          aldea a0_
          LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
          LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
          LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
          LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
        WHERE
          p1_.municipio_id = ?
        ORDER BY
          a0_.nombre ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT a0_.id AS id_0, a0_.nombre AS nombre_1 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016 ORDER BY a0_.nombre ASC) dctrn_result) dctrn_table;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	App\Twig\AppExtension->renderPaginator (line 53)
8	__TwigTemplate_0a973508acba37e704e315c6abdf080a->block_content (line 211)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_55490eacf10ce755c4315e0aef303578->block_layout (line 172)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_5648c975ed053af6d0b21a8f88563eb7->doDisplay (line 80)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_55490eacf10ce755c4315e0aef303578->doDisplay (line 59)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_0a973508acba37e704e315c6abdf080a->doDisplay (line 59)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\AldeaController->index (line 48)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.75 ms
(2.42%)

SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.parroquia_id AS parroquia_id_2 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.nombre ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nombre AS nombre_1,
  a0_.parroquia_id AS parroquia_id_2
FROM
  aldea a0_
  LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id
  LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id
  LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id
  LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id
WHERE
  p1_.municipio_id = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  a0_.nombre ASC

SELECT a0_.id AS id_0, a0_.nombre AS nombre_1, a0_.parroquia_id AS parroquia_id_2 FROM aldea a0_ LEFT JOIN parroquia p1_ ON a0_.parroquia_id = p1_.id LEFT JOIN municipio m2_ ON p1_.municipio_id = m2_.id LEFT JOIN provincia p3_ ON m2_.provincia_id = p3_.id LEFT JOIN comunidad_autonoma c4_ ON p3_.comunidad_autonoma_id = c4_.id WHERE p1_.municipio_id = 5016 AND a0_.id IN (74, 84, 46, 47, 100, 94, 86, 103, 87, 88, 110, 48, 60, 64, 89, 85, 54, 70, 75, 79) ORDER BY a0_.nombre 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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_05f8acf9241a670b3f12ae066c431fb3->doDisplay (line 83)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_0a973508acba37e704e315c6abdf080a->block_content (line 200)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_55490eacf10ce755c4315e0aef303578->block_layout (line 172)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_5648c975ed053af6d0b21a8f88563eb7->doDisplay (line 80)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_55490eacf10ce755c4315e0aef303578->doDisplay (line 59)
16	Twig\Template->yield (line 402)
17	__TwigTemplate_0a973508acba37e704e315c6abdf080a->doDisplay (line 59)
18	Twig\Template->yield (line 402)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 373)
21	Twig\TemplateWrapper->render (line 51)
22	Twig\Environment->render (line 333)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
26	App\Controller\AldeaController->index (line 48)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 193)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 5)

0.73 ms
(2.33%)

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ WHERE m0_.id IN (?) ORDER BY m0_.nombre ASC

Parameters:

[
  "5016"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.nombre AS nombre_1,
  m0_.provincia_id AS provincia_id_2
FROM
  municipio m0_
WHERE
  m0_.id IN (?)
ORDER BY
  m0_.nombre ASC

SELECT m0_.id AS id_0, m0_.nombre AS nombre_1, m0_.provincia_id AS provincia_id_2 FROM municipio m0_ WHERE m0_.id IN ('5016') ORDER BY m0_.nombre 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	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 100)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 92)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 76)
10	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 41)
11	Symfony\Component\Form\Form->viewToNorm (line 1006)
12	Symfony\Component\Form\Form->submit (line 556)
13	Symfony\Component\Form\Form->submit (line 497)
14	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
15	Symfony\Component\Form\Form->handleRequest (line 418)
16	App\Service\FilterManager->prepareForm (line 100)
17	App\Service\FilterManager->build (line 30)
18	App\Controller\AldeaController->index (line 41)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.72 ms
(2.32%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.esta_habilitado AS esta_habilitado_5, t0.plain_password AS plain_password_6, t0.nombre AS nombre_7, t0.apellidos AS apellidos_8, t0.email AS email_9, t0.ultimo_acceso AS ultimo_acceso_10, t0.eliminado_el AS eliminado_el_11, t0.avatar AS avatar_12, t0.avatar_actualizado_el AS avatar_actualizado_el_13, t0.perfil_id AS perfil_id_14, t0.entidad_id AS entidad_id_15 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.esta_habilitado AS esta_habilitado_5,
  t0.plain_password AS plain_password_6,
  t0.nombre AS nombre_7,
  t0.apellidos AS apellidos_8,
  t0.email AS email_9,
  t0.ultimo_acceso AS ultimo_acceso_10,
  t0.eliminado_el AS eliminado_el_11,
  t0.avatar AS avatar_12,
  t0.avatar_actualizado_el AS avatar_actualizado_el_13,
  t0.perfil_id AS perfil_id_14,
  t0.entidad_id AS entidad_id_15
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.esta_habilitado AS esta_habilitado_5, t0.plain_password AS plain_password_6, t0.nombre AS nombre_7, t0.apellidos AS apellidos_8, t0.email AS email_9, t0.ultimo_acceso AS ultimo_acceso_10, t0.eliminado_el AS eliminado_el_11, t0.avatar AS avatar_12, t0.avatar_actualizado_el AS avatar_actualizado_el_13, t0.perfil_id AS perfil_id_14, t0.entidad_id AS entidad_id_15 FROM usuario t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.59 ms
(1.90%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM perfil t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2
FROM
  perfil t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2 FROM perfil t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Perfil::getPermisos (line 68)
5	App\Entity\Usuario->getRoles (line 119)
6	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 318)
7	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 217)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.46 ms
(1.48%)

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM comunidad_autonoma c0_ ORDER BY c0_.nombre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nombre AS nombre_1
FROM
  comunidad_autonoma c0_
ORDER BY
  c0_.nombre ASC

SELECT c0_.id AS id_0, c0_.nombre AS nombre_1 FROM comunidad_autonoma c0_ ORDER BY c0_.nombre 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 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 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\ResolvedFormType->buildView (line 109)
19	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
20	Symfony\Component\Form\Form->createView (line 892)
21	Symfony\Component\Form\Form->createView (line 895)
22	App\Service\FilterManager->build (line 53)
23	App\Controller\AldeaController->index (line 41)
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)

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\Municipio	8145
App\Entity\Provincia	52
App\Entity\Parroquia	29
App\Entity\Permiso	26
App\Entity\Aldea	20
App\Entity\ComunidadAutonoma	19
App\Entity\Usuario	1
App\Entity\Perfil	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuario	No errors.
App\Entity\Perfil	No errors.
App\Entity\Entidad	No errors.
App\Entity\Permiso	No errors.
App\Entity\Aldea	No errors.
App\Entity\Parroquia	The mappings App\Entity\Parroquia#municipio and App\Entity\Municipio#parroquias are inconsistent with each other.
App\Entity\Municipio	The association App\Entity\Municipio#parroquias refers to the owning side field App\Entity\Parroquia#Municipio which does not exist.
App\Entity\Provincia	No errors.
App\Entity\ComunidadAutonoma	No errors.
App\Entity\Participante	No errors.

Symfony Profiler

POST https://demo.programas.vabadus.com.es/aldea

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping