Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.children_updated_at AS children_updated_at_2,
  t0.training_id AS training_id_3,
  t0.module_id AS module_id_4,
  t0.lesson_id AS lesson_id_5
FROM
  scholar_update_tracker t0
WHERE
  t0.module_id = ?

SELECT t0.id AS id_1, t0.children_updated_at AS children_updated_at_2, t0.training_id AS training_id_3, t0.module_id AS module_id_4, t0.lesson_id AS lesson_id_5 FROM scholar_update_tracker t0 WHERE t0.module_id = '47fc216c-a342-11ef-8ed8-0242c0a83005';

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 = '47fc216c-a342-11ef-8ed8-0242c0a83005';

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.from_api AS from_api_7,
  t0.owner_channel_id AS owner_channel_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10,
  t0.dtype,
  t1.name AS name_11,
  t1.description AS description_12,
  t1.public AS public_13,
  t1.status AS status_14,
  t1.image_id AS image_id_15,
  t1.duplicate_from_id AS duplicate_from_id_16,
  t2.lock_by_status AS lock_by_status_17,
  t2.lock_by_id AS lock_by_id_18,
  t2.target_channel_id AS target_channel_id_19
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.from_api AS from_api_7, t0.owner_channel_id AS owner_channel_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10, t0.dtype, t1.name AS name_11, t1.description AS description_12, t1.public AS public_13, t1.status AS status_14, t1.image_id AS image_id_15, t1.duplicate_from_id AS duplicate_from_id_16, t2.lock_by_status AS lock_by_status_17, t2.lock_by_id AS lock_by_id_18, t2.target_channel_id AS target_channel_id_19 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 = '47fc216c-a342-11ef-8ed8-0242c0a83005';

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,
  t1.from_api AS from_api_6,
  t0.name AS name_7,
  t0.description AS description_8,
  t0.public AS public_9,
  t0.status AS status_10,
  t1.owner_channel_id AS owner_channel_id_11,
  t1.created_by_id AS created_by_id_12,
  t1.updated_by_id AS updated_by_id_13,
  t0.image_id AS image_id_14,
  t0.duplicate_from_id AS duplicate_from_id_15,
  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, t1.from_api AS from_api_6, t0.name AS name_7, t0.description AS description_8, t0.public AS public_9, t0.status AS status_10, t1.owner_channel_id AS owner_channel_id_11, t1.created_by_id AS created_by_id_12, t1.updated_by_id AS updated_by_id_13, t0.image_id AS image_id_14, t0.duplicate_from_id AS duplicate_from_id_15, 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_1,
  t0.children_updated_at AS children_updated_at_2,
  t0.training_id AS training_id_3,
  t0.module_id AS module_id_4,
  t0.lesson_id AS lesson_id_5
FROM
  scholar_update_tracker t0
WHERE
  t0.lesson_id = ?

SELECT t0.id AS id_1, t0.children_updated_at AS children_updated_at_2, t0.training_id AS training_id_3, t0.module_id AS module_id_4, t0.lesson_id AS lesson_id_5 FROM scholar_update_tracker t0 WHERE t0.lesson_id = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

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 = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

SELECT
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.from_api AS from_api_6,
  t0.lesson_id AS lesson_id_7,
  t0.dtype,
  t1.name AS name_8,
  t1.body AS body_9,
  t1.sort_order AS sort_order_10,
  t1.description AS description_11,
  t1.indexed_content_id AS indexed_content_id_12,
  t2.lock_by_id AS lock_by_id_13
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.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.from_api AS from_api_6, t0.lesson_id AS lesson_id_7, t0.dtype, t1.name AS name_8, t1.body AS body_9, t1.sort_order AS sort_order_10, t1.description AS description_11, t1.indexed_content_id AS indexed_content_id_12, t2.lock_by_id AS lock_by_id_13 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, 44366, 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,
  f2_.is_bot AS is_bot_5,
  f2_.enabled AS enabled_6,
  a0_.d_type AS d_type_7,
  a0_.assigned_to_id AS assigned_to_id_8,
  f1_.parent_id AS parent_id_9,
  f2_.chapter_id AS chapter_id_10,
  f2_.training_id AS training_id_11,
  f2_.module_id AS module_id_12,
  f2_.user_id AS user_id_13
FROM
  forum_chapter_message f2_
  INNER JOIN forum_abstract_chapter_message f1_ ON f2_.id = f1_.id
  INNER JOIN assignable a0_ ON f2_.id = a0_.id
  INNER JOIN scholar_chapters s3_ ON f2_.chapter_id = s3_.id
  LEFT JOIN scholar_origin_chapters s4_ ON s3_.id = s4_.id
  LEFT JOIN scholar_shared_chapters s5_ ON s3_.id = s5_.id
WHERE
  f2_.enabled = ?
  AND s3_.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, f2_.is_bot AS is_bot_5, f2_.enabled AS enabled_6, a0_.d_type AS d_type_7, a0_.assigned_to_id AS assigned_to_id_8, f1_.parent_id AS parent_id_9, f2_.chapter_id AS chapter_id_10, f2_.training_id AS training_id_11, f2_.module_id AS module_id_12, f2_.user_id AS user_id_13 FROM forum_chapter_message f2_ INNER JOIN forum_abstract_chapter_message f1_ ON f2_.id = f1_.id INNER JOIN assignable a0_ ON f2_.id = a0_.id INNER JOIN scholar_chapters s3_ ON f2_.chapter_id = s3_.id LEFT JOIN scholar_origin_chapters s4_ ON s3_.id = s4_.id LEFT JOIN scholar_shared_chapters s5_ ON s3_.id = s5_.id WHERE f2_.enabled = 1 AND s3_.id = 103145 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.from_api AS from_api_6,
  t0.lesson_id AS lesson_id_7,
  t0.dtype,
  t1.name AS name_8,
  t1.body AS body_9,
  t1.sort_order AS sort_order_10,
  t1.description AS description_11,
  t1.indexed_content_id AS indexed_content_id_12,
  t2.lock_by_id AS lock_by_id_13
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.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.from_api AS from_api_6, t0.lesson_id AS lesson_id_7, t0.dtype, t1.name AS name_8, t1.body AS body_9, t1.sort_order AS sort_order_10, t1.description AS description_11, t1.indexed_content_id AS indexed_content_id_12, t2.lock_by_id AS lock_by_id_13 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 = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

SELECT
  t0.id AS id_3,
  t0.minimum_time AS minimum_time_4,
  t0.lesson_review_activated AS lesson_review_activated_5,
  t0.enable_chat_bot AS enable_chat_bot_6,
  t0.support_scorm AS support_scorm_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.from_api AS from_api_10,
  t0.status AS status_11,
  t0.referral_trainer_id AS referral_trainer_id_12,
  t0.lesson_stats_id AS lesson_stats_id_13,
  t0.owner_channel_id AS owner_channel_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16,
  t0.dtype,
  t1.ref AS ref_17,
  t1.objective AS objective_18,
  t1.name AS name_19,
  t1.description AS description_20,
  t1.public AS public_21,
  t1.image_id AS image_id_22,
  t1.indexed_content_id AS indexed_content_id_23,
  t2.lock_by_status AS lock_by_status_24,
  t2.lock_by_id AS lock_by_id_25,
  t2.target_channel_id AS target_channel_id_26
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.enable_chat_bot AS enable_chat_bot_6, t0.support_scorm AS support_scorm_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.from_api AS from_api_10, t0.status AS status_11, t0.referral_trainer_id AS referral_trainer_id_12, t0.lesson_stats_id AS lesson_stats_id_13, t0.owner_channel_id AS owner_channel_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16, t0.dtype, t1.ref AS ref_17, t1.objective AS objective_18, t1.name AS name_19, t1.description AS description_20, t1.public AS public_21, t1.image_id AS image_id_22, t1.indexed_content_id AS indexed_content_id_23, t2.lock_by_status AS lock_by_status_24, t2.lock_by_id AS lock_by_id_25, t2.target_channel_id AS target_channel_id_26 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 = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

SELECT
  t1.id AS id_2,
  t1.minimum_time AS minimum_time_3,
  t1.lesson_review_activated AS lesson_review_activated_4,
  t1.enable_chat_bot AS enable_chat_bot_5,
  t1.support_scorm AS support_scorm_6,
  t1.created_at AS created_at_7,
  t1.updated_at AS updated_at_8,
  t1.from_api AS from_api_9,
  t1.status AS status_10,
  t0.ref AS ref_11,
  t0.objective AS objective_12,
  t0.name AS name_13,
  t0.description AS description_14,
  t0.public AS public_15,
  t1.referral_trainer_id AS referral_trainer_id_16,
  t1.lesson_stats_id AS lesson_stats_id_17,
  t1.owner_channel_id AS owner_channel_id_18,
  t1.created_by_id AS created_by_id_19,
  t1.updated_by_id AS updated_by_id_20,
  t0.image_id AS image_id_21,
  t0.indexed_content_id AS indexed_content_id_22,
  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.enable_chat_bot AS enable_chat_bot_5, t1.support_scorm AS support_scorm_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.from_api AS from_api_9, t1.status AS status_10, t0.ref AS ref_11, t0.objective AS objective_12, t0.name AS name_13, t0.description AS description_14, t0.public AS public_15, t1.referral_trainer_id AS referral_trainer_id_16, t1.lesson_stats_id AS lesson_stats_id_17, t1.owner_channel_id AS owner_channel_id_18, t1.created_by_id AS created_by_id_19, t1.updated_by_id AS updated_by_id_20, t0.image_id AS image_id_21, t0.indexed_content_id AS indexed_content_id_22, 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.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.from_api AS from_api_6,
  t0.stat_avg_score AS stat_avg_score_7,
  t0.stat_avg_time AS stat_avg_time_8,
  t0.stat_median_score AS stat_median_score_9,
  t0.stat_median_time AS stat_median_time_10,
  t0.stat_total_score AS stat_total_score_11,
  t0.stat_total_time AS stat_total_time_12,
  t0.stat_total_done AS stat_total_done_13,
  t0.stat_score_distribution AS stat_score_distribution_14,
  t0.stat_time_distribution AS stat_time_distribution_15,
  t0.lesson_id AS lesson_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.dtype,
  t1.name AS name_19,
  t1.description AS description_20,
  t1.sort_order AS sort_order_21,
  t2.lock_by_id AS lock_by_id_22
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.from_api AS from_api_6, t0.stat_avg_score AS stat_avg_score_7, t0.stat_avg_time AS stat_avg_time_8, t0.stat_median_score AS stat_median_score_9, t0.stat_median_time AS stat_median_time_10, t0.stat_total_score AS stat_total_score_11, t0.stat_total_time AS stat_total_time_12, t0.stat_total_done AS stat_total_done_13, t0.stat_score_distribution AS stat_score_distribution_14, t0.stat_time_distribution AS stat_time_distribution_15, t0.lesson_id AS lesson_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.dtype, t1.name AS name_19, t1.description AS description_20, t1.sort_order AS sort_order_21, t2.lock_by_id AS lock_by_id_22 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 = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

SELECT
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.from_api AS from_api_6,
  t0.stat_avg_score AS stat_avg_score_7,
  t0.stat_avg_time AS stat_avg_time_8,
  t0.stat_median_score AS stat_median_score_9,
  t0.stat_median_time AS stat_median_time_10,
  t0.stat_total_score AS stat_total_score_11,
  t0.stat_total_time AS stat_total_time_12,
  t0.stat_total_done AS stat_total_done_13,
  t0.stat_score_distribution AS stat_score_distribution_14,
  t0.stat_time_distribution AS stat_time_distribution_15,
  t0.lesson_id AS lesson_id_16,
  t0.created_by_id AS created_by_id_17,
  t0.updated_by_id AS updated_by_id_18,
  t0.dtype,
  t1.name AS name_19,
  t1.description AS description_20,
  t1.sort_order AS sort_order_21,
  t2.lock_by_id AS lock_by_id_22
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.from_api AS from_api_6, t0.stat_avg_score AS stat_avg_score_7, t0.stat_avg_time AS stat_avg_time_8, t0.stat_median_score AS stat_median_score_9, t0.stat_median_time AS stat_median_time_10, t0.stat_total_score AS stat_total_score_11, t0.stat_total_time AS stat_total_time_12, t0.stat_total_done AS stat_total_done_13, t0.stat_score_distribution AS stat_score_distribution_14, t0.stat_time_distribution AS stat_time_distribution_15, t0.lesson_id AS lesson_id_16, t0.created_by_id AS created_by_id_17, t0.updated_by_id AS updated_by_id_18, t0.dtype, t1.name AS name_19, t1.description AS description_20, t1.sort_order AS sort_order_21, t2.lock_by_id AS lock_by_id_22 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_3,
  t0.ask_for_referent_correction AS ask_for_referent_correction_4,
  t0.from_api AS from_api_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.lesson_id AS lesson_id_8,
  t0.dtype,
  t1.title AS title_9,
  t1.content AS content_10,
  t1.remark AS remark_11,
  t1.estimate_time AS estimate_time_12,
  t1.correction AS correction_13,
  t1.is_archived AS is_archived_14,
  t2.lock_by_id AS lock_by_id_15
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.from_api AS from_api_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lesson_id AS lesson_id_8, t0.dtype, t1.title AS title_9, t1.content AS content_10, t1.remark AS remark_11, t1.estimate_time AS estimate_time_12, t1.correction AS correction_13, t1.is_archived AS is_archived_14, t2.lock_by_id AS lock_by_id_15 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 = '47fa4cf8-a342-11ef-8ed8-0242c0a83005';

SELECT
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.from_api AS from_api_6,
  t0.lesson_id AS lesson_id_7,
  t0.dtype,
  t1.name AS name_8,
  t1.body AS body_9,
  t1.sort_order AS sort_order_10,
  t1.description AS description_11,
  t1.indexed_content_id AS indexed_content_id_12,
  t2.lock_by_id AS lock_by_id_13
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.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.from_api AS from_api_6, t0.lesson_id AS lesson_id_7, t0.dtype, t1.name AS name_8, t1.body AS body_9, t1.sort_order AS sort_order_10, t1.description AS description_11, t1.indexed_content_id AS indexed_content_id_12, t2.lock_by_id AS lock_by_id_13 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 = '103145';

SELECT
  t2.id AS id_3,
  t2.assignable_status AS assignable_status_4,
  t2.created_at AS created_at_5,
  t2.updated_at AS updated_at_6,
  t1.content AS content_7,
  t0.is_bot AS is_bot_8,
  t0.enabled AS enabled_9,
  t2.assigned_to_id AS assigned_to_id_10,
  t1.parent_id AS parent_id_11,
  t0.chapter_id AS chapter_id_12,
  t0.training_id AS training_id_13,
  t0.module_id AS module_id_14,
  t0.user_id AS user_id_15,
  t2.d_type
FROM
  forum_chapter_message t0
  INNER JOIN forum_abstract_chapter_message t1 ON t0.id = t1.id
  INNER JOIN assignable t2 ON t0.id = t2.id
WHERE
  t0.chapter_id = ?

SELECT t2.id AS id_3, t2.assignable_status AS assignable_status_4, t2.created_at AS created_at_5, t2.updated_at AS updated_at_6, t1.content AS content_7, t0.is_bot AS is_bot_8, t0.enabled AS enabled_9, t2.assigned_to_id AS assigned_to_id_10, t1.parent_id AS parent_id_11, t0.chapter_id AS chapter_id_12, t0.training_id AS training_id_13, t0.module_id AS module_id_14, t0.user_id AS user_id_15, t2.d_type FROM forum_chapter_message t0 INNER JOIN forum_abstract_chapter_message t1 ON t0.id = t1.id INNER JOIN assignable t2 ON t0.id = t2.id WHERE t0.chapter_id = 103145;

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,
  t0.created_by_id AS created_by_id_8,
  t9.id AS id_10,
  t9.email AS email_11,
  t9.roles AS roles_12,
  t9.description AS description_13,
  t9.avatar AS avatar_14,
  t9.avatar_path AS avatar_path_15,
  t9.first_name AS first_name_16,
  t9.last_name AS last_name_17,
  t9.avatar_file AS avatar_file_18,
  t9.role_description AS role_description_19,
  t9.signing_limit_date AS signing_limit_date_20,
  t9.token_token AS token_token_21,
  t9.token_expire_at AS token_expire_at_22,
  t9.token_refresh_token AS token_refresh_token_23,
  t0.updated_by_id AS updated_by_id_24,
  t25.id AS id_26,
  t25.email AS email_27,
  t25.roles AS roles_28,
  t25.description AS description_29,
  t25.avatar AS avatar_30,
  t25.avatar_path AS avatar_path_31,
  t25.first_name AS first_name_32,
  t25.last_name AS last_name_33,
  t25.avatar_file AS avatar_file_34,
  t25.role_description AS role_description_35,
  t25.signing_limit_date AS signing_limit_date_36,
  t25.token_token AS token_token_37,
  t25.token_expire_at AS token_expire_at_38,
  t25.token_refresh_token AS token_refresh_token_39
