The Open Source Applications Foundation is a non-profit whose mission is "Create and gain wide adoption of Open Source application software of uncompromising quality". We are working on the Chandler desktop PIM and the Cosmo sharing server. We are also working on Windmill, an open source tool for testing web applications.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002765s ]
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.146500s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002708s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002113s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002477s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003736s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002557s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005881s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.025157s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.007031s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 273757 [ RunTime:0.001799s ]