Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

31.39 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.98 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14 FROM noticias n0_ WHERE n0_.web = 1 ORDER BY n0_.fecha DESC) dctrn_result) dctrn_table

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.titular AS titular_1,
          n0_.slug AS slug_2,
          n0_.entradilla AS entradilla_3,
          n0_.contenido AS contenido_4,
          n0_.thumbnail AS thumbnail_5,
          n0_.imagen AS imagen_6,
          n0_.imagen2 AS imagen2_7,
          n0_.imagen3 AS imagen3_8,
          n0_.imagen4 AS imagen4_9,
          n0_.web AS web_10,
          n0_.home_web AS home_web_11,
          n0_.prensa AS prensa_12,
          n0_.fecha AS fecha_13,
          n0_.modificado AS modificado_14
        FROM
          noticias n0_
        WHERE
          n0_.web = 1
        ORDER BY
          n0_.fecha DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14 FROM noticias n0_ WHERE n0_.web = 1 ORDER BY n0_.fecha DESC) dctrn_result) dctrn_table;

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 42)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getNbResults (line 300)
9	Pagerfanta\Pagerfanta->getNbResults (line 326)
10	Pagerfanta\Pagerfanta->calculateNbPages (line 308)
11	Pagerfanta\Pagerfanta->getNbPages (line 222)
12	Pagerfanta\Pagerfanta->currentPageOutOfRange (line 217)
13	Pagerfanta\Pagerfanta->notAllowedCurrentPageOutOfRange (line 208)
14	Pagerfanta\Pagerfanta->filterOutOfRangeCurrentPage (line 188)
15	Pagerfanta\Pagerfanta->filterCurrentPage (line 173)
16	Pagerfanta\Pagerfanta->setCurrentPage (line 67)
17	App\Repository\NoticiaRepository->getAllWebQuery (line 33)
18	App\Controller\NoticiaController->index (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.85 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, fecha_13 FROM (SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14 FROM noticias n0_ WHERE n0_.web = 1) dctrn_result_inner ORDER BY fecha_13 DESC) dctrn_result LIMIT 4 OFFSET 84

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      fecha_13
    FROM
      (
        SELECT
          n0_.id AS id_0,
          n0_.titular AS titular_1,
          n0_.slug AS slug_2,
          n0_.entradilla AS entradilla_3,
          n0_.contenido AS contenido_4,
          n0_.thumbnail AS thumbnail_5,
          n0_.imagen AS imagen_6,
          n0_.imagen2 AS imagen2_7,
          n0_.imagen3 AS imagen3_8,
          n0_.imagen4 AS imagen4_9,
          n0_.web AS web_10,
          n0_.home_web AS home_web_11,
          n0_.prensa AS prensa_12,
          n0_.fecha AS fecha_13,
          n0_.modificado AS modificado_14
        FROM
          noticias n0_
        WHERE
          n0_.web = 1
      ) dctrn_result_inner
    ORDER BY
      fecha_13 DESC
  ) dctrn_result
LIMIT
  4
OFFSET
  84

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, fecha_13 FROM (SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14 FROM noticias n0_ WHERE n0_.web = 1) dctrn_result_inner ORDER BY fecha_13 DESC) dctrn_result LIMIT 4 OFFSET 84;

#	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 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 1871)
11	Twig\Extension\CoreExtension::getAttribute (line 127)
12	__TwigTemplate_4e11763ac930095230f2b73564861fdb->block_body (line 431)
13	Twig\Template->yieldBlock (line 101)
14	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_4e11763ac930095230f2b73564861fdb->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
25	App\Controller\NoticiaController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

29.56 ms

SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14, n0_.meta_id AS meta_id_15 FROM noticias n0_ WHERE n0_.web = 1 AND n0_.id IN (?, ?, ?, ?) ORDER BY n0_.fecha DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.titular AS titular_1,
  n0_.slug AS slug_2,
  n0_.entradilla AS entradilla_3,
  n0_.contenido AS contenido_4,
  n0_.thumbnail AS thumbnail_5,
  n0_.imagen AS imagen_6,
  n0_.imagen2 AS imagen2_7,
  n0_.imagen3 AS imagen3_8,
  n0_.imagen4 AS imagen4_9,
  n0_.web AS web_10,
  n0_.home_web AS home_web_11,
  n0_.prensa AS prensa_12,
  n0_.fecha AS fecha_13,
  n0_.modificado AS modificado_14,
  n0_.meta_id AS meta_id_15
FROM
  noticias n0_
WHERE
  n0_.web = 1
  AND n0_.id IN (?, ?, ?, ?)
ORDER BY
  n0_.fecha DESC

SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14, n0_.meta_id AS meta_id_15 FROM noticias n0_ WHERE n0_.web = 1 AND n0_.id IN (830, 829, 828, 827) ORDER BY n0_.fecha DESC;

#	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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 57)
8	Pagerfanta\Doctrine\ORM\QueryAdapter->getSlice (line 268)
9	Pagerfanta\Pagerfanta->getCurrentPageResultsFromAdapter (line 257)
10	Pagerfanta\Pagerfanta->getCurrentPageResults (line 1871)
11	Twig\Extension\CoreExtension::getAttribute (line 127)
12	__TwigTemplate_4e11763ac930095230f2b73564861fdb->block_body (line 431)
13	Twig\Template->yieldBlock (line 101)
14	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
15	Twig\Template->yield (line 57)
16	__TwigTemplate_4e11763ac930095230f2b73564861fdb->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 40)
25	App\Controller\NoticiaController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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\Noticia	No errors.
App\Entity\Peliculas\Meta	No errors.

Symfony Profiler

GET https://filmax.iteracion.net/noticias/?page=22

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping