The OpenSocial Container Sample
The demonstration OpenSocial container has moved to the shindig apache project. You can see the code in the svn trunk.
All downloads and code on this site have been deprecated.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000998s ]
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.066989s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000923s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001064s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000814s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.002836s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000712s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003473s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.013927s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001079s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 228828 [ RunTime:0.011894s ]
