Symfony Profiler

Query Metrics

263 Database Queries

3 Different statements

110.10 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

53.71 ms
(48.79%)

261

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = ? ORDER BY t0.principal DESC, t0.id ASC

Parameters:

[
  296
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 296 ORDER BY t0.principal DESC, t0.id ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1920)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1861)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 132)
9	App\Entity\Peliculas\Pelicula->getCartel (line 1871)
10	Twig\Extension\CoreExtension::getAttribute (line 586)
11	__TwigTemplate_cd4c954c96bf87f3dc9a386edb8fd1d9->{closure} (line 2068)
12	Twig\Extension\CoreExtension::captureOutput (line 564)
13	__TwigTemplate_cd4c954c96bf87f3dc9a386edb8fd1d9->macro_gridMovies (line 204)
14	__TwigTemplate_8fda4a4dfcfebad9cceb6969ce8a33e4->block_body (line 431)
15	Twig\Template->yieldBlock (line 101)
16	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
17	Twig\Template->yield (line 57)
18	__TwigTemplate_8fda4a4dfcfebad9cceb6969ce8a33e4->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 27)
27	App\Controller\PeliculasController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

36.20 ms
(32.88%)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.titulo AS titulo_2, p0_.claim AS claim_3, p0_.fecha_estreno AS fecha_estreno_4, p0_.sinopsis AS sinopsis_5, p0_.reparto AS reparto_6, p0_.equipo_tecnico AS equipo_tecnico_7, p0_.datos_tecnicos AS datos_tecnicos_8, p0_.cines AS cines_9, p0_.web AS web_10, p0_.facebook AS facebook_11, p0_.twitter AS twitter_12, p0_.instagram AS instagram_13, p0_.youtube AS youtube_14, p0_.dvd_link AS dvd_link_15, p0_.vod_link AS vod_link_16, p0_.destacada_web AS destacada_web_17, p0_.principal_prensa AS principal_prensa_18, p0_.destacada_prensa AS destacada_prensa_19, p0_.banner AS banner_20, p0_.listado AS listado_21, p0_.catalogo AS catalogo_22, p0_.catalogo_prensa AS catalogo_prensa_23, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24, p0_.activa AS activa_25, p0_.activa_prensa AS activa_prensa_26, p0_.destacado_orden AS destacado_orden_27, p0_.destacado_orden_prensa AS destacado_orden_prensa_28, p0_.catalogo_orden AS catalogo_orden_29, p0_.rodaje AS rodaje_30, c1_.id AS id_31, c1_.nombre_corto AS nombre_corto_32, c1_.nombre AS nombre_33, c1_.web AS web_34, c1_.prensa AS prensa_35, p0_.meta_id AS meta_id_36, p0_.estadoRodaje_id AS estadoRodaje_id_37, c1_.seccion_id AS seccion_id_38 FROM peliculas p0_ INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id WHERE p0_.activa = 1 AND s3_.slug = ? AND p0_.listado = 1 ORDER BY p0_.fecha_estreno DESC, p0_.titulo ASC

Parameters:

