Symfony Profiler

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 = '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
  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.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
  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;

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

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.owner_channel_id AS owner_channel_id_8
FROM
  channel_images t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.title AS title_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.owner_channel_id AS owner_channel_id_8 FROM channel_images t0 WHERE t0.id = 5879;

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

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 = 'e231122f-1f18-11e9-8180-00163e87308f';

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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,
          s0_.dtype AS dtype_15
        FROM
          scholar_trainings s0_
          LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id
          INNER JOIN channel_channels c2_ ON s0_.owner_channel_id = c2_.id
          INNER JOIN (
            scholar_shared_trainings s3_
            INNER JOIN scholar_trainings s4_ ON s3_.id = s4_.id
          ) ON (s4_.id = s0_.id)
        WHERE
          s0_.owner_channel_id = ?
          AND (
            s0_.status = ?
            OR s0_.status IS NULL
          )
          AND c2_.approved = ?
          AND (
            s4_.id IS NULL
            OR s3_.lock_by_status <> ?
          )
        ORDER BY
          s0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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, s0_.dtype AS dtype_15 FROM scholar_trainings s0_ LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id INNER JOIN channel_channels c2_ ON s0_.owner_channel_id = c2_.id INNER JOIN (scholar_shared_trainings s3_ INNER JOIN scholar_trainings s4_ ON s3_.id = s4_.id) ON (s4_.id = s0_.id) WHERE s0_.owner_channel_id = 'e231122f-1f18-11e9-8180-00163e87308f' AND (s0_.status = 'published' OR s0_.status IS NULL) AND c2_.approved = 1 AND (s4_.id IS NULL OR s3_.lock_by_status <> 0) ORDER BY s0_.created_at DESC) dctrn_result) dctrn_table;

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,
  s0_.dtype AS dtype_15,
  s0_.image_id AS image_id_16,
  s0_.duplicate_from_id AS duplicate_from_id_17,
  s0_.owner_channel_id AS owner_channel_id_18,
  s0_.created_by_id AS created_by_id_19,
  s0_.updated_by_id AS updated_by_id_20,
  s1_.lock_by_id AS lock_by_id_21,
  s1_.target_channel_id AS target_channel_id_22
FROM
  scholar_trainings s0_
  LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id
  INNER JOIN channel_channels c2_ ON s0_.owner_channel_id = c2_.id
  INNER JOIN (
    scholar_shared_trainings s3_
    INNER JOIN scholar_trainings s4_ ON s3_.id = s4_.id
  ) ON (s4_.id = s0_.id)
WHERE
  s0_.owner_channel_id = ?
  AND (
    s0_.status = ?
    OR s0_.status IS NULL
  )
  AND c2_.approved = ?
  AND (
    s4_.id IS NULL
    OR s3_.lock_by_status <> ?
  )
  AND s0_.id IN (?)
ORDER BY
  s0_.created_at DESC

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, s0_.dtype AS dtype_15, s0_.image_id AS image_id_16, s0_.duplicate_from_id AS duplicate_from_id_17, s0_.owner_channel_id AS owner_channel_id_18, s0_.created_by_id AS created_by_id_19, s0_.updated_by_id AS updated_by_id_20, s1_.lock_by_id AS lock_by_id_21, s1_.target_channel_id AS target_channel_id_22 FROM scholar_trainings s0_ LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id INNER JOIN channel_channels c2_ ON s0_.owner_channel_id = c2_.id INNER JOIN (scholar_shared_trainings s3_ INNER JOIN scholar_trainings s4_ ON s3_.id = s4_.id) ON (s4_.id = s0_.id) WHERE s0_.owner_channel_id = 'e231122f-1f18-11e9-8180-00163e87308f' AND (s0_.status = 'published' OR s0_.status IS NULL) AND c2_.approved = 1 AND (s4_.id IS NULL OR s3_.lock_by_status <> 0) AND s0_.id IN ('ddf201b3-6026-11e9-a435-0242c0a8d002', 'bf77b15a-6026-11e9-a435-0242c0a8d002', '57ab277f-6025-11e9-a435-0242c0a8d002', 'b4d36364-6024-11e9-a435-0242c0a8d002', '22758599-6024-11e9-a435-0242c0a8d002', '6398d4f0-6023-11e9-a435-0242c0a8d002', 'f80bcb0f-6022-11e9-a435-0242c0a8d002', '6aaf2ba1-6022-11e9-a435-0242c0a8d002', 'bf444850-6021-11e9-a435-0242c0a8d002', '497c92c1-6021-11e9-a435-0242c0a8d002', '6afcaddb-6020-11e9-a435-0242c0a8d002', 'a5e5b80d-601f-11e9-a435-0242c0a8d002', '3a7d758f-601f-11e9-a435-0242c0a8d002', '94dc0631-601e-11e9-a435-0242c0a8d002') ORDER BY s0_.created_at DESC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_7
    FROM
      (
        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,
          s2_.id AS id_15,
          s3_.lock_by_status AS lock_by_status_16,
          c4_.approved AS approved_17,
          s0_.dtype AS dtype_18,
          s2_.dtype AS dtype_19
        FROM
          scholar_trainings s0_
          LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id
          INNER JOIN channel_channels c4_ ON s0_.owner_channel_id = c4_.id
          INNER JOIN (
            scholar_shared_trainings s3_
            INNER JOIN scholar_trainings s2_ ON s3_.id = s2_.id
          ) ON (s2_.id = s0_.id)
        WHERE
          s0_.owner_channel_id = ?
          AND (
            s0_.status = ?
            OR s0_.status IS NULL
          )
          AND c4_.approved = ?
          AND (
            s2_.id IS NULL
            OR s3_.lock_by_status <> ?
          )
      ) dctrn_result_inner
    ORDER BY
      created_at_7 DESC
  ) dctrn_result
LIMIT
  16 OFFSET 32

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_7 FROM (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, s2_.id AS id_15, s3_.lock_by_status AS lock_by_status_16, c4_.approved AS approved_17, s0_.dtype AS dtype_18, s2_.dtype AS dtype_19 FROM scholar_trainings s0_ LEFT JOIN scholar_shared_trainings s1_ ON s0_.id = s1_.id INNER JOIN channel_channels c4_ ON s0_.owner_channel_id = c4_.id INNER JOIN (scholar_shared_trainings s3_ INNER JOIN scholar_trainings s2_ ON s3_.id = s2_.id) ON (s2_.id = s0_.id) WHERE s0_.owner_channel_id = 'e231122f-1f18-11e9-8180-00163e87308f' AND (s0_.status = 'published' OR s0_.status IS NULL) AND c4_.approved = 1 AND (s2_.id IS NULL OR s3_.lock_by_status <> 0)) dctrn_result_inner ORDER BY created_at_7 DESC) dctrn_result LIMIT 16 OFFSET 32;

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

SELECT COUNT(*) FROM channel_institution t0 WHERE t0.channel_id = 'e231122f-1f18-11e9-8180-00163e87308f';

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 = 'e231122f-1f18-11e9-8180-00163e87308f';

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
  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.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 = 'e231122f-1f18-11e9-8180-00163e87308f';