| 1 |
0.21 ms |
SELECT t0.email AS email_1, t0.login AS login_2, t0.display_password AS display_password_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.last_login AS last_login_7, t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8, t0.name AS name_9, t0.phone AS phone_10, t0.phone_webinar AS phone_webinar_11, t0.city AS city_12, t0.sex AS sex_13, t0.timezone AS timezone_14, t0.about_self AS about_self_15, t0.last_active_at AS last_active_at_16, t0.change_password_token AS change_password_token_17, t0.user_change_password AS user_change_password_18, t0.last_change_email_date AS last_change_email_date_19, t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20, t0.union_auth_key AS union_auth_key_21, t0.related_services AS related_services_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.uuid AS uuid_26, t0.avatar_id AS avatar_id_27, t28.name AS name_29, t28.type AS type_30, t28.mime AS mime_31, t28.bucket AS bucket_32, t28.path AS path_33, t28.dir AS dir_34, t28.size AS size_35, t28.chunked AS chunked_36, t28.chunked_metadata AS chunked_metadata_37, t28.chunked_token AS chunked_token_38, t28.entity_owner_name AS entity_owner_name_39, t28.entity_owner_id AS entity_owner_id_40, t28.kinescope_id AS kinescope_id_41, t28.kinescope_short_id AS kinescope_short_id_42, t28.audio_time AS audio_time_43, t28.audio_average_frequency AS audio_average_frequency_44, t28.multipart_upload_id AS multipart_upload_id_45, t28.restore_information AS restore_information_46, t28.deleted AS deleted_47, t28.deleted_at AS deleted_at_48, t28.path_deleted AS path_deleted_49, t28.id AS id_50, t28.create_at AS create_at_51, t28.update_at AS update_at_52, t28.uuid AS uuid_53, t28.school_id AS school_id_54, t28.lesson_module_file_id AS lesson_module_file_id_55, t28.homework_answer_audio_id AS homework_answer_audio_id_56, t28.question_fail_comment_file_id AS question_fail_comment_file_id_57, t28.question_success_comment_file_id AS question_success_comment_file_id_58, t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59, t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60, t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61, t28.answer_select_comment_file_id AS answer_select_comment_file_id_62, t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63, t28.answer_comment_file_id AS answer_comment_file_id_64 FROM users t0 LEFT JOIN file t28 ON t0.avatar_id = t28.id WHERE t0.uuid = ? LIMIT 1
Parameters: [
"d00efc1d-8022-4d38-ac0e-0713420d962e"
]
SELECT
t0.email AS email_1,
t0.login AS login_2,
t0.display_password AS display_password_3,
t0.roles AS roles_4,
t0.password AS password_5,
t0.active AS active_6,
t0.last_login AS last_login_7,
t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8,
t0.name AS name_9,
t0.phone AS phone_10,
t0.phone_webinar AS phone_webinar_11,
t0.city AS city_12,
t0.sex AS sex_13,
t0.timezone AS timezone_14,
t0.about_self AS about_self_15,
t0.last_active_at AS last_active_at_16,
t0.change_password_token AS change_password_token_17,
t0.user_change_password AS user_change_password_18,
t0.last_change_email_date AS last_change_email_date_19,
t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20,
t0.union_auth_key AS union_auth_key_21,
t0.related_services AS related_services_22,
t0.id AS id_23,
t0.create_at AS create_at_24,
t0.update_at AS update_at_25,
t0.uuid AS uuid_26,
t0.avatar_id AS avatar_id_27,
t28.name AS name_29,
t28.type AS type_30,
t28.mime AS mime_31,
t28.bucket AS bucket_32,
t28.path AS path_33,
t28.dir AS dir_34,
t28.size AS size_35,
t28.chunked AS chunked_36,
t28.chunked_metadata AS chunked_metadata_37,
t28.chunked_token AS chunked_token_38,
t28.entity_owner_name AS entity_owner_name_39,
t28.entity_owner_id AS entity_owner_id_40,
t28.kinescope_id AS kinescope_id_41,
t28.kinescope_short_id AS kinescope_short_id_42,
t28.audio_time AS audio_time_43,
t28.audio_average_frequency AS audio_average_frequency_44,
t28.multipart_upload_id AS multipart_upload_id_45,
t28.restore_information AS restore_information_46,
t28.deleted AS deleted_47,
t28.deleted_at AS deleted_at_48,
t28.path_deleted AS path_deleted_49,
t28.id AS id_50,
t28.create_at AS create_at_51,
t28.update_at AS update_at_52,
t28.uuid AS uuid_53,
t28.school_id AS school_id_54,
t28.lesson_module_file_id AS lesson_module_file_id_55,
t28.homework_answer_audio_id AS homework_answer_audio_id_56,
t28.question_fail_comment_file_id AS question_fail_comment_file_id_57,
t28.question_success_comment_file_id AS question_success_comment_file_id_58,
t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59,
t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60,
t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61,
t28.answer_select_comment_file_id AS answer_select_comment_file_id_62,
t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63,
t28.answer_comment_file_id AS answer_comment_file_id_64
FROM
users t0
LEFT JOIN file t28 ON t0.avatar_id = t28.id
WHERE
t0.uuid = ?
LIMIT
1
SELECT t0.email AS email_1, t0.login AS login_2, t0.display_password AS display_password_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.last_login AS last_login_7, t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8, t0.name AS name_9, t0.phone AS phone_10, t0.phone_webinar AS phone_webinar_11, t0.city AS city_12, t0.sex AS sex_13, t0.timezone AS timezone_14, t0.about_self AS about_self_15, t0.last_active_at AS last_active_at_16, t0.change_password_token AS change_password_token_17, t0.user_change_password AS user_change_password_18, t0.last_change_email_date AS last_change_email_date_19, t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20, t0.union_auth_key AS union_auth_key_21, t0.related_services AS related_services_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.uuid AS uuid_26, t0.avatar_id AS avatar_id_27, t28.name AS name_29, t28.type AS type_30, t28.mime AS mime_31, t28.bucket AS bucket_32, t28.path AS path_33, t28.dir AS dir_34, t28.size AS size_35, t28.chunked AS chunked_36, t28.chunked_metadata AS chunked_metadata_37, t28.chunked_token AS chunked_token_38, t28.entity_owner_name AS entity_owner_name_39, t28.entity_owner_id AS entity_owner_id_40, t28.kinescope_id AS kinescope_id_41, t28.kinescope_short_id AS kinescope_short_id_42, t28.audio_time AS audio_time_43, t28.audio_average_frequency AS audio_average_frequency_44, t28.multipart_upload_id AS multipart_upload_id_45, t28.restore_information AS restore_information_46, t28.deleted AS deleted_47, t28.deleted_at AS deleted_at_48, t28.path_deleted AS path_deleted_49, t28.id AS id_50, t28.create_at AS create_at_51, t28.update_at AS update_at_52, t28.uuid AS uuid_53, t28.school_id AS school_id_54, t28.lesson_module_file_id AS lesson_module_file_id_55, t28.homework_answer_audio_id AS homework_answer_audio_id_56, t28.question_fail_comment_file_id AS question_fail_comment_file_id_57, t28.question_success_comment_file_id AS question_success_comment_file_id_58, t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59, t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60, t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61, t28.answer_select_comment_file_id AS answer_select_comment_file_id_62, t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63, t28.answer_comment_file_id AS answer_comment_file_id_64 FROM users t0 LEFT JOIN file t28 ON t0.avatar_id = t28.id WHERE t0.uuid = 'd00efc1d-8022-4d38-ac0e-0713420d962e' LIMIT 1;
|
| 2 |
0.16 ms |
SELECT t0.email AS email_1, t0.login AS login_2, t0.display_password AS display_password_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.last_login AS last_login_7, t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8, t0.name AS name_9, t0.phone AS phone_10, t0.phone_webinar AS phone_webinar_11, t0.city AS city_12, t0.sex AS sex_13, t0.timezone AS timezone_14, t0.about_self AS about_self_15, t0.last_active_at AS last_active_at_16, t0.change_password_token AS change_password_token_17, t0.user_change_password AS user_change_password_18, t0.last_change_email_date AS last_change_email_date_19, t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20, t0.union_auth_key AS union_auth_key_21, t0.related_services AS related_services_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.uuid AS uuid_26, t0.avatar_id AS avatar_id_27, t28.name AS name_29, t28.type AS type_30, t28.mime AS mime_31, t28.bucket AS bucket_32, t28.path AS path_33, t28.dir AS dir_34, t28.size AS size_35, t28.chunked AS chunked_36, t28.chunked_metadata AS chunked_metadata_37, t28.chunked_token AS chunked_token_38, t28.entity_owner_name AS entity_owner_name_39, t28.entity_owner_id AS entity_owner_id_40, t28.kinescope_id AS kinescope_id_41, t28.kinescope_short_id AS kinescope_short_id_42, t28.audio_time AS audio_time_43, t28.audio_average_frequency AS audio_average_frequency_44, t28.multipart_upload_id AS multipart_upload_id_45, t28.restore_information AS restore_information_46, t28.deleted AS deleted_47, t28.deleted_at AS deleted_at_48, t28.path_deleted AS path_deleted_49, t28.id AS id_50, t28.create_at AS create_at_51, t28.update_at AS update_at_52, t28.uuid AS uuid_53, t28.school_id AS school_id_54, t28.lesson_module_file_id AS lesson_module_file_id_55, t28.homework_answer_audio_id AS homework_answer_audio_id_56, t28.question_fail_comment_file_id AS question_fail_comment_file_id_57, t28.question_success_comment_file_id AS question_success_comment_file_id_58, t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59, t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60, t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61, t28.answer_select_comment_file_id AS answer_select_comment_file_id_62, t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63, t28.answer_comment_file_id AS answer_comment_file_id_64 FROM users t0 LEFT JOIN file t28 ON t0.avatar_id = t28.id WHERE t0.uuid = ? LIMIT 1
Parameters: [
"d00efc1d-8022-4d38-ac0e-0713420d962e"
]
SELECT
t0.email AS email_1,
t0.login AS login_2,
t0.display_password AS display_password_3,
t0.roles AS roles_4,
t0.password AS password_5,
t0.active AS active_6,
t0.last_login AS last_login_7,
t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8,
t0.name AS name_9,
t0.phone AS phone_10,
t0.phone_webinar AS phone_webinar_11,
t0.city AS city_12,
t0.sex AS sex_13,
t0.timezone AS timezone_14,
t0.about_self AS about_self_15,
t0.last_active_at AS last_active_at_16,
t0.change_password_token AS change_password_token_17,
t0.user_change_password AS user_change_password_18,
t0.last_change_email_date AS last_change_email_date_19,
t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20,
t0.union_auth_key AS union_auth_key_21,
t0.related_services AS related_services_22,
t0.id AS id_23,
t0.create_at AS create_at_24,
t0.update_at AS update_at_25,
t0.uuid AS uuid_26,
t0.avatar_id AS avatar_id_27,
t28.name AS name_29,
t28.type AS type_30,
t28.mime AS mime_31,
t28.bucket AS bucket_32,
t28.path AS path_33,
t28.dir AS dir_34,
t28.size AS size_35,
t28.chunked AS chunked_36,
t28.chunked_metadata AS chunked_metadata_37,
t28.chunked_token AS chunked_token_38,
t28.entity_owner_name AS entity_owner_name_39,
t28.entity_owner_id AS entity_owner_id_40,
t28.kinescope_id AS kinescope_id_41,
t28.kinescope_short_id AS kinescope_short_id_42,
t28.audio_time AS audio_time_43,
t28.audio_average_frequency AS audio_average_frequency_44,
t28.multipart_upload_id AS multipart_upload_id_45,
t28.restore_information AS restore_information_46,
t28.deleted AS deleted_47,
t28.deleted_at AS deleted_at_48,
t28.path_deleted AS path_deleted_49,
t28.id AS id_50,
t28.create_at AS create_at_51,
t28.update_at AS update_at_52,
t28.uuid AS uuid_53,
t28.school_id AS school_id_54,
t28.lesson_module_file_id AS lesson_module_file_id_55,
t28.homework_answer_audio_id AS homework_answer_audio_id_56,
t28.question_fail_comment_file_id AS question_fail_comment_file_id_57,
t28.question_success_comment_file_id AS question_success_comment_file_id_58,
t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59,
t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60,
t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61,
t28.answer_select_comment_file_id AS answer_select_comment_file_id_62,
t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63,
t28.answer_comment_file_id AS answer_comment_file_id_64
FROM
users t0
LEFT JOIN file t28 ON t0.avatar_id = t28.id
WHERE
t0.uuid = ?
LIMIT
1
SELECT t0.email AS email_1, t0.login AS login_2, t0.display_password AS display_password_3, t0.roles AS roles_4, t0.password AS password_5, t0.active AS active_6, t0.last_login AS last_login_7, t0.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_8, t0.name AS name_9, t0.phone AS phone_10, t0.phone_webinar AS phone_webinar_11, t0.city AS city_12, t0.sex AS sex_13, t0.timezone AS timezone_14, t0.about_self AS about_self_15, t0.last_active_at AS last_active_at_16, t0.change_password_token AS change_password_token_17, t0.user_change_password AS user_change_password_18, t0.last_change_email_date AS last_change_email_date_19, t0.unsubscription_email_notify_token AS unsubscription_email_notify_token_20, t0.union_auth_key AS union_auth_key_21, t0.related_services AS related_services_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.uuid AS uuid_26, t0.avatar_id AS avatar_id_27, t28.name AS name_29, t28.type AS type_30, t28.mime AS mime_31, t28.bucket AS bucket_32, t28.path AS path_33, t28.dir AS dir_34, t28.size AS size_35, t28.chunked AS chunked_36, t28.chunked_metadata AS chunked_metadata_37, t28.chunked_token AS chunked_token_38, t28.entity_owner_name AS entity_owner_name_39, t28.entity_owner_id AS entity_owner_id_40, t28.kinescope_id AS kinescope_id_41, t28.kinescope_short_id AS kinescope_short_id_42, t28.audio_time AS audio_time_43, t28.audio_average_frequency AS audio_average_frequency_44, t28.multipart_upload_id AS multipart_upload_id_45, t28.restore_information AS restore_information_46, t28.deleted AS deleted_47, t28.deleted_at AS deleted_at_48, t28.path_deleted AS path_deleted_49, t28.id AS id_50, t28.create_at AS create_at_51, t28.update_at AS update_at_52, t28.uuid AS uuid_53, t28.school_id AS school_id_54, t28.lesson_module_file_id AS lesson_module_file_id_55, t28.homework_answer_audio_id AS homework_answer_audio_id_56, t28.question_fail_comment_file_id AS question_fail_comment_file_id_57, t28.question_success_comment_file_id AS question_success_comment_file_id_58, t28.answer_digit_comment_file_id AS answer_digit_comment_file_id_59, t28.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_60, t28.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_61, t28.answer_select_comment_file_id AS answer_select_comment_file_id_62, t28.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_63, t28.answer_comment_file_id AS answer_comment_file_id_64 FROM users t0 LEFT JOIN file t28 ON t0.avatar_id = t28.id WHERE t0.uuid = 'd00efc1d-8022-4d38-ac0e-0713420d962e' LIMIT 1;
|
| 3 |
0.51 ms |
SELECT s0_.name AS name_0, s0_.default_slug AS default_slug_1, s0_.slug AS slug_2, s0_.domain AS domain_3, s0_.description AS description_4, s0_.primary_color AS primary_color_5, s0_.balance AS balance_6, s0_.amo_company_id AS amo_company_id_7, s0_.amo_register_deal_id AS amo_register_deal_id_8, s0_.roistat AS roistat_9, s0_.tagline AS tagline_10, s0_.kinescope_project_id AS kinescope_project_id_11, s0_.generate_invite_user_id AS generate_invite_user_id_12, s0_.kinescope_player_id AS kinescope_player_id_13, s0_.allow_self_register AS allow_self_register_14, s0_.confirm_registration_code AS confirm_registration_code_15, s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16, s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17, s0_.confirm_registration_finished AS confirm_registration_finished_18, s0_.confirm_registration_skipped AS confirm_registration_skipped_19, s0_.active AS active_20, s0_.storage_size AS storage_size_21, s0_.last_storage_size_calculation AS last_storage_size_calculation_22, s0_.clear_storage_files AS clear_storage_files_23, s0_.cover_dimming AS cover_dimming_24, s0_.cover_mobile_dimming AS cover_mobile_dimming_25, s0_.mobile_cover_type AS mobile_cover_type_26, s0_.disable_clear_storage AS disable_clear_storage_27, s0_.id AS id_28, s0_.create_at AS create_at_29, s0_.update_at AS update_at_30, s0_.sort AS sort_31, s0_.uuid AS uuid_32, s0_.owner_id AS owner_id_33, s0_.logo_id AS logo_id_34, s0_.favicon_id AS favicon_id_35, s0_.avatar_id AS avatar_id_36, s0_.cover_id AS cover_id_37, s0_.mobile_cover_id AS mobile_cover_id_38, s0_.cover_change_id AS cover_change_id_39, s0_.plan_id AS plan_id_40, s0_.subscription_id AS subscription_id_41, s0_.schoolChannel AS schoolChannel_42, s0_.schoolGroup AS schoolGroup_43, s0_.discount_id AS discount_id_44 FROM schools s0_ WHERE s0_.slug = ? OR s0_.default_slug = ? LIMIT 1
Parameters: [
"963174"
"963174"
]
SELECT
s0_.name AS name_0,
s0_.default_slug AS default_slug_1,
s0_.slug AS slug_2,
s0_.domain AS domain_3,
s0_.description AS description_4,
s0_.primary_color AS primary_color_5,
s0_.balance AS balance_6,
s0_.amo_company_id AS amo_company_id_7,
s0_.amo_register_deal_id AS amo_register_deal_id_8,
s0_.roistat AS roistat_9,
s0_.tagline AS tagline_10,
s0_.kinescope_project_id AS kinescope_project_id_11,
s0_.generate_invite_user_id AS generate_invite_user_id_12,
s0_.kinescope_player_id AS kinescope_player_id_13,
s0_.allow_self_register AS allow_self_register_14,
s0_.confirm_registration_code AS confirm_registration_code_15,
s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16,
s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17,
s0_.confirm_registration_finished AS confirm_registration_finished_18,
s0_.confirm_registration_skipped AS confirm_registration_skipped_19,
s0_.active AS active_20,
s0_.storage_size AS storage_size_21,
s0_.last_storage_size_calculation AS last_storage_size_calculation_22,
s0_.clear_storage_files AS clear_storage_files_23,
s0_.cover_dimming AS cover_dimming_24,
s0_.cover_mobile_dimming AS cover_mobile_dimming_25,
s0_.mobile_cover_type AS mobile_cover_type_26,
s0_.disable_clear_storage AS disable_clear_storage_27,
s0_.id AS id_28,
s0_.create_at AS create_at_29,
s0_.update_at AS update_at_30,
s0_.sort AS sort_31,
s0_.uuid AS uuid_32,
s0_.owner_id AS owner_id_33,
s0_.logo_id AS logo_id_34,
s0_.favicon_id AS favicon_id_35,
s0_.avatar_id AS avatar_id_36,
s0_.cover_id AS cover_id_37,
s0_.mobile_cover_id AS mobile_cover_id_38,
s0_.cover_change_id AS cover_change_id_39,
s0_.plan_id AS plan_id_40,
s0_.subscription_id AS subscription_id_41,
s0_.schoolChannel AS schoolChannel_42,
s0_.schoolGroup AS schoolGroup_43,
s0_.discount_id AS discount_id_44
FROM
schools s0_
WHERE
s0_.slug = ?
OR s0_.default_slug = ?
LIMIT
1
SELECT s0_.name AS name_0, s0_.default_slug AS default_slug_1, s0_.slug AS slug_2, s0_.domain AS domain_3, s0_.description AS description_4, s0_.primary_color AS primary_color_5, s0_.balance AS balance_6, s0_.amo_company_id AS amo_company_id_7, s0_.amo_register_deal_id AS amo_register_deal_id_8, s0_.roistat AS roistat_9, s0_.tagline AS tagline_10, s0_.kinescope_project_id AS kinescope_project_id_11, s0_.generate_invite_user_id AS generate_invite_user_id_12, s0_.kinescope_player_id AS kinescope_player_id_13, s0_.allow_self_register AS allow_self_register_14, s0_.confirm_registration_code AS confirm_registration_code_15, s0_.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_16, s0_.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_17, s0_.confirm_registration_finished AS confirm_registration_finished_18, s0_.confirm_registration_skipped AS confirm_registration_skipped_19, s0_.active AS active_20, s0_.storage_size AS storage_size_21, s0_.last_storage_size_calculation AS last_storage_size_calculation_22, s0_.clear_storage_files AS clear_storage_files_23, s0_.cover_dimming AS cover_dimming_24, s0_.cover_mobile_dimming AS cover_mobile_dimming_25, s0_.mobile_cover_type AS mobile_cover_type_26, s0_.disable_clear_storage AS disable_clear_storage_27, s0_.id AS id_28, s0_.create_at AS create_at_29, s0_.update_at AS update_at_30, s0_.sort AS sort_31, s0_.uuid AS uuid_32, s0_.owner_id AS owner_id_33, s0_.logo_id AS logo_id_34, s0_.favicon_id AS favicon_id_35, s0_.avatar_id AS avatar_id_36, s0_.cover_id AS cover_id_37, s0_.mobile_cover_id AS mobile_cover_id_38, s0_.cover_change_id AS cover_change_id_39, s0_.plan_id AS plan_id_40, s0_.subscription_id AS subscription_id_41, s0_.schoolChannel AS schoolChannel_42, s0_.schoolGroup AS schoolGroup_43, s0_.discount_id AS discount_id_44 FROM schools s0_ WHERE s0_.slug = '963174' OR s0_.default_slug = '963174' LIMIT 1;
|
| 4 |
0.39 ms |
SELECT t0.chat_schoolwide_channel AS chat_schoolwide_channel_1, t0.chat_schoolwide_group AS chat_schoolwide_group_2, t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3, t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4, t0.white_label_hide_logo AS white_label_hide_logo_5, t0.hide_app_links_from_email AS hide_app_links_from_email_6, t0.request_missing_user_data AS request_missing_user_data_7, t0.smtp_enabled AS smtp_enabled_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.smtp_username AS smtp_username_11, t0.smtp_password AS smtp_password_12, t0.smtp_from AS smtp_from_13, t0.close_from_search_engines AS close_from_search_engines_14, t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15, t0.custom_css AS custom_css_16, t0.language AS language_17, t0.id AS id_18, t0.create_at AS create_at_19, t0.update_at AS update_at_20, t0.school_id AS school_id_21 FROM school_settings t0 WHERE t0.school_id = ?
SELECT t0.chat_schoolwide_channel AS chat_schoolwide_channel_1, t0.chat_schoolwide_group AS chat_schoolwide_group_2, t0.chat_flow_autocreate_channel AS chat_flow_autocreate_channel_3, t0.chat_flow_autocreate_group AS chat_flow_autocreate_group_4, t0.white_label_hide_logo AS white_label_hide_logo_5, t0.hide_app_links_from_email AS hide_app_links_from_email_6, t0.request_missing_user_data AS request_missing_user_data_7, t0.smtp_enabled AS smtp_enabled_8, t0.smtp_host AS smtp_host_9, t0.smtp_port AS smtp_port_10, t0.smtp_username AS smtp_username_11, t0.smtp_password AS smtp_password_12, t0.smtp_from AS smtp_from_13, t0.close_from_search_engines AS close_from_search_engines_14, t0.close_from_search_engine_custom_domain AS close_from_search_engine_custom_domain_15, t0.custom_css AS custom_css_16, t0.language AS language_17, t0.id AS id_18, t0.create_at AS create_at_19, t0.update_at AS update_at_20, t0.school_id AS school_id_21 FROM school_settings t0 WHERE t0.school_id = 50;
|
| 5 |
0.18 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.mime AS mime_3, t0.bucket AS bucket_4, t0.path AS path_5, t0.dir AS dir_6, t0.size AS size_7, t0.chunked AS chunked_8, t0.chunked_metadata AS chunked_metadata_9, t0.chunked_token AS chunked_token_10, t0.entity_owner_name AS entity_owner_name_11, t0.entity_owner_id AS entity_owner_id_12, t0.kinescope_id AS kinescope_id_13, t0.kinescope_short_id AS kinescope_short_id_14, t0.audio_time AS audio_time_15, t0.audio_average_frequency AS audio_average_frequency_16, t0.multipart_upload_id AS multipart_upload_id_17, t0.restore_information AS restore_information_18, t0.deleted AS deleted_19, t0.deleted_at AS deleted_at_20, t0.path_deleted AS path_deleted_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.uuid AS uuid_25, t0.school_id AS school_id_26, t0.lesson_module_file_id AS lesson_module_file_id_27, t0.homework_answer_audio_id AS homework_answer_audio_id_28, t0.question_fail_comment_file_id AS question_fail_comment_file_id_29, t0.question_success_comment_file_id AS question_success_comment_file_id_30, t0.answer_digit_comment_file_id AS answer_digit_comment_file_id_31, t0.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_32, t0.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_33, t0.answer_select_comment_file_id AS answer_select_comment_file_id_34, t0.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_35, t0.answer_comment_file_id AS answer_comment_file_id_36 FROM file t0 WHERE t0.id IN (?, ?)
SELECT t0.name AS name_1, t0.type AS type_2, t0.mime AS mime_3, t0.bucket AS bucket_4, t0.path AS path_5, t0.dir AS dir_6, t0.size AS size_7, t0.chunked AS chunked_8, t0.chunked_metadata AS chunked_metadata_9, t0.chunked_token AS chunked_token_10, t0.entity_owner_name AS entity_owner_name_11, t0.entity_owner_id AS entity_owner_id_12, t0.kinescope_id AS kinescope_id_13, t0.kinescope_short_id AS kinescope_short_id_14, t0.audio_time AS audio_time_15, t0.audio_average_frequency AS audio_average_frequency_16, t0.multipart_upload_id AS multipart_upload_id_17, t0.restore_information AS restore_information_18, t0.deleted AS deleted_19, t0.deleted_at AS deleted_at_20, t0.path_deleted AS path_deleted_21, t0.id AS id_22, t0.create_at AS create_at_23, t0.update_at AS update_at_24, t0.uuid AS uuid_25, t0.school_id AS school_id_26, t0.lesson_module_file_id AS lesson_module_file_id_27, t0.homework_answer_audio_id AS homework_answer_audio_id_28, t0.question_fail_comment_file_id AS question_fail_comment_file_id_29, t0.question_success_comment_file_id AS question_success_comment_file_id_30, t0.answer_digit_comment_file_id AS answer_digit_comment_file_id_31, t0.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_32, t0.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_33, t0.answer_select_comment_file_id AS answer_select_comment_file_id_34, t0.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_35, t0.answer_comment_file_id AS answer_comment_file_id_36 FROM file t0 WHERE t0.id IN (24, 25);
|
| 6 |
0.63 ms |
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.published AS published_5, t0.closed AS closed_6, t0.price AS price_7, t0.old_price AS old_price_8, t0.custom_payment_link AS custom_payment_link_9, t0.free_first_step AS free_first_step_10, t0.private_status AS private_status_11, t0.includes AS includes_12, t0.show_reviews AS show_reviews_13, t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14, t0.hard_sequence AS hard_sequence_15, t0.use_landing_external_url AS use_landing_external_url_16, t0.landing_external_url AS landing_external_url_17, t0.copy_protected AS copy_protected_18, t0.video_protected AS video_protected_19, t0.enable_certificate AS enable_certificate_20, t0.deleted AS deleted_21, t0.deleted_at AS deleted_at_22, t0.calculation_in_progress AS calculation_in_progress_23, t0.background_dimming AS background_dimming_24, t0.background_mobile_dimming AS background_mobile_dimming_25, t0.mobile_background_type AS mobile_background_type_26, t0.id AS id_27, t0.create_at AS create_at_28, t0.update_at AS update_at_29, t0.sort AS sort_30, t0.uuid AS uuid_31, t0.cover_id AS cover_id_32, t0.background_id AS background_id_33, t0.mobile_background_id AS mobile_background_id_34, t0.school_id AS school_id_35, t0.flow_to_add_id AS flow_to_add_id_36, t0.payment_gateway_id AS payment_gateway_id_37, t0.installment_gateway_id AS installment_gateway_id_38, t39.rules AS rules_40, t39.draw_rules AS draw_rules_41, t39.published_at AS published_at_42, t39.display_share_buttons AS display_share_buttons_43, t39.draw_display_share_buttons AS draw_display_share_buttons_44, t39.title AS title_45, t39.draw_title AS draw_title_46, t39.subtitle AS subtitle_47, t39.draw_subtitle AS draw_subtitle_48, t39.status AS status_49, t39.display_student AS display_student_50, t39.draw_display_student AS draw_display_student_51, t39.id AS id_52, t39.create_at AS create_at_53, t39.update_at AS update_at_54, t39.uuid AS uuid_55, t39.school_id AS school_id_56, t39.course_id AS course_id_57, t39.group_id AS group_id_58, t59.rules AS rules_60, t59.draw_rules AS draw_rules_61, t59.display_share_buttons AS display_share_buttons_62, t59.draw_display_share_buttons AS draw_display_share_buttons_63, t59.status AS status_64, t59.published_at AS published_at_65, t59.id AS id_66, t59.create_at AS create_at_67, t59.update_at AS update_at_68, t59.uuid AS uuid_69, t59.school_id AS school_id_70, t59.course_id AS course_id_71, t59.group_id AS group_id_72, t0.certificate_template_id AS certificate_template_id_73, t0.draw_certificate_template_id AS draw_certificate_template_id_74, t0.course_certificate_template_id AS course_certificate_template_id_75 FROM course t0 LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id WHERE t0.id = ? AND t0.school_id = ? AND t0.deleted = ? LIMIT 1
SELECT
t0.name AS name_1,
t0.slug AS slug_2,
t0.short_description AS short_description_3,
t0.description AS description_4,
t0.published AS published_5,
t0.closed AS closed_6,
t0.price AS price_7,
t0.old_price AS old_price_8,
t0.custom_payment_link AS custom_payment_link_9,
t0.free_first_step AS free_first_step_10,
t0.private_status AS private_status_11,
t0.includes AS includes_12,
t0.show_reviews AS show_reviews_13,
t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14,
t0.hard_sequence AS hard_sequence_15,
t0.use_landing_external_url AS use_landing_external_url_16,
t0.landing_external_url AS landing_external_url_17,
t0.copy_protected AS copy_protected_18,
t0.video_protected AS video_protected_19,
t0.enable_certificate AS enable_certificate_20,
t0.deleted AS deleted_21,
t0.deleted_at AS deleted_at_22,
t0.calculation_in_progress AS calculation_in_progress_23,
t0.background_dimming AS background_dimming_24,
t0.background_mobile_dimming AS background_mobile_dimming_25,
t0.mobile_background_type AS mobile_background_type_26,
t0.id AS id_27,
t0.create_at AS create_at_28,
t0.update_at AS update_at_29,
t0.sort AS sort_30,
t0.uuid AS uuid_31,
t0.cover_id AS cover_id_32,
t0.background_id AS background_id_33,
t0.mobile_background_id AS mobile_background_id_34,
t0.school_id AS school_id_35,
t0.flow_to_add_id AS flow_to_add_id_36,
t0.payment_gateway_id AS payment_gateway_id_37,
t0.installment_gateway_id AS installment_gateway_id_38,
t39.rules AS rules_40,
t39.draw_rules AS draw_rules_41,
t39.published_at AS published_at_42,
t39.display_share_buttons AS display_share_buttons_43,
t39.draw_display_share_buttons AS draw_display_share_buttons_44,
t39.title AS title_45,
t39.draw_title AS draw_title_46,
t39.subtitle AS subtitle_47,
t39.draw_subtitle AS draw_subtitle_48,
t39.status AS status_49,
t39.display_student AS display_student_50,
t39.draw_display_student AS draw_display_student_51,
t39.id AS id_52,
t39.create_at AS create_at_53,
t39.update_at AS update_at_54,
t39.uuid AS uuid_55,
t39.school_id AS school_id_56,
t39.course_id AS course_id_57,
t39.group_id AS group_id_58,
t59.rules AS rules_60,
t59.draw_rules AS draw_rules_61,
t59.display_share_buttons AS display_share_buttons_62,
t59.draw_display_share_buttons AS draw_display_share_buttons_63,
t59.status AS status_64,
t59.published_at AS published_at_65,
t59.id AS id_66,
t59.create_at AS create_at_67,
t59.update_at AS update_at_68,
t59.uuid AS uuid_69,
t59.school_id AS school_id_70,
t59.course_id AS course_id_71,
t59.group_id AS group_id_72,
t0.certificate_template_id AS certificate_template_id_73,
t0.draw_certificate_template_id AS draw_certificate_template_id_74,
t0.course_certificate_template_id AS course_certificate_template_id_75
FROM
course t0
LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id
LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id
WHERE
t0.id = ?
AND t0.school_id = ?
AND t0.deleted = ?
LIMIT
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.published AS published_5, t0.closed AS closed_6, t0.price AS price_7, t0.old_price AS old_price_8, t0.custom_payment_link AS custom_payment_link_9, t0.free_first_step AS free_first_step_10, t0.private_status AS private_status_11, t0.includes AS includes_12, t0.show_reviews AS show_reviews_13, t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14, t0.hard_sequence AS hard_sequence_15, t0.use_landing_external_url AS use_landing_external_url_16, t0.landing_external_url AS landing_external_url_17, t0.copy_protected AS copy_protected_18, t0.video_protected AS video_protected_19, t0.enable_certificate AS enable_certificate_20, t0.deleted AS deleted_21, t0.deleted_at AS deleted_at_22, t0.calculation_in_progress AS calculation_in_progress_23, t0.background_dimming AS background_dimming_24, t0.background_mobile_dimming AS background_mobile_dimming_25, t0.mobile_background_type AS mobile_background_type_26, t0.id AS id_27, t0.create_at AS create_at_28, t0.update_at AS update_at_29, t0.sort AS sort_30, t0.uuid AS uuid_31, t0.cover_id AS cover_id_32, t0.background_id AS background_id_33, t0.mobile_background_id AS mobile_background_id_34, t0.school_id AS school_id_35, t0.flow_to_add_id AS flow_to_add_id_36, t0.payment_gateway_id AS payment_gateway_id_37, t0.installment_gateway_id AS installment_gateway_id_38, t39.rules AS rules_40, t39.draw_rules AS draw_rules_41, t39.published_at AS published_at_42, t39.display_share_buttons AS display_share_buttons_43, t39.draw_display_share_buttons AS draw_display_share_buttons_44, t39.title AS title_45, t39.draw_title AS draw_title_46, t39.subtitle AS subtitle_47, t39.draw_subtitle AS draw_subtitle_48, t39.status AS status_49, t39.display_student AS display_student_50, t39.draw_display_student AS draw_display_student_51, t39.id AS id_52, t39.create_at AS create_at_53, t39.update_at AS update_at_54, t39.uuid AS uuid_55, t39.school_id AS school_id_56, t39.course_id AS course_id_57, t39.group_id AS group_id_58, t59.rules AS rules_60, t59.draw_rules AS draw_rules_61, t59.display_share_buttons AS display_share_buttons_62, t59.draw_display_share_buttons AS draw_display_share_buttons_63, t59.status AS status_64, t59.published_at AS published_at_65, t59.id AS id_66, t59.create_at AS create_at_67, t59.update_at AS update_at_68, t59.uuid AS uuid_69, t59.school_id AS school_id_70, t59.course_id AS course_id_71, t59.group_id AS group_id_72, t0.certificate_template_id AS certificate_template_id_73, t0.draw_certificate_template_id AS draw_certificate_template_id_74, t0.course_certificate_template_id AS course_certificate_template_id_75 FROM course t0 LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id WHERE t0.id = 37 AND t0.school_id = 50 AND t0.deleted = 0 LIMIT 1;
|
| 7 |
0.35 ms |
SELECT t0.code AS code_14, t0.type AS type_15, t0.status AS status_16, t0.error AS error_17, t0.name AS name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.uuid AS uuid_22, t0.school_id AS school_id_23, t0.gateway, t1.shop_id AS shop_id_24, t1.secret_key AS secret_key_25, t1.vat AS vat_26, t2.terminal_key AS terminal_key_27, t2.secret_key AS secret_key_28, t2.taxation AS taxation_29, t2.vat AS vat_30, t3.secret_key AS secret_key_31, t3.url AS url_32, t3.dont_check_payment_sum AS dont_check_payment_sum_33, t4.merchant_id AS merchant_id_34, t4.secret AS secret_35, t4.taxation_system AS taxation_system_36, t4.vat AS vat_37, t5.api_key AS api_key_38, t6.login AS login_39, t6.password AS password_40, t6.secret AS secret_41, t7.login AS login_42, t7.password AS password_43, t7.secret AS secret_44, t8.shop_id AS shop_id_45, t8.secret_key AS secret_key_46, t8.rsa_public_key AS rsa_public_key_47, t9.public_id AS public_id_48, t9.private_key AS private_key_49, t9.country AS country_50, t9.tax_system AS tax_system_51, t9.vat AS vat_52, t10.user_name AS user_name_53, t10.password AS password_54, t10.tax_system AS tax_system_55, t10.tax_type AS tax_type_56, t10.callback_token AS callback_token_57, t11.token AS token_58, t11.client_id AS client_id_59, t11.customer_code AS customer_code_60, t11.merchant_id AS merchant_id_61, t11.tax_system AS tax_system_62, t11.vat AS vat_63, t12.api_key AS api_key_64, t12.payment_options_id AS payment_options_id_65, t12.vat AS vat_66, t13.client_id AS client_id_67, t13.client_secret AS client_secret_68, t13.merchant_authorization AS merchant_authorization_69, t13.vat AS vat_70 FROM payment_gateway t0 LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id WHERE t0.id = ?
SELECT
t0.code AS code_14,
t0.type AS type_15,
t0.status AS status_16,
t0.error AS error_17,
t0.name AS name_18,
t0.id AS id_19,
t0.create_at AS create_at_20,
t0.update_at AS update_at_21,
t0.uuid AS uuid_22,
t0.school_id AS school_id_23,
t0.gateway,
t1.shop_id AS shop_id_24,
t1.secret_key AS secret_key_25,
t1.vat AS vat_26,
t2.terminal_key AS terminal_key_27,
t2.secret_key AS secret_key_28,
t2.taxation AS taxation_29,
t2.vat AS vat_30,
t3.secret_key AS secret_key_31,
t3.url AS url_32,
t3.dont_check_payment_sum AS dont_check_payment_sum_33,
t4.merchant_id AS merchant_id_34,
t4.secret AS secret_35,
t4.taxation_system AS taxation_system_36,
t4.vat AS vat_37,
t5.api_key AS api_key_38,
t6.login AS login_39,
t6.password AS password_40,
t6.secret AS secret_41,
t7.login AS login_42,
t7.password AS password_43,
t7.secret AS secret_44,
t8.shop_id AS shop_id_45,
t8.secret_key AS secret_key_46,
t8.rsa_public_key AS rsa_public_key_47,
t9.public_id AS public_id_48,
t9.private_key AS private_key_49,
t9.country AS country_50,
t9.tax_system AS tax_system_51,
t9.vat AS vat_52,
t10.user_name AS user_name_53,
t10.password AS password_54,
t10.tax_system AS tax_system_55,
t10.tax_type AS tax_type_56,
t10.callback_token AS callback_token_57,
t11.token AS token_58,
t11.client_id AS client_id_59,
t11.customer_code AS customer_code_60,
t11.merchant_id AS merchant_id_61,
t11.tax_system AS tax_system_62,
t11.vat AS vat_63,
t12.api_key AS api_key_64,
t12.payment_options_id AS payment_options_id_65,
t12.vat AS vat_66,
t13.client_id AS client_id_67,
t13.client_secret AS client_secret_68,
t13.merchant_authorization AS merchant_authorization_69,
t13.vat AS vat_70
FROM
payment_gateway t0
LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id
LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id
LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id
LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id
LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id
LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id
LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id
LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id
LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id
LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id
LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id
LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id
LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id
WHERE
t0.id = ?
SELECT t0.code AS code_14, t0.type AS type_15, t0.status AS status_16, t0.error AS error_17, t0.name AS name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.uuid AS uuid_22, t0.school_id AS school_id_23, t0.gateway, t1.shop_id AS shop_id_24, t1.secret_key AS secret_key_25, t1.vat AS vat_26, t2.terminal_key AS terminal_key_27, t2.secret_key AS secret_key_28, t2.taxation AS taxation_29, t2.vat AS vat_30, t3.secret_key AS secret_key_31, t3.url AS url_32, t3.dont_check_payment_sum AS dont_check_payment_sum_33, t4.merchant_id AS merchant_id_34, t4.secret AS secret_35, t4.taxation_system AS taxation_system_36, t4.vat AS vat_37, t5.api_key AS api_key_38, t6.login AS login_39, t6.password AS password_40, t6.secret AS secret_41, t7.login AS login_42, t7.password AS password_43, t7.secret AS secret_44, t8.shop_id AS shop_id_45, t8.secret_key AS secret_key_46, t8.rsa_public_key AS rsa_public_key_47, t9.public_id AS public_id_48, t9.private_key AS private_key_49, t9.country AS country_50, t9.tax_system AS tax_system_51, t9.vat AS vat_52, t10.user_name AS user_name_53, t10.password AS password_54, t10.tax_system AS tax_system_55, t10.tax_type AS tax_type_56, t10.callback_token AS callback_token_57, t11.token AS token_58, t11.client_id AS client_id_59, t11.customer_code AS customer_code_60, t11.merchant_id AS merchant_id_61, t11.tax_system AS tax_system_62, t11.vat AS vat_63, t12.api_key AS api_key_64, t12.payment_options_id AS payment_options_id_65, t12.vat AS vat_66, t13.client_id AS client_id_67, t13.client_secret AS client_secret_68, t13.merchant_authorization AS merchant_authorization_69, t13.vat AS vat_70 FROM payment_gateway t0 LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id WHERE t0.id = 1;
|
| 8 |
0.14 ms |
SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = ? ORDER BY t0.sort ASC
SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = 37 ORDER BY t0.sort ASC;
|
| 9 |
0.37 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.type AS type_3, t0.score AS score_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.lesson_version AS lesson_version_7, t0.published_at AS published_at_8, t0.restored_history_at AS restored_history_at_9, t0.restored_history_from_at AS restored_history_from_at_10, t0.status AS status_11, t0.introduction AS introduction_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.sort AS sort_17, t0.uuid AS uuid_18, t0.step_id AS step_id_19, t20.score_type AS score_type_21, t20.score_right_question AS score_right_question_22, t20.required AS required_23, t20.skipped_questions AS skipped_questions_24, t20.percent_to_complete AS percent_to_complete_25, t20.randomize_questions AS randomize_questions_26, t20.randomize_answers AS randomize_answers_27, t20.show_correct_answers AS show_correct_answers_28, t20.show_correct_answers_type AS show_correct_answers_type_29, t20.use_timer AS use_timer_30, t20.timer AS timer_31, t20.attempts_limit AS attempts_limit_32, t20.use_question_bank AS use_question_bank_33, t20.question_bank_limit AS question_bank_limit_34, t20.id AS id_35, t20.create_at AS create_at_36, t20.update_at AS update_at_37, t20.sort AS sort_38, t20.uuid AS uuid_39, t20.deadline_has_time_limit AS deadline_has_time_limit_40, t20.deadline_type_time_limit AS deadline_type_time_limit_41, t20.deadline_time_limit AS deadline_time_limit_42, t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43, t20.lesson_id AS lesson_id_44, t20.lesson_id_draw AS lesson_id_draw_45, t46.score_type AS score_type_47, t46.score_right_question AS score_right_question_48, t46.required AS required_49, t46.skipped_questions AS skipped_questions_50, t46.percent_to_complete AS percent_to_complete_51, t46.randomize_questions AS randomize_questions_52, t46.randomize_answers AS randomize_answers_53, t46.show_correct_answers AS show_correct_answers_54, t46.show_correct_answers_type AS show_correct_answers_type_55, t46.use_timer AS use_timer_56, t46.timer AS timer_57, t46.attempts_limit AS attempts_limit_58, t46.use_question_bank AS use_question_bank_59, t46.question_bank_limit AS question_bank_limit_60, t46.id AS id_61, t46.create_at AS create_at_62, t46.update_at AS update_at_63, t46.sort AS sort_64, t46.uuid AS uuid_65, t46.deadline_has_time_limit AS deadline_has_time_limit_66, t46.deadline_type_time_limit AS deadline_type_time_limit_67, t46.deadline_time_limit AS deadline_time_limit_68, t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69, t46.lesson_id AS lesson_id_70, t46.lesson_id_draw AS lesson_id_draw_71, t72.content AS content_73, t72.draw_content AS draw_content_74, t72.autoaccept_delay AS autoaccept_delay_75, t72.autoaccept_message AS autoaccept_message_76, t72.id AS id_77, t72.create_at AS create_at_78, t72.update_at AS update_at_79, t72.uuid AS uuid_80, t72.deadline_has_time_limit AS deadline_has_time_limit_81, t72.deadline_type_time_limit AS deadline_type_time_limit_82, t72.deadline_time_limit AS deadline_time_limit_83, t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84, t72.lesson_id AS lesson_id_85, t72.auto_accept_message_user_id AS auto_accept_message_user_id_86, t87.student_notify_first AS student_notify_first_88, t87.student_notify_second AS student_notify_second_89, t87.employee_notify_first AS employee_notify_first_90, t87.employee_notify_second AS employee_notify_second_91, t87.completion_logic AS completion_logic_92, t87.id AS id_93, t87.create_at AS create_at_94, t87.update_at AS update_at_95, t87.sort AS sort_96, t87.uuid AS uuid_97, t87.lesson_id AS lesson_id_98 FROM lesson t0 LEFT JOIN tests t20 ON t20.lesson_id = t0.id LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id LEFT JOIN homework t72 ON t72.lesson_id = t0.id LEFT JOIN webinar t87 ON t87.lesson_id = t0.id WHERE t0.step_id = ? ORDER BY t0.sort ASC
SELECT
t0.name AS name_1,
t0.description AS description_2,
t0.type AS type_3,
t0.score AS score_4,
t0.deleted AS deleted_5,
t0.deleted_at AS deleted_at_6,
t0.lesson_version AS lesson_version_7,
t0.published_at AS published_at_8,
t0.restored_history_at AS restored_history_at_9,
t0.restored_history_from_at AS restored_history_from_at_10,
t0.status AS status_11,
t0.introduction AS introduction_12,
t0.document_id AS document_id_13,
t0.id AS id_14,
t0.create_at AS create_at_15,
t0.update_at AS update_at_16,
t0.sort AS sort_17,
t0.uuid AS uuid_18,
t0.step_id AS step_id_19,
t20.score_type AS score_type_21,
t20.score_right_question AS score_right_question_22,
t20.required AS required_23,
t20.skipped_questions AS skipped_questions_24,
t20.percent_to_complete AS percent_to_complete_25,
t20.randomize_questions AS randomize_questions_26,
t20.randomize_answers AS randomize_answers_27,
t20.show_correct_answers AS show_correct_answers_28,
t20.show_correct_answers_type AS show_correct_answers_type_29,
t20.use_timer AS use_timer_30,
t20.timer AS timer_31,
t20.attempts_limit AS attempts_limit_32,
t20.use_question_bank AS use_question_bank_33,
t20.question_bank_limit AS question_bank_limit_34,
t20.id AS id_35,
t20.create_at AS create_at_36,
t20.update_at AS update_at_37,
t20.sort AS sort_38,
t20.uuid AS uuid_39,
t20.deadline_has_time_limit AS deadline_has_time_limit_40,
t20.deadline_type_time_limit AS deadline_type_time_limit_41,
t20.deadline_time_limit AS deadline_time_limit_42,
t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43,
t20.lesson_id AS lesson_id_44,
t20.lesson_id_draw AS lesson_id_draw_45,
t46.score_type AS score_type_47,
t46.score_right_question AS score_right_question_48,
t46.required AS required_49,
t46.skipped_questions AS skipped_questions_50,
t46.percent_to_complete AS percent_to_complete_51,
t46.randomize_questions AS randomize_questions_52,
t46.randomize_answers AS randomize_answers_53,
t46.show_correct_answers AS show_correct_answers_54,
t46.show_correct_answers_type AS show_correct_answers_type_55,
t46.use_timer AS use_timer_56,
t46.timer AS timer_57,
t46.attempts_limit AS attempts_limit_58,
t46.use_question_bank AS use_question_bank_59,
t46.question_bank_limit AS question_bank_limit_60,
t46.id AS id_61,
t46.create_at AS create_at_62,
t46.update_at AS update_at_63,
t46.sort AS sort_64,
t46.uuid AS uuid_65,
t46.deadline_has_time_limit AS deadline_has_time_limit_66,
t46.deadline_type_time_limit AS deadline_type_time_limit_67,
t46.deadline_time_limit AS deadline_time_limit_68,
t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69,
t46.lesson_id AS lesson_id_70,
t46.lesson_id_draw AS lesson_id_draw_71,
t72.content AS content_73,
t72.draw_content AS draw_content_74,
t72.autoaccept_delay AS autoaccept_delay_75,
t72.autoaccept_message AS autoaccept_message_76,
t72.id AS id_77,
t72.create_at AS create_at_78,
t72.update_at AS update_at_79,
t72.uuid AS uuid_80,
t72.deadline_has_time_limit AS deadline_has_time_limit_81,
t72.deadline_type_time_limit AS deadline_type_time_limit_82,
t72.deadline_time_limit AS deadline_time_limit_83,
t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84,
t72.lesson_id AS lesson_id_85,
t72.auto_accept_message_user_id AS auto_accept_message_user_id_86,
t87.student_notify_first AS student_notify_first_88,
t87.student_notify_second AS student_notify_second_89,
t87.employee_notify_first AS employee_notify_first_90,
t87.employee_notify_second AS employee_notify_second_91,
t87.completion_logic AS completion_logic_92,
t87.id AS id_93,
t87.create_at AS create_at_94,
t87.update_at AS update_at_95,
t87.sort AS sort_96,
t87.uuid AS uuid_97,
t87.lesson_id AS lesson_id_98
FROM
lesson t0
LEFT JOIN tests t20 ON t20.lesson_id = t0.id
LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id
LEFT JOIN homework t72 ON t72.lesson_id = t0.id
LEFT JOIN webinar t87 ON t87.lesson_id = t0.id
WHERE
t0.step_id = ?
ORDER BY
t0.sort ASC
SELECT t0.name AS name_1, t0.description AS description_2, t0.type AS type_3, t0.score AS score_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.lesson_version AS lesson_version_7, t0.published_at AS published_at_8, t0.restored_history_at AS restored_history_at_9, t0.restored_history_from_at AS restored_history_from_at_10, t0.status AS status_11, t0.introduction AS introduction_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.sort AS sort_17, t0.uuid AS uuid_18, t0.step_id AS step_id_19, t20.score_type AS score_type_21, t20.score_right_question AS score_right_question_22, t20.required AS required_23, t20.skipped_questions AS skipped_questions_24, t20.percent_to_complete AS percent_to_complete_25, t20.randomize_questions AS randomize_questions_26, t20.randomize_answers AS randomize_answers_27, t20.show_correct_answers AS show_correct_answers_28, t20.show_correct_answers_type AS show_correct_answers_type_29, t20.use_timer AS use_timer_30, t20.timer AS timer_31, t20.attempts_limit AS attempts_limit_32, t20.use_question_bank AS use_question_bank_33, t20.question_bank_limit AS question_bank_limit_34, t20.id AS id_35, t20.create_at AS create_at_36, t20.update_at AS update_at_37, t20.sort AS sort_38, t20.uuid AS uuid_39, t20.deadline_has_time_limit AS deadline_has_time_limit_40, t20.deadline_type_time_limit AS deadline_type_time_limit_41, t20.deadline_time_limit AS deadline_time_limit_42, t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43, t20.lesson_id AS lesson_id_44, t20.lesson_id_draw AS lesson_id_draw_45, t46.score_type AS score_type_47, t46.score_right_question AS score_right_question_48, t46.required AS required_49, t46.skipped_questions AS skipped_questions_50, t46.percent_to_complete AS percent_to_complete_51, t46.randomize_questions AS randomize_questions_52, t46.randomize_answers AS randomize_answers_53, t46.show_correct_answers AS show_correct_answers_54, t46.show_correct_answers_type AS show_correct_answers_type_55, t46.use_timer AS use_timer_56, t46.timer AS timer_57, t46.attempts_limit AS attempts_limit_58, t46.use_question_bank AS use_question_bank_59, t46.question_bank_limit AS question_bank_limit_60, t46.id AS id_61, t46.create_at AS create_at_62, t46.update_at AS update_at_63, t46.sort AS sort_64, t46.uuid AS uuid_65, t46.deadline_has_time_limit AS deadline_has_time_limit_66, t46.deadline_type_time_limit AS deadline_type_time_limit_67, t46.deadline_time_limit AS deadline_time_limit_68, t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69, t46.lesson_id AS lesson_id_70, t46.lesson_id_draw AS lesson_id_draw_71, t72.content AS content_73, t72.draw_content AS draw_content_74, t72.autoaccept_delay AS autoaccept_delay_75, t72.autoaccept_message AS autoaccept_message_76, t72.id AS id_77, t72.create_at AS create_at_78, t72.update_at AS update_at_79, t72.uuid AS uuid_80, t72.deadline_has_time_limit AS deadline_has_time_limit_81, t72.deadline_type_time_limit AS deadline_type_time_limit_82, t72.deadline_time_limit AS deadline_time_limit_83, t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84, t72.lesson_id AS lesson_id_85, t72.auto_accept_message_user_id AS auto_accept_message_user_id_86, t87.student_notify_first AS student_notify_first_88, t87.student_notify_second AS student_notify_second_89, t87.employee_notify_first AS employee_notify_first_90, t87.employee_notify_second AS employee_notify_second_91, t87.completion_logic AS completion_logic_92, t87.id AS id_93, t87.create_at AS create_at_94, t87.update_at AS update_at_95, t87.sort AS sort_96, t87.uuid AS uuid_97, t87.lesson_id AS lesson_id_98 FROM lesson t0 LEFT JOIN tests t20 ON t20.lesson_id = t0.id LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id LEFT JOIN homework t72 ON t72.lesson_id = t0.id LEFT JOIN webinar t87 ON t87.lesson_id = t0.id WHERE t0.step_id = 31 ORDER BY t0.sort ASC;
|
| 10 |
0.28 ms |
SELECT t0.role AS role_1, t0.last_role AS last_role_2, t0.visibility_in_student_dialogues AS visibility_in_student_dialogues_3, t0.comment AS comment_4, t0.last_course_finished_at AS last_course_finished_at_5, t0.last_active_at AS last_active_at_6, t0.student_status AS student_status_7, t0.student_status_changed_at AS student_status_changed_at_8, t0.webhook_session_end_send AS webhook_session_end_send_9, t0.use_school_custom_employee_role AS use_school_custom_employee_role_10, t0.school_custom_employee_role_actions AS school_custom_employee_role_actions_11, t0.contact_biography AS contact_biography_12, t0.contact_phone AS contact_phone_13, t0.contact_vk AS contact_vk_14, t0.contact_tg AS contact_tg_15, t0.student_profile_name AS student_profile_name_16, t0.employee_all_course_access AS employee_all_course_access_17, t0.sort_student_name AS sort_student_name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.school_id AS school_id_22, t23.name AS name_24, t23.default_slug AS default_slug_25, t23.slug AS slug_26, t23.domain AS domain_27, t23.description AS description_28, t23.primary_color AS primary_color_29, t23.balance AS balance_30, t23.amo_company_id AS amo_company_id_31, t23.amo_register_deal_id AS amo_register_deal_id_32, t23.roistat AS roistat_33, t23.tagline AS tagline_34, t23.kinescope_project_id AS kinescope_project_id_35, t23.generate_invite_user_id AS generate_invite_user_id_36, t23.kinescope_player_id AS kinescope_player_id_37, t23.allow_self_register AS allow_self_register_38, t23.confirm_registration_code AS confirm_registration_code_39, t23.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_40, t23.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_41, t23.confirm_registration_finished AS confirm_registration_finished_42, t23.confirm_registration_skipped AS confirm_registration_skipped_43, t23.active AS active_44, t23.storage_size AS storage_size_45, t23.last_storage_size_calculation AS last_storage_size_calculation_46, t23.clear_storage_files AS clear_storage_files_47, t23.cover_dimming AS cover_dimming_48, t23.cover_mobile_dimming AS cover_mobile_dimming_49, t23.mobile_cover_type AS mobile_cover_type_50, t23.disable_clear_storage AS disable_clear_storage_51, t23.id AS id_52, t23.create_at AS create_at_53, t23.update_at AS update_at_54, t23.sort AS sort_55, t23.uuid AS uuid_56, t23.owner_id AS owner_id_57, t23.logo_id AS logo_id_58, t23.favicon_id AS favicon_id_59, t23.avatar_id AS avatar_id_60, t23.cover_id AS cover_id_61, t23.mobile_cover_id AS mobile_cover_id_62, t23.cover_change_id AS cover_change_id_63, t23.plan_id AS plan_id_64, t23.subscription_id AS subscription_id_65, t23.schoolChannel AS schoolChannel_66, t23.schoolGroup AS schoolGroup_67, t23.discount_id AS discount_id_68, t0.user_id AS user_id_69, t70.email AS email_71, t70.login AS login_72, t70.display_password AS display_password_73, t70.roles AS roles_74, t70.password AS password_75, t70.active AS active_76, t70.last_login AS last_login_77, t70.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_78, t70.name AS name_79, t70.phone AS phone_80, t70.phone_webinar AS phone_webinar_81, t70.city AS city_82, t70.sex AS sex_83, t70.timezone AS timezone_84, t70.about_self AS about_self_85, t70.last_active_at AS last_active_at_86, t70.change_password_token AS change_password_token_87, t70.user_change_password AS user_change_password_88, t70.last_change_email_date AS last_change_email_date_89, t70.unsubscription_email_notify_token AS unsubscription_email_notify_token_90, t70.union_auth_key AS union_auth_key_91, t70.related_services AS related_services_92, t70.id AS id_93, t70.create_at AS create_at_94, t70.update_at AS update_at_95, t70.uuid AS uuid_96, t70.avatar_id AS avatar_id_97, t0.employee_role_id AS employee_role_id_98, t0.student_profile_avatar_id AS student_profile_avatar_id_99, t100.name AS name_101, t100.type AS type_102, t100.mime AS mime_103, t100.bucket AS bucket_104, t100.path AS path_105, t100.dir AS dir_106, t100.size AS size_107, t100.chunked AS chunked_108, t100.chunked_metadata AS chunked_metadata_109, t100.chunked_token AS chunked_token_110, t100.entity_owner_name AS entity_owner_name_111, t100.entity_owner_id AS entity_owner_id_112, t100.kinescope_id AS kinescope_id_113, t100.kinescope_short_id AS kinescope_short_id_114, t100.audio_time AS audio_time_115, t100.audio_average_frequency AS audio_average_frequency_116, t100.multipart_upload_id AS multipart_upload_id_117, t100.restore_information AS restore_information_118, t100.deleted AS deleted_119, t100.deleted_at AS deleted_at_120, t100.path_deleted AS path_deleted_121, t100.id AS id_122, t100.create_at AS create_at_123, t100.update_at AS update_at_124, t100.uuid AS uuid_125, t100.school_id AS school_id_126, t100.lesson_module_file_id AS lesson_module_file_id_127, t100.homework_answer_audio_id AS homework_answer_audio_id_128, t100.question_fail_comment_file_id AS question_fail_comment_file_id_129, t100.question_success_comment_file_id AS question_success_comment_file_id_130, t100.answer_digit_comment_file_id AS answer_digit_comment_file_id_131, t100.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_132, t100.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_133, t100.answer_select_comment_file_id AS answer_select_comment_file_id_134, t100.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_135, t100.answer_comment_file_id AS answer_comment_file_id_136 FROM school_user t0 LEFT JOIN schools t23 ON t0.school_id = t23.id LEFT JOIN users t70 ON t0.user_id = t70.id LEFT JOIN file t100 ON t0.student_profile_avatar_id = t100.id WHERE t0.school_id = ? AND t0.user_id = ?
SELECT
t0.role AS role_1,
t0.last_role AS last_role_2,
t0.visibility_in_student_dialogues AS visibility_in_student_dialogues_3,
t0.comment AS comment_4,
t0.last_course_finished_at AS last_course_finished_at_5,
t0.last_active_at AS last_active_at_6,
t0.student_status AS student_status_7,
t0.student_status_changed_at AS student_status_changed_at_8,
t0.webhook_session_end_send AS webhook_session_end_send_9,
t0.use_school_custom_employee_role AS use_school_custom_employee_role_10,
t0.school_custom_employee_role_actions AS school_custom_employee_role_actions_11,
t0.contact_biography AS contact_biography_12,
t0.contact_phone AS contact_phone_13,
t0.contact_vk AS contact_vk_14,
t0.contact_tg AS contact_tg_15,
t0.student_profile_name AS student_profile_name_16,
t0.employee_all_course_access AS employee_all_course_access_17,
t0.sort_student_name AS sort_student_name_18,
t0.id AS id_19,
t0.create_at AS create_at_20,
t0.update_at AS update_at_21,
t0.school_id AS school_id_22,
t23.name AS name_24,
t23.default_slug AS default_slug_25,
t23.slug AS slug_26,
t23.domain AS domain_27,
t23.description AS description_28,
t23.primary_color AS primary_color_29,
t23.balance AS balance_30,
t23.amo_company_id AS amo_company_id_31,
t23.amo_register_deal_id AS amo_register_deal_id_32,
t23.roistat AS roistat_33,
t23.tagline AS tagline_34,
t23.kinescope_project_id AS kinescope_project_id_35,
t23.generate_invite_user_id AS generate_invite_user_id_36,
t23.kinescope_player_id AS kinescope_player_id_37,
t23.allow_self_register AS allow_self_register_38,
t23.confirm_registration_code AS confirm_registration_code_39,
t23.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_40,
t23.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_41,
t23.confirm_registration_finished AS confirm_registration_finished_42,
t23.confirm_registration_skipped AS confirm_registration_skipped_43,
t23.active AS active_44,
t23.storage_size AS storage_size_45,
t23.last_storage_size_calculation AS last_storage_size_calculation_46,
t23.clear_storage_files AS clear_storage_files_47,
t23.cover_dimming AS cover_dimming_48,
t23.cover_mobile_dimming AS cover_mobile_dimming_49,
t23.mobile_cover_type AS mobile_cover_type_50,
t23.disable_clear_storage AS disable_clear_storage_51,
t23.id AS id_52,
t23.create_at AS create_at_53,
t23.update_at AS update_at_54,
t23.sort AS sort_55,
t23.uuid AS uuid_56,
t23.owner_id AS owner_id_57,
t23.logo_id AS logo_id_58,
t23.favicon_id AS favicon_id_59,
t23.avatar_id AS avatar_id_60,
t23.cover_id AS cover_id_61,
t23.mobile_cover_id AS mobile_cover_id_62,
t23.cover_change_id AS cover_change_id_63,
t23.plan_id AS plan_id_64,
t23.subscription_id AS subscription_id_65,
t23.schoolChannel AS schoolChannel_66,
t23.schoolGroup AS schoolGroup_67,
t23.discount_id AS discount_id_68,
t0.user_id AS user_id_69,
t70.email AS email_71,
t70.login AS login_72,
t70.display_password AS display_password_73,
t70.roles AS roles_74,
t70.password AS password_75,
t70.active AS active_76,
t70.last_login AS last_login_77,
t70.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_78,
t70.name AS name_79,
t70.phone AS phone_80,
t70.phone_webinar AS phone_webinar_81,
t70.city AS city_82,
t70.sex AS sex_83,
t70.timezone AS timezone_84,
t70.about_self AS about_self_85,
t70.last_active_at AS last_active_at_86,
t70.change_password_token AS change_password_token_87,
t70.user_change_password AS user_change_password_88,
t70.last_change_email_date AS last_change_email_date_89,
t70.unsubscription_email_notify_token AS unsubscription_email_notify_token_90,
t70.union_auth_key AS union_auth_key_91,
t70.related_services AS related_services_92,
t70.id AS id_93,
t70.create_at AS create_at_94,
t70.update_at AS update_at_95,
t70.uuid AS uuid_96,
t70.avatar_id AS avatar_id_97,
t0.employee_role_id AS employee_role_id_98,
t0.student_profile_avatar_id AS student_profile_avatar_id_99,
t100.name AS name_101,
t100.type AS type_102,
t100.mime AS mime_103,
t100.bucket AS bucket_104,
t100.path AS path_105,
t100.dir AS dir_106,
t100.size AS size_107,
t100.chunked AS chunked_108,
t100.chunked_metadata AS chunked_metadata_109,
t100.chunked_token AS chunked_token_110,
t100.entity_owner_name AS entity_owner_name_111,
t100.entity_owner_id AS entity_owner_id_112,
t100.kinescope_id AS kinescope_id_113,
t100.kinescope_short_id AS kinescope_short_id_114,
t100.audio_time AS audio_time_115,
t100.audio_average_frequency AS audio_average_frequency_116,
t100.multipart_upload_id AS multipart_upload_id_117,
t100.restore_information AS restore_information_118,
t100.deleted AS deleted_119,
t100.deleted_at AS deleted_at_120,
t100.path_deleted AS path_deleted_121,
t100.id AS id_122,
t100.create_at AS create_at_123,
t100.update_at AS update_at_124,
t100.uuid AS uuid_125,
t100.school_id AS school_id_126,
t100.lesson_module_file_id AS lesson_module_file_id_127,
t100.homework_answer_audio_id AS homework_answer_audio_id_128,
t100.question_fail_comment_file_id AS question_fail_comment_file_id_129,
t100.question_success_comment_file_id AS question_success_comment_file_id_130,
t100.answer_digit_comment_file_id AS answer_digit_comment_file_id_131,
t100.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_132,
t100.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_133,
t100.answer_select_comment_file_id AS answer_select_comment_file_id_134,
t100.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_135,
t100.answer_comment_file_id AS answer_comment_file_id_136
FROM
school_user t0
LEFT JOIN schools t23 ON t0.school_id = t23.id
LEFT JOIN users t70 ON t0.user_id = t70.id
LEFT JOIN file t100 ON t0.student_profile_avatar_id = t100.id
WHERE
t0.school_id = ?
AND t0.user_id = ?
SELECT t0.role AS role_1, t0.last_role AS last_role_2, t0.visibility_in_student_dialogues AS visibility_in_student_dialogues_3, t0.comment AS comment_4, t0.last_course_finished_at AS last_course_finished_at_5, t0.last_active_at AS last_active_at_6, t0.student_status AS student_status_7, t0.student_status_changed_at AS student_status_changed_at_8, t0.webhook_session_end_send AS webhook_session_end_send_9, t0.use_school_custom_employee_role AS use_school_custom_employee_role_10, t0.school_custom_employee_role_actions AS school_custom_employee_role_actions_11, t0.contact_biography AS contact_biography_12, t0.contact_phone AS contact_phone_13, t0.contact_vk AS contact_vk_14, t0.contact_tg AS contact_tg_15, t0.student_profile_name AS student_profile_name_16, t0.employee_all_course_access AS employee_all_course_access_17, t0.sort_student_name AS sort_student_name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.school_id AS school_id_22, t23.name AS name_24, t23.default_slug AS default_slug_25, t23.slug AS slug_26, t23.domain AS domain_27, t23.description AS description_28, t23.primary_color AS primary_color_29, t23.balance AS balance_30, t23.amo_company_id AS amo_company_id_31, t23.amo_register_deal_id AS amo_register_deal_id_32, t23.roistat AS roistat_33, t23.tagline AS tagline_34, t23.kinescope_project_id AS kinescope_project_id_35, t23.generate_invite_user_id AS generate_invite_user_id_36, t23.kinescope_player_id AS kinescope_player_id_37, t23.allow_self_register AS allow_self_register_38, t23.confirm_registration_code AS confirm_registration_code_39, t23.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_40, t23.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_41, t23.confirm_registration_finished AS confirm_registration_finished_42, t23.confirm_registration_skipped AS confirm_registration_skipped_43, t23.active AS active_44, t23.storage_size AS storage_size_45, t23.last_storage_size_calculation AS last_storage_size_calculation_46, t23.clear_storage_files AS clear_storage_files_47, t23.cover_dimming AS cover_dimming_48, t23.cover_mobile_dimming AS cover_mobile_dimming_49, t23.mobile_cover_type AS mobile_cover_type_50, t23.disable_clear_storage AS disable_clear_storage_51, t23.id AS id_52, t23.create_at AS create_at_53, t23.update_at AS update_at_54, t23.sort AS sort_55, t23.uuid AS uuid_56, t23.owner_id AS owner_id_57, t23.logo_id AS logo_id_58, t23.favicon_id AS favicon_id_59, t23.avatar_id AS avatar_id_60, t23.cover_id AS cover_id_61, t23.mobile_cover_id AS mobile_cover_id_62, t23.cover_change_id AS cover_change_id_63, t23.plan_id AS plan_id_64, t23.subscription_id AS subscription_id_65, t23.schoolChannel AS schoolChannel_66, t23.schoolGroup AS schoolGroup_67, t23.discount_id AS discount_id_68, t0.user_id AS user_id_69, t70.email AS email_71, t70.login AS login_72, t70.display_password AS display_password_73, t70.roles AS roles_74, t70.password AS password_75, t70.active AS active_76, t70.last_login AS last_login_77, t70.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_78, t70.name AS name_79, t70.phone AS phone_80, t70.phone_webinar AS phone_webinar_81, t70.city AS city_82, t70.sex AS sex_83, t70.timezone AS timezone_84, t70.about_self AS about_self_85, t70.last_active_at AS last_active_at_86, t70.change_password_token AS change_password_token_87, t70.user_change_password AS user_change_password_88, t70.last_change_email_date AS last_change_email_date_89, t70.unsubscription_email_notify_token AS unsubscription_email_notify_token_90, t70.union_auth_key AS union_auth_key_91, t70.related_services AS related_services_92, t70.id AS id_93, t70.create_at AS create_at_94, t70.update_at AS update_at_95, t70.uuid AS uuid_96, t70.avatar_id AS avatar_id_97, t0.employee_role_id AS employee_role_id_98, t0.student_profile_avatar_id AS student_profile_avatar_id_99, t100.name AS name_101, t100.type AS type_102, t100.mime AS mime_103, t100.bucket AS bucket_104, t100.path AS path_105, t100.dir AS dir_106, t100.size AS size_107, t100.chunked AS chunked_108, t100.chunked_metadata AS chunked_metadata_109, t100.chunked_token AS chunked_token_110, t100.entity_owner_name AS entity_owner_name_111, t100.entity_owner_id AS entity_owner_id_112, t100.kinescope_id AS kinescope_id_113, t100.kinescope_short_id AS kinescope_short_id_114, t100.audio_time AS audio_time_115, t100.audio_average_frequency AS audio_average_frequency_116, t100.multipart_upload_id AS multipart_upload_id_117, t100.restore_information AS restore_information_118, t100.deleted AS deleted_119, t100.deleted_at AS deleted_at_120, t100.path_deleted AS path_deleted_121, t100.id AS id_122, t100.create_at AS create_at_123, t100.update_at AS update_at_124, t100.uuid AS uuid_125, t100.school_id AS school_id_126, t100.lesson_module_file_id AS lesson_module_file_id_127, t100.homework_answer_audio_id AS homework_answer_audio_id_128, t100.question_fail_comment_file_id AS question_fail_comment_file_id_129, t100.question_success_comment_file_id AS question_success_comment_file_id_130, t100.answer_digit_comment_file_id AS answer_digit_comment_file_id_131, t100.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_132, t100.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_133, t100.answer_select_comment_file_id AS answer_select_comment_file_id_134, t100.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_135, t100.answer_comment_file_id AS answer_comment_file_id_136 FROM school_user t0 LEFT JOIN schools t23 ON t0.school_id = t23.id LEFT JOIN users t70 ON t0.user_id = t70.id LEFT JOIN file t100 ON t0.student_profile_avatar_id = t100.id WHERE t0.school_id = 50 AND t0.user_id = 5907;
|