--------------------------------------------------------------- [2023-01-02T17:13:32+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Login/msgSend [ sql ] [ DB ] CONNECT:[ UseTime:0.000929s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040949s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff` WHERE `phone` = '13868833994' LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.027043s ] [ sql ] [ SQL ] INSERT INTO `v_phone_code` (`phone` , `status` , `phone_code` , `create_time` , `create_date`) VALUES ('13868833994' , 0 , 281299 , 1672650812 , '2023-01-02 17:13:32') [ RunTime:0.005667s ] --------------------------------------------------------------- [2023-01-02T17:13:41+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Login/registe [ sql ] [ DB ] CONNECT:[ UseTime:0.000899s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_phone_code` [ RunTime:0.034735s ] [ sql ] [ SQL ] SELECT * FROM `v_phone_code` WHERE `phone` = '13868833994' AND `phone_code` = '281299' LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_job_number` [ RunTime:0.022937s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff_job_number` ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ] [ sql ] [ SQL ] INSERT INTO `v_staff_job_number` (`job_num` , `num` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('0130' , 1 , 0 , 0 , 1672650821 , '2023-01-02 17:13:41') [ RunTime:0.003969s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027032s ] [ sql ] [ SQL ] INSERT INTO `v_staff` (`phone` , `password` , `job_num` , `status` , `is_delete` , `create_time` , `create_date` , `last_time` , `job_num_id`) VALUES ('13868833994' , 'e96b4b3ac34af04c55f9ccfbfc4a51ef' , '0130' , 0 , 0 , 1672650821 , '2023-01-02 17:13:41' , 1672650821 , 47) [ RunTime:0.001940s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027643s ] [ 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 , 1672650821 , '2023-01-02 17:13:41' , 1 , 1 , 57) [ RunTime:0.003721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.036498s ] [ sql ] [ SQL ] INSERT INTO `v_staff_total` (`status` , `is_delete` , `create_time` , `create_date` , `staff_id`) VALUES (0 , 0 , 1672650821 , '2023-01-02 17:13:41' , 57) [ RunTime:0.002118s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '57|19e4b779e258598819dfcb892eb2fbf8' WHERE `id` = 57 [ RunTime:0.003457s ] [ sql ] [ SQL ] UPDATE `v_phone_code` SET `status` = 1 WHERE `id` = 29 [ RunTime:0.002335s ] --------------------------------------------------------------- [2023-01-02T17:13:49+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000827s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046033s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '徐步伟' , `sex` = 1 WHERE `id` = 57 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038627s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 57 [ RunTime:0.000578s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.037055s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 57,1,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,2,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,3,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,4,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,5,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,6,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,7,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,8,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,9,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,10,0,1672650829,'2023-01-02 17:13:49' ) [ RunTime:0.001099s ] --------------------------------------------------------------- [2023-01-02T17:13:49+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000793s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.060561s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.098358s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000580s ] --------------------------------------------------------------- [2023-01-02T17:13:49+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/completeInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.050282s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.203991s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '徐步伟' , `sex` = 1 WHERE `id` = 57 [ RunTime:0.000463s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.114801s ] [ sql ] [ SQL ] UPDATE `v_staff_action` SET `hospital_ids` = '1,2,3,4,5,6,7,8,9,10' WHERE `staff_id` = 57 [ RunTime:0.000553s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.042605s ] [ sql ] [ SQL ] INSERT INTO `v_staff_hospital` (`staff_id` , `hospital_id` , `is_delete` , `create_time` , `create_date`) VALUES ( 57,1,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,2,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,3,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,4,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,5,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,6,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,7,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,8,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,9,0,1672650829,'2023-01-02 17:13:49' ) , ( 57,10,0,1672650829,'2023-01-02 17:13:49' ) [ RunTime:0.001078s ] --------------------------------------------------------------- [2023-01-02T17:13:49+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000562s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.079251s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.106708s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000593s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.099350s ] [ 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` = 57 [ RunTime:0.001765s ] --------------------------------------------------------------- [2023-01-02T17:13:50+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000840s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041774s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.049811s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000549s ] --------------------------------------------------------------- [2023-01-02T17:13:50+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.058458s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.057153s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.048914s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000537s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027121s ] [ 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` = 57 [ RunTime:0.000820s ] --------------------------------------------------------------- [2023-01-02T17:13:51+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.063934s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059649s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000702s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.081396s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 57 AND `status` = 0 [ RunTime:0.001044s ] --------------------------------------------------------------- [2023-01-02T17:13:51+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001108s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.098879s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000939s ] [ 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` = 57 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.083668s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 57 LIMIT 1 [ RunTime:0.000723s ] --------------------------------------------------------------- [2023-01-02T17:15:07+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000804s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047445s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.045676s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`staff_id` = 57 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000854s ] --------------------------------------------------------------- [2023-01-02T17:15:10+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.001579s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051013s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000733s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.057652s ] [ 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` = 57 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000813s ] --------------------------------------------------------------- [2023-01-02T17:15:16+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.051059s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.083341s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.082631s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.085436s ] [ 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.000806s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.065826s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 3 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000597s ] --------------------------------------------------------------- [2023-01-02T17:15:16+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000880s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.096144s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.070477s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.115400s ] [ 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.000960s ] [ 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.000713s ] --------------------------------------------------------------- [2023-01-02T17:15:24+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.001235s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032368s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.030524s ] [ 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` = 57 AND `d`.`is_delete` = 0 [ RunTime:0.000691s ] --------------------------------------------------------------- [2023-01-02T17:15:50+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000829s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033737s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026329s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`staff_id` = 57 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000770s ] --------------------------------------------------------------- [2023-01-02T17:15:52+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000801s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048428s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003740s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.051409s ] [ 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` = 57 AND `d`.`is_delete` = 0 [ RunTime:0.000674s ] --------------------------------------------------------------- [2023-01-02T17:16:37+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000841s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035472s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000726s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030196s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`t`.`is_apply`,`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 `t`.`staff_id` = 57 AND `t`.`is_delete` = 0 ORDER BY `t`.`is_apply`,`t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000876s ] --------------------------------------------------------------- [2023-01-02T17:16:44+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myDataEdit [ sql ] [ DB ] CONNECT:[ UseTime:0.000797s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051476s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `name` = '徐步伟' , `sex` = 1 , `phone` = '13868833994' WHERE `id` = 57 [ RunTime:0.002304s ] --------------------------------------------------------------- [2023-01-02T17:22:02+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000903s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044395s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000697s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.035814s ] [ 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` = 57 AND `d`.`is_delete` = 0 [ RunTime:0.000654s ] --------------------------------------------------------------- [2023-01-02T17:22:06+08:00] 60.181.166.153 POST 101.132.37.87:9001/api/My/myCreateItem [ sql ] [ DB ] CONNECT:[ UseTime:0.000785s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042535s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035046s ] [ 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` = 57 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000767s ] --------------------------------------------------------------- [2023-01-02T18:12:40+08:00] 112.17.237.78 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.050383s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000722s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.073928s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000613s ] --------------------------------------------------------------- [2023-01-02T18:12:40+08:00] 112.17.237.78 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.075408s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.081000s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time`,`is_top` FROM `v_staff` WHERE `token` = '57|19e4b779e258598819dfcb892eb2fbf8' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.075273s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task`,`management` FROM `v_staff_action` WHERE `staff_id` = 57 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027774s ] [ 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` = 57 [ RunTime:0.001430s ]