--------------------------------------------------------------- [2023-10-20T22:55:35+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000925s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049380s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.035452s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15120465261' , 0 , 759412 , 1697813735 , '2023-10-20 22:55:35') [ RunTime:0.005468s ] --------------------------------------------------------------- [2023-10-20T22:55:56+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.008953s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.045972s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15120465261' AND `phone_code` = '759412' LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.033739s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0135' , 1 , 0 , 0 , 1697813756 , '2023-10-20 22:55:56') [ RunTime:0.005093s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038919s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('15120465261' , 'e1eeaee3de972e4484e0e57fd57f9166' , '0135' , 0 , 0 , 1697813756 , '2023-10-20 22:55:56' , 1697813756 , 52) [ RunTime:0.003348s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039311s ] [ sql ] [ SQL ] INSERT INTO `v_staff_action` (`status` , `is_delete` , `create_time` , `create_date` , `is_create_item` , `is_create_task` , `staff_id`) VALUES (0 , 0 , 1697813756 , '2023-10-20 22:55:56' , 1 , 1 , 62) [ RunTime:0.004741s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.051063s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1697813756 , '2023-10-20 22:55:56' , 62) [ RunTime:0.003305s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '62|e4e14479b09a547848d2a4da0d19c317' WHERE `id` = 62 [ RunTime:0.001873s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 34 [ RunTime:0.003330s ] --------------------------------------------------------------- [2023-10-20T22:59:55+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004589s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.053638s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000756s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '马艾有布' , `sex` = 1 WHERE `id` = 62 [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.037063s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 62 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.040515s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 62,1,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,2,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,3,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,4,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,5,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,6,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,7,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,8,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,9,0,1697813995,'2023-10-20 22:59:55' ) , ( 62,10,0,1697813995,'2023-10-20 22:59:55' ) [ RunTime:0.001214s ] --------------------------------------------------------------- [2023-10-20T22:59:56+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001119s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.113343s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000816s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.077599s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] --------------------------------------------------------------- [2023-10-20T22:59:56+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.013629s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045221s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000770s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.077598s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.053959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 62 [ RunTime:0.001246s ] --------------------------------------------------------------- [2023-10-20T23:00:03+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000966s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059204s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000843s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.059377s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000776s ] --------------------------------------------------------------- [2023-10-20T23:00:03+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000917s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.126571s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000776s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040528s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.043335s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 62 [ RunTime:0.001199s ] --------------------------------------------------------------- [2023-10-20T23:01:15+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000702s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042087s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`id` = 62 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000902s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.070161s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 62 LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [2023-10-20T23:01:15+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.001069s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.101250s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.070336s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 62 AND `status` = 0 [ RunTime:0.000558s ] --------------------------------------------------------------- [2023-10-20T23:01:41+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.008411s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045284s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.036012s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 62 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000792s ] --------------------------------------------------------------- [2023-10-20T23:01:45+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.013420s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050100s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000795s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.036213s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 62 AND `d`.`is_delete` = 0 [ RunTime:0.000735s ] --------------------------------------------------------------- [2023-10-20T23:02:40+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000805s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052715s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000797s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.036661s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 62 AND `d`.`is_delete` = 0 [ RunTime:0.000717s ] --------------------------------------------------------------- [2023-10-20T23:03:19+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000956s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062992s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000879s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.057503s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.071506s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000993s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000762s ] --------------------------------------------------------------- [2023-10-20T23:03:19+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000790s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.130275s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001728s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.089301s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.030938s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (1,2,3,4,5,6,7,8,9,10) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000767s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.035478s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000702s ] --------------------------------------------------------------- [2023-10-20T23:03:47+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000786s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047703s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000743s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038459s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.037959s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000806s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000684s ] --------------------------------------------------------------- [2023-10-20T23:05:08+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000699s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.086523s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.071450s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000649s ] --------------------------------------------------------------- [2023-10-20T23:05:08+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000932s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.061431s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000981s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.064373s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.065280s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 62 [ RunTime:0.000917s ] --------------------------------------------------------------- [2023-10-20T23:05:13+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011270s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.095985s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.065539s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] --------------------------------------------------------------- [2023-10-20T23:05:14+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000612s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.069480s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000802s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.069746s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 62 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.063050s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1,2,3,4,5,6,7,8,9,10) AND `i`.`staff_id` = 62 [ RunTime:0.000927s ] --------------------------------------------------------------- [2023-10-20T23:05:16+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.013719s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.078653s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000734s ] [ sql ] [ SQL ] SELECT `s`.`id`,`s`.`job_num`,`s`.`name`,`s`.`sex`,`s`.`phone`,se.name as sector_name,p.name as position_name FROM v_staff s LEFT JOIN `v_sector` `se` ON `se`.`id`=`s`.`sector_id` LEFT JOIN `v_position` `p` ON `p`.`id`=`s`.`position_id` WHERE `s`.`id` = 62 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.051044s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 62 LIMIT 1 [ RunTime:0.000691s ] --------------------------------------------------------------- [2023-10-20T23:05:16+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000605s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.060751s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.112873s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 62 AND `status` = 0 [ RunTime:0.000657s ] --------------------------------------------------------------- [2023-10-20T23:06:31+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/sendMsg [ sql ] [ DB ] CONNECT:[ UseTime:0.009576s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047982s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.011482s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SELECT `phone` FROM `v_staff` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000440s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.044873s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('15120465261' , 0 , 445597 , 1697814391 , '2023-10-20 23:06:31') [ RunTime:0.004942s ] --------------------------------------------------------------- [2023-10-20T23:06:40+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/My/passwordEdit [ sql ] [ DB ] CONNECT:[ UseTime:0.007870s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047918s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '62|e4e14479b09a547848d2a4da0d19c317' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000714s ] [ sql ] [ DB ] CONNECT:[ UseTime:0.000841s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SELECT `phone` FROM `v_staff` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000364s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.042517s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '15120465261' AND `phone_code` = '445597' LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `password` = 'e1eeaee3de972e4484e0e57fd57f9166' WHERE `id` = 62 [ RunTime:0.000462s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 35 [ RunTime:0.000370s ] --------------------------------------------------------------- [2023-10-20T23:07:32+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000808s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050377s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000704s ] --------------------------------------------------------------- [2023-10-20T23:08:17+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000800s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048191s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000852s ] --------------------------------------------------------------- [2023-10-20T23:14:36+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.008555s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048475s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000715s ] --------------------------------------------------------------- [2023-10-20T23:15:02+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000984s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056707s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000718s ] --------------------------------------------------------------- [2023-10-20T23:15:05+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.001040s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052724s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000720s ] --------------------------------------------------------------- [2023-10-20T23:15:08+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000798s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051626s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000885s ] --------------------------------------------------------------- [2023-10-20T23:15:12+08:00] 39.144.251.189 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.001234s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051475s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '15120465261' LIMIT 1 [ RunTime:0.000699s ]