Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.title AS title_2
FROM
  Course c0_
WHERE
  c0_.front = 1
ORDER BY
  c0_.order ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.title AS title_2 FROM Course c0_ WHERE c0_.front = 1 ORDER BY c0_.order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.front AS front_4,
  t0.order AS order_5,
  t0.description AS description_6,
  t0.metadescription AS metadescription_7
FROM
  Course t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.front AS front_4, t0.order AS order_5, t0.description AS description_6, t0.metadescription AS metadescription_7 FROM Course t0 WHERE t0.slug = 'troisieme' LIMIT 1;

SELECT
  CASE WHEN a0_.lesson_title IS NOT NULL THEN
    a0_.lesson_title
  ELSE
    a0_.title
  END AS sclr_0,
  a0_.id AS id_1,
  a0_.slug AS slug_2,
  c1_.title AS title_3,
  c1_.id AS id_4,
  l2_.id AS id_5,
  l2_.`online` AS online_6,
  l2_.metadescription AS metadescription_7,
  l2_.content AS content_8,
  l2_.title AS title_9
FROM
  library l2_
  INNER JOIN Course c1_ ON l2_.course_id = c1_.id
  INNER JOIN admin_discipline a0_ ON l2_.disciplines_id = a0_.id
WHERE
  c1_.slug = ?
  AND l2_.`online` = 1
ORDER BY
  c1_.order ASC,
  l2_.position ASC

SELECT CASE WHEN a0_.lesson_title IS NOT NULL THEN a0_.lesson_title ELSE a0_.title END AS sclr_0, a0_.id AS id_1, a0_.slug AS slug_2, c1_.title AS title_3, c1_.id AS id_4, l2_.id AS id_5, l2_.`online` AS online_6, l2_.metadescription AS metadescription_7, l2_.content AS content_8, l2_.title AS title_9 FROM library l2_ INNER JOIN Course c1_ ON l2_.course_id = c1_.id INNER JOIN admin_discipline a0_ ON l2_.disciplines_id = a0_.id WHERE c1_.slug = 'troisieme' AND l2_.`online` = 1 ORDER BY c1_.order ASC, l2_.position ASC;