Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.slug AS slug_2,
  s0_.description AS description_3,
  s0_.audience AS audience_4,
  s0_.duration_seconds AS duration_seconds_5,
  s0_.release_date AS release_date_6,
  s0_.active AS active_7,
  s0_.studio_id AS studio_id_8
FROM
  scenes s0_
WHERE
  s0_.active = 1
  AND s0_.audience IN (?, ?)
ORDER BY
  s0_.release_date DESC,
  s0_.id DESC
LIMIT
  24

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.description AS description_3, s0_.audience AS audience_4, s0_.duration_seconds AS duration_seconds_5, s0_.release_date AS release_date_6, s0_.active AS active_7, s0_.studio_id AS studio_id_8 FROM scenes s0_ WHERE s0_.active = 1 AND s0_.audience IN ('gay', 'both') ORDER BY s0_.release_date DESC, s0_.id DESC LIMIT 24;

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
  24

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 24;

SELECT
  p0_.id AS id_0,
  p0_.main_name AS main_name_1,
  p0_.slug AS slug_2,
  p0_.legacy_id AS legacy_id_3,
  p0_.audience AS audience_4,
  p0_.birth_date AS birth_date_5,
  p0_.height AS height_6,
  p0_.weight AS weight_7,
  p0_.hair AS hair_8,
  p0_.eyes AS eyes_9,
  p0_.ethnicity AS ethnicity_10,
  p0_.biography AS biography_11,
  p0_.gender AS gender_12,
  p0_.twitter AS twitter_13,
  p0_.flirt4free AS flirt4free_14,
  p0_.chaturbate AS chaturbate_15,
  p0_.active AS active_16
FROM
  performers p0_
WHERE
  p0_.active = 1
  AND p0_.audience IN (?, ?)
ORDER BY
  p0_.main_name ASC
LIMIT
  12

SELECT p0_.id AS id_0, p0_.main_name AS main_name_1, p0_.slug AS slug_2, p0_.legacy_id AS legacy_id_3, p0_.audience AS audience_4, p0_.birth_date AS birth_date_5, p0_.height AS height_6, p0_.weight AS weight_7, p0_.hair AS hair_8, p0_.eyes AS eyes_9, p0_.ethnicity AS ethnicity_10, p0_.biography AS biography_11, p0_.gender AS gender_12, p0_.twitter AS twitter_13, p0_.flirt4free AS flirt4free_14, p0_.chaturbate AS chaturbate_15, p0_.active AS active_16 FROM performers p0_ WHERE p0_.active = 1 AND p0_.audience IN ('gay', 'both') ORDER BY p0_.main_name ASC LIMIT 12;

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;