Symfony Profiler

Query Metrics

25 Database Queries

10 Different statements

13.17 ms Query time

3 Invalid entities

761 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.93 ms
(37.42%)

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id LEFT JOIN meta m2_ ON i1_.meta_id = m2_.id LEFT JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.anio = ? AND r0_.entidad_local_id = ? AND r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL ORDER BY o3_.orden ASC, m2_.orden ASC, i1_.orden ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.valor_tras_formula AS valor_tras_formula_3,
  r0_.valor_real_alcanzado AS valor_real_alcanzado_4,
  r0_.valor_objetivo AS valor_objetivo_5,
  r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6,
  r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7,
  r0_.valor_homogenizado AS valor_homogenizado_8,
  r0_.semaforizacion AS semaforizacion_9,
  r0_.informacion_adicional AS informacion_adicional_10,
  r0_.observaciones AS observaciones_11,
  r0_.observaciones_validador AS observaciones_validador_12,
  r0_.texto_ivl AS texto_ivl_13,
  r0_.mostrar_ivl AS mostrar_ivl_14,
  r0_.fecha_validado AS fecha_validado_15,
  r0_.estado AS estado_16,
  r0_.anio AS anio_17,
  r0_.path AS path_18,
  r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19,
  r0_.entidad_local_id AS entidad_local_id_20,
  r0_.indicador_id AS indicador_id_21,
  r0_.usuario_id AS usuario_id_22
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  LEFT JOIN meta m2_ ON i1_.meta_id = m2_.id
  LEFT JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
ORDER BY
  o3_.orden ASC,
  m2_.orden ASC,
  i1_.orden ASC

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id LEFT JOIN meta m2_ ON i1_.meta_id = m2_.id LEFT JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL ORDER BY o3_.orden ASC, m2_.orden ASC, i1_.orden ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\ResultadoRepository->findResultadosByAnioYEntidadLocal (line 153)
7	App\Controller\MainController->tablaIndicadores (line 267)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.84 ms
(14.00%)

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = ? AND r0_.entidad_local_id = ? AND i1_.set_entity_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT r0_.id) AS sclr_0
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
  INNER JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i1_.set_entity_id = ?

SELECT count(DISTINCT r0_.id) AS sclr_0 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i1_.set_entity_id = 2;

#	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	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGG01xBg\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\MainController->tablaIndicadores (line 305)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.78 ms
(13.53%)

SELECT DISTINCT r0_.id AS id_0, m1_.orden AS orden_1, o2_.orden AS orden_2, i3_.orden AS orden_3 FROM resultado r0_ INNER JOIN indicador i3_ ON r0_.indicador_id = i3_.id INNER JOIN meta m1_ ON i3_.meta_id = m1_.id INNER JOIN ods o2_ ON m1_.ods_id = o2_.id WHERE r0_.deleted_at IS NULL AND i3_.deleted_at IS NULL AND r0_.anio = ? AND r0_.entidad_local_id = ? AND i3_.set_entity_id = ? ORDER BY m1_.orden ASC, o2_.orden ASC, i3_.orden ASC LIMIT 15

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT r0_.id AS id_0,
  m1_.orden AS orden_1,
  o2_.orden AS orden_2,
  i3_.orden AS orden_3
FROM
  resultado r0_
  INNER JOIN indicador i3_ ON r0_.indicador_id = i3_.id
  INNER JOIN meta m1_ ON i3_.meta_id = m1_.id
  INNER JOIN ods o2_ ON m1_.ods_id = o2_.id
WHERE
  r0_.deleted_at IS NULL
  AND i3_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i3_.set_entity_id = ?
ORDER BY
  m1_.orden ASC,
  o2_.orden ASC,
  i3_.orden ASC
LIMIT
  15

SELECT DISTINCT r0_.id AS id_0, m1_.orden AS orden_1, o2_.orden AS orden_2, i3_.orden AS orden_3 FROM resultado r0_ INNER JOIN indicador i3_ ON r0_.indicador_id = i3_.id INNER JOIN meta m1_ ON i3_.meta_id = m1_.id INNER JOIN ods o2_ ON m1_.ods_id = o2_.id WHERE r0_.deleted_at IS NULL AND i3_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i3_.set_entity_id = 2 ORDER BY m1_.orden ASC, o2_.orden ASC, i3_.orden ASC LIMIT 15;

