Symfony Profiler

SELECT
  t1.id AS id_2,
  t1.price AS price_3,
  t0.module AS module_4,
  t1.dtype
FROM
  module_product t0
  INNER JOIN product t1 ON t0.id = t1.id
WHERE
  t0.module = ?

SELECT t1.id AS id_2, t1.price AS price_3, t0.module AS module_4, t1.dtype FROM module_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.module = '98b18e99-6449-11ef-a99a-0242c0a84006';

SELECT
  t0.id AS id_3,
  t0.lesson_id AS lesson_id_4,
  t0.dtype,
  t1.name AS name_5,
  t1.body AS body_6,
  t1.sort_order AS sort_order_7,
  t1.description AS description_8,
  t2.lock_by_id AS lock_by_id_9
FROM
  scholar_chapters t0
  LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id
WHERE
  t0.lesson_id = ?

SELECT t0.id AS id_3, t0.lesson_id AS lesson_id_4, t0.dtype, t1.name AS name_5, t1.body AS body_6, t1.sort_order AS sort_order_7, t1.description AS description_8, t2.lock_by_id AS lock_by_id_9 FROM scholar_chapters t0 LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id WHERE t0.lesson_id = '98af3749-6449-11ef-a99a-0242c0a84006';

SELECT
  t0.id AS id_3,
  t0.lesson_id AS lesson_id_4,
  t0.dtype,
  t1.name AS name_5,
  t1.body AS body_6,
  t1.sort_order AS sort_order_7,
  t1.description AS description_8,
  t2.lock_by_id AS lock_by_id_9
FROM
  scholar_chapters t0
  LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.lesson_id AS lesson_id_4, t0.dtype, t1.name AS name_5, t1.body AS body_6, t1.sort_order AS sort_order_7, t1.description AS description_8, t2.lock_by_id AS lock_by_id_9 FROM scholar_chapters t0 LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id WHERE t0.id = '62062';

SELECT
  t0.id AS id_3,
  t0.is_blocked AS is_blocked_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.owner_channel_id AS owner_channel_id_7,
  t0.dtype,
  t1.name AS name_8,
  t1.description AS description_9,
  t1.public AS public_10,
  t1.status AS status_11,
  t1.image_id AS image_id_12,
  t2.lock_by_status AS lock_by_status_13,
  t2.lock_by_id AS lock_by_id_14
FROM
  scholar_modules t0
  LEFT JOIN scholar_origin_modules t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_modules t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.is_blocked AS is_blocked_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.owner_channel_id AS owner_channel_id_7, t0.dtype, t1.name AS name_8, t1.description AS description_9, t1.public AS public_10, t1.status AS status_11, t1.image_id AS image_id_12, t2.lock_by_status AS lock_by_status_13, t2.lock_by_id AS lock_by_id_14 FROM scholar_modules t0 LEFT JOIN scholar_origin_modules t1 ON t0.id = t1.id LEFT JOIN scholar_shared_modules t2 ON t0.id = t2.id WHERE t0.id = '98b18e99-6449-11ef-a99a-0242c0a84006';

SELECT
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.stat_avg_score AS stat_avg_score_6,
  t0.stat_avg_time AS stat_avg_time_7,
  t0.stat_median_score AS stat_median_score_8,
  t0.stat_median_time AS stat_median_time_9,
  t0.stat_total_score AS stat_total_score_10,
  t0.stat_total_time AS stat_total_time_11,
  t0.stat_total_done AS stat_total_done_12,
  t0.stat_score_distribution AS stat_score_distribution_13,
  t0.stat_time_distribution AS stat_time_distribution_14,
  t0.lesson_id AS lesson_id_15,
  t0.dtype,
  t1.name AS name_16,
  t1.description AS description_17,
  t1.sort_order AS sort_order_18,
  t2.lock_by_id AS lock_by_id_19
FROM
  exercise_exercises t0
  LEFT JOIN scholar_origin_exercises t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_exercises t2 ON t0.id = t2.id
WHERE
  t0.lesson_id = ?

