IMPORTANT
The EAS project has moved! You can find the new page here. As of May, 2013, the source code and issues herein are no longer being maintained and have been moved to the BitBucket page. This page will continue to be available for the time being as an archive. Please see our new project page for updates.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002065s ]
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.090775s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002523s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002232s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002142s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004027s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001950s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003286s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014879s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002324s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 269967 [ RunTime:0.001165s ]
