Symfony Profiler

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 = 'programas' ORDER BY t0_.destacado_orden ASC, t2_.principal DESC, t2_.id ASC;

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

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;