Events
Project demo Feb 22 after class
To-Do
Refresh and fix phase 2"s code to fix bugs.
Get together and brainstorm on the 3rd phase of our project.
Recent
Tasks created under the Issues tab.
Wiki page created for Phase 2 overview
Wiki page created for Notes - feel free to add any random stuff here
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001006s ]
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.123876s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002123s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001448s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001135s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003145s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001172s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005547s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015266s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001091s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 296678 [ RunTime:0.020886s ]
