机于s52的巡检系统的开发代码。从代码中可以看到整个系统的流程和上位机的通信协议的格式非常不错。-plane s52 of the Tour system development code. From the code, we can see the whole system and the flow of PC communications agreement very good format.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002820s ]
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.089739s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002386s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002039s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002140s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003626s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001920s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003292s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014655s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002766s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 292052 [ RunTime:0.001219s ]