SHOW FULL COLUMNS FROM `yun_category` [ RunTime:0.001348s ]
SELECT * FROM `yun_category` WHERE ( `type` = 'song' ) ORDER BY `weigh` DESC [ RunTime:0.000399s ]
SELECT * FROM `yun_category` WHERE ( `type` = 'singer' ) ORDER BY `weigh` DESC [ RunTime:0.000570s ]
SELECT `id` FROM `yun_category` WHERE `pid` = 13 [ RunTime:0.000583s ]
SHOW FULL COLUMNS FROM `yun_singer` [ RunTime:0.001196s ]
SELECT COUNT(*) AS think_count FROM `yun_singer` `singer` LEFT JOIN `yun_category` `category` ON `singer`.`c_id`=`category`.`id` WHERE `c_id` IN (14,15,16) AND `sex` = '2' [ RunTime:0.031524s ]
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` WHERE `c_id` IN (14,15,16) AND `sex` = '2' ORDER BY `id` ASC LIMIT 0,30 [ RunTime:0.033385s ]
SHOW FULL COLUMNS FROM `yun_page` [ RunTime:0.001246s ]
SELECT * FROM `yun_page` WHERE `status` = '1' ORDER BY createtime desc [ RunTime:0.000515s ]
