通过普通USB接口的网络摄像头进行视频图像采集,并可以完成AVI格式的视频录像。加上音频采集和音视频同步机制会更好。-by ordinary USB Webcam Video image acquisition, and will be completed AVI format video projection. Audio acquisition and add audio and video synchronization mechanism will be even better.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002061s ]
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.097456s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002905s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003387s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002938s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.006087s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002643s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005972s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.026886s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002223s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 306462 [ RunTime:0.001392s ]