Symfony Profiler

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;

SELECT
  f0_.title AS title_0,
  v1_.slug AS slug_1,
  f2_.title AS title_2,
  f0_.slug AS slug_3,
  c3_.slug AS slug_4,
  a4_.slug AS slug_5
FROM
  free_activity_notion f0_
  INNER JOIN free_notion f2_ ON f0_.notion_id = f2_.id
  INNER JOIN library l5_ ON f2_.library_id = l5_.id
  INNER JOIN Course c3_ ON l5_.course_id = c3_.id
  INNER JOIN admin_discipline a4_ ON l5_.disciplines_id = a4_.id
  LEFT JOIN Video v1_ ON f0_.video_id = v1_.id
WHERE
  l5_.id = ?
  AND (
    f0_.`online` = 1
    AND f2_.`online` = 1
    AND l5_.`online` = 1
  )

SELECT f0_.title AS title_0, v1_.slug AS slug_1, f2_.title AS title_2, f0_.slug AS slug_3, c3_.slug AS slug_4, a4_.slug AS slug_5 FROM free_activity_notion f0_ INNER JOIN free_notion f2_ ON f0_.notion_id = f2_.id INNER JOIN library l5_ ON f2_.library_id = l5_.id INNER JOIN Course c3_ ON l5_.course_id = c3_.id INNER JOIN admin_discipline a4_ ON l5_.disciplines_id = a4_.id LEFT JOIN Video v1_ ON f0_.video_id = v1_.id WHERE l5_.id = 72 AND (f0_.`online` = 1 AND f2_.`online` = 1 AND l5_.`online` = 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 = ?
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
  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;