Repository for my projects.
See downloads for some projects, considered to be worthy of public releasing.
Some other projects may be found in SVN repository, binary builds can be found in /Binaries directory.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001294s ]
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.109510s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001547s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002413s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001315s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004629s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001459s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004031s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020817s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001582s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 239955 [ RunTime:0.001840s ]
