SHOW FULL COLUMNS FROM `u_popular_album` [ RunTime:0.000949s ]
SELECT `id`,`title`,`keyword` FROM `u_popular_album` WHERE `is_recommend` = 2 LIMIT 10 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `u_music` [ RunTime:0.001140s ]
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 ('5','6','8') AND `m`.`create_time` BETWEEN '1764518400' AND '1767110400' ) AND `is_checked` = 2 ORDER BY `hits_num` DESC LIMIT 100 [ RunTime:0.000887s ]
