--------------------------------------------------------------- [2022-05-18T10:08:37+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Login/msgSend [ 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.036686s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '18855498383' LIMIT 1 [ RunTime:0.000717s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.029640s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('18855498383' , 0 , 117261 , 1652839717 , '2022-05-18 10:08:37') [ RunTime:0.005462s ] --------------------------------------------------------------- [2022-05-18T10:08:55+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.013652s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.036322s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '18855498383' AND `phone_code` = '117261' LIMIT 1 [ RunTime:0.000577s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.019086s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0120' , 1 , 0 , 0 , 1652839735 , '2022-05-18 10:08:55') [ RunTime:0.004619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021655s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('18855498383' , 'd0580d0ae395e0c05476e3bfcc2eae19' , '0120' , 0 , 0 , 1652839735 , '2022-05-18 10:08:55' , 1652839735 , 37) [ RunTime:0.003122s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020258s ] [ 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 , 1652839735 , '2022-05-18 10:08:55' , 1 , 1 , 47) [ RunTime:0.003735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026850s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1652839735 , '2022-05-18 10:08:55' , 47) [ RunTime:0.004644s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '47|1d0486b0db82ff07f117dede10a97934' WHERE `id` = 47 [ RunTime:0.003442s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 18 [ RunTime:0.002226s ] --------------------------------------------------------------- [2022-05-18T10:09:09+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000701s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027268s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000669s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '刘波' , `sex` = 1 WHERE `id` = 47 [ RunTime:0.000451s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020378s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 47 [ RunTime:0.000572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.022111s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 47,1,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,2,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,3,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,4,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,5,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,6,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,7,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,8,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,9,0,1652839749,'2022-05-18 10:09:09' ) , ( 47,10,0,1652839749,'2022-05-18 10:09:09' ) [ RunTime:0.001113s ] --------------------------------------------------------------- [2022-05-18T10:09:09+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000681s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024258s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042788s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000561s ] --------------------------------------------------------------- [2022-05-18T10:09:09+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000976s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030636s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000908s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.047318s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.044576s ] [ 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` = 47 [ RunTime:0.001832s ] --------------------------------------------------------------- [2022-05-18T10:10:24+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000754s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035694s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039612s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [2022-05-18T10:10:24+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000922s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050548s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046350s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020633s ] [ 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` = 47 [ RunTime:0.000850s ] --------------------------------------------------------------- [2022-05-18T10:10:46+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002883s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027920s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019880s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024994s ] [ 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.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.017576s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000541s ] --------------------------------------------------------------- [2022-05-18T10:10:47+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/cityInfo [ 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.026289s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023378s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.033563s ] [ 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.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.018101s ] [ 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.000553s ] --------------------------------------------------------------- [2022-05-18T10:10:48+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.008049s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027605s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020615s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020567s ] [ 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.000922s ] [ 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.000875s ] --------------------------------------------------------------- [2022-05-18T10:10:55+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006657s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027888s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021995s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027455s ] [ 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.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.019567s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000591s ] --------------------------------------------------------------- [2022-05-18T10:11:07+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000834s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043593s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.047953s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.034201s ] [ 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.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.041241s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000539s ] --------------------------------------------------------------- [2022-05-18T10:11:09+08:00] 101.224.108.246 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.002564s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029581s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '47|1d0486b0db82ff07f117dede10a97934' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022015s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 47 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018976s ] [ 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.000912s ] [ 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.000644s ]