GET:emps [2025-07-31 08:15:24] GET:device [2025-07-31 08:15:24] GET:getDeviceInfo [2025-07-31 08:15:49] GET:accessDays [2025-07-31 08:16:06] GET:getDeviceInfo [2025-07-31 08:16:27] GET:records [2025-07-31 08:17:06] GET:emps [2025-07-31 08:17:55] GET:device [2025-07-31 08:17:55] GET:emps [2025-07-31 08:17:56] GET:device [2025-07-31 08:17:56] GET:device [2025-07-31 08:31:51] SQL: select serial_num as serialNum from device [2025-07-31 08:31:51] GET:emps [2025-07-31 08:31:51] SQL: select COUNT(*) as count from person [2025-07-31 08:31:51] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-07-31 08:41:56] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-07-31 08:42:12] GET:emps [2025-07-31 08:42:43] GET:device [2025-07-31 08:42:43] SQL: select serial_num as serialNum from device [2025-07-31 08:42:43] SQL: select COUNT(*) as count from person [2025-07-31 08:42:43] GET:records [2025-07-31 08:43:10] SQL: select COUNT(*) as count from records [2025-07-31 08:43:10] GET:records [2025-07-31 08:44:16] SQL: select COUNT(*) as count from records [2025-07-31 08:44:16] GET:getNewLog [2025-07-31 08:44:28] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF240068357','getnewlog','0','0','0','2025-07-31 08:44:28','2025-07-31 08:44:28','{"cmd": [2025-07-31 08:44:28] GET:getAllLog [2025-07-31 08:44:36] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF240068357','getalllog','0','0','0','2025-07-31 08:44:36','2025-07-31 08:44:36','{"cmd": [2025-07-31 08:44:36] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-07-31 08:45:09] GET:emps [2025-07-31 08:46:22] GET:device [2025-07-31 08:46:22] SQL: select COUNT(*) as count from person [2025-07-31 08:46:22] SQL: select serial_num as serialNum from device [2025-07-31 08:46:22] GET:device [2025-07-31 08:49:48] GET:emps [2025-07-31 08:49:48] SQL: select COUNT(*) as count from person [2025-07-31 08:49:48] :48] GET:setUsernameToDevice [2025-07-31 08:50:09] SQL: select * from person [2025-07-31 08:50:09] GET:sendWs [2025-07-31 08:50:13] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','getuserlist','0','0','0','2025-07-31 08:50:13','2025-07-31 08:50:13','{"cmd":"getuserlis [2025-07-31 08:50:13] GET:getUserInfo [2025-07-31 08:50:15] SQL: select person.id,enroll_id as enrollId,backupnum as num from person INNER JOIN enrollinfo ON person.id= enrollinfo.enroll_id order by person.id asc [2025-07-31 08:50:15] GET:setUsernameToDevice [2025-07-31 08:50:17] SQL: select * from person [2025-07-31 08:50:17] GET:initSystem [2025-07-31 08:50:20] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','initsys','0','0','0','2025-07-31 08:50:20','2025-07-31 08:50:20','{"cmd":"initsys"}') [2025-07-31 08:50:20] GET:records [2025-07-31 08:50:24] SQL: select COUNT(*) as count from records [2025-07-31 08:50:24] GET:getNewLog [2025-07-31 08:50:29] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','getnewlog','0','0','0','2025-07-31 08:50:29','2025-07-31 08:50:29','{"cmd":"getnewlog"," [2025-07-31 08:50:29] GET:accessDays [2025-07-31 08:50:33] SQL: select * from access_day [2025-07-31 08:50:33] GET:accessDays [2025-07-31 08:50:36] SQL: select * from access_day [2025-07-31 08:50:36] GET:enrollInfo [2025-07-31 08:50:53] SQL: select id,name,roll_id as rollId from person [2025-07-31 08:50:53] GET:sendGetUserInfo [2025-07-31 08:51:03] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','getuserinfo','0','0','0','2025-07-31 08:51:03','2025-07-31 08:51:03','{"cmd":"getuserinf [2025-07-31 08:51:03] GET:sendGetUserInfo [2025-07-31 08:51:08] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','getuserinfo','0','0','0','2025-07-31 08:51:08','2025-07-31 08:51:08','{"cmd":"getuserinf [2025-07-31 08:51:08] GET:getDeviceInfo [2025-07-31 08:51:14] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('','getdevinfo','0','0','0','2025-07-31 08:51:14','2025-07-31 08:51:14','{"cmd":"getdevinfo" [2025-07-31 08:51:14] GET:device [2025-07-31 08:57:23] GET:emps [2025-07-31 08:57:23] SQL: select serial_num as serialNum from device [2025-07-31 08:57:23] GET:device [2025-07-31 09:04:53] GET:emps [2025-07-31 09:04:53] SQL: select COUNT(*) as count from person [2025-07-31 09:04:53] :53] GET:records [2025-07-31 09:05:05] SQL: select COUNT(*) as count from records [2025-07-31 09:05:05] GET:records [2025-07-31 09:05:13] SQL: select COUNT(*) as count from records [2025-07-31 09:05:13] GET:getAllLog [2025-07-31 09:05:23] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF240068357','getalllog','0','0','0','2025-07-31 09:05:23','2025-07-31 09:05:23','{"cmd": [2025-07-31 09:05:23] GET:emps [2025-07-31 09:13:47] GET:device [2025-07-31 09:13:47] GET:addPerson [2025-07-31 09:14:02] GET:emps [2025-07-31 09:19:19] GET:device [2025-07-31 09:19:19] SQL: select COUNT(*) as count from person [2025-07-31 09:19:19] :19] GET:addPerson [2025-07-31 09:19:30] SQL: select * from person where id=1 limit 0,2 [2025-07-31 09:19:30] GET:emps [2025-07-31 09:31:03] GET:device [2025-07-31 09:31:03] SQL: select serial_num as serialNum from device [2025-07-31 09:31:03] echo: {"extend":{"device":[]},"code":100,"msg":"Success\uff01"} [2025-07-31 09:31:03] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-07-31 09:31:03] GET:addPerson [2025-07-31 09:31:15] SQL: select * from person where id=1 limit 0,2 [2025-07-31 09:31:15] Exc: insert into person(roll_id,name,id) values('0','22','1') [2025-07-31 09:31:15] GET:device [2025-07-31 09:31:36] GET:emps [2025-07-31 09:31:36] SQL: select serial_num as serialNum from device [2025-07-31 09:31:36] echo: {"extend":{"device":[]},"code":100,"msg":"Success\uff01"} [2025-07-31 09:31:36] SQL: select COUNT(*) as count from person [2025-07-31 09:31:36] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-07-31 09:31:36] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-07-31 09:36:32] Exc: insert into device(serial_num,status) values('AYTF24068357','1') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-30 20:11:15','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-30 23:14:50','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-30 23:16:59','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-30 23:49:02','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-30 23:52:45','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 00:06:28','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 00:07:47','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 00:09:16','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 00:11:54','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 00:13:07','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 01:17:46','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 01:24:16','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 01:30:41','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 01:42:15','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 01:44:49','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 02:03:06','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 02:04:15','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 02:32:06','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 02:33:18','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 02:35:16','0','8','0','0') [2025-07-31 09:36:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 09:36:36','0','8','0','0') [2025-07-31 09:36:36] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 09:44:52','0','8','0','0') [2025-07-31 09:44:52] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 09:54:11','0','8','0','0') [2025-07-31 09:54:12] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 10:12:13','0','8','0','0') [2025-07-31 10:12:13] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 00:52:28] Exc: update device set `status`='1' where id="2" [2025-08-01 00:52:28] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 17:49:29','0','8','0','0') [2025-08-01 00:52:28] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 00:52:29','0','8','0','0') [2025-08-01 00:52:30] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 01:05:20] Exc: update device set `status`='1' where id="2" [2025-08-01 01:05:20] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 01:04:27','0','8','0','0') [2025-08-01 01:05:20] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 01:07:04','0','8','0','0') [2025-08-01 01:07:05] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 01:20:12','0','8','0','0') [2025-08-01 01:20:13] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 18:54:49','0','8','0','0') [2025-08-01 01:54:50] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 18:54:55','0','8','0','0') [2025-08-01 01:54:57] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 18:55:07','0','8','0','0') [2025-08-01 01:55:08] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 18:56:34','0','8','0','0') [2025-08-01 01:56:35] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 18:57:14','0','8','0','0') [2025-08-01 01:57:15] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 01:58:20] Exc: update device set `status`='1' where id="2" [2025-08-01 01:58:20] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 01:58:26','0','8','0','0') [2025-08-01 01:58:27] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:04:35','0','8','0','0') [2025-08-01 02:04:36] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:04:45','0','8','0','0') [2025-08-01 02:04:46] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:04:53','0','8','0','0') [2025-08-01 02:04:54] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:04:58','0','8','0','0') [2025-08-01 02:04:59] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:06:14','0','8','0','0') [2025-08-01 02:06:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:10:18','0','8','0','0') [2025-08-01 02:10:20] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:24:11','0','8','0','0') [2025-08-01 02:24:12] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:26:04','0','8','0','0') [2025-08-01 02:26:06] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 02:27:11] Exc: update device set `status`='1' where id="2" [2025-08-01 02:27:11] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 02:34:03] Exc: update device set `status`='1' where id="2" [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:32:13','0','8','0','0') [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:32:18','0','8','0','0') [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:32:27','0','8','0','0') [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:32:41','0','8','0','0') [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:33:41','0','8','0','0') [2025-08-01 02:34:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 02:34:11','0','8','0','0') [2025-08-01 02:34:12] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:36:34','0','8','0','0') [2025-08-01 02:36:35] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 19:36:40','0','8','0','0') [2025-08-01 02:36:41] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 20:28:34','0','8','0','0') [2025-08-01 03:28:35] GET:device [2025-08-01 03:41:51] GET:emps [2025-08-01 03:41:51] SQL: select serial_num as serialNum from device [2025-08-01 03:41:51] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-01 03:41:51] SQL: select COUNT(*) as count from person [2025-08-01 03:41:51] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-01 03:41:51] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-01 04:45:41] Exc: update device set `status`='1' where id="2" [2025-08-01 04:45:41] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 21:44:31','0','8','0','0') [2025-08-01 04:45:42] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 21:44:36','0','8','0','0') [2025-08-01 04:45:42] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 21:44:42','0','8','0','0') [2025-08-01 04:45:42] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 21:45:08','0','8','0','0') [2025-08-01 04:45:42] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 21:48:45','0','8','0','0') [2025-08-01 04:48:46] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 22:11:11','0','8','0','0') [2025-08-01 05:11:11] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-07-31 22:47:00','0','8','0','0') [2025-08-01 05:47:01] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','11111111','2025-08-01 01:18:07','0','8','0','0') [2025-08-01 08:18:08] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','22222222','2025-08-01 01:21:06','0','8','0','0') [2025-08-01 08:21:07] GET:device [2025-08-06 19:16:38] SQL: select serial_num as serialNum from device [2025-08-06 19:16:38] SQL: select COUNT(*) as count from person [2025-08-06 19:16:38] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-06 19:16:38] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-06 19:16:38] GET:device [2025-08-28 01:37:03] SQL: select serial_num as serialNum from device [2025-08-28 01:37:03] SQL: select COUNT(*) as count from person [2025-08-28 01:37:03] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 01:37:03] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 01:37:03] GET:setOneUser [2025-08-28 01:37:43] SQL: select * from person where id=1 [2025-08-28 01:37:43] SQL: select * from enrollinfo where enroll_id=1 and backupnum=-1 [2025-08-28 01:37:43] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','setusername','0','0','0','2025-08-28 01:37:43','2025-08-28 01:37:43','{"cmd" [2025-08-28 01:37:43] GET:emps [2025-08-28 01:37:44] SQL: select COUNT(*) as count from person [2025-08-28 01:37:44] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 01:37:44] GET:records [2025-08-28 01:37:58] SQL: select COUNT(*) as count from records [2025-08-28 01:37:58] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 01:37:58] GET:records [2025-08-28 01:38:06] SQL: select COUNT(*) as count from records [2025-08-28 01:38:06] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 8,8 [2025-08-28 01:38:06] GET:records [2025-08-28 01:38:06] SQL: select COUNT(*) as count from records [2025-08-28 01:38:06] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 16,8 [2025-08-28 01:38:06] GET:records [2025-08-28 01:38:07] SQL: select COUNT(*) as count from records [2025-08-28 01:38:07] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 24,8 [2025-08-28 01:38:07] GET:records [2025-08-28 01:38:08] SQL: select COUNT(*) as count from records [2025-08-28 01:38:08] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 24,8 [2025-08-28 01:38:08] GET:records [2025-08-28 01:38:08] SQL: select COUNT(*) as count from records [2025-08-28 01:38:08] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 32,8 [2025-08-28 01:38:08] GET:records [2025-08-28 01:38:09] SQL: select COUNT(*) as count from records [2025-08-28 01:38:09] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 40,8 [2025-08-28 01:38:09] GET:records [2025-08-28 01:38:10] SQL: select COUNT(*) as count from records [2025-08-28 01:38:10] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 48,8 [2025-08-28 01:38:10] GET:getAllLog [2025-08-28 01:38:31] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','getalllog','0','0','0','2025-08-28 01:38:31','2025-08-28 01:38:31','{"cmd":" [2025-08-28 01:38:31] GET:records [2025-08-28 01:38:33] SQL: select COUNT(*) as count from records [2025-08-28 01:38:33] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 56,8 [2025-08-28 01:38:33] GET:getNewLog [2025-08-28 01:38:40] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','getnewlog','0','0','0','2025-08-28 01:38:40','2025-08-28 01:38:40','{"cmd":" [2025-08-28 01:38:40] GET:records [2025-08-28 01:38:41] SQL: select COUNT(*) as count from records [2025-08-28 01:38:41] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 56,8 [2025-08-28 01:38:41] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:32:22','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:33:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:38:21','0','8','0','0') [2025-08-28 01:39:16] SQL: select * from person where id=8888888 limit 0,2 [2025-08-28 01:39:16] Exc: insert into person(roll_id,name,id) values('0','pedro','8888888') [2025-08-28 01:39:16] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="50" limit 0,2 [2025-08-28 01:39:16] Exc: insert into enrollinfo(backupnum,signatures,imagepath,enroll_id) values('50','/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2w [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] SQL: select * from person where id=166484 limit 0,2 [2025-08-28 01:39:16] Exc: insert into person(roll_id,name,id) values('0','yq8whw','166484') [2025-08-28 01:39:16] SQL: select * from enrollinfo where enroll_id=166484 and backupnum="11" limit 0,2 [2025-08-28 01:39:16] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('11','5137935','166484') [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 01:39:16' where id=5239 [2025-08-28 01:39:16] SQL: select * from person where id=166484 limit 0,2 [2025-08-28 01:39:16] Exc: update person set `roll_id`='0',`name`='yq8whw' where id=166484 [2025-08-28 01:39:16] SQL: select * from enrollinfo where enroll_id=166484 and backupnum="0" limit 0,2 [2025-08-28 01:39:16] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('0','c515700676f70af617cda8c603f6fb31ff2e488673f69b4e1fcda7c486f82b71e84798c5e4861b9eef7e588517f86ba60732390491f8ebc9e745a7c408f73c0505ec4 [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 01:39:16' where id=5239 [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 01:39:16' where id=5240 [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-20 00:10:10','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-20 00:14:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-20 00:19:05','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-20 00:22:34','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-20 00:31:59','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 17:29:44','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 17:31:13','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 18:54:00','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 18:57:00','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 18:58:49','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 18:59:50','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 19:01:40','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-21 19:04:41','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-22 00:12:54','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-22 09:36:18','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-22 09:38:31','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-22 09:40:28','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-22 10:07:33','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:06:07','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:07:31','0','8','0','0') [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 01:39:16' where id=5240 [2025-08-28 01:39:16] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 01:39:16' where id=5241 [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:08:42','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:14:29','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:16:46','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:17:47','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 01:20:49','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 21:58:21','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 22:02:29','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 22:04:40','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 22:22:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 22:48:42','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 22:59:24','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:02:41','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:07:19','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:16:17','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:22:30','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:23:52','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:25:31','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:28:50','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:54:20','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-26 23:55:23','0','8','0','0') [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:32:22','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:33:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:38:21','0','8','0','0') [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 01:39:16' where id=5241 [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 00:14:56','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 01:13:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','166484','2025-08-27 14:39:17','0','3','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:32:22','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:33:36','0','8','0','0') [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:38:21','0','8','0','0') [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:39:16] Exc: update device set `status`='1' where id="2" [2025-08-28 01:39:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 01:39:17','0','8','0','0') [2025-08-28 01:39:17] GET:device [2025-08-28 01:40:28] GET:emps [2025-08-28 01:40:28] SQL: select COUNT(*) as count from person [2025-08-28 01:40:28] SQL: select serial_num as serialNum from device [2025-08-28 01:40:28] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 01:40:28] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 01:40:28] GET:enrollInfo [2025-08-28 01:41:35] SQL: select id,name,roll_id as rollId from person [2025-08-28 01:41:35] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 01:41:57','0','8','0','0') [2025-08-28 01:41:57] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:43:47','0','8','0','0') [2025-08-28 01:44:03] GET:emps [2025-08-28 01:48:22] GET:device [2025-08-28 01:48:22] SQL: select COUNT(*) as count from person [2025-08-28 01:48:22] SQL: select serial_num as serialNum from device [2025-08-28 01:48:22] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 01:48:22] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 01:48:22] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 01:49:05] Exc: update device set `status`='1' where id="2" [2025-08-28 01:49:05] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 01:49:05','0','8','0','0') [2025-08-28 01:49:07] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:51:17','0','8','0','0') [2025-08-28 01:51:31] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 18:54:50','0','8','0','0') [2025-08-28 01:55:03] GET:setUserLock [2025-08-28 01:58:37] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','setuserlock','0','0','0','2025-08-28 01:58:37','2025-08-28 01:58:37','{"cmd" [2025-08-28 01:58:37] GET:emps [2025-08-28 01:58:39] SQL: select COUNT(*) as count from person [2025-08-28 01:58:39] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 01:58:39] GET:getDeviceInfo [2025-08-28 02:00:48] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','getdevinfo','0','0','0','2025-08-28 02:00:48','2025-08-28 02:00:48','{"cmd": [2025-08-28 02:00:48] GET:emps [2025-08-28 02:00:52] SQL: select COUNT(*) as count from person [2025-08-28 02:00:52] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:00:52] GET:enrollInfo [2025-08-28 02:01:22] SQL: select id,name,roll_id as rollId from person [2025-08-28 02:01:22] GET:geUSerLock [2025-08-28 02:06:53] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','getuserlock','0','0','0','2025-08-28 02:06:53','2025-08-28 02:06:53','{"cmd" [2025-08-28 02:06:53] GET:emps [2025-08-28 02:06:54] SQL: select COUNT(*) as count from person [2025-08-28 02:06:55] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:06:55] GET:initSystem [2025-08-28 02:09:00] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','initsys','0','0','0','2025-08-28 02:09:00','2025-08-28 02:09:00','{"cmd":"in [2025-08-28 02:09:00] GET:emps [2025-08-28 02:09:01] SQL: select COUNT(*) as count from person [2025-08-28 02:09:01] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:09:01] GET:device [2025-08-28 02:09:05] GET:emps [2025-08-28 02:09:05] SQL: select serial_num as serialNum from device [2025-08-28 02:09:05] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 02:09:05] SQL: select COUNT(*) as count from person [2025-08-28 02:09:05] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:09:05] GET:setOneUser [2025-08-28 02:13:21] SQL: select * from person where id=8888888 [2025-08-28 02:13:21] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum=-1 [2025-08-28 02:13:21] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','setusername','0','0','0','2025-08-28 02:13:21','2025-08-28 02:13:21','{"cmd" [2025-08-28 02:13:21] GET:emps [2025-08-28 02:13:23] SQL: select COUNT(*) as count from person [2025-08-28 02:13:23] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:13:23] GET:deletePersonFromDevice [2025-08-28 02:13:33] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','deleteuser','0','0','0','2025-08-28 02:13:33','2025-08-28 02:13:33','{"cmd": [2025-08-28 02:13:33] Exc: delete from person where id=166484 [2025-08-28 02:13:33] Exc: delete from enrollinfo where enroll_id=166484 [2025-08-28 02:13:33] GET:emps [2025-08-28 02:13:34] SQL: select COUNT(*) as count from person [2025-08-28 02:13:34] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:13:34] GET:records [2025-08-28 02:13:41] SQL: select COUNT(*) as count from records [2025-08-28 02:13:41] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 02:13:41] GET:records [2025-08-28 02:13:54] SQL: select COUNT(*) as count from records [2025-08-28 02:13:54] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 8,8 [2025-08-28 02:13:54] GET:records [2025-08-28 02:13:54] SQL: select COUNT(*) as count from records [2025-08-28 02:13:54] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 16,8 [2025-08-28 02:13:54] GET:records [2025-08-28 02:13:55] SQL: select COUNT(*) as count from records [2025-08-28 02:13:55] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 24,8 [2025-08-28 02:13:55] GET:records [2025-08-28 02:13:56] SQL: select COUNT(*) as count from records [2025-08-28 02:13:56] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 96,8 [2025-08-28 02:13:56] GET:records [2025-08-28 02:13:57] SQL: select COUNT(*) as count from records [2025-08-28 02:13:57] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 88,8 [2025-08-28 02:13:57] GET:records [2025-08-28 02:13:58] SQL: select COUNT(*) as count from records [2025-08-28 02:13:58] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 96,8 [2025-08-28 02:13:58] GET:records [2025-08-28 02:13:58] SQL: select COUNT(*) as count from records [2025-08-28 02:13:58] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 104,8 [2025-08-28 02:13:58] GET:records [2025-08-28 02:13:59] SQL: select COUNT(*) as count from records [2025-08-28 02:13:59] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 104,8 [2025-08-28 02:13:59] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:34] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:34] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:06:46','0','8','0','0') [2025-08-28 02:14:34] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:10:26','0','8','0','0') [2025-08-28 02:14:34] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:12:40','0','8','0','0') [2025-08-28 02:14:34] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:13:55','0','8','0','0') [2025-08-28 02:14:34] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 02:14:34','0','8','0','0') [2025-08-28 02:14:34] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:34' where id=5242 [2025-08-28 02:14:34] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:34' where id=5242 [2025-08-28 02:14:34] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:34] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:34] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:34' where id=5243 [2025-08-28 02:14:34] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:34' where id=5243 [2025-08-28 02:14:34] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:34] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:34] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:34' where id=5244 [2025-08-28 02:14:34] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:34' where id=5244 [2025-08-28 02:14:34] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:34] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:34] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:34' where id=5245 [2025-08-28 02:14:34] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:35' where id=5245 [2025-08-28 02:14:35] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:35] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:35] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:35' where id=5246 [2025-08-28 02:14:35] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:35' where id=5246 [2025-08-28 02:14:35] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:35] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:35] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-28 02:14:35' where id=5247 [2025-08-28 02:14:35] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-28 02:14:35' where id=5247 [2025-08-28 02:14:35] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:14:35] Exc: update device set `status`='1' where id="2" [2025-08-28 02:14:35] SQL: select * from person where id=8888888 limit 0,2 [2025-08-28 02:15:44] Exc: update person set `roll_id`='0',`name`='pedro' where id=8888888 [2025-08-28 02:15:44] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="50" limit 0,2 [2025-08-28 02:15:44] Exc: update enrollinfo set `backupnum`='50',`signatures`='/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQYGBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYaKCg [2025-08-28 02:15:44] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:15:44] Exc: update device set `status`='1' where id="2" [2025-08-28 02:15:44] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 02:15:50','0','8','0','0') [2025-08-28 02:15:50] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:22:04','0','8','0','0') [2025-08-28 02:22:19] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:23:39','0','8','0','0') [2025-08-28 02:23:55] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:38:03] Exc: update device set `status`='1' where id="2" [2025-08-28 02:38:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:34:34','0','8','0','0') [2025-08-28 02:38:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:35:54','0','8','0','0') [2025-08-28 02:38:03] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 02:38:11','0','8','0','0') [2025-08-28 02:38:12] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:38:42] Exc: update device set `status`='1' where id="2" [2025-08-28 02:38:42] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 02:38:42] Exc: update device set `status`='1' where id="2" [2025-08-28 02:38:42] GET:device [2025-08-28 02:40:04] GET:emps [2025-08-28 02:40:04] SQL: select serial_num as serialNum from device [2025-08-28 02:40:04] SQL: select COUNT(*) as count from person [2025-08-28 02:40:04] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 02:40:04] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:40:04] GET:setPersonToDevice [2025-08-28 02:54:28] SQL: select name,roll_id,person.id,enroll_id as enrollId,backupnum as num,signatures from person INNER JOIN enrollinfo ON person.id= enrollinfo.enroll_id order by person.id asc [2025-08-28 02:54:28] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','setuserinfo','0','0','0','2025-08-28 02:54:28','2025-08-28 02:54:28','{"cmd" [2025-08-28 02:54:28] GET:emps [2025-08-28 02:54:31] SQL: select COUNT(*) as count from person [2025-08-28 02:54:31] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 02:54:31] GET:records [2025-08-28 02:55:05] SQL: select COUNT(*) as count from records [2025-08-28 02:55:05] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 02:55:05] GET:records [2025-08-28 02:55:14] SQL: select COUNT(*) as count from records [2025-08-28 02:55:14] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 02:55:14] GET:getNewLog [2025-08-28 02:55:28] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','getnewlog','0','0','0','2025-08-28 02:55:28','2025-08-28 02:55:28','{"cmd":" [2025-08-28 02:55:28] GET:records [2025-08-28 02:55:30] SQL: select COUNT(*) as count from records [2025-08-28 02:55:30] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 128,8 [2025-08-28 02:55:30] GET:records [2025-08-28 02:55:40] SQL: select COUNT(*) as count from records [2025-08-28 02:55:40] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 02:55:40] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 19:55:52] Exc: update device set `status`='1' where id="2" [2025-08-27 19:55:52] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 00:55:07','0','8','0','0') [2025-08-27 19:55:52] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-27 19:55:53' where id=5248 [2025-08-27 19:55:53] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-27 19:55:53' where id=5248 [2025-08-27 19:55:53] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 19:55:53] Exc: update device set `status`='1' where id="2" [2025-08-27 19:55:53] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-27 19:55:53' where id=5249 [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:55:52','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 02:15:50','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:22:04','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:23:39','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:34:34','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:35:54','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 02:38:11','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 00:55:07','0','8','0','0') [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:55:52','0','8','0','0') [2025-08-27 19:55:53] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 19:55:53] Exc: update device set `status`='1' where id="2" [2025-08-27 19:55:53] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-27 19:55:53' where id=5249 [2025-08-27 19:55:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 19:59:21','0','8','0','0') [2025-08-27 19:59:22] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:02:39','0','8','0','0') [2025-08-27 20:02:40] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:14:18','0','8','0','0') [2025-08-27 20:14:19] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:25:53','0','8','0','0') [2025-08-27 20:25:53] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:32:10','0','8','0','0') [2025-08-27 20:32:11] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 20:58:13] Exc: update device set `status`='1' where id="2" [2025-08-27 20:58:13] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:55:13','0','8','0','0') [2025-08-27 20:58:13] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 20:57:18','0','8','0','0') [2025-08-27 20:58:13] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 22:14:32] Exc: update device set `status`='1' where id="2" [2025-08-27 22:14:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:09:36','0','8','0','0') [2025-08-27 22:14:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:13:57','0','8','0','0') [2025-08-27 22:14:32] GET:device [2025-08-28 05:16:24] GET:emps [2025-08-28 05:16:24] SQL: select serial_num as serialNum from device [2025-08-28 05:16:24] SQL: select COUNT(*) as count from person [2025-08-28 05:16:24] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-28 05:16:24] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-28 05:16:24] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:18:24','0','8','0','0') [2025-08-27 22:18:24] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:23:05','0','8','0','0') [2025-08-27 22:23:05] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 22:23:18] Exc: update device set `status`='1' where id="2" [2025-08-27 22:23:18] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-27 22:35:09] Exc: update device set `status`='1' where id="2" [2025-08-27 22:35:09] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:34:39','0','8','0','0') [2025-08-27 22:35:09] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:36:09','0','8','0','0') [2025-08-27 22:36:10] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 22:50:13','0','8','0','0') [2025-08-27 22:50:14] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:08:22','0','8','0','0') [2025-08-27 23:08:23] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:10:50','0','8','0','0') [2025-08-27 23:10:51] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:12:30','0','8','0','0') [2025-08-27 23:12:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:14:53','0','8','0','0') [2025-08-27 23:14:54] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:16:40','0','8','0','0') [2025-08-27 23:16:41] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-27 23:24:32','0','8','0','0') [2025-08-27 23:24:34] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 10:31:32] Exc: update device set `status`='1' where id="2" [2025-08-28 10:31:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 00:15:17','0','8','0','0') [2025-08-28 10:31:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 10:30:10','0','8','0','0') [2025-08-28 10:31:32] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 10:31:32','0','8','0','0') [2025-08-28 10:31:33] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 11:23:01','0','8','0','0') [2025-08-28 11:23:01] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:27:29] Exc: update device set `status`='1' where id="2" [2025-08-28 11:27:29] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:27:30] Exc: update device set `status`='1' where id="2" [2025-08-28 11:27:30] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 11:31:58','0','8','0','0') [2025-08-28 11:31:59] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:32:26] Exc: update device set `status`='1' where id="2" [2025-08-28 11:32:26] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:32:27] Exc: update device set `status`='1' where id="2" [2025-08-28 11:32:27] GET:records [2025-08-28 18:33:46] SQL: select COUNT(*) as count from records [2025-08-28 18:33:46] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-28 18:33:46] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 11:39:28','0','8','0','0') [2025-08-28 11:39:29] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:39:53] Exc: update device set `status`='1' where id="2" [2025-08-28 11:39:53] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 11:52:16] Exc: update device set `status`='1' where id="2" [2025-08-28 11:52:16] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 12:04:41','0','8','0','0') [2025-08-28 12:04:41] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-28 22:11:24] Exc: update device set `status`='1' where id="2" [2025-08-28 22:11:24] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-28 22:11:02','0','8','0','0') [2025-08-28 22:11:24] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0828_221121_1.jpg','AYTF24068357','8888888','2025-08-28 22:29:58','0','8','0','0' [2025-08-28 22:29:59] GET:device [2025-08-29 05:30:05] GET:emps [2025-08-29 05:30:05] SQL: select serial_num as serialNum from device [2025-08-29 05:30:05] SQL: select COUNT(*) as count from person [2025-08-29 05:30:05] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-08-29 05:30:05] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-08-29 05:30:05] GET:records [2025-08-29 05:30:12] SQL: select COUNT(*) as count from records [2025-08-29 05:30:12] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-29 05:30:12] GET:records [2025-08-29 05:30:22] SQL: select COUNT(*) as count from records [2025-08-29 05:30:22] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 160,8 [2025-08-29 05:30:22] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0828_221121_2.jpg','AYTF24068357','8888888','2025-08-28 22:33:43','0','8','0','0' [2025-08-28 22:33:45] GET:records [2025-08-29 05:34:09] SQL: select COUNT(*) as count from records [2025-08-29 05:34:09] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-08-29 05:34:09] GET:records [2025-08-29 05:34:11] SQL: select COUNT(*) as count from records [2025-08-29 05:34:11] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 168,8 [2025-08-29 05:34:11] GET:records [2025-08-29 05:36:48] SQL: select COUNT(*) as count from records [2025-08-29 05:36:48] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 160,8 [2025-08-29 05:36:48] GET:records [2025-08-29 05:36:51] SQL: select COUNT(*) as count from records [2025-08-29 05:36:51] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 168,8 [2025-08-29 05:36:51] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 22:03:47] Exc: update device set `status`='1' where id="2" [2025-08-31 22:03:47] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_1.jpg','AYTF24068357','8888888','2025-08-29 14:33:35','0','8','0','0' [2025-08-31 22:03:47] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_2.jpg','AYTF24068357','8888888','2025-08-29 15:21:25','0','8','0','0' [2025-08-31 22:03:47] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_3.jpg','AYTF24068357','8888888','2025-08-30 01:47:02','0','8','0','0' [2025-08-31 22:03:47] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_4.jpg','AYTF24068357','8888888','2025-08-31 16:49:37','0','8','0','0' [2025-08-31 22:03:47] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_5.jpg','AYTF24068357','8888888','2025-08-31 17:07:28','0','8','0','0' [2025-08-31 22:03:48] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_6.jpg','AYTF24068357','8888888','2025-08-31 17:14:02','0','8','0','0' [2025-08-31 22:03:48] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_7.jpg','AYTF24068357','8888888','2025-08-31 18:02:10','0','8','0','0' [2025-08-31 22:03:48] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_8.jpg','AYTF24068357','8888888','2025-08-31 20:56:59','0','8','0','0' [2025-08-31 22:03:48] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_9.jpg','AYTF24068357','8888888','2025-08-31 22:03:52','0','8','0','0' [2025-08-31 22:03:52] GET:device [2025-09-01 05:04:23] GET:emps [2025-09-01 05:04:23] SQL: select serial_num as serialNum from device [2025-09-01 05:04:23] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-09-01 05:04:23] SQL: select COUNT(*) as count from person [2025-09-01 05:04:23] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:04:23] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220347_10.jpg','AYTF24068357','8888888','2025-08-31 22:05:51','0','8','0','0 [2025-08-31 22:05:50] GET:deletePersonFromDevice [2025-09-01 05:06:32] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','deleteuser','0','0','0','2025-09-01 05:06:32','2025-09-01 05:06:32','{"cmd": [2025-09-01 05:06:32] Exc: delete from person where id=1 [2025-09-01 05:06:32] Exc: delete from enrollinfo where enroll_id=1 [2025-09-01 05:06:32] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-31 22:06:33' where id=5250 [2025-08-31 22:06:33] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-31 22:06:33' where id=5250 [2025-08-31 22:06:33] GET:emps [2025-09-01 05:06:33] SQL: select COUNT(*) as count from person [2025-09-01 05:06:33] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:06:33] GET:setPersonToDevice [2025-09-01 05:06:47] SQL: select name,roll_id,person.id,enroll_id as enrollId,backupnum as num,signatures from person INNER JOIN enrollinfo ON person.id= enrollinfo.enroll_id order by person.id asc [2025-09-01 05:06:47] Exc: insert into machine_command(serial,name,status,send_status,err_count,gmt_crate,gmt_modified,content) values('AYTF24068357','setuserinfo','0','0','0','2025-09-01 05:06:47','2025-09-01 05:06:47','{"cmd" [2025-09-01 05:06:47] GET:emps [2025-09-01 05:06:49] SQL: select COUNT(*) as count from person [2025-09-01 05:06:49] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:06:49] GET:device [2025-09-01 05:06:51] GET:emps [2025-09-01 05:06:51] SQL: select serial_num as serialNum from device [2025-09-01 05:06:51] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-09-01 05:06:51] SQL: select COUNT(*) as count from person [2025-09-01 05:06:51] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:06:51] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 22:07:06] Exc: update device set `status`='1' where id="2" [2025-08-31 22:07:06] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220706_1.jpg','AYTF24068357','8888888','2025-08-31 22:06:57','0','8','0','0' [2025-08-31 22:07:06] Exc: update machine_command set `status`='0',`send_status`='1',`run_time`='2025-08-31 22:07:07' where id=5251 [2025-08-31 22:07:07] Exc: update machine_command set `status`='1',`send_status`='0',`run_time`='2025-08-31 22:07:07' where id=5251 [2025-08-31 22:07:07] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 22:07:07] Exc: update device set `status`='1' where id="2" [2025-08-31 22:07:07] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220706_2.jpg','AYTF24068357','8888888','2025-08-31 22:08:03','0','8','0','0' [2025-08-31 22:08:02] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220706_3.jpg','AYTF24068357','8888888','2025-08-31 22:11:18','0','8','0','0' [2025-08-31 22:11:18] GET:device [2025-09-01 05:12:03] GET:emps [2025-09-01 05:12:03] SQL: select COUNT(*) as count from person [2025-09-01 05:12:03] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:12:03] SQL: select serial_num as serialNum from device [2025-09-01 05:12:03] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-09-01 05:12:03] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_220706_4.jpg','AYTF24068357','8888888','2025-08-31 22:12:24','0','8','0','0' [2025-08-31 22:12:23] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 22:12:29] Exc: update device set `status`='1' where id="2" [2025-08-31 22:12:29] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 22:18:25] Exc: update device set `status`='1' where id="2" [2025-08-31 22:18:25] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_1.jpg','AYTF24068357','8888888','2025-08-31 22:15:41','0','8','0','0' [2025-08-31 22:18:25] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_2.jpg','AYTF24068357','8888888','2025-08-31 22:17:28','0','8','0','0' [2025-08-31 22:18:25] GET:device [2025-09-01 05:18:40] GET:emps [2025-09-01 05:18:40] SQL: select COUNT(*) as count from person [2025-09-01 05:18:40] :40] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-09-01 05:18:40] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-01 05:18:40] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_3.jpg','AYTF24068357','8888888','2025-08-31 22:18:55','0','8','0','0' [2025-08-31 22:18:55] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_4.jpg','AYTF24068357','8888888','2025-08-31 22:21:17','0','8','0','0' [2025-08-31 22:21:17] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_5.jpg','AYTF24068357','8888888','2025-08-31 22:22:38','0','8','0','0' [2025-08-31 22:22:38] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_6.jpg','AYTF24068357','8888888','2025-08-31 22:33:18','0','8','0','0' [2025-08-31 22:33:18] Exc: insert into records(image,device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('commands/his 0831_221825_7.jpg','AYTF24068357','8888888','2025-08-31 22:37:42','0','8','0','0' [2025-08-31 22:37:42] GET:records [2025-09-01 05:38:39] SQL: select COUNT(*) as count from records [2025-09-01 05:38:39] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-09-01 05:38:39] GET:records [2025-09-01 05:38:43] SQL: select COUNT(*) as count from records [2025-09-01 05:38:43] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 88,8 [2025-09-01 05:38:43] GET:records [2025-09-01 05:38:44] SQL: select COUNT(*) as count from records [2025-09-01 05:38:44] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 96,8 [2025-09-01 05:38:44] GET:records [2025-09-01 05:38:47] SQL: select COUNT(*) as count from records [2025-09-01 05:38:47] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 104,8 [2025-09-01 05:38:47] GET:records [2025-09-01 05:38:51] SQL: select COUNT(*) as count from records [2025-09-01 05:38:51] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 112,8 [2025-09-01 05:38:51] GET:records [2025-09-01 05:38:53] SQL: select COUNT(*) as count from records [2025-09-01 05:38:53] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 96,8 [2025-09-01 05:38:53] GET:records [2025-09-01 05:38:55] SQL: select COUNT(*) as count from records [2025-09-01 05:38:55] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 88,8 [2025-09-01 05:38:55] GET:records [2025-09-01 05:38:56] SQL: select COUNT(*) as count from records [2025-09-01 05:38:56] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 80,8 [2025-09-01 05:38:56] GET:records [2025-09-01 05:38:57] SQL: select COUNT(*) as count from records [2025-09-01 05:38:57] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 72,8 [2025-09-01 05:38:57] GET:records [2025-09-01 05:38:57] SQL: select COUNT(*) as count from records [2025-09-01 05:38:57] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 64,8 [2025-09-01 05:38:57] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 22:39:05','0','8','0','0') [2025-08-31 22:39:04] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 22:53:11','0','8','0','0') [2025-08-31 22:53:11] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 22:54:24','0','8','0','0') [2025-08-31 22:54:24] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 23:12:20','0','8','0','0') [2025-08-31 23:12:19] GET:records [2025-09-01 06:12:42] SQL: select COUNT(*) as count from records [2025-09-01 06:12:42] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-09-01 06:12:42] GET:records [2025-09-01 06:12:48] SQL: select COUNT(*) as count from records [2025-09-01 06:12:48] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 120,8 [2025-09-01 06:12:48] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 23:44:57','0','8','0','0') [2025-08-31 23:44:55] GET:records [2025-09-01 06:46:00] SQL: select COUNT(*) as count from records [2025-09-01 06:46:00] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-09-01 06:46:00] GET:records [2025-09-01 06:46:03] SQL: select COUNT(*) as count from records [2025-09-01 06:46:03] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 120,8 [2025-09-01 06:46:03] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 23:46:24] Exc: update device set `status`='1' where id="2" [2025-08-31 23:46:24] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 23:46:32] Exc: update device set `status`='1' where id="2" [2025-08-31 23:46:32] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 23:47:01] Exc: update device set `status`='1' where id="2" [2025-08-31 23:47:01] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-08-31 23:47:02] Exc: update device set `status`='1' where id="2" [2025-08-31 23:47:02] GET:records [2025-09-01 06:48:39] SQL: select COUNT(*) as count from records [2025-09-01 06:48:39] SQL: select enroll_id as enrollId,records_time as recordsTime,mode,intOut as intout,event,device_serial_num as deviceSerialNum,temperature,image from records limit 0,8 [2025-09-01 06:48:39] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-08-31 23:49:05','0','8','0','0') [2025-08-31 23:49:04] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 09:42:58] Exc: update device set `status`='1' where id="2" [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 17:47:41','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 18:12:20','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 18:13:48','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 18:17:16','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 18:36:23','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 19:07:20','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 19:08:44','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 19:28:24','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 22:30:16','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 22:50:44','0','16','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 23:12:36','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-02 23:29:43','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:28:37','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:30:36','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:35:54','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:38:49','0','8','0','0') [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:40:08','0','8','0','0') [2025-09-03 09:42:58] SQL: select * from person where id=8888888 limit 0,2 [2025-09-03 09:42:58] Exc: update person set `roll_id`='0',`name`='pedro' where id=8888888 [2025-09-03 09:42:58] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="10" limit 0,2 [2025-09-03 09:42:58] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('10','99673','8888888') [2025-09-03 09:42:58] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 09:42:58] Exc: update device set `status`='1' where id="2" [2025-09-03 09:42:58] SQL: select * from person where id=8888888 limit 0,2 [2025-09-03 09:42:58] Exc: update person set `roll_id`='0',`name`='pedro' where id=8888888 [2025-09-03 09:42:58] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="11" limit 0,2 [2025-09-03 09:42:58] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('11','9525668','8888888') [2025-09-03 09:42:58] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 09:42:58] Exc: update device set `status`='1' where id="2" [2025-09-03 09:42:58] SQL: select * from person where id=8888888 limit 0,2 [2025-09-03 09:42:58] Exc: update person set `roll_id`='0',`name`='pedro' where id=8888888 [2025-09-03 09:42:58] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="0" limit 0,2 [2025-09-03 09:42:58] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('0','c5187101de859b29ff7e2a440ab91b3eef762c837ab89b510805bbc465b653a10f49c78368b713a2100bc9c4da85b3f5ef7626c265b6ac2d0009b70300b7d441eef03 [2025-09-03 09:42:58] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 09:42:58] Exc: update device set `status`='1' where id="2" [2025-09-03 09:42:58] SQL: select * from person where id=8888888 limit 0,2 [2025-09-03 09:42:58] Exc: update person set `roll_id`='0',`name`='pedro' where id=8888888 [2025-09-03 09:42:58] SQL: select * from enrollinfo where enroll_id=8888888 and backupnum="40" limit 0,2 [2025-09-03 09:42:58] Exc: insert into enrollinfo(backupnum,signatures,enroll_id) values('40','C+3+Bvfx6f36HhQGCNH6DgP8D+/5CgHx9QADEQMS/wAAAfD63g77FAQQAQD+E/n+7yUC8BgC9AYDAQEKCuP79vsHA/MgCP0C3Q0HBBDxOSrv8hkWCAfq+/f/FfAEAxrU7wD+ [2025-09-03 09:42:58] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 09:42:58] Exc: update device set `status`='1' where id="2" [2025-09-03 09:42:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:42:59','0','8','0','0') [2025-09-03 09:42:59] GET:device [2025-09-03 16:43:59] GET:emps [2025-09-03 16:43:59] SQL: select COUNT(*) as count from person [2025-09-03 16:43:59] :59] echo: {"extend":{"device":[{"serialNum":"AYTF24068357"}]},"code":100,"msg":"Success\uff01"} [2025-09-03 16:43:59] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-03 16:43:59] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 09:46:23','0','8','0','0') [2025-09-03 09:46:23] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 10:33:45] Exc: update device set `status`='1' where id="2" [2025-09-03 10:33:45] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 10:36:32] Exc: update device set `status`='1' where id="2" [2025-09-03 10:36:32] SQL: select * from device where serial_num="AYTF24068357" limit 0,2 [2025-09-03 15:58:06] Exc: update device set `status`='1' where id="2" [2025-09-03 15:58:06] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 15:37:42','0','1','0','0') [2025-09-03 15:58:06] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 15:44:50','0','8','0','0') [2025-09-03 15:58:06] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 15:58:12','0','8','0','0') [2025-09-03 15:58:12] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 16:05:58','0','8','0','0') [2025-09-03 16:05:58] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 16:07:34','0','8','0','0') [2025-09-03 16:07:33] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 16:08:38','0','8','0','0') [2025-09-03 16:08:37] Exc: insert into records(device_serial_num,enroll_id,records_time,intOut,mode,event,temperature) values('AYTF24068357','8888888','2025-09-03 16:29:32','0','1','0','0') [2025-09-03 16:29:32] GET:device [2025-09-09 17:50:57] GET:emps [2025-09-09 17:50:57] SQL: select serial_num as serialNum from device [2025-09-09 17:50:57] SQL: select COUNT(*) as count from person [2025-09-09 17:50:57] echo: {"extend":{"device":[]},"code":100,"msg":"Success\uff01"} [2025-09-09 17:50:57] SQL: select person.id as enrollId,name,backupnum as num,roll_id as admin,enrollinfo.imagepath AS imagePath from person LEFT JOIN enrollinfo ON person.id= enrollinfo.enroll_id and backupnum=50 order by per [2025-09-09 17:50:57]