Symfony Profiler

Query Metrics

31 Database Queries

7 Different statements

12.17 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.59 ms
(54.13%)

SELECT a0_.id AS id_0, a0_.nombre_eu AS nombre_eu_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = ? ORDER BY a0_.nombre_eu ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nombre_eu AS nombre_eu_1,
  a1_.tipo AS tipo_2,
  a1_.nivel AS nivel_3
FROM
  actividad a0_
  LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id
  LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id
WHERE
  t2_.id = ?
ORDER BY
  a0_.nombre_eu ASC

SELECT a0_.id AS id_0, a0_.nombre_eu AS nombre_eu_1, a1_.tipo AS tipo_2, a1_.nivel AS nivel_3 FROM actividad a0_ LEFT JOIN actividad_titulacion a1_ ON a0_.id = a1_.actividad_id LEFT JOIN titulacion t2_ ON a1_.titulacion_id = t2_.id WHERE t2_.id = 2 ORDER BY a0_.nombre_eu ASC;

#	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 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 137)
7	App\Repository\ActividadRepository->getDetalleActividadesByTitulacion (line 17)
8	App\Service\Recomendador\RecomendadorContextoService->crearDetalleActividades (line 42)
9	App\Service\Recomendador\RecomendadorTitulacionesService->crearDetalleActividadesTitulacion (line 29)
10	App\Service\Recomendador\RecomendadorTitulacionesService->getRecomendaciones (line 60)
11	App\Twig\Components\ActividadDefinicionModalComponent->getRecomendaciones (line 53)
12	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 1861)
13	Twig\Extension\CoreExtension::getAttribute (line 350)
14	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->block_modal_body (line 431)
15	Twig\Template->yieldBlock (line 106)
16	__TwigTemplate_47dac8254a426c4adbc5734310be7392->block_modal_full_content (line 431)
17	Twig\Template->yieldBlock (line 61)
18	__TwigTemplate_47dac8254a426c4adbc5734310be7392->doDisplay (line 387)
19	Twig\Template->yield (line 277)
20	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 126)
23	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1->doDisplay (line 387)
24	Twig\Template->yield (line 343)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 77)
27	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
28	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
29	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 63)
30	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
31	Twig\Template->yield (line 56)
32	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
33	Twig\Template->yield (line 343)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 77)
36	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
37	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
38	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
39	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
40	Twig\Template->yieldBlock (line 81)
41	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
42	Twig\Template->yield (line 54)
43	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
44	Twig\Template->yield (line 343)
45	Twig\Template->display (line 358)
46	Twig\Template->render (line 35)
47	Twig\TemplateWrapper->render (line 320)
48	Twig\Environment->render (line 448)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
50	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
52	App\Controller\SolicitudController->solicitudActividades (line 181)
53	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
54	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
55	Symfony\Component\HttpKernel\Kernel->handle (line 35)
56	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
57	require_once (line 5)

2.70 ms
(22.14%)

SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nivel AS nivel_2,
  t0.tipo AS tipo_3,
  t0.titulacion_id AS titulacion_id_4,
  t0.actividad_id AS actividad_id_5
FROM
  actividad_titulacion t0
WHERE
  t0.titulacion_id = ?

