Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1.45 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.56 ms
(38.32%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titulo AS titulo_3, t0.claim AS claim_4, t0.fecha_estreno AS fecha_estreno_5, t0.sinopsis AS sinopsis_6, t0.reparto AS reparto_7, t0.equipo_tecnico AS equipo_tecnico_8, t0.datos_tecnicos AS datos_tecnicos_9, t0.cines AS cines_10, t0.web AS web_11, t0.facebook AS facebook_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.dvd_link AS dvd_link_16, t0.vod_link AS vod_link_17, t0.destacada_web AS destacada_web_18, t0.principal_prensa AS principal_prensa_19, t0.destacada_prensa AS destacada_prensa_20, t0.banner AS banner_21, t0.listado AS listado_22, t0.catalogo AS catalogo_23, t0.catalogo_prensa AS catalogo_prensa_24, t0.catalogo_prensa_orden AS catalogo_prensa_orden_25, t0.activa AS activa_26, t0.activa_prensa AS activa_prensa_27, t0.destacado_orden AS destacado_orden_28, t0.destacado_orden_prensa AS destacado_orden_prensa_29, t0.catalogo_orden AS catalogo_orden_30, t0.rodaje AS rodaje_31, t0.meta_id AS meta_id_32, t0.estadoRodaje_id AS estadoRodaje_id_33 FROM peliculas t0 WHERE t0.id = ?

Parameters:

[
  "157"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.titulo AS titulo_3,
  t0.claim AS claim_4,
  t0.fecha_estreno AS fecha_estreno_5,
  t0.sinopsis AS sinopsis_6,
  t0.reparto AS reparto_7,
  t0.equipo_tecnico AS equipo_tecnico_8,
  t0.datos_tecnicos AS datos_tecnicos_9,
  t0.cines AS cines_10,
  t0.web AS web_11,
  t0.facebook AS facebook_12,
  t0.twitter AS twitter_13,
  t0.instagram AS instagram_14,
  t0.youtube AS youtube_15,
  t0.dvd_link AS dvd_link_16,
  t0.vod_link AS vod_link_17,
  t0.destacada_web AS destacada_web_18,
  t0.principal_prensa AS principal_prensa_19,
  t0.destacada_prensa AS destacada_prensa_20,
  t0.banner AS banner_21,
  t0.listado AS listado_22,
  t0.catalogo AS catalogo_23,
  t0.catalogo_prensa AS catalogo_prensa_24,
  t0.catalogo_prensa_orden AS catalogo_prensa_orden_25,
  t0.activa AS activa_26,
  t0.activa_prensa AS activa_prensa_27,
  t0.destacado_orden AS destacado_orden_28,
  t0.destacado_orden_prensa AS destacado_orden_prensa_29,
  t0.catalogo_orden AS catalogo_orden_30,
  t0.rodaje AS rodaje_31,
  t0.meta_id AS meta_id_32,
  t0.estadoRodaje_id AS estadoRodaje_id_33
FROM
  peliculas t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titulo AS titulo_3, t0.claim AS claim_4, t0.fecha_estreno AS fecha_estreno_5, t0.sinopsis AS sinopsis_6, t0.reparto AS reparto_7, t0.equipo_tecnico AS equipo_tecnico_8, t0.datos_tecnicos AS datos_tecnicos_9, t0.cines AS cines_10, t0.web AS web_11, t0.facebook AS facebook_12, t0.twitter AS twitter_13, t0.instagram AS instagram_14, t0.youtube AS youtube_15, t0.dvd_link AS dvd_link_16, t0.vod_link AS vod_link_17, t0.destacada_web AS destacada_web_18, t0.principal_prensa AS principal_prensa_19, t0.destacada_prensa AS destacada_prensa_20, t0.banner AS banner_21, t0.listado AS listado_22, t0.catalogo AS catalogo_23, t0.catalogo_prensa AS catalogo_prensa_24, t0.catalogo_prensa_orden AS catalogo_prensa_orden_25, t0.activa AS activa_26, t0.activa_prensa AS activa_prensa_27, t0.destacado_orden AS destacado_orden_28, t0.destacado_orden_prensa AS destacado_orden_prensa_29, t0.catalogo_orden AS catalogo_orden_30, t0.rodaje AS rodaje_31, t0.meta_id AS meta_id_32, t0.estadoRodaje_id AS estadoRodaje_id_33 FROM peliculas t0 WHERE t0.id = '157';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 797)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 119)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.29 ms
