AI Game Programming Wisdom 02 Useful Techniques 03 Pathfinding with Astar 04 Pathfinding and Movement 05 Tactical Issues 06 General Architectures 07 DecisionMaking Architectures 08 FPS, RTS, and RPG AI 09 Racing and Sports AI 10 Scripting 11 Learning
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001113s ]
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.069002s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001062s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001193s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001214s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005400s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001391s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005920s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014927s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001222s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 221736 [ RunTime:0.014375s ]