#	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	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGG01xBg\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\MainController->tablaIndicadores (line 305)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

1.62 ms
(12.28%)

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.descripcion AS descripcion_6,
  t0.color AS color_7,
  t0.path_ivl AS path_ivl_8,
  t0.ods_id AS ods_id_9
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.descripcion AS descripcion_6, t0.color AS color_7, t0.path_ivl AS path_ivl_8, t0.ods_id AS ods_id_9 FROM meta 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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Meta::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Meta->__get (line 129)
7	App\Entity\Meta->getOds (line 144)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_2fb043c85f738827908964f8ef0fe4cb::doDisplay (line 118)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
17	App\Controller\MainController->tablaIndicadores (line 312)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

1.45 ms
(11.03%)

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = ? AND r0_.entidad_local_id = ? AND i1_.set_entity_id = ? AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m2_.orden ASC, o3_.orden ASC, i1_.orden ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.deleted_at AS deleted_at_1,
  r0_.created_at AS created_at_2,
  r0_.valor_tras_formula AS valor_tras_formula_3,
  r0_.valor_real_alcanzado AS valor_real_alcanzado_4,
  r0_.valor_objetivo AS valor_objetivo_5,
  r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6,
  r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7,
  r0_.valor_homogenizado AS valor_homogenizado_8,
  r0_.semaforizacion AS semaforizacion_9,
  r0_.informacion_adicional AS informacion_adicional_10,
  r0_.observaciones AS observaciones_11,
  r0_.observaciones_validador AS observaciones_validador_12,
  r0_.texto_ivl AS texto_ivl_13,
  r0_.mostrar_ivl AS mostrar_ivl_14,
  r0_.fecha_validado AS fecha_validado_15,
  r0_.estado AS estado_16,
  r0_.anio AS anio_17,
  r0_.path AS path_18,
  r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19,
  r0_.entidad_local_id AS entidad_local_id_20,
  r0_.indicador_id AS indicador_id_21,
  r0_.usuario_id AS usuario_id_22
FROM
  resultado r0_
  INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id
  INNER JOIN meta m2_ ON i1_.meta_id = m2_.id
  INNER JOIN ods o3_ ON m2_.ods_id = o3_.id
WHERE
  r0_.deleted_at IS NULL
  AND i1_.deleted_at IS NULL
  AND r0_.anio = ?
  AND r0_.entidad_local_id = ?
  AND i1_.set_entity_id = ?
  AND r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m2_.orden ASC,
  o3_.orden ASC,
  i1_.orden ASC

SELECT r0_.id AS id_0, r0_.deleted_at AS deleted_at_1, r0_.created_at AS created_at_2, r0_.valor_tras_formula AS valor_tras_formula_3, r0_.valor_real_alcanzado AS valor_real_alcanzado_4, r0_.valor_objetivo AS valor_objetivo_5, r0_.umbral_minimo_teorico AS umbral_minimo_teorico_6, r0_.umbral_maximo_teorico AS umbral_maximo_teorico_7, r0_.valor_homogenizado AS valor_homogenizado_8, r0_.semaforizacion AS semaforizacion_9, r0_.informacion_adicional AS informacion_adicional_10, r0_.observaciones AS observaciones_11, r0_.observaciones_validador AS observaciones_validador_12, r0_.texto_ivl AS texto_ivl_13, r0_.mostrar_ivl AS mostrar_ivl_14, r0_.fecha_validado AS fecha_validado_15, r0_.estado AS estado_16, r0_.anio AS anio_17, r0_.path AS path_18, r0_.valor_tras_formula_no_numerico AS valor_tras_formula_no_numerico_19, r0_.entidad_local_id AS entidad_local_id_20, r0_.indicador_id AS indicador_id_21, r0_.usuario_id AS usuario_id_22 FROM resultado r0_ INNER JOIN indicador i1_ ON r0_.indicador_id = i1_.id INNER JOIN meta m2_ ON i1_.meta_id = m2_.id INNER JOIN ods o3_ ON m2_.ods_id = o3_.id WHERE r0_.deleted_at IS NULL AND i1_.deleted_at IS NULL AND r0_.anio = 2023 AND r0_.entidad_local_id = 5 AND i1_.set_entity_id = 2 AND r0_.id IN (5909, 5910, 5911, 5912, 5913, 5914, 5915, 5916, 5917, 6677, 5919, 5920, 5921, 6688, 5923) ORDER BY m2_.orden ASC, o3_.orden ASC, i1_.orden 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	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGG01xBg\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\MainController->tablaIndicadores (line 305)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.62 ms
(4.68%)

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.deleted_at AS deleted_at_2,
  t0.created_at AS created_at_3,
  t0.orden AS orden_4,
  t0.nombre AS nombre_5,
  t0.color AS color_6,
  t0.path_ivl AS path_ivl_7
