UVL is the biggest on-line database about almost any video game ever created, for any platform.
Please report any issue or suggestion here.
Search games
Supported platforms list
Read the forum
Tag cloud
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001115s ]
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.071945s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001194s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001305s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001032s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003151s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000930s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003710s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014826s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001384s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 247600 [ RunTime:0.013934s ]
