Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1.05 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.37 ms
(35.23%)

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.codigo_cines AS codigo_cines_11, t0.web AS web_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.instagram AS instagram_15, t0.youtube AS youtube_16, t0.dvd_link AS dvd_link_17, t0.vod_link AS vod_link_18, t0.destacada_web AS destacada_web_19, t0.principal_prensa AS principal_prensa_20, t0.destacada_prensa AS destacada_prensa_21, t0.banner AS banner_22, t0.listado AS listado_23, t0.catalogo AS catalogo_24, t0.catalogo_prensa AS catalogo_prensa_25, t0.catalogo_prensa_orden AS catalogo_prensa_orden_26, t0.activa AS activa_27, t0.activa_prensa AS activa_prensa_28, t0.destacado_orden AS destacado_orden_29, t0.destacado_orden_prensa AS destacado_orden_prensa_30, t0.catalogo_orden AS catalogo_orden_31, t0.rodaje AS rodaje_32, t0.meta_id AS meta_id_33, t0.estadoRodaje_id AS estadoRodaje_id_34 FROM peliculas t0 WHERE t0.id = ?

Parameters:

[
  "299"
]

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.codigo_cines AS codigo_cines_11,
  t0.web AS web_12,
  t0.facebook AS facebook_13,
  t0.twitter AS twitter_14,
  t0.instagram AS instagram_15,
  t0.youtube AS youtube_16,
  t0.dvd_link AS dvd_link_17,
  t0.vod_link AS vod_link_18,
  t0.destacada_web AS destacada_web_19,
  t0.principal_prensa AS principal_prensa_20,
  t0.destacada_prensa AS destacada_prensa_21,
  t0.banner AS banner_22,
  t0.listado AS listado_23,
  t0.catalogo AS catalogo_24,
  t0.catalogo_prensa AS catalogo_prensa_25,
  t0.catalogo_prensa_orden AS catalogo_prensa_orden_26,
  t0.activa AS activa_27,
  t0.activa_prensa AS activa_prensa_28,
  t0.destacado_orden AS destacado_orden_29,
  t0.destacado_orden_prensa AS destacado_orden_prensa_30,
  t0.catalogo_orden AS catalogo_orden_31,
  t0.rodaje AS rodaje_32,
  t0.meta_id AS meta_id_33,
  t0.estadoRodaje_id AS estadoRodaje_id_34
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.codigo_cines AS codigo_cines_11, t0.web AS web_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.instagram AS instagram_15, t0.youtube AS youtube_16, t0.dvd_link AS dvd_link_17, t0.vod_link AS vod_link_18, t0.destacada_web AS destacada_web_19, t0.principal_prensa AS principal_prensa_20, t0.destacada_prensa AS destacada_prensa_21, t0.banner AS banner_22, t0.listado AS listado_23, t0.catalogo AS catalogo_24, t0.catalogo_prensa AS catalogo_prensa_25, t0.catalogo_prensa_orden AS catalogo_prensa_orden_26, t0.activa AS activa_27, t0.activa_prensa AS activa_prensa_28, t0.destacado_orden AS destacado_orden_29, t0.destacado_orden_prensa AS destacado_orden_prensa_30, t0.catalogo_orden AS catalogo_orden_31, t0.rodaje AS rodaje_32, t0.meta_id AS meta_id_33, t0.estadoRodaje_id AS estadoRodaje_id_34 FROM peliculas t0 WHERE t0.id = '299';

#	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.19 ms
(18.00%)

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:

[
  299
]

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 = 299;

#	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 53)
16	__TwigTemplate_999e7e293135c664b3f2f731dcc971aa->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 84)
25	App\Controller\PeliculasController->cines (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)

0.17 ms
(16.66%)

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:

[
  299
]

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 = 299 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 134)
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 53)
17	__TwigTemplate_999e7e293135c664b3f2f731dcc971aa->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 84)
26	App\Controller\PeliculasController->cines (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.17 ms
(16.00%)

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:

[
  299
]

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 = 299;

#	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 53)
18	__TwigTemplate_999e7e293135c664b3f2f731dcc971aa->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 84)
27	App\Controller\PeliculasController->cines (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)

0.15 ms
(14.10%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.keywords AS keywords_3 FROM meta t0 WHERE t0.id = ?

Parameters:

[
  9395
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.keywords AS keywords_3
FROM
  meta t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.keywords AS keywords_3 FROM meta t0 WHERE t0.id = 9395;

#	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 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Peliculas\Meta::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Peliculas\Meta->__get (line 48)
8	App\Entity\Peliculas\Meta->getDescription (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 92)
10	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->block_ogtags (line 431)
11	Twig\Template->yieldBlock (line 82)
12	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
13	Twig\Template->yield (line 65)
14	__TwigTemplate_9d8714a2298270234e10f4ba4f3bdfb4->doDisplay (line 387)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_999e7e293135c664b3f2f731dcc971aa->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 84)
25	App\Controller\PeliculasController->cines (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://dev.filmax.com/distribucion/mi-amiga-eva/299/cines

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping