2.40 ms
(75.39%)
|
1 |
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 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;
|
0.78 ms
(24.61%)
|
1 |
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 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;
|