按照时间数字排序的列表框
,功能实现很简单,很适合初学者学习使用。-ranking figures in accordance with the time frame of the list, the implementation of function is very simple and very suitable for beginners to learn how to use.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002620s ]
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.087768s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002345s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002061s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002249s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003742s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002004s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003172s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014884s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002388s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 140778 [ RunTime:0.001309s ]