Symfony Profiler

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 = 'fc0e6cc2-4f0e-11ef-bc20-0242c0a88006';

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 = 'fc0e6cc2-4f0e-11ef-bc20-0242c0a88006';

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.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.from_api AS from_api_9,
  t0.status AS status_10,
  t0.referral_trainer_id AS referral_trainer_id_11,
  t0.lesson_stats_id AS lesson_stats_id_12,
  t0.owner_channel_id AS owner_channel_id_13,
  t0.created_by_id AS created_by_id_14,
  t0.updated_by_id AS updated_by_id_15,
  t0.dtype,
  t1.ref AS ref_16,
  t1.objective AS objective_17,
  t1.name AS name_18,
  t1.description AS description_19,
  t1.public AS public_20,
  t1.image_id AS image_id_21,
  t1.indexed_content_id AS indexed_content_id_22,
  t2.lock_by_status AS lock_by_status_23,
  t2.lock_by_id AS lock_by_id_24,
  t2.target_channel_id AS target_channel_id_25
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.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.from_api AS from_api_9, t0.status AS status_10, t0.referral_trainer_id AS referral_trainer_id_11, t0.lesson_stats_id AS lesson_stats_id_12, t0.owner_channel_id AS owner_channel_id_13, t0.created_by_id AS created_by_id_14, t0.updated_by_id AS updated_by_id_15, t0.dtype, t1.ref AS ref_16, t1.objective AS objective_17, t1.name AS name_18, t1.description AS description_19, t1.public AS public_20, t1.image_id AS image_id_21, t1.indexed_content_id AS indexed_content_id_22, t2.lock_by_status AS lock_by_status_23, t2.lock_by_id AS lock_by_id_24, t2.target_channel_id AS target_channel_id_25 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 = 'fc0e6cc2-4f0e-11ef-bc20-0242c0a88006';

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.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.from_api AS from_api_8,
  t1.status AS status_9,
  t0.ref AS ref_10,
  t0.objective AS objective_11,
  t0.name AS name_12,
  t0.description AS description_13,
  t0.public AS public_14,
  t1.referral_trainer_id AS referral_trainer_id_15,
  t1.lesson_stats_id AS lesson_stats_id_16,
  t1.owner_channel_id AS owner_channel_id_17,
  t1.created_by_id AS created_by_id_18,
  t1.updated_by_id AS updated_by_id_19,
  t0.image_id AS image_id_20,
  t0.indexed_content_id AS indexed_content_id_21,
  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.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.from_api AS from_api_8, t1.status AS status_9, t0.ref AS ref_10, t0.objective AS objective_11, t0.name AS name_12, t0.description AS description_13, t0.public AS public_14, t1.referral_trainer_id AS referral_trainer_id_15, t1.lesson_stats_id AS lesson_stats_id_16, t1.owner_channel_id AS owner_channel_id_17, t1.created_by_id AS created_by_id_18, t1.updated_by_id AS updated_by_id_19, t0.image_id AS image_id_20, t0.indexed_content_id AS indexed_content_id_21, 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
  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 = 'fc10636c-4f0e-11ef-bc20-0242c0a88006';

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 = 'fc10636c-4f0e-11ef-bc20-0242c0a88006';

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 = 'fc10636c-4f0e-11ef-bc20-0242c0a88006' ORDER BY t0.sort_order ASC;

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 = 'fc10636c-4f0e-11ef-bc20-0242c0a88006';

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
  s0_.id AS id_0,
  s0_.total_hour_description AS total_hour_description_1,
  s0_.video_description AS video_description_2,
  s0_.diploma_description AS diploma_description_3,
  s0_.training_type AS training_type_4,
  s0_.thematic AS thematic_5,
  s0_.diploma AS diploma_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.from_api AS from_api_9,
  s0_.name AS name_10,
  s0_.description AS description_11,
  s0_.public AS public_12,
  s0_.status AS status_13,
  s1_.lock_by_status AS lock_by_status_14,
  avg(s2_.note) AS sclr_15,
  s0_.dtype AS dtype_16,
  s0_.image_id AS image_id_17,
  s0_.duplicate_from_id AS duplicate_from_id_18,
  s0_.owner_channel_id AS owner_channel_id_19,
  s0_.created_by_id AS created_by_id_20,
  s0_.updated_by_id AS updated_by_id_21,
  s1_.lock_by_id AS lock_by_id_22,
  s1_.target_channel_id AS target_channel_id_23
