This is an unofficial patch for Deus Ex, addressing bugs left in the v1112fm and Game of the Year editions of the game. This patch is in no way produced by Eidos Games or the now-defunct Ion Storm.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001121s ]
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.084125s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001309s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001091s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000983s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003164s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000752s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004650s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016182s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001160s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 255120 [ RunTime:0.023484s ]
