--------------------------------------------------------------- [2022-11-23T12:04:45+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.001518s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030895s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '18227278022' LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.020555s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('18227278022' , 0 , 708685 , 1669176285 , '2022-11-23 12:04:45') [ RunTime:0.005058s ] --------------------------------------------------------------- [2022-11-23T12:05:01+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000714s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.026107s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '18227278022' AND `phone_code` = '708685' LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.018190s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0127' , 1 , 0 , 0 , 1669176301 , '2022-11-23 12:05:01') [ RunTime:0.003672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020746s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('18227278022' , 'f128c0c9d3cd2d80bd35208fe5f20944' , '0127' , 0 , 0 , 1669176301 , '2022-11-23 12:05:01' , 1669176301 , 44) [ RunTime:0.004439s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020167s ] [ 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 , 1669176301 , '2022-11-23 12:05:01' , 1 , 1 , 54) [ RunTime:0.002968s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026553s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1669176301 , '2022-11-23 12:05:01' , 54) [ RunTime:0.003195s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' WHERE `id` = 54 [ RunTime:0.003377s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 26 [ RunTime:0.003079s ] --------------------------------------------------------------- [2022-11-23T12:05:45+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000704s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031941s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000747s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '许芝铭' , `sex` = 1 WHERE `id` = 54 [ RunTime:0.000462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021890s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 54 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.020197s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 54,1,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,2,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,3,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,4,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,5,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,6,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,7,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,8,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,9,0,1669176345,'2022-11-23 12:05:45' ) , ( 54,10,0,1669176345,'2022-11-23 12:05:45' ) [ RunTime:0.001086s ] --------------------------------------------------------------- [2022-11-23T12:05:46+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000691s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041032s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000820s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035525s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 54 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032393s ] [ 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` = 54 [ RunTime:0.001843s ] --------------------------------------------------------------- [2022-11-23T12:05:46+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000674s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050262s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017764s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 54 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000524s ] --------------------------------------------------------------- [2022-11-23T12:05:49+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000658s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022644s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046072s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 54 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.021170s ] [ 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.000893s ] [ 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.000664s ] --------------------------------------------------------------- [2022-11-23T12:05:49+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000918s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062646s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.072253s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 54 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017904s ] [ 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.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.019740s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000544s ] --------------------------------------------------------------- [2022-11-23T12:06:07+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/My/myInfo [ 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.035017s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000696s ] [ 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` = 54 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000768s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.052898s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 54 LIMIT 1 [ RunTime:0.000636s ] --------------------------------------------------------------- [2022-11-23T12:06:07+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/My/myTaskNotSee [ 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.056781s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.055624s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 54 AND `status` = 0 [ RunTime:0.000623s ] --------------------------------------------------------------- [2022-11-23T12:06:16+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007208s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.020432s ] [ 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` = 2 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019069s ] [ 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` = 2 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000707s ] --------------------------------------------------------------- [2022-11-23T12:06:20+08:00] 117.173.184.197 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000661s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026743s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '54|f50f5f734ee3378fa3144f7c8bf45cec' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000709s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023432s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` 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`.`id` = 42 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022730s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `item_id` = 42 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.001009s ]