TrainReset:there are many trains need to drive out of the station .In terms of their numbers from small to large.There are only three railways used to place the trains ,and also need the same order.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001509s ]
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.093461s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001047s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001152s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000943s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003632s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001360s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006871s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025547s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001431s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 519931 [ RunTime:0.028006s ]