This app allows for access to all of the default user account pictures. Allowing for quick removal and addition of images. The screenshot too is used for adding images and is pretty dandy.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001300s ]
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.088394s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001456s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001926s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001260s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003769s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001125s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003305s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015764s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001509s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 204812 [ RunTime:0.002439s ]
