1 |
2.13 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.first_name AS first_name_18, t16.last_name AS last_name_19, t16.email AS email_20, t16.surname AS surname_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.timesheet_number AS timesheet_number_24, t16.m_id AS m_id_25, t16.user_id AS user_id_26, t27.id AS id_28, t27.direction_sub_group_id AS direction_sub_group_id_29, t27.lessons_time_map AS lessons_time_map_30, t27.lessons_type_map AS lessons_type_map_31, t27.matrix AS matrix_32, t27.removed_lessons AS removed_lessons_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.age AS age_36, t27.email AS email_37, t27.surname AS surname_38, t27.created_at AS created_at_39, t27.updated_at AS updated_at_40, t27.group_id AS group_id_41, t27.user_id AS user_id_42 FROM "user" t0 LEFT JOIN teacher t16 ON t16.user_id = t0.id LEFT JOIN student t27 ON t27.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.verification_token AS verification_token_6, t0.reset_token AS reset_token_7, t0.reset_token_expires_at AS reset_token_expires_at_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.verify_code AS verify_code_11, t0.verify_code_created_at AS verify_code_created_at_12, t0.jwt_token AS jwt_token_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.first_name AS first_name_18, t16.last_name AS last_name_19, t16.email AS email_20, t16.surname AS surname_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.timesheet_number AS timesheet_number_24, t16.m_id AS m_id_25, t16.user_id AS user_id_26, t27.id AS id_28, t27.direction_sub_group_id AS direction_sub_group_id_29, t27.lessons_time_map AS lessons_time_map_30, t27.lessons_type_map AS lessons_type_map_31, t27.matrix AS matrix_32, t27.removed_lessons AS removed_lessons_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.age AS age_36, t27.email AS email_37, t27.surname AS surname_38, t27.created_at AS created_at_39, t27.updated_at AS updated_at_40, t27.group_id AS group_id_41, t27.user_id AS user_id_42 FROM "user" t0 LEFT JOIN teacher t16 ON t16.user_id = t0.id LEFT JOIN student t27 ON t27.user_id = t0.id WHERE t0.id = 14;
|
2 |
0.93 ms |
SELECT DISTINCT s0_.id AS id_0 FROM sub_group s0_ WHERE s0_.number = ? LIMIT 20
SELECT DISTINCT s0_.id AS id_0 FROM sub_group s0_ WHERE s0_.number = 11 LIMIT 20;
|
3 |
0.51 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.number AS number_2, s0_.matrix AS matrix_3, s0_.m_id AS m_id_4, s0_.group_id AS group_id_5, s0_.lesson_id AS lesson_id_6, s0_.type_class_id AS type_class_id_7, s0_.group_direction_id AS group_direction_id_8 FROM sub_group s0_ WHERE s0_.number = ? AND s0_.id IN (?, ?, ?, ?, ?)
Parameters: [
11
102
101
99
98
100
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.number AS number_2, s0_.matrix AS matrix_3, s0_.m_id AS m_id_4, s0_.group_id AS group_id_5, s0_.lesson_id AS lesson_id_6, s0_.type_class_id AS type_class_id_7, s0_.group_direction_id AS group_direction_id_8 FROM sub_group s0_ WHERE s0_.number = 11 AND s0_.id IN (102, 101, 99, 98, 100);
|
4 |
0.67 ms |
SELECT count(s0_.id) AS sclr_0 FROM sub_group s0_ WHERE s0_.number = ?
SELECT count(s0_.id) AS sclr_0 FROM sub_group s0_ WHERE s0_.number = 11;
|
5 |
0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.m_id AS m_id_4, t0.level_class_id AS level_class_id_5 FROM "group" t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.m_id AS m_id_4, t0.level_class_id AS level_class_id_5 FROM "group" t0 WHERE t0.id = 9;
|
6 |
1.12 ms |
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = 98;
|
7 |
0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = 98;
|
8 |
0.43 ms |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = 4;
|
9 |
0.63 ms |
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = 101;
|
10 |
0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = 101;
|
11 |
0.37 ms |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = 1;
|
12 |
0.85 ms |
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = 99;
|
13 |
0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = 99;
|
14 |
0.33 ms |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = 3;
|
15 |
0.90 ms |
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = 100;
|
16 |
0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = 100;
|
17 |
0.34 ms |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = 6;
|
18 |
0.71 ms |
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = ?
SELECT t0.id AS id_1, t0.direction_sub_group_id AS direction_sub_group_id_2, t0.lessons_time_map AS lessons_time_map_3, t0.lessons_type_map AS lessons_type_map_4, t0.matrix AS matrix_5, t0.removed_lessons AS removed_lessons_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.age AS age_9, t0.email AS email_10, t0.surname AS surname_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.group_id AS group_id_14, t0.user_id AS user_id_15 FROM student t0 INNER JOIN student_sub_group ON t0.id = student_sub_group.student_id WHERE student_sub_group.sub_group_id = 102;
|
19 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.phase_index_title AS phase_index_title_4, t0.group_id AS group_id_5, t0.sub_group_id AS sub_group_id_6, t0.lesson_id AS lesson_id_7, t0.type_class_id AS type_class_id_8, t0.phase_item_id AS phase_item_id_9 FROM phase_group t0 WHERE t0.sub_group_id = 102;
|
20 |
0.33 ms |
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.direction AS direction_2, t0.group_id AS group_id_3 FROM group_direction t0 WHERE t0.id = 2;
|