--------------------------------------------------------------- [2022-11-11T20:10:12+08:00] 123.57.235.51 SSTP_DUPLEX_POST 101.132.37.87/sra_{BA195980-CD49-458b-9E23-C84EE0ADCD75}/ [ error ] [8]未定义数组索引: sstp_duplex_post --------------------------------------------------------------- [2022-11-11T22:00:30+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000851s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027209s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '17625120678' LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.019004s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('17625120678' , 0 , 141654 , 1668175230 , '2022-11-11 22:00:30') [ RunTime:0.005345s ] --------------------------------------------------------------- [2022-11-11T22:00:38+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000715s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.026910s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '17625120678' AND `phone_code` = '141654' LIMIT 1 [ RunTime:0.000681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.020897s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0126' , 1 , 0 , 0 , 1668175238 , '2022-11-11 22:00:38') [ RunTime:0.003895s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025432s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('17625120678' , 'c3df410db7ec5096b4f2be94d09bccda' , '0126' , 0 , 0 , 1668175238 , '2022-11-11 22:00:38' , 1668175238 , 43) [ RunTime:0.004474s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024389s ] [ 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 , 1668175238 , '2022-11-11 22:00:38' , 1 , 1 , 53) [ RunTime:0.003152s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029966s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1668175238 , '2022-11-11 22:00:38' , 53) [ RunTime:0.001925s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' WHERE `id` = 53 [ RunTime:0.002716s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 25 [ RunTime:0.003260s ] --------------------------------------------------------------- [2022-11-11T22:00:53+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000712s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028349s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000665s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '明' , `sex` = 1 WHERE `id` = 53 [ RunTime:0.000510s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027255s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 53 [ RunTime:0.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.022067s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 53,1,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,2,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,3,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,4,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,5,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,6,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,7,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,8,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,9,0,1668175253,'2022-11-11 22:00:53' ) , ( 53,10,0,1668175253,'2022-11-11 22:00:53' ) [ RunTime:0.001173s ] --------------------------------------------------------------- [2022-11-11T22:00:53+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000941s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030717s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039288s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000535s ] --------------------------------------------------------------- [2022-11-11T22:00:53+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000777s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035719s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039432s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023837s ] [ 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` = 53 [ RunTime:0.001148s ] --------------------------------------------------------------- [2022-11-11T22:00:55+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Hospital/myHospital [ 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.048301s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038171s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.028710s ] [ 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.000834s ] [ 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.000656s ] --------------------------------------------------------------- [2022-11-11T22:00:55+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000993s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042960s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041130s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.050668s ] [ 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.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.039776s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000612s ] --------------------------------------------------------------- [2022-11-11T22:01:03+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000677s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029165s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023253s ] [ 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` = 3 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.025826s ] [ 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 `hospital_id` = 3 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000756s ] --------------------------------------------------------------- [2022-11-11T22:01:14+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000832s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034597s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045733s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 53 AND `status` = 0 [ RunTime:0.000554s ] --------------------------------------------------------------- [2022-11-11T22:01:17+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012537s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029343s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000768s ] [ 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` = 53 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029828s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 53 LIMIT 1 [ RunTime:0.000692s ] --------------------------------------------------------------- [2022-11-11T22:01:18+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006248s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031089s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031966s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [2022-11-11T22:01:18+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000740s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.072142s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027040s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 53 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023769s ] [ 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` = 53 [ RunTime:0.001052s ] --------------------------------------------------------------- [2022-11-11T22:01:20+08:00] 122.193.54.136 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.001154s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043626s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '53|bda811e7be60f11396ad459ee3cdcdc8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.042576s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 53 AND `status` = 0 [ RunTime:0.000597s ]