Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.out_slug AS out_slug_3,
  c0_.active AS active_4,
  c0_.sort_order AS sort_order_5,
  c0_.featured AS featured_6,
  c0_.short_description AS short_description_7,
  c0_.description AS description_8
FROM
  category c0_
WHERE
  c0_.featured = 1
ORDER BY
  c0_.sort_order ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.out_slug AS out_slug_3, c0_.active AS active_4, c0_.sort_order AS sort_order_5, c0_.featured AS featured_6, c0_.short_description AS short_description_7, c0_.description AS description_8 FROM category c0_ WHERE c0_.featured = 1 ORDER BY c0_.sort_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.out_slug AS out_slug_3,
  c0_.active AS active_4,
  c0_.sort_order AS sort_order_5,
  c0_.featured AS featured_6,
  c0_.short_description AS short_description_7,
  c0_.description AS description_8,
  CASE WHEN SUBSTRING(
    c0_.name
    FROM
      1 FOR 1
  ) BETWEEN '0'
  AND '9' THEN
    '#'
  ELSE
    UPPER(
      SUBSTRING(
        c0_.name
        FROM
          1 FOR 1
      )
    )
  END AS sclr_9
FROM
  category c0_
WHERE
  c0_.active = ?
ORDER BY
  sclr_9 ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.out_slug AS out_slug_3, c0_.active AS active_4, c0_.sort_order AS sort_order_5, c0_.featured AS featured_6, c0_.short_description AS short_description_7, c0_.description AS description_8, CASE WHEN SUBSTRING(c0_.name FROM 1 FOR 1) BETWEEN '0' AND '9' THEN '#' ELSE UPPER(SUBSTRING(c0_.name FROM 1 FOR 1)) END AS sclr_9 FROM category c0_ WHERE c0_.active = 1 ORDER BY sclr_9 ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 22;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 93;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 40;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 94;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 63;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 24;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 43;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 35;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 56;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.out_slug AS out_slug_4,
  t0.active AS active_5,
  t0.release_date AS release_date_6,
  t0.duration AS duration_7,
  t0.fps AS fps_8,
  t0.angle AS angle_9,
  t0.resolution AS resolution_10,
  t0.sound AS sound_11,
  t0.description AS description_12,
  t0.studio_id AS studio_id_13
FROM
  video t0
  INNER JOIN video_category ON t0.id = video_category.video_id
WHERE
  video_category.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.out_slug AS out_slug_4, t0.active AS active_5, t0.release_date AS release_date_6, t0.duration AS duration_7, t0.fps AS fps_8, t0.angle AS angle_9, t0.resolution AS resolution_10, t0.sound AS sound_11, t0.description AS description_12, t0.studio_id AS studio_id_13 FROM video t0 INNER JOIN video_category ON t0.id = video_category.video_id WHERE video_category.category_id = 110;