Symfony Profiler

Query Metrics

43 Database Queries

8 Different statements

17.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.21 ms
(42.23%)

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id IN (?)

Parameters:

[
  182
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id IN (?)

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id IN (182);

#	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 62)
7	App\Repository\TitulacionRepository->getTitulacionesMatch (line 25)
8	App\Service\CalculateTitulaciones\CalculateEstadosTitulaciones->calculateEstadosTitulacionesF1 (line 12)
9	App\Service\CalculateTitulaciones\CalculateMatchActividadTitulacionNivelService->calculate (line 142)
10	App\Twig\Components\DedicacionComponent->init (line 61)
11	App\Twig\Components\DedicacionComponent->mount (line 1)
12	ReflectionMethod->invoke (line 171)
13	Symfony\UX\TwigComponent\ComponentFactory->mount (line 93)
14	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
15	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
18	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 105)
27	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
28	Twig\Template->yieldBlock (line 81)
29	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
30	Twig\Template->yield (line 54)
31	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->doDisplay (line 387)
32	Twig\Template->yield (line 343)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 35)
35	Twig\TemplateWrapper->render (line 320)
36	Twig\Environment->render (line 448)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 187)
40	App\Controller\SolicitudController->solicitudDedicacion (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 5)

3.44 ms
(20.15%)

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:

[
  1
]

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 = 1;

#	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 61)
32	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
33	Twig\Template->yield (line 65)
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 105)
41	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
42	Twig\Template->yieldBlock (line 81)
43	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
44	Twig\Template->yield (line 54)
45	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->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 187)
54	App\Controller\SolicitudController->solicitudDedicacion (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)

2.40 ms
(14.09%)

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 = ? AND a0_.id IN (?) ORDER BY a0_.nombre_eu ASC

Parameters:

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 = ?
  AND a0_.id IN (?)
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 = 1 AND a0_.id IN (182) 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 61)
30	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
31	Twig\Template->yield (line 65)
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 105)
39	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
40	Twig\Template->yieldBlock (line 81)
41	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
42	Twig\Template->yield (line 54)
43	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->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 187)
52	App\Controller\SolicitudController->solicitudDedicacion (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.31 ms
(13.55%)

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.codigo AS codigo_3,
  t0.label AS label_4,
  t0.modalidad AS modalidad_5,
  t0.tipo AS tipo_6,
  t0.tipopractica_es AS tipopractica_es_7,
  t0.nombre_eu AS nombre_eu_8,
  t0.tipopractica_eu AS tipopractica_eu_9,
  t0.nivel AS nivel_10,
  t11.id AS id_12,
  t11.descripcion_eu AS descripcion_eu_13,
  t11.descripcion_es AS descripcion_es_14,
  t11.titulacion_id AS titulacion_id_15
FROM
  titulacion t0
  LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.codigo AS codigo_3, t0.label AS label_4, t0.modalidad AS modalidad_5, t0.tipo AS tipo_6, t0.tipopractica_es AS tipopractica_es_7, t0.nombre_eu AS nombre_eu_8, t0.tipopractica_eu AS tipopractica_eu_9, t0.nivel AS nivel_10, t11.id AS id_12, t11.descripcion_eu AS descripcion_eu_13, t11.descripcion_es AS descripcion_es_14, t11.titulacion_id AS titulacion_id_15 FROM titulacion t0 LEFT JOIN perfil_competencial t11 ON t11.titulacion_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 51)
