[2021-11-10T00:00:40+08:00][sql] CONNECT:[ UseTime:0.013590s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:00:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.010763s ] [2021-11-10T00:00:40+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000496s ] [2021-11-10T00:01:14+08:00][sql] CONNECT:[ UseTime:0.013451s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:01:14+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011653s ] [2021-11-10T00:01:14+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000460s ] [2021-11-10T00:01:18+08:00][sql] CONNECT:[ UseTime:0.003537s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:01:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.010694s ] [2021-11-10T00:01:18+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000455s ] [2021-11-10T00:06:15+08:00][sql] CONNECT:[ UseTime:0.014845s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:06:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011554s ] [2021-11-10T00:06:15+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.000477s ] [2021-11-10T00:06:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.010378s ] [2021-11-10T00:06:15+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` = 1636473975 , `update_time` = 1636473975 [ RunTime:0.000364s ] [2021-11-10T00:06:15+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.012280s ] [2021-11-10T00:06:15+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000611s ] [2021-11-10T00:06:15+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011331s ] [2021-11-10T00:06:15+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-11-10 00:06:15' [ RunTime:0.023321s ] [2021-11-10T00:06:18+08:00][sql] CONNECT:[ UseTime:0.003673s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:06:18+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011634s ] [2021-11-10T00:06:18+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000538s ] [2021-11-10T00:11:47+08:00][sql] CONNECT:[ UseTime:0.003256s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:11:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.012146s ] [2021-11-10T00:11:47+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` = 1636474307 , `update_time` = 1636474307 , `delete_time` = 0 [ RunTime:0.000361s ] [2021-11-10T00:11:47+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.012221s ] [2021-11-10T00:11:47+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-11-10 00:11:47' , `status` = 0 WHERE `user_id` = 4 AND `status` = '1' [ RunTime:0.017557s ] [2021-11-10T00:11:59+08:00][sql] CONNECT:[ UseTime:0.004602s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:11:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011889s ] [2021-11-10T00:11:59+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `status` = 1 AND `name` = 'mpqrmzf' ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000564s ] [2021-11-10T00:11:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.012921s ] [2021-11-10T00:11:59+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 18 , `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` = 1636474319 , `update_time` = 1636474319 [ RunTime:0.000459s ] [2021-11-10T00:11:59+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.012432s ] [2021-11-10T00:11:59+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 18 [ RunTime:0.000556s ] [2021-11-10T00:11:59+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011133s ] [2021-11-10T00:11:59+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 18 , `status` = 1 , `login_time` = '2021-11-10 00:11:59' [ RunTime:0.087486s ] [2021-11-10T00:12:02+08:00][sql] CONNECT:[ UseTime:0.004018s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:12:02+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011368s ] [2021-11-10T00:12:02+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 18 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000558s ] [2021-11-10T00:14:33+08:00][sql] CONNECT:[ UseTime:0.004082s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:14:33+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011502s ] [2021-11-10T00:14:33+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 18 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000415s ] [2021-11-10T00:14:58+08:00][sql] CONNECT:[ UseTime:0.004377s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T00:14:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.012739s ] [2021-11-10T00:14:58+08:00][sql] INSERT INTO `t_doc_log` SET `user_id` = 18 , `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` = 1636474498 , `update_time` = 1636474498 , `delete_time` = 0 [ RunTime:0.000446s ] [2021-11-10T00:14:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011200s ] [2021-11-10T00:14:58+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-11-10 00:14:58' , `status` = 0 WHERE `user_id` = 18 AND `status` = '1' [ RunTime:0.029178s ] [2021-11-10T01:11:58+08:00][sql] CONNECT:[ UseTime:0.003933s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:11:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011800s ] [2021-11-10T01:11:58+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.000574s ] [2021-11-10T01:11:58+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.011036s ] [2021-11-10T01:11:58+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` = 1636477917 , `update_time` = 1636477917 [ RunTime:0.000588s ] [2021-11-10T01:11:58+08:00][error] [10501]SQLSTATE[42S02]: Base table or view not found: 1146 Table 'szym.v_doc_user_role' doesn't exist[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-11-10T01:12:02+08:00][sql] CONNECT:[ UseTime:0.003117s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:12:02+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011617s ] [2021-11-10T01:12:02+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.000586s ] [2021-11-10T01:12:02+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.011208s ] [2021-11-10T01:12:02+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` = 1636477922 , `update_time` = 1636477922 [ RunTime:0.000421s ] [2021-11-10T01:12:02+08:00][error] [10501]SQLSTATE[42S02]: Base table or view not found: 1146 Table 'szym.v_doc_user_role' doesn't exist[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-11-10T01:12:13+08:00][sql] CONNECT:[ UseTime:0.013311s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:12:13+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011910s ] [2021-11-10T01:12:13+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.000578s ] [2021-11-10T01:12:13+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.011393s ] [2021-11-10T01:12:13+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` = 1636477933 , `update_time` = 1636477933 [ RunTime:0.000460s ] [2021-11-10T01:12:13+08:00][error] [10501]SQLSTATE[42S02]: Base table or view not found: 1146 Table 'szym.v_doc_user_role' doesn't exist[D:\wamp\www\szym\vendor\topthink\think-orm\src\db\PDOConnection.php:768] [2021-11-10T01:12:40+08:00][sql] CONNECT:[ UseTime:0.003205s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:12:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011120s ] [2021-11-10T01:12: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.000541s ] [2021-11-10T01:12:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.010582s ] [2021-11-10T01:12:40+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` = 1636477960 , `update_time` = 1636477960 [ RunTime:0.000449s ] [2021-11-10T01:12:40+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.011941s ] [2021-11-10T01:12:40+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000485s ] [2021-11-10T01:12:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011300s ] [2021-11-10T01:12:40+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-11-10 01:12:40' [ RunTime:0.023520s ] [2021-11-10T01:12:44+08:00][sql] CONNECT:[ UseTime:0.013640s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:12:44+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.012515s ] [2021-11-10T01:12:44+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000383s ] [2021-11-10T01:20:32+08:00][sql] CONNECT:[ UseTime:0.004471s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:20:32+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.014099s ] [2021-11-10T01:20:32+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000647s ] [2021-11-10T01:21:06+08:00][sql] CONNECT:[ UseTime:0.013821s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:21:06+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.010262s ] [2021-11-10T01:21:06+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000478s ] [2021-11-10T01:21:31+08:00][sql] CONNECT:[ UseTime:0.013097s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:21:31+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011974s ] [2021-11-10T01:21:31+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000532s ] [2021-11-10T01:21:57+08:00][sql] CONNECT:[ UseTime:0.013653s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:21:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011772s ] [2021-11-10T01:21:57+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000540s ] [2021-11-10T01:22:11+08:00][sql] CONNECT:[ UseTime:0.003842s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:22:11+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011036s ] [2021-11-10T01:22:11+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000507s ] [2021-11-10T01:22:40+08:00][sql] CONNECT:[ UseTime:0.003205s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T01:22:40+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011064s ] [2021-11-10T01:22:40+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000491s ] [2021-11-10T17:56:52+08:00][sql] CONNECT:[ UseTime:0.003426s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T17:56:52+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.017929s ] [2021-11-10T17:56:52+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` = 1636538211 , `update_time` = 1636538211 , `delete_time` = 0 [ RunTime:0.000321s ] [2021-11-10T17:56:52+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.010524s ] [2021-11-10T17:56:52+08:00][sql] UPDATE `t_doc_online` SET `logout_time` = '2021-11-10 17:56:52' , `status` = 0 WHERE `user_id` = 4 AND `status` = '1' [ RunTime:0.234660s ] [2021-11-10T17:56:57+08:00][sql] CONNECT:[ UseTime:0.006188s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T17:56:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.011945s ] [2021-11-10T17:56:57+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.000593s ] [2021-11-10T17:56:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_log` [ RunTime:0.014874s ] [2021-11-10T17:56:57+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` = 1636538216 , `update_time` = 1636538216 [ RunTime:0.000551s ] [2021-11-10T17:56:57+08:00][sql] SHOW FULL COLUMNS FROM `v_doc_user_role` [ RunTime:0.014490s ] [2021-11-10T17:56:57+08:00][sql] SELECT * FROM `v_doc_user_role` WHERE `user_id` = 4 [ RunTime:0.000719s ] [2021-11-10T17:56:57+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_online` [ RunTime:0.011015s ] [2021-11-10T17:56:57+08:00][sql] INSERT INTO `t_doc_online` SET `user_id` = 4 , `status` = 1 , `login_time` = '2021-11-10 17:56:57' [ RunTime:0.043229s ] [2021-11-10T17:57:00+08:00][sql] CONNECT:[ UseTime:0.004104s ] mysql:host=localhost;port=3306;dbname=szym;charset=utf8mb4 [2021-11-10T17:57:00+08:00][sql] SHOW FULL COLUMNS FROM `t_doc_user` [ RunTime:0.010758s ] [2021-11-10T17:57:00+08:00][sql] SELECT * FROM `t_doc_user` WHERE ( `id` = 4 ) AND `t_doc_user`.`delete_time` = 0 LIMIT 1 [ RunTime:0.000615s ]