(19.98%)

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:

[
  157
]

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 = 157 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 102)
11	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_ogtags (line 431)
12	Twig\Template->yieldBlock (line 82)
13	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
14	Twig\Template->yield (line 65)
15	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 45)
24	App\Controller\PeliculasController->detalle (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.22 ms
(14.89%)

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.subtitulo AS subtitulo_3, t0.imagen AS imagen_4, t0.pelicula_id AS pelicula_id_5 FROM peliculas_banners t0 WHERE t0.pelicula_id = ?

Parameters:

[
  157
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.subtitulo AS subtitulo_3,
  t0.imagen AS imagen_4,
  t0.pelicula_id AS pelicula_id_5
FROM
  peliculas_banners t0
WHERE
  t0.pelicula_id = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.subtitulo AS subtitulo_3, t0.imagen AS imagen_4, t0.pelicula_id AS pelicula_id_5 FROM peliculas_banners t0 WHERE t0.pelicula_id = 157;

#	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 1375)
9	Twig\Extension\CoreExtension::testEmpty (line 221)
10	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_body (line 431)
11	Twig\Template->yieldBlock (line 101)
12	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
13	Twig\Template->yield (line 65)
14	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 45)
23	App\Controller\PeliculasController->detalle (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.21 ms
(14.13%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.nombre AS nombre_3, t0.link AS link_4 FROM video_on_demand t0 INNER JOIN peliculas_vod ON t0.id = peliculas_vod.videoondemand_id WHERE peliculas_vod.pelicula_id = ?

Parameters:

[
  157
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.nombre AS nombre_3,
  t0.link AS link_4
FROM
  video_on_demand t0
  INNER JOIN peliculas_vod ON t0.id = peliculas_vod.videoondemand_id
WHERE
  peliculas_vod.pelicula_id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.nombre AS nombre_3, t0.link AS link_4 FROM video_on_demand t0 INNER JOIN peliculas_vod ON t0.id = peliculas_vod.videoondemand_id WHERE peliculas_vod.pelicula_id = 157;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1120)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1042)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 920)
8	__TwigTemplate_cd4c954c96bf87f3dc9a386edb8fd1d9->{closure} (line 2068)
9	Twig\Extension\CoreExtension::captureOutput (line 904)
10	__TwigTemplate_cd4c954c96bf87f3dc9a386edb8fd1d9->macro_sectionVOD (line 325)
11	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_area (line 431)
12	Twig\Template->yieldBlock (line 260)
13	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_body (line 431)
14	Twig\Template->yieldBlock (line 101)
15	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
16	Twig\Template->yield (line 65)
17	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 45)
26	App\Controller\PeliculasController->detalle (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.18 ms
(12.68%)

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.pelicula_id AS pelicula_id_4 FROM peliculas_extras t0 WHERE t0.pelicula_id = ?

Parameters:

[
  157
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titulo AS titulo_2,
  t0.texto AS texto_3,
  t0.pelicula_id AS pelicula_id_4
FROM
  peliculas_extras t0
WHERE
  t0.pelicula_id = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.texto AS texto_3, t0.pelicula_id AS pelicula_id_4 FROM peliculas_extras t0 WHERE t0.pelicula_id = 157;

#	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 1375)
9	Twig\Extension\CoreExtension::testEmpty (line 128)
10	__TwigTemplate_18d67b76690dd6d3c8be39d44c84481f->doDisplay (line 387)
11	Twig\Template->yield (line 251)
12	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_body (line 431)
13	Twig\Template->yieldBlock (line 101)
14	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
15	Twig\Template->yield (line 65)
16	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->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 45)
25	App\Controller\PeliculasController->detalle (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\Peliculas\Pelicula	No errors.
App\Entity\Peliculas\Meta	No errors.
App\Entity\Peliculas\EstadoRodaje	No errors.
App\Entity\Peliculas\Categoria	No errors.
App\Entity\Peliculas\Seccion	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\Prensa\Statistics	No errors.
App\Entity\Prensa\CartelStats	No errors.

Symfony Profiler

GET https://filmax.iteracion.net/produccion/el-embrujo-del-sur/157

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping