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_.codigo_cines AS codigo_cines_10,
  p0_.web AS web_11,
  p0_.facebook AS facebook_12,
  p0_.twitter AS twitter_13,
  p0_.instagram AS instagram_14,
  p0_.youtube AS youtube_15,
  p0_.dvd_link AS dvd_link_16,
  p0_.vod_link AS vod_link_17,
  p0_.destacada_web AS destacada_web_18,
  p0_.principal_prensa AS principal_prensa_19,
  p0_.destacada_prensa AS destacada_prensa_20,
  p0_.banner AS banner_21,
  p0_.listado AS listado_22,
  p0_.catalogo AS catalogo_23,
  p0_.catalogo_prensa AS catalogo_prensa_24,
  p0_.catalogo_prensa_orden AS catalogo_prensa_orden_25,
  p0_.activa AS activa_26,
  p0_.activa_prensa AS activa_prensa_27,
  p0_.destacado_orden AS destacado_orden_28,
  p0_.destacado_orden_prensa AS destacado_orden_prensa_29,
  p0_.catalogo_orden AS catalogo_orden_30,
  p0_.rodaje AS rodaje_31,
  c1_.id AS id_32,
  c1_.nombre_corto AS nombre_corto_33,
  c1_.nombre AS nombre_34,
  c1_.web AS web_35,
  c1_.prensa AS prensa_36,
  p0_.meta_id AS meta_id_37,
  p0_.estadoRodaje_id AS estadoRodaje_id_38,
  c1_.seccion_id AS seccion_id_39
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
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_.codigo_cines AS codigo_cines_10, p0_.web AS web_11, p0_.facebook AS facebook_12, p0_.twitter AS twitter_13, p0_.instagram AS instagram_14, p0_.youtube AS youtube_15, p0_.dvd_link AS dvd_link_16, p0_.vod_link AS vod_link_17, p0_.destacada_web AS destacada_web_18, p0_.principal_prensa AS principal_prensa_19, p0_.destacada_prensa AS destacada_prensa_20, p0_.banner AS banner_21, p0_.listado AS listado_22, p0_.catalogo AS catalogo_23, p0_.catalogo_prensa AS catalogo_prensa_24, p0_.catalogo_prensa_orden AS catalogo_prensa_orden_25, p0_.activa AS activa_26, p0_.activa_prensa AS activa_prensa_27, p0_.destacado_orden AS destacado_orden_28, p0_.destacado_orden_prensa AS destacado_orden_prensa_29, p0_.catalogo_orden AS catalogo_orden_30, p0_.rodaje AS rodaje_31, c1_.id AS id_32, c1_.nombre_corto AS nombre_corto_33, c1_.nombre AS nombre_34, c1_.web AS web_35, c1_.prensa AS prensa_36, p0_.meta_id AS meta_id_37, p0_.estadoRodaje_id AS estadoRodaje_id_38, c1_.seccion_id AS seccion_id_39 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 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 = 308 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 = 291 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 = 297 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 = 306 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 = 285 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 = 296 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 = 283 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 = 304 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 = 284 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 = 301 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 = 271 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 = 288 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 = 266 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 = 280 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 = 268 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 = 289 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