Used MATLAB to extract musical notes from an instrumental music fed as input. Used the Fourier Transforms to extract the frequency components nd then classify them to the respective notes based on the frequency components of the music.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001246s ]
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.088396s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001299s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001936s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001275s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005364s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002080s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006600s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017569s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.003567s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 85551 [ RunTime:0.014291s ]
