Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

89.47 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

88.92 ms

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.titulo AS titulo_2, t0_.claim AS claim_3, t0_.section AS section_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_.web AS web_10, t0_.facebook AS facebook_11, t0_.twitter AS twitter_12, t0_.instagram AS instagram_13, t0_.youtube AS youtube_14, t0_.dvd_link AS dvd_link_15, t0_.vod_link AS vod_link_16, t0_.activa AS activa_17, t0_.destacado_orden AS destacado_orden_18, t0_.destacada AS destacada_19, c1_.id AS id_20, c1_.nombre_corto AS nombre_corto_21, c1_.nombre AS nombre_22, c1_.web AS web_23, c1_.prensa AS prensa_24, t2_.id AS id_25, t2_.cartel AS cartel_26, t2_.descripcion AS descripcion_27, t2_.principal AS principal_28, t2_.banner AS banner_29, t0_.meta_id AS meta_id_30, c1_.seccion_id AS seccion_id_31, t2_.tv_id AS tv_id_32 FROM tv t0_ LEFT JOIN tv_categorias t3_ ON t0_.id = t3_.tv_id LEFT JOIN categorias c1_ ON c1_.id = t3_.categoria_id LEFT JOIN tv_carteles t2_ ON t0_.id = t2_.tv_id LEFT JOIN tv_videos t4_ ON t0_.id = t4_.tv_id WHERE t0_.activa = 1 AND t0_.destacada = 1 AND t0_.section = ? ORDER BY t0_.destacado_orden ASC, t2_.principal DESC, t2_.id ASC

Parameters:

[
  "series"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.titulo AS titulo_2,
  t0_.claim AS claim_3,
  t0_.section AS section_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_.web AS web_10,
  t0_.facebook AS facebook_11,
  t0_.twitter AS twitter_12,
  t0_.instagram AS instagram_13,
  t0_.youtube AS youtube_14,
  t0_.dvd_link AS dvd_link_15,
  t0_.vod_link AS vod_link_16,
  t0_.activa AS activa_17,
  t0_.destacado_orden AS destacado_orden_18,
  t0_.destacada AS destacada_19,
  c1_.id AS id_20,
  c1_.nombre_corto AS nombre_corto_21,
  c1_.nombre AS nombre_22,
  c1_.web AS web_23,
  c1_.prensa AS prensa_24,
  t2_.id AS id_25,
  t2_.cartel AS cartel_26,
  t2_.descripcion AS descripcion_27,
  t2_.principal AS principal_28,
  t2_.banner AS banner_29,
  t0_.meta_id AS meta_id_30,
  c1_.seccion_id AS seccion_id_31,
  t2_.tv_id AS tv_id_32
FROM
  tv t0_
  LEFT JOIN tv_categorias t3_ ON t0_.id = t3_.tv_id
  LEFT JOIN categorias c1_ ON c1_.id = t3_.categoria_id
  LEFT JOIN tv_carteles t2_ ON t0_.id = t2_.tv_id
  LEFT JOIN tv_videos t4_ ON t0_.id = t4_.tv_id
WHERE
  t0_.activa = 1
  AND t0_.destacada = 1
  AND t0_.section = ?
ORDER BY
  t0_.destacado_orden ASC,
  t2_.principal DESC,
  t2_.id ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.titulo AS titulo_2, t0_.claim AS claim_3, t0_.section AS section_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_.web AS web_10, t0_.facebook AS facebook_11, t0_.twitter AS twitter_12, t0_.instagram AS instagram_13, t0_.youtube AS youtube_14, t0_.dvd_link AS dvd_link_15, t0_.vod_link AS vod_link_16, t0_.activa AS activa_17, t0_.destacado_orden AS destacado_orden_18, t0_.destacada AS destacada_19, c1_.id AS id_20, c1_.nombre_corto AS nombre_corto_21, c1_.nombre AS nombre_22, c1_.web AS web_23, c1_.prensa AS prensa_24, t2_.id AS id_25, t2_.cartel AS cartel_26, t2_.descripcion AS descripcion_27, t2_.principal AS principal_28, t2_.banner AS banner_29, t0_.meta_id AS meta_id_30, c1_.seccion_id AS seccion_id_31, t2_.tv_id AS tv_id_32 FROM tv t0_ LEFT JOIN tv_categorias t3_ ON t0_.id = t3_.tv_id LEFT JOIN categorias c1_ ON c1_.id = t3_.categoria_id LEFT JOIN tv_carteles t2_ ON t0_.id = t2_.tv_id LEFT JOIN tv_videos t4_ ON t0_.id = t4_.tv_id WHERE t0_.activa = 1 AND t0_.destacada = 1 AND t0_.section = 'series' ORDER BY t0_.destacado_orden ASC, t2_.principal DESC, t2_.id 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 31)