FROM
  ods t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.deleted_at AS deleted_at_2, t0.created_at AS created_at_3, t0.orden AS orden_4, t0.nombre AS nombre_5, t0.color AS color_6, t0.path_ivl AS path_ivl_7 FROM ods t0 WHERE t0.id = 2;

#	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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Ods::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Ods->__get (line 129)
7	App\Entity\Ods->__toString (line 39)
8	Twig\Runtime\EscaperRuntime->escape (line 126)
9	__TwigTemplate_2fb043c85f738827908964f8ef0fe4cb->doDisplay (line 118)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 229)
17	App\Controller\MainController->tablaIndicadores (line 312)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.43 ms
(3.30%)

SELECT i0_.id AS id_0, i0_.deleted_at AS deleted_at_1, i0_.created_at AS created_at_2, i0_.orden AS orden_3, i0_.nombre AS nombre_4, i0_.territorios AS territorios_5, i0_.tendencia_deseada AS tendencia_deseada_6, i0_.valor_objetivo AS valor_objetivo_7, i0_.justificacion_valor_objetivo AS justificacion_valor_objetivo_8, i0_.umbral_minimo_teorico AS umbral_minimo_teorico_9, i0_.umbral_maximo_teorico AS umbral_maximo_teorico_10, i0_.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_11, i0_.metodo_calculo AS metodo_calculo_12, i0_.fuentes AS fuentes_13, i0_.datos_historicos AS datos_historicos_14, i0_.indicador_repetido AS indicador_repetido_15, i0_.referencias AS referencias_16, i0_.automatizable AS automatizable_17, i0_.descripcion AS descripcion_18, i0_.set_entity_id AS set_entity_id_19, i0_.metodo_obtencion_id AS metodo_obtencion_id_20, i0_.periodicidad_publicacion_id AS periodicidad_publicacion_id_21, i0_.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_22, i0_.unidad_medida_id AS unidad_medida_id_23, i0_.tipo_indicador_id AS tipo_indicador_id_24, i0_.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_25, i0_.objetivo_uae_id AS objetivo_uae_id_26, i0_.calculo_id AS calculo_id_27, i0_.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_28, i0_.meta_id AS meta_id_29 FROM indicador i0_ WHERE i0_.deleted_at IS NULL ORDER BY i0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.deleted_at AS deleted_at_1,
  i0_.created_at AS created_at_2,
  i0_.orden AS orden_3,
  i0_.nombre AS nombre_4,
  i0_.territorios AS territorios_5,
  i0_.tendencia_deseada AS tendencia_deseada_6,
  i0_.valor_objetivo AS valor_objetivo_7,
  i0_.justificacion_valor_objetivo AS justificacion_valor_objetivo_8,
  i0_.umbral_minimo_teorico AS umbral_minimo_teorico_9,
  i0_.umbral_maximo_teorico AS umbral_maximo_teorico_10,
  i0_.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_11,
  i0_.metodo_calculo AS metodo_calculo_12,
  i0_.fuentes AS fuentes_13,
  i0_.datos_historicos AS datos_historicos_14,
  i0_.indicador_repetido AS indicador_repetido_15,
  i0_.referencias AS referencias_16,
  i0_.automatizable AS automatizable_17,
  i0_.descripcion AS descripcion_18,
  i0_.set_entity_id AS set_entity_id_19,
  i0_.metodo_obtencion_id AS metodo_obtencion_id_20,
  i0_.periodicidad_publicacion_id AS periodicidad_publicacion_id_21,
  i0_.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_22,
  i0_.unidad_medida_id AS unidad_medida_id_23,
  i0_.tipo_indicador_id AS tipo_indicador_id_24,
  i0_.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_25,
  i0_.objetivo_uae_id AS objetivo_uae_id_26,
  i0_.calculo_id AS calculo_id_27,
  i0_.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_28,
  i0_.meta_id AS meta_id_29
