SELECT COUNT(*) AS think_count FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_cid` = '25' AND `vod_area` IN ('香港','台湾','中国香港','中国台湾') AND `vod_letter` = 'T' AND `mcid_mid` = 47 AND `vod_status` = '1' LIMIT 1 [ RunTime:0.005257s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_pinyin`,`vod_pic`,`vod_year`,`vod_pic_thumb`,`vod_area`,`vod_title`,`vod_mcid`,`vod_actor`,`vod_director`,`vod_total`,`vod_isend`,`vod_continu`,`vod_content`,`vod_gold`,`vod_hits`,`vod_label`,`vod_jumpurl` FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_cid` = '25' AND `vod_area` IN ('香港','台湾','中国香港','中国台湾') AND `vod_letter` = 'T' AND `mcid_mid` = 47 AND `vod_status` = '1' ORDER BY `vod_hits` DESC LIMIT 0,32 [ RunTime:0.005658s ]
