The final product should be a very simple musicplayer with the ability to fade one musik into another and fade out smoothly when turned of. It should also be possible to handle Playlists. It is primary for mp3.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001434s ]
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.094606s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001333s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003317s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001372s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003766s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001158s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003237s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015639s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001508s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 278091 [ RunTime:0.001556s ]
