SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'tianzhonglihui' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001657s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '田中理惠' [ RunTime:0.000891s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (16947,18981,22233,22330,31634,31642,33712,34143,34149,34234) [ RunTime:0.001503s ]
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 ('福山润','野岛健儿','佐藤利奈','野上尤加奈','吉浦康裕','大川透','后藤邑子','石井真','中原麻衣','小林智树','元永庆太郎','天冲','木宫茂','细田直人','铃木利正','小林孝志','小林公二','中村和久','池上太郎','松本佳久','渡边正彦','佐藤真二','待田堂子','长津晴子','田村龙','真岛浩一','白石凉子','钉宫理惠','伊藤静','高桥美佳子','川口敬一郎','渡边慎一','川越淳','则座诚','三浦贵博','博史池畠','小高义规','桥口洋介','武上纯希','猪爪慎一','高桥奈津子','浦泽义雄','畑健二郎','铃村健一','坂本真绫','池田秀一','关俊彦','福田己津央','谷田部胜义','西村大树','高田昌宏','鸟羽聪','西山明树彦','久保山英一','丝贺慎太郎','两泽千晶','吉野弘幸','大野木宽','野村祐一','森田繁','兵头一步','矢立肇','富野由悠季','竹达彩奈','早见沙织','长泽刚','小鹿りえ','丸川直子','内山昂辉','筱原俊哉','市村彻夫','古川知宏','安斋刚文','政木伸一','太田知章','平向智子','大西景介','安藤健','荻原规子','横手美智子','田村由香里','小伏伸之','丰口惠美','真殿光昭','成田剑','三瓶由布子','小野坂昌也','桑谷夏子','杉田智和','寿美菜子','浅野真澄','安元洋贵','三宅健太','小山刚志','中田让治','新谷良子','楠见尚己','速水奖','楠大典','清水爱','白石稔','宫下荣治','又吉爱','森永理科','平川大辅','大桥步夕','悠木碧','小清水亚美','斋藤千和','真堂圭','水上清资','浦畑达彦','高桥健司','井端义秀','安藤正臣','三好正人','田边泰裕','青井小夜','江岛泰男','曾我准','井上麻里奈','新田惠海','东山奈央','黑田崇矢','小野大辅','小林优','名冢佳织','川上稔','砂山藏澄','子安武人','田村睦心','泽城美雪','茅原实里','渡边哲哉','宅野诚起','石黑恭平','小野学','熊谷纯','田口智久','绿川光','鸟海浩辅','石田彰','秋田谷典昭') AND `star_status` = 1 ORDER BY field(star_name,'福山润','野岛健儿','佐藤利奈','野上尤加奈','吉浦康裕','大川透','后藤邑子','石井真','中原麻衣','小林智树','元永庆太郎','天冲','木宫茂','细田直人','铃木利正','小林孝志','小林公二','中村和久','池上太郎','松本佳久','渡边正彦','佐藤真二','待田堂子','长津晴子','田村龙','真岛浩一','白石凉子','钉宫理惠','伊藤静','高桥美佳子','川口敬一郎','渡边慎一','川越淳','则座诚','三浦贵博','博史池畠','小高义规','桥口洋介','武上纯希','猪爪慎一','高桥奈津子','浦泽义雄','畑健二郎','铃村健一','坂本真绫','池田秀一','关俊彦','福田己津央','谷田部胜义','西村大树','高田昌宏','鸟羽聪','西山明树彦','久保山英一','丝贺慎太郎','两泽千晶','吉野弘幸','大野木宽','野村祐一','森田繁','兵头一步','矢立肇','富野由悠季','竹达彩奈','早见沙织','长泽刚','小鹿りえ','丸川直子','内山昂辉','筱原俊哉','市村彻夫','古川知宏','安斋刚文','政木伸一','太田知章','平向智子','大西景介','安藤健','荻原规子','横手美智子','田村由香里','小伏伸之','丰口惠美','真殿光昭','成田剑','三瓶由布子','小野坂昌也','桑谷夏子','杉田智和','寿美菜子','浅野真澄','安元洋贵','三宅健太','小山刚志','中田让治','新谷良子','楠见尚己','速水奖','楠大典','清水爱','白石稔','宫下荣治','又吉爱','森永理科','平川大辅','大桥步夕','悠木碧','小清水亚美','斋藤千和','真堂圭','水上清资','浦畑达彦','高桥健司','井端义秀','安藤正臣','三好正人','田边泰裕','青井小夜','江岛泰男','曾我准','井上麻里奈','新田惠海','东山奈央','黑田崇矢','小野大辅','小林优','名冢佳织','川上稔','砂山藏澄','子安武人','田村睦心','泽城美雪','茅原实里','渡边哲哉','宅野诚起','石黑恭平','小野学','熊谷纯','田口智久','绿川光','鸟海浩辅','石田彰','秋田谷典昭') LIMIT 0,6 [ RunTime:0.012978s ]
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.003490s ]
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.002081s ]
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.001862s ]
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.001662s ]
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.001612s ]
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.004837s ]