A system utilizing the accelerometer on the iPhone to recognize gestures. The goal is to allow the visually impaired to operate the iPhone with gestures (proprioception instead of sight), and perhaps help regular people driving, etc. better use the device.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001960s ]
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.088926s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002369s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001964s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002208s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003636s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002185s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003215s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014869s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002774s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 194413 [ RunTime:0.001269s ]
