SHOW FULL COLUMNS FROM `yun_category` [ RunTime:0.002136s ]
SELECT * FROM `yun_category` WHERE ( `type` = 'song' ) ORDER BY `weigh` DESC [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `yun_songs` [ RunTime:0.001338s ]
SELECT COUNT(*) AS think_count FROM `yun_songs` `songs` LEFT JOIN `yun_category` `category` ON `songs`.`c_id`=`category`.`id` [ RunTime:0.003558s ]
SELECT `songs`.`id`,`songs`.`uniqueid`,`songs`.`status`,`songs`.`type`,`songs`.`is_encode`,`songs`.`name`,`songs`.`u_id`,`songs`.`c_id`,`songs`.`a_id`,`songs`.`s_id`,`songs`.`tags`,`songs`.`attachment_id`,`songs`.`image_id`,`songs`.`play_url`,`songs`.`download_url`,`songs`.`image`,`songs`.`size`,`songs`.`duration`,`songs`.`code_rate`,`songs`.`digg`,`songs`.`bury`,`songs`.`download`,`songs`.`rater`,`songs`.`listens`,`songs`.`recs`,`songs`.`collects`,`songs`.`likes`,`songs`.`score`,`songs`.`comment`,`songs`.`sing`,`songs`.`lyrics`,`songs`.`composer`,`songs`.`midi`,`songs`.`mix`,`songs`.`createtime`,`songs`.`updatetime`,`songs`.`encodetime`,`category`.`id` AS `category__id`,`category`.`uniqueid` AS `category__uniqueid`,`category`.`pid` AS `category__pid`,`category`.`type` AS `category__type`,`category`.`name` AS `category__name`,`category`.`nickname` AS `category__nickname`,`category`.`image` AS `category__image`,`category`.`keywords` AS `category__keywords`,`category`.`description` AS `category__description`,`category`.`createtime` AS `category__createtime`,`category`.`updatetime` AS `category__updatetime`,`category`.`weigh` AS `category__weigh`,`category`.`status` AS `category__status` FROM `yun_songs` `songs` LEFT JOIN `yun_category` `category` ON `songs`.`c_id`=`category`.`id` ORDER BY `download` DESC LIMIT 100,20 [ RunTime:0.005242s ]
SHOW FULL COLUMNS FROM `yun_page` [ RunTime:0.001498s ]
SELECT * FROM `yun_page` WHERE `status` = '1' ORDER BY createtime desc [ RunTime:0.000748s ]
