Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.token AS token_3,
  t0.expire_at AS expire_at_4,
  t0.is_active AS is_active_5,
  t0.refresh_token AS refresh_token_6,
  t0.rt_expire_at AS rt_expire_at_7,
  t0.short_token AS short_token_8,
  t0.user_id AS user_id_9,
  t0.container_id AS container_id_10
FROM
  access_token t0
WHERE
  t0.token = ?
  AND t0.container_id = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.token AS token_3, t0.expire_at AS expire_at_4, t0.is_active AS is_active_5, t0.refresh_token AS refresh_token_6, t0.rt_expire_at AS rt_expire_at_7, t0.short_token AS short_token_8, t0.user_id AS user_id_9, t0.container_id AS container_id_10 FROM access_token t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjE3NDkwNTUsImV4cCI6MTc2MTgzNTQ1NSwicm9sZXMiOlsiUk9MRV9BRE1JTiJdLCJ1c2VybmFtZSI6InBoaWxpcHBAYWR2YW50aXMudGVjaCIsImlwIjoiODUuNy4xMi4xMDYiLCJjaWQiOjcxLCJjbnRpZCI6MTUzfQ.QmzfXi_Vkpzyvzlj0SZ0IC6P05-73QrpiY3k3Ehx34AKB2_oR0gGWKHej1UuwjAuL07vYeCvTKvH5R8BV5uyyYTqSGAlUePlCBS03C2f4AavVJFLTRFu03QyPvTaPd3RFvCdXDZDP4DI52ya58VFg-5QVlCulx8w5ARnNB0OsKLa5arx9G2WYtXqLWQ1lDLIP0bj6nLhh6lQUQeB62iXdI1m0rxWuox6jM6Jo5fClPDOEaUBynl6VX9MnIahEygeJnEONP-OQn403nxpJU6RVRhadD-k-Q8fQKlTxmKJJx9fcDatWDyJuOrqmq7TKXUc-ykhldFFXVZhplOXyNUsMw' AND t0.container_id = 153 AND t0.is_active = 1 LIMIT 1;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.locale AS locale_5,
  u0_.status AS status_6,
  u0_.company AS company_7,
  u0_.job_title AS job_title_8,
  u0_.image_name AS image_name_9,
  u0_.source AS source_10,
  u0_.is_onboarded AS is_onboarded_11,
  u0_.is_blocked AS is_blocked_12,
  u0_.onboarded_at AS onboarded_at_13,
  u0_.last_login_at AS last_login_at_14,
  u0_.is_display_as_guest AS is_display_as_guest_15,
  u0_.is_expose_email AS is_expose_email_16,
  u0_.is_allow_communication AS is_allow_communication_17,
  u0_.timezone AS timezone_18,
  u0_.is_pwd_generated AS is_pwd_generated_19,
  u0_.is_online AS is_online_20,
  u0_.is_show_disclaimer AS is_show_disclaimer_21,
  u0_.sa_linkedin AS sa_linkedin_22,
  u0_.sa_twitter AS sa_twitter_23,
  u0_.sa_facebook AS sa_facebook_24,
  u0_.sa_instagram AS sa_instagram_25,
  u0_.sa_youtube AS sa_youtube_26,
  u0_.country AS country_27,
  u0_.fail_attempt_count AS fail_attempt_count_28,
  u0_.last_fail_attempt_at AS last_fail_attempt_at_29,
  u0_.login_block_until_at AS login_block_until_at_30,
  u0_.is_consider_speaker AS is_consider_speaker_31,
  u0_.is_consider_moderator AS is_consider_moderator_32,
  u0_.is_show_public AS is_show_public_33,
  u0_.is_notification_assign AS is_notification_assign_34,
  u0_.is_notification_chat AS is_notification_chat_35,
  u0_.is_notification_follow AS is_notification_follow_36,
  u0_.gln_number AS gln_number_37,
  u0_.ord AS ord_38,
  u0_.ord_state AS ord_state_39,
  u0_.is_notification_chat_group AS is_notification_chat_group_40,
  u0_.invite_code AS invite_code_41,
  u0_.headline AS headline_42,
  u0_.user_container_domain AS user_container_domain_43,
  u0_.is_unsubscribed_invite AS is_unsubscribed_invite_44,
  u0_.is_email_off AS is_email_off_45,
  u0_.created_at AS created_at_46,
  u0_.updated_at AS updated_at_47,
  r1_.id AS id_48,
  r1_.role AS role_49,
  u0_.client_id AS client_id_50,
  u0_.relation_manager_id AS relation_manager_id_51,
  u0_.user_container_id AS user_container_id_52,
  u0_.organization_id AS organization_id_53,
  r1_.container_id AS container_id_54,
  r1_.user_id AS user_id_55
FROM
  user u0_
  LEFT JOIN role_container r1_ ON u0_.id = r1_.user_id
WHERE
  u0_.client_id = ?
  AND u0_.email = ?
  AND r1_.container_id = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.locale AS locale_5, u0_.status AS status_6, u0_.company AS company_7, u0_.job_title AS job_title_8, u0_.image_name AS image_name_9, u0_.source AS source_10, u0_.is_onboarded AS is_onboarded_11, u0_.is_blocked AS is_blocked_12, u0_.onboarded_at AS onboarded_at_13, u0_.last_login_at AS last_login_at_14, u0_.is_display_as_guest AS is_display_as_guest_15, u0_.is_expose_email AS is_expose_email_16, u0_.is_allow_communication AS is_allow_communication_17, u0_.timezone AS timezone_18, u0_.is_pwd_generated AS is_pwd_generated_19, u0_.is_online AS is_online_20, u0_.is_show_disclaimer AS is_show_disclaimer_21, u0_.sa_linkedin AS sa_linkedin_22, u0_.sa_twitter AS sa_twitter_23, u0_.sa_facebook AS sa_facebook_24, u0_.sa_instagram AS sa_instagram_25, u0_.sa_youtube AS sa_youtube_26, u0_.country AS country_27, u0_.fail_attempt_count AS fail_attempt_count_28, u0_.last_fail_attempt_at AS last_fail_attempt_at_29, u0_.login_block_until_at AS login_block_until_at_30, u0_.is_consider_speaker AS is_consider_speaker_31, u0_.is_consider_moderator AS is_consider_moderator_32, u0_.is_show_public AS is_show_public_33, u0_.is_notification_assign AS is_notification_assign_34, u0_.is_notification_chat AS is_notification_chat_35, u0_.is_notification_follow AS is_notification_follow_36, u0_.gln_number AS gln_number_37, u0_.ord AS ord_38, u0_.ord_state AS ord_state_39, u0_.is_notification_chat_group AS is_notification_chat_group_40, u0_.invite_code AS invite_code_41, u0_.headline AS headline_42, u0_.user_container_domain AS user_container_domain_43, u0_.is_unsubscribed_invite AS is_unsubscribed_invite_44, u0_.is_email_off AS is_email_off_45, u0_.created_at AS created_at_46, u0_.updated_at AS updated_at_47, r1_.id AS id_48, r1_.role AS role_49, u0_.client_id AS client_id_50, u0_.relation_manager_id AS relation_manager_id_51, u0_.user_container_id AS user_container_id_52, u0_.organization_id AS organization_id_53, r1_.container_id AS container_id_54, r1_.user_id AS user_id_55 FROM user u0_ LEFT JOIN role_container r1_ ON u0_.id = r1_.user_id WHERE u0_.client_id = 71 AND u0_.email = 'philipp@advantis.tech' AND r1_.container_id = 153;

SELECT
  c0_.id AS id_0,
  c0_.domain AS domain_1,
  c0_.name AS name_2,
  c0_.container_group AS container_group_3,
  c0_.storage AS storage_4,
  c0_.bucket_key AS bucket_key_5,
  c0_.bucket_secret AS bucket_secret_6,
  c0_.bucket_name AS bucket_name_7,
  c0_.bucket_region AS bucket_region_8,
  c0_.bucket_endpoint AS bucket_endpoint_9,
  c0_.is_active AS is_active_10,
  c0_.configuration AS configuration_11,
  c0_.design_configuration AS design_configuration_12,
  c0_.description AS description_13,
  c0_.image_name AS image_name_14,
  c0_.navigation AS navigation_15,
  c0_.is_live_now AS is_live_now_16,
  c0_.video_gallery_ids AS video_gallery_ids_17,
  c0_.user_static_fields AS user_static_fields_18,
  c0_.logo_image_name AS logo_image_name_19,
  c0_.is_show_public AS is_show_public_20,
  c0_.is_main_container AS is_main_container_21,
  c0_.is_show_public_container AS is_show_public_container_22,
  c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23,
  c0_.old_id AS old_id_24,
  c0_.is_login_container AS is_login_container_25,
  c0_.course_commission AS course_commission_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  u1_.id AS id_29,
  u1_.name AS name_30,
  u1_.is_generated AS is_generated_31,
  u1_.created_at AS created_at_32,
  u1_.updated_at AS updated_at_33,
  c0_.client_id AS client_id_34,
  c0_.container_category_id AS container_category_id_35,
  u1_.client_id AS client_id_36
FROM
  container c0_
  LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id
  LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id
WHERE
  c0_.domain = ?
  OR c0_.domain = ?

SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = 'my.advantis.tech' OR c0_.domain = 'www.my.advantis.tech';

SELECT
  e0_.id AS id_0,
  e0_.ord AS ord_1,
  e0_.color AS color_2,
  e0_.created_at AS created_at_3,
  e0_.updated_at AS updated_at_4,
  e1_.id AS id_5,
  e1_.image_name AS image_name_6,
  e1_.is_registration_required AS is_registration_required_7,
  e1_.is_step_by_step_completion AS is_step_by_step_completion_8,
  e1_.start AS start_9,
  e1_.end AS end_10,
  e1_.duration AS duration_11,
  e1_.is_active AS is_active_12,
  e1_.available_start AS available_start_13,
  e1_.available_end AS available_end_14,
  e1_.course_index AS course_index_15,
  e1_.is_show_public AS is_show_public_16,
  e1_.bullet_points AS bullet_points_17,
  e1_.is_certificate AS is_certificate_18,
  e1_.is_show_date AS is_show_date_19,
  e1_.certificate_progress AS certificate_progress_20,
  e1_.original_price AS original_price_21,
  e1_.price AS price_22,
  e1_.total_rating AS total_rating_23,
  e1_.average_rating AS average_rating_24,
  e1_.created_at AS created_at_25,
  e1_.updated_at AS updated_at_26,
  e2_.id AS id_27,
  e2_.ord AS ord_28,
  e2_.created_at AS created_at_29,
  e2_.updated_at AS updated_at_30,
  e3_.id AS id_31,
  e3_.start AS start_32,
  e3_.end AS end_33,
  e3_.duration AS duration_34,
  e3_.is_publised AS is_publised_35,
  e3_.task_type AS task_type_36,
  e3_.video_task_type AS video_task_type_37,
  e3_.stream_type AS stream_type_38,
  e3_.stream_url AS stream_url_39,
  e3_.upload_video AS upload_video_40,
  e3_.general_info AS general_info_41,
  e3_.reminder_before AS reminder_before_42,
  e3_.reminder_after AS reminder_after_43,
  e3_.ord AS ord_44,
  e3_.is_reminder_before AS is_reminder_before_45,
  e3_.is_reminder_after AS is_reminder_after_46,
  e3_.is_show_in_video_library AS is_show_in_video_library_47,
  e3_.image_name AS image_name_48,
  e3_.is_comment_enable AS is_comment_enable_49,
  e3_.bullet_points AS bullet_points_50,
  e3_.task_level AS task_level_51,
  e3_.is_video_complete_required AS is_video_complete_required_52,
  e3_.created_at AS created_at_53,
  e3_.updated_at AS updated_at_54,
  u4_.id AS id_55,
  u4_.email AS email_56,
  u4_.password AS password_57,
  u4_.first_name AS first_name_58,
  u4_.last_name AS last_name_59,
  u4_.locale AS locale_60,
  u4_.status AS status_61,
  u4_.company AS company_62,
  u4_.job_title AS job_title_63,
  u4_.image_name AS image_name_64,
  u4_.source AS source_65,
  u4_.is_onboarded AS is_onboarded_66,
  u4_.is_blocked AS is_blocked_67,
  u4_.onboarded_at AS onboarded_at_68,
  u4_.last_login_at AS last_login_at_69,
  u4_.is_display_as_guest AS is_display_as_guest_70,
  u4_.is_expose_email AS is_expose_email_71,
  u4_.is_allow_communication AS is_allow_communication_72,
  u4_.timezone AS timezone_73,
  u4_.is_pwd_generated AS is_pwd_generated_74,
  u4_.is_online AS is_online_75,
  u4_.is_show_disclaimer AS is_show_disclaimer_76,
  u4_.sa_linkedin AS sa_linkedin_77,
  u4_.sa_twitter AS sa_twitter_78,
  u4_.sa_facebook AS sa_facebook_79,
  u4_.sa_instagram AS sa_instagram_80,
  u4_.sa_youtube AS sa_youtube_81,
  u4_.country AS country_82,
  u4_.fail_attempt_count AS fail_attempt_count_83,
  u4_.last_fail_attempt_at AS last_fail_attempt_at_84,
  u4_.login_block_until_at AS login_block_until_at_85,
  u4_.is_consider_speaker AS is_consider_speaker_86,
  u4_.is_consider_moderator AS is_consider_moderator_87,
  u4_.is_show_public AS is_show_public_88,
  u4_.is_notification_assign AS is_notification_assign_89,
  u4_.is_notification_chat AS is_notification_chat_90,
  u4_.is_notification_follow AS is_notification_follow_91,
  u4_.gln_number AS gln_number_92,
  u4_.ord AS ord_93,
  u4_.ord_state AS ord_state_94,
  u4_.is_notification_chat_group AS is_notification_chat_group_95,
  u4_.invite_code AS invite_code_96,
  u4_.headline AS headline_97,
  u4_.user_container_domain AS user_container_domain_98,
  u4_.is_unsubscribed_invite AS is_unsubscribed_invite_99,
  u4_.is_email_off AS is_email_off_100,
  u4_.created_at AS created_at_101,
  u4_.updated_at AS updated_at_102,
  r5_.id AS id_103,
  r5_.ord AS ord_104,
  a6_.id AS id_105,
  a6_.created_at AS created_at_106,
  a6_.updated_at AS updated_at_107,
  u7_.id AS id_108,
  u7_.email AS email_109,
  u7_.password AS password_110,
  u7_.first_name AS first_name_111,
  u7_.last_name AS last_name_112,
  u7_.locale AS locale_113,
  u7_.status AS status_114,
  u7_.company AS company_115,
  u7_.job_title AS job_title_116,
  u7_.image_name AS image_name_117,
  u7_.source AS source_118,
  u7_.is_onboarded AS is_onboarded_119,
  u7_.is_blocked AS is_blocked_120,
  u7_.onboarded_at AS onboarded_at_121,
  u7_.last_login_at AS last_login_at_122,
  u7_.is_display_as_guest AS is_display_as_guest_123,
  u7_.is_expose_email AS is_expose_email_124,
  u7_.is_allow_communication AS is_allow_communication_125,
  u7_.timezone AS timezone_126,
  u7_.is_pwd_generated AS is_pwd_generated_127,
  u7_.is_online AS is_online_128,
  u7_.is_show_disclaimer AS is_show_disclaimer_129,
  u7_.sa_linkedin AS sa_linkedin_130,
  u7_.sa_twitter AS sa_twitter_131,
  u7_.sa_facebook AS sa_facebook_132,
  u7_.sa_instagram AS sa_instagram_133,
  u7_.sa_youtube AS sa_youtube_134,
  u7_.country AS country_135,
  u7_.fail_attempt_count AS fail_attempt_count_136,
  u7_.last_fail_attempt_at AS last_fail_attempt_at_137,
  u7_.login_block_until_at AS login_block_until_at_138,
  u7_.is_consider_speaker AS is_consider_speaker_139,
  u7_.is_consider_moderator AS is_consider_moderator_140,
  u7_.is_show_public AS is_show_public_141,
  u7_.is_notification_assign AS is_notification_assign_142,
  u7_.is_notification_chat AS is_notification_chat_143,
  u7_.is_notification_follow AS is_notification_follow_144,
  u7_.gln_number AS gln_number_145,
  u7_.ord AS ord_146,
  u7_.ord_state AS ord_state_147,
  u7_.is_notification_chat_group AS is_notification_chat_group_148,
  u7_.invite_code AS invite_code_149,
  u7_.headline AS headline_150,
  u7_.user_container_domain AS user_container_domain_151,
  u7_.is_unsubscribed_invite AS is_unsubscribed_invite_152,
  u7_.is_email_off AS is_email_off_153,
  u7_.created_at AS created_at_154,
  u7_.updated_at AS updated_at_155,
  r8_.id AS id_156,
  r8_.ord AS ord_157,
  a9_.id AS id_158,
  a9_.created_at AS created_at_159,
  a9_.updated_at AS updated_at_160,
  e10_.id AS id_161,
  e10_.passing_point AS passing_point_162,
  e10_.duration AS duration_163,
  e10_.is_show_leader_board AS is_show_leader_board_164,
  e10_.is_allow_show_solution AS is_allow_show_solution_165,
  e10_.is_allow_show_result AS is_allow_show_result_166,
  e10_.is_allow_show_short_result AS is_allow_show_short_result_167,
  e10_.is_allow_re_attempt AS is_allow_re_attempt_168,
  e10_.solution_type AS solution_type_169,
  e10_.is_consider_for_pass AS is_consider_for_pass_170,
  e10_.exam_level AS exam_level_171,
  e10_.ord AS ord_172,
  e10_.start AS start_173,
  e10_.end AS end_174,
  e10_.reminder_before AS reminder_before_175,
  e10_.reminder_after AS reminder_after_176,
  e10_.is_reminder_before AS is_reminder_before_177,
  e10_.is_reminder_after AS is_reminder_after_178,
  e10_.is_allow_random AS is_allow_random_179,
  e10_.is_comment_enable AS is_comment_enable_180,
  e10_.is_review_enable AS is_review_enable_181,
  e10_.is_show_points AS is_show_points_182,
  e10_.bullet_points AS bullet_points_183,
  e10_.is_step_by_step AS is_step_by_step_184,
  e10_.is_auto_result_send AS is_auto_result_send_185,
  e10_.is_only_choice_question AS is_only_choice_question_186,
  e10_.is_only_continue_on_pass AS is_only_continue_on_pass_187,
  e10_.created_at AS created_at_188,
  e10_.updated_at AS updated_at_189,
  v11_.id AS id_190,
  v11_.type AS type_191,
  v11_.type_id AS type_id_192,
  v11_.video_file_name AS video_file_name_193,
  v11_.metadata AS metadata_194,
  v11_.is_active AS is_active_195,
  v11_.image_name AS image_name_196,
  v11_.stream_type AS stream_type_197,
  v11_.total_views AS total_views_198,
  v11_.is_top AS is_top_199,
  v11_.is_show_public AS is_show_public_200,
  v11_.bullet_points AS bullet_points_201,
  v11_.is_comment_enable AS is_comment_enable_202,
  v11_.is_download AS is_download_203,
  v11_.created_at AS created_at_204,
  v11_.updated_at AS updated_at_205,
  c12_.id AS id_206,
  c12_.color AS color_207,
  c12_.text_color AS text_color_208,
  c12_.ord AS ord_209,
  c12_.type AS type_210,
  c12_.image_name AS image_name_211,
  c12_.created_at AS created_at_212,
  c12_.updated_at AS updated_at_213,
  c13_.id AS id_214,
  c13_.color AS color_215,
  c13_.text_color AS text_color_216,
  c13_.ord AS ord_217,
  c13_.type AS type_218,
  c13_.image_name AS image_name_219,
  c13_.created_at AS created_at_220,
  c13_.updated_at AS updated_at_221,
  c14_.id AS id_222,
  c14_.color AS color_223,
  c14_.text_color AS text_color_224,
  c14_.ord AS ord_225,
  c14_.type AS type_226,
  c14_.image_name AS image_name_227,
  c14_.created_at AS created_at_228,
  c14_.updated_at AS updated_at_229,
  e15_.id AS id_230,
  e15_.passing_point AS passing_point_231,
  e15_.duration AS duration_232,
  e15_.is_show_leader_board AS is_show_leader_board_233,
  e15_.is_allow_show_solution AS is_allow_show_solution_234,
  e15_.is_allow_show_result AS is_allow_show_result_235,
  e15_.is_allow_show_short_result AS is_allow_show_short_result_236,
  e15_.is_allow_re_attempt AS is_allow_re_attempt_237,
  e15_.solution_type AS solution_type_238,
  e15_.is_consider_for_pass AS is_consider_for_pass_239,
  e15_.exam_level AS exam_level_240,
  e15_.ord AS ord_241,
  e15_.start AS start_242,
  e15_.end AS end_243,
  e15_.reminder_before AS reminder_before_244,
  e15_.reminder_after AS reminder_after_245,
  e15_.is_reminder_before AS is_reminder_before_246,
  e15_.is_reminder_after AS is_reminder_after_247,
  e15_.is_allow_random AS is_allow_random_248,
  e15_.is_comment_enable AS is_comment_enable_249,
  e15_.is_review_enable AS is_review_enable_250,
  e15_.is_show_points AS is_show_points_251,
  e15_.bullet_points AS bullet_points_252,
  e15_.is_step_by_step AS is_step_by_step_253,
  e15_.is_auto_result_send AS is_auto_result_send_254,
  e15_.is_only_choice_question AS is_only_choice_question_255,
  e15_.is_only_continue_on_pass AS is_only_continue_on_pass_256,
  e15_.created_at AS created_at_257,
  e15_.updated_at AS updated_at_258,
  e16_.id AS id_259,
  e16_.start AS start_260,
  e16_.end AS end_261,
  e16_.duration AS duration_262,
  e16_.is_publised AS is_publised_263,
  e16_.task_type AS task_type_264,
  e16_.video_task_type AS video_task_type_265,
  e16_.stream_type AS stream_type_266,
  e16_.stream_url AS stream_url_267,
  e16_.upload_video AS upload_video_268,
  e16_.general_info AS general_info_269,
  e16_.reminder_before AS reminder_before_270,
  e16_.reminder_after AS reminder_after_271,
  e16_.ord AS ord_272,
  e16_.is_reminder_before AS is_reminder_before_273,
  e16_.is_reminder_after AS is_reminder_after_274,
  e16_.is_show_in_video_library AS is_show_in_video_library_275,
  e16_.image_name AS image_name_276,
  e16_.is_comment_enable AS is_comment_enable_277,
  e16_.bullet_points AS bullet_points_278,
  e16_.task_level AS task_level_279,
  e16_.is_video_complete_required AS is_video_complete_required_280,
  e16_.created_at AS created_at_281,
  e16_.updated_at AS updated_at_282,
  u17_.id AS id_283,
  u17_.email AS email_284,
  u17_.password AS password_285,
  u17_.first_name AS first_name_286,
  u17_.last_name AS last_name_287,
  u17_.locale AS locale_288,
  u17_.status AS status_289,
  u17_.company AS company_290,
  u17_.job_title AS job_title_291,
  u17_.image_name AS image_name_292,
  u17_.source AS source_293,
  u17_.is_onboarded AS is_onboarded_294,
  u17_.is_blocked AS is_blocked_295,
  u17_.onboarded_at AS onboarded_at_296,
  u17_.last_login_at AS last_login_at_297,
  u17_.is_display_as_guest AS is_display_as_guest_298,
  u17_.is_expose_email AS is_expose_email_299,
  u17_.is_allow_communication AS is_allow_communication_300,
  u17_.timezone AS timezone_301,
  u17_.is_pwd_generated AS is_pwd_generated_302,
  u17_.is_online AS is_online_303,
  u17_.is_show_disclaimer AS is_show_disclaimer_304,
  u17_.sa_linkedin AS sa_linkedin_305,
  u17_.sa_twitter AS sa_twitter_306,
  u17_.sa_facebook AS sa_facebook_307,
  u17_.sa_instagram AS sa_instagram_308,
  u17_.sa_youtube AS sa_youtube_309,
  u17_.country AS country_310,
  u17_.fail_attempt_count AS fail_attempt_count_311,
  u17_.last_fail_attempt_at AS last_fail_attempt_at_312,
  u17_.login_block_until_at AS login_block_until_at_313,
  u17_.is_consider_speaker AS is_consider_speaker_314,
  u17_.is_consider_moderator AS is_consider_moderator_315,
  u17_.is_show_public AS is_show_public_316,
  u17_.is_notification_assign AS is_notification_assign_317,
  u17_.is_notification_chat AS is_notification_chat_318,
  u17_.is_notification_follow AS is_notification_follow_319,
  u17_.gln_number AS gln_number_320,
  u17_.ord AS ord_321,
  u17_.ord_state AS ord_state_322,
  u17_.is_notification_chat_group AS is_notification_chat_group_323,
  u17_.invite_code AS invite_code_324,
  u17_.headline AS headline_325,
  u17_.user_container_domain AS user_container_domain_326,
  u17_.is_unsubscribed_invite AS is_unsubscribed_invite_327,
  u17_.is_email_off AS is_email_off_328,
  u17_.created_at AS created_at_329,
  u17_.updated_at AS updated_at_330,
  r18_.id AS id_331,
  r18_.ord AS ord_332,
  a19_.id AS id_333,
  a19_.created_at AS created_at_334,
  a19_.updated_at AS updated_at_335,
  u20_.id AS id_336,
  u20_.email AS email_337,
  u20_.password AS password_338,
  u20_.first_name AS first_name_339,
  u20_.last_name AS last_name_340,
  u20_.locale AS locale_341,
  u20_.status AS status_342,
  u20_.company AS company_343,
  u20_.job_title AS job_title_344,
  u20_.image_name AS image_name_345,
  u20_.source AS source_346,
  u20_.is_onboarded AS is_onboarded_347,
  u20_.is_blocked AS is_blocked_348,
  u20_.onboarded_at AS onboarded_at_349,
  u20_.last_login_at AS last_login_at_350,
  u20_.is_display_as_guest AS is_display_as_guest_351,
  u20_.is_expose_email AS is_expose_email_352,
  u20_.is_allow_communication AS is_allow_communication_353,
  u20_.timezone AS timezone_354,
  u20_.is_pwd_generated AS is_pwd_generated_355,
  u20_.is_online AS is_online_356,
  u20_.is_show_disclaimer AS is_show_disclaimer_357,
  u20_.sa_linkedin AS sa_linkedin_358,
  u20_.sa_twitter AS sa_twitter_359,
  u20_.sa_facebook AS sa_facebook_360,
  u20_.sa_instagram AS sa_instagram_361,
  u20_.sa_youtube AS sa_youtube_362,
  u20_.country AS country_363,
  u20_.fail_attempt_count AS fail_attempt_count_364,
  u20_.last_fail_attempt_at AS last_fail_attempt_at_365,
  u20_.login_block_until_at AS login_block_until_at_366,
  u20_.is_consider_speaker AS is_consider_speaker_367,
  u20_.is_consider_moderator AS is_consider_moderator_368,
  u20_.is_show_public AS is_show_public_369,
  u20_.is_notification_assign AS is_notification_assign_370,
  u20_.is_notification_chat AS is_notification_chat_371,
  u20_.is_notification_follow AS is_notification_follow_372,
  u20_.gln_number AS gln_number_373,
  u20_.ord AS ord_374,
  u20_.ord_state AS ord_state_375,
  u20_.is_notification_chat_group AS is_notification_chat_group_376,
  u20_.invite_code AS invite_code_377,
  u20_.headline AS headline_378,
  u20_.user_container_domain AS user_container_domain_379,
  u20_.is_unsubscribed_invite AS is_unsubscribed_invite_380,
  u20_.is_email_off AS is_email_off_381,
  u20_.created_at AS created_at_382,
  u20_.updated_at AS updated_at_383,
  r21_.id AS id_384,
  r21_.ord AS ord_385,
  a22_.id AS id_386,
  a22_.created_at AS created_at_387,
  a22_.updated_at AS updated_at_388,
  e23_.id AS id_389,
  e23_.passing_point AS passing_point_390,
  e23_.duration AS duration_391,
  e23_.is_show_leader_board AS is_show_leader_board_392,
  e23_.is_allow_show_solution AS is_allow_show_solution_393,
  e23_.is_allow_show_result AS is_allow_show_result_394,
  e23_.is_allow_show_short_result AS is_allow_show_short_result_395,
  e23_.is_allow_re_attempt AS is_allow_re_attempt_396,
  e23_.solution_type AS solution_type_397,
  e23_.is_consider_for_pass AS is_consider_for_pass_398,
  e23_.exam_level AS exam_level_399,
  e23_.ord AS ord_400,
  e23_.start AS start_401,
  e23_.end AS end_402,
  e23_.reminder_before AS reminder_before_403,
  e23_.reminder_after AS reminder_after_404,
  e23_.is_reminder_before AS is_reminder_before_405,
  e23_.is_reminder_after AS is_reminder_after_406,
  e23_.is_allow_random AS is_allow_random_407,
  e23_.is_comment_enable AS is_comment_enable_408,
  e23_.is_review_enable AS is_review_enable_409,
  e23_.is_show_points AS is_show_points_410,
  e23_.bullet_points AS bullet_points_411,
  e23_.is_step_by_step AS is_step_by_step_412,
  e23_.is_auto_result_send AS is_auto_result_send_413,
  e23_.is_only_choice_question AS is_only_choice_question_414,
  e23_.is_only_continue_on_pass AS is_only_continue_on_pass_415,
  e23_.created_at AS created_at_416,
  e23_.updated_at AS updated_at_417,
  v24_.id AS id_418,
  v24_.type AS type_419,
  v24_.type_id AS type_id_420,
  v24_.video_file_name AS video_file_name_421,
  v24_.metadata AS metadata_422,
  v24_.is_active AS is_active_423,
  v24_.image_name AS image_name_424,
  v24_.stream_type AS stream_type_425,
  v24_.total_views AS total_views_426,
  v24_.is_top AS is_top_427,
  v24_.is_show_public AS is_show_public_428,
  v24_.bullet_points AS bullet_points_429,
  v24_.is_comment_enable AS is_comment_enable_430,
  v24_.is_download AS is_download_431,
  v24_.created_at AS created_at_432,
  v24_.updated_at AS updated_at_433,
  c25_.id AS id_434,
  c25_.color AS color_435,
  c25_.text_color AS text_color_436,
  c25_.ord AS ord_437,
  c25_.type AS type_438,
  c25_.image_name AS image_name_439,
  c25_.created_at AS created_at_440,
  c25_.updated_at AS updated_at_441,
  c26_.id AS id_442,
  c26_.color AS color_443,
  c26_.text_color AS text_color_444,
  c26_.ord AS ord_445,
  c26_.type AS type_446,
  c26_.image_name AS image_name_447,
  c26_.created_at AS created_at_448,
  c26_.updated_at AS updated_at_449,
  c27_.id AS id_450,
  c27_.color AS color_451,
  c27_.text_color AS text_color_452,
  c27_.ord AS ord_453,
  c27_.type AS type_454,
  c27_.image_name AS image_name_455,
  c27_.created_at AS created_at_456,
  c27_.updated_at AS updated_at_457,
  e28_.id AS id_458,
  e28_.passing_point AS passing_point_459,
  e28_.duration AS duration_460,
  e28_.is_show_leader_board AS is_show_leader_board_461,
  e28_.is_allow_show_solution AS is_allow_show_solution_462,
  e28_.is_allow_show_result AS is_allow_show_result_463,
  e28_.is_allow_show_short_result AS is_allow_show_short_result_464,
  e28_.is_allow_re_attempt AS is_allow_re_attempt_465,
  e28_.solution_type AS solution_type_466,
  e28_.is_consider_for_pass AS is_consider_for_pass_467,
  e28_.exam_level AS exam_level_468,
  e28_.ord AS ord_469,
  e28_.start AS start_470,
  e28_.end AS end_471,
  e28_.reminder_before AS reminder_before_472,
  e28_.reminder_after AS reminder_after_473,
  e28_.is_reminder_before AS is_reminder_before_474,
  e28_.is_reminder_after AS is_reminder_after_475,
  e28_.is_allow_random AS is_allow_random_476,
  e28_.is_comment_enable AS is_comment_enable_477,
  e28_.is_review_enable AS is_review_enable_478,
  e28_.is_show_points AS is_show_points_479,
  e28_.bullet_points AS bullet_points_480,
  e28_.is_step_by_step AS is_step_by_step_481,
  e28_.is_auto_result_send AS is_auto_result_send_482,
  e28_.is_only_choice_question AS is_only_choice_question_483,
  e28_.is_only_continue_on_pass AS is_only_continue_on_pass_484,
  e28_.created_at AS created_at_485,
  e28_.updated_at AS updated_at_486,
  e0_.container_id AS container_id_487,
  e0_.el_course_id AS el_course_id_488,
  e1_.container_id AS container_id_489,
  e1_.el_course_category_id AS el_course_category_id_490,
  e1_.certificate_template_id AS certificate_template_id_491,
  e1_.instructor_id AS instructor_id_492,
  e2_.container_id AS container_id_493,
  e2_.el_lession_id AS el_lession_id_494,
  e2_.el_course_id AS el_course_id_495,
  e3_.session_id AS session_id_496,
  e3_.container_id AS container_id_497,
  e3_.el_lession_topic_id AS el_lession_topic_id_498,
  e3_.el_lession_id AS el_lession_id_499,
  e3_.el_course_id AS el_course_id_500,
  e3_.video_gallery_id AS video_gallery_id_501,
  u4_.client_id AS client_id_502,
  u4_.relation_manager_id AS relation_manager_id_503,
  u4_.user_container_id AS user_container_id_504,
  u4_.organization_id AS organization_id_505,
  r5_.academic_title_id AS academic_title_id_506,
  r5_.user_id AS user_id_507,
  a6_.client_id AS client_id_508,
  u7_.client_id AS client_id_509,
  u7_.relation_manager_id AS relation_manager_id_510,
  u7_.user_container_id AS user_container_id_511,
  u7_.organization_id AS organization_id_512,
  r8_.academic_title_id AS academic_title_id_513,
  r8_.user_id AS user_id_514,
  a9_.client_id AS client_id_515,
  e10_.container_id AS container_id_516,
  e10_.el_task_id AS el_task_id_517,
  e10_.el_lesstion_topic_id AS el_lesstion_topic_id_518,
  e10_.el_lession_id AS el_lession_id_519,
  e10_.el_course_id AS el_course_id_520,
  e10_.el_course_always_id AS el_course_always_id_521,
  v11_.video_gallery_category_id AS video_gallery_category_id_522,
  v11_.container_id AS container_id_523,
  c12_.client_id AS client_id_524,
  c12_.parent_id AS parent_id_525,
  c13_.client_id AS client_id_526,
  c13_.parent_id AS parent_id_527,
  c14_.client_id AS client_id_528,
  c14_.parent_id AS parent_id_529,
  e15_.container_id AS container_id_530,
  e15_.el_task_id AS el_task_id_531,
  e15_.el_lesstion_topic_id AS el_lesstion_topic_id_532,
  e15_.el_lession_id AS el_lession_id_533,
  e15_.el_course_id AS el_course_id_534,
  e15_.el_course_always_id AS el_course_always_id_535,
  e16_.session_id AS session_id_536,
  e16_.container_id AS container_id_537,
  e16_.el_lession_topic_id AS el_lession_topic_id_538,
  e16_.el_lession_id AS el_lession_id_539,
  e16_.el_course_id AS el_course_id_540,
  e16_.video_gallery_id AS video_gallery_id_541,
  u17_.client_id AS client_id_542,
  u17_.relation_manager_id AS relation_manager_id_543,
  u17_.user_container_id AS user_container_id_544,
  u17_.organization_id AS organization_id_545,
  r18_.academic_title_id AS academic_title_id_546,
  r18_.user_id AS user_id_547,
  a19_.client_id AS client_id_548,
  u20_.client_id AS client_id_549,
  u20_.relation_manager_id AS relation_manager_id_550,
  u20_.user_container_id AS user_container_id_551,
  u20_.organization_id AS organization_id_552,
  r21_.academic_title_id AS academic_title_id_553,
  r21_.user_id AS user_id_554,
  a22_.client_id AS client_id_555,
  e23_.container_id AS container_id_556,
  e23_.el_task_id AS el_task_id_557,
  e23_.el_lesstion_topic_id AS el_lesstion_topic_id_558,
  e23_.el_lession_id AS el_lession_id_559,
  e23_.el_course_id AS el_course_id_560,
  e23_.el_course_always_id AS el_course_always_id_561,
  v24_.video_gallery_category_id AS video_gallery_category_id_562,
  v24_.container_id AS container_id_563,
  c25_.client_id AS client_id_564,
  c25_.parent_id AS parent_id_565,
  c26_.client_id AS client_id_566,
  c26_.parent_id AS parent_id_567,
  c27_.client_id AS client_id_568,
  c27_.parent_id AS parent_id_569,
  e28_.container_id AS container_id_570,
  e28_.el_task_id AS el_task_id_571,
  e28_.el_lesstion_topic_id AS el_lesstion_topic_id_572,
  e28_.el_lession_id AS el_lession_id_573,
  e28_.el_course_id AS el_course_id_574,
  e28_.el_course_always_id AS el_course_always_id_575
FROM
  el_lession e0_
  INNER JOIN el_course e1_ ON e0_.el_course_id = e1_.id
  LEFT JOIN el_lession_topic e2_ ON e0_.id = e2_.el_lession_id
  LEFT JOIN el_task e3_ ON e2_.id = e3_.el_lession_topic_id
  LEFT JOIN rel_eltask_speaker r29_ ON e3_.id = r29_.el_task_id
  LEFT JOIN user u4_ ON u4_.id = r29_.user_id
  LEFT JOIN rel_user_academic_title r5_ ON u4_.id = r5_.user_id
  LEFT JOIN academic_title a6_ ON r5_.academic_title_id = a6_.id
  LEFT JOIN rel_eltask_expert r30_ ON e3_.id = r30_.el_task_id
  LEFT JOIN user u7_ ON u7_.id = r30_.user_id
  LEFT JOIN rel_user_academic_title r8_ ON u7_.id = r8_.user_id
  LEFT JOIN academic_title a9_ ON r8_.academic_title_id = a9_.id
  LEFT JOIN el_exam e10_ ON e3_.id = e10_.el_task_id
  LEFT JOIN video_gallery v11_ ON e3_.video_gallery_id = v11_.id
  LEFT JOIN common_category c12_ ON v11_.video_gallery_category_id = c12_.id
  LEFT JOIN common_category c13_ ON c12_.parent_id = c13_.id
  LEFT JOIN common_category c14_ ON c12_.id = c14_.parent_id
  LEFT JOIN el_exam e15_ ON e2_.id = e15_.el_lesstion_topic_id
  LEFT JOIN el_task e16_ ON e0_.id = e16_.el_lession_id
  LEFT JOIN rel_eltask_speaker r31_ ON e16_.id = r31_.el_task_id
  LEFT JOIN user u17_ ON u17_.id = r31_.user_id
  LEFT JOIN rel_user_academic_title r18_ ON u17_.id = r18_.user_id
  LEFT JOIN academic_title a19_ ON r18_.academic_title_id = a19_.id
  LEFT JOIN rel_eltask_expert r32_ ON e16_.id = r32_.el_task_id
  LEFT JOIN user u20_ ON u20_.id = r32_.user_id
  LEFT JOIN rel_user_academic_title r21_ ON u20_.id = r21_.user_id
  LEFT JOIN academic_title a22_ ON r21_.academic_title_id = a22_.id
  LEFT JOIN el_exam e23_ ON e16_.id = e23_.el_task_id
  LEFT JOIN video_gallery v24_ ON e16_.video_gallery_id = v24_.id
  LEFT JOIN common_category c25_ ON v24_.video_gallery_category_id = c25_.id
  LEFT JOIN common_category c26_ ON c25_.parent_id = c26_.id
  LEFT JOIN common_category c27_ ON c25_.id = c27_.parent_id
  LEFT JOIN el_exam e28_ ON e0_.id = e28_.el_lession_id
WHERE
  e0_.id = ?
ORDER BY
  u4_.last_name ASC,
  u7_.last_name ASC,
  u17_.last_name ASC,
  u20_.last_name ASC