Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.slug AS slug_2,
  m0_.legacy_id AS legacy_id_3,
  m0_.aebn_id AS aebn_id_4,
  m0_.description AS description_5,
  m0_.audience AS audience_6,
  m0_.release_date AS release_date_7,
  m0_.runtime_minutes AS runtime_minutes_8,
  m0_.active AS active_9
FROM
  movies m0_
WHERE
  m0_.active = 1
  AND m0_.audience IN (?, ?)
ORDER BY
  m0_.release_date DESC,
  m0_.id DESC
LIMIT
  48

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.slug AS slug_2, m0_.legacy_id AS legacy_id_3, m0_.aebn_id AS aebn_id_4, m0_.description AS description_5, m0_.audience AS audience_6, m0_.release_date AS release_date_7, m0_.runtime_minutes AS runtime_minutes_8, m0_.active AS active_9 FROM movies m0_ WHERE m0_.active = 1 AND m0_.audience IN ('gay', 'both') ORDER BY m0_.release_date DESC, m0_.id DESC LIMIT 48;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.legacy_id AS legacy_id_4,
  t0.audience AS audience_5,
  t0.url AS url_6,
  t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7,
  t0.active AS active_8
FROM
  studios t0
  INNER JOIN movie_studios ON t0.id = movie_studios.studio_id
WHERE
  movie_studios.movie_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legacy_id AS legacy_id_4, t0.audience AS audience_5, t0.url AS url_6, t0.affiliate_site_legacy_id AS affiliate_site_legacy_id_7, t0.active AS active_8 FROM studios t0 INNER JOIN movie_studios ON t0.id = movie_studios.studio_id WHERE movie_studios.movie_id = 10;