大学英语精读学习软件，中英文对照，可复读，由于MP3文件太大，只上传2课，源程序未上传，打开数据库文件就知道编程思路。-College English learning software, bilingual and can read, as much MP3 files, upload only two classes, the source did not upload, open database files know programming ideas.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001208s ]
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.088918s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001034s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001163s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000971s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003075s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000913s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003675s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.023055s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001405s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 226800 [ RunTime:0.012253s ]