FROM
  scholar_trainings s0_
  LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id
  LEFT JOIN scholar_training_advice s2_ ON (s0_.id = s2_.training_id)
  INNER JOIN channel_channels c3_ ON s0_.owner_channel_id = c3_.id
  INNER JOIN (
    scholar_shared_trainings s4_
    INNER JOIN scholar_trainings s5_ ON s4_.id = s5_.id
  ) ON (s5_.id = s0_.id)
WHERE
  s0_.owner_channel_id = ?
  AND (
    s0_.status = ?
    OR s0_.status IS NULL
  )
  AND c3_.approved = ?
  AND (
    s5_.id IS NULL
    OR s4_.lock_by_status <> ?
  )
GROUP BY
  s0_.id
ORDER BY
  sclr_15 DESC,
  s0_.created_at DESC
LIMIT
  4

SELECT s0_.id AS id_0, s0_.total_hour_description AS total_hour_description_1, s0_.video_description AS video_description_2, s0_.diploma_description AS diploma_description_3, s0_.training_type AS training_type_4, s0_.thematic AS thematic_5, s0_.diploma AS diploma_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.from_api AS from_api_9, s0_.name AS name_10, s0_.description AS description_11, s0_.public AS public_12, s0_.status AS status_13, s1_.lock_by_status AS lock_by_status_14, avg(s2_.note) AS sclr_15, s0_.dtype AS dtype_16, s0_.image_id AS image_id_17, s0_.duplicate_from_id AS duplicate_from_id_18, s0_.owner_channel_id AS owner_channel_id_19, s0_.created_by_id AS created_by_id_20, s0_.updated_by_id AS updated_by_id_21, s1_.lock_by_id AS lock_by_id_22, s1_.target_channel_id AS target_channel_id_23 FROM scholar_trainings s0_ LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id LEFT JOIN scholar_training_advice s2_ ON (s0_.id = s2_.training_id) INNER JOIN channel_channels c3_ ON s0_.owner_channel_id = c3_.id INNER JOIN (scholar_shared_trainings s4_ INNER JOIN scholar_trainings s5_ ON s4_.id = s5_.id) ON (s5_.id = s0_.id) WHERE s0_.owner_channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84' AND (s0_.status = 'published' OR s0_.status IS NULL) AND c3_.approved = 1 AND (s5_.id IS NULL OR s4_.lock_by_status <> 0) GROUP BY s0_.id ORDER BY sclr_15 DESC, s0_.created_at DESC LIMIT 4;

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 = '4d23a7fe-3197-11f0-b1c2-aa0701787942' ORDER BY t0.sort_order ASC;

SELECT
  count(c0_.id) AS sclr_0
FROM
  channel_user_data_cursus c0_
WHERE
  c0_.training_id = ?

SELECT count(c0_.id) AS sclr_0 FROM channel_user_data_cursus c0_ WHERE c0_.training_id = '4d23a7fe-3197-11f0-b1c2-aa0701787942';

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 = '4d23a7fe-3197-11f0-b1c2-aa0701787942';

SELECT
  s0_.id AS id_0,
  s0_.note AS note_1,
  s0_.comment AS comment_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.user_id AS user_id_5,
  s0_.training_id AS training_id_6
FROM
  scholar_training_advice s0_
  INNER JOIN (
    scholar_trainings s1_
    LEFT JOIN scholar_shared_trainings s2_ ON s1_.id = s2_.id
  ) ON (s1_.id = s0_.training_id)
  INNER JOIN channel_channels c3_ ON (c3_.id = s1_.owner_channel_id)
WHERE
  c3_.id = ?
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.note AS note_1, s0_.comment AS comment_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.user_id AS user_id_5, s0_.training_id AS training_id_6 FROM scholar_training_advice s0_ INNER JOIN (scholar_trainings s1_ LEFT JOIN scholar_shared_trainings s2_ ON s1_.id = s2_.id) ON (s1_.id = s0_.training_id) INNER JOIN channel_channels c3_ ON (c3_.id = s1_.owner_channel_id) WHERE c3_.id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84' ORDER BY s0_.created_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.note AS note_1,
  s0_.comment AS comment_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.user_id AS user_id_5,
  s0_.training_id AS training_id_6
FROM
  scholar_training_advice s0_
WHERE
  s0_.training_id = ?

SELECT s0_.id AS id_0, s0_.note AS note_1, s0_.comment AS comment_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.user_id AS user_id_5, s0_.training_id AS training_id_6 FROM scholar_training_advice s0_ WHERE s0_.training_id = '4d23a7fe-3197-11f0-b1c2-aa0701787942';

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  forum_chapter_message f1_
  INNER JOIN forum_abstract_chapter_message f2_ ON f1_.id = f2_.id
  INNER JOIN assignable a0_ ON f1_.id = a0_.id
  LEFT JOIN scholar_chapters s3_ ON f1_.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
  LEFT JOIN scholar_lessons s6_ ON s3_.lesson_id = s6_.id
  LEFT JOIN scholar_origin_lessons s7_ ON s6_.id = s7_.id
  LEFT JOIN scholar_shared_lessons s8_ ON s6_.id = s8_.id
WHERE
  f1_.enabled = ?
  AND f1_.user_id = ?
  AND f2_.parent_id IS NOT NULL
  AND s6_.owner_channel_id = ?
ORDER BY
  a0_.created_at DESC,
  f1_.chapter_id ASC

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM forum_chapter_message f1_ INNER JOIN forum_abstract_chapter_message f2_ ON f1_.id = f2_.id INNER JOIN assignable a0_ ON f1_.id = a0_.id LEFT JOIN scholar_chapters s3_ ON f1_.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 LEFT JOIN scholar_lessons s6_ ON s3_.lesson_id = s6_.id LEFT JOIN scholar_origin_lessons s7_ ON s6_.id = s7_.id LEFT JOIN scholar_shared_lessons s8_ ON s6_.id = s8_.id WHERE f1_.enabled = 1 AND f1_.user_id = '1ef4f0e7-d8b0-612a-9b42-296584037db6' AND f2_.parent_id IS NOT NULL AND s6_.owner_channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84' ORDER BY a0_.created_at DESC, f1_.chapter_id 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 = '4d23a7fe-3197-11f0-b1c2-aa0701787942';

SELECT
  COUNT(*)
FROM
  channel_institution t0
WHERE
  t0.channel_id = ?

SELECT COUNT(*) FROM channel_institution t0 WHERE t0.channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.url AS url_3,
  t0.channel_id AS channel_id_4
FROM
  channel_links t0
WHERE
  t0.channel_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.url AS url_3, t0.channel_id AS channel_id_4 FROM channel_links t0 WHERE t0.channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

SELECT
  COUNT(*)
FROM
  scholar_trainings t0
  LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id
WHERE
  t0.owner_channel_id = ?

SELECT COUNT(*) FROM scholar_trainings t0 LEFT JOIN scholar_shared_trainings t1 ON t0.id = t1.id WHERE t0.owner_channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

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 = '374ed1f5-4852-11ef-9bb3-0242c0a88004';

SELECT
  COUNT(*)
FROM
  channel_gallery t0
WHERE
  t0.channel_id = ?

SELECT COUNT(*) FROM channel_gallery t0 WHERE t0.channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

SELECT
  COUNT(*)
FROM
  channel_partner t0
WHERE
  t0.channel_id = ?

SELECT COUNT(*) FROM channel_partner t0 WHERE t0.channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

SELECT
  COUNT(*)
FROM
  channel_description t0
