SHOW FULL COLUMNS FROM `yun_category` [ RunTime:0.001434s ]
SELECT * FROM `yun_category` WHERE ( `type` = 'song' ) ORDER BY `weigh` DESC [ RunTime:0.000506s ]
SELECT * FROM `yun_category` WHERE ( `type` = 'singer' ) ORDER BY `weigh` DESC [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `yun_singer` [ RunTime:0.001342s ]
SELECT COUNT(*) AS think_count FROM `yun_singer` `singer` LEFT JOIN `yun_category` `category` ON `singer`.`c_id`=`category`.`id` [ RunTime:0.000491s ]
SELECT `singer`.`id`,`singer`.`uniqueid`,`singer`.`qq_singer_mid`,`singer`.`status`,`singer`.`name`,`singer`.`foreign_name`,`singer`.`c_id`,`singer`.`birthday`,`singer`.`image`,`singer`.`image_id`,`singer`.`sex`,`singer`.`intro`,`singer`.`wiki`,`singer`.`digg`,`singer`.`bury`,`singer`.`rater`,`singer`.`recs`,`singer`.`collects`,`singer`.`likes`,`singer`.`songs`,`singer`.`createtime`,`singer`.`updatetime`,`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_singer` `singer` LEFT JOIN `yun_category` `category` ON `singer`.`c_id`=`category`.`id` ORDER BY `id` ASC LIMIT 30,30 [ RunTime:0.004613s ]
SHOW FULL COLUMNS FROM `yun_page` [ RunTime:0.001137s ]
SELECT * FROM `yun_page` WHERE `status` = '1' ORDER BY createtime desc [ RunTime:0.000423s ]
