[2023-03-24T08:39:06+08:00][sql] CONNECT:[ UseTime:0.000880s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T08:39:06+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.002457s ] [2023-03-24T08:39:06+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `status` = 1 AND `name` = 'admin' ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000248s ] [2023-03-24T08:39:06+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.002478s ] [2023-03-24T08:39:06+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `user_name` = '系统管理员' , `account` = 'admin' , `action` = '登录' , `method` = 'app\\admin\\subscribe\\User::onUserLogin' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.51' , `create_time` = 1679618345 , `update_time` = 1679618345 [ RunTime:0.000231s ] [2023-03-24T08:39:06+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009932s ] [2023-03-24T08:39:06+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.001126s ] [2023-03-24T08:39:06+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.004718s ] [2023-03-24T08:39:06+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = '4' , `status` = 1 , `login_time` = '2023-03-24 08:39:06' [ RunTime:0.027017s ] [2023-03-24T08:39:09+08:00][sql] CONNECT:[ UseTime:0.005702s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T08:39:09+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.002892s ] [2023-03-24T08:39:09+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000218s ] [2023-03-24T08:40:16+08:00][sql] CONNECT:[ UseTime:0.117245s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T08:40:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.030700s ] [2023-03-24T08:40:16+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `user_name` = '系统管理员' , `account` = 'admin' , `method` = 'logout' , `platform` = 'PC' , `action` = '退出登录' , `url` = '/szym/api/index.php/admin/auth/logout' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.51' , `create_time` = 1679618415 , `update_time` = 1679618415 , `delete_time` = 0 [ RunTime:0.028414s ] [2023-03-24T08:40:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.031089s ] [2023-03-24T08:40:16+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2023-03-24 08:40:16' , `status` = 0 WHERE `user_id` = '4' AND `status` = '1' [ RunTime:0.032733s ] [2023-03-24T08:40:17+08:00][sql] CONNECT:[ UseTime:0.087974s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T08:40:17+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.032227s ] [2023-03-24T08:40:17+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `status` = 1 AND `name` = 'admin' ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.030012s ] [2023-03-24T08:40:17+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.031960s ] [2023-03-24T08:40:17+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `user_name` = '系统管理员' , `account` = 'admin' , `action` = '登录' , `method` = 'app\\admin\\subscribe\\User::onUserLogin' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36 Edg/111.0.1661.51' , `create_time` = 1679618417 , `update_time` = 1679618417 [ RunTime:0.029695s ] [2023-03-24T08:40:17+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.032191s ] [2023-03-24T08:40:17+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.029839s ] [2023-03-24T08:40:17+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.031920s ] [2023-03-24T08:40:17+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = '4' , `status` = 1 , `login_time` = '2023-03-24 08:40:17' [ RunTime:0.031817s ] [2023-03-24T08:40:22+08:00][sql] CONNECT:[ UseTime:0.074293s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T08:40:22+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.027914s ] [2023-03-24T08:40:22+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.025001s ] [2023-03-24T10:05:16+08:00][sql] CONNECT:[ UseTime:0.075197s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2023-03-24T10:05:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.028102s ] [2023-03-24T10:05:16+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.025211s ]