Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

6.35 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.45 ms
(22.85%)

SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.tiempo_inactividad IS NOT NULL ORDER BY p0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.kg_tope AS kg_tope_1,
  p0_.kg_minimo AS kg_minimo_2,
  p0_.espacio AS espacio_3,
  p0_.tiempo_inactividad AS tiempo_inactividad_4,
  p0_.activo_inactividad AS activo_inactividad_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.deleted_at AS deleted_at_8
FROM
  parameters p0_
WHERE
  p0_.tiempo_inactividad IS NOT NULL
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.tiempo_inactividad IS NOT NULL ORDER BY p0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 34)
7	App\Repository\ParametrosRepository->findUltimoConInactividadActiva (line 25)
8	App\Twig\InactividadSegExtension->getGlobals (line 332)
9	Twig\ExtensionSet->getGlobals (line 824)
10	Twig\Environment->getGlobals (line 389)
11	Twig\Template->yield (line 349)
12	Twig\Template->display (line 364)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 306)
15	Twig\Environment->render (line 448)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
19	App\Controller\Security\UserController->index (line 181)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

1.24 ms
(19.56%)

DELETE FROM cola_notificaciones WHERE categoria = ?

Parameters:

[
  "espacio-disco"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  cola_notificaciones
WHERE
  categoria = ?

DELETE FROM cola_notificaciones WHERE categoria = 'espacio-disco';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 38)
2	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 100)
6	App\Service\DiskMemoryService->getUsoDiscoMemoria (line 21)
7	App\Twig\MemoriaExtension->getGlobals (line 332)
8	Twig\ExtensionSet->getGlobals (line 824)
9	Twig\Environment->getGlobals (line 389)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
18	App\Controller\Security\UserController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.22 ms
(19.23%)

SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.espacio IS NOT NULL ORDER BY p0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.kg_tope AS kg_tope_1,
  p0_.kg_minimo AS kg_minimo_2,
  p0_.espacio AS espacio_3,
  p0_.tiempo_inactividad AS tiempo_inactividad_4,
  p0_.activo_inactividad AS activo_inactividad_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.deleted_at AS deleted_at_8
FROM
  parameters p0_
WHERE
  p0_.espacio IS NOT NULL
ORDER BY
  p0_.id DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.kg_tope AS kg_tope_1, p0_.kg_minimo AS kg_minimo_2, p0_.espacio AS espacio_3, p0_.tiempo_inactividad AS tiempo_inactividad_4, p0_.activo_inactividad AS activo_inactividad_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.deleted_at AS deleted_at_8 FROM parameters p0_ WHERE p0_.espacio IS NOT NULL ORDER BY p0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 23)
7	App\Repository\ParametrosRepository->findUltimoConEspacio (line 47)
8	App\Service\DiskMemoryService->getUsoDiscoMemoria (line 21)
9	App\Twig\MemoriaExtension->getGlobals (line 332)
10	Twig\ExtensionSet->getGlobals (line 824)
11	Twig\Environment->getGlobals (line 389)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
20	App\Controller\Security\UserController->index (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.99 ms
(15.56%)

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.updated_at AS updated_at_3 FROM nodosTor t0 WHERE t0.ip = ? LIMIT 1

Parameters:

[
  "172.20.0.1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip AS ip_2,
  t0.updated_at AS updated_at_3
FROM
  nodosTor t0
WHERE
  t0.ip = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ip AS ip_2, t0.updated_at AS updated_at_3 FROM nodosTor t0 WHERE t0.ip = '172.20.0.1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 42)
4	App\EventListener\PeticionesVerificacionIPListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.40 ms
(6.36%)

SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.activo AS activo_2
FROM
  mantenimiento t0
LIMIT
  1

SELECT t0.id AS id_1, t0.activo AS activo_2 FROM mantenimiento t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 19)
5	App\Repository\MantenimientoRepository->isModoMantenimientoActivo (line 40)
6	App\EventListener\MantenimientoListener->onKernelRequest (line 116)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.40 ms
(6.31%)

SELECT t0.id AS id_1, t0.nombre_archivo AS nombre_archivo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM logo t0 WHERE t0.deleted_at IS NULL ORDER BY t0.updated_at DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre_archivo AS nombre_archivo_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5
FROM
  logo t0
WHERE
  t0.deleted_at IS NULL
ORDER BY
  t0.updated_at DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.nombre_archivo AS nombre_archivo_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5 FROM logo t0 WHERE t0.deleted_at IS NULL ORDER BY t0.updated_at DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 24)
4	App\Service\LogoProviderService->getLogoPath (line 138)
5	App\EventSubscriber\GlobalVariablesSubscriber->onKernelRequest (line 116)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.33 ms
(5.12%)

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?

Parameters:

[
  "%ROLE_SUPER_ADMIN%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(u0_.id) AS sclr_0
FROM
  user u0_
WHERE
  u0_.roles LIKE ?

SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE '%ROLE_SUPER_ADMIN%';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 55)
8	App\EventListener\SuperAdminListener->onKernelRequest (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.32 ms
(5.01%)

SELECT t0.id AS id_1, t0.src_imagen_logo AS src_imagen_logo_2, t0.src_imagen_logo_mini AS src_imagen_logo_mini_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.fk_contacto AS fk_contacto_7, t0.fk_direccion AS fk_direccion_8 FROM integradoras t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.src_imagen_logo AS src_imagen_logo_2,
  t0.src_imagen_logo_mini AS src_imagen_logo_mini_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.fk_contacto AS fk_contacto_7,
  t0.fk_direccion AS fk_direccion_8
FROM
  integradoras t0

SELECT t0.id AS id_1, t0.src_imagen_logo AS src_imagen_logo_2, t0.src_imagen_logo_mini AS src_imagen_logo_mini_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.fk_contacto AS fk_contacto_7, t0.fk_direccion AS fk_direccion_8 FROM integradoras t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 21)
6	App\Twig\IntegratorsGlobalExtension->getGlobals (line 332)
7	Twig\ExtensionSet->getGlobals (line 824)
8	Twig\Environment->getGlobals (line 389)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
13	Twig\Environment->render (line 448)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 60)
17	App\Controller\Security\UserController->index (line 181)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
serprovit_prod	doctrine.dbal.serprovit_prod_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\Mantenimiento	No errors.
App\Entity\NodoTor	No errors.
App\Entity\User	No errors.
App\Entity\Logo	No errors.
App\Entity\Parametros	No errors.
App\Entity\Intervalo	No errors.
App\Entity\Integradora	No errors.
App\Entity\Contacto	No errors.
App\Entity\Direccion	No errors.
App\Entity\Animal	No errors.
App\Entity\NotificationQueue	No errors.

Symfony Profiler

GET https://dev.ingafood.pigdata.es/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping