SELECT * FROM `zanpiancms_slide` WHERE `slide_cid` IN (25,26,27,28,29,30,31,32,33,66,67,68,69,70,71,72,73,74,75,1) AND `slide_status` = 1 ORDER BY `slide_sort` DESC LIMIT 10 [ RunTime:0.001388s ]
SELECT * FROM `zanpiancms_slide` WHERE `slide_status` = 1 ORDER BY `slide_sort` DESC LIMIT 10 [ RunTime:0.000885s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 6409 LIMIT 1 [ RunTime:0.000909s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 32500 LIMIT 1 [ RunTime:0.000745s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 32410 LIMIT 1 [ RunTime:0.000777s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 32319 LIMIT 1 [ RunTime:0.000718s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 27322 LIMIT 1 [ RunTime:0.000933s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 27904 LIMIT 1 [ RunTime:0.000778s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 27940 LIMIT 1 [ RunTime:0.000871s ]
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_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_yesterday`,`vod_hits_week`,`vod_hits_month`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_filmtime`,`vod_length`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_id` = 25800 LIMIT 1 [ RunTime:0.000898s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_pid` = 1 AND `vod_filmtime` BETWEEN 1651832621 AND 1714991021 AND `vod_status` = 1 ORDER BY `vod_filmtime` DESC LIMIT 0,12 [ RunTime:0.003107s ]
SELECT `vod_id`,`vod_pid`,`vod_cid`,`vod_name`,`vod_pic`,`vod_label`,`vod_year`,`vod_content`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_vod` WHERE `vod_pid` = 1 AND `vod_filmtime` <= 1714991021 AND `vod_status` = 1 ORDER BY `vod_hits` DESC LIMIT 0,10 [ RunTime:0.001533s ]
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` = 1 AND `vod_filmtime` >= 1714991021 AND `vod_status` = 1 ORDER BY `vod_filmtime` ASC LIMIT 0,8 [ RunTime:0.001195s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 25 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001472s ]
SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_mcid`,`star_wwm`,`star_pinyin`,`star_tag`,`star_label`,`star_color`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_weibo`,`star_work`,`star_guanxi`,`star_zy`,`star_xz`,`star_xx`,`star_area`,`star_gj`,`star_csd`,`star_hits`,`star_hits_day`,`star_hits_yesterday`,`star_hits_week`,`star_hits_month`,`star_hits_lasttime`,`star_addtime`,`star_stars`,`star_up`,`star_down`,`star_flower`,`star_jumpurl` FROM `zanpiancms_star` WHERE `star_prty` IN (4,31,20,12,6,5,28,22,14,21,13,7,30,29,23,15) AND `star_status` = 1 ORDER BY `star_hits` DESC LIMIT 0,5 [ RunTime:0.001331s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '长井新' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.005298s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '洛雷娜·舒特' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.004091s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '莎利尼·瓦察' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.004800s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '长井新' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.003714s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '洛雷娜·舒特' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.004179s ]
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_actors` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`actors_id` WHERE `vod_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '莎利尼·瓦察' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,9 [ RunTime:0.004008s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 26 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001452s ]
SELECT `actor`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_actor` `actor` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`actor`.`actor_vid` WHERE `vod_pid` = '1' AND `actor_status` = 1 ORDER BY `actor_addtime` DESC LIMIT 0,5 [ RunTime:0.002992s ]
SELECT `role`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_vid` = 32722 AND `role_status` = 1 ORDER BY `role_oid` ASC LIMIT 0,2 [ RunTime:0.002103s ]
SELECT `role`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_vid` = 32493 AND `role_status` = 1 ORDER BY `role_oid` ASC LIMIT 0,2 [ RunTime:0.001922s ]
SELECT `role`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_vid` = 32270 AND `role_status` = 1 ORDER BY `role_oid` ASC LIMIT 0,2 [ RunTime:0.002162s ]
SELECT `role`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_vid` = 14700 AND `role_status` = 1 ORDER BY `role_oid` ASC LIMIT 0,2 [ RunTime:0.002008s ]
SELECT `role`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_diantai`,`vod_tvcont`,`vod_area`,`vod_language`,`vod_year`,`vod_continu`,`vod_total`,`vod_isend`,`vod_addtime`,`vod_hits`,`vod_hits_day`,`vod_hits_week`,`vod_hits_month`,`vod_hits_lasttime`,`vod_stars`,`vod_up`,`vod_down`,`vod_play`,`vod_gold`,`vod_golder`,`vod_isfilm`,`vod_filmtime`,`vod_length`,`vod_weekday`,`vod_pinyin`,`vod_jumpurl` FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`role_star` WHERE `role_vid` = 14709 AND `role_status` = 1 ORDER BY `role_oid` ASC LIMIT 0,2 [ RunTime:0.001982s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 27 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.003622s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 28 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001946s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 29 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001687s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 30 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001523s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 31 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001614s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 32 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001968s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 33 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001651s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 66 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001693s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 67 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001547s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 68 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001638s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 69 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001785s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 70 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.002044s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 71 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001752s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 72 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001547s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 73 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001603s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 74 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001873s ]
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`,`actor_id`,`actor_cid` FROM `zanpiancms_vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod_id` WHERE `vod_cid` = 75 AND `vod_status` = 1 ORDER BY `vod_addtime` DESC LIMIT 0,8 [ RunTime:0.001856s ]
SELECT `news_id`,`news_pid`,`news_cid`,`news_name`,`news_tag`,`news_label`,`news_color`,`news_pic`,`news_pic_thumb`,`news_pic_big`,`news_remark`,`news_hits`,`news_hits_day`,`news_hits_yesterday`,`news_hits_week`,`news_hits_month`,`news_hits_lasttime`,`news_stars`,`news_up`,`news_down`,`news_addtime`,`news_gold`,`news_jumpurl` FROM `zanpiancms_news` WHERE `news_cid` = 45 AND `news_status` = 1 ORDER BY `news_addtime` DESC LIMIT 0,6 [ RunTime:0.001511s ]