Symfony Profiler

Query Metrics

42 Database Queries

33 Different statements

9.07 ms Query time

0 Invalid entities

Grouped Statements

Time▼	Count	Info
1.10 ms (12.11%)	5	SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND c0_.course_id = ? AND c0_.role = ? AND c2_.deleted = ? LIMIT 1 Parameters: [`7158 37 "ROLE_STUDENT" 0`] View formatted query View runnable query Explain query SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND c0_.course_id = ? AND c0_.role = ? AND c2_.deleted = ? LIMIT 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, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = 7158 AND c0_.course_id = 37 AND c0_.role = 'ROLE_STUDENT' AND c2_.deleted = 0 LIMIT 1;
0.60 ms (6.64%)	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, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND c0_.course_id = ? AND c2_.deleted = ? LIMIT 1 Parameters: [`7158 37 0`] View formatted query View runnable query Explain query SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = ? AND c0_.course_id = ? AND c2_.deleted = ? LIMIT 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, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN users u1_ ON c0_.user_id = u1_.id LEFT JOIN course c2_ ON c0_.course_id = c2_.id WHERE c0_.user_id = 7158 AND c0_.course_id = 37 AND c2_.deleted = 0 LIMIT 1;
0.56 ms (6.21%)	3	SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.lesson_id IS NOT NULL AND l1_.uuid IS NOT NULL AND u0_.user_id = ? AND s2_.course_id = ? AND l1_.deleted = ? AND l1_.status IN (?, ?) Parameters: [`7158 37 0 "published" "published-draw"`] View formatted query View runnable query Explain query SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.lesson_id IS NOT NULL AND l1_.uuid IS NOT NULL AND u0_.user_id = ? AND s2_.course_id = ? AND l1_.deleted = ? AND l1_.status IN (?, ?) SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.lesson_id IS NOT NULL AND l1_.uuid IS NOT NULL AND u0_.user_id = 7158 AND s2_.course_id = 37 AND l1_.deleted = 0 AND l1_.status IN ('published', 'published-draw');
0.48 ms (5.32%)	2	SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN lesson_employee ON t0.id = lesson_employee.course_user_id WHERE lesson_employee.lesson_id = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN lesson_employee ON t0.id = lesson_employee.course_user_id WHERE lesson_employee.lesson_id = ? SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN lesson_employee ON t0.id = lesson_employee.course_user_id WHERE lesson_employee.lesson_id = 54;
0.40 ms (4.41%)	1	SELECT t0.name AS name_1, t0.slug AS slug_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.published AS published_5, t0.closed AS closed_6, t0.price AS price_7, t0.old_price AS old_price_8, t0.custom_payment_link AS custom_payment_link_9, t0.free_first_step AS free_first_step_10, t0.private_status AS private_status_11, t0.includes AS includes_12, t0.show_reviews AS show_reviews_13, t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14, t0.hard_sequence AS hard_sequence_15, t0.use_landing_external_url AS use_landing_external_url_16, t0.landing_external_url AS landing_external_url_17, t0.copy_protected AS copy_protected_18, t0.video_protected AS video_protected_19, t0.enable_certificate AS enable_certificate_20, t0.deleted AS deleted_21, t0.deleted_at AS deleted_at_22, t0.calculation_in_progress AS calculation_in_progress_23, t0.background_dimming AS background_dimming_24, t0.background_mobile_dimming AS background_mobile_dimming_25, t0.mobile_background_type AS mobile_background_type_26, t0.id AS id_27, t0.create_at AS create_at_28, t0.update_at AS update_at_29, t0.sort AS sort_30, t0.uuid AS uuid_31, t0.cover_id AS cover_id_32, t0.background_id AS background_id_33, t0.mobile_background_id AS mobile_background_id_34, t0.school_id AS school_id_35, t0.flow_to_add_id AS flow_to_add_id_36, t0.payment_gateway_id AS payment_gateway_id_37, t0.installment_gateway_id AS installment_gateway_id_38, t39.rules AS rules_40, t39.draw_rules AS draw_rules_41, t39.published_at AS published_at_42, t39.display_share_buttons AS display_share_buttons_43, t39.draw_display_share_buttons AS draw_display_share_buttons_44, t39.title AS title_45, t39.draw_title AS draw_title_46, t39.subtitle AS subtitle_47, t39.draw_subtitle AS draw_subtitle_48, t39.status AS status_49, t39.display_student AS display_student_50, t39.draw_display_student AS draw_display_student_51, t39.id AS id_52, t39.create_at AS create_at_53, t39.update_at AS update_at_54, t39.uuid AS uuid_55, t39.school_id AS school_id_56, t39.course_id AS course_id_57, t39.group_id AS group_id_58, t59.rules AS rules_60, t59.draw_rules AS draw_rules_61, t59.display_share_buttons AS display_share_buttons_62, t59.draw_display_share_buttons AS draw_display_share_buttons_63, t59.status AS status_64, t59.published_at AS published_at_65, t59.id AS id_66, t59.create_at AS create_at_67, t59.update_at AS update_at_68, t59.uuid AS uuid_69, t59.school_id AS school_id_70, t59.course_id AS course_id_71, t59.group_id AS group_id_72, t0.certificate_template_id AS certificate_template_id_73, t0.draw_certificate_template_id AS draw_certificate_template_id_74, t0.course_certificate_template_id AS course_certificate_template_id_75 FROM course t0 LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id WHERE t0.id = ? AND t0.school_id = ? AND t0.deleted = ? LIMIT 1 Parameters: [`37 50 0`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.slug AS slug_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.published AS published_5, t0.closed AS closed_6, t0.price AS price_7, t0.old_price AS old_price_8, t0.custom_payment_link AS custom_payment_link_9, t0.free_first_step AS free_first_step_10, t0.private_status AS private_status_11, t0.includes AS includes_12, t0.show_reviews AS show_reviews_13, t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14, t0.hard_sequence AS hard_sequence_15, t0.use_landing_external_url AS use_landing_external_url_16, t0.landing_external_url AS landing_external_url_17, t0.copy_protected AS copy_protected_18, t0.video_protected AS video_protected_19, t0.enable_certificate AS enable_certificate_20, t0.deleted AS deleted_21, t0.deleted_at AS deleted_at_22, t0.calculation_in_progress AS calculation_in_progress_23, t0.background_dimming AS background_dimming_24, t0.background_mobile_dimming AS background_mobile_dimming_25, t0.mobile_background_type AS mobile_background_type_26, t0.id AS id_27, t0.create_at AS create_at_28, t0.update_at AS update_at_29, t0.sort AS sort_30, t0.uuid AS uuid_31, t0.cover_id AS cover_id_32, t0.background_id AS background_id_33, t0.mobile_background_id AS mobile_background_id_34, t0.school_id AS school_id_35, t0.flow_to_add_id AS flow_to_add_id_36, t0.payment_gateway_id AS payment_gateway_id_37, t0.installment_gateway_id AS installment_gateway_id_38, t39.rules AS rules_40, t39.draw_rules AS draw_rules_41, t39.published_at AS published_at_42, t39.display_share_buttons AS display_share_buttons_43, t39.draw_display_share_buttons AS draw_display_share_buttons_44, t39.title AS title_45, t39.draw_title AS draw_title_46, t39.subtitle AS subtitle_47, t39.draw_subtitle AS draw_subtitle_48, t39.status AS status_49, t39.display_student AS display_student_50, t39.draw_display_student AS draw_display_student_51, t39.id AS id_52, t39.create_at AS create_at_53, t39.update_at AS update_at_54, t39.uuid AS uuid_55, t39.school_id AS school_id_56, t39.course_id AS course_id_57, t39.group_id AS group_id_58, t59.rules AS rules_60, t59.draw_rules AS draw_rules_61, t59.display_share_buttons AS display_share_buttons_62, t59.draw_display_share_buttons AS draw_display_share_buttons_63, t59.status AS status_64, t59.published_at AS published_at_65, t59.id AS id_66, t59.create_at AS create_at_67, t59.update_at AS update_at_68, t59.uuid AS uuid_69, t59.school_id AS school_id_70, t59.course_id AS course_id_71, t59.group_id AS group_id_72, t0.certificate_template_id AS certificate_template_id_73, t0.draw_certificate_template_id AS draw_certificate_template_id_74, t0.course_certificate_template_id AS course_certificate_template_id_75 FROM course t0 LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id WHERE t0.id = ? AND t0.school_id = ? AND t0.deleted = ? LIMIT 1 SELECT t0.name AS name_1, t0.slug AS slug_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.published AS published_5, t0.closed AS closed_6, t0.price AS price_7, t0.old_price AS old_price_8, t0.custom_payment_link AS custom_payment_link_9, t0.free_first_step AS free_first_step_10, t0.private_status AS private_status_11, t0.includes AS includes_12, t0.show_reviews AS show_reviews_13, t0.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_14, t0.hard_sequence AS hard_sequence_15, t0.use_landing_external_url AS use_landing_external_url_16, t0.landing_external_url AS landing_external_url_17, t0.copy_protected AS copy_protected_18, t0.video_protected AS video_protected_19, t0.enable_certificate AS enable_certificate_20, t0.deleted AS deleted_21, t0.deleted_at AS deleted_at_22, t0.calculation_in_progress AS calculation_in_progress_23, t0.background_dimming AS background_dimming_24, t0.background_mobile_dimming AS background_mobile_dimming_25, t0.mobile_background_type AS mobile_background_type_26, t0.id AS id_27, t0.create_at AS create_at_28, t0.update_at AS update_at_29, t0.sort AS sort_30, t0.uuid AS uuid_31, t0.cover_id AS cover_id_32, t0.background_id AS background_id_33, t0.mobile_background_id AS mobile_background_id_34, t0.school_id AS school_id_35, t0.flow_to_add_id AS flow_to_add_id_36, t0.payment_gateway_id AS payment_gateway_id_37, t0.installment_gateway_id AS installment_gateway_id_38, t39.rules AS rules_40, t39.draw_rules AS draw_rules_41, t39.published_at AS published_at_42, t39.display_share_buttons AS display_share_buttons_43, t39.draw_display_share_buttons AS draw_display_share_buttons_44, t39.title AS title_45, t39.draw_title AS draw_title_46, t39.subtitle AS subtitle_47, t39.draw_subtitle AS draw_subtitle_48, t39.status AS status_49, t39.display_student AS display_student_50, t39.draw_display_student AS draw_display_student_51, t39.id AS id_52, t39.create_at AS create_at_53, t39.update_at AS update_at_54, t39.uuid AS uuid_55, t39.school_id AS school_id_56, t39.course_id AS course_id_57, t39.group_id AS group_id_58, t59.rules AS rules_60, t59.draw_rules AS draw_rules_61, t59.display_share_buttons AS display_share_buttons_62, t59.draw_display_share_buttons AS draw_display_share_buttons_63, t59.status AS status_64, t59.published_at AS published_at_65, t59.id AS id_66, t59.create_at AS create_at_67, t59.update_at AS update_at_68, t59.uuid AS uuid_69, t59.school_id AS school_id_70, t59.course_id AS course_id_71, t59.group_id AS group_id_72, t0.certificate_template_id AS certificate_template_id_73, t0.draw_certificate_template_id AS draw_certificate_template_id_74, t0.course_certificate_template_id AS course_certificate_template_id_75 FROM course t0 LEFT JOIN course_finish_rule t39 ON t39.course_id = t0.id LEFT JOIN course_certificate_rule t59 ON t59.course_id = t0.id WHERE t0.id = 37 AND t0.school_id = 50 AND t0.deleted = 0 LIMIT 1;
0.40 ms (4.41%)	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_ WHERE s0_.school_id = ? AND s0_.user_id = ? AND s0_.role = ? LIMIT 1 Parameters: [`50 7158 "ROLE_STUDENT"`] 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_ WHERE s0_.school_id = ? AND s0_.user_id = ? AND s0_.role = ? LIMIT 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_ WHERE s0_.school_id = 50 AND s0_.user_id = 7158 AND s0_.role = 'ROLE_STUDENT' LIMIT 1;
0.40 ms (4.36%)	1	SELECT t0.name AS name_1, t0.user_limit AS user_limit_2, t0.homework_block AS homework_block_3, t0.dialogue_with_employees_block AS dialogue_with_employees_block_4, t0.lessons_access AS lessons_access_5, t0.hard_sequence AS hard_sequence_6, t0.hard_sequence_homework AS hard_sequence_homework_7, t0.hard_sequence_test AS hard_sequence_test_8, t0.enable_certificate AS enable_certificate_9, t0.limit_students AS limit_students_10, t0.display_unavailable_lesson_student AS display_unavailable_lesson_student_11, t0.id AS id_12, t0.create_at AS create_at_13, t0.update_at AS update_at_14, t0.sort AS sort_15, t0.uuid AS uuid_16, t0.access_lessons AS access_lessons_17, t0.access_dates AS access_dates_18, t0.access_type AS access_type_19, t0.access_access_opens_for AS access_access_opens_for_20, t0.access_weekdays AS access_weekdays_21, t0.access_weekdays_start_date AS access_weekdays_start_date_22, t0.access_once_for_days_interval AS access_once_for_days_interval_23, t0.access_once_for_days_start_date AS access_once_for_days_start_date_24, t0.access_for_time_type AS access_for_time_type_25, t0.access_for_time_start_date AS access_for_time_start_date_26, t0.access_for_time_range AS access_for_time_range_27, t0.access_is_open_for_time AS access_is_open_for_time_28, t0.access_is_open_for_schedule AS access_is_open_for_schedule_29, t0.access_for_schedule_type AS access_for_schedule_type_30, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_31, t0.course_id AS course_id_32, t33.last_message_date AS last_message_date_34, t33.active AS active_35, t33.name AS name_36, t33.description AS description_37, t33.type AS type_38, t33.id AS id_39, t33.create_at AS create_at_40, t33.update_at AS update_at_41, t33.uuid AS uuid_42, t33.school_owner_id AS school_owner_id_43, t33.last_message_id AS last_message_id_44, t33.flowChannel AS flowChannel_45, t33.flowGroup AS flowGroup_46, t33.flow_id AS flow_id_47, t33.schoolChannel AS schoolChannel_48, t33.schoolGroup AS schoolGroup_49, t33.school_id AS school_id_50, t51.last_message_date AS last_message_date_52, t51.active AS active_53, t51.name AS name_54, t51.description AS description_55, t51.type AS type_56, t51.id AS id_57, t51.create_at AS create_at_58, t51.update_at AS update_at_59, t51.uuid AS uuid_60, t51.school_owner_id AS school_owner_id_61, t51.last_message_id AS last_message_id_62, t51.flowChannel AS flowChannel_63, t51.flowGroup AS flowGroup_64, t51.flow_id AS flow_id_65, t51.schoolChannel AS schoolChannel_66, t51.schoolGroup AS schoolGroup_67, t51.school_id AS school_id_68, t69.rules AS rules_70, t69.draw_rules AS draw_rules_71, t69.published_at AS published_at_72, t69.display_share_buttons AS display_share_buttons_73, t69.draw_display_share_buttons AS draw_display_share_buttons_74, t69.title AS title_75, t69.draw_title AS draw_title_76, t69.subtitle AS subtitle_77, t69.draw_subtitle AS draw_subtitle_78, t69.status AS status_79, t69.display_student AS display_student_80, t69.draw_display_student AS draw_display_student_81, t69.id AS id_82, t69.create_at AS create_at_83, t69.update_at AS update_at_84, t69.uuid AS uuid_85, t69.school_id AS school_id_86, t69.course_id AS course_id_87, t69.group_id AS group_id_88, t89.rules AS rules_90, t89.draw_rules AS draw_rules_91, t89.display_share_buttons AS display_share_buttons_92, t89.draw_display_share_buttons AS draw_display_share_buttons_93, t89.status AS status_94, t89.published_at AS published_at_95, t89.id AS id_96, t89.create_at AS create_at_97, t89.update_at AS update_at_98, t89.uuid AS uuid_99, t89.school_id AS school_id_100, t89.course_id AS course_id_101, t89.group_id AS group_id_102 FROM flow t0 LEFT JOIN chat t33 ON t33.flowChannel = t0.id LEFT JOIN chat t51 ON t51.flowGroup = t0.id LEFT JOIN course_finish_rule t69 ON t69.group_id = t0.id LEFT JOIN course_certificate_rule t89 ON t89.group_id = t0.id WHERE t0.course_id = ? ORDER BY t0.id ASC Parameters: [`37`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.user_limit AS user_limit_2, t0.homework_block AS homework_block_3, t0.dialogue_with_employees_block AS dialogue_with_employees_block_4, t0.lessons_access AS lessons_access_5, t0.hard_sequence AS hard_sequence_6, t0.hard_sequence_homework AS hard_sequence_homework_7, t0.hard_sequence_test AS hard_sequence_test_8, t0.enable_certificate AS enable_certificate_9, t0.limit_students AS limit_students_10, t0.display_unavailable_lesson_student AS display_unavailable_lesson_student_11, t0.id AS id_12, t0.create_at AS create_at_13, t0.update_at AS update_at_14, t0.sort AS sort_15, t0.uuid AS uuid_16, t0.access_lessons AS access_lessons_17, t0.access_dates AS access_dates_18, t0.access_type AS access_type_19, t0.access_access_opens_for AS access_access_opens_for_20, t0.access_weekdays AS access_weekdays_21, t0.access_weekdays_start_date AS access_weekdays_start_date_22, t0.access_once_for_days_interval AS access_once_for_days_interval_23, t0.access_once_for_days_start_date AS access_once_for_days_start_date_24, t0.access_for_time_type AS access_for_time_type_25, t0.access_for_time_start_date AS access_for_time_start_date_26, t0.access_for_time_range AS access_for_time_range_27, t0.access_is_open_for_time AS access_is_open_for_time_28, t0.access_is_open_for_schedule AS access_is_open_for_schedule_29, t0.access_for_schedule_type AS access_for_schedule_type_30, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_31, t0.course_id AS course_id_32, t33.last_message_date AS last_message_date_34, t33.active AS active_35, t33.name AS name_36, t33.description AS description_37, t33.type AS type_38, t33.id AS id_39, t33.create_at AS create_at_40, t33.update_at AS update_at_41, t33.uuid AS uuid_42, t33.school_owner_id AS school_owner_id_43, t33.last_message_id AS last_message_id_44, t33.flowChannel AS flowChannel_45, t33.flowGroup AS flowGroup_46, t33.flow_id AS flow_id_47, t33.schoolChannel AS schoolChannel_48, t33.schoolGroup AS schoolGroup_49, t33.school_id AS school_id_50, t51.last_message_date AS last_message_date_52, t51.active AS active_53, t51.name AS name_54, t51.description AS description_55, t51.type AS type_56, t51.id AS id_57, t51.create_at AS create_at_58, t51.update_at AS update_at_59, t51.uuid AS uuid_60, t51.school_owner_id AS school_owner_id_61, t51.last_message_id AS last_message_id_62, t51.flowChannel AS flowChannel_63, t51.flowGroup AS flowGroup_64, t51.flow_id AS flow_id_65, t51.schoolChannel AS schoolChannel_66, t51.schoolGroup AS schoolGroup_67, t51.school_id AS school_id_68, t69.rules AS rules_70, t69.draw_rules AS draw_rules_71, t69.published_at AS published_at_72, t69.display_share_buttons AS display_share_buttons_73, t69.draw_display_share_buttons AS draw_display_share_buttons_74, t69.title AS title_75, t69.draw_title AS draw_title_76, t69.subtitle AS subtitle_77, t69.draw_subtitle AS draw_subtitle_78, t69.status AS status_79, t69.display_student AS display_student_80, t69.draw_display_student AS draw_display_student_81, t69.id AS id_82, t69.create_at AS create_at_83, t69.update_at AS update_at_84, t69.uuid AS uuid_85, t69.school_id AS school_id_86, t69.course_id AS course_id_87, t69.group_id AS group_id_88, t89.rules AS rules_90, t89.draw_rules AS draw_rules_91, t89.display_share_buttons AS display_share_buttons_92, t89.draw_display_share_buttons AS draw_display_share_buttons_93, t89.status AS status_94, t89.published_at AS published_at_95, t89.id AS id_96, t89.create_at AS create_at_97, t89.update_at AS update_at_98, t89.uuid AS uuid_99, t89.school_id AS school_id_100, t89.course_id AS course_id_101, t89.group_id AS group_id_102 FROM flow t0 LEFT JOIN chat t33 ON t33.flowChannel = t0.id LEFT JOIN chat t51 ON t51.flowGroup = t0.id LEFT JOIN course_finish_rule t69 ON t69.group_id = t0.id LEFT JOIN course_certificate_rule t89 ON t89.group_id = t0.id WHERE t0.course_id = ? ORDER BY t0.id ASC SELECT t0.name AS name_1, t0.user_limit AS user_limit_2, t0.homework_block AS homework_block_3, t0.dialogue_with_employees_block AS dialogue_with_employees_block_4, t0.lessons_access AS lessons_access_5, t0.hard_sequence AS hard_sequence_6, t0.hard_sequence_homework AS hard_sequence_homework_7, t0.hard_sequence_test AS hard_sequence_test_8, t0.enable_certificate AS enable_certificate_9, t0.limit_students AS limit_students_10, t0.display_unavailable_lesson_student AS display_unavailable_lesson_student_11, t0.id AS id_12, t0.create_at AS create_at_13, t0.update_at AS update_at_14, t0.sort AS sort_15, t0.uuid AS uuid_16, t0.access_lessons AS access_lessons_17, t0.access_dates AS access_dates_18, t0.access_type AS access_type_19, t0.access_access_opens_for AS access_access_opens_for_20, t0.access_weekdays AS access_weekdays_21, t0.access_weekdays_start_date AS access_weekdays_start_date_22, t0.access_once_for_days_interval AS access_once_for_days_interval_23, t0.access_once_for_days_start_date AS access_once_for_days_start_date_24, t0.access_for_time_type AS access_for_time_type_25, t0.access_for_time_start_date AS access_for_time_start_date_26, t0.access_for_time_range AS access_for_time_range_27, t0.access_is_open_for_time AS access_is_open_for_time_28, t0.access_is_open_for_schedule AS access_is_open_for_schedule_29, t0.access_for_schedule_type AS access_for_schedule_type_30, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_31, t0.course_id AS course_id_32, t33.last_message_date AS last_message_date_34, t33.active AS active_35, t33.name AS name_36, t33.description AS description_37, t33.type AS type_38, t33.id AS id_39, t33.create_at AS create_at_40, t33.update_at AS update_at_41, t33.uuid AS uuid_42, t33.school_owner_id AS school_owner_id_43, t33.last_message_id AS last_message_id_44, t33.flowChannel AS flowChannel_45, t33.flowGroup AS flowGroup_46, t33.flow_id AS flow_id_47, t33.schoolChannel AS schoolChannel_48, t33.schoolGroup AS schoolGroup_49, t33.school_id AS school_id_50, t51.last_message_date AS last_message_date_52, t51.active AS active_53, t51.name AS name_54, t51.description AS description_55, t51.type AS type_56, t51.id AS id_57, t51.create_at AS create_at_58, t51.update_at AS update_at_59, t51.uuid AS uuid_60, t51.school_owner_id AS school_owner_id_61, t51.last_message_id AS last_message_id_62, t51.flowChannel AS flowChannel_63, t51.flowGroup AS flowGroup_64, t51.flow_id AS flow_id_65, t51.schoolChannel AS schoolChannel_66, t51.schoolGroup AS schoolGroup_67, t51.school_id AS school_id_68, t69.rules AS rules_70, t69.draw_rules AS draw_rules_71, t69.published_at AS published_at_72, t69.display_share_buttons AS display_share_buttons_73, t69.draw_display_share_buttons AS draw_display_share_buttons_74, t69.title AS title_75, t69.draw_title AS draw_title_76, t69.subtitle AS subtitle_77, t69.draw_subtitle AS draw_subtitle_78, t69.status AS status_79, t69.display_student AS display_student_80, t69.draw_display_student AS draw_display_student_81, t69.id AS id_82, t69.create_at AS create_at_83, t69.update_at AS update_at_84, t69.uuid AS uuid_85, t69.school_id AS school_id_86, t69.course_id AS course_id_87, t69.group_id AS group_id_88, t89.rules AS rules_90, t89.draw_rules AS draw_rules_91, t89.display_share_buttons AS display_share_buttons_92, t89.draw_display_share_buttons AS draw_display_share_buttons_93, t89.status AS status_94, t89.published_at AS published_at_95, t89.id AS id_96, t89.create_at AS create_at_97, t89.update_at AS update_at_98, t89.uuid AS uuid_99, t89.school_id AS school_id_100, t89.course_id AS course_id_101, t89.group_id AS group_id_102 FROM flow t0 LEFT JOIN chat t33 ON t33.flowChannel = t0.id LEFT JOIN chat t51 ON t51.flowGroup = t0.id LEFT JOIN course_finish_rule t69 ON t69.group_id = t0.id LEFT JOIN course_certificate_rule t89 ON t89.group_id = t0.id WHERE t0.course_id = 37 ORDER BY t0.id ASC;
0.37 ms (4.10%)	1	SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = ? ORDER BY t0.sort ASC SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.type AS type_6, t0.features_limit AS features_limit_7, t0.delete_at AS delete_at_8, t0.removed AS removed_9, t0.display_plan_page AS display_plan_page_10, t0.id AS id_11, t0.create_at AS create_at_12, t0.update_at AS update_at_13, t0.sort AS sort_14 FROM subscription_plan_feature t0 INNER JOIN plan_plan_feature ON t0.id = plan_plan_feature.plan_feature_id WHERE plan_plan_feature.plan_id = 1 ORDER BY t0.sort ASC;
0.36 ms (3.93%)	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: [`"cb5eb972-00b7-4db3-80bd-24ebb5d917cb"`] 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 = 'cb5eb972-00b7-4db3-80bd-24ebb5d917cb' LIMIT 1;
0.33 ms (3.60%)	1	SELECT t0.code AS code_14, t0.type AS type_15, t0.status AS status_16, t0.error AS error_17, t0.name AS name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.uuid AS uuid_22, t0.school_id AS school_id_23, t0.gateway, t1.shop_id AS shop_id_24, t1.secret_key AS secret_key_25, t1.vat AS vat_26, t2.terminal_key AS terminal_key_27, t2.secret_key AS secret_key_28, t2.taxation AS taxation_29, t2.vat AS vat_30, t3.secret_key AS secret_key_31, t3.url AS url_32, t3.dont_check_payment_sum AS dont_check_payment_sum_33, t4.merchant_id AS merchant_id_34, t4.secret AS secret_35, t4.taxation_system AS taxation_system_36, t4.vat AS vat_37, t5.api_key AS api_key_38, t6.login AS login_39, t6.password AS password_40, t6.secret AS secret_41, t7.login AS login_42, t7.password AS password_43, t7.secret AS secret_44, t8.shop_id AS shop_id_45, t8.secret_key AS secret_key_46, t8.rsa_public_key AS rsa_public_key_47, t9.public_id AS public_id_48, t9.private_key AS private_key_49, t9.country AS country_50, t9.tax_system AS tax_system_51, t9.vat AS vat_52, t10.user_name AS user_name_53, t10.password AS password_54, t10.tax_system AS tax_system_55, t10.tax_type AS tax_type_56, t10.callback_token AS callback_token_57, t11.token AS token_58, t11.client_id AS client_id_59, t11.customer_code AS customer_code_60, t11.merchant_id AS merchant_id_61, t11.tax_system AS tax_system_62, t11.vat AS vat_63, t12.api_key AS api_key_64, t12.payment_options_id AS payment_options_id_65, t12.vat AS vat_66, t13.client_id AS client_id_67, t13.client_secret AS client_secret_68, t13.merchant_authorization AS merchant_authorization_69, t13.vat AS vat_70 FROM payment_gateway t0 LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.code AS code_14, t0.type AS type_15, t0.status AS status_16, t0.error AS error_17, t0.name AS name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.uuid AS uuid_22, t0.school_id AS school_id_23, t0.gateway, t1.shop_id AS shop_id_24, t1.secret_key AS secret_key_25, t1.vat AS vat_26, t2.terminal_key AS terminal_key_27, t2.secret_key AS secret_key_28, t2.taxation AS taxation_29, t2.vat AS vat_30, t3.secret_key AS secret_key_31, t3.url AS url_32, t3.dont_check_payment_sum AS dont_check_payment_sum_33, t4.merchant_id AS merchant_id_34, t4.secret AS secret_35, t4.taxation_system AS taxation_system_36, t4.vat AS vat_37, t5.api_key AS api_key_38, t6.login AS login_39, t6.password AS password_40, t6.secret AS secret_41, t7.login AS login_42, t7.password AS password_43, t7.secret AS secret_44, t8.shop_id AS shop_id_45, t8.secret_key AS secret_key_46, t8.rsa_public_key AS rsa_public_key_47, t9.public_id AS public_id_48, t9.private_key AS private_key_49, t9.country AS country_50, t9.tax_system AS tax_system_51, t9.vat AS vat_52, t10.user_name AS user_name_53, t10.password AS password_54, t10.tax_system AS tax_system_55, t10.tax_type AS tax_type_56, t10.callback_token AS callback_token_57, t11.token AS token_58, t11.client_id AS client_id_59, t11.customer_code AS customer_code_60, t11.merchant_id AS merchant_id_61, t11.tax_system AS tax_system_62, t11.vat AS vat_63, t12.api_key AS api_key_64, t12.payment_options_id AS payment_options_id_65, t12.vat AS vat_66, t13.client_id AS client_id_67, t13.client_secret AS client_secret_68, t13.merchant_authorization AS merchant_authorization_69, t13.vat AS vat_70 FROM payment_gateway t0 LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id WHERE t0.id = ? SELECT t0.code AS code_14, t0.type AS type_15, t0.status AS status_16, t0.error AS error_17, t0.name AS name_18, t0.id AS id_19, t0.create_at AS create_at_20, t0.update_at AS update_at_21, t0.uuid AS uuid_22, t0.school_id AS school_id_23, t0.gateway, t1.shop_id AS shop_id_24, t1.secret_key AS secret_key_25, t1.vat AS vat_26, t2.terminal_key AS terminal_key_27, t2.secret_key AS secret_key_28, t2.taxation AS taxation_29, t2.vat AS vat_30, t3.secret_key AS secret_key_31, t3.url AS url_32, t3.dont_check_payment_sum AS dont_check_payment_sum_33, t4.merchant_id AS merchant_id_34, t4.secret AS secret_35, t4.taxation_system AS taxation_system_36, t4.vat AS vat_37, t5.api_key AS api_key_38, t6.login AS login_39, t6.password AS password_40, t6.secret AS secret_41, t7.login AS login_42, t7.password AS password_43, t7.secret AS secret_44, t8.shop_id AS shop_id_45, t8.secret_key AS secret_key_46, t8.rsa_public_key AS rsa_public_key_47, t9.public_id AS public_id_48, t9.private_key AS private_key_49, t9.country AS country_50, t9.tax_system AS tax_system_51, t9.vat AS vat_52, t10.user_name AS user_name_53, t10.password AS password_54, t10.tax_system AS tax_system_55, t10.tax_type AS tax_type_56, t10.callback_token AS callback_token_57, t11.token AS token_58, t11.client_id AS client_id_59, t11.customer_code AS customer_code_60, t11.merchant_id AS merchant_id_61, t11.tax_system AS tax_system_62, t11.vat AS vat_63, t12.api_key AS api_key_64, t12.payment_options_id AS payment_options_id_65, t12.vat AS vat_66, t13.client_id AS client_id_67, t13.client_secret AS client_secret_68, t13.merchant_authorization AS merchant_authorization_69, t13.vat AS vat_70 FROM payment_gateway t0 LEFT JOIN payment_gateway_yandex_kassa t1 ON t0.id = t1.id LEFT JOIN payment_gateway_tinkoff t2 ON t0.id = t2.id LEFT JOIN payment_gateway_prodamus t3 ON t0.id = t3.id LEFT JOIN payment_gateway_mandarin_pay t4 ON t0.id = t4.id LEFT JOIN payment_gateway_mandarin_pay_installment t5 ON t0.id = t5.id LEFT JOIN payment_gateway_development_resource_installment t6 ON t0.id = t6.id LEFT JOIN payment_gateway_development_resource_v2_installment t7 ON t0.id = t7.id LEFT JOIN payment_gateway_be_paid t8 ON t0.id = t8.id LEFT JOIN payment_gateway_cloud_payments t9 ON t0.id = t9.id LEFT JOIN payment_gateway_gazprom t10 ON t0.id = t10.id LEFT JOIN payment_gateway_tochka t11 ON t0.id = t11.id LEFT JOIN payment_gateway_mandarin t12 ON t0.id = t12.id LEFT JOIN payment_gateway_vtb t13 ON t0.id = t13.id WHERE t0.id = 1;
0.32 ms (3.55%)	1	SELECT count(l0_.id) AS sclr_0 FROM lesson l0_ LEFT JOIN step s1_ ON l0_.step_id = s1_.id WHERE s1_.course_id = ? AND l0_.status IN (?, ?) AND l0_.deleted = ? Parameters: [`37 "published" "published-draw" 0`] View formatted query View runnable query Explain query SELECT count(l0_.id) AS sclr_0 FROM lesson l0_ LEFT JOIN step s1_ ON l0_.step_id = s1_.id WHERE s1_.course_id = ? AND l0_.status IN (?, ?) AND l0_.deleted = ? SELECT count(l0_.id) AS sclr_0 FROM lesson l0_ LEFT JOIN step s1_ ON l0_.step_id = s1_.id WHERE s1_.course_id = 37 AND l0_.status IN ('published', 'published-draw') AND l0_.deleted = 0;
0.32 ms (3.48%)	1	SELECT t0.slug AS slug_1, t0.yandex_metrika_code AS yandex_metrika_code_2, t0.google_analytics_code AS google_analytics_code_3, t0.facebook_pixel AS facebook_pixel_4, t0.vk_pixel AS vk_pixel_5, t0.primary_color AS primary_color_6, t0.landing_type AS landing_type_7, t0.hide_price_at_start AS hide_price_at_start_8, t0.plans_payment AS plans_payment_9, t0.order_title AS order_title_10, t0.order_subtitle AS order_subtitle_11, t0.published AS published_12, t0.price AS price_13, t0.price_old AS price_old_14, t0.currency AS currency_15, t0.social_networks_urls AS social_networks_urls_16, t0.id AS id_17, t0.create_at AS create_at_18, t0.update_at AS update_at_19, t0.sort AS sort_20, t0.uuid AS uuid_21, t0.course_id AS course_id_22, t23.name AS name_24, t23.slug AS slug_25, t23.short_description AS short_description_26, t23.description AS description_27, t23.published AS published_28, t23.closed AS closed_29, t23.price AS price_30, t23.old_price AS old_price_31, t23.custom_payment_link AS custom_payment_link_32, t23.free_first_step AS free_first_step_33, t23.private_status AS private_status_34, t23.includes AS includes_35, t23.show_reviews AS show_reviews_36, t23.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_37, t23.hard_sequence AS hard_sequence_38, t23.use_landing_external_url AS use_landing_external_url_39, t23.landing_external_url AS landing_external_url_40, t23.copy_protected AS copy_protected_41, t23.video_protected AS video_protected_42, t23.enable_certificate AS enable_certificate_43, t23.deleted AS deleted_44, t23.deleted_at AS deleted_at_45, t23.calculation_in_progress AS calculation_in_progress_46, t23.background_dimming AS background_dimming_47, t23.background_mobile_dimming AS background_mobile_dimming_48, t23.mobile_background_type AS mobile_background_type_49, t23.id AS id_50, t23.create_at AS create_at_51, t23.update_at AS update_at_52, t23.sort AS sort_53, t23.uuid AS uuid_54, t23.cover_id AS cover_id_55, t23.background_id AS background_id_56, t23.mobile_background_id AS mobile_background_id_57, t23.school_id AS school_id_58, t23.flow_to_add_id AS flow_to_add_id_59, t23.payment_gateway_id AS payment_gateway_id_60, t23.installment_gateway_id AS installment_gateway_id_61, t23.certificate_template_id AS certificate_template_id_62, t23.draw_certificate_template_id AS draw_certificate_template_id_63, t23.course_certificate_template_id AS course_certificate_template_id_64, t0.school_id AS school_id_65, t66.name AS name_67, t66.default_slug AS default_slug_68, t66.slug AS slug_69, t66.domain AS domain_70, t66.description AS description_71, t66.primary_color AS primary_color_72, t66.balance AS balance_73, t66.amo_company_id AS amo_company_id_74, t66.amo_register_deal_id AS amo_register_deal_id_75, t66.roistat AS roistat_76, t66.tagline AS tagline_77, t66.kinescope_project_id AS kinescope_project_id_78, t66.generate_invite_user_id AS generate_invite_user_id_79, t66.kinescope_player_id AS kinescope_player_id_80, t66.allow_self_register AS allow_self_register_81, t66.confirm_registration_code AS confirm_registration_code_82, t66.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_83, t66.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_84, t66.confirm_registration_finished AS confirm_registration_finished_85, t66.confirm_registration_skipped AS confirm_registration_skipped_86, t66.active AS active_87, t66.storage_size AS storage_size_88, t66.last_storage_size_calculation AS last_storage_size_calculation_89, t66.clear_storage_files AS clear_storage_files_90, t66.cover_dimming AS cover_dimming_91, t66.cover_mobile_dimming AS cover_mobile_dimming_92, t66.mobile_cover_type AS mobile_cover_type_93, t66.disable_clear_storage AS disable_clear_storage_94, t66.id AS id_95, t66.create_at AS create_at_96, t66.update_at AS update_at_97, t66.sort AS sort_98, t66.uuid AS uuid_99, t66.owner_id AS owner_id_100, t66.logo_id AS logo_id_101, t66.favicon_id AS favicon_id_102, t66.avatar_id AS avatar_id_103, t66.cover_id AS cover_id_104, t66.mobile_cover_id AS mobile_cover_id_105, t66.cover_change_id AS cover_change_id_106, t66.plan_id AS plan_id_107, t66.subscription_id AS subscription_id_108, t66.schoolChannel AS schoolChannel_109, t66.schoolGroup AS schoolGroup_110, t66.discount_id AS discount_id_111, t0.published_landing_id AS published_landing_id_112 FROM landing t0 LEFT JOIN course t23 ON t0.course_id = t23.id LEFT JOIN schools t66 ON t0.school_id = t66.id WHERE t0.course_id = ? Parameters: [`37`] View formatted query View runnable query Explain query SELECT t0.slug AS slug_1, t0.yandex_metrika_code AS yandex_metrika_code_2, t0.google_analytics_code AS google_analytics_code_3, t0.facebook_pixel AS facebook_pixel_4, t0.vk_pixel AS vk_pixel_5, t0.primary_color AS primary_color_6, t0.landing_type AS landing_type_7, t0.hide_price_at_start AS hide_price_at_start_8, t0.plans_payment AS plans_payment_9, t0.order_title AS order_title_10, t0.order_subtitle AS order_subtitle_11, t0.published AS published_12, t0.price AS price_13, t0.price_old AS price_old_14, t0.currency AS currency_15, t0.social_networks_urls AS social_networks_urls_16, t0.id AS id_17, t0.create_at AS create_at_18, t0.update_at AS update_at_19, t0.sort AS sort_20, t0.uuid AS uuid_21, t0.course_id AS course_id_22, t23.name AS name_24, t23.slug AS slug_25, t23.short_description AS short_description_26, t23.description AS description_27, t23.published AS published_28, t23.closed AS closed_29, t23.price AS price_30, t23.old_price AS old_price_31, t23.custom_payment_link AS custom_payment_link_32, t23.free_first_step AS free_first_step_33, t23.private_status AS private_status_34, t23.includes AS includes_35, t23.show_reviews AS show_reviews_36, t23.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_37, t23.hard_sequence AS hard_sequence_38, t23.use_landing_external_url AS use_landing_external_url_39, t23.landing_external_url AS landing_external_url_40, t23.copy_protected AS copy_protected_41, t23.video_protected AS video_protected_42, t23.enable_certificate AS enable_certificate_43, t23.deleted AS deleted_44, t23.deleted_at AS deleted_at_45, t23.calculation_in_progress AS calculation_in_progress_46, t23.background_dimming AS background_dimming_47, t23.background_mobile_dimming AS background_mobile_dimming_48, t23.mobile_background_type AS mobile_background_type_49, t23.id AS id_50, t23.create_at AS create_at_51, t23.update_at AS update_at_52, t23.sort AS sort_53, t23.uuid AS uuid_54, t23.cover_id AS cover_id_55, t23.background_id AS background_id_56, t23.mobile_background_id AS mobile_background_id_57, t23.school_id AS school_id_58, t23.flow_to_add_id AS flow_to_add_id_59, t23.payment_gateway_id AS payment_gateway_id_60, t23.installment_gateway_id AS installment_gateway_id_61, t23.certificate_template_id AS certificate_template_id_62, t23.draw_certificate_template_id AS draw_certificate_template_id_63, t23.course_certificate_template_id AS course_certificate_template_id_64, t0.school_id AS school_id_65, t66.name AS name_67, t66.default_slug AS default_slug_68, t66.slug AS slug_69, t66.domain AS domain_70, t66.description AS description_71, t66.primary_color AS primary_color_72, t66.balance AS balance_73, t66.amo_company_id AS amo_company_id_74, t66.amo_register_deal_id AS amo_register_deal_id_75, t66.roistat AS roistat_76, t66.tagline AS tagline_77, t66.kinescope_project_id AS kinescope_project_id_78, t66.generate_invite_user_id AS generate_invite_user_id_79, t66.kinescope_player_id AS kinescope_player_id_80, t66.allow_self_register AS allow_self_register_81, t66.confirm_registration_code AS confirm_registration_code_82, t66.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_83, t66.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_84, t66.confirm_registration_finished AS confirm_registration_finished_85, t66.confirm_registration_skipped AS confirm_registration_skipped_86, t66.active AS active_87, t66.storage_size AS storage_size_88, t66.last_storage_size_calculation AS last_storage_size_calculation_89, t66.clear_storage_files AS clear_storage_files_90, t66.cover_dimming AS cover_dimming_91, t66.cover_mobile_dimming AS cover_mobile_dimming_92, t66.mobile_cover_type AS mobile_cover_type_93, t66.disable_clear_storage AS disable_clear_storage_94, t66.id AS id_95, t66.create_at AS create_at_96, t66.update_at AS update_at_97, t66.sort AS sort_98, t66.uuid AS uuid_99, t66.owner_id AS owner_id_100, t66.logo_id AS logo_id_101, t66.favicon_id AS favicon_id_102, t66.avatar_id AS avatar_id_103, t66.cover_id AS cover_id_104, t66.mobile_cover_id AS mobile_cover_id_105, t66.cover_change_id AS cover_change_id_106, t66.plan_id AS plan_id_107, t66.subscription_id AS subscription_id_108, t66.schoolChannel AS schoolChannel_109, t66.schoolGroup AS schoolGroup_110, t66.discount_id AS discount_id_111, t0.published_landing_id AS published_landing_id_112 FROM landing t0 LEFT JOIN course t23 ON t0.course_id = t23.id LEFT JOIN schools t66 ON t0.school_id = t66.id WHERE t0.course_id = ? SELECT t0.slug AS slug_1, t0.yandex_metrika_code AS yandex_metrika_code_2, t0.google_analytics_code AS google_analytics_code_3, t0.facebook_pixel AS facebook_pixel_4, t0.vk_pixel AS vk_pixel_5, t0.primary_color AS primary_color_6, t0.landing_type AS landing_type_7, t0.hide_price_at_start AS hide_price_at_start_8, t0.plans_payment AS plans_payment_9, t0.order_title AS order_title_10, t0.order_subtitle AS order_subtitle_11, t0.published AS published_12, t0.price AS price_13, t0.price_old AS price_old_14, t0.currency AS currency_15, t0.social_networks_urls AS social_networks_urls_16, t0.id AS id_17, t0.create_at AS create_at_18, t0.update_at AS update_at_19, t0.sort AS sort_20, t0.uuid AS uuid_21, t0.course_id AS course_id_22, t23.name AS name_24, t23.slug AS slug_25, t23.short_description AS short_description_26, t23.description AS description_27, t23.published AS published_28, t23.closed AS closed_29, t23.price AS price_30, t23.old_price AS old_price_31, t23.custom_payment_link AS custom_payment_link_32, t23.free_first_step AS free_first_step_33, t23.private_status AS private_status_34, t23.includes AS includes_35, t23.show_reviews AS show_reviews_36, t23.add_to_default_flow_after_payment AS add_to_default_flow_after_payment_37, t23.hard_sequence AS hard_sequence_38, t23.use_landing_external_url AS use_landing_external_url_39, t23.landing_external_url AS landing_external_url_40, t23.copy_protected AS copy_protected_41, t23.video_protected AS video_protected_42, t23.enable_certificate AS enable_certificate_43, t23.deleted AS deleted_44, t23.deleted_at AS deleted_at_45, t23.calculation_in_progress AS calculation_in_progress_46, t23.background_dimming AS background_dimming_47, t23.background_mobile_dimming AS background_mobile_dimming_48, t23.mobile_background_type AS mobile_background_type_49, t23.id AS id_50, t23.create_at AS create_at_51, t23.update_at AS update_at_52, t23.sort AS sort_53, t23.uuid AS uuid_54, t23.cover_id AS cover_id_55, t23.background_id AS background_id_56, t23.mobile_background_id AS mobile_background_id_57, t23.school_id AS school_id_58, t23.flow_to_add_id AS flow_to_add_id_59, t23.payment_gateway_id AS payment_gateway_id_60, t23.installment_gateway_id AS installment_gateway_id_61, t23.certificate_template_id AS certificate_template_id_62, t23.draw_certificate_template_id AS draw_certificate_template_id_63, t23.course_certificate_template_id AS course_certificate_template_id_64, t0.school_id AS school_id_65, t66.name AS name_67, t66.default_slug AS default_slug_68, t66.slug AS slug_69, t66.domain AS domain_70, t66.description AS description_71, t66.primary_color AS primary_color_72, t66.balance AS balance_73, t66.amo_company_id AS amo_company_id_74, t66.amo_register_deal_id AS amo_register_deal_id_75, t66.roistat AS roistat_76, t66.tagline AS tagline_77, t66.kinescope_project_id AS kinescope_project_id_78, t66.generate_invite_user_id AS generate_invite_user_id_79, t66.kinescope_player_id AS kinescope_player_id_80, t66.allow_self_register AS allow_self_register_81, t66.confirm_registration_code AS confirm_registration_code_82, t66.confirm_registration_code_sent_date AS confirm_registration_code_sent_date_83, t66.confirm_registration_code_sent_count AS confirm_registration_code_sent_count_84, t66.confirm_registration_finished AS confirm_registration_finished_85, t66.confirm_registration_skipped AS confirm_registration_skipped_86, t66.active AS active_87, t66.storage_size AS storage_size_88, t66.last_storage_size_calculation AS last_storage_size_calculation_89, t66.clear_storage_files AS clear_storage_files_90, t66.cover_dimming AS cover_dimming_91, t66.cover_mobile_dimming AS cover_mobile_dimming_92, t66.mobile_cover_type AS mobile_cover_type_93, t66.disable_clear_storage AS disable_clear_storage_94, t66.id AS id_95, t66.create_at AS create_at_96, t66.update_at AS update_at_97, t66.sort AS sort_98, t66.uuid AS uuid_99, t66.owner_id AS owner_id_100, t66.logo_id AS logo_id_101, t66.favicon_id AS favicon_id_102, t66.avatar_id AS avatar_id_103, t66.cover_id AS cover_id_104, t66.mobile_cover_id AS mobile_cover_id_105, t66.cover_change_id AS cover_change_id_106, t66.plan_id AS plan_id_107, t66.subscription_id AS subscription_id_108, t66.schoolChannel AS schoolChannel_109, t66.schoolGroup AS schoolGroup_110, t66.discount_id AS discount_id_111, t0.published_landing_id AS published_landing_id_112 FROM landing t0 LEFT JOIN course t23 ON t0.course_id = t23.id LEFT JOIN schools t66 ON t0.school_id = t66.id WHERE t0.course_id = 37;
0.27 ms (3.00%)	1	SELECT t0.name AS name_1, t0.description AS description_2, t0.type AS type_3, t0.score AS score_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.lesson_version AS lesson_version_7, t0.published_at AS published_at_8, t0.restored_history_at AS restored_history_at_9, t0.restored_history_from_at AS restored_history_from_at_10, t0.status AS status_11, t0.introduction AS introduction_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.sort AS sort_17, t0.uuid AS uuid_18, t0.step_id AS step_id_19, t20.score_type AS score_type_21, t20.score_right_question AS score_right_question_22, t20.required AS required_23, t20.skipped_questions AS skipped_questions_24, t20.percent_to_complete AS percent_to_complete_25, t20.randomize_questions AS randomize_questions_26, t20.randomize_answers AS randomize_answers_27, t20.show_correct_answers AS show_correct_answers_28, t20.show_correct_answers_type AS show_correct_answers_type_29, t20.use_timer AS use_timer_30, t20.timer AS timer_31, t20.attempts_limit AS attempts_limit_32, t20.use_question_bank AS use_question_bank_33, t20.question_bank_limit AS question_bank_limit_34, t20.id AS id_35, t20.create_at AS create_at_36, t20.update_at AS update_at_37, t20.sort AS sort_38, t20.uuid AS uuid_39, t20.deadline_has_time_limit AS deadline_has_time_limit_40, t20.deadline_type_time_limit AS deadline_type_time_limit_41, t20.deadline_time_limit AS deadline_time_limit_42, t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43, t20.lesson_id AS lesson_id_44, t20.lesson_id_draw AS lesson_id_draw_45, t46.score_type AS score_type_47, t46.score_right_question AS score_right_question_48, t46.required AS required_49, t46.skipped_questions AS skipped_questions_50, t46.percent_to_complete AS percent_to_complete_51, t46.randomize_questions AS randomize_questions_52, t46.randomize_answers AS randomize_answers_53, t46.show_correct_answers AS show_correct_answers_54, t46.show_correct_answers_type AS show_correct_answers_type_55, t46.use_timer AS use_timer_56, t46.timer AS timer_57, t46.attempts_limit AS attempts_limit_58, t46.use_question_bank AS use_question_bank_59, t46.question_bank_limit AS question_bank_limit_60, t46.id AS id_61, t46.create_at AS create_at_62, t46.update_at AS update_at_63, t46.sort AS sort_64, t46.uuid AS uuid_65, t46.deadline_has_time_limit AS deadline_has_time_limit_66, t46.deadline_type_time_limit AS deadline_type_time_limit_67, t46.deadline_time_limit AS deadline_time_limit_68, t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69, t46.lesson_id AS lesson_id_70, t46.lesson_id_draw AS lesson_id_draw_71, t72.content AS content_73, t72.draw_content AS draw_content_74, t72.autoaccept_delay AS autoaccept_delay_75, t72.autoaccept_message AS autoaccept_message_76, t72.id AS id_77, t72.create_at AS create_at_78, t72.update_at AS update_at_79, t72.uuid AS uuid_80, t72.deadline_has_time_limit AS deadline_has_time_limit_81, t72.deadline_type_time_limit AS deadline_type_time_limit_82, t72.deadline_time_limit AS deadline_time_limit_83, t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84, t72.lesson_id AS lesson_id_85, t72.auto_accept_message_user_id AS auto_accept_message_user_id_86, t87.student_notify_first AS student_notify_first_88, t87.student_notify_second AS student_notify_second_89, t87.employee_notify_first AS employee_notify_first_90, t87.employee_notify_second AS employee_notify_second_91, t87.completion_logic AS completion_logic_92, t87.id AS id_93, t87.create_at AS create_at_94, t87.update_at AS update_at_95, t87.sort AS sort_96, t87.uuid AS uuid_97, t87.lesson_id AS lesson_id_98 FROM lesson t0 LEFT JOIN tests t20 ON t20.lesson_id = t0.id LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id LEFT JOIN homework t72 ON t72.lesson_id = t0.id LEFT JOIN webinar t87 ON t87.lesson_id = t0.id WHERE t0.step_id = ? ORDER BY t0.sort ASC Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.description AS description_2, t0.type AS type_3, t0.score AS score_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.lesson_version AS lesson_version_7, t0.published_at AS published_at_8, t0.restored_history_at AS restored_history_at_9, t0.restored_history_from_at AS restored_history_from_at_10, t0.status AS status_11, t0.introduction AS introduction_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.sort AS sort_17, t0.uuid AS uuid_18, t0.step_id AS step_id_19, t20.score_type AS score_type_21, t20.score_right_question AS score_right_question_22, t20.required AS required_23, t20.skipped_questions AS skipped_questions_24, t20.percent_to_complete AS percent_to_complete_25, t20.randomize_questions AS randomize_questions_26, t20.randomize_answers AS randomize_answers_27, t20.show_correct_answers AS show_correct_answers_28, t20.show_correct_answers_type AS show_correct_answers_type_29, t20.use_timer AS use_timer_30, t20.timer AS timer_31, t20.attempts_limit AS attempts_limit_32, t20.use_question_bank AS use_question_bank_33, t20.question_bank_limit AS question_bank_limit_34, t20.id AS id_35, t20.create_at AS create_at_36, t20.update_at AS update_at_37, t20.sort AS sort_38, t20.uuid AS uuid_39, t20.deadline_has_time_limit AS deadline_has_time_limit_40, t20.deadline_type_time_limit AS deadline_type_time_limit_41, t20.deadline_time_limit AS deadline_time_limit_42, t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43, t20.lesson_id AS lesson_id_44, t20.lesson_id_draw AS lesson_id_draw_45, t46.score_type AS score_type_47, t46.score_right_question AS score_right_question_48, t46.required AS required_49, t46.skipped_questions AS skipped_questions_50, t46.percent_to_complete AS percent_to_complete_51, t46.randomize_questions AS randomize_questions_52, t46.randomize_answers AS randomize_answers_53, t46.show_correct_answers AS show_correct_answers_54, t46.show_correct_answers_type AS show_correct_answers_type_55, t46.use_timer AS use_timer_56, t46.timer AS timer_57, t46.attempts_limit AS attempts_limit_58, t46.use_question_bank AS use_question_bank_59, t46.question_bank_limit AS question_bank_limit_60, t46.id AS id_61, t46.create_at AS create_at_62, t46.update_at AS update_at_63, t46.sort AS sort_64, t46.uuid AS uuid_65, t46.deadline_has_time_limit AS deadline_has_time_limit_66, t46.deadline_type_time_limit AS deadline_type_time_limit_67, t46.deadline_time_limit AS deadline_time_limit_68, t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69, t46.lesson_id AS lesson_id_70, t46.lesson_id_draw AS lesson_id_draw_71, t72.content AS content_73, t72.draw_content AS draw_content_74, t72.autoaccept_delay AS autoaccept_delay_75, t72.autoaccept_message AS autoaccept_message_76, t72.id AS id_77, t72.create_at AS create_at_78, t72.update_at AS update_at_79, t72.uuid AS uuid_80, t72.deadline_has_time_limit AS deadline_has_time_limit_81, t72.deadline_type_time_limit AS deadline_type_time_limit_82, t72.deadline_time_limit AS deadline_time_limit_83, t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84, t72.lesson_id AS lesson_id_85, t72.auto_accept_message_user_id AS auto_accept_message_user_id_86, t87.student_notify_first AS student_notify_first_88, t87.student_notify_second AS student_notify_second_89, t87.employee_notify_first AS employee_notify_first_90, t87.employee_notify_second AS employee_notify_second_91, t87.completion_logic AS completion_logic_92, t87.id AS id_93, t87.create_at AS create_at_94, t87.update_at AS update_at_95, t87.sort AS sort_96, t87.uuid AS uuid_97, t87.lesson_id AS lesson_id_98 FROM lesson t0 LEFT JOIN tests t20 ON t20.lesson_id = t0.id LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id LEFT JOIN homework t72 ON t72.lesson_id = t0.id LEFT JOIN webinar t87 ON t87.lesson_id = t0.id WHERE t0.step_id = ? ORDER BY t0.sort ASC SELECT t0.name AS name_1, t0.description AS description_2, t0.type AS type_3, t0.score AS score_4, t0.deleted AS deleted_5, t0.deleted_at AS deleted_at_6, t0.lesson_version AS lesson_version_7, t0.published_at AS published_at_8, t0.restored_history_at AS restored_history_at_9, t0.restored_history_from_at AS restored_history_from_at_10, t0.status AS status_11, t0.introduction AS introduction_12, t0.document_id AS document_id_13, t0.id AS id_14, t0.create_at AS create_at_15, t0.update_at AS update_at_16, t0.sort AS sort_17, t0.uuid AS uuid_18, t0.step_id AS step_id_19, t20.score_type AS score_type_21, t20.score_right_question AS score_right_question_22, t20.required AS required_23, t20.skipped_questions AS skipped_questions_24, t20.percent_to_complete AS percent_to_complete_25, t20.randomize_questions AS randomize_questions_26, t20.randomize_answers AS randomize_answers_27, t20.show_correct_answers AS show_correct_answers_28, t20.show_correct_answers_type AS show_correct_answers_type_29, t20.use_timer AS use_timer_30, t20.timer AS timer_31, t20.attempts_limit AS attempts_limit_32, t20.use_question_bank AS use_question_bank_33, t20.question_bank_limit AS question_bank_limit_34, t20.id AS id_35, t20.create_at AS create_at_36, t20.update_at AS update_at_37, t20.sort AS sort_38, t20.uuid AS uuid_39, t20.deadline_has_time_limit AS deadline_has_time_limit_40, t20.deadline_type_time_limit AS deadline_type_time_limit_41, t20.deadline_time_limit AS deadline_time_limit_42, t20.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_43, t20.lesson_id AS lesson_id_44, t20.lesson_id_draw AS lesson_id_draw_45, t46.score_type AS score_type_47, t46.score_right_question AS score_right_question_48, t46.required AS required_49, t46.skipped_questions AS skipped_questions_50, t46.percent_to_complete AS percent_to_complete_51, t46.randomize_questions AS randomize_questions_52, t46.randomize_answers AS randomize_answers_53, t46.show_correct_answers AS show_correct_answers_54, t46.show_correct_answers_type AS show_correct_answers_type_55, t46.use_timer AS use_timer_56, t46.timer AS timer_57, t46.attempts_limit AS attempts_limit_58, t46.use_question_bank AS use_question_bank_59, t46.question_bank_limit AS question_bank_limit_60, t46.id AS id_61, t46.create_at AS create_at_62, t46.update_at AS update_at_63, t46.sort AS sort_64, t46.uuid AS uuid_65, t46.deadline_has_time_limit AS deadline_has_time_limit_66, t46.deadline_type_time_limit AS deadline_type_time_limit_67, t46.deadline_time_limit AS deadline_time_limit_68, t46.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_69, t46.lesson_id AS lesson_id_70, t46.lesson_id_draw AS lesson_id_draw_71, t72.content AS content_73, t72.draw_content AS draw_content_74, t72.autoaccept_delay AS autoaccept_delay_75, t72.autoaccept_message AS autoaccept_message_76, t72.id AS id_77, t72.create_at AS create_at_78, t72.update_at AS update_at_79, t72.uuid AS uuid_80, t72.deadline_has_time_limit AS deadline_has_time_limit_81, t72.deadline_type_time_limit AS deadline_type_time_limit_82, t72.deadline_time_limit AS deadline_time_limit_83, t72.deadline_is_closing_after_limit AS deadline_is_closing_after_limit_84, t72.lesson_id AS lesson_id_85, t72.auto_accept_message_user_id AS auto_accept_message_user_id_86, t87.student_notify_first AS student_notify_first_88, t87.student_notify_second AS student_notify_second_89, t87.employee_notify_first AS employee_notify_first_90, t87.employee_notify_second AS employee_notify_second_91, t87.completion_logic AS completion_logic_92, t87.id AS id_93, t87.create_at AS create_at_94, t87.update_at AS update_at_95, t87.sort AS sort_96, t87.uuid AS uuid_97, t87.lesson_id AS lesson_id_98 FROM lesson t0 LEFT JOIN tests t20 ON t20.lesson_id = t0.id LEFT JOIN tests t46 ON t46.lesson_id_draw = t0.id LEFT JOIN homework t72 ON t72.lesson_id = t0.id LEFT JOIN webinar t87 ON t87.lesson_id = t0.id WHERE t0.step_id = 31 ORDER BY t0.sort ASC;
0.27 ms (2.95%)	1	SELECT DISTINCT l0_.id AS id_0 FROM test_attempt t1_ LEFT JOIN tests t2_ ON t1_.test_id = t2_.id LEFT JOIN lesson l0_ ON t2_.lesson_id = l0_.id LEFT JOIN step s3_ ON l0_.step_id = s3_.id LEFT JOIN course c4_ ON s3_.course_id = c4_.id WHERE t1_.user_id = ? AND c4_.school_id = ? Parameters: [`7158 50`] View formatted query View runnable query Explain query SELECT DISTINCT l0_.id AS id_0 FROM test_attempt t1_ LEFT JOIN tests t2_ ON t1_.test_id = t2_.id LEFT JOIN lesson l0_ ON t2_.lesson_id = l0_.id LEFT JOIN step s3_ ON l0_.step_id = s3_.id LEFT JOIN course c4_ ON s3_.course_id = c4_.id WHERE t1_.user_id = ? AND c4_.school_id = ? SELECT DISTINCT l0_.id AS id_0 FROM test_attempt t1_ LEFT JOIN tests t2_ ON t1_.test_id = t2_.id LEFT JOIN lesson l0_ ON t2_.lesson_id = l0_.id LEFT JOIN step s3_ ON l0_.step_id = s3_.id LEFT JOIN course c4_ ON s3_.course_id = c4_.id WHERE t1_.user_id = 7158 AND c4_.school_id = 50;
0.25 ms (2.80%)	1	SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN group_employee_responsible ON t0.id = group_employee_responsible.course_user_id WHERE group_employee_responsible.flow_id = ? Parameters: [`42`] View formatted query View runnable query Explain query SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN group_employee_responsible ON t0.id = group_employee_responsible.course_user_id WHERE group_employee_responsible.flow_id = ? SELECT t0.role AS role_1, t0.accepted AS accepted_2, t0.payed AS payed_3, t0.lessons_access AS lessons_access_4, t0.score AS score_5, t0.total_score AS total_score_6, t0.progress_success AS progress_success_7, t0.progress AS progress_8, t0.finished_at AS finished_at_9, t0.status AS status_10, t0.certificate_received AS certificate_received_11, t0.use_discount AS use_discount_12, t0.use_discount_coupon AS use_discount_coupon_13, t0.has_employee_groups AS has_employee_groups_14, t0.access_ent_at AS access_ent_at_15, t0.start_training_at AS start_training_at_16, t0.use_custom_access AS use_custom_access_17, t0.custom_access_update_at AS custom_access_update_at_18, t0.access_type_student AS access_type_student_19, t0.process_calc_progress AS process_calc_progress_20, t0.process_calc_score AS process_calc_score_21, t0.process_course_finish AS process_course_finish_22, t0.id AS id_23, t0.create_at AS create_at_24, t0.update_at AS update_at_25, t0.access_lessons AS access_lessons_26, t0.access_dates AS access_dates_27, t0.access_type AS access_type_28, t0.access_access_opens_for AS access_access_opens_for_29, t0.access_weekdays AS access_weekdays_30, t0.access_weekdays_start_date AS access_weekdays_start_date_31, t0.access_once_for_days_interval AS access_once_for_days_interval_32, t0.access_once_for_days_start_date AS access_once_for_days_start_date_33, t0.access_for_time_type AS access_for_time_type_34, t0.access_for_time_start_date AS access_for_time_start_date_35, t0.access_for_time_range AS access_for_time_range_36, t0.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_37, t0.group_id AS group_id_38, t0.course_id AS course_id_39, t0.user_id AS user_id_40, t0.lesson_id AS lesson_id_41, t42.name AS name_43, t42.description AS description_44, t42.type AS type_45, t42.score AS score_46, t42.deleted AS deleted_47, t42.deleted_at AS deleted_at_48, t42.lesson_version AS lesson_version_49, t42.published_at AS published_at_50, t42.restored_history_at AS restored_history_at_51, t42.restored_history_from_at AS restored_history_from_at_52, t42.status AS status_53, t42.introduction AS introduction_54, t42.document_id AS document_id_55, t42.id AS id_56, t42.create_at AS create_at_57, t42.update_at AS update_at_58, t42.sort AS sort_59, t42.uuid AS uuid_60, t42.step_id AS step_id_61, t0.user_certificate_id AS user_certificate_id_62, t0.discount_id AS discount_id_63 FROM course_user t0 LEFT JOIN lesson t42 ON t0.lesson_id = t42.id INNER JOIN group_employee_responsible ON t0.id = group_employee_responsible.course_user_id WHERE group_employee_responsible.flow_id = 42;
0.25 ms (2.79%)	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 7158`] 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 = 7158;
0.23 ms (2.52%)	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.20 ms (2.20%)	1	SELECT COUNT(u0_.id) AS sclr_0 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE s2_.course_id = ? AND u0_.user_id = ? AND l1_.published_at IS NOT NULL AND l1_.deleted = ? LIMIT 1 Parameters: [`37 7158 0`] View formatted query View runnable query Explain query SELECT COUNT(u0_.id) AS sclr_0 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE s2_.course_id = ? AND u0_.user_id = ? AND l1_.published_at IS NOT NULL AND l1_.deleted = ? LIMIT 1 SELECT COUNT(u0_.id) AS sclr_0 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE s2_.course_id = 37 AND u0_.user_id = 7158 AND l1_.published_at IS NOT NULL AND l1_.deleted = 0 LIMIT 1;
0.20 ms (2.16%)	1	SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id WHERE u0_.user_id = ? AND u0_.lesson_id IN (?, ?) AND l1_.status IN (?, ?) Parameters: [`7158 54 55 "published" "published-draw"`] View formatted query View runnable query Explain query SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id WHERE u0_.user_id = ? AND u0_.lesson_id IN (?, ?) AND l1_.status IN (?, ?) SELECT u0_.score AS score_0, u0_.id AS id_1, u0_.create_at AS create_at_2, u0_.update_at AS update_at_3, u0_.user_id AS user_id_4, u0_.lesson_id AS lesson_id_5 FROM user_lesson_complete u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id WHERE u0_.user_id = 7158 AND u0_.lesson_id IN (54, 55) AND l1_.status IN ('published', 'published-draw');
0.18 ms (1.98%)	1	SELECT u0_.start_lesson_at AS start_lesson_at_0, u0_.finish_lesson_at AS finish_lesson_at_1, u0_.deadline_at AS deadline_at_2, u0_.id AS id_3, l1_.id AS id_4, l1_.uuid AS uuid_5 FROM user_lesson_deadline u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.course_user_id = ? AND l1_.deleted = ? Parameters: [`22260 0`] View formatted query View runnable query Explain query SELECT u0_.start_lesson_at AS start_lesson_at_0, u0_.finish_lesson_at AS finish_lesson_at_1, u0_.deadline_at AS deadline_at_2, u0_.id AS id_3, l1_.id AS id_4, l1_.uuid AS uuid_5 FROM user_lesson_deadline u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.course_user_id = ? AND l1_.deleted = ? SELECT u0_.start_lesson_at AS start_lesson_at_0, u0_.finish_lesson_at AS finish_lesson_at_1, u0_.deadline_at AS deadline_at_2, u0_.id AS id_3, l1_.id AS id_4, l1_.uuid AS uuid_5 FROM user_lesson_deadline u0_ LEFT JOIN lesson l1_ ON u0_.lesson_id = l1_.id LEFT JOIN step s2_ ON l1_.step_id = s2_.id WHERE u0_.course_user_id = 22260 AND l1_.deleted = 0;
0.16 ms (1.76%)	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.16 ms (1.76%)	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, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c1_.deleted = ? AND c0_.course_id = ? AND c0_.user_id = ? LIMIT 1 Parameters: [`0 37 7158`] View formatted query View runnable query Explain query SELECT c0_.role AS role_0, c0_.accepted AS accepted_1, c0_.payed AS payed_2, c0_.lessons_access AS lessons_access_3, c0_.score AS score_4, c0_.total_score AS total_score_5, c0_.progress_success AS progress_success_6, c0_.progress AS progress_7, c0_.finished_at AS finished_at_8, c0_.status AS status_9, c0_.certificate_received AS certificate_received_10, c0_.use_discount AS use_discount_11, c0_.use_discount_coupon AS use_discount_coupon_12, c0_.has_employee_groups AS has_employee_groups_13, c0_.access_ent_at AS access_ent_at_14, c0_.start_training_at AS start_training_at_15, c0_.use_custom_access AS use_custom_access_16, c0_.custom_access_update_at AS custom_access_update_at_17, c0_.access_type_student AS access_type_student_18, c0_.process_calc_progress AS process_calc_progress_19, c0_.process_calc_score AS process_calc_score_20, c0_.process_course_finish AS process_course_finish_21, c0_.id AS id_22, c0_.create_at AS create_at_23, c0_.update_at AS update_at_24, c0_.access_lessons AS access_lessons_25, c0_.access_dates AS access_dates_26, c0_.access_type AS access_type_27, c0_.access_access_opens_for AS access_access_opens_for_28, c0_.access_weekdays AS access_weekdays_29, c0_.access_weekdays_start_date AS access_weekdays_start_date_30, c0_.access_once_for_days_interval AS access_once_for_days_interval_31, c0_.access_once_for_days_start_date AS access_once_for_days_start_date_32, c0_.access_for_time_type AS access_for_time_type_33, c0_.access_for_time_start_date AS access_for_time_start_date_34, c0_.access_for_time_range AS access_for_time_range_35, c0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_36, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c1_.deleted = ? AND c0_.course_id = ? AND c0_.user_id = ? LIMIT 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, c0_.group_id AS group_id_37, c0_.course_id AS course_id_38, c0_.user_id AS user_id_39, c0_.lesson_id AS lesson_id_40, c0_.user_certificate_id AS user_certificate_id_41, c0_.discount_id AS discount_id_42 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c1_.deleted = 0 AND c0_.course_id = 37 AND c0_.user_id = 7158 LIMIT 1;
0.16 ms (1.74%)	1	SELECT l0_.id AS id_0 FROM user_lesson_complete u1_ LEFT JOIN lesson l0_ ON u1_.lesson_id = l0_.id LEFT JOIN step s2_ ON l0_.step_id = s2_.id WHERE s2_.course_id = ? AND u1_.user_id = ? Parameters: [`37 7158`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM user_lesson_complete u1_ LEFT JOIN lesson l0_ ON u1_.lesson_id = l0_.id LEFT JOIN step s2_ ON l0_.step_id = s2_.id WHERE s2_.course_id = ? AND u1_.user_id = ? SELECT l0_.id AS id_0 FROM user_lesson_complete u1_ LEFT JOIN lesson l0_ ON u1_.lesson_id = l0_.id LEFT JOIN step s2_ ON l0_.step_id = s2_.id WHERE s2_.course_id = 37 AND u1_.user_id = 7158;
0.15 ms (1.69%)	1	SELECT f0_.name AS name_0, f0_.user_limit AS user_limit_1, f0_.homework_block AS homework_block_2, f0_.dialogue_with_employees_block AS dialogue_with_employees_block_3, f0_.lessons_access AS lessons_access_4, f0_.hard_sequence AS hard_sequence_5, f0_.hard_sequence_homework AS hard_sequence_homework_6, f0_.hard_sequence_test AS hard_sequence_test_7, f0_.enable_certificate AS enable_certificate_8, f0_.limit_students AS limit_students_9, f0_.display_unavailable_lesson_student AS display_unavailable_lesson_student_10, f0_.id AS id_11, f0_.create_at AS create_at_12, f0_.update_at AS update_at_13, f0_.sort AS sort_14, f0_.uuid AS uuid_15, f0_.access_lessons AS access_lessons_16, f0_.access_dates AS access_dates_17, f0_.access_type AS access_type_18, f0_.access_access_opens_for AS access_access_opens_for_19, f0_.access_weekdays AS access_weekdays_20, f0_.access_weekdays_start_date AS access_weekdays_start_date_21, f0_.access_once_for_days_interval AS access_once_for_days_interval_22, f0_.access_once_for_days_start_date AS access_once_for_days_start_date_23, f0_.access_for_time_type AS access_for_time_type_24, f0_.access_for_time_start_date AS access_for_time_start_date_25, f0_.access_for_time_range AS access_for_time_range_26, f0_.access_is_open_for_time AS access_is_open_for_time_27, f0_.access_is_open_for_schedule AS access_is_open_for_schedule_28, f0_.access_for_schedule_type AS access_for_schedule_type_29, f0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_30, f0_.course_id AS course_id_31 FROM flow f0_ WHERE f0_.course_id = ? ORDER BY f0_.id DESC LIMIT 1 Parameters: [`37`] View formatted query View runnable query Explain query SELECT f0_.name AS name_0, f0_.user_limit AS user_limit_1, f0_.homework_block AS homework_block_2, f0_.dialogue_with_employees_block AS dialogue_with_employees_block_3, f0_.lessons_access AS lessons_access_4, f0_.hard_sequence AS hard_sequence_5, f0_.hard_sequence_homework AS hard_sequence_homework_6, f0_.hard_sequence_test AS hard_sequence_test_7, f0_.enable_certificate AS enable_certificate_8, f0_.limit_students AS limit_students_9, f0_.display_unavailable_lesson_student AS display_unavailable_lesson_student_10, f0_.id AS id_11, f0_.create_at AS create_at_12, f0_.update_at AS update_at_13, f0_.sort AS sort_14, f0_.uuid AS uuid_15, f0_.access_lessons AS access_lessons_16, f0_.access_dates AS access_dates_17, f0_.access_type AS access_type_18, f0_.access_access_opens_for AS access_access_opens_for_19, f0_.access_weekdays AS access_weekdays_20, f0_.access_weekdays_start_date AS access_weekdays_start_date_21, f0_.access_once_for_days_interval AS access_once_for_days_interval_22, f0_.access_once_for_days_start_date AS access_once_for_days_start_date_23, f0_.access_for_time_type AS access_for_time_type_24, f0_.access_for_time_start_date AS access_for_time_start_date_25, f0_.access_for_time_range AS access_for_time_range_26, f0_.access_is_open_for_time AS access_is_open_for_time_27, f0_.access_is_open_for_schedule AS access_is_open_for_schedule_28, f0_.access_for_schedule_type AS access_for_schedule_type_29, f0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_30, f0_.course_id AS course_id_31 FROM flow f0_ WHERE f0_.course_id = ? ORDER BY f0_.id DESC LIMIT 1 SELECT f0_.name AS name_0, f0_.user_limit AS user_limit_1, f0_.homework_block AS homework_block_2, f0_.dialogue_with_employees_block AS dialogue_with_employees_block_3, f0_.lessons_access AS lessons_access_4, f0_.hard_sequence AS hard_sequence_5, f0_.hard_sequence_homework AS hard_sequence_homework_6, f0_.hard_sequence_test AS hard_sequence_test_7, f0_.enable_certificate AS enable_certificate_8, f0_.limit_students AS limit_students_9, f0_.display_unavailable_lesson_student AS display_unavailable_lesson_student_10, f0_.id AS id_11, f0_.create_at AS create_at_12, f0_.update_at AS update_at_13, f0_.sort AS sort_14, f0_.uuid AS uuid_15, f0_.access_lessons AS access_lessons_16, f0_.access_dates AS access_dates_17, f0_.access_type AS access_type_18, f0_.access_access_opens_for AS access_access_opens_for_19, f0_.access_weekdays AS access_weekdays_20, f0_.access_weekdays_start_date AS access_weekdays_start_date_21, f0_.access_once_for_days_interval AS access_once_for_days_interval_22, f0_.access_once_for_days_start_date AS access_once_for_days_start_date_23, f0_.access_for_time_type AS access_for_time_type_24, f0_.access_for_time_start_date AS access_for_time_start_date_25, f0_.access_for_time_range AS access_for_time_range_26, f0_.access_is_open_for_time AS access_is_open_for_time_27, f0_.access_is_open_for_schedule AS access_is_open_for_schedule_28, f0_.access_for_schedule_type AS access_for_schedule_type_29, f0_.access_once_for_schedule_start_date AS access_once_for_schedule_start_date_30, f0_.course_id AS course_id_31 FROM flow f0_ WHERE f0_.course_id = 37 ORDER BY f0_.id DESC LIMIT 1;
0.15 ms (1.62%)	1	SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = ? Parameters: [`37`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = ? SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = 37;
0.15 ms (1.62%)	1	SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = ? SELECT t0.name AS name_1, t0.code AS code_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.active AS active_5, t0.price AS price_6, t0.old_price AS old_price_7, t0.price1month AS price1month_8, t0.price3month AS price3month_9, t0.price6month AS price6month_10, t0.price12month AS price12month_11, t0.delete_at AS delete_at_12, t0.removed AS removed_13, t0.period AS period_14, t0.free AS free_15, t0.id AS id_16, t0.create_at AS create_at_17, t0.update_at AS update_at_18, t0.sort AS sort_19 FROM subscription_plan t0 WHERE t0.id = 1;
0.14 ms (1.56%)	1	SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c0_.course_id IN (?) AND c0_.user_id = ? AND c0_.role = ? AND c1_.deleted = ? LIMIT 1 Parameters: [`37 7158 "ROLE_STUDENT" 0`] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c0_.course_id IN (?) AND c0_.user_id = ? AND c0_.role = ? AND c1_.deleted = ? LIMIT 1 SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM course_user c0_ LEFT JOIN course c1_ ON c0_.course_id = c1_.id WHERE c0_.course_id IN (37) AND c0_.user_id = 7158 AND c0_.role = 'ROLE_STUDENT' AND c1_.deleted = 0 LIMIT 1;
0.12 ms (1.38%)	1	SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.school_id AS school_id_9, t0.user_field_id AS user_field_id_10, t0.user_id AS user_id_11, t0.field_type, t1.value AS value_12, t2.value AS value_13, t3.value AS value_14, t4.value AS value_15 FROM user_custom_field_value t0 LEFT JOIN user_custom_field_value_number t1 ON t0.id = t1.id LEFT JOIN user_custom_field_value_text t2 ON t0.id = t2.id LEFT JOIN user_custom_field_value_phone t3 ON t0.id = t3.id LEFT JOIN user_custom_field_value_student_name t4 ON t0.id = t4.id WHERE t0.school_id = ? AND t0.user_id = ? Parameters: [`50 7158`] View formatted query View runnable query Explain query SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.school_id AS school_id_9, t0.user_field_id AS user_field_id_10, t0.user_id AS user_id_11, t0.field_type, t1.value AS value_12, t2.value AS value_13, t3.value AS value_14, t4.value AS value_15 FROM user_custom_field_value t0 LEFT JOIN user_custom_field_value_number t1 ON t0.id = t1.id LEFT JOIN user_custom_field_value_text t2 ON t0.id = t2.id LEFT JOIN user_custom_field_value_phone t3 ON t0.id = t3.id LEFT JOIN user_custom_field_value_student_name t4 ON t0.id = t4.id WHERE t0.school_id = ? AND t0.user_id = ? SELECT t0.id AS id_5, t0.uuid AS uuid_6, t0.create_at AS create_at_7, t0.update_at AS update_at_8, t0.school_id AS school_id_9, t0.user_field_id AS user_field_id_10, t0.user_id AS user_id_11, t0.field_type, t1.value AS value_12, t2.value AS value_13, t3.value AS value_14, t4.value AS value_15 FROM user_custom_field_value t0 LEFT JOIN user_custom_field_value_number t1 ON t0.id = t1.id LEFT JOIN user_custom_field_value_text t2 ON t0.id = t2.id LEFT JOIN user_custom_field_value_phone t3 ON t0.id = t3.id LEFT JOIN user_custom_field_value_student_name t4 ON t0.id = t4.id WHERE t0.school_id = 50 AND t0.user_id = 7158;
0.12 ms (1.37%)	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.11 ms (1.19%)	1	UPDATE users SET last_active_at = ?, update_at = ? WHERE id = ? Parameters: [`"2026-08-29 15:29:06" "2026-08-29 15:29:06" 7158`] View formatted query View runnable query Explain query UPDATE users SET last_active_at = ?, update_at = ? WHERE id = ? UPDATE users SET last_active_at = '2026-08-29 15:29:06', update_at = '2026-08-29 15:29:06' WHERE id = 7158;
0.09 ms (0.95%)	1	SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = ? ORDER BY t0.sort ASC Parameters: [`37`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = ? ORDER BY t0.sort ASC SELECT t0.name AS name_1, t0.deleted AS deleted_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.create_at AS create_at_5, t0.update_at AS update_at_6, t0.sort AS sort_7, t0.uuid AS uuid_8, t0.course_id AS course_id_9 FROM step t0 WHERE t0.course_id = 37 ORDER BY t0.sort ASC;
0.04 ms (0.46%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
0.04 ms (0.40%)	1	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

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\School\UserFields\FieldValue\FieldValue	No errors.
App\Entity\Group\LessonAccess	No errors.
App\Entity\Group\Flow	No errors.
App\Entity\Payment\Gateway\Gateway	No errors.
App\Entity\Course\CourseFinishRule	No errors.
App\Entity\Course\CourseCertificateRule	No errors.
App\Entity\Course\Certificate\CertificateTemplate	No errors.
App\Entity\Course\CoursePlan	No errors.
App\Entity\Payment\Gateway\GatewayYandexKassa	No errors.
App\Entity\Payment\Gateway\GatewayTinkoff	No errors.
App\Entity\Payment\Gateway\GatewayProdamus	No errors.
App\Entity\Payment\Gateway\GatewayMandarinPay	No errors.
App\Entity\Payment\Gateway\GatewayMandarinPayInstallment	No errors.
App\Entity\Payment\Gateway\GatewayDevelopmentResourceInstallment	No errors.
App\Entity\Payment\Gateway\GatewayDevelopmentResourceV2Installment	No errors.
App\Entity\Payment\Gateway\GatewayBePaid	No errors.
App\Entity\Payment\Gateway\GatewayCloudPayments	No errors.
App\Entity\Payment\Gateway\GatewayGazprom	No errors.
App\Entity\Payment\Gateway\GatewayTochka	No errors.
App\Entity\Payment\Gateway\GatewayMandarin	No errors.
App\Entity\Payment\Gateway\GatewayVtb	No errors.
App\Entity\Course\CourseCategory	No errors.
App\Entity\Test\Attempt\TestAttempt	No errors.
App\Entity\Chat\Recipient	No errors.
App\Entity\Chat\Message\Message	No errors.
App\Entity\School\SchoolEmployeeRole	No errors.
App\Entity\Payment\Transaction\Transaction	No errors.
App\Entity\UserLessonComplete	No errors.
App\Entity\Settings\SchoolUser	No errors.
App\Entity\FileUpload	No errors.
App\Entity\RichTextImage	No errors.
App\Entity\UserLessonDeadline	No errors.
App\Entity\Webinar\Webinar	No errors.
App\Entity\Webinar\WebinarFlow	No errors.
App\Entity\Lesson\StudentOptions\ParentType	No errors.
App\Entity\Course\Certificate\UserCertificate	No errors.
App\Entity\Landing\Block\ParentType	No errors.
App\Entity\School\UserFields\LandingField	No errors.
App\Entity\School\UserFields\FieldValue\NumberFieldValue	No errors.
App\Entity\School\UserFields\FieldValue\TextFieldValue	No errors.
App\Entity\School\UserFields\FieldValue\PhoneFieldValue	No errors.
App\Entity\School\UserFields\FieldValue\StudentNameFieldValue	No errors.

Symfony Profiler

GET https://963174.dev-4.sksp.site/api/student/course/37

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping