Exploring basic techniques in image processing such as smoothening (low pass filtering) and edge detection (high pass filtering) and its applications to "crispening" an image, as well as some basic optical character recognition.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000918s ]
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.090267s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.019561s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.027792s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.003605s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.011835s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.016916s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004134s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.027630s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001477s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 258878 [ RunTime:0.023091s ]
