Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

20.99 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

19.60 ms
(93.36%)

SELECT t0.id AS id_1, t0.trailer AS trailer_2, t0.titulo AS titulo_3, t0.duracion AS duracion_4, t0.idioma AS idioma_5, t0.thumbnail AS thumbnail_6, t0.video AS video_7, t0.tv_id AS tv_id_8 FROM tv_videos t0 WHERE t0.tv_id = ?

Parameters:

[
  25
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.trailer AS trailer_2,
  t0.titulo AS titulo_3,
  t0.duracion AS duracion_4,
  t0.idioma AS idioma_5,
  t0.thumbnail AS thumbnail_6,
  t0.video AS video_7,
  t0.tv_id AS tv_id_8
FROM
  tv_videos t0
WHERE
  t0.tv_id = ?

SELECT t0.id AS id_1, t0.trailer AS trailer_2, t0.titulo AS titulo_3, t0.duracion AS duracion_4, t0.idioma AS idioma_5, t0.thumbnail AS thumbnail_6, t0.video AS video_7, t0.tv_id AS tv_id_8 FROM tv_videos t0 WHERE t0.tv_id = 25;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 82)
8	__TwigTemplate_27fa1d19a68fad39c9c99d8bda61127b->block_area (line 431)
9	Twig\Template->yieldBlock (line 260)
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_27fa1d19a68fad39c9c99d8bda61127b->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 35)
25	App\Controller\TVController->trailer (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.61 ms
(2.92%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titulo AS titulo_3, t0.claim AS claim_4, t0.section AS section_5, t0.fecha_estreno AS fecha_estreno_6, t0.sinopsis AS sinopsis_7, t0.reparto AS reparto_8, t0.equipo_tecnico AS equipo_tecnico_9, t0.datos_tecnicos AS datos_tecnicos_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.activa AS activa_18, t0.destacado_orden AS destacado_orden_19, t0.destacada AS destacada_20, t0.meta_id AS meta_id_21 FROM tv t0 WHERE t0.id = ?

Parameters:

[
  "25"
]

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.section AS section_5,
  t0.fecha_estreno AS fecha_estreno_6,
  t0.sinopsis AS sinopsis_7,
  t0.reparto AS reparto_8,
  t0.equipo_tecnico AS equipo_tecnico_9,
  t0.datos_tecnicos AS datos_tecnicos_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.activa AS activa_18,
  t0.destacado_orden AS destacado_orden_19,
  t0.destacada AS destacada_20,
  t0.meta_id AS meta_id_21
FROM
  tv 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.section AS section_5, t0.fecha_estreno AS fecha_estreno_6, t0.sinopsis AS sinopsis_7, t0.reparto AS reparto_8, t0.equipo_tecnico AS equipo_tecnico_9, t0.datos_tecnicos AS datos_tecnicos_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.activa AS activa_18, t0.destacado_orden AS destacado_orden_19, t0.destacada AS destacada_20, t0.meta_id AS meta_id_21 FROM tv t0 WHERE t0.id = '25';

#	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.28 ms
(1.32%)

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.banner AS banner_5, t0.tv_id AS tv_id_6 FROM tv_carteles t0 WHERE t0.tv_id = ? ORDER BY t0.principal DESC, t0.id ASC

Parameters:

[
  25
]

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.banner AS banner_5,
  t0.tv_id AS tv_id_6
FROM
  tv_carteles t0
WHERE
  t0.tv_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.banner AS banner_5, t0.tv_id AS tv_id_6 FROM tv_carteles t0 WHERE t0.tv_id = 25 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 116)
9	App\Entity\Tv\TV->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_27fa1d19a68fad39c9c99d8bda61127b->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 35)
26	App\Controller\TVController->trailer (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.27 ms
(1.31%)

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

Parameters:

[
  9351
]

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

#	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_27fa1d19a68fad39c9c99d8bda61127b->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 35)
25	App\Controller\TVController->trailer (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.23 ms
(1.09%)

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.subtitulo AS subtitulo_3, t0.imagen AS imagen_4, t0.tv_id AS tv_id_5 FROM tv_banners t0 WHERE t0.tv_id = ?

Parameters:

[
  25
]

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.tv_id AS tv_id_5
FROM
  tv_banners t0
WHERE
  t0.tv_id = ?

SELECT t0.id AS id_1, t0.titulo AS titulo_2, t0.subtitulo AS subtitulo_3, t0.imagen AS imagen_4, t0.tv_id AS tv_id_5 FROM tv_banners t0 WHERE t0.tv_id = 25;

#	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_27fa1d19a68fad39c9c99d8bda61127b->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 35)
25	App\Controller\TVController->trailer (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\Tv\TV	No errors.
App\Entity\Peliculas\Meta	No errors.
App\Entity\Peliculas\Categoria	No errors.
App\Entity\Peliculas\Director	No errors.
App\Entity\Peliculas\Actor	No errors.
App\Entity\Tv\Cartel	No errors.
App\Entity\Tv\Fotografia	No errors.
App\Entity\Tv\Documento	No errors.
App\Entity\Tv\Video	No errors.
App\Entity\Tv\Audio	No errors.
App\Entity\Tv\Critica	No errors.
App\Entity\Tv\Extra	No errors.
App\Entity\Tv\Banner	No errors.
App\Entity\Tv\VideoPrensa	No errors.

Symfony Profiler

GET https://filmax.iteracion.net/tv/selftape/25/trailer

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping