Symfony Profiler

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;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.titulo AS titulo_2,
  p0_.claim AS claim_3,
  p0_.fecha_estreno AS fecha_estreno_4,
  p0_.sinopsis AS sinopsis_5,
  p0_.reparto AS reparto_6,
  p0_.equipo_tecnico AS equipo_tecnico_7,
  p0_.datos_tecnicos AS datos_tecnicos_8,
  p0_.cines AS cines_9,
  p0_.web AS web_10,
  p0_.facebook AS facebook_11,
  p0_.twitter AS twitter_12,
  p0_.instagram AS instagram_13,
  p0_.youtube AS youtube_14,
  p0_.dvd_link AS dvd_link_15,
  p0_.vod_link AS vod_link_16,
  p0_.destacada_web AS destacada_web_17,
  p0_.principal_prensa AS principal_prensa_18,
  p0_.destacada_prensa AS destacada_prensa_19,
  p0_.banner AS banner_20,
  p0_.listado AS listado_21,
  p0_.catalogo AS catalogo_22,
  p0_.catalogo_prensa AS catalogo_prensa_23,
  p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24,
  p0_.activa AS activa_25,
  p0_.activa_prensa AS activa_prensa_26,
  p0_.destacado_orden AS destacado_orden_27,
  p0_.destacado_orden_prensa AS destacado_orden_prensa_28,
  p0_.catalogo_orden AS catalogo_orden_29,
  p0_.rodaje AS rodaje_30,
  d1_.id AS id_31,
  d1_.nombre AS nombre_32,
  e2_.id AS id_33,
  e2_.nombre_corto AS nombre_corto_34,
  e2_.nombre AS nombre_35,
  c3_.id AS id_36,
  c3_.nombre_corto AS nombre_corto_37,
  c3_.nombre AS nombre_38,
  c3_.web AS web_39,
  c3_.prensa AS prensa_40,
  p4_.id AS id_41,
  p4_.cartel AS cartel_42,
  p4_.descripcion AS descripcion_43,
  p4_.principal AS principal_44,
  p4_.press AS press_45,
  p5_.id AS id_46,
  p5_.trailer AS trailer_47,
  p5_.titulo AS titulo_48,
  p5_.duracion AS duracion_49,
  p5_.idioma AS idioma_50,
  p5_.thumbnail AS thumbnail_51,
  p5_.video AS video_52,
  p0_.meta_id AS meta_id_53,
  p0_.estadoRodaje_id AS estadoRodaje_id_54,
  c3_.seccion_id AS seccion_id_55,
  p4_.pelicula_id AS pelicula_id_56,
  p5_.pelicula_id AS pelicula_id_57
FROM
  peliculas p0_
  LEFT JOIN peliculas_directores p6_ ON p0_.id = p6_.pelicula_id
  LEFT JOIN directores d1_ ON d1_.id = p6_.director_id
  LEFT JOIN estados_rodaje e2_ ON p0_.estadoRodaje_id = e2_.id
  LEFT JOIN peliculas_categorias p7_ ON p0_.id = p7_.pelicula_id
  LEFT JOIN categorias c3_ ON c3_.id = p7_.categoria_id
  LEFT JOIN peliculas_carteles p4_ ON p0_.id = p4_.pelicula_id
  LEFT JOIN peliculas_videos p5_ ON p0_.id = p5_.pelicula_id
WHERE
  p0_.activa = 1
  AND p0_.destacada_web = 1
ORDER BY
  p0_.destacado_orden ASC,
  d1_.nombre ASC,
  p4_.principal DESC,
  p4_.id ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.titulo AS titulo_2, p0_.claim AS claim_3, p0_.fecha_estreno AS fecha_estreno_4, p0_.sinopsis AS sinopsis_5, p0_.reparto AS reparto_6, p0_.equipo_tecnico AS equipo_tecnico_7, p0_.datos_tecnicos AS datos_tecnicos_8, p0_.cines AS cines_9, p0_.web AS web_10, p0_.facebook AS facebook_11, p0_.twitter AS twitter_12, p0_.instagram AS instagram_13, p0_.youtube AS youtube_14, p0_.dvd_link AS dvd_link_15, p0_.vod_link AS vod_link_16, p0_.destacada_web AS destacada_web_17, p0_.principal_prensa AS principal_prensa_18, p0_.destacada_prensa AS destacada_prensa_19, p0_.banner AS banner_20, p0_.listado AS listado_21, p0_.catalogo AS catalogo_22, p0_.catalogo_prensa AS catalogo_prensa_23, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_24, p0_.activa AS activa_25, p0_.activa_prensa AS activa_prensa_26, p0_.destacado_orden AS destacado_orden_27, p0_.destacado_orden_prensa AS destacado_orden_prensa_28, p0_.catalogo_orden AS catalogo_orden_29, p0_.rodaje AS rodaje_30, d1_.id AS id_31, d1_.nombre AS nombre_32, e2_.id AS id_33, e2_.nombre_corto AS nombre_corto_34, e2_.nombre AS nombre_35, c3_.id AS id_36, c3_.nombre_corto AS nombre_corto_37, c3_.nombre AS nombre_38, c3_.web AS web_39, c3_.prensa AS prensa_40, p4_.id AS id_41, p4_.cartel AS cartel_42, p4_.descripcion AS descripcion_43, p4_.principal AS principal_44, p4_.press AS press_45, p5_.id AS id_46, p5_.trailer AS trailer_47, p5_.titulo AS titulo_48, p5_.duracion AS duracion_49, p5_.idioma AS idioma_50, p5_.thumbnail AS thumbnail_51, p5_.video AS video_52, p0_.meta_id AS meta_id_53, p0_.estadoRodaje_id AS estadoRodaje_id_54, c3_.seccion_id AS seccion_id_55, p4_.pelicula_id AS pelicula_id_56, p5_.pelicula_id AS pelicula_id_57 FROM peliculas p0_ LEFT JOIN peliculas_directores p6_ ON p0_.id = p6_.pelicula_id LEFT JOIN directores d1_ ON d1_.id = p6_.director_id LEFT JOIN estados_rodaje e2_ ON p0_.estadoRodaje_id = e2_.id LEFT JOIN peliculas_categorias p7_ ON p0_.id = p7_.pelicula_id LEFT JOIN categorias c3_ ON c3_.id = p7_.categoria_id LEFT JOIN peliculas_carteles p4_ ON p0_.id = p4_.pelicula_id LEFT JOIN peliculas_videos p5_ ON p0_.id = p5_.pelicula_id WHERE p0_.activa = 1 AND p0_.destacada_web = 1 ORDER BY p0_.destacado_orden ASC, d1_.nombre ASC, p4_.principal DESC, p4_.id ASC;

SELECT
  n0_.id AS id_0,
  n0_.titular AS titular_1,
  n0_.slug AS slug_2,
  n0_.entradilla AS entradilla_3,
  n0_.contenido AS contenido_4,
  n0_.thumbnail AS thumbnail_5,
  n0_.imagen AS imagen_6,
  n0_.imagen2 AS imagen2_7,
  n0_.imagen3 AS imagen3_8,
  n0_.imagen4 AS imagen4_9,
  n0_.web AS web_10,
  n0_.home_web AS home_web_11,
  n0_.prensa AS prensa_12,
  n0_.fecha AS fecha_13,
  n0_.modificado AS modificado_14,
  n0_.meta_id AS meta_id_15
FROM
  noticias n0_
WHERE
  n0_.web = 1
ORDER BY
  n0_.home_web DESC,
  n0_.fecha DESC
LIMIT
  4

SELECT n0_.id AS id_0, n0_.titular AS titular_1, n0_.slug AS slug_2, n0_.entradilla AS entradilla_3, n0_.contenido AS contenido_4, n0_.thumbnail AS thumbnail_5, n0_.imagen AS imagen_6, n0_.imagen2 AS imagen2_7, n0_.imagen3 AS imagen3_8, n0_.imagen4 AS imagen4_9, n0_.web AS web_10, n0_.home_web AS home_web_11, n0_.prensa AS prensa_12, n0_.fecha AS fecha_13, n0_.modificado AS modificado_14, n0_.meta_id AS meta_id_15 FROM noticias n0_ WHERE n0_.web = 1 ORDER BY n0_.home_web DESC, n0_.fecha DESC LIMIT 4;