1 |
2.42 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 = 1;
|
3 |
0.79 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.number AS number_2, p0_.phase_index_title AS phase_index_title_3, p0_.group_id AS group_id_4, p0_.sub_group_id AS sub_group_id_5, p0_.lesson_id AS lesson_id_6, p0_.type_class_id AS type_class_id_7, p0_.phase_item_id AS phase_item_id_8 FROM phase_group p0_ WHERE (p0_.id = ? OR LOWER(p0_.name || '') LIKE ? OR p0_.number = ?) AND p0_.id IN (?) ORDER BY p0_.id DESC
Parameters: [
1477
"%1477%"
1477
1477
]
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.number AS number_2, p0_.phase_index_title AS phase_index_title_3, p0_.group_id AS group_id_4, p0_.sub_group_id AS sub_group_id_5, p0_.lesson_id AS lesson_id_6, p0_.type_class_id AS type_class_id_7, p0_.phase_item_id AS phase_item_id_8 FROM phase_group p0_ WHERE (p0_.id = 1477 OR LOWER(p0_.name || '') LIKE '%1477%' OR p0_.number = 1477) AND p0_.id IN (1477) ORDER BY p0_.id DESC;
|
5 |
1.05 ms |
SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 WHERE t0.phase_group_id = ?
SELECT t0.id AS id_1, t0.duration_in_minutes AS duration_in_minutes_2, t0.length AS length_3, t0.tmp_count AS tmp_count_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.group_ids AS group_ids_7, t0.sub_group_ids AS sub_group_ids_8, t0.phase_group_ids AS phase_group_ids_9, t0.ref_id AS ref_id_10, t0.phase_part AS phase_part_11, t0.group_id AS group_id_12, t0.sub_group_id AS sub_group_id_13, t0.lesson_id AS lesson_id_14, t0.department_id AS department_id_15, t0.teacher_id AS teacher_id_16, t0.phase_group_id AS phase_group_id_17, t0.room_id AS room_id_18, t0.selecting_class_time_id AS selecting_class_time_id_19, t0.type_class_id AS type_class_id_20 FROM class_time t0 WHERE t0.phase_group_id = 1477;
|
10 |
0.84 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_phase_group ON t0.id = student_phase_group.student_id WHERE student_phase_group.phase_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_phase_group ON t0.id = student_phase_group.student_id WHERE student_phase_group.phase_group_id = 1477;
|