caiping/runtime/acctconnect/log/202408/14.log

[2024-08-14T18:49:57+08:00][sql] CONNECT:[ UseTime:0.000931s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-14T18:49:57+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002460s ]
[2024-08-14T18:49:57+08:00][sql] SELECT `acct_connect` FROM `cp_admin` WHERE  `id` = 118 LIMIT 1 [ RunTime:0.000294s ]
[2024-08-14T18:49:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (117,115,93,121,130,116,119,120,1) LIMIT 1 [ RunTime:0.000299s ]
[2024-08-14T18:49:57+08:00][sql] SELECT * FROM `cp_admin` WHERE  `status` >= 0  AND `id` IN (117,115,93,121,130,116,119,120,1) ORDER BY `create_time` ASC LIMIT 0,20 [ RunTime:0.000381s ]
[2024-08-14T18:49:57+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002407s ]
[2024-08-14T18:49:57+08:00][sql] SELECT * FROM `cp_department` WHERE  `id` IN (102,17) [ RunTime:0.000366s ]
[2024-08-14T18:49:57+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002428s ]
[2024-08-14T18:49:57+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 93 [ RunTime:0.000341s ]
[2024-08-14T18:49:57+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.002191s ]
[2024-08-14T18:49:57+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 50 [ RunTime:0.000311s ]
[2024-08-14T18:49:57+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 1 [ RunTime:0.000283s ]
[2024-08-14T18:49:57+08:00][sql] SELECT `title` FROM `cp_admin_group` WHERE  `id` = 1 [ RunTime:0.000228s ]
[2024-08-14T18:50:08+08:00][sql] CONNECT:[ UseTime:0.000881s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_rule` [ RunTime:0.002079s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin_rule` WHERE  `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.001194s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group_access` [ RunTime:0.002030s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin_group_access` `a` LEFT JOIN `cp_admin_group` `g` ON `a`.`group_id`=`g`.`id` WHERE  ( a.uid='93' and g.status='1' ) [ RunTime:0.001947s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_department` [ RunTime:0.002530s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_department` WHERE  `status` = 1 [ RunTime:0.000558s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_position` [ RunTime:0.004137s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_position` WHERE  `status` >= 0 ORDER BY `create_time` ASC [ RunTime:0.000253s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002356s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 93 LIMIT 1 [ RunTime:0.000369s ]
[2024-08-14T18:50:08+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 93 [ RunTime:0.000304s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin_rule` WHERE  `src` = 'acctconnect/connect/view' LIMIT 1 [ RunTime:0.000408s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_log` [ RunTime:0.004387s ]
[2024-08-14T18:50:08+08:00][sql] INSERT INTO `cp_admin_log` SET `title` = '' , `uid` = 118 , `nickname` = 'A财政员工一' , `type` = 'view' , `action` = '查看' , `param_id` = 93 , `param` = '[]' , `module` = 'acctconnect' , `controller` = 'connect' , `function` = 'view' , `subject` = '系统' , `content` = 'A财政员工一在2024-08-14 18:50:08查看了系统' , `ip` = '127.0.0.1' , `create_time` = 1723632608 [ RunTime:0.004190s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 93 LIMIT 1 [ RunTime:0.000347s ]
[2024-08-14T18:50:08+08:00][sql] SELECT `group_id` FROM `cp_admin_group_access` WHERE  `uid` = 93 [ RunTime:0.000213s ]
[2024-08-14T18:50:08+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin_group` [ RunTime:0.000775s ]
[2024-08-14T18:50:08+08:00][sql] SELECT * FROM `cp_admin_group` ORDER BY `create_time` ASC [ RunTime:0.000895s ]
[2024-08-14T18:50:18+08:00][sql] CONNECT:[ UseTime:0.001139s ] mysql:host=127.0.0.1;port=3306;dbname=mxdb;charset=utf8mb4
[2024-08-14T18:50:18+08:00][sql] SHOW FULL COLUMNS FROM `cp_admin` [ RunTime:0.002151s ]
[2024-08-14T18:50:18+08:00][sql] SELECT * FROM `cp_admin` WHERE  `id` = 93 LIMIT 1 [ RunTime:0.000314s ]
[2024-08-14T18:50:18+08:00][sql] UPDATE `cp_admin`  SET `last_login_time` = 1723632618 , `last_login_ip` = '127.0.0.1' , `login_num` = 168  WHERE  `id` = 93 [ RunTime:0.004385s ]