Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

5.02 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.92 ms

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ? LIMIT 1

Parameters:

[
  91
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_parametro AS id_parametro_1,
  t0.descripcion_parametro AS descripcion_parametro_2,
  t0.valor AS valor_3,
  t0.tipo_dato AS tipo_dato_4,
  t0.cliente AS cliente_5
FROM
  parametros t0
WHERE
  t0.id_parametro = ?
LIMIT
  1

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = 91 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 17)
4	App\Repository\ParameterRepository->findParameterForId (line 664)
5	App\Controller\HomeController->noticiasAction (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 4)

1.46 ms

SELECT n0_.id AS id_0, n0_.titulo AS titulo_1, n0_.resumen AS resumen_2, n0_.contenido AS contenido_3, n0_.activo AS activo_4, n0_.visible AS visible_5, n0_.fecha_creacion AS fecha_creacion_6, n0_.fecha_actualizacion AS fecha_actualizacion_7 FROM noticias n0_ WHERE n0_.activo = ? AND n0_.titulo LIKE ? ORDER BY n0_.id ASC

Parameters:

[
  1
  "%%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.titulo AS titulo_1,
  n0_.resumen AS resumen_2,
  n0_.contenido AS contenido_3,
  n0_.activo AS activo_4,
  n0_.visible AS visible_5,
  n0_.fecha_creacion AS fecha_creacion_6,
  n0_.fecha_actualizacion AS fecha_actualizacion_7
FROM
  noticias n0_
WHERE
  n0_.activo = ?
  AND n0_.titulo LIKE ?
ORDER BY
  n0_.id ASC

SELECT n0_.id AS id_0, n0_.titulo AS titulo_1, n0_.resumen AS resumen_2, n0_.contenido AS contenido_3, n0_.activo AS activo_4, n0_.visible AS visible_5, n0_.fecha_creacion AS fecha_creacion_6, n0_.fecha_actualizacion AS fecha_actualizacion_7 FROM noticias n0_ WHERE n0_.activo = 1 AND n0_.titulo LIKE '%%' ORDER BY n0_.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 1213)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1167)
5	Doctrine\ORM\AbstractQuery->execute (line 906)
6	Doctrine\ORM\AbstractQuery->getResult (line 65)
7	App\Repository\NewsRepository->searchNews (line 671)
8	App\Controller\HomeController->noticiasAction (line 181)
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 4)

0.64 ms

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = ? LIMIT 1

Parameters:

[
  114
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_parametro AS id_parametro_1,
  t0.descripcion_parametro AS descripcion_parametro_2,
  t0.valor AS valor_3,
  t0.tipo_dato AS tipo_dato_4,
  t0.cliente AS cliente_5
FROM
  parametros t0
WHERE
  t0.id_parametro = ?
LIMIT
  1

SELECT t0.id_parametro AS id_parametro_1, t0.descripcion_parametro AS descripcion_parametro_2, t0.valor AS valor_3, t0.tipo_dato AS tipo_dato_4, t0.cliente AS cliente_5 FROM parametros t0 WHERE t0.id_parametro = 114 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 17)
4	App\Repository\ParameterRepository->findParameterForId (line 19)
5	App\Twig\AppExtension->getGlobals (line 365)
6	Twig\ExtensionSet->getGlobals (line 908)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 243)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 674)
15	App\Controller\HomeController->noticiasAction (line 181)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 4)

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\Parameter	No errors.
App\Entity\News	No errors.

Symfony Profiler

GET https://pruebasepa.appoloatiende.com/home/noticias

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping