这不是一个完整的工程,只是对IPv4,IPv6及mpg4的实现代码。如果你正在进行这类工作,里面的东西对你肯定有帮助。- This is not a complete project, only is to IPv4, IPv6 and the
mpg4 realization code. If you are carrying on this kind of work, the
inside thing definitely has the help to you.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001100s ]
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.085682s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000973s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001104s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001122s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003215s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000941s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003585s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015191s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001243s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 115325 [ RunTime:0.017147s ]