CRC校验TS流文件的的PSI信息表,分析TS流文件的PAT表、PMT表、SDT表(注意项目文件中没有TS文件,要运行程序需要加入TS文件,并简单修改文件OPEN函数的参数)。-CRC Checksum TS stream file information table of the PSI, analysis TS stream file PAT table, PMT table, SDT table (note that the project document did not TS files, to run the program need to join the TS file, and modify the file a simple function of the parameters OPEN ).
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001386s ]
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.078152s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000951s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001269s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001054s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003195s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000964s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003779s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015084s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001191s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 247407 [ RunTime:0.021847s ]