--------------------------------------------------------------- [2020-01-05T11:00:08+08:00] 180.110.209.27 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000983s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.054555s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000903s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033754s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001354s ] --------------------------------------------------------------- [2020-01-05T11:00:08+08:00] 180.110.209.27 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.027373s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000837s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035554s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 31 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001132s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.030247s ] [ 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` = 17261 [ RunTime:0.000985s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` = 17261 ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000634s ] --------------------------------------------------------------- [2020-01-05T17:11:11+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000997s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047953s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000793s ] --------------------------------------------------------------- [2020-01-05T17:11:11+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000594s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.067711s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000780s ] --------------------------------------------------------------- [2020-01-05T17:11:11+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010403s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017523s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|e28905da6e963d62c9dbdab64a4fccd1' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] --------------------------------------------------------------- [2020-01-05T17:11:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.010426s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024522s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0013' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '27|c40944398167a362265f19622baeb706' , `last_time` = 1578215507 WHERE `id` = 27 [ RunTime:0.003450s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018631s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000471s ] --------------------------------------------------------------- [2020-01-05T17:11:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000805s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017078s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000617s ] [ 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` = 27 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000716s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024909s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000617s ] --------------------------------------------------------------- [2020-01-05T17:11:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038008s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001176s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046429s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000713s ] --------------------------------------------------------------- [2020-01-05T17:11:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.011549s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059259s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040934s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.034187s ] [ 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 (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503) [ RunTime:0.001315s ] [ 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 `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001053s ] --------------------------------------------------------------- [2020-01-05T17:11:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000846s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043094s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001468s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029961s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000562s ] --------------------------------------------------------------- [2020-01-05T17:11:49+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010704s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034326s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000805s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029757s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000689s ] --------------------------------------------------------------- [2020-01-05T17:11:57+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032874s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000718s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025260s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] --------------------------------------------------------------- [2020-01-05T17:11:58+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.010645s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024815s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019657s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 27 AND `status` = 0 [ RunTime:0.000527s ] --------------------------------------------------------------- [2020-01-05T17:11:58+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000945s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027265s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000682s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030466s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 50 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001205s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 50 AND `remind_date` >= '2020-01-05' [ RunTime:0.000503s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018552s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000475s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028478s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000572s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 4 WHERE `id` = 50 [ RunTime:0.000502s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024287s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `overdue_task_num` = `overdue_task_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000511s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000488s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000399s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018010s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 50 AND `t`.`type` = 2 [ RunTime:0.000654s ] --------------------------------------------------------------- [2020-01-05T17:11:58+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000765s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026336s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030967s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 27 AND `status` = 0 [ RunTime:0.001831s ] --------------------------------------------------------------- [2020-01-05T17:12:04+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000861s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050083s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001222s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.047541s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000760s ] --------------------------------------------------------------- [2020-01-05T17:12:06+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001342s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047996s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002769s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.060359s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001560s ] --------------------------------------------------------------- [2020-01-05T17:12:06+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002843s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.064473s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002317s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.050130s ] [ 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` = 28 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000978s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026201s ] [ 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` = 28 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000889s ] --------------------------------------------------------------- [2020-01-05T17:12:07+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010925s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026002s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000707s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020359s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] --------------------------------------------------------------- [2020-01-05T17:12:07+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.011025s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018593s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021935s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 50 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000966s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.020995s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 50 AND `remind_date` >= '2020-01-05' [ RunTime:0.000585s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.031158s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.031231s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.019384s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 50 AND `t`.`type` = 2 [ RunTime:0.000645s ] --------------------------------------------------------------- [2020-01-05T17:12:12+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/deleteTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000770s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024948s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020291s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 50 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025489s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000596s ] --------------------------------------------------------------- [2020-01-05T17:12:16+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/deleteTask [ sql ] [ DB ] CONNECT:[ UseTime:0.011163s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025289s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000712s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021785s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 50 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000821s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027982s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000635s ] --------------------------------------------------------------- [2020-01-05T17:12:17+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010987s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025234s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019604s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000609s ] --------------------------------------------------------------- [2020-01-05T17:12:18+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000806s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027970s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000715s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022634s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 50 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001006s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.021193s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 50 AND `remind_date` >= '2020-01-05' [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.020668s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000574s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030028s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.024785s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 50 AND `t`.`type` = 2 [ RunTime:0.000713s ] --------------------------------------------------------------- [2020-01-05T17:12:20+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011212s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033289s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000783s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039662s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000883s ] --------------------------------------------------------------- [2020-01-05T17:12:20+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001842s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039417s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000675s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.037422s ] [ 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` = 28 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000984s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.038510s ] [ 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` = 28 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000756s ] --------------------------------------------------------------- [2020-01-05T17:12:22+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000794s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028228s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000678s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022410s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`status`,`t`.`name`,`t`.`task_num`,`task_content`,`t`.`addess`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`t`.`remark`,`is_apply`,`is_delay`,i.name as item_name,ty.name as type_name,n.name as nature_name,l.name as level_name,`l`.`colour`,`contacts_id`,`t`.`staff_id`,`disable_remark`,`create_staff_id`,s.name as staff_name,`task_type_id`,`task_nature_id`,`t`.`item_id` FROM v_task t LEFT JOIN `v_item` `i` ON `i`.`id`=`t`.`item_id` LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_type` `ty` ON `ty`.`id`=`t`.`task_type_id` LEFT JOIN `v_task_nature` `n` ON `n`.`id`=`t`.`task_nature_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `t`.`id` = 50 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000970s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.022027s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 50 AND `remind_date` >= '2020-01-05' [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.020439s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000576s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030098s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 50 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.034795s ] [ sql ] [ SQL ] SELECT `t`.`create_date`,`t`.`remark`,`s`.`name` FROM v_task_record t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` WHERE `t`.`task_id` = 50 AND `t`.`type` = 2 [ RunTime:0.000652s ] --------------------------------------------------------------- [2020-01-05T17:12:25+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemEnd [ sql ] [ DB ] CONNECT:[ UseTime:0.000786s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025932s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000706s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019658s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 28 AND `staff_id` = 27 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021374s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `item_id` = 28 AND `status` IN (0,1,2) LIMIT 1 [ RunTime:0.000780s ] [ sql ] [ SQL ] UPDATE `v_item` SET `status` = 1 WHERE `id` = 28 [ RunTime:0.000527s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026686s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `finish_item_num` = `finish_item_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000590s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.021936s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578215545 , '2020-01-05 17:12:25' , 28 , 27 , '结束了项目' , 1) [ RunTime:0.000631s ] --------------------------------------------------------------- [2020-01-05T17:12:27+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010564s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052565s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030211s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000751s ] --------------------------------------------------------------- [2020-01-05T17:12:37+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000756s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029299s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000918s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020998s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] --------------------------------------------------------------- [2020-01-05T17:12:39+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000606s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032431s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000819s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038302s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000755s ] --------------------------------------------------------------- [2020-01-05T17:12:40+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010701s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043221s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000867s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.039870s ] [ 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` = 28 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000794s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023525s ] [ 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` = 28 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000837s ] --------------------------------------------------------------- [2020-01-05T17:12:46+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemDel [ sql ] [ DB ] CONNECT:[ UseTime:0.011053s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031616s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000738s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020893s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 28 AND `staff_id` = 27 AND `status` = 1 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000703s ] [ sql ] [ SQL ] UPDATE `v_item` SET `status` = 2 WHERE `id` = 28 [ RunTime:0.000485s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.019292s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578215566 , '2020-01-05 17:12:46' , 28 , 27 , '删除了项目' , 1) [ RunTime:0.000542s ] --------------------------------------------------------------- [2020-01-05T17:12:47+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010552s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027972s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021199s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000656s ] --------------------------------------------------------------- [2020-01-05T17:12:48+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000821s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026093s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '27|c40944398167a362265f19622baeb706' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028332s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 27 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ]