The idea for this plugin came to my mind when we needed to show a quick image gallery to client, and we need something lightweight, with more control over how the image is shown in the gallery page itself. We could have used other big gallery components but I was not interested in something simple and quick. Check out the implementation of akJoomGallery.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.005406s ]
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.151287s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002500s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003006s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002910s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005989s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002592s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005604s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024666s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003330s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 267347 [ RunTime:0.001513s ]