SELECT t0.id AS id_1, t0.nivel AS nivel_2, t0.tipo AS tipo_3, t0.titulacion_id AS titulacion_id_4, t0.actividad_id AS actividad_id_5 FROM actividad_titulacion t0 WHERE t0.titulacion_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 20)
8	App\Praktiker\Application\Matching\Service\MatchingTitulacionFaseSeleccionActividades->matches (line 17)
9	App\Praktiker\Application\Matching\Service\MatchingTitulacion->match (line 26)
10	App\Praktiker\Application\Recomendador\RecomendadorTitulacionNoSeleccionada->getRecomendacion (line 35)
11	App\Praktiker\Application\Recomendador\RecomendadorTitulaciones->getRecomendacion (line 34)
12	App\Service\Recomendador\RecomendadorTitulacionesService->getRecomendaciones (line 60)
13	App\Twig\Components\ActividadDefinicionModalComponent->getRecomendaciones (line 53)
14	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 1861)
15	Twig\Extension\CoreExtension::getAttribute (line 350)
16	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->block_modal_body (line 431)
17	Twig\Template->yieldBlock (line 106)
18	__TwigTemplate_47dac8254a426c4adbc5734310be7392->block_modal_full_content (line 431)
19	Twig\Template->yieldBlock (line 61)
20	__TwigTemplate_47dac8254a426c4adbc5734310be7392->doDisplay (line 387)
21	Twig\Template->yield (line 277)
22	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 126)
25	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1->doDisplay (line 387)
26	Twig\Template->yield (line 343)
27	Twig\Template->display (line 358)
28	Twig\Template->render (line 77)
29	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
30	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
31	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 63)
32	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
33	Twig\Template->yield (line 56)
34	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
35	Twig\Template->yield (line 343)
36	Twig\Template->display (line 358)
37	Twig\Template->render (line 77)
38	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
39	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
40	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
41	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
42	Twig\Template->yieldBlock (line 81)
43	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
44	Twig\Template->yield (line 54)
45	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
46	Twig\Template->yield (line 343)
47	Twig\Template->display (line 358)
48	Twig\Template->render (line 35)
49	Twig\TemplateWrapper->render (line 320)
50	Twig\Environment->render (line 448)
51	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
54	App\Controller\SolicitudController->solicitudActividades (line 181)
55	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
56	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
57	Symfony\Component\HttpKernel\Kernel->handle (line 35)
58	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
59	require_once (line 5)

1.39 ms
(11.42%)

SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.descripcion_eu AS descripcion_eu_2,
  t0.descripcion_es AS descripcion_es_3,
  t0.titulacion_id AS titulacion_id_4
FROM
  perfil_competencial t0
WHERE
  t0.titulacion_id = ?

SELECT t0.id AS id_1, t0.descripcion_eu AS descripcion_eu_2, t0.descripcion_es AS descripcion_es_3, t0.titulacion_id AS titulacion_id_4 FROM perfil_competencial t0 WHERE t0.titulacion_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 873)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1231)
9	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
10	Doctrine\ORM\AbstractQuery->execute (line 36)
11	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
12	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 64)
15	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
16	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
17	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
18	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
19	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
20	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
21	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
22	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
23	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
24	Symfony\Component\Form\Form->createView (line 903)
25	Symfony\Component\Form\Form->createView (line 120)
26	App\Twig\Components\SearchComponent->getFormView (line 95)
27	App\Twig\Components\SearchComponent->initializeForm (line 196)
28	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 105)
29	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
30	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
31	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
32	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
33	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
34	Twig\Template->yield (line 56)
35	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
36	Twig\Template->yield (line 343)
37	Twig\Template->display (line 358)
38	Twig\Template->render (line 77)
39	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
40	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
41	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
42	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
43	Twig\Template->yieldBlock (line 81)
44	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
45	Twig\Template->yield (line 54)
46	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
47	Twig\Template->yield (line 343)
48	Twig\Template->display (line 358)
49	Twig\Template->render (line 35)
50	Twig\TemplateWrapper->render (line 320)
51	Twig\Environment->render (line 448)
52	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
53	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
54	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
55	App\Controller\SolicitudController->solicitudActividades (line 181)
56	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
57	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
58	Symfony\Component\HttpKernel\Kernel->handle (line 35)
59	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
60	require_once (line 5)

0.66 ms
(5.41%)

SELECT t0_.id AS id_0, t0_.nombre_es AS nombre_es_1, t0_.codigo AS codigo_2, t0_.label AS label_3, t0_.modalidad AS modalidad_4, t0_.tipo AS tipo_5, t0_.tipopractica_es AS tipopractica_es_6, t0_.nombre_eu AS nombre_eu_7, t0_.tipopractica_eu AS tipopractica_eu_8, t0_.nivel AS nivel_9 FROM titulacion t0_ WHERE t0_.modalidad = ? ORDER BY t0_.id ASC