SELECT t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stat_avg_score AS stat_avg_score_6, t0.stat_avg_time AS stat_avg_time_7, t0.stat_median_score AS stat_median_score_8, t0.stat_median_time AS stat_median_time_9, t0.stat_total_score AS stat_total_score_10, t0.stat_total_time AS stat_total_time_11, t0.stat_total_done AS stat_total_done_12, t0.stat_score_distribution AS stat_score_distribution_13, t0.stat_time_distribution AS stat_time_distribution_14, t0.lesson_id AS lesson_id_15, t0.dtype, t1.name AS name_16, t1.description AS description_17, t1.sort_order AS sort_order_18, t2.lock_by_id AS lock_by_id_19 FROM exercise_exercises t0 LEFT JOIN scholar_origin_exercises t1 ON t0.id = t1.id LEFT JOIN scholar_shared_exercises t2 ON t0.id = t2.id WHERE t0.lesson_id = '98af3749-6449-11ef-a99a-0242c0a84006';

SELECT
  t1.id AS id_2,
  t1.is_blocked AS is_blocked_3,
  t1.created_at AS created_at_4,
  t1.updated_at AS updated_at_5,
  t0.name AS name_6,
  t0.description AS description_7,
  t0.public AS public_8,
  t0.status AS status_9,
  t1.owner_channel_id AS owner_channel_id_10,
  t0.image_id AS image_id_11,
  t1.dtype
FROM
  scholar_origin_modules t0
  INNER JOIN scholar_modules t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.is_blocked AS is_blocked_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t0.name AS name_6, t0.description AS description_7, t0.public AS public_8, t0.status AS status_9, t1.owner_channel_id AS owner_channel_id_10, t0.image_id AS image_id_11, t1.dtype FROM scholar_origin_modules t0 INNER JOIN scholar_modules t1 ON t0.id = t1.id WHERE t1.id = '3755e587-4852-11ef-9bb3-0242c0a88004';

SELECT
  t0.id AS id_3,
  t0.ask_for_referent_correction AS ask_for_referent_correction_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.lesson_id AS lesson_id_7,
  t0.dtype,
  t1.title AS title_8,
  t1.content AS content_9,
  t1.remark AS remark_10,
  t1.estimate_time AS estimate_time_11,
  t1.correction AS correction_12,
  t1.is_archived AS is_archived_13,
  t2.lock_by_id AS lock_by_id_14
FROM
  practical_case t0
  LEFT JOIN scholar_origin_practical_cases t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_practical_cases t2 ON t0.id = t2.id
WHERE
  t0.lesson_id = ?

SELECT t0.id AS id_3, t0.ask_for_referent_correction AS ask_for_referent_correction_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.lesson_id AS lesson_id_7, t0.dtype, t1.title AS title_8, t1.content AS content_9, t1.remark AS remark_10, t1.estimate_time AS estimate_time_11, t1.correction AS correction_12, t1.is_archived AS is_archived_13, t2.lock_by_id AS lock_by_id_14 FROM practical_case t0 LEFT JOIN scholar_origin_practical_cases t1 ON t0.id = t1.id LEFT JOIN scholar_shared_practical_cases t2 ON t0.id = t2.id WHERE t0.lesson_id = '98af3749-6449-11ef-a99a-0242c0a84006';

SELECT
  t0.id AS id_3,
  t0.lesson_id AS lesson_id_4,
  t0.dtype,
  t1.name AS name_5,
  t1.body AS body_6,
  t1.sort_order AS sort_order_7,
  t1.description AS description_8,
  t2.lock_by_id AS lock_by_id_9
FROM
  scholar_chapters t0
  LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_3, t0.lesson_id AS lesson_id_4, t0.dtype, t1.name AS name_5, t1.body AS body_6, t1.sort_order AS sort_order_7, t1.description AS description_8, t2.lock_by_id AS lock_by_id_9 FROM scholar_chapters t0 LEFT JOIN scholar_origin_chapters t1 ON t0.id = t1.id LEFT JOIN scholar_shared_chapters t2 ON t0.id = t2.id WHERE t0.id IN (44359, 44360, 44361, 44362, 44363, 44364, 44365, 44367);

