Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 1
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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 WHERE t0.slug = ? AND t0.active = ? LIMIT 1

[
  "mile-high-media"
  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
WHERE
  t0.slug = ?
  AND t0.active = ?
LIMIT
  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 WHERE t0.slug = 'mile-high-media' AND t0.active = 1 LIMIT 1;

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_ INNER JOIN movie_studios m2_ ON m0_.id = m2_.movie_id INNER JOIN studios s1_ ON s1_.id = m2_.studio_id WHERE m0_.active = 1 AND m0_.audience IN (?, ?) AND s1_.id = ? ORDER BY m0_.release_date DESC, m0_.id DESC LIMIT 48

[
  "gay"
  "both"
  6
]

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_
  INNER JOIN movie_studios m2_ ON m0_.id = m2_.movie_id
  INNER JOIN studios s1_ ON s1_.id = m2_.studio_id
WHERE
  m0_.active = 1
  AND m0_.audience IN (?, ?)
  AND s1_.id = ?
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_ INNER JOIN movie_studios m2_ ON m0_.id = m2_.movie_id INNER JOIN studios s1_ ON s1_.id = m2_.studio_id WHERE m0_.active = 1 AND m0_.audience IN ('gay', 'both') AND s1_.id = 6 ORDER BY m0_.release_date DESC, m0_.id DESC LIMIT 48;