--------------------------------------------------------------- [2022-07-10T08:15:25+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.016400s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027329s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '13902156775' LIMIT 1 [ RunTime:0.000514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.020484s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('13902156775' , 0 , 111273 , 1657412125 , '2022-07-10 08:15:25') [ RunTime:0.003555s ] --------------------------------------------------------------- [2022-07-10T08:15:44+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.008226s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.026964s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '13902156775' AND `phone_code` = '111273' LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.018977s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0123' , 1 , 0 , 0 , 1657412144 , '2022-07-10 08:15:44') [ RunTime:0.003882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020012s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('13902156775' , '2ea3bdd4d63c5e831442302e93fdebd6' , '0123' , 0 , 0 , 1657412144 , '2022-07-10 08:15:44' , 1657412144 , 40) [ RunTime:0.002992s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025068s ] [ 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 , 1657412144 , '2022-07-10 08:15:44' , 1 , 1 , 50) [ RunTime:0.004563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029192s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1657412144 , '2022-07-10 08:15:44' , 50) [ RunTime:0.001856s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '50|018e237d35a8c120d95aa95bdb6833d3' WHERE `id` = 50 [ RunTime:0.002857s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 21 [ RunTime:0.003274s ] --------------------------------------------------------------- [2022-07-10T08:15:58+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009349s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027404s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '郭' , `sex` = 2 WHERE `id` = 50 [ RunTime:0.000420s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019064s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 50 [ RunTime:0.000450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.018861s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 50,1,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,2,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,3,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,4,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,5,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,6,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,7,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,8,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,9,0,1657412158,'2022-07-10 08:15:58' ) , ( 50,10,0,1657412158,'2022-07-10 08:15:58' ) [ RunTime:0.001037s ] --------------------------------------------------------------- [2022-07-10T08:15:58+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001338s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031432s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036192s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029023s ] [ 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` = 50 [ RunTime:0.001846s ] --------------------------------------------------------------- [2022-07-10T08:15:58+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013175s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050184s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018073s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000555s ] --------------------------------------------------------------- [2022-07-10T08:16:19+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.009836s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026747s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023699s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000525s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019460s ] [ 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.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.018681s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000479s ] --------------------------------------------------------------- [2022-07-10T08:16:24+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008880s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027714s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022922s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000484s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.019961s ] [ 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.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.019393s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000529s ] --------------------------------------------------------------- [2022-07-10T08:16:26+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007278s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028480s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021083s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020813s ] [ 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.020413s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 5 AND `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000589s ] --------------------------------------------------------------- [2022-07-10T08:16:27+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.001309s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028863s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021587s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021708s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000917s ] [ 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 `city_id` = 5 AND `h`.`id` IN ('1','2','3','4','5','6','7','8','9','10') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,100 [ RunTime:0.000696s ] --------------------------------------------------------------- [2022-07-10T08:16:31+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/departmentList [ sql ] [ DB ] CONNECT:[ UseTime:0.000695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029573s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.020446s ] [ sql ] [ SQL ] SELECT `id`,`name`,`letter` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000620s ] --------------------------------------------------------------- [2022-07-10T08:16:42+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010903s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027827s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024627s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000589s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020832s ] [ 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.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.020823s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000560s ] --------------------------------------------------------------- [2022-07-10T08:16:45+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.015312s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030136s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021890s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021668s ] [ 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.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022554s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000513s ] --------------------------------------------------------------- [2022-07-10T08:16:46+08:00] 117.15.66.73 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002720s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028861s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '50|018e237d35a8c120d95aa95bdb6833d3' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021518s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 50 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020469s ] [ 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.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.022565s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 5 AND `parent_id` = 3 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000526s ]