Symfony Profiler

Query Metrics

22 Database Queries

18 Different statements

6.15 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
1.68 ms (27.38%)	1	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, s0_.school_id AS school_id_21, s0_.user_id AS user_id_22, s0_.employee_role_id AS employee_role_id_23, s0_.student_profile_avatar_id AS student_profile_avatar_id_24 FROM school_user s0_ LEFT JOIN school_employee_role s1_ ON s0_.employee_role_id = s1_.id LEFT JOIN users u2_ ON s0_.user_id = u2_.id WHERE s0_.school_id = ? AND s0_.role IN (?, ?, ?, ?, ?, ?, ?) ORDER BY s1_.sort ASC, s1_.name ASC, u2_.name ASC Parameters: [`50 "ROLE_SCHOOL_ADMIN" "ROLE_EMPLOYEE" "ROLE_SCHOOL_OWNER" "ROLE_SCHOOL_EDITOR" "ROLE_SCHOOL_TEACHER" "ROLE_SCHOOL_COURSE_EDITOR" "ROLE_SCHOOL_CUSTOM"`] 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, s0_.school_id AS school_id_21, s0_.user_id AS user_id_22, s0_.employee_role_id AS employee_role_id_23, s0_.student_profile_avatar_id AS student_profile_avatar_id_24 FROM school_user s0_ LEFT JOIN school_employee_role s1_ ON s0_.employee_role_id = s1_.id LEFT JOIN users u2_ ON s0_.user_id = u2_.id WHERE s0_.school_id = ? AND s0_.role IN (?, ?, ?, ?, ?, ?, ?) ORDER BY s1_.sort ASC, s1_.name ASC, u2_.name ASC 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, s0_.school_id AS school_id_21, s0_.user_id AS user_id_22, s0_.employee_role_id AS employee_role_id_23, s0_.student_profile_avatar_id AS student_profile_avatar_id_24 FROM school_user s0_ LEFT JOIN school_employee_role s1_ ON s0_.employee_role_id = s1_.id LEFT JOIN users u2_ ON s0_.user_id = u2_.id WHERE s0_.school_id = 50 AND s0_.role IN ('ROLE_SCHOOL_ADMIN', 'ROLE_EMPLOYEE', 'ROLE_SCHOOL_OWNER', 'ROLE_SCHOOL_EDITOR', 'ROLE_SCHOOL_TEACHER', 'ROLE_SCHOOL_COURSE_EDITOR', 'ROLE_SCHOOL_CUSTOM') ORDER BY s1_.sort ASC, s1_.name ASC, u2_.name ASC;
0.97 ms (15.80%)	2	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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c4_.last_message_date AS last_message_date_125, c4_.active AS active_126, c4_.name AS name_127, c4_.description AS description_128, c4_.type AS type_129, c4_.id AS id_130, c4_.create_at AS create_at_131, c4_.update_at AS update_at_132, c4_.uuid AS uuid_133, c5_.last_message_date AS last_message_date_134, c5_.active AS active_135, c5_.name AS name_136, c5_.description AS description_137, c5_.type AS type_138, c5_.id AS id_139, c5_.create_at AS create_at_140, c5_.update_at AS update_at_141, c5_.uuid AS uuid_142, c0_.group_id AS group_id_143, c0_.course_id AS course_id_144, c0_.user_id AS user_id_145, c0_.lesson_id AS lesson_id_146, c0_.user_certificate_id AS user_certificate_id_147, c0_.discount_id AS discount_id_148, u1_.avatar_id AS avatar_id_149, c2_.cover_id AS cover_id_150, c2_.background_id AS background_id_151, c2_.mobile_background_id AS mobile_background_id_152, c2_.school_id AS school_id_153, c2_.flow_to_add_id AS flow_to_add_id_154, c2_.payment_gateway_id AS payment_gateway_id_155, c2_.installment_gateway_id AS installment_gateway_id_156, c2_.certificate_template_id AS certificate_template_id_157, c2_.draw_certificate_template_id AS draw_certificate_template_id_158, c2_.course_certificate_template_id AS course_certificate_template_id_159, f3_.course_id AS course_id_160, c4_.school_owner_id AS school_owner_id_161, c4_.last_message_id AS last_message_id_162, c4_.flowChannel AS flowChannel_163, c4_.flowGroup AS flowGroup_164, c4_.flow_id AS flow_id_165, c4_.schoolChannel AS schoolChannel_166, c4_.schoolGroup AS schoolGroup_167, c4_.school_id AS school_id_168, c5_.school_owner_id AS school_owner_id_169, c5_.last_message_id AS last_message_id_170, c5_.flowChannel AS flowChannel_171, c5_.flowGroup AS flowGroup_172, c5_.flow_id AS flow_id_173, c5_.schoolChannel AS schoolChannel_174, c5_.schoolGroup AS schoolGroup_175, c5_.school_id AS school_id_176 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 flow f3_ ON c0_.group_id = f3_.id LEFT JOIN chat c4_ ON f3_.id = c4_.flowChannel LEFT JOIN chat c5_ ON f3_.id = c5_.flowGroup WHERE c0_.user_id = ? AND u1_.active = ? AND c0_.role = ? AND c2_.school_id = ? AND c2_.deleted = ? Parameters: [`7151 1 "ROLE_STUDENT" 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, 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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c4_.last_message_date AS last_message_date_125, c4_.active AS active_126, c4_.name AS name_127, c4_.description AS description_128, c4_.type AS type_129, c4_.id AS id_130, c4_.create_at AS create_at_131, c4_.update_at AS update_at_132, c4_.uuid AS uuid_133, c5_.last_message_date AS last_message_date_134, c5_.active AS active_135, c5_.name AS name_136, c5_.description AS description_137, c5_.type AS type_138, c5_.id AS id_139, c5_.create_at AS create_at_140, c5_.update_at AS update_at_141, c5_.uuid AS uuid_142, c0_.group_id AS group_id_143, c0_.course_id AS course_id_144, c0_.user_id AS user_id_145, c0_.lesson_id AS lesson_id_146, c0_.user_certificate_id AS user_certificate_id_147, c0_.discount_id AS discount_id_148, u1_.avatar_id AS avatar_id_149, c2_.cover_id AS cover_id_150, c2_.background_id AS background_id_151, c2_.mobile_background_id AS mobile_background_id_152, c2_.school_id AS school_id_153, c2_.flow_to_add_id AS flow_to_add_id_154, c2_.payment_gateway_id AS payment_gateway_id_155, c2_.installment_gateway_id AS installment_gateway_id_156, c2_.certificate_template_id AS certificate_template_id_157, c2_.draw_certificate_template_id AS draw_certificate_template_id_158, c2_.course_certificate_template_id AS course_certificate_template_id_159, f3_.course_id AS course_id_160, c4_.school_owner_id AS school_owner_id_161, c4_.last_message_id AS last_message_id_162, c4_.flowChannel AS flowChannel_163, c4_.flowGroup AS flowGroup_164, c4_.flow_id AS flow_id_165, c4_.schoolChannel AS schoolChannel_166, c4_.schoolGroup AS schoolGroup_167, c4_.school_id AS school_id_168, c5_.school_owner_id AS school_owner_id_169, c5_.last_message_id AS last_message_id_170, c5_.flowChannel AS flowChannel_171, c5_.flowGroup AS flowGroup_172, c5_.flow_id AS flow_id_173, c5_.schoolChannel AS schoolChannel_174, c5_.schoolGroup AS schoolGroup_175, c5_.school_id AS school_id_176 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 flow f3_ ON c0_.group_id = f3_.id LEFT JOIN chat c4_ ON f3_.id = c4_.flowChannel LEFT JOIN chat c5_ ON f3_.id = c5_.flowGroup 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, 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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c4_.last_message_date AS last_message_date_125, c4_.active AS active_126, c4_.name AS name_127, c4_.description AS description_128, c4_.type AS type_129, c4_.id AS id_130, c4_.create_at AS create_at_131, c4_.update_at AS update_at_132, c4_.uuid AS uuid_133, c5_.last_message_date AS last_message_date_134, c5_.active AS active_135, c5_.name AS name_136, c5_.description AS description_137, c5_.type AS type_138, c5_.id AS id_139, c5_.create_at AS create_at_140, c5_.update_at AS update_at_141, c5_.uuid AS uuid_142, c0_.group_id AS group_id_143, c0_.course_id AS course_id_144, c0_.user_id AS user_id_145, c0_.lesson_id AS lesson_id_146, c0_.user_certificate_id AS user_certificate_id_147, c0_.discount_id AS discount_id_148, u1_.avatar_id AS avatar_id_149, c2_.cover_id AS cover_id_150, c2_.background_id AS background_id_151, c2_.mobile_background_id AS mobile_background_id_152, c2_.school_id AS school_id_153, c2_.flow_to_add_id AS flow_to_add_id_154, c2_.payment_gateway_id AS payment_gateway_id_155, c2_.installment_gateway_id AS installment_gateway_id_156, c2_.certificate_template_id AS certificate_template_id_157, c2_.draw_certificate_template_id AS draw_certificate_template_id_158, c2_.course_certificate_template_id AS course_certificate_template_id_159, f3_.course_id AS course_id_160, c4_.school_owner_id AS school_owner_id_161, c4_.last_message_id AS last_message_id_162, c4_.flowChannel AS flowChannel_163, c4_.flowGroup AS flowGroup_164, c4_.flow_id AS flow_id_165, c4_.schoolChannel AS schoolChannel_166, c4_.schoolGroup AS schoolGroup_167, c4_.school_id AS school_id_168, c5_.school_owner_id AS school_owner_id_169, c5_.last_message_id AS last_message_id_170, c5_.flowChannel AS flowChannel_171, c5_.flowGroup AS flowGroup_172, c5_.flow_id AS flow_id_173, c5_.schoolChannel AS schoolChannel_174, c5_.schoolGroup AS schoolGroup_175, c5_.school_id AS school_id_176 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 flow f3_ ON c0_.group_id = f3_.id LEFT JOIN chat c4_ ON f3_.id = c4_.flowChannel LEFT JOIN chat c5_ ON f3_.id = c5_.flowGroup WHERE c0_.user_id = 7151 AND u1_.active = 1 AND c0_.role = 'ROLE_STUDENT' AND c2_.school_id = 50 AND c2_.deleted = 0;
0.69 ms (11.24%)	2	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: [`"5cf8b4dd-555c-4a46-a34e-be563f3f4b3c"`] 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 = '5cf8b4dd-555c-4a46-a34e-be563f3f4b3c' LIMIT 1;
0.36 ms (5.83%)	1	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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c0_.group_id AS group_id_125, c0_.course_id AS course_id_126, c0_.user_id AS user_id_127, c0_.lesson_id AS lesson_id_128, c0_.user_certificate_id AS user_certificate_id_129, c0_.discount_id AS discount_id_130, u1_.avatar_id AS avatar_id_131, c2_.cover_id AS cover_id_132, c2_.background_id AS background_id_133, c2_.mobile_background_id AS mobile_background_id_134, c2_.school_id AS school_id_135, c2_.flow_to_add_id AS flow_to_add_id_136, c2_.payment_gateway_id AS payment_gateway_id_137, c2_.installment_gateway_id AS installment_gateway_id_138, c2_.certificate_template_id AS certificate_template_id_139, c2_.draw_certificate_template_id AS draw_certificate_template_id_140, c2_.course_certificate_template_id AS course_certificate_template_id_141, f3_.course_id AS course_id_142 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 group_employee g4_ ON c0_.id = g4_.course_user_id LEFT JOIN flow f3_ ON f3_.id = g4_.flow_id WHERE c2_.school_id = ? AND c2_.deleted = ? AND c0_.role = ? AND c2_.id IN (?) Parameters: [`50 0 "ROLE_TEACHER" 40`] 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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c0_.group_id AS group_id_125, c0_.course_id AS course_id_126, c0_.user_id AS user_id_127, c0_.lesson_id AS lesson_id_128, c0_.user_certificate_id AS user_certificate_id_129, c0_.discount_id AS discount_id_130, u1_.avatar_id AS avatar_id_131, c2_.cover_id AS cover_id_132, c2_.background_id AS background_id_133, c2_.mobile_background_id AS mobile_background_id_134, c2_.school_id AS school_id_135, c2_.flow_to_add_id AS flow_to_add_id_136, c2_.payment_gateway_id AS payment_gateway_id_137, c2_.installment_gateway_id AS installment_gateway_id_138, c2_.certificate_template_id AS certificate_template_id_139, c2_.draw_certificate_template_id AS draw_certificate_template_id_140, c2_.course_certificate_template_id AS course_certificate_template_id_141, f3_.course_id AS course_id_142 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 group_employee g4_ ON c0_.id = g4_.course_user_id LEFT JOIN flow f3_ ON f3_.id = g4_.flow_id WHERE c2_.school_id = ? AND c2_.deleted = ? AND c0_.role = ? 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, f3_.name AS name_94, f3_.user_limit AS user_limit_95, f3_.homework_block AS homework_block_96, f3_.dialogue_with_employees_block AS dialogue_with_employees_block_97, f3_.lessons_access AS lessons_access_98, f3_.hard_sequence AS hard_sequence_99, f3_.hard_sequence_homework AS hard_sequence_homework_100, f3_.hard_sequence_test AS hard_sequence_test_101, f3_.enable_certificate AS enable_certificate_102, f3_.limit_students AS limit_students_103, f3_.display_unavailable_lesson_student AS display_unavailable_lesson_student_104, f3_.id AS id_105, f3_.create_at AS create_at_106, f3_.update_at AS update_at_107, f3_.sort AS sort_108, f3_.uuid AS uuid_109, f3_.access_lessons AS access_lessons_110, f3_.access_dates AS access_dates_111, f3_.access_type AS access_type_112, f3_.access_access_opens_for AS access_access_opens_for_113, f3_.access_weekdays AS access_weekdays_114, f3_.access_weekdays_start_date AS access_weekdays_start_date_115, f3_.access_once_for_days_interval AS access_once_for_days_interval_116, f3_.access_once_for_days_start_date AS access_once_for_days_start_date_117, f3_.access_for_time_type AS access_for_time_type_118, f3_.access_for_time_start_date AS access_for_time_start_date_119, f3_.access_for_time_range AS access_for_time_range_120, f3_.access_is_open_for_time AS access_is_open_for_time_121, f3_.access_is_open_for_schedule AS access_is_open_for_schedule_122, f3_.access_for_schedule_type AS access_for_schedule_type_123, f3_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_124, c0_.group_id AS group_id_125, c0_.course_id AS course_id_126, c0_.user_id AS user_id_127, c0_.lesson_id AS lesson_id_128, c0_.user_certificate_id AS user_certificate_id_129, c0_.discount_id AS discount_id_130, u1_.avatar_id AS avatar_id_131, c2_.cover_id AS cover_id_132, c2_.background_id AS background_id_133, c2_.mobile_background_id AS mobile_background_id_134, c2_.school_id AS school_id_135, c2_.flow_to_add_id AS flow_to_add_id_136, c2_.payment_gateway_id AS payment_gateway_id_137, c2_.installment_gateway_id AS installment_gateway_id_138, c2_.certificate_template_id AS certificate_template_id_139, c2_.draw_certificate_template_id AS draw_certificate_template_id_140, c2_.course_certificate_template_id AS course_certificate_template_id_141, f3_.course_id AS course_id_142 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 group_employee g4_ ON c0_.id = g4_.course_user_id LEFT JOIN flow f3_ ON f3_.id = g4_.flow_id WHERE c2_.school_id = 50 AND c2_.deleted = 0 AND c0_.role = 'ROLE_TEACHER' AND c2_.id IN (40);
0.34 ms (5.50%)	1	SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c0_.schoolChannel AS sclr_14, c0_.schoolGroup AS sclr_15, COALESCE(s6_.avatar_id, s7_.avatar_id) AS sclr_16, c8_.unread_messages AS unread_messages_17, c8_.unread_since AS unread_since_18, 1 AS sclr_19 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c9_ ON c1_.id = c9_.id LEFT JOIN chat_message_group c10_ ON c1_.id = c10_.id LEFT JOIN chat_message_channel c11_ ON c1_.id = c11_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN (chat_message_dialogue c2_ INNER JOIN chat_message c12_ ON c2_.id = c12_.id) ON (c12_.id = c1_.id) LEFT JOIN (chat_message_group c3_ INNER JOIN chat_message c13_ ON c3_.id = c13_.id) ON (c13_.id = c1_.id) LEFT JOIN (chat_message_channel c4_ INNER JOIN chat_message c14_ ON c4_.id = c14_.id) ON (c14_.id = c1_.id) LEFT JOIN schools s6_ ON c0_.schoolChannel = s6_.id LEFT JOIN schools s7_ ON c0_.schoolGroup = s7_.id LEFT JOIN chat_recipient c8_ ON (c8_.chat_id = c0_.id AND c8_.user_id = ?) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type IN ('group', 'channel') AND c0_.flowChannel IS NULL AND c0_.flowGroup IS NULL Parameters: [`7151 50 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c0_.schoolChannel AS sclr_14, c0_.schoolGroup AS sclr_15, COALESCE(s6_.avatar_id, s7_.avatar_id) AS sclr_16, c8_.unread_messages AS unread_messages_17, c8_.unread_since AS unread_since_18, 1 AS sclr_19 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c9_ ON c1_.id = c9_.id LEFT JOIN chat_message_group c10_ ON c1_.id = c10_.id LEFT JOIN chat_message_channel c11_ ON c1_.id = c11_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN ( chat_message_dialogue c2_ INNER JOIN chat_message c12_ ON c2_.id = c12_.id ) ON (c12_.id = c1_.id) LEFT JOIN ( chat_message_group c3_ INNER JOIN chat_message c13_ ON c3_.id = c13_.id ) ON (c13_.id = c1_.id) LEFT JOIN ( chat_message_channel c4_ INNER JOIN chat_message c14_ ON c4_.id = c14_.id ) ON (c14_.id = c1_.id) LEFT JOIN schools s6_ ON c0_.schoolChannel = s6_.id LEFT JOIN schools s7_ ON c0_.schoolGroup = s7_.id LEFT JOIN chat_recipient c8_ ON ( c8_.chat_id = c0_.id AND c8_.user_id = ? ) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type IN ('group', 'channel') AND c0_.flowChannel IS NULL AND c0_.flowGroup IS NULL SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c0_.schoolChannel AS sclr_14, c0_.schoolGroup AS sclr_15, COALESCE(s6_.avatar_id, s7_.avatar_id) AS sclr_16, c8_.unread_messages AS unread_messages_17, c8_.unread_since AS unread_since_18, 1 AS sclr_19 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c9_ ON c1_.id = c9_.id LEFT JOIN chat_message_group c10_ ON c1_.id = c10_.id LEFT JOIN chat_message_channel c11_ ON c1_.id = c11_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN (chat_message_dialogue c2_ INNER JOIN chat_message c12_ ON c2_.id = c12_.id) ON (c12_.id = c1_.id) LEFT JOIN (chat_message_group c3_ INNER JOIN chat_message c13_ ON c3_.id = c13_.id) ON (c13_.id = c1_.id) LEFT JOIN (chat_message_channel c4_ INNER JOIN chat_message c14_ ON c4_.id = c14_.id) ON (c14_.id = c1_.id) LEFT JOIN schools s6_ ON c0_.schoolChannel = s6_.id LEFT JOIN schools s7_ ON c0_.schoolGroup = s7_.id LEFT JOIN chat_recipient c8_ ON (c8_.chat_id = c0_.id AND c8_.user_id = 7151) WHERE c0_.school_owner_id = 50 AND c0_.active = 1 AND c0_.type IN ('group', 'channel') AND c0_.flowChannel IS NULL AND c0_.flowGroup IS NULL;
0.26 ms (4.26%)	1	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 7151`] 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 = 7151;
0.21 ms (3.38%)	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 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;
0.21 ms (3.37%)	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 = ? 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;
0.20 ms (3.29%)	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.id IN (?, ?, ?, ?) Parameters: [`5907 6580 7143 6641`] 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.id IN (?, ?, ?, ?) 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.id IN (5907, 6580, 7143, 6641);
0.19 ms (3.11%)	1	SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c6_.unread_messages AS unread_messages_14, c6_.unread_since AS unread_since_15 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN (chat_message_dialogue c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN (chat_message_group c3_ INNER JOIN chat_message c11_ ON c3_.id = c11_.id) ON (c11_.id = c1_.id) LEFT JOIN (chat_message_channel c4_ INNER JOIN chat_message c12_ ON c4_.id = c12_.id) ON (c12_.id = c1_.id) LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = ?) WHERE c0_.school_owner_id = ? AND c0_.type = ? AND c0_.active = ? AND c6_.id IS NOT NULL AND c1_.id IS NOT NULL Parameters: [`7151 50 "dialogue" 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c6_.unread_messages AS unread_messages_14, c6_.unread_since AS unread_since_15 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN ( chat_message_dialogue c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id ) ON (c10_.id = c1_.id) LEFT JOIN ( chat_message_group c3_ INNER JOIN chat_message c11_ ON c3_.id = c11_.id ) ON (c11_.id = c1_.id) LEFT JOIN ( chat_message_channel c4_ INNER JOIN chat_message c12_ ON c4_.id = c12_.id ) ON (c12_.id = c1_.id) LEFT JOIN chat_recipient c6_ ON ( c6_.chat_id = c0_.id AND c6_.user_id = ? ) WHERE c0_.school_owner_id = ? AND c0_.type = ? AND c0_.active = ? AND c6_.id IS NOT NULL AND c1_.id IS NOT NULL SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, COALESCE(c2_.text, c3_.text, c4_.text) AS sclr_9, u5_.id AS id_10, u5_.uuid AS uuid_11, u5_.name AS name_12, u5_.avatar_id AS sclr_13, c6_.unread_messages AS unread_messages_14, c6_.unread_since AS unread_since_15 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u5_ ON c1_.user_id = u5_.id LEFT JOIN (chat_message_dialogue c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN (chat_message_group c3_ INNER JOIN chat_message c11_ ON c3_.id = c11_.id) ON (c11_.id = c1_.id) LEFT JOIN (chat_message_channel c4_ INNER JOIN chat_message c12_ ON c4_.id = c12_.id) ON (c12_.id = c1_.id) LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = 7151) WHERE c0_.school_owner_id = 50 AND c0_.type = 'dialogue' AND c0_.active = 1 AND c6_.id IS NOT NULL AND c1_.id IS NOT NULL;
0.19 ms (3.08%)	1	SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN (chat_message_channel c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowChannel = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = ?) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type = ? AND f4_.id IN (?) Parameters: [`7151 50 1 "channel" 46`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN ( chat_message_channel c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id ) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowChannel = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON ( c6_.chat_id = c0_.id AND c6_.user_id = ? ) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type = ? AND f4_.id IN (?) SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN (chat_message_channel c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowChannel = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = 7151) WHERE c0_.school_owner_id = 50 AND c0_.active = 1 AND c0_.type = 'channel' AND f4_.id IN (46);
0.17 ms (2.84%)	3	SELECT t0.name AS name_1, t0.is_owner AS is_owner_2, t0.role AS role_3, t0.icon AS icon_4, t0.actions AS actions_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.active AS active_10, t0.sort AS sort_11, t0.school_id AS school_id_12 FROM school_employee_role t0 WHERE t0.id = ? Parameters: [`197`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.is_owner AS is_owner_2, t0.role AS role_3, t0.icon AS icon_4, t0.actions AS actions_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.active AS active_10, t0.sort AS sort_11, t0.school_id AS school_id_12 FROM school_employee_role t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.is_owner AS is_owner_2, t0.role AS role_3, t0.icon AS icon_4, t0.actions AS actions_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.active AS active_10, t0.sort AS sort_11, t0.school_id AS school_id_12 FROM school_employee_role t0 WHERE t0.id = 197;
0.16 ms (2.62%)	1	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.course_id = ? Parameters: [`40`] 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.course_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.course_id = 40;
0.14 ms (2.23%)	1	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);
0.12 ms (1.95%)	1	SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN (chat_message_group c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowGroup = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = ?) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type = ? AND f4_.id IN (?) Parameters: [`7151 50 1 "group" 46`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN ( chat_message_group c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id ) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowGroup = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON ( c6_.chat_id = c0_.id AND c6_.user_id = ? ) WHERE c0_.school_owner_id = ? AND c0_.active = ? AND c0_.type = ? AND f4_.id IN (?) SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.active AS active_2, c0_.name AS name_3, c0_.description AS description_4, c0_.type AS type_5, c1_.id AS id_6, c1_.create_at AS create_at_7, c1_.file_type AS file_type_8, c2_.text AS text_9, u3_.id AS id_10, u3_.uuid AS uuid_11, u3_.name AS name_12, u3_.avatar_id AS sclr_13, f4_.id AS id_14, f4_.name AS name_15, c5_.id AS id_16, c5_.name AS name_17, c5_.cover_id AS sclr_18, c6_.unread_messages AS unread_messages_19, c6_.unread_since AS unread_since_20 FROM chat c0_ LEFT JOIN chat_message c1_ ON c0_.last_message_id = c1_.id LEFT JOIN chat_message_dialogue c7_ ON c1_.id = c7_.id LEFT JOIN chat_message_group c8_ ON c1_.id = c8_.id LEFT JOIN chat_message_channel c9_ ON c1_.id = c9_.id LEFT JOIN users u3_ ON c1_.user_id = u3_.id LEFT JOIN (chat_message_group c2_ INNER JOIN chat_message c10_ ON c2_.id = c10_.id) ON (c10_.id = c1_.id) LEFT JOIN flow f4_ ON c0_.flowGroup = f4_.id LEFT JOIN course c5_ ON f4_.course_id = c5_.id LEFT JOIN chat_recipient c6_ ON (c6_.chat_id = c0_.id AND c6_.user_id = 7151) WHERE c0_.school_owner_id = 50 AND c0_.active = 1 AND c0_.type = 'group' AND f4_.id IN (46);
0.11 ms (1.82%)	1	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: [`46`] 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 = 46;
0.09 ms (1.43%)	1	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.course_id = ? Parameters: [`40`] 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.course_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.course_id = 40;
0.05 ms (0.87%)	1	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: [`46`] 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 = 46;

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\Chat\Recipient	No errors.
App\Entity\Chat\Message\Message	No errors.
App\Entity\Group\LessonAccess	No errors.
App\Entity\Group\Flow	No errors.
App\Entity\Course\Certificate\UserCertificate	No errors.
App\Entity\Payment\Gateway\Gateway	No errors.
App\Entity\Course\Certificate\CertificateTemplate	No errors.
App\Entity\Course\CoursePlan	No errors.
App\Entity\Course\CourseCategory	No errors.
App\Entity\Course\CourseFinishRule	No errors.
App\Entity\Course\CourseCertificateRule	No errors.
App\Entity\Webinar\WebinarFlow	No errors.
App\Entity\Chat\Message\MessageDialogue	No errors.
App\Entity\Chat\Message\MessageGroup	No errors.
App\Entity\Chat\Message\MessageChannel	No errors.
App\Entity\School\SchoolEmployeeRole	No errors.

Symfony Profiler

GET https://963174.dev-4.sksp.site/api/chat/list

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping