--------------------------------------------------------------- [2020-01-17T12:22:03+08:00] 117.136.38.172 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000782s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042711s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '29|aa47bb139fc9a39fc5cbd52e0c02f00b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [2020-01-17T12:22:03+08:00] 117.136.38.172 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.001235s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.088093s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '29|aa47bb139fc9a39fc5cbd52e0c02f00b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [2020-01-17T12:22:03+08:00] 117.136.38.172 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000800s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051078s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '29|aa47bb139fc9a39fc5cbd52e0c02f00b' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] --------------------------------------------------------------- [2020-01-17T16:00:08+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008342s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035390s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000745s ] --------------------------------------------------------------- [2020-01-17T16:00:08+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.008940s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034864s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000779s ] --------------------------------------------------------------- [2020-01-17T16:00:08+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000724s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017616s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '31|834005a8e93b1299ebf1a2900449c437' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000609s ] --------------------------------------------------------------- [2020-01-17T16:00:19+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.002572s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023372s ] [ sql ] [ SQL ] SELECT `name`,`id`,`last_time`,`token` FROM `v_staff` WHERE `job_num` = '0001' AND `password` = 'cd48cc70f2b45da4747a9f18a32648da' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '16|37aa10a24bd9871d60c890a247bc548a' , `last_time` = 1579248019 WHERE `id` = 16 [ RunTime:0.003367s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021571s ] [ sql ] [ SQL ] SELECT `is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [2020-01-17T16:00:19+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.014308s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016766s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] [ 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` = 16 AND `s`.`status` = 0 AND `s`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000724s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.032951s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.000647s ] --------------------------------------------------------------- [2020-01-17T16:00:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.005139s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051748s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000852s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034554s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002318s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.039852s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) [ RunTime:0.002164s ] [ 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 (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001860s ] --------------------------------------------------------------- [2020-01-17T16:00:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.023406s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.058647s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001014s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.048649s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [2020-01-17T16:00:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000954s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.057957s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000676s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025312s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000524s ] --------------------------------------------------------------- [2020-01-17T16:00:25+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004024s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029013s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000788s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.031961s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000682s ] --------------------------------------------------------------- [2020-01-17T16:00:25+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000618s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040442s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032546s ] [ 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` = 29 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000690s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019022s ] [ 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` = 29 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000819s ] --------------------------------------------------------------- [2020-01-17T16:00:27+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.015820s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022448s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020081s ] [ 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` = 52 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001077s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019251s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 52 AND `remind_date` >= '2020-01-17' [ RunTime:0.000567s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.019355s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028437s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017331s ] [ 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` = 52 AND `t`.`type` = 2 [ RunTime:0.000682s ] --------------------------------------------------------------- [2020-01-17T16:00:30+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.004367s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031319s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019387s ] [ 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` = 52 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000915s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.019118s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 52 AND `remind_date` >= '2020-01-17' [ RunTime:0.000591s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.019000s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000555s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028289s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000586s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.026282s ] [ 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` = 52 AND `t`.`type` = 2 [ RunTime:0.000856s ] --------------------------------------------------------------- [2020-01-17T16:00:30+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.006751s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.016543s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018461s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000575s ] --------------------------------------------------------------- [2020-01-17T16:00:35+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003762s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035740s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000818s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.044698s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000740s ] --------------------------------------------------------------- [2020-01-17T16:00:40+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000951s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023594s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018649s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000546s ] --------------------------------------------------------------- [2020-01-17T16:00:50+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010287s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025999s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018374s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-17T16:00:57+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.007374s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023891s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026060s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000775s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029084s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 [ RunTime:0.002052s ] [ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `h`.`id` IN ('1063','1817','1860','1864','1870','1872','1875','1877','1878','1879','1880','1881','1882','1883','1884','1886','1887','1890','1893','1895','1904','1906','5879','5881','5882','5884','5887','5890','5891','5892','5896','5897','5898','5901','5909','5910','19119','19121','19124','19125','19126','19127','19128','19131','19132','19134','19135','19141','19143','19144','19152','19154','19164') AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.001206s ] --------------------------------------------------------------- [2020-01-17T16:01:00+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.024863s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000624s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018920s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000586s ] --------------------------------------------------------------- [2020-01-17T16:01:07+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000742s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023079s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019985s ] [ 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` = 16 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000745s ] --------------------------------------------------------------- [2020-01-17T16:01:10+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000721s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023735s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018444s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000557s ] --------------------------------------------------------------- [2020-01-17T16:01:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000726s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023392s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017511s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [2020-01-17T16:01:21+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/itemInfo [ 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.035026s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000815s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.022049s ] [ 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` = 29 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.001358s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035703s ] [ 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` = 29 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000911s ] --------------------------------------------------------------- [2020-01-17T16:01:22+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010867s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035481s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000773s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033814s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000550s ] --------------------------------------------------------------- [2020-01-17T16:01:26+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/Item/taskInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000758s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022627s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.019298s ] [ 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` = 52 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.020004s ] [ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 52 AND `remind_date` >= '2020-01-17' [ RunTime:0.000557s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.018325s ] [ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000533s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.028708s ] [ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 52 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.017678s ] [ 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` = 52 AND `t`.`type` = 2 [ RunTime:0.000595s ] --------------------------------------------------------------- [2020-01-17T16:01:30+08:00] 117.62.198.153 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.040260s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018779s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000579s ] --------------------------------------------------------------- [2020-01-17T16:01:40+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000733s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023866s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018807s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [2020-01-17T16:01:50+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013831s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025894s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020286s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000575s ] --------------------------------------------------------------- [2020-01-17T16:02:00+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001349s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026741s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000640s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019648s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000608s ] --------------------------------------------------------------- [2020-01-17T16:02:10+08:00] 117.62.198.153 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.022969s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017507s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000548s ] --------------------------------------------------------------- [2020-01-17T16:02:49+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010979s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024013s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000657s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022941s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000582s ] --------------------------------------------------------------- [2020-01-17T16:02:59+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008235s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026042s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023198s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000579s ] --------------------------------------------------------------- [2020-01-17T16:03:09+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024224s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022941s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000749s ] --------------------------------------------------------------- [2020-01-17T16:03:19+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.024354s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021259s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-17T16:03:29+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012687s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024508s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017706s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] --------------------------------------------------------------- [2020-01-17T16:03:39+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007041s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023312s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017477s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000528s ] --------------------------------------------------------------- [2020-01-17T16:03:49+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000731s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024806s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018083s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000550s ] --------------------------------------------------------------- [2020-01-17T16:03:59+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025077s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018556s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000579s ] --------------------------------------------------------------- [2020-01-17T16:04:09+08:00] 117.62.198.153 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.023643s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017839s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000511s ] --------------------------------------------------------------- [2020-01-17T16:04:19+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000735s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023759s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020240s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] --------------------------------------------------------------- [2020-01-17T16:07:00+08:00] 117.62.198.153 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.025038s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020009s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000669s ] --------------------------------------------------------------- [2020-01-17T16:07:10+08:00] 117.62.198.153 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.023458s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020445s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000529s ] --------------------------------------------------------------- [2020-01-17T16:07:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001750s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034848s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018926s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] --------------------------------------------------------------- [2020-01-17T16:07:30+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005173s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023651s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017942s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000520s ] --------------------------------------------------------------- [2020-01-17T16:07:40+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009294s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023432s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017983s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [2020-01-17T16:07:50+08:00] 117.62.198.153 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.024353s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035112s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000565s ] --------------------------------------------------------------- [2020-01-17T16:08:00+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012366s ] 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` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019016s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000667s ] --------------------------------------------------------------- [2020-01-17T16:08:10+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000723s ] 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` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000674s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017426s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-17T16:08:20+08:00] 117.62.198.153 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.023569s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018036s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [2020-01-17T16:08:30+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000855s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023326s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026019s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000675s ] --------------------------------------------------------------- [2020-01-17T16:08:54+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026263s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019852s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] --------------------------------------------------------------- [2020-01-17T16:09:04+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000806s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026136s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018891s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000589s ] --------------------------------------------------------------- [2020-01-17T16:09:14+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008123s ] 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` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018778s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] --------------------------------------------------------------- [2020-01-17T16:09:24+08:00] 117.62.198.153 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.023261s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000631s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027067s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [2020-01-17T16:12:29+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009620s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026659s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030244s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000785s ] --------------------------------------------------------------- [2020-01-17T16:14:02+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000826s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025957s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000662s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023396s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000693s ] --------------------------------------------------------------- [2020-01-17T16:14:12+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.023064s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018000s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [2020-01-17T16:14:22+08:00] 117.62.198.153 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.023658s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018510s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000539s ] --------------------------------------------------------------- [2020-01-17T16:14:32+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000780s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026175s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019383s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] --------------------------------------------------------------- [2020-01-17T16:14:42+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000785s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024460s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018416s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000558s ] --------------------------------------------------------------- [2020-01-17T16:15:23+08:00] 117.62.198.153 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.025164s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019951s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000584s ] --------------------------------------------------------------- [2020-01-17T16:15:40+08:00] 117.62.198.153 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.024177s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000612s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017610s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000515s ] --------------------------------------------------------------- [2020-01-17T16:15:50+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000780s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027040s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018773s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000727s ] --------------------------------------------------------------- [2020-01-17T16:16:00+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.024756s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019750s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000712s ] --------------------------------------------------------------- [2020-01-17T16:16:10+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030353s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020037s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [2020-01-17T16:16:20+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002004s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033990s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018303s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000555s ] --------------------------------------------------------------- [2020-01-17T16:16:30+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013629s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024377s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021493s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-17T16:16:40+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025589s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000663s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019408s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [2020-01-17T16:16:50+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010479s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024269s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018860s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000594s ] --------------------------------------------------------------- [2020-01-17T16:17:00+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004693s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025877s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000636s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019039s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000563s ] --------------------------------------------------------------- [2020-01-17T16:17:26+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023583s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000841s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020460s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000562s ] --------------------------------------------------------------- [2020-01-17T16:17:36+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005895s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024159s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017511s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000516s ] --------------------------------------------------------------- [2020-01-17T16:17:46+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000781s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024024s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019654s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000591s ] --------------------------------------------------------------- [2020-01-17T16:17:56+08:00] 117.62.198.153 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.044930s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000643s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019455s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000619s ] --------------------------------------------------------------- [2020-01-17T16:18:06+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001969s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024334s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ 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` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-17T16:18:16+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015482s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023487s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018612s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] --------------------------------------------------------------- [2020-01-17T16:18:56+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001383s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023799s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019003s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000577s ] --------------------------------------------------------------- [2020-01-17T16:19:06+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000743s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025229s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018740s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] --------------------------------------------------------------- [2020-01-17T16:19:16+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001636s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024735s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021543s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] --------------------------------------------------------------- [2020-01-17T16:19:26+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000814s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025188s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018874s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000566s ] --------------------------------------------------------------- [2020-01-17T16:19:44+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000798s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025426s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020595s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-17T16:19:58+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000756s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026453s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018454s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-17T16:20:08+08:00] 117.62.198.153 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.028359s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023067s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000666s ] --------------------------------------------------------------- [2020-01-17T16:20:18+08:00] 117.62.198.153 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.023875s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023528s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000591s ] --------------------------------------------------------------- [2020-01-17T16:20:28+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009327s ] 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` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000645s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017999s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000756s ] --------------------------------------------------------------- [2020-01-17T16:21:32+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000781s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025537s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018975s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000651s ] --------------------------------------------------------------- [2020-01-17T16:21:42+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000749s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026150s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000672s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019090s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000582s ] --------------------------------------------------------------- [2020-01-17T16:21:52+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008926s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024458s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000646s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018974s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-17T16:22:02+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025796s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018596s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000575s ] --------------------------------------------------------------- [2020-01-17T16:22:12+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.025631s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018359s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000642s ] --------------------------------------------------------------- [2020-01-17T16:22:22+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000758s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023557s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017339s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000531s ] --------------------------------------------------------------- [2020-01-17T16:22:32+08:00] 117.62.198.153 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.029314s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018729s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000563s ] --------------------------------------------------------------- [2020-01-17T16:22:42+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004103s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024101s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000653s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019589s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000589s ] --------------------------------------------------------------- [2020-01-17T16:22:52+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004104s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023469s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018273s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000565s ] --------------------------------------------------------------- [2020-01-17T16:23:02+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.028808s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000691s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019988s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000684s ] --------------------------------------------------------------- [2020-01-17T16:23:12+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000839s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024443s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017963s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000535s ] --------------------------------------------------------------- [2020-01-17T16:23:22+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009209s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024248s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000649s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018843s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] --------------------------------------------------------------- [2020-01-17T16:23:32+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.023182s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000592s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018088s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000540s ] --------------------------------------------------------------- [2020-01-17T16:23:42+08:00] 117.62.198.153 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.036880s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018652s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [2020-01-17T16:23:52+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000798s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030229s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018869s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000767s ] --------------------------------------------------------------- [2020-01-17T16:24:35+08:00] 117.62.198.153 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.024838s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017778s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000536s ] --------------------------------------------------------------- [2020-01-17T16:25:46+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009158s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026378s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020097s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] --------------------------------------------------------------- [2020-01-17T16:25:56+08:00] 117.62.198.153 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.023475s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017898s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000563s ] --------------------------------------------------------------- [2020-01-17T16:26:06+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012201s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026628s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018552s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000556s ] --------------------------------------------------------------- [2020-01-17T16:26:17+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000782s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027217s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019013s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-17T16:27:58+08:00] 117.62.198.153 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.025467s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000635s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018585s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000593s ] --------------------------------------------------------------- [2020-01-17T16:28:22+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012643s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023542s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018492s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000659s ] --------------------------------------------------------------- [2020-01-17T16:28:32+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.009821s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023790s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018461s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000696s ] --------------------------------------------------------------- [2020-01-17T16:28:42+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015267s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024010s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000603s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018420s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000571s ] --------------------------------------------------------------- [2020-01-17T16:29:59+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005091s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025237s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000618s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018396s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000547s ] --------------------------------------------------------------- [2020-01-17T16:30:37+08:00] 117.62.198.153 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.022952s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020017s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000509s ] --------------------------------------------------------------- [2020-01-17T16:32:57+08:00] 117.62.198.153 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.024956s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040523s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] --------------------------------------------------------------- [2020-01-17T16:33:07+08:00] 117.62.198.153 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.024510s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000628s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018137s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000556s ] --------------------------------------------------------------- [2020-01-17T16:33:17+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014973s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023746s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000604s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017939s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000576s ] --------------------------------------------------------------- [2020-01-17T16:33:27+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000785s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023856s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018480s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000570s ] --------------------------------------------------------------- [2020-01-17T16:43:02+08:00] 117.62.198.153 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.025428s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000627s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018263s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000555s ] --------------------------------------------------------------- [2020-01-17T16:43:08+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.002866s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026193s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000609s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020190s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000562s ] --------------------------------------------------------------- [2020-01-17T16:43:12+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008794s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023040s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000607s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017406s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000541s ] --------------------------------------------------------------- [2020-01-17T16:43:22+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014091s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024446s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019047s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] --------------------------------------------------------------- [2020-01-17T16:43:32+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.029970s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000584s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017626s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000523s ] --------------------------------------------------------------- [2020-01-17T16:43:42+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000785s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024310s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020519s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] --------------------------------------------------------------- [2020-01-17T16:43:53+08:00] 117.62.198.153 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.023240s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022987s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] --------------------------------------------------------------- [2020-01-17T16:44:03+08:00] 117.62.198.153 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.027300s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000637s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019982s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000602s ] --------------------------------------------------------------- [2020-01-17T16:44:13+08:00] 117.62.198.153 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.023174s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017534s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000534s ] --------------------------------------------------------------- [2020-01-17T16:44:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000751s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027073s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018090s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000529s ] --------------------------------------------------------------- [2020-01-17T16:44:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000768s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024904s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019528s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000560s ] --------------------------------------------------------------- [2020-01-17T16:44:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007760s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023510s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020481s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000551s ] --------------------------------------------------------------- [2020-01-17T16:44:53+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004989s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023832s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000605s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018059s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000539s ] --------------------------------------------------------------- [2020-01-17T16:45:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.015642s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025231s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018723s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-17T16:45:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.004629s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023467s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000620s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017885s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000535s ] --------------------------------------------------------------- [2020-01-17T16:45:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000779s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023464s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000606s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017890s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [2020-01-17T16:45:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010852s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023694s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018871s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000582s ] --------------------------------------------------------------- [2020-01-17T16:45:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011527s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023781s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018981s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000604s ] --------------------------------------------------------------- [2020-01-17T16:45:53+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003302s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023702s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000660s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019392s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000581s ] --------------------------------------------------------------- [2020-01-17T16:46:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000746s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026340s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000623s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019216s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-17T16:46:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.027271s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000694s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020815s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000633s ] --------------------------------------------------------------- [2020-01-17T16:46:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.012154s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026135s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033535s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000584s ] --------------------------------------------------------------- [2020-01-17T16:46:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003320s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026278s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000641s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021681s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000612s ] --------------------------------------------------------------- [2020-01-17T16:46:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000735s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027680s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018753s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000569s ] --------------------------------------------------------------- [2020-01-17T16:46:53+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000761s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023999s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019277s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000578s ] --------------------------------------------------------------- [2020-01-17T16:47:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013074s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026876s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000670s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019319s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000567s ] --------------------------------------------------------------- [2020-01-17T16:47:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000779s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025984s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000642s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029181s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [2020-01-17T16:47:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008411s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025471s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.034741s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000540s ] --------------------------------------------------------------- [2020-01-17T16:47:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ 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.022993s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017731s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000527s ] --------------------------------------------------------------- [2020-01-17T16:47:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013615s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029186s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000950s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019260s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000600s ] --------------------------------------------------------------- [2020-01-17T16:47:53+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001860s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025416s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018090s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-17T16:48:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.011947s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028200s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000655s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019015s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000587s ] --------------------------------------------------------------- [2020-01-17T16:48:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000791s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024818s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000632s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019397s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] --------------------------------------------------------------- [2020-01-17T16:48:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005698s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027659s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000625s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019177s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000574s ] --------------------------------------------------------------- [2020-01-17T16:48:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.001462s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024144s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000622s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019349s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000545s ] --------------------------------------------------------------- [2020-01-17T16:48:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000753s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026949s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001113s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017737s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000528s ] --------------------------------------------------------------- [2020-01-17T16:48:54+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000741s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023286s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017667s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000538s ] --------------------------------------------------------------- [2020-01-17T16:49:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007825s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034784s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000700s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019656s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000581s ] --------------------------------------------------------------- [2020-01-17T16:49:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000761s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024452s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000651s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018433s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000543s ] --------------------------------------------------------------- [2020-01-17T16:49:23+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.008864s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023386s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000595s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017546s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000554s ] --------------------------------------------------------------- [2020-01-17T16:49:33+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.003427s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028098s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000619s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019351s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000575s ] --------------------------------------------------------------- [2020-01-17T16:49:43+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000719s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022801s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000616s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020969s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000589s ] --------------------------------------------------------------- [2020-01-17T16:49:53+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000728s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024421s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000638s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018264s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000559s ] --------------------------------------------------------------- [2020-01-17T16:50:03+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010873s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025615s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000613s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018810s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] --------------------------------------------------------------- [2020-01-17T16:50:14+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000746s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023913s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000614s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017610s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000545s ] --------------------------------------------------------------- [2020-01-17T16:50:24+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000789s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035316s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000621s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018765s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] --------------------------------------------------------------- [2020-01-17T16:50:34+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.000748s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023097s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000599s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.017813s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000533s ] --------------------------------------------------------------- [2020-01-17T16:50:44+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007848s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023372s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000629s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018641s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000568s ] --------------------------------------------------------------- [2020-01-17T16:50:54+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.014194s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023200s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018296s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ] --------------------------------------------------------------- [2020-01-17T16:51:38+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.010844s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024884s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021019s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000537s ] --------------------------------------------------------------- [2020-01-17T16:52:13+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013085s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035701s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000656s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.020411s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000634s ] --------------------------------------------------------------- [2020-01-17T16:52:38+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005921s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025582s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019361s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000585s ] --------------------------------------------------------------- [2020-01-17T16:53:08+08:00] 117.62.198.153 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.024878s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019417s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000578s ] --------------------------------------------------------------- [2020-01-17T16:53:38+08:00] 117.62.198.153 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.013084s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024804s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|37aa10a24bd9871d60c890a247bc548a' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019539s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000552s ]