--------------------------------------------------------------- [2020-09-29T10:04:26+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.001010s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026689s ] [ 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.000617s ] [ sql ] [ SQL ] UPDATE `v_staff` SET `token` = '16|de4d694bb856e6a7663827baffc31caf' , `last_time` = 1601345066 WHERE `id` = 16 [ RunTime:0.002693s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018939s ] [ 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.000579s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.012612s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033871s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000762s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.184641s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 16 AND `status` = 0 [ RunTime:0.001729s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.005203s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032597s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000695s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.220805s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 16 AND `status` = 0 [ RunTime:0.000612s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.005258s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.088175s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000648s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.074671s ] [ 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.000672s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.022014s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.075148s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001148s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.051151s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000596s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.053513s ] [ 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.003571s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001750s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.000906s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.076775s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000661s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.058090s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000541s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.027727s ] [ 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.002009s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 20,20 [ RunTime:0.001853s ] --------------------------------------------------------------- [2020-09-29T10:04:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.008144s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017986s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000582s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.015397s ] [ 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.000479s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.016541s ] [ 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.001267s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 40,20 [ RunTime:0.001315s ] --------------------------------------------------------------- [2020-09-29T10:04:29+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.000737s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.027632s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.021173s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 16 AND `status` = 0 [ RunTime:0.000524s ] --------------------------------------------------------------- [2020-09-29T10:04:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.000847s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.034008s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000731s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.043579s ] [ 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.000617s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.051893s ] [ 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.001961s ] [ 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.001733s ] --------------------------------------------------------------- [2020-09-29T10:04:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001212s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.043150s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000611s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040502s ] [ 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.000564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.061384s ] [ 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.001798s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.035117s ] [ 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.001016s ] --------------------------------------------------------------- [2020-09-29T10:04:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.013138s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.099354s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000828s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.040047s ] [ 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.000564s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.014883s ] [ 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.001178s ] [ 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.001189s ] --------------------------------------------------------------- [2020-09-29T10:04:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.013496s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.017432s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000575s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020209s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 16 AND `status` = 0 [ RunTime:0.000510s ] --------------------------------------------------------------- [2020-09-29T10:04:31+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.000546s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.028132s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000668s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.030939s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 0,20 [ RunTime:0.000900s ] --------------------------------------------------------------- [2020-09-29T10:04:31+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTask [ sql ] [ DB ] CONNECT:[ UseTime:0.012546s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.031200s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000597s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.035202s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `staff_id` = 16 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC LIMIT 20,20 [ RunTime:0.000675s ] --------------------------------------------------------------- [2020-09-29T15:24:24+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Login/staffLogin [ sql ] [ DB ] CONNECT:[ UseTime:0.012448s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.026431s ] [ 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.000639s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.018405s ] [ 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.000467s ] --------------------------------------------------------------- [2020-09-29T15:24:25+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/verifyAccess [ sql ] [ DB ] CONNECT:[ UseTime:0.007208s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.019908s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000626s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.029902s ] [ 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.000626s ] --------------------------------------------------------------- [2020-09-29T15:24:25+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/itemList [ sql ] [ DB ] CONNECT:[ UseTime:0.003348s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.033506s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001480s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.030481s ] [ 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.000644s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.036651s ] [ 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.001501s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`is_delete` = 0 AND `i`.`status` IN (0,1) AND `hospital_id` IN (1063,1817,1860,1864,1870,1872,1875,1877,1878,1879,1880,1881,1882,1883,1884,1886,1887,1890,1893,1895,1904,1906,5879,5881,5882,5884,5887,5890,5891,5892,5896,5897,5898,5901,5909,5910,19119,19121,19124,19125,19126,19127,19128,19131,19132,19134,19135,19141,19143,19144,19152,19154,19164) ORDER BY `i`.`status`,`i`.`id` DESC LIMIT 0,20 [ RunTime:0.001232s ] --------------------------------------------------------------- [2020-09-29T15:24:27+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/itemInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000774s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.025745s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.021659s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`item_introduce`,`item_content`,`i`.`remark`,`staff_id`,`i`.`status`,`i`.`money`,`i`.`is_money` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `i`.`id` = 29 AND `i`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000751s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.020298s ] [ sql ] [ SQL ] SELECT `t`.`id`,`t`.`name`,`t`.`status`,`start_date`,`start_time`,`end_date`,`end_time`,`delay_date`,`delay_time`,`is_delay`,`is_change`,s.name as staff_name,l.name as level_name,`l`.`colour` FROM v_task t LEFT JOIN `v_staff` `s` ON `s`.`id`=`t`.`staff_id` LEFT JOIN `v_task_level` `l` ON `l`.`id`=`t`.`task_level_id` WHERE `item_id` = 29 AND `t`.`is_delete` = 0 ORDER BY `t`.`status`,`t`.`id` DESC [ RunTime:0.000832s ] --------------------------------------------------------------- [2020-09-29T15:24:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Hospital/myHospital [ sql ] [ DB ] CONNECT:[ UseTime:0.001970s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.032223s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000583s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.036756s ] [ 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.000521s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.027233s ] [ 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.002289s ] [ 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.001581s ] --------------------------------------------------------------- [2020-09-29T15:24:30+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Item/provinceInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000873s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030705s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_action` [ RunTime:0.027697s ] [ sql ] [ SQL ] SELECT `hospital_ids`,`is_create_item`,`is_create_task` FROM `v_staff_action` WHERE `staff_id` = 16 AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000610s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.034751s ] [ 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.001688s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_city` [ RunTime:0.031497s ] [ 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.000777s ] --------------------------------------------------------------- [2020-09-29T15:24:32+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/Hospital/hospitalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000722s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.023811s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_hospital` [ RunTime:0.017825s ] [ 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` = 1864 AND `h`.`status` = 0 AND `h`.`is_delete` = 0 LIMIT 1 [ RunTime:0.000544s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_item` [ RunTime:0.017714s ] [ sql ] [ SQL ] SELECT `i`.`id`,`i`.`name`,c.name as city_name,h.name as hospital_name,d.name as department_name,`i`.`status` FROM v_item i LEFT JOIN `v_hospital` `h` ON `h`.`id`=`i`.`hospital_id` LEFT JOIN `v_city` `c` ON `c`.`id`=`h`.`city_id` LEFT JOIN `v_department` `d` ON `d`.`id`=`i`.`department_id` WHERE `hospital_id` = 1864 AND `i`.`is_delete` = 0 ORDER BY `i`.`status`,`i`.`id` DESC [ RunTime:0.000594s ] --------------------------------------------------------------- [2020-09-29T15:24:33+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.000985s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.030026s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000588s ] [ 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.000689s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff_total` [ RunTime:0.034523s ] [ sql ] [ SQL ] SELECT * FROM `v_staff_total` WHERE `staff_id` = 16 LIMIT 1 [ RunTime:0.000761s ] --------------------------------------------------------------- [2020-09-29T15:24:36+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myDough [ sql ] [ DB ] CONNECT:[ UseTime:0.002902s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.062406s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.001462s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_dough_staff` [ RunTime:0.038767s ] [ 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.000912s ] --------------------------------------------------------------- [2020-09-29T15:24:36+08:00] 180.102.200.75 POST 101.132.37.87:9001/api/My/myTaskNotSee [ sql ] [ DB ] CONNECT:[ UseTime:0.006933s ] mysql:host=127.0.0.1;port=3306;dbname=visonmedical;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `v_staff` [ RunTime:0.040721s ] [ sql ] [ SQL ] SELECT `id`,`job_num`,`last_time` FROM `v_staff` WHERE `token` = '16|de4d694bb856e6a7663827baffc31caf' AND `status` = 0 AND `is_delete` = 0 LIMIT 1 [ RunTime:0.000725s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `v_task` [ RunTime:0.086310s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `v_task` WHERE `staff_id` = 16 AND `status` = 0 [ RunTime:0.000573s ]