KomitCMS is an open source CMS solution for small to medium size websites. The source code is open source but we provide commercial solutions based on KomitCMS at Zafri Technologies.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001178s ]
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.069951s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001065s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001191s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000950s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003027s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000968s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003683s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016603s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001372s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 301889 [ RunTime:0.019663s ]