---------------------------------------------------------------
[2019-12-12T14:50:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007788s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027938s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|ebabb1caeac91d5c705f0938ae749b7e' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005096s ]
---------------------------------------------------------------
[2019-12-12T14:52:22+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Login/staffLogin
[ sql ] [ DB ] CONNECT:[ UseTime:0.021083s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030569s ]
[ 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.006813s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024562s ]
[ 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.006702s ]
---------------------------------------------------------------
[2019-12-12T14:52:22+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.005455s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031430s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003869s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028952s ]
[ 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.003733s ]
---------------------------------------------------------------
[2019-12-12T14:52:22+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.036019s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050592s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005546s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039591s ]
[ 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.005589s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.036221s ]
[ 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.009155s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.006817s ]
---------------------------------------------------------------
[2019-12-12T14:52:23+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.010664s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051154s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.008256s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.060994s ]
[ 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.007069s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031122s ]
[ 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.008380s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.008151s ]
---------------------------------------------------------------
[2019-12-12T14:52:23+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.008373s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020261s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004993s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030172s ]
[ 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.005132s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026635s ]
[ 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.005836s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.006195s ]
---------------------------------------------------------------
[2019-12-12T14:52:37+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.003811s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027604s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002640s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018984s ]
[ 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` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002657s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020268s ]
[ 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` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.002767s ]
---------------------------------------------------------------
[2019-12-12T14:52:37+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.011725s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023220s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007903s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.028579s ]
[ 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.008018s ]
---------------------------------------------------------------
[2019-12-12T14:52:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007574s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025841s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005081s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.023044s ]
[ 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` = 5 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005572s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.022541s ]
[ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 5 AND `remind_date` >= '2019-12-12' [ RunTime:0.004970s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.022566s ]
[ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 5 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004936s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.039598s ]
[ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 5 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005063s ]
[ sql ] [ SQL ] UPDATE `v_task` SET `status` = 4 WHERE `id` = 5 [ RunTime:0.004896s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028262s ]
[ sql ] [ SQL ] UPDATE `v_staff_total` SET `overdue_task_num` = `overdue_task_num` + 1 WHERE `staff_id` = 16 [ RunTime:0.004914s ]
[ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 18 LIMIT 1 [ RunTime:0.004826s ]
[ sql ] [ SQL ] SELECT `job_num` FROM `v_staff` WHERE `id` = 16 LIMIT 1 [ RunTime:0.004841s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.022334s ]
[ 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` = 5 AND `t`.`type` = 2 [ RunTime:0.005069s ]
---------------------------------------------------------------
[2019-12-12T14:52:48+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007781s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026749s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005291s ]
[ 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.005473s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029408s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005217s ]
---------------------------------------------------------------
[2019-12-12T14:52:55+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007664s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029821s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005215s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.029590s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005082s ]
---------------------------------------------------------------
[2019-12-12T14:52:55+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009906s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032527s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006363s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.034827s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006277s ]
---------------------------------------------------------------
[2019-12-12T14:53:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005781s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031820s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003941s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025489s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004163s ]
---------------------------------------------------------------
[2019-12-12T14:53:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005188s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044601s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003771s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.034418s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.003943s ]
---------------------------------------------------------------
[2019-12-12T14:53:20+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005538s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034392s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004019s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.027597s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004029s ]
---------------------------------------------------------------
[2019-12-12T14:53:20+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007510s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050927s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005050s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.050570s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005083s ]
---------------------------------------------------------------
[2019-12-12T14:53:27+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.011126s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029883s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007495s ]
[ 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.007437s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.031741s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.007484s ]
---------------------------------------------------------------
[2019-12-12T14:53:28+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.006803s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030604s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005102s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.024588s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004627s ]
---------------------------------------------------------------
[2019-12-12T14:53:28+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.008427s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020851s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005690s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.023415s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005705s ]
---------------------------------------------------------------
[2019-12-12T14:53:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.009288s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031729s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006942s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.028145s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.006573s ]
---------------------------------------------------------------
[2019-12-12T14:53:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.009207s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032544s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006445s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.043896s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.006598s ]
---------------------------------------------------------------
[2019-12-12T14:58:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateItem
[ sql ] [ DB ] CONNECT:[ UseTime:0.008767s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033239s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004409s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024381s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 16 AND `i`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.004471s ]
---------------------------------------------------------------
[2019-12-12T14:58:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateItem
[ sql ] [ DB ] CONNECT:[ UseTime:0.007982s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041183s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005475s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.032587s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 16 AND `i`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.005597s ]
---------------------------------------------------------------
[2019-12-12T14:58:20+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005496s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032020s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003868s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.027648s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.003936s ]
---------------------------------------------------------------
[2019-12-12T14:58:20+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.009562s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040823s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006607s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.038794s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.006792s ]
---------------------------------------------------------------
[2019-12-12T14:58:28+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.003757s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027611s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002701s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.032824s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.002505s ]
---------------------------------------------------------------
[2019-12-12T14:58:28+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.008066s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027283s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005544s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.030254s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005535s ]
---------------------------------------------------------------
[2019-12-12T15:02:48+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.019469s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033100s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004868s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.028788s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004709s ]
---------------------------------------------------------------
[2019-12-12T15:02:48+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.011298s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044902s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007694s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.036009s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.007711s ]
---------------------------------------------------------------
[2019-12-12T15:04:05+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.016015s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025550s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003216s ]
[ 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.003234s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.025423s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003205s ]
---------------------------------------------------------------
[2019-12-12T15:04:05+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007075s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019355s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004765s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.024538s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004865s ]
---------------------------------------------------------------
[2019-12-12T15:04:05+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009382s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021569s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006346s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.038638s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006409s ]
---------------------------------------------------------------
[2019-12-12T15:04:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.005761s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028726s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004000s ]
[ 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.003998s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.029682s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.003934s ]
---------------------------------------------------------------
[2019-12-12T15:04:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005010s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024243s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003543s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.031563s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003472s ]
---------------------------------------------------------------
[2019-12-12T15:04:16+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.008333s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020896s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005076s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021066s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005026s ]
---------------------------------------------------------------
[2019-12-12T15:04:42+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.007231s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059827s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004985s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.068309s ]
[ 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.005022s ]
---------------------------------------------------------------
[2019-12-12T15:04:42+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.014836s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043407s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004878s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050488s ]
[ 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.004598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.052529s ]
[ 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.006097s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.007440s ]
---------------------------------------------------------------
[2019-12-12T15:04:42+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.006906s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059107s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003825s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043006s ]
[ 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.003663s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017853s ]
[ 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.004470s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.004853s ]
---------------------------------------------------------------
[2019-12-12T15:04:50+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009539s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033605s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.031696s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006390s ]
---------------------------------------------------------------
[2019-12-12T15:04:50+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009902s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027851s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006682s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.037205s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006567s ]
---------------------------------------------------------------
[2019-12-12T15:05:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007238s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028555s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004976s ]
[ 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.004868s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028106s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004871s ]
---------------------------------------------------------------
[2019-12-12T15:05:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009834s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030751s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006565s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.026713s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006628s ]
---------------------------------------------------------------
[2019-12-12T15:05:50+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.009461s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033510s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006386s ]
[ 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.006329s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030344s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006439s ]
---------------------------------------------------------------
[2019-12-12T15:05:50+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.011360s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022990s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007641s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.027672s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.007681s ]
---------------------------------------------------------------
[2019-12-12T15:05:58+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.009765s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032028s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006610s ]
[ 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.006618s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030965s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006623s ]
---------------------------------------------------------------
[2019-12-12T15:05:58+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.012127s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029941s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.008306s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.034312s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.008263s ]
---------------------------------------------------------------
[2019-12-12T15:05:58+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007578s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025105s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005178s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.022324s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005115s ]
---------------------------------------------------------------
[2019-12-12T15:07:19+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.018031s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037770s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003695s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026428s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004130s ]
---------------------------------------------------------------
[2019-12-12T15:07:19+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005296s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043640s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003719s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.037937s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.003935s ]
---------------------------------------------------------------
[2019-12-12T15:07:31+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.006663s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032450s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004477s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.027147s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004404s ]
---------------------------------------------------------------
[2019-12-12T15:07:31+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007499s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041566s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005419s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.034963s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005246s ]
---------------------------------------------------------------
[2019-12-12T15:07:46+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006486s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026857s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004320s ]
[ 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.004275s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028100s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004309s ]
---------------------------------------------------------------
[2019-12-12T15:07:46+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.011495s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022934s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007739s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.037527s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.007786s ]
---------------------------------------------------------------
[2019-12-12T15:07:46+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007381s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020083s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005080s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021575s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005030s ]
---------------------------------------------------------------
[2019-12-12T15:09:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.010804s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035446s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005259s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.028485s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005113s ]
---------------------------------------------------------------
[2019-12-12T15:09:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.008044s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043273s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006060s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.038323s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005405s ]
---------------------------------------------------------------
[2019-12-12T15:10:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006922s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027930s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004645s ]
[ 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.004638s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027374s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004628s ]
---------------------------------------------------------------
[2019-12-12T15:10:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005948s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020317s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003984s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.025416s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004043s ]
---------------------------------------------------------------
[2019-12-12T15:10:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.009483s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028893s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006377s ]
[ 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.006400s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030923s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.006456s ]
---------------------------------------------------------------
[2019-12-12T15:10:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007334s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.072045s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004993s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.023943s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004914s ]
---------------------------------------------------------------
[2019-12-12T15:11:19+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.010653s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041290s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006949s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.037880s ]
[ 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.006965s ]
---------------------------------------------------------------
[2019-12-12T15:11:19+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.007614s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039422s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005238s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.049289s ]
[ 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.005131s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.046306s ]
[ 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.006574s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.006411s ]
---------------------------------------------------------------
[2019-12-12T15:11:20+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.007657s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040795s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005307s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041902s ]
[ 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.005223s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.055363s ]
[ 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.005967s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006334s ]
---------------------------------------------------------------
[2019-12-12T15:11:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.008492s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.061832s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005243s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046137s ]
[ 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.005329s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.045362s ]
[ 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.006606s ]
[ 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.006248s ]
---------------------------------------------------------------
[2019-12-12T15:11:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.005540s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.047883s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003855s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041801s ]
[ 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.003772s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.037924s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.004806s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.053502s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003791s ]
---------------------------------------------------------------
[2019-12-12T15:11:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.005258s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040837s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003579s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043211s ]
[ 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.003882s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.052184s ]
[ 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.004200s ]
[ 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 20,20 [ RunTime:0.004587s ]
---------------------------------------------------------------
[2019-12-12T15:11:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.006267s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035296s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004442s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026915s ]
[ 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 `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.005039s ]
---------------------------------------------------------------
[2019-12-12T15:11:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005927s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049172s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004110s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.046153s ]
[ 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 `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.004422s ]
---------------------------------------------------------------
[2019-12-12T15:11:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005657s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032083s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004081s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.028743s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004094s ]
---------------------------------------------------------------
[2019-12-12T15:11:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009312s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044832s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.035929s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006313s ]
---------------------------------------------------------------
[2019-12-12T15:11:58+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005766s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034375s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003999s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024664s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004304s ]
---------------------------------------------------------------
[2019-12-12T15:11:59+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005021s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045349s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003529s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.038784s ]
[ 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 `create_staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.003847s ]
---------------------------------------------------------------
[2019-12-12T15:12:02+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateItem
[ sql ] [ DB ] CONNECT:[ UseTime:0.009889s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036155s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006689s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.029661s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 16 AND `i`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.006831s ]
---------------------------------------------------------------
[2019-12-12T15:12:02+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateItem
[ sql ] [ DB ] CONNECT:[ UseTime:0.009161s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033243s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006293s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.035714s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 16 AND `i`.`is_delete` = 0 LIMIT 20,20 [ RunTime:0.006296s ]
---------------------------------------------------------------
[2019-12-12T15:13:29+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.004896s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027663s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '4|cb94b90ed4416c0dad7fc7a9cdb14c36' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003413s ]
---------------------------------------------------------------
[2019-12-12T15:13:43+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005939s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024923s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004022s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021958s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003983s ]
---------------------------------------------------------------
[2019-12-12T15:13:48+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007051s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026860s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005055s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.023836s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.004616s ]
---------------------------------------------------------------
[2019-12-12T15:13:53+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005073s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024699s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003385s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.021561s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003339s ]
---------------------------------------------------------------
[2019-12-12T15:14:28+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006654s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027939s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004508s ]
[ 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.004670s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.028190s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004608s ]
---------------------------------------------------------------
[2019-12-12T15:14:29+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myCreateItem
[ sql ] [ DB ] CONNECT:[ UseTime:0.003698s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024102s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002545s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019495s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `staff_id` = 16 AND `i`.`is_delete` = 0 LIMIT 0,20 [ RunTime:0.002666s ]
---------------------------------------------------------------
[2019-12-12T15:14:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007415s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028255s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005015s ]
[ 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.005081s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.030258s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.005029s ]
---------------------------------------------------------------
[2019-12-12T15:14:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009493s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027441s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006506s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.035963s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006450s ]
---------------------------------------------------------------
[2019-12-12T15:14:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005224s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.020804s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003566s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.019585s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003532s ]
---------------------------------------------------------------
[2019-12-12T15:15:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006755s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027867s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004600s ]
[ 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.004471s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.027918s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.004536s ]
---------------------------------------------------------------
[2019-12-12T15:15:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.009021s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.021317s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006044s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.037492s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.006206s ]
---------------------------------------------------------------
[2019-12-12T15:15:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.003461s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017280s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002459s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.018530s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.002461s ]
---------------------------------------------------------------
[2019-12-12T15:18:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Login/staffLogin
[ sql ] [ DB ] CONNECT:[ UseTime:0.009272s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033104s ]
[ 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.006257s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023461s ]
[ 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.006240s ]
---------------------------------------------------------------
[2019-12-12T15:18:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.010105s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033762s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006919s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.061842s ]
[ 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.006886s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.049519s ]
[ 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.008230s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.010724s ]
---------------------------------------------------------------
[2019-12-12T15:18:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.009903s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056522s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007153s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043027s ]
[ 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.006670s ]
---------------------------------------------------------------
[2019-12-12T15:18:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.008567s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.058195s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006187s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036989s ]
[ 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.005788s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023574s ]
[ 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.006673s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006915s ]
---------------------------------------------------------------
[2019-12-12T15:18:52+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.005044s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030077s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003711s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.026651s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.003637s ]
---------------------------------------------------------------
[2019-12-12T15:18:52+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myDough
[ sql ] [ DB ] CONNECT:[ UseTime:0.007955s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045620s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005184s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.035034s ]
[ sql ] [ SQL ] SELECT `d`.`id`,`d`.`status`,`d`.`money`,`d`.`is_submit`,`t`.`name`,`task_id` FROM v_dough_staff d LEFT JOIN `v_task` `t` ON `t`.`id`=`d`.`task_id` WHERE `d`.`staff_id` = 16 AND `d`.`is_delete` = 0 [ RunTime:0.005118s ]
---------------------------------------------------------------
[2019-12-12T15:19:00+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.008426s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.055539s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005736s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.042684s ]
[ 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.005970s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.039591s ]
[ 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.006835s ]
[ 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.006265s ]
---------------------------------------------------------------
[2019-12-12T15:19:00+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.003508s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.045238s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002500s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.033384s ]
[ 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.002611s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.053790s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.003474s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.056204s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.002640s ]
---------------------------------------------------------------
[2019-12-12T15:19:00+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.007411s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050048s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005137s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.055125s ]
[ 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.005039s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023373s ]
[ 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.005941s ]
[ 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 20,20 [ RunTime:0.006093s ]
---------------------------------------------------------------
[2019-12-12T15:19:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.005651s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.058175s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004286s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.029076s ]
[ 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 `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.004170s ]
---------------------------------------------------------------
[2019-12-12T15:19:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.007615s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.069695s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005539s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035921s ]
[ 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 `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.005644s ]
---------------------------------------------------------------
[2019-12-12T15:19:02+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.034341s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.037394s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004091s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.044516s ]
[ 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.003945s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.040913s ]
[ 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.005529s ]
[ 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.004959s ]
---------------------------------------------------------------
[2019-12-12T15:19:02+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.006470s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.059370s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004705s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.048176s ]
[ 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.005250s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.047832s ]
[ 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.006429s ]
[ 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 20,20 [ RunTime:0.005510s ]
---------------------------------------------------------------
[2019-12-12T15:19:02+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.005636s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049119s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003914s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.046233s ]
[ 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.003957s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.047437s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.006157s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.040045s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003786s ]
---------------------------------------------------------------
[2019-12-12T15:19:04+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.008922s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042728s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006195s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.032029s ]
[ 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.006203s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.023078s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 47 AND `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.007474s ]
[ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 47 AND `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.007338s ]
---------------------------------------------------------------
[2019-12-12T15:19:04+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/cityInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006060s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032014s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004234s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026054s ]
[ 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.004160s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.029513s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.004963s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.037994s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (21,51,321) AND `parent_id` = 47 AND `level` = 1 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004021s ]
---------------------------------------------------------------
[2019-12-12T15:19:06+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.010082s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035364s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006786s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.026755s ]
[ 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.006753s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.026212s ]
[ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 47 AND `city_id` = 51 AND `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.007521s ]
[ sql ] [ SQL ] SELECT `h`.`id`,`h`.`name`,`h`.`addess`,`h`.`phone`,g.name as grade_name FROM v_hospital h LEFT JOIN `v_hospital_grade` `g` ON `g`.`id`=`grade_id` WHERE `province_id` = 47 AND `city_id` = 51 AND `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.007934s ]
---------------------------------------------------------------
[2019-12-12T15:19:10+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.004947s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027401s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003390s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039689s ]
[ 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.003416s ]
---------------------------------------------------------------
[2019-12-12T15:19:10+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.009896s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048346s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006674s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.077903s ]
[ 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.006990s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.077734s ]
[ 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.020872s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.007802s ]
---------------------------------------------------------------
[2019-12-12T15:19:10+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.011978s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022958s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007903s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.022830s ]
[ 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.007902s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.022625s ]
[ 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.008685s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.009036s ]
---------------------------------------------------------------
[2019-12-12T15:19:11+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.009715s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029849s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006625s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023251s ]
[ 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` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006676s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035756s ]
[ 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` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.006716s ]
---------------------------------------------------------------
[2019-12-12T15:19:12+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.007975s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028509s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005412s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.023121s ]
[ 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.005410s ]
---------------------------------------------------------------
[2019-12-12T15:19:26+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.012132s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039715s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003386s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050387s ]
[ 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.003493s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.037344s ]
[ 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.004892s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006850s ]
---------------------------------------------------------------
[2019-12-12T15:19:26+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.007202s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.055275s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004686s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.050427s ]
[ 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.004570s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.064883s ]
[ 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.007872s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.005583s ]
---------------------------------------------------------------
[2019-12-12T15:19:26+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.014001s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.076673s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005695s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.067869s ]
[ 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.005284s ]
---------------------------------------------------------------
[2019-12-12T15:19:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.020106s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.051918s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006451s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.055739s ]
[ 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.006613s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.040907s ]
[ 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.007561s ]
[ 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.007466s ]
---------------------------------------------------------------
[2019-12-12T15:19:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.009718s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.050517s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006316s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038607s ]
[ 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.006261s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.042259s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.007959s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.049450s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.006116s ]
---------------------------------------------------------------
[2019-12-12T15:19:38+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.009145s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056899s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004860s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.045621s ]
[ 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.005160s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.048376s ]
[ 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.005358s ]
[ 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 20,20 [ RunTime:0.005809s ]
---------------------------------------------------------------
[2019-12-12T15:19:40+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.018478s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048277s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005605s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.045278s ]
[ 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.005709s ]
---------------------------------------------------------------
[2019-12-12T15:19:40+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.009375s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.036740s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005023s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038193s ]
[ 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.003933s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.058162s ]
[ 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.004985s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.004781s ]
---------------------------------------------------------------
[2019-12-12T15:19:40+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.010053s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.044534s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005471s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.059801s ]
[ 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.004964s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020282s ]
[ 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.006323s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006252s ]
---------------------------------------------------------------
[2019-12-12T15:19:40+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.005482s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.029171s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003749s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019160s ]
[ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003777s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.018046s ]
[ 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.004839s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.004830s ]
---------------------------------------------------------------
[2019-12-12T15:19:41+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.008768s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028888s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005931s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023058s ]
[ 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` = 2 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.006039s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.024109s ]
[ 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` = 2 AND `t`.`is_delete` = 0 [ RunTime:0.006313s ]
---------------------------------------------------------------
[2019-12-12T15:19:41+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.005379s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019220s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003626s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.019724s ]
[ 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.003608s ]
---------------------------------------------------------------
[2019-12-12T15:19:44+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006940s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.035574s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004796s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.022052s ]
[ 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` = 2 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.005200s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.032185s ]
[ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 2 AND `remind_date` >= '2019-12-12' [ RunTime:0.004761s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.021627s ]
[ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 2 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004601s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030302s ]
[ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 2 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004602s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020298s ]
[ 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` = 2 AND `t`.`type` = 2 [ RunTime:0.004651s ]
---------------------------------------------------------------
[2019-12-12T15:19:47+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.010913s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049522s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005000s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.074275s ]
[ 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.005069s ]
---------------------------------------------------------------
[2019-12-12T15:19:47+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.025085s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042739s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005166s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041184s ]
[ 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.005078s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.058884s ]
[ 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.006336s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.009692s ]
---------------------------------------------------------------
[2019-12-12T15:19:47+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.006708s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.056723s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004777s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.064220s ]
[ 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.010064s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.071836s ]
[ 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.005125s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.005009s ]
---------------------------------------------------------------
[2019-12-12T15:19:47+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.013174s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.060987s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004176s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.025190s ]
[ 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.004079s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.028097s ]
[ 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.005613s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.005273s ]
---------------------------------------------------------------
[2019-12-12T15:19:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.016768s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.039727s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002498s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.039232s ]
[ 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.002394s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.041513s ]
[ 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.003339s ]
[ 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.003399s ]
---------------------------------------------------------------
[2019-12-12T15:19:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/myHospital
[ sql ] [ DB ] CONNECT:[ UseTime:0.014972s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048225s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004879s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.051940s ]
[ 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.004658s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.024329s ]
[ 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.005632s ]
[ 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 20,20 [ RunTime:0.005862s ]
---------------------------------------------------------------
[2019-12-12T15:19:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/provinceInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.007757s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048537s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005045s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.053815s ]
[ 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.005118s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.050200s ]
[ sql ] [ SQL ] SELECT `province_id`,`city_id` FROM `v_hospital` WHERE `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 `status` = 0 AND `is_delete` = 0 [ RunTime:0.005865s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.031153s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_city` WHERE `id` IN (20,47,320) AND `level` = 0 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.005063s ]
---------------------------------------------------------------
[2019-12-12T15:19:57+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.008814s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028382s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005998s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.041637s ]
[ 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.005974s ]
---------------------------------------------------------------
[2019-12-12T15:19:57+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Hospital/hospitalInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.012919s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041380s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.008179s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.037140s ]
[ 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` = 1063 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.008160s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.026867s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `hospital_id` = 1063 AND `i`.`is_delete` = 0 [ RunTime:0.008247s ]
---------------------------------------------------------------
[2019-12-12T15:20:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.009658s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034754s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006485s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026553s ]
[ 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 `id` DESC,`t`.`status` LIMIT 0,20 [ RunTime:0.006982s ]
---------------------------------------------------------------
[2019-12-12T15:20:01+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myTask
[ sql ] [ DB ] CONNECT:[ UseTime:0.009544s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042296s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006537s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.053035s ]
[ 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 `id` DESC,`t`.`status` LIMIT 20,20 [ RunTime:0.006798s ]
---------------------------------------------------------------
[2019-12-12T15:20:04+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027698s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003997s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.025858s ]
[ 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` = 11 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004338s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.023234s ]
[ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 11 AND `remind_date` >= '2019-12-12' [ RunTime:0.003853s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.021718s ]
[ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 11 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003790s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.030504s ]
[ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 11 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003859s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020616s ]
[ 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` = 11 AND `t`.`type` = 2 [ RunTime:0.003857s ]
---------------------------------------------------------------
[2019-12-12T15:20:10+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskType
[ sql ] [ DB ] CONNECT:[ UseTime:0.007174s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028106s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005274s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.034009s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.004566s ]
---------------------------------------------------------------
[2019-12-12T15:20:10+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskNature
[ sql ] [ DB ] CONNECT:[ UseTime:0.015664s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032715s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005906s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.033325s ]
[ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.005321s ]
---------------------------------------------------------------
[2019-12-12T15:20:13+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.006490s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.041506s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004253s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.035866s ]
[ 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.003929s ]
---------------------------------------------------------------
[2019-12-12T15:20:13+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.019719s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.048872s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006213s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.038913s ]
[ 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.006225s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.031999s ]
[ 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.019627s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.015369s ]
---------------------------------------------------------------
[2019-12-12T15:20:13+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.016965s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.049423s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005141s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.051444s ]
[ 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.014259s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024189s ]
[ 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.006540s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006383s ]
---------------------------------------------------------------
[2019-12-12T15:20:13+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.008714s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032988s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006442s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.021522s ]
[ 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.005566s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.020810s ]
[ 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.006539s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.006714s ]
---------------------------------------------------------------
[2019-12-12T15:20:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.006109s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025603s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002403s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024269s ]
[ 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` = 5 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.002500s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021275s ]
[ 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` = 5 AND `t`.`is_delete` = 0 [ RunTime:0.002454s ]
---------------------------------------------------------------
[2019-12-12T15:20:15+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.008190s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.022583s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005598s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024625s ]
[ 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.005547s ]
---------------------------------------------------------------
[2019-12-12T15:20:17+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.012345s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026566s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004173s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.026134s ]
[ 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` = 11 AND `t`.`is_delete` = 0 LIMIT 1 [ RunTime:0.004490s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_remind` [ RunTime:0.036676s ]
[ sql ] [ SQL ] SELECT `name`,`remind_date`,`start_time` FROM `v_task_remind` WHERE `task_id` = 11 AND `remind_date` >= '2019-12-12' [ RunTime:0.004396s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_img` [ RunTime:0.043048s ]
[ sql ] [ SQL ] SELECT `id`,`img_url` FROM `v_task_img` WHERE `task_id` = 11 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.003941s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_course` [ RunTime:0.031688s ]
[ sql ] [ SQL ] SELECT `title`,`course_date`,`remark` FROM `v_task_course` WHERE `task_id` = 11 AND `status` = 0 AND `is_delete` = 0 [ RunTime:0.004035s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_record` [ RunTime:0.020785s ]
[ 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` = 11 AND `t`.`type` = 2 [ RunTime:0.004069s ]
---------------------------------------------------------------
[2019-12-12T15:20:21+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskType
[ sql ] [ DB ] CONNECT:[ UseTime:0.010252s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031850s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005214s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_type` [ RunTime:0.027102s ]
[ sql ] [ SQL ] SELECT `id`,`name` FROM `v_task_type` WHERE `status` = 0 AND `is_delete` = 0 [ RunTime:0.005228s ]
---------------------------------------------------------------
[2019-12-12T15:20:22+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/taskNature
[ sql ] [ DB ] CONNECT:[ UseTime:0.010593s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032771s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.003286s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_task_nature` [ RunTime:0.094163s ]
[ sql ] [ SQL ] SELECT n.id as nature_id,n.name as nature_name,`task_level_id`,l.name as level_name FROM v_task_nature n LEFT JOIN `v_task_level` `l` ON `l`.`id`=`n`.`task_level_id` WHERE `n`.`status` = 0 AND `n`.`is_delete` = 0 [ RunTime:0.003356s ]
---------------------------------------------------------------
[2019-12-12T15:20:26+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.017481s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.096508s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.006874s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.063149s ]
[ 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.006840s ]
---------------------------------------------------------------
[2019-12-12T15:20:26+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.016031s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.024076s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004065s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.024040s ]
[ 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.003973s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.023455s ]
[ 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.005273s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.005152s ]
---------------------------------------------------------------
[2019-12-12T15:20:27+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.021711s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023553s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.008096s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.047520s ]
[ 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.008088s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.024780s ]
[ 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.008977s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 40,20 [ RunTime:0.009336s ]
---------------------------------------------------------------
[2019-12-12T15:29:53+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/myInfo
[ sql ] [ DB ] CONNECT:[ UseTime:0.003492s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026653s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.002420s ]
[ 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.002327s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.024696s ]
[ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.002308s ]
---------------------------------------------------------------
[2019-12-12T15:29:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.032214s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043770s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.004004s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036205s ]
[ 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.003881s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027845s ]
[ 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.005326s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 0,20 [ RunTime:0.006101s ]
---------------------------------------------------------------
[2019-12-12T15:29:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/My/verifyAccess
[ sql ] [ DB ] CONNECT:[ UseTime:0.010436s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.052919s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.007104s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.067626s ]
[ 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.009041s ]
---------------------------------------------------------------
[2019-12-12T15:29:54+08:00] 39.190.140.97 POST 101.132.37.87:9001/api/Item/itemList
[ sql ] [ DB ] CONNECT:[ UseTime:0.007998s ] mysql:host=101.132.37.87;port=3306;dbname=visonmedical;charset=utf8
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.042475s ]
[ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|a640c15d410e63997a3be6712c8a4a3d' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.005713s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.068330s ]
[ 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.005386s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.019551s ]
[ 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.006253s ]
[ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name 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`.`id`,`i`.`status` LIMIT 20,20 [ RunTime:0.006476s ]