[2026-11-01T11:14:20+08:00][sql] CONNECT:[ UseTime:0.002508s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T11:14:20+08:00][sql] SELECT * FROM `oms_admin_menus` WHERE  `menu_key` = 'production' LIMIT 1 [ RunTime:0.002564s ]
[2026-11-01T11:14:20+08:00][sql] SELECT * FROM `oms_admin_menus` WHERE  `menu_key` = 'production.position-devices' LIMIT 1 [ RunTime:0.002918s ]
[2026-11-01T11:14:20+08:00][sql] INSERT INTO `oms_admin_menus` SET `menu_key` = 'production.position-devices' , `parent_key` = 'production' , `title` = '岗位设备管理' , `icon` = 'Connection' , `sort_order` = 22 , `enabled` = 1 , `updated_at` = 1793502860 [ RunTime:0.001322s ]
[2026-11-01T11:22:44+08:00][sql] CONNECT:[ UseTime:0.011129s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T11:22:44+08:00][sql] CREATE TABLE IF NOT EXISTS `oms_me_position_device` (
 plan_id INT NOT NULL, m_id INT NOT NULL, poid INT NOT NULL, updated_at INT NOT NULL,
 PRIMARY KEY(plan_id,m_id), KEY idx_position(plan_id,poid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.298352s ]
[2026-11-01T11:22:45+08:00][sql] CREATE TABLE IF NOT EXISTS `oms_me_position_device_log` (
 id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY, plan_id INT NOT NULL, m_id INT NOT NULL,
 old_poid INT NOT NULL, new_poid INT NOT NULL, old_name VARCHAR(100) NOT NULL, new_name VARCHAR(100) NOT NULL,
 actor VARCHAR(100) NOT NULL, source VARCHAR(40) NOT NULL, tid INT NOT NULL, created_at INT NOT NULL,
 KEY idx_plan_log(plan_id,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.299605s ]
[2026-11-01T11:23:12+08:00][sql] CONNECT:[ UseTime:0.002247s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T11:23:12+08:00][sql] SELECT * FROM `oms_admin_menus` WHERE  `menu_key` = 'production' LIMIT 1 [ RunTime:0.001646s ]
[2026-11-01T11:23:12+08:00][sql] SELECT * FROM `oms_admin_menus` WHERE  `menu_key` = 'production.position-devices' LIMIT 1 [ RunTime:0.000421s ]
[2026-11-01T15:44:57+08:00][sql] CONNECT:[ UseTime:0.002905s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T15:44:57+08:00][sql] CREATE TABLE IF NOT EXISTS `oms_member_position_request` (
 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, mid INT NOT NULL, tid INT NOT NULL, plan_id INT NOT NULL,
 from_poid INT NOT NULL, to_poid INT NOT NULL, fingerprint CHAR(64) NOT NULL, created_at INT NOT NULL,
 UNIQUE KEY idx_member(mid), KEY idx_team(tid,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.309532s ]
[2026-11-01T15:55:02+08:00][sql] CONNECT:[ UseTime:0.001405s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T15:55:02+08:00][sql] CREATE TABLE IF NOT EXISTS `oms_member_position_request` (
 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, mid INT NOT NULL, tid INT NOT NULL, plan_id INT NOT NULL,
 from_poid INT NOT NULL, to_poid INT NOT NULL, fingerprint CHAR(64) NOT NULL, created_at INT NOT NULL,
 UNIQUE KEY idx_member(mid), KEY idx_team(tid,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.001968s ]
[2026-11-01T15:55:02+08:00][sql] SELECT * FROM `oms_admin_menus_wx` WHERE  `action` = 'memberPositions' LIMIT 1 [ RunTime:0.000873s ]
[2026-11-01T15:55:02+08:00][sql] SELECT `sort` FROM `oms_admin_menus_wx` WHERE  `action` = 'toolsCheck' LIMIT 1 [ RunTime:0.000341s ]
[2026-11-01T15:55:02+08:00][error] [10500]fields not exists:[department_ids][D:\phpstudy_pro\WWW\cqoms.com\vendor\topthink\think-orm\src\db\Builder.php:164]
[2026-11-01T16:35:03+08:00][sql] CONNECT:[ UseTime:0.002653s ] mysql:host=127.0.0.1;port=3306;dbname=oms;charset=utf8
[2026-11-01T16:35:03+08:00][sql] CREATE TABLE IF NOT EXISTS `oms_member_position_request` (
 id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, mid INT NOT NULL, tid INT NOT NULL, plan_id INT NOT NULL,
 from_poid INT NOT NULL, to_poid INT NOT NULL, fingerprint CHAR(64) NOT NULL, created_at INT NOT NULL,
 UNIQUE KEY idx_member(mid), KEY idx_team(tid,id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 [ RunTime:0.002094s ]
[2026-11-01T16:35:03+08:00][sql] SHOW COLUMNS FROM `oms_admin_menus_wx` [ RunTime:0.001307s ]
[2026-11-01T16:35:03+08:00][sql] SHOW FULL COLUMNS FROM `oms_admin_menus_wx` [ RunTime:0.000901s ]
[2026-11-01T16:35:03+08:00][sql] SELECT * FROM `oms_admin_menus_wx` WHERE  `action` = 'memberPositions' LIMIT 1 [ RunTime:0.000472s ]
[2026-11-01T16:35:03+08:00][sql] SELECT `sort` FROM `oms_admin_menus_wx` WHERE  `action` = 'toolsCheck' LIMIT 1 [ RunTime:0.000421s ]
[2026-11-01T16:35:03+08:00][sql] INSERT INTO `oms_admin_menus_wx` SET `action` = 'memberPositions' , `title` = '组员岗位设置' , `route` = '/pages/tools-check/member-positions?mode=leader' , `icon` = 'user-group' , `icon_color` = '#137E78' , `sort` = 5 , `status` = 1 , `user_types` = '1,2,3' , `department_ids` = '' [ RunTime:0.002832s ]