Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.78 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.78 ms
(100.00%)

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_.activo = 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_.activo = 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_.activo = 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 16)
8	App\Controller\CarruselController->banner (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_f5cd7290d20009f94a46a11397032289->block_body (line 431)
17	Twig\Template->yieldBlock (line 101)
18	__TwigTemplate_ecafe876606b0eeeefbed9836f0d8ae5->doDisplay (line 387)
19	Twig\Template->yield (line 57)
20	__TwigTemplate_f5cd7290d20009f94a46a11397032289->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\PeliculasController->home (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\Peliculas\BannerPortada	No errors.
App\Entity\Peliculas\Pelicula	No errors.
App\Entity\Noticia	No errors.
App\Entity\Tv\TV	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.

Symfony Profiler

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

Configuration Settings

Theme