SELECT
  a0_.id AS id_0,
  a0_.assignable_status AS assignable_status_1,
  a0_.created_at AS created_at_2,
  a0_.updated_at AS updated_at_3,
  f1_.content AS content_4,
  a0_.d_type AS d_type_5,
  a0_.assigned_to_id AS assigned_to_id_6,
  f1_.chapter_id AS chapter_id_7,
  f1_.training_id AS training_id_8,
  f1_.module_id AS module_id_9,
  f1_.user_id AS user_id_10,
  f1_.parent_id AS parent_id_11
FROM
  forum_chapter_message f1_
  INNER JOIN assignable a0_ ON f1_.id = a0_.id
  INNER JOIN scholar_chapters s2_ ON f1_.chapter_id = s2_.id
  LEFT JOIN scholar_origin_chapters s3_ ON s2_.id = s3_.id
  LEFT JOIN scholar_shared_chapters s4_ ON s2_.id = s4_.id
WHERE
  s2_.id = ?
  AND f1_.parent_id IS NULL
ORDER BY
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.assignable_status AS assignable_status_1, a0_.created_at AS created_at_2, a0_.updated_at AS updated_at_3, f1_.content AS content_4, a0_.d_type AS d_type_5, a0_.assigned_to_id AS assigned_to_id_6, f1_.chapter_id AS chapter_id_7, f1_.training_id AS training_id_8, f1_.module_id AS module_id_9, f1_.user_id AS user_id_10, f1_.parent_id AS parent_id_11 FROM forum_chapter_message f1_ INNER JOIN assignable a0_ ON f1_.id = a0_.id INNER JOIN scholar_chapters s2_ ON f1_.chapter_id = s2_.id LEFT JOIN scholar_origin_chapters s3_ ON s2_.id = s3_.id LEFT JOIN scholar_shared_chapters s4_ ON s2_.id = s4_.id WHERE s2_.id = 62062 AND f1_.parent_id IS NULL ORDER BY a0_.created_at ASC;

SELECT
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.stat_avg_score AS stat_avg_score_6,
  t0.stat_avg_time AS stat_avg_time_7,
  t0.stat_median_score AS stat_median_score_8,
  t0.stat_median_time AS stat_median_time_9,
  t0.stat_total_score AS stat_total_score_10,
  t0.stat_total_time AS stat_total_time_11,
  t0.stat_total_done AS stat_total_done_12,
  t0.stat_score_distribution AS stat_score_distribution_13,
  t0.stat_time_distribution AS stat_time_distribution_14,
  t0.lesson_id AS lesson_id_15,
  t0.dtype,
  t1.name AS name_16,
  t1.description AS description_17,
  t1.sort_order AS sort_order_18,
  t2.lock_by_id AS lock_by_id_19
FROM
  exercise_exercises t0
  LEFT JOIN scholar_origin_exercises t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_exercises t2 ON t0.id = t2.id
WHERE
  t0.id IN (?)

SELECT t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.stat_avg_score AS stat_avg_score_6, t0.stat_avg_time AS stat_avg_time_7, t0.stat_median_score AS stat_median_score_8, t0.stat_median_time AS stat_median_time_9, t0.stat_total_score AS stat_total_score_10, t0.stat_total_time AS stat_total_time_11, t0.stat_total_done AS stat_total_done_12, t0.stat_score_distribution AS stat_score_distribution_13, t0.stat_time_distribution AS stat_time_distribution_14, t0.lesson_id AS lesson_id_15, t0.dtype, t1.name AS name_16, t1.description AS description_17, t1.sort_order AS sort_order_18, t2.lock_by_id AS lock_by_id_19 FROM exercise_exercises t0 LEFT JOIN scholar_origin_exercises t1 ON t0.id = t1.id LEFT JOIN scholar_shared_exercises t2 ON t0.id = t2.id WHERE t0.id IN ('3fd8b517-4852-11ef-9bb3-0242c0a88004');

SELECT
  t0.id AS id_2,
  t0.total_hour_description AS total_hour_description_3,
  t0.video_description AS video_description_4,
  t0.diploma_description AS diploma_description_5,
  t0.training_type AS training_type_6,
  t0.thematic AS thematic_7,
  t0.diploma AS diploma_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.name AS name_11,
  t0.description AS description_12,
  t0.public AS public_13,
  t0.status AS status_14,
  t0.image_id AS image_id_15,
  t0.owner_channel_id AS owner_channel_id_16,
  t0.dtype,
  t1.lock_by_status AS lock_by_status_17,
  t1.lock_by_id AS lock_by_id_18
