This is my collection of software development related utilities and code snippets that can be used just as it is or with minor changes.
License is LGPL v3 for all the codes.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001419s ]
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.075140s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002782s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001375s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001086s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003333s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000871s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003971s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.020646s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001382s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 269486 [ RunTime:0.014108s ]