SELECT COUNT(*) AS think_count FROM `zanpiancms_vod` WHERE `vod_cid` = 77 AND `vod_area` IN ('美国','英国','法国','瑞士','德国','意大利','加拿大','挪威','丹麦','瑞典','芬兰','爱尔兰','比利时','荷兰','奥地利','捷克','波兰','西班牙','葡萄牙','安道尔','罗马尼亚','希腊','保加利亚','匈牙利') AND `vod_year` = 2007 AND `vod_letter` = 'X' AND `vod_status` = 1 LIMIT 1 [ RunTime:0.012563s ]
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_vod` WHERE `vod_cid` = 77 AND `vod_area` IN ('美国','英国','法国','瑞士','德国','意大利','加拿大','挪威','丹麦','瑞典','芬兰','爱尔兰','比利时','荷兰','奥地利','捷克','波兰','西班牙','葡萄牙','安道尔','罗马尼亚','希腊','保加利亚','匈牙利') AND `vod_year` = 2007 AND `vod_letter` = 'X' AND `vod_status` = 1 ORDER BY `vod_gold` DESC LIMIT 0,32 [ RunTime:0.011580s ]