{"time":"2026-09-21 09:10:33","type":"SUCCESS","operation":"新增员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:33","type":"SUCCESS","operation":"新增员工-工号唯一性: 10001","sql":"SELECT empid FROM employee WHERE orgid = ? AND empno = ?","params":"[1,\"10001\"]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:34","type":"SUCCESS","operation":"新增员工: 10001 - TONGTONG","sql":"INSERT INTO employee (orgid, empno, empname, status, password, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)","params":"[1,\"10001\",\"TONGTONG\",1,\"$2y$10$C9NZpyWffE3vyIpd6hD22O4JwC\\\/ZtNYkiNIvnvrh7NAmQi941bxzu\",1,4,1,2,1,null,null,null,null]","affected":1,"lastId":"1","exec_time":"0.0777s"}
{"time":"2026-09-21 09:10:34","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:10:34","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[1]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:34","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 09:10:35","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:35","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[1]","affected":0,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:10:35","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"删除员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"删除员工-校验权限","sql":"SELECT empid FROM employee WHERE empid = ? AND orgid = ?","params":"[1,1]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"删除员工: empid=1","sql":"DELETE FROM employee WHERE empid = ? AND orgid = ?","params":"[1,1]","affected":1,"lastId":"0","exec_time":"0.0500s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[1]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:10:43","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[1]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:14:30","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:14:31","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:14:33","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=2","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:14:41","type":"SUCCESS","operation":"退出登录: 删除Token","sql":"DELETE FROM user_tokens WHERE token = ?","params":"[\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoyLCJleHAiOjE3OTA1NjEzODMsImlhdCI6MTc4OTk1NjU4M30=.1c3ff5bdc002cf6075a6943a7f5658792e6e2d543e4f47ca44d3896686d65b3d\"]","affected":1,"lastId":"0","exec_time":"0.0116s"}
{"time":"2026-09-21 09:16:11","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:16:53","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:17:07","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:17:08","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:17:09","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:17:10","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:13","type":"SUCCESS","operation":"密码登录-查询用户: 13666666666","sql":"SELECT id, phone, nickname, password, orgid FROM users WHERE phone = ? AND status = 1","params":"[\"13666666666\"]","affected":1,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:21:13","type":"SUCCESS","operation":"密码登录-保存Token: user_id=1","sql":"INSERT INTO user_tokens (user_id, token, device_type, expires_at, created_at) VALUES (?, ?, 'android', DATE_ADD(NOW(), INTERVAL ? DAY), NOW())","params":"[1,\"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoxLCJleHAiOjE3OTA1ODcyNzMsImlhdCI6MTc4OTk4MjQ3M30=.a0ff02fe72c5f26edd7b8ef6a3b208a2dfa2b724cbc54e0881a7c0d78e55f967\",7]","affected":1,"lastId":"2","exec_time":"0.0435s"}
{"time":"2026-09-21 09:21:16","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:16","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:21:16","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:17","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:18","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:18","type":"SUCCESS","operation":"查询员工: empid=5001","sql":"SELECT empid, orgid, empno, empname, status, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark FROM employee WHERE empid = ? AND orgid = ?","params":"[5001,2]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:21:21","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:22","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:23","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:23","type":"SUCCESS","operation":"查询员工: empid=5001","sql":"SELECT empid, orgid, empno, empname, status, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark FROM employee WHERE empid = ? AND orgid = ?","params":"[5001,2]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:23","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:23","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:21:23","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:21:24","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:24","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:21:24","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:26","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:27","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:27","type":"SUCCESS","operation":"查询员工: empid=5000","sql":"SELECT empid, orgid, empno, empname, status, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark FROM employee WHERE empid = ? AND orgid = ?","params":"[5000,2]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:21:28","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:28","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0015s"}
{"time":"2026-09-21 09:21:28","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 09:21:29","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:21:29","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:21:29","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表: page=2","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 20","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:22:00","type":"SUCCESS","operation":"人员列表: page=3","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 40","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0015s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表: page=4","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 60","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表: page=5","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 80","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表: page=6","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 100","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:01","type":"SUCCESS","operation":"人员列表: page=7","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 120","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=8","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 140","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=9","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 160","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=10","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 180","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=11","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 200","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=12","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 220","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:02","type":"SUCCESS","operation":"人员列表: page=13","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 240","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=14","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 260","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=15","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 280","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=16","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 300","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=17","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 320","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=18","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 340","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0015s"}
{"time":"2026-09-21 09:22:03","type":"SUCCESS","operation":"人员列表: page=19","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 360","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0017s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=20","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 380","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=21","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 400","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0017s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=22","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 420","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=23","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 440","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=24","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 460","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:04","type":"SUCCESS","operation":"人员列表: page=25","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 480","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表: page=26","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 500","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表: page=27","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 520","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表: page=28","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 540","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:05","type":"SUCCESS","operation":"人员列表: page=29","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 560","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:22:06","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:22:06","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0015s"}
{"time":"2026-09-21 09:22:06","type":"SUCCESS","operation":"人员列表: page=30","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 580","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0016s"}
{"time":"2026-09-21 09:22:09","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:09","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:09","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:22:10","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:10","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:10","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:11","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:22:12","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:12","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:12","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:22:13","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:22:13","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:22:13","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:24:43","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:24:43","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:24:43","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:24:44","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:24:44","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:24:44","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:24:45","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:24:45","type":"SUCCESS","operation":"查询员工: empid=5001","sql":"SELECT empid, orgid, empno, empname, status, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark FROM employee WHERE empid = ? AND orgid = ?","params":"[5001,2]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 09:24:46","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:40:11","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:11","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:40:11","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:40:12","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:12","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 09:40:12","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:14","type":"SUCCESS","operation":"查询员工: empid=4999","sql":"SELECT empid, orgid, empno, empname, status, can_login, deptid, identid, positid, gender, idcardno, birthdate, hiredate, remark FROM employee WHERE empid = ? AND orgid = ?","params":"[4999,2]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"更新员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"更新员工-校验权限","sql":"SELECT empid FROM employee WHERE empid = ? AND orgid = ?","params":"[4999,2]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"更新员工: empid=4999","sql":"UPDATE employee SET empname = ?, status = ?, can_login = ?, deptid = ?, identid = ?, positid = ?, gender = ?, idcardno = ?, birthdate = ?, hiredate = ?, remark = ? WHERE empid = ? AND orgid = ?","params":"[\"刘敏1\",1,1,27,4,7,1,\"44010100004998\",\"1985-03-23\",\"2024-04-27\",null,4999,2]","affected":1,"lastId":"0","exec_time":"0.0275s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0010s"}
{"time":"2026-09-21 09:40:23","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:12","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:12","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:12","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:13","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:13","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:13","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:20","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:20","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:24","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:24","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:24","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:25","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:25","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:25","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:26","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:29","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:29","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 09:54:29","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:30","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:30","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:30","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 09:54:31","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:34","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:34","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:34","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:54:35","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:36","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:36","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:36","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:38","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:38","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 09:54:38","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:39","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:39","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:54:39","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:54:41","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:43","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:43","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 09:54:43","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 09:54:44","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 09:54:44","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 09:54:44","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:43","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:04:43","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:04:43","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:44","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:04:44","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:04:44","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:04:45","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:48","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:04:48","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:04:48","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:49","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:04:49","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 10:04:49","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:26","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:26","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0012s"}
{"time":"2026-09-21 10:05:26","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:27","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:27","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:05:27","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 10:05:29","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:33","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:33","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:05:33","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:05:34","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:35","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:35","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:05:35","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 10:05:36","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:06:30","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:06:34","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee WHERE orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:03","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:08:06","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:48:56","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:48:58","type":"SUCCESS","operation":"查询员工: empid=5001","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.empid = ? AND e.orgid = ?","params":"[5001,2]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:49:01","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:02","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:02","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0001s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0001s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:15","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表: page=2","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 20","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:23","type":"SUCCESS","operation":"人员列表: page=3","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 40","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0005s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表: page=4","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 60","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表: page=5","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 80","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0006s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"获取部门树","sql":"SELECT deptid, parentid FROM department WHERE orgid = ?","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.deptid IN (?)","params":"[2,17]","affected":0,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:24","type":"SUCCESS","operation":"人员列表: page=6","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.deptid IN (?) ORDER BY e.empid DESC LIMIT 20 OFFSET 100","params":"[2,17]","affected":20,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 10:49:25","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:12:58","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:13:25","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0014s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0016s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:15:55","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0007s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:57","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:18:59","type":"SUCCESS","operation":"查询员工: empid=5001","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.empid = ? AND e.orgid = ?","params":"[5001,2]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0009s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 11:19:01","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:03","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:03","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0011s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ?","params":"[2]","affected":0,"lastId":0,"exec_time":"0.0008s"}
{"time":"2026-09-21 11:19:08","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2]","affected":20,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:12","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:12","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.empno LIKE ?","params":"[2,\"%001%\"]","affected":0,"lastId":0,"exec_time":"0.0013s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.empno LIKE ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,\"%001%\"]","affected":20,"lastId":0,"exec_time":"0.0021s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.empno LIKE ?","params":"[2,\"%001%\"]","affected":0,"lastId":0,"exec_time":"0.0017s"}
{"time":"2026-09-21 11:19:15","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.empno LIKE ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,\"%001%\"]","affected":20,"lastId":0,"exec_time":"0.0032s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取部门-查用户机构: user_id=1","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取部门列表: orgid=2","sql":"SELECT deptid, orgid, parentid, deptname FROM department WHERE orgid = ? ORDER BY parentid, deptid","params":"[2]","affected":22,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取身份-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取身份列表: orgid=2","sql":"SELECT identid, orgid, identname FROM identities WHERE orgid = ? ORDER BY identid","params":"[2]","affected":4,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取职务-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"获取职务列表: orgid=2","sql":"SELECT positid, orgid, positname FROM positions WHERE orgid = ? ORDER BY positid","params":"[2]","affected":6,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"查询员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:17","type":"SUCCESS","operation":"查询员工: empid=4002","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.empid = ? AND e.orgid = ?","params":"[4002,2]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:19:27","type":"SUCCESS","operation":"导出员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0004s"}
{"time":"2026-09-21 11:19:27","type":"SUCCESS","operation":"导出员工: orgid=2","sql":"SELECT e.empno, e.empname, e.status, e.can_login, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid","params":"[2]","affected":5000,"lastId":0,"exec_time":"0.0142s"}
{"time":"2026-09-21 11:19:52","type":"SUCCESS","operation":"导出员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:19:52","type":"SUCCESS","operation":"导出员工: orgid=2","sql":"SELECT e.empno, e.empname, e.status, e.can_login, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? ORDER BY e.empid","params":"[2]","affected":5000,"lastId":0,"exec_time":"0.0138s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"更新员工-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"更新员工-校验权限","sql":"SELECT empid FROM employee WHERE empid = ? AND orgid = ?","params":"[4002,2]","affected":0,"lastId":0,"exec_time":"0.0002s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"更新员工: empid=4002","sql":"UPDATE employee SET empname = ?, status = ?, can_login = ?, deptid = ?, identid = ?, positid = ?, gender = ?, idcardno = ?, birthdate = ?, hiredate = ?, remark = ? WHERE empid = ? AND orgid = ?","params":"[\"朱静\",1,1,29,4,6,2,\"44010100004001\",\"1981-08-10\",\"2015-06-25\",null,4002,2]","affected":0,"lastId":"0","exec_time":"0.0002s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.empno LIKE ?","params":"[2,\"%001%\"]","affected":0,"lastId":0,"exec_time":"0.0017s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.empno LIKE ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,\"%001%\"]","affected":20,"lastId":0,"exec_time":"0.0036s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表-查用户机构","sql":"SELECT orgid FROM users WHERE id = ? AND status = 1","params":"[1]","affected":1,"lastId":0,"exec_time":"0.0003s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表-总数","sql":"SELECT COUNT(*) FROM employee e WHERE e.orgid = ? AND e.empno LIKE ?","params":"[2,\"%001%\"]","affected":0,"lastId":0,"exec_time":"0.0014s"}
{"time":"2026-09-21 11:20:31","type":"SUCCESS","operation":"人员列表: page=1","sql":"SELECT e.empid, e.orgid, e.empno, e.empname, e.status, e.can_login, e.deptid, e.identid, e.positid, e.gender, e.idcardno, e.birthdate, e.hiredate, e.remark, d.deptname, i.identname, p.positname FROM employee e LEFT JOIN department d ON d.deptid = e.deptid LEFT JOIN identities i ON i.identid = e.identid LEFT JOIN positions p ON p.positid = e.positid WHERE e.orgid = ? AND e.empno LIKE ? ORDER BY e.empid DESC LIMIT 20 OFFSET 0","params":"[2,\"%001%\"]","affected":20,"lastId":0,"exec_time":"0.0022s"}