[2021-12-12T17:09:59+08:00][sql] CONNECT:[ UseTime:0.025341s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T17:09:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.046026s ] [2021-12-12T17:09:59+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.001043s ] [2021-12-12T17:09:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.078897s ] [2021-12-12T17:09:59+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639300199 , `update_time` = 1639300199 [ RunTime:0.000643s ] [2021-12-12T17:09:59+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.077735s ] [2021-12-12T17:09:59+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.007181s ] [2021-12-12T17:09:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.019133s ] [2021-12-12T17:09:59+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-12-12 17:09:59' [ RunTime:0.031405s ] [2021-12-12T17:10:06+08:00][sql] CONNECT:[ UseTime:0.003525s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T17:10:06+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.008323s ] [2021-12-12T17:10:06+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000397s ] [2021-12-12T17:46:26+08:00][sql] CONNECT:[ UseTime:0.012960s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T17:46:26+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.008776s ] [2021-12-12T17:46:26+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000537s ] [2021-12-12T18:30:31+08:00][sql] CONNECT:[ UseTime:0.003131s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:30:31+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.009036s ] [2021-12-12T18:30:31+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '退出登录' , `url` = '/szym/api/index.php/admin/auth/logout' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305031 , `update_time` = 1639305031 , `delete_time` = 0 [ RunTime:0.000390s ] [2021-12-12T18:30:31+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.009115s ] [2021-12-12T18:30:31+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-12-12 18:30:31' , `status` = 0 WHERE `user_id` = 4 AND `status` = '1' [ RunTime:0.023237s ] [2021-12-12T18:31:18+08:00][sql] CONNECT:[ UseTime:0.012506s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:31:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009384s ] [2021-12-12T18:31:18+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.000544s ] [2021-12-12T18:31:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.009491s ] [2021-12-12T18:31:18+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305078 , `update_time` = 1639305078 [ RunTime:0.000488s ] [2021-12-12T18:31:18+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009477s ] [2021-12-12T18:31:18+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000599s ] [2021-12-12T18:31:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.008697s ] [2021-12-12T18:31:18+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-12-12 18:31:18' [ RunTime:0.029044s ] [2021-12-12T18:31:22+08:00][sql] CONNECT:[ UseTime:0.003934s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:31:22+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.011659s ] [2021-12-12T18:31:22+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '退出登录' , `url` = '/szym/api/index.php/admin/auth/logout' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305082 , `update_time` = 1639305082 , `delete_time` = 0 [ RunTime:0.000491s ] [2021-12-12T18:31:22+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.010627s ] [2021-12-12T18:31:22+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-12-12 18:31:22' , `status` = 0 WHERE `user_id` = 4 AND `status` = '1' [ RunTime:0.021929s ] [2021-12-12T18:31:30+08:00][sql] CONNECT:[ UseTime:0.013249s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:31:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009849s ] [2021-12-12T18:31:30+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.000482s ] [2021-12-12T18:31:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.009164s ] [2021-12-12T18:31:30+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305090 , `update_time` = 1639305090 [ RunTime:0.000391s ] [2021-12-12T18:31:30+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009939s ] [2021-12-12T18:31:30+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000609s ] [2021-12-12T18:31:30+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.008452s ] [2021-12-12T18:31:30+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-12-12 18:31:30' [ RunTime:0.036074s ] [2021-12-12T18:31:33+08:00][sql] CONNECT:[ UseTime:0.003548s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:31:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009237s ] [2021-12-12T18:31:33+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000445s ] [2021-12-12T18:31:43+08:00][sql] CONNECT:[ UseTime:0.005429s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:31:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.011239s ] [2021-12-12T18:31:43+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '退出登录' , `url` = '/szym/api/index.php/admin/auth/logout' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305103 , `update_time` = 1639305103 , `delete_time` = 0 [ RunTime:0.000463s ] [2021-12-12T18:31:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011393s ] [2021-12-12T18:31:43+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-12-12 18:31:43' , `status` = 0 WHERE `user_id` = 4 AND `status` = '1' [ RunTime:0.097508s ] [2021-12-12T18:41:16+08:00][sql] CONNECT:[ UseTime:0.003178s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:41:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.008758s ] [2021-12-12T18:41:16+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.000526s ] [2021-12-12T18:41:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.008906s ] [2021-12-12T18:41:16+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '127.0.0.1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639305676 , `update_time` = 1639305676 [ RunTime:0.000403s ] [2021-12-12T18:41:16+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.008704s ] [2021-12-12T18:41:16+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000637s ] [2021-12-12T18:41:16+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.008350s ] [2021-12-12T18:41:16+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-12-12 18:41:16' [ RunTime:0.021470s ] [2021-12-12T18:41:19+08:00][sql] CONNECT:[ UseTime:0.013210s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T18:41:19+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009139s ] [2021-12-12T18:41:19+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000470s ] [2021-12-12T22:29:40+08:00][sql] CONNECT:[ UseTime:0.003863s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T22:29:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009792s ] [2021-12-12T22:29:40+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.000624s ] [2021-12-12T22:29:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.009383s ] [2021-12-12T22:29:40+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639319380 , `update_time` = 1639319380 [ RunTime:0.000501s ] [2021-12-12T22:29:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.009176s ] [2021-12-12T22:29:40+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000557s ] [2021-12-12T22:29:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.009062s ] [2021-12-12T22:29:40+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-12-12 22:29:40' [ RunTime:0.070840s ] [2021-12-12T22:29:43+08:00][sql] CONNECT:[ UseTime:0.014084s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T22:29:43+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.009723s ] [2021-12-12T22:29:43+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000481s ] [2021-12-12T23:33:09+08:00][sql] CONNECT:[ UseTime:3.260545s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T23:33:09+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.033839s ] [2021-12-12T23:33:09+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.028760s ] [2021-12-12T23:33:09+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.033851s ] [2021-12-12T23:33:09+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639323189 , `update_time` = 1639323189 [ RunTime:0.029112s ] [2021-12-12T23:33:09+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.034310s ] [2021-12-12T23:33:09+08:00][error] [10501]SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-12-12T23:33:18+08:00][sql] CONNECT:[ UseTime:0.042233s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T23:33:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.033335s ] [2021-12-12T23:33:18+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.028195s ] [2021-12-12T23:33:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.034213s ] [2021-12-12T23:33:18+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639323197 , `update_time` = 1639323197 [ RunTime:0.027994s ] [2021-12-12T23:33:18+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.034243s ] [2021-12-12T23:33:18+08:00][error] [10501]SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-12-12T23:34:35+08:00][sql] CONNECT:[ UseTime:0.049880s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T23:34:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.035528s ] [2021-12-12T23:34:35+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.029900s ] [2021-12-12T23:34:35+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.034371s ] [2021-12-12T23:34:35+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639323275 , `update_time` = 1639323275 [ RunTime:0.031141s ] [2021-12-12T23:34:35+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.039855s ] [2021-12-12T23:34:35+08:00][error] [10501]SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-12-12T23:35:45+08:00][sql] CONNECT:[ UseTime:0.055139s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T23:35:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.021410s ] [2021-12-12T23:35:45+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.018571s ] [2021-12-12T23:35:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.021402s ] [2021-12-12T23:35:45+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 4 , `action` = '登录' , `url` = '/szym/api/index.php/admin/auth/login' , `ip` = '::1' , `user_agent` = 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36' , `create_time` = 1639323345 , `update_time` = 1639323345 [ RunTime:0.018411s ] [2021-12-12T23:35:45+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.022097s ] [2021-12-12T23:35:45+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.019248s ] [2021-12-12T23:35:45+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.022907s ] [2021-12-12T23:35:45+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = '4' , `status` = 1 , `login_time` = '2021-12-12 23:35:45' [ RunTime:0.019519s ] [2021-12-12T23:35:49+08:00][sql] CONNECT:[ UseTime:0.042160s ] mysql:host=47.104.70.80;port=3306;dbname=szym;charset=utf8mb4 [2021-12-12T23:35:49+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.017161s ] [2021-12-12T23:35:49+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.014213s ]