Parameters:

[
  "corta"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nombre_es AS nombre_es_1,
  t0_.codigo AS codigo_2,
  t0_.label AS label_3,
  t0_.modalidad AS modalidad_4,
  t0_.tipo AS tipo_5,
  t0_.tipopractica_es AS tipopractica_es_6,
  t0_.nombre_eu AS nombre_eu_7,
  t0_.tipopractica_eu AS tipopractica_eu_8,
  t0_.nivel AS nivel_9
FROM
  titulacion t0_
WHERE
  t0_.modalidad = ?
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.nombre_es AS nombre_es_1, t0_.codigo AS codigo_2, t0_.label AS label_3, t0_.modalidad AS modalidad_4, t0_.tipo AS tipo_5, t0_.tipopractica_es AS tipopractica_es_6, t0_.nombre_eu AS nombre_eu_7, t0_.tipopractica_eu AS tipopractica_eu_8, t0_.nivel AS nivel_9 FROM titulacion t0_ WHERE t0_.modalidad = 'corta' ORDER BY t0_.id ASC;

#	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 36)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 120)
21	App\Twig\Components\SearchComponent->getFormView (line 95)
22	App\Twig\Components\SearchComponent->initializeForm (line 196)
23	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 105)
24	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
25	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
28	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
31	Twig\Template->yield (line 343)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 77)
34	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
35	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
36	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
37	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
38	Twig\Template->yieldBlock (line 81)
39	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
40	Twig\Template->yield (line 54)
41	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
42	Twig\Template->yield (line 343)
43	Twig\Template->display (line 358)
44	Twig\Template->render (line 35)
45	Twig\TemplateWrapper->render (line 320)
46	Twig\Environment->render (line 448)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
50	App\Controller\SolicitudController->solicitudActividades (line 181)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
53	Symfony\Component\HttpKernel\Kernel->handle (line 35)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
55	require_once (line 5)

0.36 ms
(2.97%)

SELECT t0_.id AS id_0, t0_.nombre_eu AS nombre_eu_1, t0_.tipopractica_eu AS tipopractica_eu_2 FROM titulacion t0_ WHERE t0_.modalidad = ?

Parameters:

[
  "corta"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.nombre_eu AS nombre_eu_1,
  t0_.tipopractica_eu AS tipopractica_eu_2
FROM
  titulacion t0_
WHERE
  t0_.modalidad = ?

SELECT t0_.id AS id_0, t0_.nombre_eu AS nombre_eu_1, t0_.tipopractica_eu AS tipopractica_eu_2 FROM titulacion t0_ WHERE t0_.modalidad = 'corta';

#	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 919)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 96)
7	App\Repository\TitulacionRepository->getTitulacionesByModalidad (line 13)
8	App\Service\CalculateTitulaciones\CalculateTitulacionesService->initEstadosTitulaciones (line 28)
9	App\Service\CalculateTitulaciones\CalculateTitulacionesService->calculate (line 73)
10	App\Twig\Components\TitulacionesComponent->fillEstadosTitulaciones (line 66)
11	App\Twig\Components\TitulacionesComponent->trataPanel (line 60)
12	App\Twig\Components\TitulacionesComponent->mount (line 1)
13	ReflectionMethod->invoke (line 171)
14	Symfony\UX\TwigComponent\ComponentFactory->mount (line 93)
15	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
16	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 63)
19	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
20	Twig\Template->yield (line 56)
21	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
22	Twig\Template->yield (line 343)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 77)
25	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
28	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
29	Twig\Template->yieldBlock (line 81)
30	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
33	Twig\Template->yield (line 343)
34	Twig\Template->display (line 358)
35	Twig\Template->render (line 35)
36	Twig\TemplateWrapper->render (line 320)
37	Twig\Environment->render (line 448)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
41	App\Controller\SolicitudController->solicitudActividades (line 181)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 5)

