SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_tag`,`vod_title`,`vod_label`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_color`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_content`,`vod_addtime`,`vod_gold`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_status` = 1 ORDER BY `vod_hits_week` DESC LIMIT 0,12 [ RunTime:0.004032s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_status` = 1 ORDER BY `vod_hits_month` DESC LIMIT 0,12 [ RunTime:0.004788s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_status` = 1 ORDER BY `vod_hits` DESC LIMIT 0,10 [ RunTime:0.003547s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.003931s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_area` IN ('中国','内地','大陆') AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.004593s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_area` IN ('日韩','韩日','日本','韩国') AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.006985s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 3 AND `vod_area` IN ('美国','英国','法国','瑞士','德国','意大利','加拿大','挪威','丹麦','瑞典','芬兰','爱尔兰','比利时','荷兰','奥地利','捷克','波兰','西班牙','葡萄牙','安道尔','罗马尼亚','希腊','保加利亚','匈牙利') AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.017808s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_pid` = '3' AND `mcid_mid` = 125 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.006958s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_pid` = '3' AND `mcid_mid` = 123 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.003106s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_pid` = '3' AND `mcid_mid` = 126 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.003423s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_aliases`,`vod_title`,`vod_color`,`vod_mcid`,`vod_area`,`vod_language`,`vod_year`,`vod_gold`,`vod_actor`,`vod_director`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_filmtime`,`vod_isfilm`,`vod_continu`,`vod_total`,`vod_isend`,`vod_length`,`vod_pinyin`,`vod_label`,`vod_weekday`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_content`,`vod_golder`,`vod_addtime`,`vod_jumpurl` FROM `zanpiancms_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `vod_pid` = '3' AND `mcid_mid` = 121 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.007427s ]