6	App\Twig\Components\ActividadDefinicionModalComponent->getRecomendaciones (line 53)
7	Symfony\UX\TwigComponent\ComputedPropertiesProxy->__call (line 1861)
8	Twig\Extension\CoreExtension::getAttribute (line 350)
9	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->block_modal_body (line 431)
10	Twig\Template->yieldBlock (line 106)
11	__TwigTemplate_47dac8254a426c4adbc5734310be7392->block_modal_full_content (line 431)
12	Twig\Template->yieldBlock (line 61)
13	__TwigTemplate_47dac8254a426c4adbc5734310be7392->doDisplay (line 387)
14	Twig\Template->yield (line 277)
15	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1___541844921->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 126)
18	__TwigTemplate_2c1c906fcc2d2b9e6079ec04a19beec1->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 77)
22	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
23	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
24	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 61)
25	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
26	Twig\Template->yield (line 65)
27	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
28	Twig\Template->yield (line 343)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 77)
31	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
32	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
33	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 105)
34	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
35	Twig\Template->yieldBlock (line 81)
36	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
37	Twig\Template->yield (line 54)
38	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->doDisplay (line 387)
39	Twig\Template->yield (line 343)
40	Twig\Template->display (line 358)
41	Twig\Template->render (line 35)
42	Twig\TemplateWrapper->render (line 320)
43	Twig\Environment->render (line 448)
44	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 187)
47	App\Controller\SolicitudController->solicitudDedicacion (line 181)
48	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
49	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
50	Symfony\Component\HttpKernel\Kernel->handle (line 35)
51	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
52	require_once (line 5)

0.60 ms
(3.52%)

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.nombre_eu AS nombre_eu_3, t0.funcion_id AS funcion_id_4 FROM actividad t0 WHERE t0.id IN (?)

Parameters:

[
  182
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_es AS nombre_es_2,
  t0.nombre_eu AS nombre_eu_3,
  t0.funcion_id AS funcion_id_4
FROM
  actividad t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.nombre_es AS nombre_es_2, t0.nombre_eu AS nombre_eu_3, t0.funcion_id AS funcion_id_4 FROM actividad t0 WHERE t0.id IN (182);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 229)
4	App\Repository\ActividadRepository->findActividadesSeleccionadas (line 62)
5	App\Praktiker\Infraestructure\Repository\ConfiguradorRepository->load (line 180)
6	App\Controller\SolicitudController->solicitudDedicacion (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.48 ms
(2.80%)

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id = 182 AND a2_.nivel >= 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT t0_.id AS id_0,
  a1_.id AS id_1,
  a2_.tipo AS tipo_2
FROM
  titulacion t0_
  LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id
  LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id
WHERE
  a1_.id = 182
  AND a2_.nivel >= 4

SELECT DISTINCT t0_.id AS id_0, a1_.id AS id_1, a2_.tipo AS tipo_2 FROM titulacion t0_ LEFT JOIN actividad_titulacion a2_ ON t0_.id = a2_.titulacion_id LEFT JOIN actividad a1_ ON a2_.actividad_id = a1_.id WHERE a1_.id = 182 AND a2_.nivel >= 4;

#	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 136)
7	App\Repository\TitulacionRepository->getTitulacionesMatchNivel (line 47)
8	App\Service\CalculateTitulaciones\CalculateEstadosTitulaciones->calculateEstadosTitulacionesF2 (line 14)
9	App\Service\CalculateTitulaciones\CalculateMatchActividadTitulacionNivelService->calculate (line 142)
10	App\Twig\Components\DedicacionComponent->init (line 61)
11	App\Twig\Components\DedicacionComponent->mount (line 1)
12	ReflectionMethod->invoke (line 171)
13	Symfony\UX\TwigComponent\ComponentFactory->mount (line 93)
14	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
15	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
18	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
19	Twig\Template->yield (line 65)
20	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 77)
24	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
25	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
26	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 105)
27	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
28	Twig\Template->yieldBlock (line 81)
29	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
30	Twig\Template->yield (line 54)
31	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->doDisplay (line 387)
32	Twig\Template->yield (line 343)
33	Twig\Template->display (line 358)
34	Twig\Template->render (line 35)
35	Twig\TemplateWrapper->render (line 320)
36	Twig\Environment->render (line 448)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 187)
40	App\Controller\SolicitudController->solicitudDedicacion (line 181)
41	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
42	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
43	Symfony\Component\HttpKernel\Kernel->handle (line 35)
44	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
45	require_once (line 5)

