SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'gaotianchanghong' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001217s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '高田昌宏' [ RunTime:0.001472s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (16877,20019,20234,20244,20722,21608,21634,21657,21706) [ RunTime:0.002595s ]
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_name` IN ('樱井孝宏','代永翼','梶裕贵','中村悠一','濑藤健嗣','赤城博昭','深濑重','原口浩','则座诚','能登麻美子','松村树里亚','高桥悠也','唐唐烟','宍户淳','浅香守生','奈良彻','细谷佳正','宫野真守','濑户麻沙美','细川秀树','渡边琴乃','小野田雄亮','久保山英一','南川达马','朝木幸彦','野上和男','铃木拓磨','江副仁美','友田政晴','所俊克','佐土原武之','柿原优子','森山明美','加藤绫子','川岛澄乃','石野敦夫','畠中祐','入野自由','增田俊树','内山昂辉','小松未可子','桑原智','武藤公春','政木伸一','德本善信','茉田哲明','柳濑雄之','牧野吉高','青柳宏宜','铃木卓夫','池田重隆','向井雅浩','山本隆太','濑谷新二','羽原久美子','小平麻纪','玉田博','黑田晃一郎','望月敬一郎','高桥和希','吉田伸','福岛幸典','竹内利光','山下宪一','铃木康之','广田光毅','待田堂子','杂破业','小野贤章','稻村优奈','矢野奖吾','大林洋平','小野胜巳','湖山祯崇','鴫野彰','高桥幸雄','儿谷直树','布施康之','上代务','前川淳','甲斐田幸','野田顺子','小西克幸','麦人','小林沙苗','森邦宏','小仓宏文','山口祐司','冈岛国敏','土屋浩幸','吉田俊司','饭村正之','山田弘和','上田茂','五十岚达矢','浅木樱','结城光流','浅川美也','山口伸明','吉村清子','西园悟','铃村健一','坂本真绫','池田秀一','田中理惠','关俊彦','福田己津央','谷田部胜义','西村大树','鸟羽聪','西山明树彦','丝贺慎太郎','两泽千晶','吉野弘幸','大野木宽','野村祐一','森田繁','高桥奈津子','兵头一步','矢立肇','富野由悠季','大仓孝二','丰口惠美','小山力也','江原正士','田中秀幸','真下耕一','川面真也','泽井幸次','黑川智之','守冈博','平田丰','川崎裕之','井上麻里奈','早水理沙','川中子雅人','佐山圣子','古川知宏','杉山庆一','山口赖房','筑紫大介','小高义规','大脊户聪','中山敦史','五月女有作','镰仲史阳','安藤健','仲村佳树','关岛真赖','大知庆一郎','户松遥','关智一','小樱悦子','远藤绫','后信治','滨名孝行','永居慎平','高桥滋春','矢野孝典','岩田义彦','川西泰二','久慈悟郎','荒井省吾','北川正人','寺泽伸介','平向智子','吉本毅','本间修','星野真','佐藤和磨','佐藤光敏','驹屋健一郎','泉保良辅','日野晃博','加藤阳一','山田由香','鸿野贵光','LEVEL-5') AND `star_status` = 1 ORDER BY field(star_name,'樱井孝宏','代永翼','梶裕贵','中村悠一','濑藤健嗣','赤城博昭','深濑重','原口浩','则座诚','能登麻美子','松村树里亚','高桥悠也','唐唐烟','宍户淳','浅香守生','奈良彻','细谷佳正','宫野真守','濑户麻沙美','细川秀树','渡边琴乃','小野田雄亮','久保山英一','南川达马','朝木幸彦','野上和男','铃木拓磨','江副仁美','友田政晴','所俊克','佐土原武之','柿原优子','森山明美','加藤绫子','川岛澄乃','石野敦夫','畠中祐','入野自由','增田俊树','内山昂辉','小松未可子','桑原智','武藤公春','政木伸一','德本善信','茉田哲明','柳濑雄之','牧野吉高','青柳宏宜','铃木卓夫','池田重隆','向井雅浩','山本隆太','濑谷新二','羽原久美子','小平麻纪','玉田博','黑田晃一郎','望月敬一郎','高桥和希','吉田伸','福岛幸典','竹内利光','山下宪一','铃木康之','广田光毅','待田堂子','杂破业','小野贤章','稻村优奈','矢野奖吾','大林洋平','小野胜巳','湖山祯崇','鴫野彰','高桥幸雄','儿谷直树','布施康之','上代务','前川淳','甲斐田幸','野田顺子','小西克幸','麦人','小林沙苗','森邦宏','小仓宏文','山口祐司','冈岛国敏','土屋浩幸','吉田俊司','饭村正之','山田弘和','上田茂','五十岚达矢','浅木樱','结城光流','浅川美也','山口伸明','吉村清子','西园悟','铃村健一','坂本真绫','池田秀一','田中理惠','关俊彦','福田己津央','谷田部胜义','西村大树','鸟羽聪','西山明树彦','丝贺慎太郎','两泽千晶','吉野弘幸','大野木宽','野村祐一','森田繁','高桥奈津子','兵头一步','矢立肇','富野由悠季','大仓孝二','丰口惠美','小山力也','江原正士','田中秀幸','真下耕一','川面真也','泽井幸次','黑川智之','守冈博','平田丰','川崎裕之','井上麻里奈','早水理沙','川中子雅人','佐山圣子','古川知宏','杉山庆一','山口赖房','筑紫大介','小高义规','大脊户聪','中山敦史','五月女有作','镰仲史阳','安藤健','仲村佳树','关岛真赖','大知庆一郎','户松遥','关智一','小樱悦子','远藤绫','后信治','滨名孝行','永居慎平','高桥滋春','矢野孝典','岩田义彦','川西泰二','久慈悟郎','荒井省吾','北川正人','寺泽伸介','平向智子','吉本毅','本间修','星野真','佐藤和磨','佐藤光敏','驹屋健一郎','泉保良辅','日野晃博','加藤阳一','山田由香','鸿野贵光','LEVEL-5') LIMIT 0,6 [ RunTime:0.006333s ]
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 `actors_name` = '高田昌宏' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,12 [ RunTime:0.001677s ]
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_pid` = '1' AND `actors_name` = '高田昌宏' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.001672s ]
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_pid` = '2' AND `actors_name` = '高田昌宏' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.001729s ]
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_pid` = '4' AND `actors_name` = '高田昌宏' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,1 [ RunTime:0.002061s ]
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_star` = '高田昌宏' AND `role_status` = 1 ORDER BY `role_id` DESC LIMIT 0,6 [ RunTime:0.001785s ]
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_status` = 1 ORDER BY `star_hits` DESC LIMIT 0,6 [ RunTime:0.001371s ]
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_hits_day` DESC LIMIT 0,6 [ RunTime:0.005107s ]
