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.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 = '8ff02cd5-3543-11e9-8180-00163e87308f';

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 = '8ff02cd5-3543-11e9-8180-00163e87308f';

SELECT
  s0_.id AS id_0,
  s0_.is_blocked AS is_blocked_1,
  s0_.created_at AS created_at_2,
  s0_.updated_at AS updated_at_3,
  s0_.from_api AS from_api_4,
  s1_.name AS name_5,
  s1_.description AS description_6,
  s1_.public AS public_7,
  s1_.status AS status_8,
  s2_.lock_by_status AS lock_by_status_9,
  s0_.dtype AS dtype_10,
  s0_.owner_channel_id AS owner_channel_id_11,
  s0_.created_by_id AS created_by_id_12,
  s0_.updated_by_id AS updated_by_id_13,
  s1_.image_id AS image_id_14,
  s1_.duplicate_from_id AS duplicate_from_id_15,
  s2_.lock_by_id AS lock_by_id_16,
  s2_.target_channel_id AS target_channel_id_17
FROM
  scholar_modules s0_
  LEFT JOIN scholar_origin_modules s1_ ON s0_.id = s1_.id
  LEFT JOIN scholar_shared_modules s2_ ON s0_.id = s2_.id
  INNER JOIN scholar_training_modules s3_ ON (s3_.module_id = s0_.id)
WHERE
  s3_.training_id = ?
  AND s0_.id = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.is_blocked AS is_blocked_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, s0_.from_api AS from_api_4, s1_.name AS name_5, s1_.description AS description_6, s1_.public AS public_7, s1_.status AS status_8, s2_.lock_by_status AS lock_by_status_9, s0_.dtype AS dtype_10, s0_.owner_channel_id AS owner_channel_id_11, s0_.created_by_id AS created_by_id_12, s0_.updated_by_id AS updated_by_id_13, s1_.image_id AS image_id_14, s1_.duplicate_from_id AS duplicate_from_id_15, s2_.lock_by_id AS lock_by_id_16, s2_.target_channel_id AS target_channel_id_17 FROM scholar_modules s0_ LEFT JOIN scholar_origin_modules s1_ ON s0_.id = s1_.id LEFT JOIN scholar_shared_modules s2_ ON s0_.id = s2_.id INNER JOIN scholar_training_modules s3_ ON (s3_.module_id = s0_.id) WHERE s3_.training_id = 'ddf201b3-6026-11e9-a435-0242c0a8d002' AND s0_.id = '2b6a41ad-354a-11e9-8180-00163e87308f' LIMIT 1;

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 = '8ff02cd5-3543-11e9-8180-00163e87308f';

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_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 = 'ddf201b3-6026-11e9-a435-0242c0a8d002';

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 = '2b6a41ad-354a-11e9-8180-00163e87308f';

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 = 'ddf201b3-6026-11e9-a435-0242c0a8d002';

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 = 'ddf201b3-6026-11e9-a435-0242c0a8d002';

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 IN (?)

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 IN ('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.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 = '2b6a41ad-354a-11e9-8180-00163e87308f';

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 = '2b6a41ad-354a-11e9-8180-00163e87308f' ORDER BY t0.sort_order ASC;