WHERE
  t0.channel_id = ?

SELECT COUNT(*) FROM channel_description t0 WHERE t0.channel_id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

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 = ?

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 = 'adrec.staging.nellapp-01.drosalys.net';

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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slogan AS slogan_3,
  t0.approved AS approved_4,
  t0.can_share_content AS can_share_content_5,
  t0.can_upload_video AS can_upload_video_6,
  t0.image_path AS image_path_7,
  t0.description AS description_8,
  t0.contact_email AS contact_email_9,
  t0.contact_phone AS contact_phone_10,
  t0.presentation_title AS presentation_title_11,
  t0.presentation_text AS presentation_text_12,
  t0.payment_alert AS payment_alert_13,
  t0.enabled_indexing AS enabled_indexing_14,
  t0.enabled_chat_bot AS enabled_chat_bot_15,
  t0.owner_id AS owner_id_16,
  t0.image_id AS image_id_17,
  t18.id AS id_19,
  t18.domain AS domain_20,
  t18.channel_id AS channel_id_21,
  t0.default_referral_trainer_id AS default_referral_trainer_id_22
FROM
  channel_channels t0
  LEFT JOIN channel_white_label t18 ON t18.channel_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slogan AS slogan_3, t0.approved AS approved_4, t0.can_share_content AS can_share_content_5, t0.can_upload_video AS can_upload_video_6, t0.image_path AS image_path_7, t0.description AS description_8, t0.contact_email AS contact_email_9, t0.contact_phone AS contact_phone_10, t0.presentation_title AS presentation_title_11, t0.presentation_text AS presentation_text_12, t0.payment_alert AS payment_alert_13, t0.enabled_indexing AS enabled_indexing_14, t0.enabled_chat_bot AS enabled_chat_bot_15, t0.owner_id AS owner_id_16, t0.image_id AS image_id_17, t18.id AS id_19, t18.domain AS domain_20, t18.channel_id AS channel_id_21, t0.default_referral_trainer_id AS default_referral_trainer_id_22 FROM channel_channels t0 LEFT JOIN channel_white_label t18 ON t18.channel_id = t0.id WHERE t0.id = '1ef4f0e1-d6fe-6eb8-a357-5f2b03096d84';

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.description AS description_4,
  t0.avatar AS avatar_5,
  t0.avatar_path AS avatar_path_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.avatar_file AS avatar_file_9,
  t0.role_description AS role_description_10,
  t0.signing_limit_date AS signing_limit_date_11,
  t0.token_token AS token_token_12,
  t0.token_expire_at AS token_expire_at_13,
  t0.token_refresh_token AS token_refresh_token_14
FROM
  account_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.description AS description_4, t0.avatar AS avatar_5, t0.avatar_path AS avatar_path_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.avatar_file AS avatar_file_9, t0.role_description AS role_description_10, t0.signing_limit_date AS signing_limit_date_11, t0.token_token AS token_token_12, t0.token_expire_at AS token_expire_at_13, t0.token_refresh_token AS token_refresh_token_14 FROM account_users t0 WHERE t0.id = '1ef4f0e7-d8b0-612a-9b42-296584037db6';

SELECT
  t0.id AS id_1,
  t0.is_learner AS is_learner_2,
  t0.is_active AS is_active_3,
  t0.expire_at AS expire_at_4,
  t0.start_at AS start_at_5,
  t0.displayed_menu AS displayed_menu_6,
  t0.user_id AS user_id_7,
  t0.channel_id AS channel_id_8,
  t0.channel_user_role_id AS channel_user_role_id_9
FROM
  channel_user_data t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.is_learner AS is_learner_2, t0.is_active AS is_active_3, t0.expire_at AS expire_at_4, t0.start_at AS start_at_5, t0.displayed_menu AS displayed_menu_6, t0.user_id AS user_id_7, t0.channel_id AS channel_id_8, t0.channel_user_role_id AS channel_user_role_id_9 FROM channel_user_data t0 WHERE t0.user_id = '1ef4f0e7-d8b0-612a-9b42-296584037db6';