FROM
  template_template_page t0
  LEFT JOIN account_users t9 ON t0.created_by_id = t9.id
  LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id
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, t0.created_by_id AS created_by_id_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.description AS description_13, t9.avatar AS avatar_14, t9.avatar_path AS avatar_path_15, t9.first_name AS first_name_16, t9.last_name AS last_name_17, t9.avatar_file AS avatar_file_18, t9.role_description AS role_description_19, t9.signing_limit_date AS signing_limit_date_20, t9.token_token AS token_token_21, t9.token_expire_at AS token_expire_at_22, t9.token_refresh_token AS token_refresh_token_23, t0.updated_by_id AS updated_by_id_24, t25.id AS id_26, t25.email AS email_27, t25.roles AS roles_28, t25.description AS description_29, t25.avatar AS avatar_30, t25.avatar_path AS avatar_path_31, t25.first_name AS first_name_32, t25.last_name AS last_name_33, t25.avatar_file AS avatar_file_34, t25.role_description AS role_description_35, t25.signing_limit_date AS signing_limit_date_36, t25.token_token AS token_token_37, t25.token_expire_at AS token_expire_at_38, t25.token_refresh_token AS token_refresh_token_39 FROM template_template_page t0 LEFT JOIN account_users t9 ON t0.created_by_id = t9.id LEFT JOIN account_users t25 ON t0.updated_by_id = t25.id WHERE t0.in_footer = 1;

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 = '4851fc3e-a342-11ef-8ed8-0242c0a83005';

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.from_api AS from_api_11,
  t0.name AS name_12,
  t0.description AS description_13,
  t0.public AS public_14,
  t0.status AS status_15,
  t0.image_id AS image_id_16,
  t0.duplicate_from_id AS duplicate_from_id_17,
  t0.owner_channel_id AS owner_channel_id_18,
  t0.created_by_id AS created_by_id_19,
  t0.updated_by_id AS updated_by_id_20,
  t0.dtype,
  t1.lock_by_status AS lock_by_status_21,
  t1.lock_by_id AS lock_by_id_22,
  t1.target_channel_id AS target_channel_id_23
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.from_api AS from_api_11, t0.name AS name_12, t0.description AS description_13, t0.public AS public_14, t0.status AS status_15, t0.image_id AS image_id_16, t0.duplicate_from_id AS duplicate_from_id_17, t0.owner_channel_id AS owner_channel_id_18, t0.created_by_id AS created_by_id_19, t0.updated_by_id AS updated_by_id_20, t0.dtype, t1.lock_by_status AS lock_by_status_21, t1.lock_by_id AS lock_by_id_22, t1.target_channel_id AS target_channel_id_23 FROM scholar_trainings t0 LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id WHERE t0.id = '4851fc3e-a342-11ef-8ed8-0242c0a83005';

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 = '4851fc3e-a342-11ef-8ed8-0242c0a83005' ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.children_updated_at AS children_updated_at_2,
  t0.training_id AS training_id_3,
  t0.module_id AS module_id_4,
  t0.lesson_id AS lesson_id_5
FROM
  scholar_update_tracker t0
WHERE
  t0.training_id = ?

SELECT t0.id AS id_1, t0.children_updated_at AS children_updated_at_2, t0.training_id AS training_id_3, t0.module_id AS module_id_4, t0.lesson_id AS lesson_id_5 FROM scholar_update_tracker t0 WHERE t0.training_id = '4851fc3e-a342-11ef-8ed8-0242c0a83005';

SELECT
  t1.id AS id_2,
  t1.created_at AS created_at_3,
  t1.updated_at AS updated_at_4,
  t1.from_api AS from_api_5,
  t0.name AS name_6,
  t0.body AS body_7,
  t0.sort_order AS sort_order_8,
  t0.description AS description_9,
  t1.lesson_id AS lesson_id_10,
  t0.indexed_content_id AS indexed_content_id_11,
  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, t1.created_at AS created_at_3, t1.updated_at AS updated_at_4, t1.from_api AS from_api_5, t0.name AS name_6, t0.body AS body_7, t0.sort_order AS sort_order_8, t0.description AS description_9, t1.lesson_id AS lesson_id_10, t0.indexed_content_id AS indexed_content_id_11, t1.dtype FROM scholar_origin_chapters t0 INNER JOIN scholar_chapters t1 ON t0.id = t1.id WHERE t1.id = 44365;

SELECT
  c0_.id AS id_0,
  c0_.domain AS domain_1,
  c0_.channel_id AS channel_id_2
FROM
  channel_white_label c0_
WHERE
  c0_.domain = ?