SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'nengdengmameizi' AND `star_status` = 1 LIMIT 1 [ RunTime:0.000935s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '能登麻美子' [ RunTime:0.001085s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (13832,14537,16501,20087,20089,20102,20160,20333,20374,20545,20559,20610,20643,20709,31651,36748,36802) [ RunTime:0.002060s ]
SELECT COUNT(*) AS think_count FROM `zanpiancms_star` WHERE `star_name` IN ('铃木雅词','大槻敦史','斋藤千和','川澄绫子','玉井豪','入江泰浩','博史池畠','德本善信','名和宗则','清水香里','佐藤利奈','后藤麻衣','羽多野涉','中村悠一','梶裕贵','代永翼','樱井孝宏','原口浩','则座诚','深濑重','赤城博昭','濑藤健嗣','高田昌宏','松村树里亚','高桥悠也','唐唐烟','水桥香织','喜多村英梨','福圆美里','田村由香里','伊藤祐毅','小林成朗','水濑祈','小仓唯','上坂堇','西村纯二','都筑真纪','小林裕介','濑户麻沙美','茅野爱衣','水岛努','后藤圭二','铃木洋平','樱美胜志','高岛大辅','池端隆史','横手美智子','吉田玲子','水剃龙','堺雅人','远藤绫','朴璐美','久川绫','浅香守生','荒木哲郎','宫繁之','中村亮介','石塚敦子','渡边琴乃','久米一成','兼森义则','细川秀树','鹤冈耕次郎','太宰治','夏目漱石','芥川龙之介','坂口安吾','伊藤加奈惠','小见川千明','丰崎爱生','户松遥','安藤真裕','筱原俊哉','桥本昌和','安斋刚文','柿本广大','小森香织','守冈博','太田知章','仓川英扬','冈田麿里','浦畑达彦','小柳启伍','樋口达人','P.A.WORKS','铃木崚汰','上田丽奈','前野智昭','柳沼和良','福田纪之','川崎芳树','笔安一幸','山田由香','山口胜平','雪野五月','渡边久美子','森川智之','青木康直','京极尚彦','秋田谷典昭','古田丈司','岩本保雄','绵田慎也','鸟羽聪','斋藤德明','根岸宏树','佐藤照雄','高桥留美子','隅泽克之','钉宫理惠','日野聪','江原正士','伊藤静','渡部高志','山口赖房','湖山祯崇','神保昌登','飞田刚','石田畅','桥本敏一','小野田雄亮','高桥弥七郎','小林靖子','水上清资','安川正吾','白根秀树','砂山藏澄','桑岛法子','水田山葵','汤浅政明','高桥知也','三原三千夫','横山彰利','柿原彻也','福山润','泽城美雪','日高政光','吉村清子','森田繁','诹访部顺一','吉野裕行','中原麻衣','吉原正行','今泉贤一','伊藤秀树','佐土原武之','菅沼芙实彦','菅正太郎','桧垣亮','森见登美彦','铃村健一','真殿光昭','川尻善昭','滨崎博嗣','太田雅彦','松尾衡','宍户淳','细田雅弘','渡边正彦','松村康弘','佐藤英一','外崎春雄','池田重隆','有富兴二','木宫茂','高田淳','远藤卓司','冈崎幸男','杉原研二','五十岚皋','吉野智美','今敏','平尾隆之','高桥敦史','内海贤二','关俊彦','饭塚昭三','桃井晴子','池田真美子','横谷昌宏','佐藤顺一','吉崎观音','子安武人','中田让治','小樱悦子','藤原启治','石田彰','广桥凉','池泽春菜','平松晶子','川上伦子','草尾毅') AND `star_status` = 1 LIMIT 1 [ RunTime:0.019918s ]
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 ('铃木雅词','大槻敦史','斋藤千和','川澄绫子','玉井豪','入江泰浩','博史池畠','德本善信','名和宗则','清水香里','佐藤利奈','后藤麻衣','羽多野涉','中村悠一','梶裕贵','代永翼','樱井孝宏','原口浩','则座诚','深濑重','赤城博昭','濑藤健嗣','高田昌宏','松村树里亚','高桥悠也','唐唐烟','水桥香织','喜多村英梨','福圆美里','田村由香里','伊藤祐毅','小林成朗','水濑祈','小仓唯','上坂堇','西村纯二','都筑真纪','小林裕介','濑户麻沙美','茅野爱衣','水岛努','后藤圭二','铃木洋平','樱美胜志','高岛大辅','池端隆史','横手美智子','吉田玲子','水剃龙','堺雅人','远藤绫','朴璐美','久川绫','浅香守生','荒木哲郎','宫繁之','中村亮介','石塚敦子','渡边琴乃','久米一成','兼森义则','细川秀树','鹤冈耕次郎','太宰治','夏目漱石','芥川龙之介','坂口安吾','伊藤加奈惠','小见川千明','丰崎爱生','户松遥','安藤真裕','筱原俊哉','桥本昌和','安斋刚文','柿本广大','小森香织','守冈博','太田知章','仓川英扬','冈田麿里','浦畑达彦','小柳启伍','樋口达人','P.A.WORKS','铃木崚汰','上田丽奈','前野智昭','柳沼和良','福田纪之','川崎芳树','笔安一幸','山田由香','山口胜平','雪野五月','渡边久美子','森川智之','青木康直','京极尚彦','秋田谷典昭','古田丈司','岩本保雄','绵田慎也','鸟羽聪','斋藤德明','根岸宏树','佐藤照雄','高桥留美子','隅泽克之','钉宫理惠','日野聪','江原正士','伊藤静','渡部高志','山口赖房','湖山祯崇','神保昌登','飞田刚','石田畅','桥本敏一','小野田雄亮','高桥弥七郎','小林靖子','水上清资','安川正吾','白根秀树','砂山藏澄','桑岛法子','水田山葵','汤浅政明','高桥知也','三原三千夫','横山彰利','柿原彻也','福山润','泽城美雪','日高政光','吉村清子','森田繁','诹访部顺一','吉野裕行','中原麻衣','吉原正行','今泉贤一','伊藤秀树','佐土原武之','菅沼芙实彦','菅正太郎','桧垣亮','森见登美彦','铃村健一','真殿光昭','川尻善昭','滨崎博嗣','太田雅彦','松尾衡','宍户淳','细田雅弘','渡边正彦','松村康弘','佐藤英一','外崎春雄','池田重隆','有富兴二','木宫茂','高田淳','远藤卓司','冈崎幸男','杉原研二','五十岚皋','吉野智美','今敏','平尾隆之','高桥敦史','内海贤二','关俊彦','饭塚昭三','桃井晴子','池田真美子','横谷昌宏','佐藤顺一','吉崎观音','子安武人','中田让治','小樱悦子','藤原启治','石田彰','广桥凉','池泽春菜','平松晶子','川上伦子','草尾毅') AND `star_status` = 1 ORDER BY field(star_name,'铃木雅词','大槻敦史','斋藤千和','川澄绫子','玉井豪','入江泰浩','博史池畠','德本善信','名和宗则','清水香里','佐藤利奈','后藤麻衣','羽多野涉','中村悠一','梶裕贵','代永翼','樱井孝宏','原口浩','则座诚','深濑重','赤城博昭','濑藤健嗣','高田昌宏','松村树里亚','高桥悠也','唐唐烟','水桥香织','喜多村英梨','福圆美里','田村由香里','伊藤祐毅','小林成朗','水濑祈','小仓唯','上坂堇','西村纯二','都筑真纪','小林裕介','濑户麻沙美','茅野爱衣','水岛努','后藤圭二','铃木洋平','樱美胜志','高岛大辅','池端隆史','横手美智子','吉田玲子','水剃龙','堺雅人','远藤绫','朴璐美','久川绫','浅香守生','荒木哲郎','宫繁之','中村亮介','石塚敦子','渡边琴乃','久米一成','兼森义则','细川秀树','鹤冈耕次郎','太宰治','夏目漱石','芥川龙之介','坂口安吾','伊藤加奈惠','小见川千明','丰崎爱生','户松遥','安藤真裕','筱原俊哉','桥本昌和','安斋刚文','柿本广大','小森香织','守冈博','太田知章','仓川英扬','冈田麿里','浦畑达彦','小柳启伍','樋口达人','P.A.WORKS','铃木崚汰','上田丽奈','前野智昭','柳沼和良','福田纪之','川崎芳树','笔安一幸','山田由香','山口胜平','雪野五月','渡边久美子','森川智之','青木康直','京极尚彦','秋田谷典昭','古田丈司','岩本保雄','绵田慎也','鸟羽聪','斋藤德明','根岸宏树','佐藤照雄','高桥留美子','隅泽克之','钉宫理惠','日野聪','江原正士','伊藤静','渡部高志','山口赖房','湖山祯崇','神保昌登','飞田刚','石田畅','桥本敏一','小野田雄亮','高桥弥七郎','小林靖子','水上清资','安川正吾','白根秀树','砂山藏澄','桑岛法子','水田山葵','汤浅政明','高桥知也','三原三千夫','横山彰利','柿原彻也','福山润','泽城美雪','日高政光','吉村清子','森田繁','诹访部顺一','吉野裕行','中原麻衣','吉原正行','今泉贤一','伊藤秀树','佐土原武之','菅沼芙实彦','菅正太郎','桧垣亮','森见登美彦','铃村健一','真殿光昭','川尻善昭','滨崎博嗣','太田雅彦','松尾衡','宍户淳','细田雅弘','渡边正彦','松村康弘','佐藤英一','外崎春雄','池田重隆','有富兴二','木宫茂','高田淳','远藤卓司','冈崎幸男','杉原研二','五十岚皋','吉野智美','今敏','平尾隆之','高桥敦史','内海贤二','关俊彦','饭塚昭三','桃井晴子','池田真美子','横谷昌宏','佐藤顺一','吉崎观音','子安武人','中田让治','小樱悦子','藤原启治','石田彰','广桥凉','池泽春菜','平松晶子','川上伦子','草尾毅') LIMIT 0,32 [ RunTime:0.019106s ]
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.002121s ]
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.001732s ]
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.001923s ]
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,1 [ RunTime:0.002250s ]
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_id` DESC LIMIT 0,6 [ RunTime:0.000685s ]
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','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.003833s ]