0.26 ms
(2.13%)

SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a0_.visible AS visible_2, a0_.nombre_eu AS nombre_eu_3 FROM area a0_ WHERE a0_.visible = ? ORDER BY a0_.nombre_eu ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.nombre_es AS nombre_es_1,
  a0_.visible AS visible_2,
  a0_.nombre_eu AS nombre_eu_3
FROM
  area a0_
WHERE
  a0_.visible = ?
ORDER BY
  a0_.nombre_eu ASC

SELECT a0_.id AS id_0, a0_.nombre_es AS nombre_es_1, a0_.visible AS visible_2, a0_.nombre_eu AS nombre_eu_3 FROM area a0_ WHERE a0_.visible = 1 ORDER BY a0_.nombre_eu ASC;

#	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 36)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 120)
21	App\Twig\Components\SearchComponent->getFormView (line 95)
22	App\Twig\Components\SearchComponent->initializeForm (line 196)
23	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 105)
24	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
25	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
28	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
31	Twig\Template->yield (line 343)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 77)
34	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
35	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
36	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
37	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
38	Twig\Template->yieldBlock (line 81)
39	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
40	Twig\Template->yield (line 54)
41	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
42	Twig\Template->yield (line 343)
43	Twig\Template->display (line 358)
44	Twig\Template->render (line 35)
45	Twig\TemplateWrapper->render (line 320)
46	Twig\Environment->render (line 448)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
50	App\Controller\SolicitudController->solicitudActividades (line 181)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
53	Symfony\Component\HttpKernel\Kernel->handle (line 35)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
55	require_once (line 5)

0.22 ms
(1.78%)

SELECT f0_.id AS id_0, f0_.nombre_es AS nombre_es_1, f0_.visible AS visible_2, f0_.nombre_eu AS nombre_eu_3, f0_.area_id AS area_id_4 FROM funcion f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.nombre_es AS nombre_es_1,
  f0_.visible AS visible_2,
  f0_.nombre_eu AS nombre_eu_3,
  f0_.area_id AS area_id_4
FROM
  funcion f0_

SELECT f0_.id AS id_0, f0_.nombre_es AS nombre_es_1, f0_.visible AS visible_2, f0_.nombre_eu AS nombre_eu_3, f0_.area_id AS area_id_4 FROM funcion f0_;

#	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 36)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 120)
21	App\Twig\Components\SearchComponent->getFormView (line 95)
22	App\Twig\Components\SearchComponent->initializeForm (line 196)
23	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 105)
24	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
25	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
26	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
27	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
28	__TwigTemplate_d18621fb6ea5e5cdf048b40373126abd->doDisplay (line 387)
29	Twig\Template->yield (line 56)
30	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
31	Twig\Template->yield (line 343)
32	Twig\Template->display (line 358)
33	Twig\Template->render (line 77)
34	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
35	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
36	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 107)
37	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->block_body (line 431)
38	Twig\Template->yieldBlock (line 81)
39	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
40	Twig\Template->yield (line 54)
41	__TwigTemplate_1a943ee80df7b73cf5ae12b8de8c16bd->doDisplay (line 387)
42	Twig\Template->yield (line 343)
43	Twig\Template->display (line 358)
44	Twig\Template->render (line 35)
45	Twig\TemplateWrapper->render (line 320)
46	Twig\Environment->render (line 448)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
48	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
49	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 171)
50	App\Controller\SolicitudController->solicitudActividades (line 181)
51	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
52	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
53	Symfony\Component\HttpKernel\Kernel->handle (line 35)
54	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
55	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\Titulacion	No errors.
App\Entity\Area	No errors.
App\Entity\Keyword	No errors.
App\Entity\Funcion	No errors.
App\Entity\ActividadTitulacion	No errors.
App\Entity\InfoTitulacion	No errors.
App\Entity\PerfilCompetencial	No errors.
App\Entity\Actividad	No errors.

Symfony Profiler

GET https://praktiker.wdemo.net/eu/eskaera/jarduerak

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping