介绍游戏引擎的关键技术及实现办法，以一个引擎高手的经验为基础，阐述其中的难点和关键点。-Game engine introduction and implementation of key technologies in order to master the experience of an engine based on the difficulties and one of the key points.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001324s ]
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.088239s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001206s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001929s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001215s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003654s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001027s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003207s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014850s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001315s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 134927 [ RunTime:0.001494s ]
