不足千行代码就能实现俄罗斯方块的基本功能。有兴趣的朋友可以把他的功能扩
展下。基础学习不错!-Less than a thousand lines of code will be able to achieve the basic functions of the Russian box. Interested friends can put him under the function of the expansion. Learn basic good!
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001355s ]
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.096412s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001309s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001908s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001236s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003666s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001065s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003358s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014937s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001345s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 158458 [ RunTime:0.001389s ]