| 1 |
0.64 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.id_card AS id_card_6, t0.cover AS cover_7, t0.idno AS idno_8, t0.is_resigned AS is_resigned_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_deleted AS is_deleted_12, t0.merchant_id AS merchant_id_13 FROM student t0 WHERE t0.id = 39;
|
| 2 |
0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.file_id AS file_id_4, t0.teacher AS teacher_5, t0.duration AS duration_6, t0.credit_hours AS credit_hours_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.is_deleted AS is_deleted_10, t0.chapter_id AS chapter_id_11 FROM video t0 WHERE t0.id = 32;
|
| 3 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_deleted AS is_deleted_5, t0.major_id AS major_id_6 FROM chapter t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.is_deleted AS is_deleted_5, t0.major_id AS major_id_6 FROM chapter t0 WHERE t0.id = 24;
|
| 4 |
0.34 ms |
SELECT t0.id AS id_1, t0.is_completed AS is_completed_2, t0.watch_seconds AS watch_seconds_3, t0.ip AS ip_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_deleted AS is_deleted_9, t0.student_id AS student_id_10, t0.video_id AS video_id_11 FROM video_watch_log t0 WHERE t0.student_id = ? AND t0.video_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.is_completed AS is_completed_2, t0.watch_seconds AS watch_seconds_3, t0.ip AS ip_4, t0.start_time AS start_time_5, t0.end_time AS end_time_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.is_deleted AS is_deleted_9, t0.student_id AS student_id_10, t0.video_id AS video_id_11 FROM video_watch_log t0 WHERE t0.student_id = 39 AND t0.video_id = 32 LIMIT 1;
|
| 5 |
0.23 ms |
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = ? AND t0.video_id = ? AND t0.start_time = ? LIMIT 1
Parameters: [
39
32
1782202208
]
SELECT t0.id AS id_1, t0.start_time AS start_time_2, t0.end_time AS end_time_3, t0.action_target AS action_target_4, t0.action_type AS action_type_5, t0.platform AS platform_6, t0.ip AS ip_7, t0.duration AS duration_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.is_deleted AS is_deleted_11, t0.student_id AS student_id_12, t0.video_id AS video_id_13 FROM learn_track t0 WHERE t0.student_id = 39 AND t0.video_id = 32 AND t0.start_time = 1782202208 LIMIT 1;
|
| 6 |
0.10 ms |
"START TRANSACTION"
"START TRANSACTION";
|
| 7 |
0.28 ms |
INSERT INTO learn_track (start_time, end_time, action_target, action_type, platform, ip, duration, created_at, updated_at, is_deleted, student_id, video_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: [
1782202208
1782202211
"3,新能源趋势"
"视频学习"
"uni-app"
"113.90.83.124"
3
"2026-06-23 16:10:10"
"2026-06-23 16:10:10"
0
39
32
]
INSERT INTO learn_track (start_time, end_time, action_target, action_type, platform, ip, duration, created_at, updated_at, is_deleted, student_id, video_id) VALUES (1782202208, 1782202211, '3,新能源趋势', '视频学习', 'uni-app', '113.90.83.124', 3, '2026-06-23 16:10:10', '2026-06-23 16:10:10', 0, 39, 32);
|
| 8 |
0.20 ms |
UPDATE video_watch_log SET watch_seconds = ?, end_time = ?, updated_at = ? WHERE id = ?
Parameters: [
17
1782202211
"2026-06-23 16:10:10"
44
]
UPDATE video_watch_log SET watch_seconds = 17, end_time = 1782202211, updated_at = '2026-06-23 16:10:10' WHERE id = 44;
|
| 9 |
3.89 ms |
"COMMIT"
|