利用ps2键盘向单片机输入数据,这样做不仅可以减少输入输出口,而且程序代码短小精悍,可以极大的提高单片机的执行效率.-Ps2 keyboard to use single-chip input data, to do so not only can reduce the input and output port, and program code dapper, you can greatly improve efficiency in the implementation of SCM.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001102s ]
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.064822s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001547s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001845s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001699s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005340s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001276s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006833s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015320s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001273s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 178372 [ RunTime:0.015518s ]