If you would like to try to use the above programs by using MATLAB.
First of all, please copy all of files to your created adequate directory.
Then, you start to run MATLAB and you can see the following command prompt in the command window.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001444s ]
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.093717s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001326s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001994s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001379s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003635s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001137s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003346s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015335s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001620s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 4385 [ RunTime:0.001531s ]