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 = 'terminale' AND l2_.`online` = 1 ORDER BY c1_.order ASC, l2_.position ASC;

SELECT
  f0_.id AS id_0,
  f0_.title AS title_1,
  f0_.slug AS slug_2,
  f0_.link AS link_3,
  f0_.content AS content_4,
  f0_.`online` AS online_5,
  f0_.position AS position_6,
  f0_.metadescription AS metadescription_7,
  f0_.created AS created_8,
  f0_.updated AS updated_9,
  f0_.video_id AS video_id_10,
  f0_.notion_id AS notion_id_11
FROM
  free_activity_notion f0_
  INNER JOIN free_notion f1_ ON f0_.notion_id = f1_.id
  INNER JOIN library l2_ ON f1_.library_id = l2_.id
  INNER JOIN Course c3_ ON l2_.course_id = c3_.id
  INNER JOIN admin_discipline a4_ ON l2_.disciplines_id = a4_.id
WHERE
  f0_.slug = ?
  AND c3_.slug = ?
  AND a4_.slug = ?

SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.slug AS slug_2, f0_.link AS link_3, f0_.content AS content_4, f0_.`online` AS online_5, f0_.position AS position_6, f0_.metadescription AS metadescription_7, f0_.created AS created_8, f0_.updated AS updated_9, f0_.video_id AS video_id_10, f0_.notion_id AS notion_id_11 FROM free_activity_notion f0_ INNER JOIN free_notion f1_ ON f0_.notion_id = f1_.id INNER JOIN library l2_ ON f1_.library_id = l2_.id INNER JOIN Course c3_ ON l2_.course_id = c3_.id INNER JOIN admin_discipline a4_ ON l2_.disciplines_id = a4_.id WHERE f0_.slug = 'evolution-genetique-des-populations-492' AND c3_.slug = 'terminale' AND a4_.slug = 'sciences';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.`online` AS online_4,
  t0.position AS position_5,
  t0.metadescription AS metadescription_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.library_id AS library_id_9
FROM
  free_notion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.`online` AS online_4, t0.position AS position_5, t0.metadescription AS metadescription_6, t0.created AS created_7, t0.updated AS updated_8, t0.library_id AS library_id_9 FROM free_notion t0 WHERE t0.id = 85;

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.content AS content_3,
  t0.`online` AS online_4,
  t0.position AS position_5,
  t0.metadescription AS metadescription_6,
  t0.created AS created_7,
  t0.updated AS updated_8,
  t0.course_id AS course_id_9,
  t0.disciplines_id AS disciplines_id_10
FROM
  library t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.`online` AS online_4, t0.position AS position_5, t0.metadescription AS metadescription_6, t0.created AS created_7, t0.updated AS updated_8, t0.course_id AS course_id_9, t0.disciplines_id AS disciplines_id_10 FROM library t0 WHERE t0.id = 20;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.vimeo_file AS vimeo_file_3,
  t0.video_id AS video_id_4,
  t0.vimeo_id AS vimeo_id_5,
  t0.picture AS picture_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.position AS position_9,
  t0.duration AS duration_10,
  t0.poster AS poster_11,
  t0.picture_mobile_id AS picture_mobile_id_12,
  t0.visible_for_all AS visible_for_all_13,
  t0.answers_question AS answers_question_14,
  t0.resume AS resume_15,
  t0.title_youtube AS title_youtube_16,
  t0.published AS published_17,
  t0.weight AS weight_18,
  t0.caption AS caption_19,
  t0.slug AS slug_20,
  t0.duration_youtube AS duration_youtube_21,
  t0.publish_date_youtube AS publish_date_youtube_22,
  t0.meta_description AS meta_description_23,
  t0.transcript AS transcript_24,
  t0.transcript_auto AS transcript_auto_25,
  t0.link_kumulus AS link_kumulus_26,
  t0.created AS created_27,
  t0.updated AS updated_28
FROM
  Video t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.vimeo_file AS vimeo_file_3, t0.video_id AS video_id_4, t0.vimeo_id AS vimeo_id_5, t0.picture AS picture_6, t0.title AS title_7, t0.description AS description_8, t0.position AS position_9, t0.duration AS duration_10, t0.poster AS poster_11, t0.picture_mobile_id AS picture_mobile_id_12, t0.visible_for_all AS visible_for_all_13, t0.answers_question AS answers_question_14, t0.resume AS resume_15, t0.title_youtube AS title_youtube_16, t0.published AS published_17, t0.weight AS weight_18, t0.caption AS caption_19, t0.slug AS slug_20, t0.duration_youtube AS duration_youtube_21, t0.publish_date_youtube AS publish_date_youtube_22, t0.meta_description AS meta_description_23, t0.transcript AS transcript_24, t0.transcript_auto AS transcript_auto_25, t0.link_kumulus AS link_kumulus_26, t0.created AS created_27, t0.updated AS updated_28 FROM Video t0 WHERE t0.id = 3302;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.lesson_title AS lesson_title_3,
  t0.slug AS slug_4,
  t0.slug_lesson AS slug_lesson_5,
  t0.front AS front_6,
  t0.order AS order_7,
  t0.speciality AS speciality_8,
  t0.exam AS exam_9,
  t0.main_color AS main_color_10,
  t0.gradient_color AS gradient_color_11,
  t0.published AS published_12,
  t0.color AS color_13,
  t0.style AS style_14
FROM
  admin_discipline t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.lesson_title AS lesson_title_3, t0.slug AS slug_4, t0.slug_lesson AS slug_lesson_5, t0.front AS front_6, t0.order AS order_7, t0.speciality AS speciality_8, t0.exam AS exam_9, t0.main_color AS main_color_10, t0.gradient_color AS gradient_color_11, t0.published AS published_12, t0.color AS color_13, t0.style AS style_14 FROM admin_discipline t0 WHERE t0.id = 10;

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 = 'terminale' LIMIT 1;