The problem is to evacuate patients from disaster place to hospitals by minimum time.
The conditions are:
1. arrival time to disaster for each brigade
1. time to reach each hospital from disaster
1. hospital capacity for each hospital
1. total quantity of pacients to evacuate
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002098s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.085787s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002561s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001917s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002191s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003702s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001952s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003384s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015055s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002377s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 301337 [ RunTime:0.001119s ]