[
  "distribucion"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.titulo AS titulo_2,
  p0_.claim AS claim_3,
  p0_.fecha_estreno AS fecha_estreno_4,
  p0_.sinopsis AS sinopsis_5,
  p0_.reparto AS reparto_6,
  p0_.equipo_tecnico AS equipo_tecnico_7,
  p0_.datos_tecnicos AS datos_tecnicos_8,
  p0_.cines AS cines_9,
  p0_.web AS web_10,
  p0_.facebook AS facebook_11,
  p0_.twitter AS twitter_12,
  p0_.instagram AS instagram_13,
  p0_.youtube AS youtube_14,
  p0_.dvd_link AS dvd_link_15,
  p0_.vod_link AS vod_link_16,
  p0_.destacada_web AS destacada_web_17,
  p0_.principal_prensa AS principal_prensa_18,
  p0_.destacada_prensa AS destacada_prensa_19,
  p0_.banner AS banner_20,
  p0_.listado AS listado_21,
  p0_.catalogo AS catalogo_22,
  p0_.catalogo_prensa AS catalogo_prensa_23,
  p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24,
  p0_.activa AS activa_25,
  p0_.activa_prensa AS activa_prensa_26,
  p0_.destacado_orden AS destacado_orden_27,
  p0_.destacado_orden_prensa AS destacado_orden_prensa_28,
  p0_.catalogo_orden AS catalogo_orden_29,
  p0_.rodaje AS rodaje_30,
  c1_.id AS id_31,
  c1_.nombre_corto AS nombre_corto_32,
  c1_.nombre AS nombre_33,
  c1_.web AS web_34,
  c1_.prensa AS prensa_35,
  p0_.meta_id AS meta_id_36,
  p0_.estadoRodaje_id AS estadoRodaje_id_37,
  c1_.seccion_id AS seccion_id_38
FROM
  peliculas p0_
  INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id
  INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id
  INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id
  INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id
WHERE
  p0_.activa = 1
  AND s3_.slug = ?
  AND p0_.listado = 1
ORDER BY
  p0_.fecha_estreno DESC,
  p0_.titulo ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.titulo AS titulo_2, p0_.claim AS claim_3, p0_.fecha_estreno AS fecha_estreno_4, p0_.sinopsis AS sinopsis_5, p0_.reparto AS reparto_6, p0_.equipo_tecnico AS equipo_tecnico_7, p0_.datos_tecnicos AS datos_tecnicos_8, p0_.cines AS cines_9, p0_.web AS web_10, p0_.facebook AS facebook_11, p0_.twitter AS twitter_12, p0_.instagram AS instagram_13, p0_.youtube AS youtube_14, p0_.dvd_link AS dvd_link_15, p0_.vod_link AS vod_link_16, p0_.destacada_web AS destacada_web_17, p0_.principal_prensa AS principal_prensa_18, p0_.destacada_prensa AS destacada_prensa_19, p0_.banner AS banner_20, p0_.listado AS listado_21, p0_.catalogo AS catalogo_22, p0_.catalogo_prensa AS catalogo_prensa_23, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24, p0_.activa AS activa_25, p0_.activa_prensa AS activa_prensa_26, p0_.destacado_orden AS destacado_orden_27, p0_.destacado_orden_prensa AS destacado_orden_prensa_28, p0_.catalogo_orden AS catalogo_orden_29, p0_.rodaje AS rodaje_30, c1_.id AS id_31, c1_.nombre_corto AS nombre_corto_32, c1_.nombre AS nombre_33, c1_.web AS web_34, c1_.prensa AS prensa_35, p0_.meta_id AS meta_id_36, p0_.estadoRodaje_id AS estadoRodaje_id_37, c1_.seccion_id AS seccion_id_38 FROM peliculas p0_ INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id WHERE p0_.activa = 1 AND s3_.slug = 'distribucion' AND p0_.listado = 1 ORDER BY p0_.fecha_estreno DESC, p0_.titulo 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 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 164)
7	App\Repository\PeliculaRepository->findByCategoria (line 25)
8	App\Controller\PeliculasController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

20.19 ms
(18.33%)

SELECT c0_.id AS id_0, c0_.nombre_corto AS nombre_corto_1, c0_.nombre AS nombre_2, c0_.web AS web_3, c0_.prensa AS prensa_4, c0_.seccion_id AS seccion_id_5 FROM categorias c0_ INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id WHERE c0_.web = 1 AND s1_.slug = ?

Parameters:

[
  "distribucion"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nombre_corto AS nombre_corto_1,
  c0_.nombre AS nombre_2,
  c0_.web AS web_3,
  c0_.prensa AS prensa_4,
  c0_.seccion_id AS seccion_id_5
FROM
  categorias c0_
  INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id
WHERE
  c0_.web = 1
  AND s1_.slug = ?

SELECT c0_.id AS id_0, c0_.nombre_corto AS nombre_corto_1, c0_.nombre AS nombre_2, c0_.web AS web_3, c0_.prensa AS prensa_4, c0_.seccion_id AS seccion_id_5 FROM categorias c0_ INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id WHERE c0_.web = 1 AND s1_.slug = 'distribucion';

#	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 25)
7	App\Repository\CategoriaRepository->findCategoriasWeb (line 26)
8	App\Controller\PeliculasController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Peliculas\Pelicula	No errors.
App\Entity\Peliculas\Categoria	No errors.
App\Entity\Peliculas\Seccion	No errors.
App\Entity\Peliculas\Meta	No errors.
App\Entity\Peliculas\EstadoRodaje	No errors.
App\Entity\Peliculas\Director	No errors.
App\Entity\Peliculas\Actor	No errors.
App\Entity\Peliculas\Cartel	No errors.
App\Entity\Peliculas\Fotografia	No errors.
App\Entity\Peliculas\Documento	No errors.
App\Entity\Peliculas\Video	No errors.
App\Entity\Peliculas\VideoPrensa	No errors.
App\Entity\Peliculas\Audio	No errors.
App\Entity\Peliculas\Critica	No errors.
App\Entity\Peliculas\Extra	No errors.
App\Entity\Peliculas\Banner	No errors.
App\Entity\Peliculas\Personalizacion	No errors.
App\Entity\Peliculas\VideoOnDemand	No errors.
App\Entity\Tv\TV	No errors.
App\Entity\Opera\Opera	No errors.
App\Entity\Prensa\Statistics	No errors.
App\Entity\Prensa\CartelStats	No errors.

Symfony Profiler

GET https://filmax.iteracion.net/distribucion/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping