Symfony Profiler

Query Metrics

33 Database Queries

26 Different statements

40.93 ms Query time

0 Invalid entities

Queries


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 = ? 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 = ? OR s0_.default_slug = ? LIMIT 1
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.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.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.school_id = ? ORDER BY t0.sort ASC
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 = ?
SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.deleted = ? AND c0_.school_id = ?
SELECT f0_.id AS id_0 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ?
SELECT u0_.id AS id_0, u0_.email AS email_1 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.active = ? GROUP BY u0_.id, u0_.email
SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.school_id = ? AND c0_.deleted = ?
SELECT f0_.id AS id_0, c1_.id AS id_1 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ?
SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND u1_.active = ? AND c0_.role = ? AND c2_.school_id = ? AND c2_.deleted = ?
SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ?
SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC
SELECT count(DISTINCT u0_.id) AS sclr_0 FROM school_user s1_ INNER JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL
SELECT u0_.id AS id_0, MAX(s1_.comment) AS sclr_1, MAX(s1_.student_status) AS sclr_2, MAX(s1_.create_at) AS sclr_3, MAX(s1_.last_course_finished_at) AS sclr_4, MAX(s1_.last_active_at) AS sclr_5, MAX(s1_.sort_student_name) AS sclr_6 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) LEFT JOIN course c4_ ON (c4_.id = c2_.course_id) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL GROUP BY u0_.id ORDER BY sclr_6 ASC, u0_.email ASC, u0_.id ASC LIMIT 20
SELECT u0_.email AS email_0, u0_.login AS login_1, u0_.display_password AS display_password_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.last_login AS last_login_6, u0_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_7, u0_.name AS name_8, u0_.phone AS phone_9, u0_.phone_webinar AS phone_webinar_10, u0_.city AS city_11, u0_.sex AS sex_12, u0_.timezone AS timezone_13, u0_.about_self AS about_self_14, u0_.last_active_at AS last_active_at_15, u0_.change_password_token AS change_password_token_16, u0_.user_change_password AS user_change_password_17, u0_.last_change_email_date AS last_change_email_date_18, u0_.unsubscription_email_notify_token AS unsubscription_email_notify_token_19, u0_.union_auth_key AS union_auth_key_20, u0_.related_services AS related_services_21, u0_.id AS id_22, u0_.create_at AS create_at_23, u0_.update_at AS update_at_24, u0_.uuid AS uuid_25, u0_.avatar_id AS avatar_id_26 FROM users u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT s0_.role AS role_0, s0_.last_role AS last_role_1, s0_.visibility_in_student_dialogues AS visibility_in_student_dialogues_2, s0_.comment AS comment_3, s0_.last_course_finished_at AS last_course_finished_at_4, s0_.last_active_at AS last_active_at_5, s0_.student_status AS student_status_6, s0_.student_status_changed_at AS student_status_changed_at_7, s0_.webhook_session_end_send AS webhook_session_end_send_8, s0_.use_school_custom_employee_role AS use_school_custom_employee_role_9, s0_.school_custom_employee_role_actions AS school_custom_employee_role_actions_10, s0_.contact_biography AS contact_biography_11, s0_.contact_phone AS contact_phone_12, s0_.contact_vk AS contact_vk_13, s0_.contact_tg AS contact_tg_14, s0_.student_profile_name AS student_profile_name_15, s0_.employee_all_course_access AS employee_all_course_access_16, s0_.sort_student_name AS sort_student_name_17, s0_.id AS id_18, s0_.create_at AS create_at_19, s0_.update_at AS update_at_20, u1_.id AS id_21, f2_.name AS name_22, f2_.type AS type_23, f2_.mime AS mime_24, f2_.bucket AS bucket_25, f2_.path AS path_26, f2_.dir AS dir_27, f2_.size AS size_28, f2_.chunked AS chunked_29, f2_.chunked_metadata AS chunked_metadata_30, f2_.chunked_token AS chunked_token_31, f2_.entity_owner_name AS entity_owner_name_32, f2_.entity_owner_id AS entity_owner_id_33, f2_.kinescope_id AS kinescope_id_34, f2_.kinescope_short_id AS kinescope_short_id_35, f2_.audio_time AS audio_time_36, f2_.audio_average_frequency AS audio_average_frequency_37, f2_.multipart_upload_id AS multipart_upload_id_38, f2_.restore_information AS restore_information_39, f2_.deleted AS deleted_40, f2_.deleted_at AS deleted_at_41, f2_.path_deleted AS path_deleted_42, f2_.id AS id_43, f2_.create_at AS create_at_44, f2_.update_at AS update_at_45, f2_.uuid AS uuid_46, s0_.school_id AS school_id_47, s0_.user_id AS user_id_48, s0_.employee_role_id AS employee_role_id_49, s0_.student_profile_avatar_id AS student_profile_avatar_id_50, u1_.avatar_id AS avatar_id_51, f2_.school_id AS school_id_52, f2_.lesson_module_file_id AS lesson_module_file_id_53, f2_.homework_answer_audio_id AS homework_answer_audio_id_54, f2_.question_fail_comment_file_id AS question_fail_comment_file_id_55, f2_.question_success_comment_file_id AS question_success_comment_file_id_56, f2_.answer_digit_comment_file_id AS answer_digit_comment_file_id_57, f2_.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_58, f2_.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_59, f2_.answer_select_comment_file_id AS answer_select_comment_file_id_60, f2_.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_61, f2_.answer_comment_file_id AS answer_comment_file_id_62 FROM school_user s0_ LEFT JOIN users u1_ ON s0_.user_id = u1_.id LEFT JOIN file f2_ ON s0_.student_profile_avatar_id = f2_.id WHERE s0_.school_id = ? AND s0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, u1_.email AS email_37, u1_.login AS login_38, u1_.display_password AS display_password_39, u1_.roles AS roles_40, u1_.password AS password_41, u1_.active AS active_42, u1_.last_login AS last_login_43, u1_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_44, u1_.name AS name_45, u1_.phone AS phone_46, u1_.phone_webinar AS phone_webinar_47, u1_.city AS city_48, u1_.sex AS sex_49, u1_.timezone AS timezone_50, u1_.about_self AS about_self_51, u1_.last_active_at AS last_active_at_52, u1_.change_password_token AS change_password_token_53, u1_.user_change_password AS user_change_password_54, u1_.last_change_email_date AS last_change_email_date_55, u1_.unsubscription_email_notify_token AS unsubscription_email_notify_token_56, u1_.union_auth_key AS union_auth_key_57, u1_.related_services AS related_services_58, u1_.id AS id_59, u1_.create_at AS create_at_60, u1_.update_at AS update_at_61, u1_.uuid AS uuid_62, c2_.name AS name_63, c2_.slug AS slug_64, c2_.short_description AS short_description_65, c2_.description AS description_66, c2_.published AS published_67, c2_.closed AS closed_68, c2_.price AS price_69, c2_.old_price AS old_price_70, c2_.custom_payment_link AS custom_payment_link_71, c2_.free_first_step AS free_first_step_72, c2_.private_status AS private_status_73, c2_.includes AS includes_74, c2_.show_reviews AS show_reviews_75, c2_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_76, c2_.hard_sequence AS hard_sequence_77, c2_.use_landing_external_url AS use_landing_external_url_78, c2_.landing_external_url AS landing_external_url_79, c2_.copy_protected AS copy_protected_80, c2_.video_protected AS video_protected_81, c2_.enable_certificate AS enable_certificate_82, c2_.deleted AS deleted_83, c2_.deleted_at AS deleted_at_84, c2_.calculation_in_progress AS calculation_in_progress_85, c2_.background_dimming AS background_dimming_86, c2_.background_mobile_dimming AS background_mobile_dimming_87, c2_.mobile_background_type AS mobile_background_type_88, c2_.id AS id_89, c2_.create_at AS create_at_90, c2_.update_at AS update_at_91, c2_.sort AS sort_92, c2_.uuid AS uuid_93, c3_.number AS number_94, c3_.fields AS fields_95, c3_.school_name AS school_name_96, c3_.course_name AS course_name_97, c3_.group_name AS group_name_98, c3_.user_name AS user_name_99, c3_.template_name AS template_name_100, c3_.primary_color AS primary_color_101, c3_.id AS id_102, c3_.create_at AS create_at_103, c3_.update_at AS update_at_104, c3_.uuid AS uuid_105, f4_.name AS name_106, f4_.user_limit AS user_limit_107, f4_.homework_block AS homework_block_108, f4_.dialogue_with_employees_block AS dialogue_with_employees_block_109, f4_.lessons_access AS lessons_access_110, f4_.hard_sequence AS hard_sequence_111, f4_.hard_sequence_homework AS hard_sequence_homework_112, f4_.hard_sequence_test AS hard_sequence_test_113, f4_.enable_certificate AS enable_certificate_114, f4_.limit_students AS limit_students_115, f4_.display_unavailable_lesson_student AS display_unavailable_lesson_student_116, f4_.id AS id_117, f4_.create_at AS create_at_118, f4_.update_at AS update_at_119, f4_.sort AS sort_120, f4_.uuid AS uuid_121, f4_.access_lessons AS access_lessons_122, f4_.access_dates AS access_dates_123, f4_.access_type AS access_type_124, f4_.access_access_opens_for AS access_access_opens_for_125, f4_.access_weekdays AS access_weekdays_126, f4_.access_weekdays_start_date AS access_weekdays_start_date_127, f4_.access_once_for_days_interval AS access_once_for_days_interval_128, f4_.access_once_for_days_start_date AS access_once_for_days_start_date_129, f4_.access_for_time_type AS access_for_time_type_130, f4_.access_for_time_start_date AS access_for_time_start_date_131, f4_.access_for_time_range AS access_for_time_range_132, f4_.access_is_open_for_time AS access_is_open_for_time_133, f4_.access_is_open_for_schedule AS access_is_open_for_schedule_134, f4_.access_for_schedule_type AS access_for_schedule_type_135, f4_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_136, c0_.group_id AS group_id_137, c0_.course_id AS course_id_138, c0_.user_id AS user_id_139, c0_.lesson_id AS lesson_id_140, c0_.user_certificate_id AS user_certificate_id_141, c0_.discount_id AS discount_id_142, u1_.avatar_id AS avatar_id_143, c2_.cover_id AS cover_id_144, c2_.background_id AS background_id_145, c2_.mobile_background_id AS mobile_background_id_146, c2_.school_id AS school_id_147, c2_.flow_to_add_id AS flow_to_add_id_148, c2_.payment_gateway_id AS payment_gateway_id_149, c2_.installment_gateway_id AS installment_gateway_id_150, c2_.certificate_template_id AS certificate_template_id_151, c2_.draw_certificate_template_id AS draw_certificate_template_id_152, c2_.course_certificate_template_id AS course_certificate_template_id_153, c3_.school_id AS school_id_154, c3_.course_id AS course_id_155, c3_.course_user_id AS course_user_id_156, c3_.group_id AS group_id_157, c3_.user_id AS user_id_158, c3_.logo_id AS logo_id_159, c3_.background_id AS background_id_160, f4_.course_id AS course_id_161 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id LEFT JOIN course_user_certificate c3_ ON c0_.user_certificate_id = c3_.id LEFT JOIN flow f4_ ON c0_.group_id = f4_.id WHERE c0_.role = ? AND c0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c2_.school_id = ? AND c2_.deleted = ? AND c2_.id IN (?, ?, ?, ?, ?)
SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ?
SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ?
SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ?
SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ?
SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ?
SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ?
SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ?
SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ?
SELECT u0_.uuid AS uuid_0 FROM user_custom_field u0_ WHERE u0_.school_id = ? AND u0_.uuid IN (?, ?, ?, ?, ?, ?, ?)
SELECT u0_.id AS id_0, AVG(c1_.score) AS sclr_1, AVG(c1_.progress) AS sclr_2 FROM course_user c1_ LEFT JOIN course c2_ ON c1_.course_id = c2_.id LEFT JOIN users u0_ ON c1_.user_id = u0_.id WHERE c2_.school_id = ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c1_.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 = ?

