--------------------------------------------------------------- [2020-01-08T09:47:30+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000860s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043200s ] [ 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.000791s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039762s ] [ 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.000677s ] --------------------------------------------------------------- [2020-01-08T09:47:30+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001119s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.064569s ] [ 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.027701s ] [ 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.000729s ] --------------------------------------------------------------- [2020-01-08T09:47:30+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.017669s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062414s ] [ 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.000766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.047238s ] [ 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.000761s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031254s ] [ 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,19504,19505,19506) [ RunTime:0.001182s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000907s ] --------------------------------------------------------------- [2020-01-08T09:47:32+08:00] 101.87.41.133 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.029490s ] [ 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.000927s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034298s ] [ 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.000779s ] --------------------------------------------------------------- [2020-01-08T09:47:32+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.012680s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021276s ] [ 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.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.033593s ] [ 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` = 30 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000760s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021137s ] [ 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` = 30 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000896s ] --------------------------------------------------------------- [2020-01-08T09:47:34+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000818s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033009s ] [ 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.000683s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021886s ] [ 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` = 56 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001107s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019907s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 56 AND `remind_date` >= '2020-01-08' [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.019350s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 56 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000581s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028958s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 56 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018733s ] [ 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` = 56 AND `t`.`type` = 2 [ RunTime:0.000658s ] --------------------------------------------------------------- [2020-01-08T09:47:35+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/verifyDough [ sql ] [ DB ] CONNECT:[ UseTime:0.000747s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024717s ] [ 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.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.025356s ] [ sql ] [ SQL ] SELECT `id` FROM `v_dough_staff` WHERE `task_id` = 56 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000545s ] --------------------------------------------------------------- [2020-01-08T09:47:36+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/Item/doughInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008202s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016616s ] [ 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.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.017216s ] [ sql ] [ SQL ] SELECT `id`,`user_name`,`money_type`,`money`,`staff_id`,`status` FROM `v_dough_staff` WHERE `id` = 15 AND `staff_id` = 27 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.029092s ] [ sql ] [ SQL ] SELECT `d`.`id`,`d`.`start_date`,`d`.`end_date`,`d`.`money`,`d`.`remark`,`t`.`name`,`dough_staff_id`,`start_city`,`end_city`,`money_use`,`t`.`type` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` = 15 AND `d`.`status` = 0 AND `d`.`is_delete` = 0 [ RunTime:0.000822s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_img` [ RunTime:0.027685s ] [ sql ] [ SQL ] SELECT `id`,`img_url`,`dough_id` FROM `v_dough_img` WHERE `dough_id` = 12 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000617s ] --------------------------------------------------------------- [2020-01-08T11:38:48+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010132s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037749s ] [ 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.000800s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.063518s ] [ 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.000785s ] --------------------------------------------------------------- [2020-01-08T11:38:48+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001163s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.088775s ] [ 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.000764s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050282s ] [ 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.000733s ] --------------------------------------------------------------- [2020-01-08T11:38:48+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000744s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044767s ] [ 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.000776s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.054124s ] [ 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.000699s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027041s ] [ 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,19504,19505,19506) [ RunTime:0.001171s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000911s ] --------------------------------------------------------------- [2020-01-08T11:38:51+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015165s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025160s ] [ 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_staff_action` [ RunTime:0.024837s ] [ 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.000625s ] --------------------------------------------------------------- [2020-01-08T11:38:57+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005295s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022933s ] [ 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.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018935s ] [ 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.000634s ] --------------------------------------------------------------- [2020-01-08T11:38:58+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000810s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026286s ] [ 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.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018730s ] [ 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.000608s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017910s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503,19504,19505,19506) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000781s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.016625s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 320 AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000597s ] --------------------------------------------------------------- [2020-01-08T11:38:59+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/cityInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008101s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023409s ] [ 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.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019717s ] [ 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 ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018132s ] [ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `id` IN (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503,19504,19505,19506) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000824s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.017052s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` = 321 AND `parent_id` = 320 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000613s ] --------------------------------------------------------------- [2020-01-08T11:39:00+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.014846s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025760s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019545s ] [ 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.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.018088s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 320 AND `city_id` = 321 AND `h`.`id` IN ('19027','19091','19110','19111','19114','19116','19124','19132','19134','19136','19141','19503','19504','19505','19506') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.000982s ] [ 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 `province_id` = 320 AND `city_id` = 321 AND `h`.`id` IN ('19027','19091','19110','19111','19114','19116','19124','19132','19134','19136','19141','19503','19504','19505','19506') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000841s ] --------------------------------------------------------------- [2020-01-08T11:39:05+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/departmentList [ sql ] [ DB ] CONNECT:[ UseTime:0.008074s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023676s ] [ 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.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_department` [ RunTime:0.018039s ] [ sql ] [ SQL ] SELECT `id`,`name`,`letter` FROM `v_department` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000605s ] --------------------------------------------------------------- [2020-01-08T11:39:07+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000939s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032056s ] [ 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.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019745s ] [ 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.000592s ] --------------------------------------------------------------- [2020-01-08T11:39:17+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000760s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024000s ] [ 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.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019343s ] [ 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.000634s ] --------------------------------------------------------------- [2020-01-08T11:39:23+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/itemAdd [ sql ] [ DB ] CONNECT:[ UseTime:0.003522s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023238s ] [ 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.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017467s ] [ 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.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.016486s ] [ sql ] [ SQL ] SELECT `id` FROM `v_staff_hospital` WHERE `staff_id` = 27 AND `hospital_id` = 19503 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.014563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018693s ] [ sql ] [ SQL ] INSERT INTO `v_item` (`name` , `hospital_id` , `department_id` , `item_introduce` , `item_content` , `remark` , `staff_id` , `status` , `is_delete` , `create_time` , `create_date`) VALUES ('仁济南院' , 19503 , 9 , '跟台' , '跟台' , '' , 27 , 0 , 0 , 1578454763 , '2020-01-08 11:39:23') [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024450s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_item_num` = `create_item_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000539s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017631s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578454763 , '2020-01-08 11:39:23' , 33 , 27 , '创建了项目' , 1) [ RunTime:0.000579s ] --------------------------------------------------------------- [2020-01-08T11:39:23+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000771s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022412s ] [ 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.000845s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022347s ] [ 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.000709s ] --------------------------------------------------------------- [2020-01-08T11:39:23+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000736s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016285s ] [ 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.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015147s ] [ 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.000538s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.015656s ] [ 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,19504,19505,19506) [ RunTime:0.000901s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.000841s ] --------------------------------------------------------------- [2020-01-08T11:39:25+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001074s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033163s ] [ 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.000763s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029882s ] [ 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` = 33 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001089s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.028062s ] [ 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` = 33 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000983s ] --------------------------------------------------------------- [2020-01-08T11:39:26+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013648s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023766s ] [ 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.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024889s ] [ 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.000589s ] --------------------------------------------------------------- [2020-01-08T11:39:27+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011169s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022875s ] [ 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.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017078s ] [ 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.000532s ] --------------------------------------------------------------- [2020-01-08T11:39:38+08:00] 140.207.23.132 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.022764s ] [ 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.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018227s ] [ 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.000595s ] --------------------------------------------------------------- [2020-01-08T11:39:40+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/taskType [ sql ] [ DB ] CONNECT:[ UseTime:0.002698s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025110s ] [ 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.000711s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.021364s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000604s ] --------------------------------------------------------------- [2020-01-08T11:39:42+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/taskNature [ sql ] [ DB ] CONNECT:[ UseTime:0.000755s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027079s ] [ 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.000814s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.019650s ] [ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.000676s ] --------------------------------------------------------------- [2020-01-08T11:39:46+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/taskStaff [ sql ] [ DB ] CONNECT:[ UseTime:0.002491s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023943s ] [ 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.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018630s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 33 AND `status` = 0 LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.016571s ] [ sql ] [ SQL ] SELECT `staff_id` FROM `v_staff_hospital` WHERE `hospital_id` = 19503 AND `is_delete` = 0 [ RunTime:0.014134s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`name` FROM `v_staff` WHERE `id` IN (27,28,32) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000585s ] --------------------------------------------------------------- [2020-01-08T11:39:48+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003373s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025065s ] [ 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.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019313s ] [ 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.000598s ] --------------------------------------------------------------- [2020-01-08T11:39:57+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001710s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022425s ] [ 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.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017231s ] [ 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.000552s ] --------------------------------------------------------------- [2020-01-08T11:40:07+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000734s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023089s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017837s ] [ 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.000577s ] --------------------------------------------------------------- [2020-01-08T11:40:17+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000799s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023743s ] [ 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.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018629s ] [ 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.000588s ] --------------------------------------------------------------- [2020-01-08T11:40:27+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013703s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031818s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018731s ] [ 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.000586s ] --------------------------------------------------------------- [2020-01-08T11:40:37+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001752s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024450s ] [ 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.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018730s ] [ 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.000593s ] --------------------------------------------------------------- [2020-01-08T11:40:43+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/taskAdd [ sql ] [ DB ] CONNECT:[ UseTime:0.014058s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029228s ] [ 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.000750s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019564s ] [ 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.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019953s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 33 AND `hospital_id` IN (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503,19504,19505,19506) AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000865s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.030537s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task_type` WHERE `id` = 2 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.024186s ] [ sql ] [ SQL ] SELECT `task_level_id` FROM `v_task_nature` WHERE `id` = 4 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020943s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task` WHERE `task_num` = '202001087850' LIMIT 1 [ RunTime:0.000548s ] [ sql ] [ SQL ] INSERT INTO `v_task` (`item_id` , `name` , `task_type_id` , `task_nature_id` , `staff_id` , `start_date` , `start_time` , `end_date` , `end_time` , `task_content` , `status` , `is_delete` , `create_time` , `create_date` , `create_staff_id` , `task_num` , `hospital_id` , `department_id` , `task_level_id`) VALUES (33 , '仁济南院跟台' , 2 , 4 , 27 , '2020-1-8' , '12:00:00' , '2020-1-8' , '17:00:00' , '沈佳林三台' , 0 , 0 , 1578454841 , '2020-01-08 11:40:41' , 27 , '202001087850' , 19503 , 9 , 3) [ RunTime:0.000680s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025805s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_task_num` = `create_task_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000553s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `total_task_num` = `total_task_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000394s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.027026s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578454842 , '2020-01-08 11:40:42' , 62 , 27 , '创建了任务' , 2) [ RunTime:0.000572s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000489s ] --------------------------------------------------------------- [2020-01-08T11:40:43+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.015578s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024430s ] [ 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.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018996s ] [ 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` = 33 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000764s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020547s ] [ 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` = 33 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000801s ] --------------------------------------------------------------- [2020-01-08T11:40:47+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001799s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024671s ] [ 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_staff_action` [ RunTime:0.019233s ] [ 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.000604s ] --------------------------------------------------------------- [2020-01-08T11:40:57+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008885s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025016s ] [ 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.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018479s ] [ 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.000567s ] --------------------------------------------------------------- [2020-01-08T11:41:08+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015409s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024034s ] [ 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.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023166s ] [ 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.000599s ] --------------------------------------------------------------- [2020-01-08T11:41:18+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012397s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025079s ] [ 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.000739s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023321s ] [ 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.000621s ] --------------------------------------------------------------- [2020-01-08T11:43:08+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010960s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024462s ] [ 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.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018683s ] [ 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.000568s ] --------------------------------------------------------------- [2020-01-08T11:43:18+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015371s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025732s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017344s ] [ 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.000538s ] --------------------------------------------------------------- [2020-01-08T11:43:28+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005481s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050609s ] [ 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.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022927s ] [ 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.000627s ] --------------------------------------------------------------- [2020-01-08T11:43:38+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002731s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023333s ] [ 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.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018400s ] [ 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.000598s ] --------------------------------------------------------------- [2020-01-08T11:43:48+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013218s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031303s ] [ 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.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020271s ] [ 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.000612s ] --------------------------------------------------------------- [2020-01-08T11:43:58+08:00] 140.207.23.132 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005844s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022605s ] [ 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.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018096s ] [ 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.000555s ] --------------------------------------------------------------- [2020-01-08T11:48:25+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001814s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024604s ] [ 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.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018261s ] [ 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.000568s ] --------------------------------------------------------------- [2020-01-08T11:48:34+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006043s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022971s ] [ 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.020108s ] [ 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.000586s ] --------------------------------------------------------------- [2020-01-08T11:48:44+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001397s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029779s ] [ 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.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021123s ] [ 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.000567s ] --------------------------------------------------------------- [2020-01-08T11:48:54+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013654s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023591s ] [ 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.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019053s ] [ 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.000610s ] --------------------------------------------------------------- [2020-01-08T11:49:05+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014604s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027171s ] [ 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.000673s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.055493s ] [ 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.000625s ] --------------------------------------------------------------- [2020-01-08T11:49:15+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008489s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025703s ] [ 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.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024459s ] [ 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.000605s ] --------------------------------------------------------------- [2020-01-08T11:49:29+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010306s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062418s ] [ 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.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027820s ] [ 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.001254s ] --------------------------------------------------------------- [2020-01-08T11:49:39+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015318s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023413s ] [ 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.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017693s ] [ 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.000575s ] --------------------------------------------------------------- [2020-01-08T11:49:49+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002458s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023955s ] [ 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.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022359s ] [ 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.000617s ] --------------------------------------------------------------- [2020-01-08T11:50:40+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.016128s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022924s ] [ 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.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017213s ] [ 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.000554s ] --------------------------------------------------------------- [2020-01-08T11:50:50+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012813s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047134s ] [ 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.001361s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.037806s ] [ 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.001124s ] --------------------------------------------------------------- [2020-01-08T11:51:02+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004982s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036546s ] [ 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.001068s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027117s ] [ 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.001029s ] --------------------------------------------------------------- [2020-01-08T11:51:11+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012983s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025238s ] [ 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.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018421s ] [ 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.000581s ] --------------------------------------------------------------- [2020-01-08T11:51:21+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009207s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022652s ] [ 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.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018016s ] [ 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.000571s ] --------------------------------------------------------------- [2020-01-08T11:51:32+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014642s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038348s ] [ 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.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025590s ] [ 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.000996s ] --------------------------------------------------------------- [2020-01-08T11:51:59+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007544s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038897s ] [ 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.000945s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032305s ] [ 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.001060s ] --------------------------------------------------------------- [2020-01-08T11:52:09+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014112s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022974s ] [ 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.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017622s ] [ 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.000577s ] --------------------------------------------------------------- [2020-01-08T11:52:30+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014015s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025000s ] [ 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.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018093s ] [ 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.000581s ] --------------------------------------------------------------- [2020-01-08T11:53:20+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008370s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023662s ] [ 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.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020195s ] [ 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.000570s ] --------------------------------------------------------------- [2020-01-08T11:53:30+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005721s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023773s ] [ 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.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019160s ] [ 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.000636s ] --------------------------------------------------------------- [2020-01-08T11:53:54+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004930s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024028s ] [ 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.000688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019488s ] [ 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.000625s ] --------------------------------------------------------------- [2020-01-08T11:54:04+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006378s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023869s ] [ 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.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018493s ] [ 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.000607s ] --------------------------------------------------------------- [2020-01-08T11:54:14+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000773s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023066s ] [ 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.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020008s ] [ 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.000560s ] --------------------------------------------------------------- [2020-01-08T11:55:16+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008542s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025474s ] [ 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.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018624s ] [ 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.000554s ] --------------------------------------------------------------- [2020-01-08T11:55:44+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013723s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025316s ] [ 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.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019134s ] [ 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.000603s ] --------------------------------------------------------------- [2020-01-08T11:55:54+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015114s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024298s ] [ 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.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018586s ] [ 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.000564s ] --------------------------------------------------------------- [2020-01-08T11:56:04+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001916s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024898s ] [ 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.000665s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019580s ] [ 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.000617s ] --------------------------------------------------------------- [2020-01-08T11:56:14+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012873s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023960s ] [ 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.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018405s ] [ 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.000647s ] --------------------------------------------------------------- [2020-01-08T11:56:50+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001656s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.038417s ] [ 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.019079s ] [ 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.000664s ] --------------------------------------------------------------- [2020-01-08T11:57:16+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008950s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022843s ] [ 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.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021349s ] [ 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.000563s ] --------------------------------------------------------------- [2020-01-08T11:58:21+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008749s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022838s ] [ 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.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018335s ] [ 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.000581s ] --------------------------------------------------------------- [2020-01-08T11:58:30+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000792s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022315s ] [ 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.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017231s ] [ 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.000551s ] --------------------------------------------------------------- [2020-01-08T11:58:40+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004067s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024020s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018686s ] [ 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.000575s ] --------------------------------------------------------------- [2020-01-08T11:58:51+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006979s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026304s ] [ 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.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025919s ] [ 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.000616s ] --------------------------------------------------------------- [2020-01-08T11:59:01+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000763s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024799s ] [ 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.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024005s ] [ 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.000621s ] --------------------------------------------------------------- [2020-01-08T11:59:31+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008126s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024202s ] [ 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.000713s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019348s ] [ 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.000580s ] --------------------------------------------------------------- [2020-01-08T11:59:41+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000739s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022945s ] [ 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.019884s ] [ 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.000577s ] --------------------------------------------------------------- [2020-01-08T11:59:51+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.016167s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023199s ] [ 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.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019538s ] [ 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.000617s ] --------------------------------------------------------------- [2020-01-08T12:00:01+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001443s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025979s ] [ 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.000696s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019958s ] [ 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.000610s ] --------------------------------------------------------------- [2020-01-08T12:03:09+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001706s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024164s ] [ 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.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018364s ] [ 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.000557s ] --------------------------------------------------------------- [2020-01-08T12:03:19+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015643s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023728s ] [ 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_staff_action` [ RunTime:0.018754s ] [ 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.000654s ] --------------------------------------------------------------- [2020-01-08T12:03:29+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007335s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024675s ] [ 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.000713s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019073s ] [ 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.000571s ] --------------------------------------------------------------- [2020-01-08T12:03:40+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007060s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026015s ] [ 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.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019222s ] [ 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.000591s ] --------------------------------------------------------------- [2020-01-08T12:03:50+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000772s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024577s ] [ 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.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019591s ] [ 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.000597s ] --------------------------------------------------------------- [2020-01-08T12:04:00+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002135s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024529s ] [ 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.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019851s ] [ 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 ] --------------------------------------------------------------- [2020-01-08T12:04:45+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000796s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025397s ] [ 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.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021550s ] [ 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.000614s ] --------------------------------------------------------------- [2020-01-08T12:04:55+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010150s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025177s ] [ 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.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017521s ] [ 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.000526s ] --------------------------------------------------------------- [2020-01-08T12:06:36+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011540s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024622s ] [ 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.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017211s ] [ 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.000551s ] --------------------------------------------------------------- [2020-01-08T12:06:46+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.023840s ] [ 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_staff_action` [ RunTime:0.022420s ] [ 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.000581s ] --------------------------------------------------------------- [2020-01-08T12:07:11+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.024451s ] [ 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.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018602s ] [ 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.000590s ] --------------------------------------------------------------- [2020-01-08T12:07:49+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000919s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023798s ] [ 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.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022043s ] [ 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.000594s ] --------------------------------------------------------------- [2020-01-08T12:08:05+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002000s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025424s ] [ 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.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020048s ] [ 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.000579s ] --------------------------------------------------------------- [2020-01-08T12:09:11+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014755s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024678s ] [ 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_staff_action` [ RunTime:0.017401s ] [ 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.000667s ] --------------------------------------------------------------- [2020-01-08T12:09:21+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000788s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023440s ] [ 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.017832s ] [ 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.000551s ] --------------------------------------------------------------- [2020-01-08T12:09:48+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005695s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026292s ] [ 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.000698s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031836s ] [ 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.000842s ] --------------------------------------------------------------- [2020-01-08T12:10:03+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000847s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027327s ] [ 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.000677s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019876s ] [ 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.000616s ] --------------------------------------------------------------- [2020-01-08T12:10:41+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002481s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024775s ] [ 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.000652s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019150s ] [ 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.000563s ] --------------------------------------------------------------- [2020-01-08T12:10:51+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000766s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023620s ] [ 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.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021154s ] [ 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.000637s ] --------------------------------------------------------------- [2020-01-08T12:11:07+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013066s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026199s ] [ 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.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018739s ] [ 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.000586s ] --------------------------------------------------------------- [2020-01-08T12:11:17+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004189s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023859s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018384s ] [ 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.000604s ] --------------------------------------------------------------- [2020-01-08T12:11:29+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000825s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023026s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019006s ] [ 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.000621s ] --------------------------------------------------------------- [2020-01-08T12:11:39+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002676s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023762s ] [ 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.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019054s ] [ 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.000572s ] --------------------------------------------------------------- [2020-01-08T12:12:03+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013071s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024852s ] [ 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.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019449s ] [ 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.000611s ] --------------------------------------------------------------- [2020-01-08T12:14:13+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007171s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025398s ] [ 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.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020065s ] [ 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.000620s ] --------------------------------------------------------------- [2020-01-08T12:14:23+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007689s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029095s ] [ 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.000720s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017224s ] [ 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.000540s ] --------------------------------------------------------------- [2020-01-08T12:14:33+08:00] 112.64.68.9 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000769s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022761s ] [ 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.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017978s ] [ 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.000702s ] --------------------------------------------------------------- [2020-01-08T14:08:28+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000965s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052848s ] [ 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.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.071413s ] [ 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.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.057813s ] [ 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,19504,19505,19506) [ RunTime:0.001459s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001181s ] --------------------------------------------------------------- [2020-01-08T14:08:28+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002588s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.091141s ] [ 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.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.094558s ] [ 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.001444s ] --------------------------------------------------------------- [2020-01-08T14:08:28+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002224s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.092918s ] [ 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.000885s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.052689s ] [ 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.000604s ] --------------------------------------------------------------- [2020-01-08T14:08:31+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.016396s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025240s ] [ 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.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020107s ] [ 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` = 62 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001122s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.018809s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 62 AND `remind_date` >= '2020-01-08' [ RunTime:0.000561s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.021163s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028916s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000615s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 1 WHERE `id` = 62 [ RunTime:0.000466s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017954s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578463711 , '2020-01-08 14:08:31' , 62 , 27 , '查看了任务' , 2) [ RunTime:0.000579s ] [ 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` = 62 AND `t`.`type` = 2 [ RunTime:0.000591s ] --------------------------------------------------------------- [2020-01-08T14:08:36+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/Item/startTask [ sql ] [ DB ] CONNECT:[ UseTime:0.014725s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025244s ] [ 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.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023275s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 62 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000909s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027780s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 2 WHERE `id` = 62 [ RunTime:0.000472s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `ongoing_task_num` = 1 WHERE `id` = 12 [ RunTime:0.000398s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.019413s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578463716 , '2020-01-08 14:08:36' , 62 , 27 , '开始任务' , 2) [ RunTime:0.000582s ] --------------------------------------------------------------- [2020-01-08T14:08:37+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002070s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017069s ] [ 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.000664s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018085s ] [ 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` = 62 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001047s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.021465s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 62 AND `remind_date` >= '2020-01-08' [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.019596s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030106s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.025234s ] [ 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` = 62 AND `t`.`type` = 2 [ RunTime:0.000695s ] --------------------------------------------------------------- [2020-01-08T14:08:37+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000895s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023155s ] [ 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.000764s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023230s ] [ 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.000593s ] --------------------------------------------------------------- [2020-01-08T14:08:48+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025006s ] [ 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.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020892s ] [ 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.000610s ] --------------------------------------------------------------- [2020-01-08T14:08:58+08:00] 112.65.61.94 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002933s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028528s ] [ 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.000703s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020478s ] [ 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.000598s ] --------------------------------------------------------------- [2020-01-08T16:24:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000872s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.067325s ] [ 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.000815s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.054007s ] [ 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.000721s ] --------------------------------------------------------------- [2020-01-08T16:24:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000953s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047077s ] [ 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.000759s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.049029s ] [ 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.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.053552s ] [ 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,19504,19505,19506) [ RunTime:0.001512s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001132s ] --------------------------------------------------------------- [2020-01-08T16:24:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013164s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050145s ] [ 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.000808s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046258s ] [ 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.000583s ] --------------------------------------------------------------- [2020-01-08T16:24:35+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000896s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030946s ] [ 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.000945s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030323s ] [ 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.000803s ] --------------------------------------------------------------- [2020-01-08T16:24:35+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000784s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026695s ] [ 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.001278s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027228s ] [ 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` = 30 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023272s ] [ 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` = 30 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000966s ] --------------------------------------------------------------- [2020-01-08T16:24:37+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000759s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022563s ] [ 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.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017857s ] [ 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.000552s ] --------------------------------------------------------------- [2020-01-08T16:24:45+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskType [ sql ] [ DB ] CONNECT:[ UseTime:0.000775s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024602s ] [ 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.000710s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.020085s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-08T16:24:48+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskNature [ sql ] [ DB ] CONNECT:[ UseTime:0.000881s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025230s ] [ 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.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.019826s ] [ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.000643s ] --------------------------------------------------------------- [2020-01-08T16:24:51+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskStaff [ sql ] [ DB ] CONNECT:[ UseTime:0.000867s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026038s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020039s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 30 AND `status` = 0 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_hospital` [ RunTime:0.017410s ] [ sql ] [ SQL ] SELECT `staff_id` FROM `v_staff_hospital` WHERE `hospital_id` = 19505 AND `is_delete` = 0 [ RunTime:0.013913s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`name` FROM `v_staff` WHERE `id` IN (27,28,32) AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000641s ] --------------------------------------------------------------- [2020-01-08T16:24:52+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009259s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025267s ] [ 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.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020084s ] [ 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.000599s ] --------------------------------------------------------------- [2020-01-08T16:25:02+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000774s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024319s ] [ 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.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019018s ] [ 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.000579s ] --------------------------------------------------------------- [2020-01-08T16:25:12+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014596s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040054s ] [ 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.000893s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020531s ] [ 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.000599s ] --------------------------------------------------------------- [2020-01-08T16:25:22+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000766s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023495s ] [ 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.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019445s ] [ 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 ] --------------------------------------------------------------- [2020-01-08T16:25:26+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskAdd [ 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.023869s ] [ 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.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021945s ] [ 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.000594s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023456s ] [ sql ] [ SQL ] SELECT * FROM `v_item` WHERE `id` = 30 AND `hospital_id` IN (19027,19091,19110,19111,19114,19116,19124,19132,19134,19136,19141,19503,19504,19505,19506) AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000876s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.021054s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task_type` WHERE `id` = 2 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.017937s ] [ sql ] [ SQL ] SELECT `task_level_id` FROM `v_task_nature` WHERE `id` = 2 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000520s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019006s ] [ sql ] [ SQL ] SELECT `id` FROM `v_task` WHERE `task_num` = '202001084190' LIMIT 1 [ RunTime:0.000526s ] [ sql ] [ SQL ] INSERT INTO `v_task` (`item_id` , `name` , `task_type_id` , `task_nature_id` , `staff_id` , `start_date` , `start_time` , `end_date` , `end_time` , `task_content` , `status` , `is_delete` , `create_time` , `create_date` , `create_staff_id` , `task_num` , `hospital_id` , `department_id` , `task_level_id`) VALUES (30 , '东肝送货' , 2 , 2 , 27 , '2020-1-8' , '16:31:00' , '2020-1-8' , '17:00:00' , '送货20莲花' , 0 , 0 , 1578471926 , '2020-01-08 16:25:26' , 27 , '202001084190' , 19505 , 12 , 2) [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024386s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `create_task_num` = `create_task_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000514s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `total_task_num` = `total_task_num` + 1 WHERE `staff_id` = 27 [ RunTime:0.000390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020569s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578471926 , '2020-01-08 16:25:26' , 63 , 27 , '创建了任务' , 2) [ RunTime:0.000542s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000477s ] --------------------------------------------------------------- [2020-01-08T16:25:26+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000750s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022546s ] [ 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.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.015473s ] [ 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` = 30 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000735s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026426s ] [ 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` = 30 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000766s ] --------------------------------------------------------------- [2020-01-08T16:25:28+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000787s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023977s ] [ 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.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020715s ] [ 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` = 63 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000995s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.023401s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 63 AND `remind_date` >= '2020-01-08' [ RunTime:0.000598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.020089s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 63 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030126s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 63 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000623s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 1 WHERE `id` = 63 [ RunTime:0.000461s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.021986s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578471928 , '2020-01-08 16:25:28' , 63 , 27 , '查看了任务' , 2) [ RunTime:0.000551s ] [ 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` = 63 AND `t`.`type` = 2 [ RunTime:0.000598s ] --------------------------------------------------------------- [2020-01-08T16:25:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/startTask [ sql ] [ DB ] CONNECT:[ UseTime:0.012670s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024931s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020659s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 63 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000784s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027108s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 2 WHERE `id` = 63 [ RunTime:0.000463s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `ongoing_task_num` = 2 WHERE `id` = 12 [ RunTime:0.000396s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018280s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578471932 , '2020-01-08 16:25:32' , 63 , 27 , '开始任务' , 2) [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-08T16:25:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000734s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.018181s ] [ 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.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.040115s ] [ 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` = 63 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001353s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.105148s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 63 AND `remind_date` >= '2020-01-08' [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.028973s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 63 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000730s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.050322s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 63 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.037197s ] [ 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` = 63 AND `t`.`type` = 2 [ RunTime:0.000770s ] --------------------------------------------------------------- [2020-01-08T16:25:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004139s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.106527s ] [ 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.000877s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.076159s ] [ 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.000672s ] --------------------------------------------------------------- [2020-01-08T16:25:32+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001641s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048048s ] [ 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.001064s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.059473s ] [ 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` = 30 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.040047s ] [ 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` = 30 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000721s ] --------------------------------------------------------------- [2020-01-08T16:25:42+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000767s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024096s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019791s ] [ 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.000588s ] --------------------------------------------------------------- [2020-01-08T16:25:52+08:00] 112.64.68.85 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.029865s ] [ 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.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019170s ] [ 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.000573s ] --------------------------------------------------------------- [2020-01-08T16:26:02+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004385s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024552s ] [ 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.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019802s ] [ 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.000597s ] --------------------------------------------------------------- [2020-01-08T16:26:12+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009445s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028787s ] [ 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.000757s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019135s ] [ 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.000622s ] --------------------------------------------------------------- [2020-01-08T16:33:07+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002016s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029736s ] [ 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.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020183s ] [ 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.000617s ] --------------------------------------------------------------- [2020-01-08T16:33:13+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.012110s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024367s ] [ 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.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019342s ] [ 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.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019113s ] [ 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,19504,19505,19506) [ RunTime:0.000984s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 20,20 [ RunTime:0.000856s ] --------------------------------------------------------------- [2020-01-08T16:33:17+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001016s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.046291s ] [ 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.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023681s ] [ 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.000685s ] --------------------------------------------------------------- [2020-01-08T16:33:17+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.008737s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.015456s ] [ 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.000573s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018644s ] [ 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` = 33 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019651s ] [ 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` = 33 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000732s ] --------------------------------------------------------------- [2020-01-08T16:33:17+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004147s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025154s ] [ 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.000659s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015985s ] [ 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.000560s ] --------------------------------------------------------------- [2020-01-08T16:33:19+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.010259s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025342s ] [ 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.000686s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019962s ] [ 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` = 62 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000926s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019088s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 62 AND `remind_date` >= '2020-01-08' [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.023943s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.029015s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.018868s ] [ 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` = 62 AND `t`.`type` = 2 [ RunTime:0.000683s ] --------------------------------------------------------------- [2020-01-08T16:33:22+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/finishTask [ 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.028244s ] [ 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.000667s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020687s ] [ sql ] [ SQL ] SELECT * FROM `v_task` WHERE `id` = 62 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000800s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.026420s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 27 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000474s ] [ sql ] [ SQL ] UPDATE `v_task` SET `status` = 3 WHERE `id` = 62 [ RunTime:0.000553s ] [ sql ] [ SQL ] UPDATE `v_staff_total` SET `ongoing_task_num` = 1 , `finish_task_num` = 3 , `finish_task_rate` = 50 WHERE `id` = 12 [ RunTime:0.000501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.024511s ] [ sql ] [ SQL ] INSERT INTO `v_task_record` (`create_time` , `create_date` , `task_id` , `staff_id` , `remark` , `type`) VALUES (1578472402 , '2020-01-08 16:33:22' , 62 , 27 , '完成了任务' , 2) [ RunTime:0.000677s ] --------------------------------------------------------------- [2020-01-08T16:33:22+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001259s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026140s ] [ 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.000705s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032471s ] [ 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` = 33 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001681s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.029667s ] [ 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` = 33 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000851s ] --------------------------------------------------------------- [2020-01-08T16:33:22+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001122s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023570s ] [ 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.001168s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024169s ] [ 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` = 62 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001191s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.033427s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 62 AND `remind_date` >= '2020-01-08' [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018741s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000543s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.027974s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 62 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.016808s ] [ 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` = 62 AND `t`.`type` = 2 [ RunTime:0.000664s ] --------------------------------------------------------------- [2020-01-08T16:33:27+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010586s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023546s ] [ 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.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019716s ] [ 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.000599s ] --------------------------------------------------------------- [2020-01-08T16:33:28+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.004741s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023049s ] [ 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.018229s ] [ 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.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019948s ] [ 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,19504,19505,19506) [ RunTime:0.000975s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 40,20 [ RunTime:0.000868s ] --------------------------------------------------------------- [2020-01-08T16:33:37+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012975s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024495s ] [ 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.000684s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018760s ] [ 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.000603s ] --------------------------------------------------------------- [2020-01-08T16:33:47+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013878s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032597s ] [ 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.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019889s ] [ 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.000606s ] --------------------------------------------------------------- [2020-01-08T16:33:57+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000870s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023304s ] [ 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.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017861s ] [ 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.000619s ] --------------------------------------------------------------- [2020-01-08T16:34:07+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002409s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028870s ] [ 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_staff_action` [ RunTime:0.019230s ] [ 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.000593s ] --------------------------------------------------------------- [2020-01-08T16:34:17+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005672s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023970s ] [ 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.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018251s ] [ 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.000629s ] --------------------------------------------------------------- [2020-01-08T16:34:21+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.014213s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022543s ] [ 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.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017814s ] [ 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.000563s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018713s ] [ 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,19504,19505,19506) [ RunTime:0.000901s ] [ 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,19504,19505,19506) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 60,20 [ RunTime:0.000824s ] --------------------------------------------------------------- [2020-01-08T16:34:27+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013397s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023643s ] [ 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.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018575s ] [ 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.000684s ] --------------------------------------------------------------- [2020-01-08T16:34:37+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006717s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025274s ] [ 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.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018181s ] [ 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.000552s ] --------------------------------------------------------------- [2020-01-08T16:34:47+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000845s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024122s ] [ 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_staff_action` [ RunTime:0.019296s ] [ 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.000599s ] --------------------------------------------------------------- [2020-01-08T16:35:10+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004080s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024530s ] [ 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.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018287s ] [ 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.000576s ] --------------------------------------------------------------- [2020-01-08T16:35:20+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007925s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024028s ] [ 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.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017773s ] [ 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.000551s ] --------------------------------------------------------------- [2020-01-08T16:35:30+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006958s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023451s ] [ 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.000658s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019995s ] [ 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.000565s ] --------------------------------------------------------------- [2020-01-08T16:35:40+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000900s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022840s ] [ 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.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019524s ] [ 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.000614s ] --------------------------------------------------------------- [2020-01-08T16:39:00+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010151s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025451s ] [ 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.019619s ] [ 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.000604s ] --------------------------------------------------------------- [2020-01-08T16:39:10+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000799s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030168s ] [ 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.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019142s ] [ 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.000605s ] --------------------------------------------------------------- [2020-01-08T16:42:52+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025333s ] [ 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.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019134s ] [ 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 ] --------------------------------------------------------------- [2020-01-08T16:43:02+08:00] 112.64.68.85 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015582s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023238s ] [ 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.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018084s ] [ 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.000579s ] --------------------------------------------------------------- [2020-01-08T16:45:48+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006085s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029524s ] [ 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_staff_action` [ RunTime:0.018598s ] [ 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.000597s ] --------------------------------------------------------------- [2020-01-08T16:45:58+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003957s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022835s ] [ 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.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017145s ] [ 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.000525s ] --------------------------------------------------------------- [2020-01-08T16:46:17+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011937s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024924s ] [ 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.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017438s ] [ 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.000550s ] --------------------------------------------------------------- [2020-01-08T16:46:27+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004776s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022967s ] [ 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.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017798s ] [ 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.000571s ] --------------------------------------------------------------- [2020-01-08T16:47:07+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009203s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026525s ] [ 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.000669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019566s ] [ 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.000596s ] --------------------------------------------------------------- [2020-01-08T16:47:17+08:00] 101.87.41.133 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.023850s ] [ 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.000647s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018959s ] [ 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.000588s ] --------------------------------------------------------------- [2020-01-08T16:50:10+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014280s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026250s ] [ 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.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021706s ] [ 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.000610s ] --------------------------------------------------------------- [2020-01-08T16:50:20+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001031s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022593s ] [ 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.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017871s ] [ 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.000568s ] --------------------------------------------------------------- [2020-01-08T16:55:24+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014949s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027795s ] [ 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.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018302s ] [ 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.000566s ] --------------------------------------------------------------- [2020-01-08T16:55:33+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012813s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025249s ] [ 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.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018372s ] [ 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.000577s ] --------------------------------------------------------------- [2020-01-08T18:36:38+08:00] 101.87.41.133 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002381s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023802s ] [ 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.000639s ] --------------------------------------------------------------- [2020-01-08T23:50:57+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.000882s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035178s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0118' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '31|478419f5e0ac66df45199b3305252add' , `last_time` = 1578498657 WHERE `id` = 31 [ RunTime:0.003194s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018060s ] [ sql ] [ SQL ] SELECT `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.000576s ] --------------------------------------------------------------- [2020-01-08T23:50:58+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000843s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033959s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000721s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027039s ] [ 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.000685s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035313s ] [ 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.001050s ] [ 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.001351s ] --------------------------------------------------------------- [2020-01-08T23:50:58+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000808s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022243s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000708s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030336s ] [ 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.000533s ] --------------------------------------------------------------- [2020-01-08T23:51:01+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.007659s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023573s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018030s ] [ 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` = 27 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019255s ] [ 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` = 27 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000971s ] --------------------------------------------------------------- [2020-01-08T23:51:03+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002006s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022727s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017136s ] [ 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` = 31 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000704s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.018073s ] [ 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` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000704s ] --------------------------------------------------------------- [2020-01-08T23:51:10+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000883s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036101s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.031074s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 31 AND `status` = 0 [ RunTime:0.000761s ] --------------------------------------------------------------- [2020-01-08T23:51:10+08:00] 180.110.211.109 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.034530s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000703s ] [ 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` = 31 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000856s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.040993s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 31 LIMIT 1 [ RunTime:0.000678s ] --------------------------------------------------------------- [2020-01-08T23:51:10+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000771s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017782s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000754s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.017467s ] [ 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 `staff_id` = 31 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000974s ] --------------------------------------------------------------- [2020-01-08T23:51:13+08:00] 180.110.211.109 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.013635s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023169s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|478419f5e0ac66df45199b3305252add' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.018844s ] [ 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` = 31 AND `d`.`is_delete` = 0 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough` [ RunTime:0.026912s ] [ sql ] [ SQL ] SELECT `dough_staff_id`,`money`,`t`.`name` FROM v_dough d LEFT JOIN `v_dough_type` `t` ON `t`.`id`=`d`.`dough_type_id` WHERE `dough_staff_id` IN (8,9,11,12,13,14) AND `d`.`status` = 0 AND `d`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.000919s ]