Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.27 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.53 ms

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.entradilla AS entradilla_2, s0_.tipo AS tipo_3, s0_.posicion AS posicion_4, s0_.nivel AS nivel_5, s0_.codigo AS codigo_6, s0_.codigosup AS codigosup_7, s0_.codigoant AS codigoant_8, s0_.codigopos AS codigopos_9, s0_.codigobloqueo AS codigobloqueo_10, s0_.codigoopcionbloqueomin AS codigoopcionbloqueomin_11, s0_.codigoopcionbloqueomax AS codigoopcionbloqueomax_12, s0_.pesomax AS pesomax_13 FROM seccion s0_ ORDER BY s0_.posicion ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nombre AS nombre_1,
  s0_.entradilla AS entradilla_2,
  s0_.tipo AS tipo_3,
  s0_.posicion AS posicion_4,
  s0_.nivel AS nivel_5,
  s0_.codigo AS codigo_6,
  s0_.codigosup AS codigosup_7,
  s0_.codigoant AS codigoant_8,
  s0_.codigopos AS codigopos_9,
  s0_.codigobloqueo AS codigobloqueo_10,
  s0_.codigoopcionbloqueomin AS codigoopcionbloqueomin_11,
  s0_.codigoopcionbloqueomax AS codigoopcionbloqueomax_12,
  s0_.pesomax AS pesomax_13
FROM
  seccion s0_
ORDER BY
  s0_.posicion ASC

SELECT s0_.id AS id_0, s0_.nombre AS nombre_1, s0_.entradilla AS entradilla_2, s0_.tipo AS tipo_3, s0_.posicion AS posicion_4, s0_.nivel AS nivel_5, s0_.codigo AS codigo_6, s0_.codigosup AS codigosup_7, s0_.codigoant AS codigoant_8, s0_.codigopos AS codigopos_9, s0_.codigobloqueo AS codigobloqueo_10, s0_.codigoopcionbloqueomin AS codigoopcionbloqueomin_11, s0_.codigoopcionbloqueomax AS codigoopcionbloqueomax_12, s0_.pesomax AS pesomax_13 FROM seccion s0_ ORDER BY s0_.posicion 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 19)
6	App\Repository\SeccionRepository->findSecciones (line 27)
7	App\Service\Valoracion\CalculoPeso->__construct (line 1223)
8	ContainerSImp6Hm\App_KernelDevDebugContainer::getCalculoPesoService (line 1243)
9	ContainerSImp6Hm\App_KernelDevDebugContainer::getAppExtensionService (line 2116)
10	ContainerSImp6Hm\App_KernelDevDebugContainer::getTwigService (line 576)
11	ContainerSImp6Hm\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1291)
12	ContainerSImp6Hm\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 983)
13	ContainerSImp6Hm\App_KernelDevDebugContainer::ContainerSImp6Hm\{closure} (line 221)
14	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
15	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 257)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 121)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.74 ms

SELECT t0.id AS id_1, t0.texto AS texto_2, t0.tipo AS tipo_3, t0.codigoopcion AS codigoopcion_4, t0.seccion_id AS seccion_id_5 FROM pregunta t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.texto AS texto_2,
  t0.tipo AS tipo_3,
  t0.codigoopcion AS codigoopcion_4,
  t0.seccion_id AS seccion_id_5
FROM
  pregunta t0

SELECT t0.id AS id_1, t0.texto AS texto_2, t0.tipo AS tipo_3, t0.codigoopcion AS codigoopcion_4, t0.seccion_id AS seccion_id_5 FROM pregunta t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 103)
5	App\Service\Valoracion\CalculoPeso->procesaPreguntas (line 28)
6	App\Service\Valoracion\CalculoPeso->__construct (line 1223)
7	ContainerSImp6Hm\App_KernelDevDebugContainer::getCalculoPesoService (line 1243)
8	ContainerSImp6Hm\App_KernelDevDebugContainer::getAppExtensionService (line 2116)
9	ContainerSImp6Hm\App_KernelDevDebugContainer::getTwigService (line 576)
10	ContainerSImp6Hm\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1291)
11	ContainerSImp6Hm\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 983)
12	ContainerSImp6Hm\App_KernelDevDebugContainer::ContainerSImp6Hm\{closure} (line 221)
13	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
14	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 257)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 121)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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\Seccion	The field 'App\Entity\Seccion#pesomax' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Pregunta	No errors.

Symfony Profiler

GET https://beta.programaintegra.net/admin/login

Configuration Settings

Theme