If we have two individually sorted vectors "a" and "b" but they are not sorted with respect to each other and we want to merge them into vector "c" such that "c" is also a sorted vector. Then c=mergesorted(a,b) can be used.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001041s ]
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.062202s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001198s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002175s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001633s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005549s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001380s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005955s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014040s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001175s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 359664 [ RunTime:0.011581s ]