FROM
  scholar_trainings t0
  LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.total_hour_description AS total_hour_description_3, t0.video_description AS video_description_4, t0.diploma_description AS diploma_description_5, t0.training_type AS training_type_6, t0.thematic AS thematic_7, t0.diploma AS diploma_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.name AS name_11, t0.description AS description_12, t0.public AS public_13, t0.status AS status_14, t0.image_id AS image_id_15, t0.owner_channel_id AS owner_channel_id_16, t0.dtype, t1.lock_by_status AS lock_by_status_17, t1.lock_by_id AS lock_by_id_18 FROM scholar_trainings t0 LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id WHERE t0.id = '9986ccdd-6449-11ef-a99a-0242c0a84006';

SELECT
  t1.id AS id_2,
  t1.price AS price_3,
  t0.lesson AS lesson_4,
  t1.dtype
FROM
  lesson_product t0
  INNER JOIN product t1 ON t0.id = t1.id
WHERE
  t0.lesson = ?

SELECT t1.id AS id_2, t1.price AS price_3, t0.lesson AS lesson_4, t1.dtype FROM lesson_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.lesson = '98af3749-6449-11ef-a99a-0242c0a84006';

SELECT
  t1.id AS id_2,
  t0.name AS name_3,
  t0.body AS body_4,
  t0.sort_order AS sort_order_5,
  t0.description AS description_6,
  t1.lesson_id AS lesson_id_7,
  t1.dtype
FROM
  scholar_origin_chapters t0
  INNER JOIN scholar_chapters t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t0.name AS name_3, t0.body AS body_4, t0.sort_order AS sort_order_5, t0.description AS description_6, t1.lesson_id AS lesson_id_7, t1.dtype FROM scholar_origin_chapters t0 INNER JOIN scholar_chapters t1 ON t0.id = t1.id WHERE t1.id = 44366;

SELECT
  t1.id AS id_2,
  t1.price AS price_3,
  t0.training AS training_4,
  t1.dtype
FROM
  training_product t0
  INNER JOIN product t1 ON t0.id = t1.id
WHERE
  t0.training = ?

SELECT t1.id AS id_2, t1.price AS price_3, t0.training AS training_4, t1.dtype FROM training_product t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.training = '9986ccdd-6449-11ef-a99a-0242c0a84006';

SELECT
  t1.id AS id_2,
  t1.minimum_time AS minimum_time_3,
  t1.lesson_review_activated AS lesson_review_activated_4,
  t1.created_at AS created_at_5,
  t1.updated_at AS updated_at_6,
  t1.status AS status_7,
  t0.ref AS ref_8,
  t0.objective AS objective_9,
  t0.name AS name_10,
  t0.description AS description_11,
  t0.public AS public_12,
  t1.referral_trainer_id AS referral_trainer_id_13,
  t1.lesson_stats_id AS lesson_stats_id_14,
  t1.owner_channel_id AS owner_channel_id_15,
  t0.image_id AS image_id_16,
  t1.dtype
FROM
  scholar_origin_lessons t0
  INNER JOIN scholar_lessons t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.minimum_time AS minimum_time_3, t1.lesson_review_activated AS lesson_review_activated_4, t1.created_at AS created_at_5, t1.updated_at AS updated_at_6, t1.status AS status_7, t0.ref AS ref_8, t0.objective AS objective_9, t0.name AS name_10, t0.description AS description_11, t0.public AS public_12, t1.referral_trainer_id AS referral_trainer_id_13, t1.lesson_stats_id AS lesson_stats_id_14, t1.owner_channel_id AS owner_channel_id_15, t0.image_id AS image_id_16, t1.dtype FROM scholar_origin_lessons t0 INNER JOIN scholar_lessons t1 ON t0.id = t1.id WHERE t1.id = '376f6101-4852-11ef-9bb3-0242c0a88004';