#▲	Time	Info
1	0.18 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"`] View formatted query View runnable query Explain query 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.14 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"`] View formatted query View runnable query Explain query 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.17 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"`] View formatted query View runnable query Explain query 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.11 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 = ? Parameters: [`50`] View formatted query View runnable query Explain query 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.10 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 (?, ?) Parameters: [`24 25`] View formatted query View runnable query Explain query 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.42 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.school_id = ? ORDER BY t0.sort ASC Parameters: [`50`] View formatted query View runnable query Explain query 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.school_id = ? ORDER BY t0.sort ASC 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.school_id = 50 ORDER BY t0.sort ASC;
7	0.25 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 = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.20 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 = ? Parameters: [`3`] View formatted query View runnable query Explain query 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 = 3;
9	0.15 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 = ? Parameters: [`4`] View formatted query View runnable query Explain query 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 = 4;
10	0.12 ms	SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.deleted = ? AND c0_.school_id = ? Parameters: [`0 50`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.deleted = ? AND c0_.school_id = ? SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.deleted = 0 AND c0_.school_id = 50;
11	0.12 ms	SELECT f0_.id AS id_0 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ? Parameters: [`0 50`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ? SELECT f0_.id AS id_0 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = 0 AND c1_.school_id = 50;
12	10.19 ms	SELECT u0_.id AS id_0, u0_.email AS email_1 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.active = ? GROUP BY u0_.id, u0_.email Parameters: [`"ROLE_STUDENT" 37 40 42 60 66 50 0 50 "ROLE_STUDENT" 1`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.email AS email_1 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON ( c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?) ) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND ( c3_.school_id = ? AND c3_.deleted = ? ) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.active = ? GROUP BY u0_.id, u0_.email SELECT u0_.id AS id_0, u0_.email AS email_1 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = 'ROLE_STUDENT' AND c2_.course_id IN (37, 40, 42, 60, 66)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = 50 AND c3_.deleted = 0) WHERE s1_.school_id = 50 AND s1_.role = 'ROLE_STUDENT' AND u0_.active = 1 GROUP BY u0_.id, u0_.email;
13	0.18 ms	SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.school_id = ? AND c0_.deleted = ? Parameters: [`50 0`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.school_id = ? AND c0_.deleted = ? SELECT c0_.id AS id_0 FROM course c0_ WHERE c0_.school_id = 50 AND c0_.deleted = 0;
14	0.11 ms	SELECT f0_.id AS id_0, c1_.id AS id_1 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ? Parameters: [`0 50`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, c1_.id AS id_1 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = ? AND c1_.school_id = ? SELECT f0_.id AS id_0, c1_.id AS id_1 FROM flow f0_ LEFT JOIN course c1_ ON f0_.course_id = c1_.id WHERE c1_.deleted = 0 AND c1_.school_id = 50;
15	0.24 ms	SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND u1_.active = ? AND c0_.role = ? AND c2_.school_id = ? AND c2_.deleted = ? Parameters: [`5907 1 "ROLE_TEACHER" 50 0`] View formatted query View runnable query Explain query SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND u1_.active = ? AND c0_.role = ? AND c2_.school_id = ? AND c2_.deleted = ? SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = 5907 AND u1_.active = 1 AND c0_.role = 'ROLE_TEACHER' AND c2_.school_id = 50 AND c2_.deleted = 0;
16	0.09 ms	SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = 1;
17	0.19 ms	SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = 1 ORDER BY t0.sort ASC;
18	9.89 ms	SELECT count(DISTINCT u0_.id) AS sclr_0 FROM school_user s1_ INNER JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL Parameters: [`"ROLE_STUDENT" 37 40 42 60 66 50 0 50 "ROLE_STUDENT"`] View formatted query View runnable query Explain query SELECT count(DISTINCT u0_.id) AS sclr_0 FROM school_user s1_ INNER JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON ( c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?) ) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND ( c3_.school_id = ? AND c3_.deleted = ? ) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL SELECT count(DISTINCT u0_.id) AS sclr_0 FROM school_user s1_ INNER JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = 'ROLE_STUDENT' AND c2_.course_id IN (37, 40, 42, 60, 66)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = 50 AND c3_.deleted = 0) WHERE s1_.school_id = 50 AND s1_.role = 'ROLE_STUDENT' AND u0_.id IS NOT NULL;
19	14.78 ms	SELECT u0_.id AS id_0, MAX(s1_.comment) AS sclr_1, MAX(s1_.student_status) AS sclr_2, MAX(s1_.create_at) AS sclr_3, MAX(s1_.last_course_finished_at) AS sclr_4, MAX(s1_.last_active_at) AS sclr_5, MAX(s1_.sort_student_name) AS sclr_6 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = ? AND c3_.deleted = ?) LEFT JOIN course c4_ ON (c4_.id = c2_.course_id) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL GROUP BY u0_.id ORDER BY sclr_6 ASC, u0_.email ASC, u0_.id ASC LIMIT 20 Parameters: [`"ROLE_STUDENT" 37 40 42 60 66 50 0 50 "ROLE_STUDENT"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, MAX(s1_.comment) AS sclr_1, MAX(s1_.student_status) AS sclr_2, MAX(s1_.create_at) AS sclr_3, MAX(s1_.last_course_finished_at) AS sclr_4, MAX(s1_.last_active_at) AS sclr_5, MAX(s1_.sort_student_name) AS sclr_6 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON ( c2_.user_id = u0_.id AND c2_.role = ? AND c2_.course_id IN (?, ?, ?, ?, ?) ) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND ( c3_.school_id = ? AND c3_.deleted = ? ) LEFT JOIN course c4_ ON (c4_.id = c2_.course_id) WHERE s1_.school_id = ? AND s1_.role = ? AND u0_.id IS NOT NULL GROUP BY u0_.id ORDER BY sclr_6 ASC, u0_.email ASC, u0_.id ASC LIMIT 20 SELECT u0_.id AS id_0, MAX(s1_.comment) AS sclr_1, MAX(s1_.student_status) AS sclr_2, MAX(s1_.create_at) AS sclr_3, MAX(s1_.last_course_finished_at) AS sclr_4, MAX(s1_.last_active_at) AS sclr_5, MAX(s1_.sort_student_name) AS sclr_6 FROM school_user s1_ LEFT JOIN users u0_ ON s1_.user_id = u0_.id LEFT JOIN course_user c2_ ON (c2_.user_id = u0_.id AND c2_.role = 'ROLE_STUDENT' AND c2_.course_id IN (37, 40, 42, 60, 66)) LEFT JOIN course c3_ ON c2_.course_id = c3_.id AND (c3_.school_id = 50 AND c3_.deleted = 0) LEFT JOIN course c4_ ON (c4_.id = c2_.course_id) WHERE s1_.school_id = 50 AND s1_.role = 'ROLE_STUDENT' AND u0_.id IS NOT NULL GROUP BY u0_.id ORDER BY sclr_6 ASC, u0_.email ASC, u0_.id ASC LIMIT 20;
20	0.38 ms	SELECT u0_.email AS email_0, u0_.login AS login_1, u0_.display_password AS display_password_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.last_login AS last_login_6, u0_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_7, u0_.name AS name_8, u0_.phone AS phone_9, u0_.phone_webinar AS phone_webinar_10, u0_.city AS city_11, u0_.sex AS sex_12, u0_.timezone AS timezone_13, u0_.about_self AS about_self_14, u0_.last_active_at AS last_active_at_15, u0_.change_password_token AS change_password_token_16, u0_.user_change_password AS user_change_password_17, u0_.last_change_email_date AS last_change_email_date_18, u0_.unsubscription_email_notify_token AS unsubscription_email_notify_token_19, u0_.union_auth_key AS union_auth_key_20, u0_.related_services AS related_services_21, u0_.id AS id_22, u0_.create_at AS create_at_23, u0_.update_at AS update_at_24, u0_.uuid AS uuid_25, u0_.avatar_id AS avatar_id_26 FROM users u0_ WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`6640 6629 5917 6653 6654 6645 6642 6649 6644 6623 6646 6655 6648 6657 6656 6650 6658 6651 6652 6622`] View formatted query View runnable query Explain query SELECT u0_.email AS email_0, u0_.login AS login_1, u0_.display_password AS display_password_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.last_login AS last_login_6, u0_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_7, u0_.name AS name_8, u0_.phone AS phone_9, u0_.phone_webinar AS phone_webinar_10, u0_.city AS city_11, u0_.sex AS sex_12, u0_.timezone AS timezone_13, u0_.about_self AS about_self_14, u0_.last_active_at AS last_active_at_15, u0_.change_password_token AS change_password_token_16, u0_.user_change_password AS user_change_password_17, u0_.last_change_email_date AS last_change_email_date_18, u0_.unsubscription_email_notify_token AS unsubscription_email_notify_token_19, u0_.union_auth_key AS union_auth_key_20, u0_.related_services AS related_services_21, u0_.id AS id_22, u0_.create_at AS create_at_23, u0_.update_at AS update_at_24, u0_.uuid AS uuid_25, u0_.avatar_id AS avatar_id_26 FROM users u0_ WHERE u0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT u0_.email AS email_0, u0_.login AS login_1, u0_.display_password AS display_password_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.active AS active_5, u0_.last_login AS last_login_6, u0_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_7, u0_.name AS name_8, u0_.phone AS phone_9, u0_.phone_webinar AS phone_webinar_10, u0_.city AS city_11, u0_.sex AS sex_12, u0_.timezone AS timezone_13, u0_.about_self AS about_self_14, u0_.last_active_at AS last_active_at_15, u0_.change_password_token AS change_password_token_16, u0_.user_change_password AS user_change_password_17, u0_.last_change_email_date AS last_change_email_date_18, u0_.unsubscription_email_notify_token AS unsubscription_email_notify_token_19, u0_.union_auth_key AS union_auth_key_20, u0_.related_services AS related_services_21, u0_.id AS id_22, u0_.create_at AS create_at_23, u0_.update_at AS update_at_24, u0_.uuid AS uuid_25, u0_.avatar_id AS avatar_id_26 FROM users u0_ WHERE u0_.id IN (6640, 6629, 5917, 6653, 6654, 6645, 6642, 6649, 6644, 6623, 6646, 6655, 6648, 6657, 6656, 6650, 6658, 6651, 6652, 6622);
21	0.47 ms	SELECT s0_.role AS role_0, s0_.last_role AS last_role_1, s0_.visibility_in_student_dialogues AS visibility_in_student_dialogues_2, s0_.comment AS comment_3, s0_.last_course_finished_at AS last_course_finished_at_4, s0_.last_active_at AS last_active_at_5, s0_.student_status AS student_status_6, s0_.student_status_changed_at AS student_status_changed_at_7, s0_.webhook_session_end_send AS webhook_session_end_send_8, s0_.use_school_custom_employee_role AS use_school_custom_employee_role_9, s0_.school_custom_employee_role_actions AS school_custom_employee_role_actions_10, s0_.contact_biography AS contact_biography_11, s0_.contact_phone AS contact_phone_12, s0_.contact_vk AS contact_vk_13, s0_.contact_tg AS contact_tg_14, s0_.student_profile_name AS student_profile_name_15, s0_.employee_all_course_access AS employee_all_course_access_16, s0_.sort_student_name AS sort_student_name_17, s0_.id AS id_18, s0_.create_at AS create_at_19, s0_.update_at AS update_at_20, u1_.id AS id_21, f2_.name AS name_22, f2_.type AS type_23, f2_.mime AS mime_24, f2_.bucket AS bucket_25, f2_.path AS path_26, f2_.dir AS dir_27, f2_.size AS size_28, f2_.chunked AS chunked_29, f2_.chunked_metadata AS chunked_metadata_30, f2_.chunked_token AS chunked_token_31, f2_.entity_owner_name AS entity_owner_name_32, f2_.entity_owner_id AS entity_owner_id_33, f2_.kinescope_id AS kinescope_id_34, f2_.kinescope_short_id AS kinescope_short_id_35, f2_.audio_time AS audio_time_36, f2_.audio_average_frequency AS audio_average_frequency_37, f2_.multipart_upload_id AS multipart_upload_id_38, f2_.restore_information AS restore_information_39, f2_.deleted AS deleted_40, f2_.deleted_at AS deleted_at_41, f2_.path_deleted AS path_deleted_42, f2_.id AS id_43, f2_.create_at AS create_at_44, f2_.update_at AS update_at_45, f2_.uuid AS uuid_46, s0_.school_id AS school_id_47, s0_.user_id AS user_id_48, s0_.employee_role_id AS employee_role_id_49, s0_.student_profile_avatar_id AS student_profile_avatar_id_50, u1_.avatar_id AS avatar_id_51, f2_.school_id AS school_id_52, f2_.lesson_module_file_id AS lesson_module_file_id_53, f2_.homework_answer_audio_id AS homework_answer_audio_id_54, f2_.question_fail_comment_file_id AS question_fail_comment_file_id_55, f2_.question_success_comment_file_id AS question_success_comment_file_id_56, f2_.answer_digit_comment_file_id AS answer_digit_comment_file_id_57, f2_.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_58, f2_.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_59, f2_.answer_select_comment_file_id AS answer_select_comment_file_id_60, f2_.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_61, f2_.answer_comment_file_id AS answer_comment_file_id_62 FROM school_user s0_ LEFT JOIN users u1_ ON s0_.user_id = u1_.id LEFT JOIN file f2_ ON s0_.student_profile_avatar_id = f2_.id WHERE s0_.school_id = ? AND s0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`50 6640 6629 5917 6653 6654 6645 6642 6649 6644 6623 6646 6655 6648 6657 6656 6650 6658 6651 6652 6622`] View formatted query View runnable query Explain query SELECT s0_.role AS role_0, s0_.last_role AS last_role_1, s0_.visibility_in_student_dialogues AS visibility_in_student_dialogues_2, s0_.comment AS comment_3, s0_.last_course_finished_at AS last_course_finished_at_4, s0_.last_active_at AS last_active_at_5, s0_.student_status AS student_status_6, s0_.student_status_changed_at AS student_status_changed_at_7, s0_.webhook_session_end_send AS webhook_session_end_send_8, s0_.use_school_custom_employee_role AS use_school_custom_employee_role_9, s0_.school_custom_employee_role_actions AS school_custom_employee_role_actions_10, s0_.contact_biography AS contact_biography_11, s0_.contact_phone AS contact_phone_12, s0_.contact_vk AS contact_vk_13, s0_.contact_tg AS contact_tg_14, s0_.student_profile_name AS student_profile_name_15, s0_.employee_all_course_access AS employee_all_course_access_16, s0_.sort_student_name AS sort_student_name_17, s0_.id AS id_18, s0_.create_at AS create_at_19, s0_.update_at AS update_at_20, u1_.id AS id_21, f2_.name AS name_22, f2_.type AS type_23, f2_.mime AS mime_24, f2_.bucket AS bucket_25, f2_.path AS path_26, f2_.dir AS dir_27, f2_.size AS size_28, f2_.chunked AS chunked_29, f2_.chunked_metadata AS chunked_metadata_30, f2_.chunked_token AS chunked_token_31, f2_.entity_owner_name AS entity_owner_name_32, f2_.entity_owner_id AS entity_owner_id_33, f2_.kinescope_id AS kinescope_id_34, f2_.kinescope_short_id AS kinescope_short_id_35, f2_.audio_time AS audio_time_36, f2_.audio_average_frequency AS audio_average_frequency_37, f2_.multipart_upload_id AS multipart_upload_id_38, f2_.restore_information AS restore_information_39, f2_.deleted AS deleted_40, f2_.deleted_at AS deleted_at_41, f2_.path_deleted AS path_deleted_42, f2_.id AS id_43, f2_.create_at AS create_at_44, f2_.update_at AS update_at_45, f2_.uuid AS uuid_46, s0_.school_id AS school_id_47, s0_.user_id AS user_id_48, s0_.employee_role_id AS employee_role_id_49, s0_.student_profile_avatar_id AS student_profile_avatar_id_50, u1_.avatar_id AS avatar_id_51, f2_.school_id AS school_id_52, f2_.lesson_module_file_id AS lesson_module_file_id_53, f2_.homework_answer_audio_id AS homework_answer_audio_id_54, f2_.question_fail_comment_file_id AS question_fail_comment_file_id_55, f2_.question_success_comment_file_id AS question_success_comment_file_id_56, f2_.answer_digit_comment_file_id AS answer_digit_comment_file_id_57, f2_.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_58, f2_.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_59, f2_.answer_select_comment_file_id AS answer_select_comment_file_id_60, f2_.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_61, f2_.answer_comment_file_id AS answer_comment_file_id_62 FROM school_user s0_ LEFT JOIN users u1_ ON s0_.user_id = u1_.id LEFT JOIN file f2_ ON s0_.student_profile_avatar_id = f2_.id WHERE s0_.school_id = ? AND s0_.user_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT s0_.role AS role_0, s0_.last_role AS last_role_1, s0_.visibility_in_student_dialogues AS visibility_in_student_dialogues_2, s0_.comment AS comment_3, s0_.last_course_finished_at AS last_course_finished_at_4, s0_.last_active_at AS last_active_at_5, s0_.student_status AS student_status_6, s0_.student_status_changed_at AS student_status_changed_at_7, s0_.webhook_session_end_send AS webhook_session_end_send_8, s0_.use_school_custom_employee_role AS use_school_custom_employee_role_9, s0_.school_custom_employee_role_actions AS school_custom_employee_role_actions_10, s0_.contact_biography AS contact_biography_11, s0_.contact_phone AS contact_phone_12, s0_.contact_vk AS contact_vk_13, s0_.contact_tg AS contact_tg_14, s0_.student_profile_name AS student_profile_name_15, s0_.employee_all_course_access AS employee_all_course_access_16, s0_.sort_student_name AS sort_student_name_17, s0_.id AS id_18, s0_.create_at AS create_at_19, s0_.update_at AS update_at_20, u1_.id AS id_21, f2_.name AS name_22, f2_.type AS type_23, f2_.mime AS mime_24, f2_.bucket AS bucket_25, f2_.path AS path_26, f2_.dir AS dir_27, f2_.size AS size_28, f2_.chunked AS chunked_29, f2_.chunked_metadata AS chunked_metadata_30, f2_.chunked_token AS chunked_token_31, f2_.entity_owner_name AS entity_owner_name_32, f2_.entity_owner_id AS entity_owner_id_33, f2_.kinescope_id AS kinescope_id_34, f2_.kinescope_short_id AS kinescope_short_id_35, f2_.audio_time AS audio_time_36, f2_.audio_average_frequency AS audio_average_frequency_37, f2_.multipart_upload_id AS multipart_upload_id_38, f2_.restore_information AS restore_information_39, f2_.deleted AS deleted_40, f2_.deleted_at AS deleted_at_41, f2_.path_deleted AS path_deleted_42, f2_.id AS id_43, f2_.create_at AS create_at_44, f2_.update_at AS update_at_45, f2_.uuid AS uuid_46, s0_.school_id AS school_id_47, s0_.user_id AS user_id_48, s0_.employee_role_id AS employee_role_id_49, s0_.student_profile_avatar_id AS student_profile_avatar_id_50, u1_.avatar_id AS avatar_id_51, f2_.school_id AS school_id_52, f2_.lesson_module_file_id AS lesson_module_file_id_53, f2_.homework_answer_audio_id AS homework_answer_audio_id_54, f2_.question_fail_comment_file_id AS question_fail_comment_file_id_55, f2_.question_success_comment_file_id AS question_success_comment_file_id_56, f2_.answer_digit_comment_file_id AS answer_digit_comment_file_id_57, f2_.answer_image_and_select_comment_file_id AS answer_image_and_select_comment_file_id_58, f2_.answer_select_image_comment_file_id AS answer_select_image_comment_file_id_59, f2_.answer_select_comment_file_id AS answer_select_comment_file_id_60, f2_.answer_digit_type_comment_file_id AS answer_digit_type_comment_file_id_61, f2_.answer_comment_file_id AS answer_comment_file_id_62 FROM school_user s0_ LEFT JOIN users u1_ ON s0_.user_id = u1_.id LEFT JOIN file f2_ ON s0_.student_profile_avatar_id = f2_.id WHERE s0_.school_id = 50 AND s0_.user_id IN (6640, 6629, 5917, 6653, 6654, 6645, 6642, 6649, 6644, 6623, 6646, 6655, 6648, 6657, 6656, 6650, 6658, 6651, 6652, 6622);
22	1.05 ms	SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, u1_.email AS email_37, u1_.login AS login_38, u1_.display_password AS display_password_39, u1_.roles AS roles_40, u1_.password AS password_41, u1_.active AS active_42, u1_.last_login AS last_login_43, u1_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_44, u1_.name AS name_45, u1_.phone AS phone_46, u1_.phone_webinar AS phone_webinar_47, u1_.city AS city_48, u1_.sex AS sex_49, u1_.timezone AS timezone_50, u1_.about_self AS about_self_51, u1_.last_active_at AS last_active_at_52, u1_.change_password_token AS change_password_token_53, u1_.user_change_password AS user_change_password_54, u1_.last_change_email_date AS last_change_email_date_55, u1_.unsubscription_email_notify_token AS unsubscription_email_notify_token_56, u1_.union_auth_key AS union_auth_key_57, u1_.related_services AS related_services_58, u1_.id AS id_59, u1_.create_at AS create_at_60, u1_.update_at AS update_at_61, u1_.uuid AS uuid_62, c2_.name AS name_63, c2_.slug AS slug_64, c2_.short_description AS short_description_65, c2_.description AS description_66, c2_.published AS published_67, c2_.closed AS closed_68, c2_.price AS price_69, c2_.old_price AS old_price_70, c2_.custom_payment_link AS custom_payment_link_71, c2_.free_first_step AS free_first_step_72, c2_.private_status AS private_status_73, c2_.includes AS includes_74, c2_.show_reviews AS show_reviews_75, c2_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_76, c2_.hard_sequence AS hard_sequence_77, c2_.use_landing_external_url AS use_landing_external_url_78, c2_.landing_external_url AS landing_external_url_79, c2_.copy_protected AS copy_protected_80, c2_.video_protected AS video_protected_81, c2_.enable_certificate AS enable_certificate_82, c2_.deleted AS deleted_83, c2_.deleted_at AS deleted_at_84, c2_.calculation_in_progress AS calculation_in_progress_85, c2_.background_dimming AS background_dimming_86, c2_.background_mobile_dimming AS background_mobile_dimming_87, c2_.mobile_background_type AS mobile_background_type_88, c2_.id AS id_89, c2_.create_at AS create_at_90, c2_.update_at AS update_at_91, c2_.sort AS sort_92, c2_.uuid AS uuid_93, c3_.number AS number_94, c3_.fields AS fields_95, c3_.school_name AS school_name_96, c3_.course_name AS course_name_97, c3_.group_name AS group_name_98, c3_.user_name AS user_name_99, c3_.template_name AS template_name_100, c3_.primary_color AS primary_color_101, c3_.id AS id_102, c3_.create_at AS create_at_103, c3_.update_at AS update_at_104, c3_.uuid AS uuid_105, f4_.name AS name_106, f4_.user_limit AS user_limit_107, f4_.homework_block AS homework_block_108, f4_.dialogue_with_employees_block AS dialogue_with_employees_block_109, f4_.lessons_access AS lessons_access_110, f4_.hard_sequence AS hard_sequence_111, f4_.hard_sequence_homework AS hard_sequence_homework_112, f4_.hard_sequence_test AS hard_sequence_test_113, f4_.enable_certificate AS enable_certificate_114, f4_.limit_students AS limit_students_115, f4_.display_unavailable_lesson_student AS display_unavailable_lesson_student_116, f4_.id AS id_117, f4_.create_at AS create_at_118, f4_.update_at AS update_at_119, f4_.sort AS sort_120, f4_.uuid AS uuid_121, f4_.access_lessons AS access_lessons_122, f4_.access_dates AS access_dates_123, f4_.access_type AS access_type_124, f4_.access_access_opens_for AS access_access_opens_for_125, f4_.access_weekdays AS access_weekdays_126, f4_.access_weekdays_start_date AS access_weekdays_start_date_127, f4_.access_once_for_days_interval AS access_once_for_days_interval_128, f4_.access_once_for_days_start_date AS access_once_for_days_start_date_129, f4_.access_for_time_type AS access_for_time_type_130, f4_.access_for_time_start_date AS access_for_time_start_date_131, f4_.access_for_time_range AS access_for_time_range_132, f4_.access_is_open_for_time AS access_is_open_for_time_133, f4_.access_is_open_for_schedule AS access_is_open_for_schedule_134, f4_.access_for_schedule_type AS access_for_schedule_type_135, f4_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_136, c0_.group_id AS group_id_137, c0_.course_id AS course_id_138, c0_.user_id AS user_id_139, c0_.lesson_id AS lesson_id_140, c0_.user_certificate_id AS user_certificate_id_141, c0_.discount_id AS discount_id_142, u1_.avatar_id AS avatar_id_143, c2_.cover_id AS cover_id_144, c2_.background_id AS background_id_145, c2_.mobile_background_id AS mobile_background_id_146, c2_.school_id AS school_id_147, c2_.flow_to_add_id AS flow_to_add_id_148, c2_.payment_gateway_id AS payment_gateway_id_149, c2_.installment_gateway_id AS installment_gateway_id_150, c2_.certificate_template_id AS certificate_template_id_151, c2_.draw_certificate_template_id AS draw_certificate_template_id_152, c2_.course_certificate_template_id AS course_certificate_template_id_153, c3_.school_id AS school_id_154, c3_.course_id AS course_id_155, c3_.course_user_id AS course_user_id_156, c3_.group_id AS group_id_157, c3_.user_id AS user_id_158, c3_.logo_id AS logo_id_159, c3_.background_id AS background_id_160, f4_.course_id AS course_id_161 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id LEFT JOIN course_user_certificate c3_ ON c0_.user_certificate_id = c3_.id LEFT JOIN flow f4_ ON c0_.group_id = f4_.id WHERE c0_.role = ? AND c0_.user_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c2_.school_id = ? AND c2_.deleted = ? AND c2_.id IN (?, ?, ?, ?, ?) Parameters: [`"ROLE_STUDENT" 6640 6629 5917 6653 6654 6645 6642 6649 6644 6623 6646 6655 6648 6657 6656 6650 6658 6651 6652 6622 50 0 37 40 42 60 66`] View formatted query View runnable query Explain query SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, u1_.email AS email_37, u1_.login AS login_38, u1_.display_password AS display_password_39, u1_.roles AS roles_40, u1_.password AS password_41, u1_.active AS active_42, u1_.last_login AS last_login_43, u1_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_44, u1_.name AS name_45, u1_.phone AS phone_46, u1_.phone_webinar AS phone_webinar_47, u1_.city AS city_48, u1_.sex AS sex_49, u1_.timezone AS timezone_50, u1_.about_self AS about_self_51, u1_.last_active_at AS last_active_at_52, u1_.change_password_token AS change_password_token_53, u1_.user_change_password AS user_change_password_54, u1_.last_change_email_date AS last_change_email_date_55, u1_.unsubscription_email_notify_token AS unsubscription_email_notify_token_56, u1_.union_auth_key AS union_auth_key_57, u1_.related_services AS related_services_58, u1_.id AS id_59, u1_.create_at AS create_at_60, u1_.update_at AS update_at_61, u1_.uuid AS uuid_62, c2_.name AS name_63, c2_.slug AS slug_64, c2_.short_description AS short_description_65, c2_.description AS description_66, c2_.published AS published_67, c2_.closed AS closed_68, c2_.price AS price_69, c2_.old_price AS old_price_70, c2_.custom_payment_link AS custom_payment_link_71, c2_.free_first_step AS free_first_step_72, c2_.private_status AS private_status_73, c2_.includes AS includes_74, c2_.show_reviews AS show_reviews_75, c2_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_76, c2_.hard_sequence AS hard_sequence_77, c2_.use_landing_external_url AS use_landing_external_url_78, c2_.landing_external_url AS landing_external_url_79, c2_.copy_protected AS copy_protected_80, c2_.video_protected AS video_protected_81, c2_.enable_certificate AS enable_certificate_82, c2_.deleted AS deleted_83, c2_.deleted_at AS deleted_at_84, c2_.calculation_in_progress AS calculation_in_progress_85, c2_.background_dimming AS background_dimming_86, c2_.background_mobile_dimming AS background_mobile_dimming_87, c2_.mobile_background_type AS mobile_background_type_88, c2_.id AS id_89, c2_.create_at AS create_at_90, c2_.update_at AS update_at_91, c2_.sort AS sort_92, c2_.uuid AS uuid_93, c3_.number AS number_94, c3_.fields AS fields_95, c3_.school_name AS school_name_96, c3_.course_name AS course_name_97, c3_.group_name AS group_name_98, c3_.user_name AS user_name_99, c3_.template_name AS template_name_100, c3_.primary_color AS primary_color_101, c3_.id AS id_102, c3_.create_at AS create_at_103, c3_.update_at AS update_at_104, c3_.uuid AS uuid_105, f4_.name AS name_106, f4_.user_limit AS user_limit_107, f4_.homework_block AS homework_block_108, f4_.dialogue_with_employees_block AS dialogue_with_employees_block_109, f4_.lessons_access AS lessons_access_110, f4_.hard_sequence AS hard_sequence_111, f4_.hard_sequence_homework AS hard_sequence_homework_112, f4_.hard_sequence_test AS hard_sequence_test_113, f4_.enable_certificate AS enable_certificate_114, f4_.limit_students AS limit_students_115, f4_.display_unavailable_lesson_student AS display_unavailable_lesson_student_116, f4_.id AS id_117, f4_.create_at AS create_at_118, f4_.update_at AS update_at_119, f4_.sort AS sort_120, f4_.uuid AS uuid_121, f4_.access_lessons AS access_lessons_122, f4_.access_dates AS access_dates_123, f4_.access_type AS access_type_124, f4_.access_access_opens_for AS access_access_opens_for_125, f4_.access_weekdays AS access_weekdays_126, f4_.access_weekdays_start_date AS access_weekdays_start_date_127, f4_.access_once_for_days_interval AS access_once_for_days_interval_128, f4_.access_once_for_days_start_date AS access_once_for_days_start_date_129, f4_.access_for_time_type AS access_for_time_type_130, f4_.access_for_time_start_date AS access_for_time_start_date_131, f4_.access_for_time_range AS access_for_time_range_132, f4_.access_is_open_for_time AS access_is_open_for_time_133, f4_.access_is_open_for_schedule AS access_is_open_for_schedule_134, f4_.access_for_schedule_type AS access_for_schedule_type_135, f4_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_136, c0_.group_id AS group_id_137, c0_.course_id AS course_id_138, c0_.user_id AS user_id_139, c0_.lesson_id AS lesson_id_140, c0_.user_certificate_id AS user_certificate_id_141, c0_.discount_id AS discount_id_142, u1_.avatar_id AS avatar_id_143, c2_.cover_id AS cover_id_144, c2_.background_id AS background_id_145, c2_.mobile_background_id AS mobile_background_id_146, c2_.school_id AS school_id_147, c2_.flow_to_add_id AS flow_to_add_id_148, c2_.payment_gateway_id AS payment_gateway_id_149, c2_.installment_gateway_id AS installment_gateway_id_150, c2_.certificate_template_id AS certificate_template_id_151, c2_.draw_certificate_template_id AS draw_certificate_template_id_152, c2_.course_certificate_template_id AS course_certificate_template_id_153, c3_.school_id AS school_id_154, c3_.course_id AS course_id_155, c3_.course_user_id AS course_user_id_156, c3_.group_id AS group_id_157, c3_.user_id AS user_id_158, c3_.logo_id AS logo_id_159, c3_.background_id AS background_id_160, f4_.course_id AS course_id_161 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id LEFT JOIN course_user_certificate c3_ ON c0_.user_certificate_id = c3_.id LEFT JOIN flow f4_ ON c0_.group_id = f4_.id WHERE c0_.role = ? AND c0_.user_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND c2_.school_id = ? AND c2_.deleted = ? AND c2_.id IN (?, ?, ?, ?, ?) SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, u1_.email AS email_37, u1_.login AS login_38, u1_.display_password AS display_password_39, u1_.roles AS roles_40, u1_.password AS password_41, u1_.active AS active_42, u1_.last_login AS last_login_43, u1_.unsubscribe_email_notification_token AS unsubscribe_email_notification_token_44, u1_.name AS name_45, u1_.phone AS phone_46, u1_.phone_webinar AS phone_webinar_47, u1_.city AS city_48, u1_.sex AS sex_49, u1_.timezone AS timezone_50, u1_.about_self AS about_self_51, u1_.last_active_at AS last_active_at_52, u1_.change_password_token AS change_password_token_53, u1_.user_change_password AS user_change_password_54, u1_.last_change_email_date AS last_change_email_date_55, u1_.unsubscription_email_notify_token AS unsubscription_email_notify_token_56, u1_.union_auth_key AS union_auth_key_57, u1_.related_services AS related_services_58, u1_.id AS id_59, u1_.create_at AS create_at_60, u1_.update_at AS update_at_61, u1_.uuid AS uuid_62, c2_.name AS name_63, c2_.slug AS slug_64, c2_.short_description AS short_description_65, c2_.description AS description_66, c2_.published AS published_67, c2_.closed AS closed_68, c2_.price AS price_69, c2_.old_price AS old_price_70, c2_.custom_payment_link AS custom_payment_link_71, c2_.free_first_step AS free_first_step_72, c2_.private_status AS private_status_73, c2_.includes AS includes_74, c2_.show_reviews AS show_reviews_75, c2_.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_76, c2_.hard_sequence AS hard_sequence_77, c2_.use_landing_external_url AS use_landing_external_url_78, c2_.landing_external_url AS landing_external_url_79, c2_.copy_protected AS copy_protected_80, c2_.video_protected AS video_protected_81, c2_.enable_certificate AS enable_certificate_82, c2_.deleted AS deleted_83, c2_.deleted_at AS deleted_at_84, c2_.calculation_in_progress AS calculation_in_progress_85, c2_.background_dimming AS background_dimming_86, c2_.background_mobile_dimming AS background_mobile_dimming_87, c2_.mobile_background_type AS mobile_background_type_88, c2_.id AS id_89, c2_.create_at AS create_at_90, c2_.update_at AS update_at_91, c2_.sort AS sort_92, c2_.uuid AS uuid_93, c3_.number AS number_94, c3_.fields AS fields_95, c3_.school_name AS school_name_96, c3_.course_name AS course_name_97, c3_.group_name AS group_name_98, c3_.user_name AS user_name_99, c3_.template_name AS template_name_100, c3_.primary_color AS primary_color_101, c3_.id AS id_102, c3_.create_at AS create_at_103, c3_.update_at AS update_at_104, c3_.uuid AS uuid_105, f4_.name AS name_106, f4_.user_limit AS user_limit_107, f4_.homework_block AS homework_block_108, f4_.dialogue_with_employees_block AS dialogue_with_employees_block_109, f4_.lessons_access AS lessons_access_110, f4_.hard_sequence AS hard_sequence_111, f4_.hard_sequence_homework AS hard_sequence_homework_112, f4_.hard_sequence_test AS hard_sequence_test_113, f4_.enable_certificate AS enable_certificate_114, f4_.limit_students AS limit_students_115, f4_.display_unavailable_lesson_student AS display_unavailable_lesson_student_116, f4_.id AS id_117, f4_.create_at AS create_at_118, f4_.update_at AS update_at_119, f4_.sort AS sort_120, f4_.uuid AS uuid_121, f4_.access_lessons AS access_lessons_122, f4_.access_dates AS access_dates_123, f4_.access_type AS access_type_124, f4_.access_access_opens_for AS access_access_opens_for_125, f4_.access_weekdays AS access_weekdays_126, f4_.access_weekdays_start_date AS access_weekdays_start_date_127, f4_.access_once_for_days_interval AS access_once_for_days_interval_128, f4_.access_once_for_days_start_date AS access_once_for_days_start_date_129, f4_.access_for_time_type AS access_for_time_type_130, f4_.access_for_time_start_date AS access_for_time_start_date_131, f4_.access_for_time_range AS access_for_time_range_132, f4_.access_is_open_for_time AS access_is_open_for_time_133, f4_.access_is_open_for_schedule AS access_is_open_for_schedule_134, f4_.access_for_schedule_type AS access_for_schedule_type_135, f4_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_136, c0_.group_id AS group_id_137, c0_.course_id AS course_id_138, c0_.user_id AS user_id_139, c0_.lesson_id AS lesson_id_140, c0_.user_certificate_id AS user_certificate_id_141, c0_.discount_id AS discount_id_142, u1_.avatar_id AS avatar_id_143, c2_.cover_id AS cover_id_144, c2_.background_id AS background_id_145, c2_.mobile_background_id AS mobile_background_id_146, c2_.school_id AS school_id_147, c2_.flow_to_add_id AS flow_to_add_id_148, c2_.payment_gateway_id AS payment_gateway_id_149, c2_.installment_gateway_id AS installment_gateway_id_150, c2_.certificate_template_id AS certificate_template_id_151, c2_.draw_certificate_template_id AS draw_certificate_template_id_152, c2_.course_certificate_template_id AS course_certificate_template_id_153, c3_.school_id AS school_id_154, c3_.course_id AS course_id_155, c3_.course_user_id AS course_user_id_156, c3_.group_id AS group_id_157, c3_.user_id AS user_id_158, c3_.logo_id AS logo_id_159, c3_.background_id AS background_id_160, f4_.course_id AS course_id_161 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id LEFT JOIN course_user_certificate c3_ ON c0_.user_certificate_id = c3_.id LEFT JOIN flow f4_ ON c0_.group_id = f4_.id WHERE c0_.role = 'ROLE_STUDENT' AND c0_.user_id IN (6640, 6629, 5917, 6653, 6654, 6645, 6642, 6649, 6644, 6623, 6646, 6655, 6648, 6657, 6656, 6650, 6658, 6651, 6652, 6622) AND c2_.school_id = 50 AND c2_.deleted = 0 AND c2_.id IN (37, 40, 42, 60, 66);
23	0.16 ms	SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ? SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = 45;
24	0.07 ms	SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ? SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = 45;
25	0.09 ms	SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ? SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = 45;
26	0.05 ms	SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ? Parameters: [`45`] View formatted query View runnable query Explain query SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ? SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = 45;
27	0.05 ms	SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = ? SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowChannel = 48;
28	0.04 ms	SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = ? SELECT t0.last_message_date AS last_message_date_1, t0.active AS active_2, t0.name AS name_3, t0.description AS description_4, t0.type AS type_5, t0.id AS id_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.uuid AS uuid_9, t0.school_owner_id AS school_owner_id_10, t0.last_message_id AS last_message_id_11, t0.flowChannel AS flowChannel_12, t0.flowGroup AS flowGroup_13, t0.flow_id AS flow_id_14, t0.schoolChannel AS schoolChannel_15, t0.schoolGroup AS schoolGroup_16, t0.school_id AS school_id_17 FROM chat t0 WHERE t0.flowGroup = 48;
29	0.05 ms	SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = ? SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.published_at AS published_at_3, t0.display_share_buttons AS display_share_buttons_4, t0.draw_display_share_buttons AS draw_display_share_buttons_5, t0.title AS title_6, t0.draw_title AS draw_title_7, t0.subtitle AS subtitle_8, t0.draw_subtitle AS draw_subtitle_9, t0.status AS status_10, t0.display_student AS display_student_11, t0.draw_display_student AS draw_display_student_12, t0.id AS id_13, t0.create_at AS create_at_14, t0.update_at AS update_at_15, t0.uuid AS uuid_16, t0.school_id AS school_id_17, t0.course_id AS course_id_18, t0.group_id AS group_id_19 FROM course_finish_rule t0 WHERE t0.group_id = 48;
30	0.04 ms	SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ? Parameters: [`48`] View formatted query View runnable query Explain query SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = ? SELECT t0.rules AS rules_1, t0.draw_rules AS draw_rules_2, t0.display_share_buttons AS display_share_buttons_3, t0.draw_display_share_buttons AS draw_display_share_buttons_4, t0.status AS status_5, t0.published_at AS published_at_6, t0.id AS id_7, t0.create_at AS create_at_8, t0.update_at AS update_at_9, t0.uuid AS uuid_10, t0.school_id AS school_id_11, t0.course_id AS course_id_12, t0.group_id AS group_id_13 FROM course_certificate_rule t0 WHERE t0.group_id = 48;
31	0.20 ms	SELECT u0_.uuid AS uuid_0 FROM user_custom_field u0_ WHERE u0_.school_id = ? AND u0_.uuid IN (?, ?, ?, ?, ?, ?, ?) Parameters: [`50 "name" "studentStatus" "score" "progress" "lastActivity" "added" "finished"`] View formatted query View runnable query Explain query SELECT u0_.uuid AS uuid_0 FROM user_custom_field u0_ WHERE u0_.school_id = ? AND u0_.uuid IN (?, ?, ?, ?, ?, ?, ?) SELECT u0_.uuid AS uuid_0 FROM user_custom_field u0_ WHERE u0_.school_id = 50 AND u0_.uuid IN ('name', 'studentStatus', 'score', 'progress', 'lastActivity', 'added', 'finished');
32	0.33 ms	SELECT u0_.id AS id_0, AVG(c1_.score) AS sclr_1, AVG(c1_.progress) AS sclr_2 FROM course_user c1_ LEFT JOIN course c2_ ON c1_.course_id = c2_.id LEFT JOIN users u0_ ON c1_.user_id = u0_.id WHERE c2_.school_id = ? AND u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY c1_.user_id Parameters: [`50 6640 6629 5917 6653 6654 6645 6642 6649 6644 6623 6646 6655 6648 6657 6656 6650 6658 6651 6652 6622`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, AVG(c1_.score) AS sclr_1, AVG(c1_.progress) AS sclr_2 FROM course_user c1_ LEFT JOIN course c2_ ON c1_.course_id = c2_.id LEFT JOIN users u0_ ON c1_.user_id = u0_.id WHERE c2_.school_id = ? AND u0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) GROUP BY c1_.user_id SELECT u0_.id AS id_0, AVG(c1_.score) AS sclr_1, AVG(c1_.progress) AS sclr_2 FROM course_user c1_ LEFT JOIN course c2_ ON c1_.course_id = c2_.id LEFT JOIN users u0_ ON c1_.user_id = u0_.id WHERE c2_.school_id = 50 AND u0_.id IN (6640, 6629, 5917, 6653, 6654, 6645, 6642, 6649, 6644, 6623, 6646, 6655, 6648, 6657, 6656, 6650, 6658, 6651, 6652, 6622) GROUP BY c1_.user_id;
33	0.32 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 = ? Parameters: [`50 5907`] View formatted query View runnable query Explain query 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\School\School	No errors.
App\Entity\UserToken	No errors.
App\Entity\User	No errors.
App\Entity\File	No errors.
App\Entity\LessonModule\LessonModule	No errors.
App\Entity\LessonModule\LessonModuleFile	No errors.
App\Entity\Homework\HomeworkAnswer	No errors.
App\Entity\Test\Question\ParentType	No errors.
App\Entity\Test\Answer\DigitType	No errors.
App\Entity\Test\Answer\ImageAndSelectType	No errors.
App\Entity\Test\Answer\SelectImageType	No errors.
App\Entity\Test\Answer\SelectType	No errors.
App\Entity\Test\Answer\TextType	No errors.
App\Entity\Test\Answer\ParentTypeNew	No errors.
App\Entity\Notifications	No errors.
App\Entity\Subscription\Plan	No errors.
App\Entity\Subscription\Subscription	No errors.
App\Entity\Chat\Chat	No errors.
App\Entity\Subscription\Discount\Discount	No errors.
App\Entity\Course\Course	No errors.
App\Entity\Homework\HomeworkUser	No errors.
App\Entity\PublicApi\SchoolToken	No errors.
App\Entity\Settings\School	No errors.
App\Entity\School\UserFields\UserField	No errors.
App\Entity\Landing\Landing	No errors.
App\Entity\Course\Category	No errors.
App\Entity\Settings\SchoolWebhook	No errors.
App\Entity\Course\LessonAccess	No errors.
App\Entity\Course\CourseUser	No errors.
App\Entity\School\SchoolUser	No errors.
App\Entity\Lesson\Lesson	No errors.
App\Entity\Lesson\LessonPage	No errors.
App\Entity\Lesson\LessonHistory	No errors.
App\Entity\Step	No errors.
App\Entity\Test\TestDeadline	No errors.
App\Entity\Test\Test	No errors.
App\Entity\School\Discount\Discount	No errors.
App\Entity\Homework\HomeworkDeadline	No errors.
App\Entity\Homework\Homework	No errors.
App\Entity\Subscription\PlanFeature	No errors.
App\Entity\Subscription\SubscriptionUsage	No errors.
App\Entity\Group\LessonAccess	No errors.
App\Entity\Group\Flow	No errors.
App\Entity\Payment\Gateway\Gateway	No errors.
App\Entity\Course\CourseFinishRule	No errors.
App\Entity\Course\CourseCertificateRule	No errors.
App\Entity\Course\Certificate\CertificateTemplate	No errors.
App\Entity\Course\CoursePlan	No errors.
App\Entity\Payment\Gateway\GatewayYandexKassa	No errors.
App\Entity\Payment\Gateway\GatewayTinkoff	No errors.
App\Entity\Payment\Gateway\GatewayProdamus	No errors.
App\Entity\Payment\Gateway\GatewayMandarinPay	No errors.
App\Entity\Payment\Gateway\GatewayMandarinPayInstallment	No errors.
App\Entity\Payment\Gateway\GatewayDevelopmentResourceInstallment	No errors.
App\Entity\Payment\Gateway\GatewayDevelopmentResourceV2Installment	No errors.
App\Entity\Payment\Gateway\GatewayBePaid	No errors.
App\Entity\Payment\Gateway\GatewayCloudPayments	No errors.
App\Entity\Payment\Gateway\GatewayGazprom	No errors.
App\Entity\Payment\Gateway\GatewayTochka	No errors.
App\Entity\Payment\Gateway\GatewayMandarin	No errors.
App\Entity\Payment\Gateway\GatewayVtb	No errors.
App\Entity\Course\CourseCategory	No errors.
App\Entity\School\UserFields\FieldValue\FieldValue	No errors.
App\Entity\UserLessonComplete	No errors.
App\Entity\Course\Certificate\UserCertificate	No errors.
App\Entity\School\SchoolEmployeeRole	No errors.
App\Entity\Chat\Message\Message	No errors.
App\Entity\Webinar\WebinarFlow	No errors.

Symfony Profiler

POST https://963174.dev-4.sksp.site/api/school/students/list

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping