串口控件编程,使用mscomm控件,串口控件有别于文件流方法,易学易懂,但是必须安装这个控件。-Serial control programming, using mscomm control, serial control is different from the file stream method, easy to learn and easy to understand, but must install the controls.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001280s ]
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.106463s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001318s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001966s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001265s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003813s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001089s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003387s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015714s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001311s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 173977 [ RunTime:0.001313s ]