Au3DB is a simple snippet holder for your commonly used pieces of AutoIt code. It is more lightweight than the other snippet holders available and also includes syntax highlighting. Au3DB is new and it may change and grow in the future.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001072s ]
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.086974s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.011966s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002388s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001917s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004515s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000964s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004949s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.038746s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.009905s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 244626 [ RunTime:0.028398s ]