7	App\Repository\TVRepository->findDestacados (line 17)
8	App\Controller\TVController->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)

0.56 ms

SELECT b0_.id AS id_0, b0_.titulo AS titulo_1, b0_.subtitulo AS subtitulo_2, b0_.imagen AS imagen_3, b0_.imagenMovil AS imagenMovil_4, b0_.orden AS orden_5, b0_.link AS link_6, b0_.header AS header_7, b0_.activo AS activo_8, b0_.activoTV AS activoTV_9, b0_.activoPrensa AS activoPrensa_10, b0_.modificado AS modificado_11, p1_.id AS id_12, p1_.slug AS slug_13, p1_.titulo AS titulo_14, p1_.claim AS claim_15, p1_.fecha_estreno AS fecha_estreno_16, p1_.sinopsis AS sinopsis_17, p1_.reparto AS reparto_18, p1_.equipo_tecnico AS equipo_tecnico_19, p1_.datos_tecnicos AS datos_tecnicos_20, p1_.cines AS cines_21, p1_.web AS web_22, p1_.facebook AS facebook_23, p1_.twitter AS twitter_24, p1_.instagram AS instagram_25, p1_.youtube AS youtube_26, p1_.dvd_link AS dvd_link_27, p1_.vod_link AS vod_link_28, p1_.destacada_web AS destacada_web_29, p1_.principal_prensa AS principal_prensa_30, p1_.destacada_prensa AS destacada_prensa_31, p1_.banner AS banner_32, p1_.listado AS listado_33, p1_.catalogo AS catalogo_34, p1_.catalogo_prensa AS catalogo_prensa_35, p1_.catalogo_prensa_orden AS catalogo_prensa_orden_36, p1_.activa AS activa_37, p1_.activa_prensa AS activa_prensa_38, p1_.destacado_orden AS destacado_orden_39, p1_.destacado_orden_prensa AS destacado_orden_prensa_40, p1_.catalogo_orden AS catalogo_orden_41, p1_.rodaje AS rodaje_42, n2_.id AS id_43, n2_.titular AS titular_44, n2_.slug AS slug_45, n2_.entradilla AS entradilla_46, n2_.contenido AS contenido_47, n2_.thumbnail AS thumbnail_48, n2_.imagen AS imagen_49, n2_.imagen2 AS imagen2_50, n2_.imagen3 AS imagen3_51, n2_.imagen4 AS imagen4_52, n2_.web AS web_53, n2_.home_web AS home_web_54, n2_.prensa AS prensa_55, n2_.fecha AS fecha_56, n2_.modificado AS modificado_57, b0_.pelicula_id AS pelicula_id_58, b0_.noticia_id AS noticia_id_59, b0_.tv_id AS tv_id_60, p1_.meta_id AS meta_id_61, p1_.estadoRodaje_id AS estadoRodaje_id_62, n2_.meta_id AS meta_id_63 FROM banners b0_ LEFT JOIN peliculas p1_ ON b0_.pelicula_id = p1_.id LEFT JOIN noticias n2_ ON b0_.noticia_id = n2_.id LEFT JOIN tv t3_ ON b0_.tv_id = t3_.id WHERE b0_.activoTV = 1 ORDER BY b0_.orden ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.titulo AS titulo_1,
  b0_.subtitulo AS subtitulo_2,
  b0_.imagen AS imagen_3,
  b0_.imagenMovil AS imagenMovil_4,
  b0_.orden AS orden_5,
  b0_.link AS link_6,
  b0_.header AS header_7,
  b0_.activo AS activo_8,
  b0_.activoTV AS activoTV_9,
  b0_.activoPrensa AS activoPrensa_10,
  b0_.modificado AS modificado_11,
  p1_.id AS id_12,
  p1_.slug AS slug_13,
  p1_.titulo AS titulo_14,
  p1_.claim AS claim_15,
  p1_.fecha_estreno AS fecha_estreno_16,
  p1_.sinopsis AS sinopsis_17,
  p1_.reparto AS reparto_18,
  p1_.equipo_tecnico AS equipo_tecnico_19,
  p1_.datos_tecnicos AS datos_tecnicos_20,
  p1_.cines AS cines_21,
  p1_.web AS web_22,
  p1_.facebook AS facebook_23,
  p1_.twitter AS twitter_24,
  p1_.instagram AS instagram_25,
  p1_.youtube AS youtube_26,
  p1_.dvd_link AS dvd_link_27,
  p1_.vod_link AS vod_link_28,
  p1_.destacada_web AS destacada_web_29,
  p1_.principal_prensa AS principal_prensa_30,
  p1_.destacada_prensa AS destacada_prensa_31,
  p1_.banner AS banner_32,
  p1_.listado AS listado_33,
  p1_.catalogo AS catalogo_34,
  p1_.catalogo_prensa AS catalogo_prensa_35,
  p1_.catalogo_prensa_orden AS catalogo_prensa_orden_36,
  p1_.activa AS activa_37,
  p1_.activa_prensa AS activa_prensa_38,
  p1_.destacado_orden AS destacado_orden_39,
  p1_.destacado_orden_prensa AS destacado_orden_prensa_40,
  p1_.catalogo_orden AS catalogo_orden_41,
  p1_.rodaje AS rodaje_42,
  n2_.id AS id_43,
  n2_.titular AS titular_44,
  n2_.slug AS slug_45,
  n2_.entradilla AS entradilla_46,
  n2_.contenido AS contenido_47,
  n2_.thumbnail AS thumbnail_48,
  n2_.imagen AS imagen_49,
  n2_.imagen2 AS imagen2_50,
  n2_.imagen3 AS imagen3_51,
  n2_.imagen4 AS imagen4_52,
  n2_.web AS web_53,
  n2_.home_web AS home_web_54,
  n2_.prensa AS prensa_55,
  n2_.fecha AS fecha_56,
  n2_.modificado AS modificado_57,
  b0_.pelicula_id AS pelicula_id_58,
  b0_.noticia_id AS noticia_id_59,
  b0_.tv_id AS tv_id_60,
  p1_.meta_id AS meta_id_61,
  p1_.estadoRodaje_id AS estadoRodaje_id_62,
  n2_.meta_id AS meta_id_63
FROM
  banners b0_
  LEFT JOIN peliculas p1_ ON b0_.pelicula_id = p1_.id
  LEFT JOIN noticias n2_ ON b0_.noticia_id = n2_.id
  LEFT JOIN tv t3_ ON b0_.tv_id = t3_.id
WHERE
  b0_.activoTV = 1
ORDER BY
  b0_.orden ASC

SELECT b0_.id AS id_0, b0_.titulo AS titulo_1, b0_.subtitulo AS subtitulo_2, b0_.imagen AS imagen_3, b0_.imagenMovil AS imagenMovil_4, b0_.orden AS orden_5, b0_.link AS link_6, b0_.header AS header_7, b0_.activo AS activo_8, b0_.activoTV AS activoTV_9, b0_.activoPrensa AS activoPrensa_10, b0_.modificado AS modificado_11, p1_.id AS id_12, p1_.slug AS slug_13, p1_.titulo AS titulo_14, p1_.claim AS claim_15, p1_.fecha_estreno AS fecha_estreno_16, p1_.sinopsis AS sinopsis_17, p1_.reparto AS reparto_18, p1_.equipo_tecnico AS equipo_tecnico_19, p1_.datos_tecnicos AS datos_tecnicos_20, p1_.cines AS cines_21, p1_.web AS web_22, p1_.facebook AS facebook_23, p1_.twitter AS twitter_24, p1_.instagram AS instagram_25, p1_.youtube AS youtube_26, p1_.dvd_link AS dvd_link_27, p1_.vod_link AS vod_link_28, p1_.destacada_web AS destacada_web_29, p1_.principal_prensa AS principal_prensa_30, p1_.destacada_prensa AS destacada_prensa_31, p1_.banner AS banner_32, p1_.listado AS listado_33, p1_.catalogo AS catalogo_34, p1_.catalogo_prensa AS catalogo_prensa_35, p1_.catalogo_prensa_orden AS catalogo_prensa_orden_36, p1_.activa AS activa_37, p1_.activa_prensa AS activa_prensa_38, p1_.destacado_orden AS destacado_orden_39, p1_.destacado_orden_prensa AS destacado_orden_prensa_40, p1_.catalogo_orden AS catalogo_orden_41, p1_.rodaje AS rodaje_42, n2_.id AS id_43, n2_.titular AS titular_44, n2_.slug AS slug_45, n2_.entradilla AS entradilla_46, n2_.contenido AS contenido_47, n2_.thumbnail AS thumbnail_48, n2_.imagen AS imagen_49, n2_.imagen2 AS imagen2_50, n2_.imagen3 AS imagen3_51, n2_.imagen4 AS imagen4_52, n2_.web AS web_53, n2_.home_web AS home_web_54, n2_.prensa AS prensa_55, n2_.fecha AS fecha_56, n2_.modificado AS modificado_57, b0_.pelicula_id AS pelicula_id_58, b0_.noticia_id AS noticia_id_59, b0_.tv_id AS tv_id_60, p1_.meta_id AS meta_id_61, p1_.estadoRodaje_id AS estadoRodaje_id_62, n2_.meta_id AS meta_id_63 FROM banners b0_ LEFT JOIN peliculas p1_ ON b0_.pelicula_id = p1_.id LEFT JOIN noticias n2_ ON b0_.noticia_id = n2_.id LEFT JOIN tv t3_ ON b0_.tv_id = t3_.id WHERE b0_.activoTV = 1 ORDER BY b0_.orden 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 43)
7	App\Repository\BannerPortadaRepository->findActivos (line 23)
8	App\Controller\CarruselController->bannerTV (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 108)
16	__TwigTemplate_d75b852b9afaf38204fb9f5199c55150->block_body (line 431)
17	Twig\Template->yieldBlock (line 101)
18	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
19	Twig\Template->yield (line 57)
20	__TwigTemplate_d75b852b9afaf38204fb9f5199c55150->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 320)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 18)
29	App\Controller\TVController->index (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	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\Categoria	No errors.
App\Entity\Tv\Cartel	No errors.
App\Entity\Tv\Video	No errors.
App\Entity\Peliculas\Meta	No errors.
App\Entity\Peliculas\Seccion	No errors.
App\Entity\Peliculas\Director	No errors.
App\Entity\Peliculas\Actor	No errors.
App\Entity\Tv\Fotografia	No errors.
App\Entity\Tv\Documento	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.
App\Entity\Peliculas\Pelicula	No errors.
App\Entity\Opera\Opera	No errors.
App\Entity\Peliculas\BannerPortada	No errors.
App\Entity\Noticia	No errors.
App\Entity\Peliculas\EstadoRodaje	No errors.

Symfony Profiler

GET https://filmax.iteracion.net/_fragment?_path=_format%3Dhtml%26_locale%3Des%26_controller%3DApp%255CController%255CCarruselController%253A%253AbannerTV

Configuration Settings

Theme