FROM
  indicador i0_
WHERE
  i0_.deleted_at IS NULL
ORDER BY
  i0_.orden ASC

SELECT i0_.id AS id_0, i0_.deleted_at AS deleted_at_1, i0_.created_at AS created_at_2, i0_.orden AS orden_3, i0_.nombre AS nombre_4, i0_.territorios AS territorios_5, i0_.tendencia_deseada AS tendencia_deseada_6, i0_.valor_objetivo AS valor_objetivo_7, i0_.justificacion_valor_objetivo AS justificacion_valor_objetivo_8, i0_.umbral_minimo_teorico AS umbral_minimo_teorico_9, i0_.umbral_maximo_teorico AS umbral_maximo_teorico_10, i0_.metodo_obtencion_umbral_teorico AS metodo_obtencion_umbral_teorico_11, i0_.metodo_calculo AS metodo_calculo_12, i0_.fuentes AS fuentes_13, i0_.datos_historicos AS datos_historicos_14, i0_.indicador_repetido AS indicador_repetido_15, i0_.referencias AS referencias_16, i0_.automatizable AS automatizable_17, i0_.descripcion AS descripcion_18, i0_.set_entity_id AS set_entity_id_19, i0_.metodo_obtencion_id AS metodo_obtencion_id_20, i0_.periodicidad_publicacion_id AS periodicidad_publicacion_id_21, i0_.frecuencia_actualizacion_id AS frecuencia_actualizacion_id_22, i0_.unidad_medida_id AS unidad_medida_id_23, i0_.tipo_indicador_id AS tipo_indicador_id_24, i0_.fuente_valor_objetivo_id AS fuente_valor_objetivo_id_25, i0_.objetivo_uae_id AS objetivo_uae_id_26, i0_.calculo_id AS calculo_id_27, i0_.sub_fuente_valor_objetivo_id AS sub_fuente_valor_objetivo_id_28, i0_.meta_id AS meta_id_29 FROM indicador i0_ WHERE i0_.deleted_at IS NULL ORDER BY i0_.orden ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\IndicadorRepository->findTodos (line 83)
7	App\Controller\MainController->tablaIndicadores (line 269)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.18 ms
(1.37%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.nombre AS nombre_6, t0.apellidos AS apellidos_7, t0.direccion AS direccion_8, t0.email AS email_9, t0.codigo2_fa AS codigo2_fa_10, t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_expires_at AS reset_password_expires_at_13, t0.estado2_fa AS estado2_fa_14, t0.comunidad_id AS comunidad_id_15, t0.provincia_id AS provincia_id_16, t0.poblacion_id AS poblacion_id_17 FROM usuario t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.deleted_at AS deleted_at_4,
  t0.created_at AS created_at_5,
  t0.nombre AS nombre_6,
  t0.apellidos AS apellidos_7,
  t0.direccion AS direccion_8,
  t0.email AS email_9,
  t0.codigo2_fa AS codigo2_fa_10,
  t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11,
  t0.reset_password_token AS reset_password_token_12,
  t0.reset_password_expires_at AS reset_password_expires_at_13,
  t0.estado2_fa AS estado2_fa_14,
  t0.comunidad_id AS comunidad_id_15,
  t0.provincia_id AS provincia_id_16,
  t0.poblacion_id AS poblacion_id_17
FROM
  usuario t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.nombre AS nombre_6, t0.apellidos AS apellidos_7, t0.direccion AS direccion_8, t0.email AS email_9, t0.codigo2_fa AS codigo2_fa_10, t0.fecha_aceptacion_terminos AS fecha_aceptacion_terminos_11, t0.reset_password_token AS reset_password_token_12, t0.reset_password_expires_at AS reset_password_expires_at_13, t0.estado2_fa AS estado2_fa_14, t0.comunidad_id AS comunidad_id_15, t0.provincia_id AS provincia_id_16, t0.poblacion_id AS poblacion_id_17 FROM usuario t0 WHERE t0.id = 5;

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 92)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 182)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.17 ms
(1.32%)

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.host AS host_2,
  t0.puerto AS puerto_3,
  t0.seguridad AS seguridad_4,
  t0.email AS email_5,
  t0.password AS password_6
FROM
  smtp t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp 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\ServiceEntityRepositoryProxy->find (line 61)
6	App\Service\EmailService->__construct (line 34)
7	ContainerGG01xBg\getEmailServiceService->do (line 30)
8	ContainerGG01xBg\App_KernelDevDebugContainer::load (line 588)
9	ContainerGG01xBg\getAppCustomAuthenticatorService->do (line 35)
10	ContainerGG01xBg\App_KernelDevDebugContainer::load (line 588)
11	ContainerGG01xBg\getSecurity_Firewall_Map_Context_MainService->do (line 32)
12	ContainerGG01xBg\App_KernelDevDebugContainer::load (line 588)
13	Symfony\Component\DependencyInjection\Container->getService (line 398)
14	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 40)
15	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallContext (line 69)
16	Symfony\Bundle\SecurityBundle\Security\FirewallMap->getFirewallConfig (line 49)
17	Symfony\Bundle\SecurityBundle\EventListener\FirewallListener->configureLogoutUrlGenerator (line 45)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 29)
27	require_once (line 5)

0.14 ms
(1.08%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.role AS role_3 FROM role t0 INNER JOIN usuario_role ON t0.id = usuario_role.role_id WHERE usuario_role.usuario_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.role AS role_3
FROM
  role t0
  INNER JOIN usuario_role ON t0.id = usuario_role.role_id
WHERE
  usuario_role.usuario_id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.role AS role_3 FROM role t0 INNER JOIN usuario_role ON t0.id = usuario_role.role_id WHERE usuario_role.usuario_id = 5;

#	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 163)
8	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 310)
9	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 219)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 77)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (line 29)
25	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\Resultado	254
App\Entity\Indicador	254
App\Entity\Meta	112
App\Entity\UnidadMedida	62
App\Entity\Calculo	27
App\Entity\PeriodicidadPublicacion	10
App\Entity\ObjetivoUAE	10
App\Entity\FuenteValorObjetivo	5
App\Entity\Ods	5
App\Entity\MetodoObtencion	3
App\Entity\FrecuenciaActualizacion	3
App\Entity\TipoIndicador	3
App\Entity\SubFuenteValorObjetivo	3
App\Entity\Usuario	2
App\Entity\SetEntity	2
App\Entity\Smtp	1
App\Entity\Comunidad	1
App\Entity\Provincia	1
App\Entity\Poblacion	1
App\Entity\Role	1
App\Entity\EntidadLocal	1

Entities Mapping

Class	Mapping errors
App\Entity\Smtp	No errors.
App\Entity\Usuario	The association App\Entity\Usuario#comunidad refers to the inverse side field App\Entity\Comunidad#usuarios which does not exist. The association App\Entity\Usuario#provincia refers to the inverse side field App\Entity\Provincia#usuarios which does not exist. The association App\Entity\Usuario#poblacion refers to the inverse side field App\Entity\Poblacion#usuarios which does not exist.
App\Entity\Comunidad	No errors.
App\Entity\Provincia	The association App\Entity\Provincia#comunidad refers to the inverse side field App\Entity\Comunidad#provincias which does not exist.
App\Entity\Poblacion	The association App\Entity\Poblacion#provincia refers to the inverse side field App\Entity\Provincia#poblaciones which does not exist.
App\Entity\Role	No errors.
App\Entity\EntidadLocal	No errors.
App\Entity\Cluster	No errors.
App\Entity\Resultado	No errors.
App\Entity\Indicador	No errors.
App\Entity\Meta	No errors.
App\Entity\Ods	No errors.
App\Entity\Pagina	No errors.
App\Entity\SetEntity	No errors.
App\Entity\MetodoObtencion	No errors.
App\Entity\PeriodicidadPublicacion	No errors.
App\Entity\FrecuenciaActualizacion	No errors.
App\Entity\UnidadMedida	No errors.
App\Entity\TipoIndicador	No errors.
App\Entity\FuenteValorObjetivo	No errors.
App\Entity\ObjetivoUAE	No errors.
App\Entity\Calculo	No errors.
App\Entity\SubFuenteValorObjetivo	No errors.

Symfony Profiler

POST https://prefemp.winecta.com/admin/tabla-indicadores/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping