一个基于串口通信的汽车行驶记录仪数据采集处理系统，这里是主程序和数据库，整个项目使用Delphi的Com+组件技术开发，后面将陆续上传各个组件的源码-a serial communication based on the vehicles running Recorder Data Acquisition and Processing System, which is the main program and database, the entire project using Delphi Com component technology development, will continue to upload behind all of the source components
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001310s ]
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.091216s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001214s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002143s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001151s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003625s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000994s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003330s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014680s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001223s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 181890 [ RunTime:0.001251s ]