SELECT
  t0.id AS id_3,
  t0.minimum_time AS minimum_time_4,
  t0.lesson_review_activated AS lesson_review_activated_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.status AS status_8,
  t0.referral_trainer_id AS referral_trainer_id_9,
  t0.lesson_stats_id AS lesson_stats_id_10,
  t0.owner_channel_id AS owner_channel_id_11,
  t0.dtype,
  t1.ref AS ref_12,
  t1.objective AS objective_13,
  t1.name AS name_14,
  t1.description AS description_15,
  t1.public AS public_16,
  t1.image_id AS image_id_17,
  t2.lock_by_status AS lock_by_status_18,
  t2.lock_by_id AS lock_by_id_19
FROM
  scholar_lessons t0
  LEFT JOIN scholar_origin_lessons t1 ON t0.id = t1.id
  LEFT JOIN scholar_shared_lessons t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.minimum_time AS minimum_time_4, t0.lesson_review_activated AS lesson_review_activated_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.status AS status_8, t0.referral_trainer_id AS referral_trainer_id_9, t0.lesson_stats_id AS lesson_stats_id_10, t0.owner_channel_id AS owner_channel_id_11, t0.dtype, t1.ref AS ref_12, t1.objective AS objective_13, t1.name AS name_14, t1.description AS description_15, t1.public AS public_16, t1.image_id AS image_id_17, t2.lock_by_status AS lock_by_status_18, t2.lock_by_id AS lock_by_id_19 FROM scholar_lessons t0 LEFT JOIN scholar_origin_lessons t1 ON t0.id = t1.id LEFT JOIN scholar_shared_lessons t2 ON t0.id = t2.id WHERE t0.id = '98af3749-6449-11ef-a99a-0242c0a84006';

SELECT
  t1.id AS id_2,
  t1.assignable_status AS assignable_status_3,
  t1.created_at AS created_at_4,
  t1.updated_at AS updated_at_5,
  t0.content AS content_6,
  t1.assigned_to_id AS assigned_to_id_7,
  t0.chapter_id AS chapter_id_8,
  t0.training_id AS training_id_9,
  t0.module_id AS module_id_10,
  t0.user_id AS user_id_11,
  t0.parent_id AS parent_id_12,
  t1.d_type
FROM
  forum_chapter_message t0
  INNER JOIN assignable t1 ON t0.id = t1.id
WHERE
  t0.chapter_id = ?

SELECT t1.id AS id_2, t1.assignable_status AS assignable_status_3, t1.created_at AS created_at_4, t1.updated_at AS updated_at_5, t0.content AS content_6, t1.assigned_to_id AS assigned_to_id_7, t0.chapter_id AS chapter_id_8, t0.training_id AS training_id_9, t0.module_id AS module_id_10, t0.user_id AS user_id_11, t0.parent_id AS parent_id_12, t1.d_type FROM forum_chapter_message t0 INNER JOIN assignable t1 ON t0.id = t1.id WHERE t0.chapter_id = 62062;

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.lock_by_status AS lock_by_status_3,
  t0.module_id AS module_id_4,
  t0.training_id AS training_id_5,
  t0.lock_by_id AS lock_by_id_6
FROM
  scholar_training_modules t0
WHERE
  t0.training_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.lock_by_status AS lock_by_status_3, t0.module_id AS module_id_4, t0.training_id AS training_id_5, t0.lock_by_id AS lock_by_id_6 FROM scholar_training_modules t0 WHERE t0.training_id = '9986ccdd-6449-11ef-a99a-0242c0a84006' ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.in_footer AS in_footer_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  template_template_page t0
WHERE
  t0.in_footer = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.in_footer AS in_footer_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM template_template_page t0 WHERE t0.in_footer = 1;

SELECT
  t0.id AS id_1,
  t0.sort_order AS sort_order_2,
  t0.lock_by_status AS lock_by_status_3,
  t0.lesson_id AS lesson_id_4,
  t0.module_id AS module_id_5,
  t0.lock_by_id AS lock_by_id_6
FROM
  scholar_module_lessons t0
WHERE
  t0.module_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.sort_order AS sort_order_2, t0.lock_by_status AS lock_by_status_3, t0.lesson_id AS lesson_id_4, t0.module_id AS module_id_5, t0.lock_by_id AS lock_by_id_6 FROM scholar_module_lessons t0 WHERE t0.module_id = '98b18e99-6449-11ef-a99a-0242c0a84006' ORDER BY t0.sort_order ASC;