I was missing a simple batch renaming feature in MacOS X. A Kickass Renamer will ask for two suffixes, one to look for and one to rename to, and a folder of choice. All files in the given folder will be parsed for the given suffixes. If matching files are found, they can easily be renamed with just one click! Easy as pie.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001237s ]
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.088097s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001152s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001889s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001297s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003582s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000999s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003153s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015815s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001315s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 38728 [ RunTime:0.001304s ]