SHOW FULL COLUMNS FROM `u_popular_album` [ RunTime:0.001158s ]
SELECT `id`,`title`,`keyword` FROM `u_popular_album` WHERE `is_recommend` = 2 LIMIT 10 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `u_music` [ RunTime:0.001015s ]
SELECT `m`.`id`,`m`.`title`,`m`.`hits_num`,`m`.`create_time`,`m`.`duration`,`m`.`size`,`m`.`bit_rate`,`m`.`down_coin`,`m`.`categorie_pid`,c.title as categorieName,`m`.`cover_id` FROM `u_music` `m` LEFT JOIN `u_categorie` `c` ON `m`.`categorie_pid`=`c`.`id` WHERE ( `m`.`categorie_pid` IN ('2','1') AND `m`.`create_time` BETWEEN '1480521600' AND '1483113600' ) AND `is_checked` = 2 ORDER BY `hits_num` DESC LIMIT 100 [ RunTime:0.004921s ]