0.45 ms
(2.62%)

SELECT max(a0_.nivel) AS sclr_0 FROM actividad_titulacion a0_ LEFT JOIN actividad a1_ ON a0_.actividad_id = a1_.id LEFT JOIN titulacion t2_ ON a0_.titulacion_id = t2_.id WHERE a1_.id = ?

Parameters:

[
  182
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  max(a0_.nivel) AS sclr_0
FROM
  actividad_titulacion a0_
  LEFT JOIN actividad a1_ ON a0_.actividad_id = a1_.id
  LEFT JOIN titulacion t2_ ON a0_.titulacion_id = t2_.id
WHERE
  a1_.id = ?

SELECT max(a0_.nivel) AS sclr_0 FROM actividad_titulacion a0_ LEFT JOIN actividad a1_ ON a0_.actividad_id = a1_.id LEFT JOIN titulacion t2_ ON a0_.titulacion_id = t2_.id WHERE a1_.id = 182;

#	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 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 1026)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 72)
8	App\Repository\ActividadTitulacionRepository->findMaximoNivel (line 16)
9	App\Service\ActividadTitulacion\CalculateMaximoNivel->get (line 99)
10	App\Twig\Components\DedicacionItemComponent->getMaxNivel (line 1861)
11	Twig\Extension\CoreExtension::getAttribute (line 79)
12	__TwigTemplate_03e6ff1ea9d6f31eae748e21641669ef->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 77)
16	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
17	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
18	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 228)
19	__TwigTemplate_e83830b5d6d1a26689f0006cfd355d20->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 77)
23	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
24	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
25	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 55)
26	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
27	Twig\Template->yield (line 65)
28	__TwigTemplate_e0b12a88bf496ecb8b197b9a3e80971e->doDisplay (line 387)
29	Twig\Template->yield (line 343)
30	Twig\Template->display (line 358)
31	Twig\Template->render (line 77)
32	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
33	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
34	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 105)
35	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
36	Twig\Template->yieldBlock (line 81)
37	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
38	Twig\Template->yield (line 54)
39	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->doDisplay (line 387)
40	Twig\Template->yield (line 343)
41	Twig\Template->display (line 358)
42	Twig\Template->render (line 35)
43	Twig\TemplateWrapper->render (line 320)
44	Twig\Environment->render (line 448)
45	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
46	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
47	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 187)
48	App\Controller\SolicitudController->solicitudDedicacion (line 181)
49	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
50	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
51	Symfony\Component\HttpKernel\Kernel->handle (line 35)
52	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
53	require_once (line 5)

0.18 ms
(1.04%)

SELECT t0_.id AS id_0, t0_.nombre_eu AS nombre_eu_1, t0_.tipopractica_eu AS tipopractica_eu_2 FROM titulacion t0_

Parameters:

[]

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_

SELECT t0_.id AS id_0, t0_.nombre_eu AS nombre_eu_1, t0_.tipopractica_eu AS tipopractica_eu_2 FROM titulacion t0_;

#	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 61)
19	__TwigTemplate_eaf2658a503ff851cfbcef0b8b67ae6c->doDisplay (line 387)
20	Twig\Template->yield (line 65)
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 105)
28	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->block_body (line 431)
29	Twig\Template->yieldBlock (line 81)
30	__TwigTemplate_61beb47bb7662e6024e9518159ab9b7f->doDisplay (line 387)
31	Twig\Template->yield (line 54)
32	__TwigTemplate_2c7829fa88f18f866a1a8e3ceaca8845->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 187)
41	App\Controller\SolicitudController->solicitudDedicacion (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)

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\Actividad	No errors.
App\Entity\Funcion	No errors.
App\Entity\ActividadTitulacion	No errors.
App\Entity\Keyword	No errors.
App\Entity\Titulacion	No errors.
App\Entity\PerfilCompetencial	No errors.
App\Entity\InfoTitulacion	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping