Vauthree is a project created for faster and better developing in ActionScript. It will contain solutions for some irritating problems, various mathematic algorithms and classes often needed for repeated operations.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000950s ]
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.077164s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001246s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002064s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001377s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005508s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001190s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.007288s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015932s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001144s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 265803 [ RunTime:0.016246s ]