Symfony Profiler

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,
  c1_.id AS id_31,
  c1_.nombre_corto AS nombre_corto_32,
  c1_.nombre AS nombre_33,
  c1_.web AS web_34,
  c1_.prensa AS prensa_35,
  p0_.meta_id AS meta_id_36,
  p0_.estadoRodaje_id AS estadoRodaje_id_37,
  c1_.seccion_id AS seccion_id_38
FROM
  peliculas p0_
  INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id
  INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id
  INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id
  INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id
WHERE
  p0_.activa = 1
  AND s3_.slug = ?
  AND p0_.listado = 1
  AND c1_.id = ?
ORDER BY
  p0_.fecha_estreno DESC,
  p0_.titulo 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, c1_.id AS id_31, c1_.nombre_corto AS nombre_corto_32, c1_.nombre AS nombre_33, c1_.web AS web_34, c1_.prensa AS prensa_35, p0_.meta_id AS meta_id_36, p0_.estadoRodaje_id AS estadoRodaje_id_37, c1_.seccion_id AS seccion_id_38 FROM peliculas p0_ INNER JOIN peliculas_categorias p2_ ON p0_.id = p2_.pelicula_id INNER JOIN categorias c1_ ON c1_.id = p2_.categoria_id INNER JOIN pelicula_seccion p4_ ON p0_.id = p4_.pelicula_id INNER JOIN seccion s3_ ON s3_.id = p4_.seccion_id WHERE p0_.activa = 1 AND s3_.slug = 'distribucion' AND p0_.listado = 1 AND c1_.id = '4' ORDER BY p0_.fecha_estreno DESC, p0_.titulo ASC;

SELECT
  c0_.id AS id_0,
  c0_.nombre_corto AS nombre_corto_1,
  c0_.nombre AS nombre_2,
  c0_.web AS web_3,
  c0_.prensa AS prensa_4,
  c0_.seccion_id AS seccion_id_5
FROM
  categorias c0_
  INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id
WHERE
  c0_.web = 1
  AND s1_.slug = ?

SELECT c0_.id AS id_0, c0_.nombre_corto AS nombre_corto_1, c0_.nombre AS nombre_2, c0_.web AS web_3, c0_.prensa AS prensa_4, c0_.seccion_id AS seccion_id_5 FROM categorias c0_ INNER JOIN seccion s1_ ON c0_.seccion_id = s1_.id WHERE c0_.web = 1 AND s1_.slug = 'distribucion';

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 262 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 281 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 292 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 279 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 269 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 270 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 263 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 258 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 255 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 287 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 265 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 247 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 240 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 272 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 274 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.cartel AS cartel_2, t0.descripcion AS descripcion_3, t0.principal AS principal_4, t0.press AS press_5, t0.pelicula_id AS pelicula_id_6 FROM peliculas_carteles t0 WHERE t0.pelicula_id = 261 ORDER BY t0.principal DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.cartel AS cartel_2,
  t0.descripcion AS descripcion_3,
  t0.principal AS principal_4,
  t0.press AS press_5,
  t0.pelicula_id AS pelicula_id_6
FROM
  peliculas_carteles t0
WHERE
  t0.pelicula_id = ?
ORDER BY
  t0.principal DESC,
  t0.id ASC