This is a project for the Web 2.0 subject for the fall term 2011. User should be able to find the nearest bicycle in Zurich, check it out, drive somewhere and check it in there.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002100s ]
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.144355s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002136s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.004543s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001459s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.004950s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001051s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004015s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016426s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001203s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 286311 [ RunTime:0.026808s ]