SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'zechengmeixue' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001324s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '泽城美雪' [ RunTime:0.000869s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (16709,16770,16783,19278,18997,19999,20100,20330,20643,20689,20890,38529,22276,33428,31862) [ RunTime:0.001654s ]
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 ('潘惠美','伊濑茉莉也','藤原启治','浪川大辅','川口敬一郎','岸间信明','富坚义博','本乡奏多','三森铃子','成田剑','大川透','渡边琴乃','细川秀树','野上和男','川越崇弘','加藤诚','江副仁美','斋藤德明','黑田洋介','井上淳哉','矢岛晶子','楢桥美纪','森川智之','兴梠里美','桥本昌和','臼井仪人','杉田智和','伊达朱里纱','伊东健人','梶裕贵','平池芳正','古贺一臣','筱塚智子','大谷育江','铃木达央','钉宫理惠','杉山纪彰','户松遥','下野纮','柿原彻也','早水理沙','山本宽','吉冈忍','平向智子','镰仓由实','森义博','山内东生雄','土屋浩幸','高岛大辅','日色如夏','仓田英之','高桥龙也','本田透','松冈祯丞','石川由依','木村良平','细谷佳正','中野英明','古怒田健志','久尾步','花田陵','阿澄佳奈','三木真一郎','神谷浩史','喜多村英梨','新房昭之','板村智幸','宫本幸裕','久保山英一','冈田坚二朗','木泽行人','中本宗应','东富耶子','西尾维新','能登麻美子','福山润','中村悠一','日高政光','吉村清子','森田繁','阿部敦','金元寿子','西田雅一','植田佳奈','江崎慎平','Nitro+','海法紀光','斋藤千和','加藤英美里','花泽香菜','尾石达也','德本善信','铃木利正','美甘义人','大沼心','堀江由衣','樱井孝宏','深濑重','安食圭','大桥一辉','铃木拓磨','石原夏织','日高里菜','小仓唯','野中蓝','村川梨衣','Lynn','内山夕实','田野麻美','小林优','山本希望','锦织博','川崎丰','浅见隆司','吉泽翠','大谷肇','早见沙织','井口裕香','古川登志夫','野泽雅子','岩井隆央','三塚雅人','竹下健一','小川孝治','藤井雪代','庄司宇芽香','横谷昌宏','野村祐一','吉野弘幸','大野木宽','更多...','飞田刚','井上亚树子') AND `star_status` = 1 ORDER BY field(star_name,'潘惠美','伊濑茉莉也','藤原启治','浪川大辅','川口敬一郎','岸间信明','富坚义博','本乡奏多','三森铃子','成田剑','大川透','渡边琴乃','细川秀树','野上和男','川越崇弘','加藤诚','江副仁美','斋藤德明','黑田洋介','井上淳哉','矢岛晶子','楢桥美纪','森川智之','兴梠里美','桥本昌和','臼井仪人','杉田智和','伊达朱里纱','伊东健人','梶裕贵','平池芳正','古贺一臣','筱塚智子','大谷育江','铃木达央','钉宫理惠','杉山纪彰','户松遥','下野纮','柿原彻也','早水理沙','山本宽','吉冈忍','平向智子','镰仓由实','森义博','山内东生雄','土屋浩幸','高岛大辅','日色如夏','仓田英之','高桥龙也','本田透','松冈祯丞','石川由依','木村良平','细谷佳正','中野英明','古怒田健志','久尾步','花田陵','阿澄佳奈','三木真一郎','神谷浩史','喜多村英梨','新房昭之','板村智幸','宫本幸裕','久保山英一','冈田坚二朗','木泽行人','中本宗应','东富耶子','西尾维新','能登麻美子','福山润','中村悠一','日高政光','吉村清子','森田繁','阿部敦','金元寿子','西田雅一','植田佳奈','江崎慎平','Nitro+','海法紀光','斋藤千和','加藤英美里','花泽香菜','尾石达也','德本善信','铃木利正','美甘义人','大沼心','堀江由衣','樱井孝宏','深濑重','安食圭','大桥一辉','铃木拓磨','石原夏织','日高里菜','小仓唯','野中蓝','村川梨衣','Lynn','内山夕实','田野麻美','小林优','山本希望','锦织博','川崎丰','浅见隆司','吉泽翠','大谷肇','早见沙织','井口裕香','古川登志夫','野泽雅子','岩井隆央','三塚雅人','竹下健一','小川孝治','藤井雪代','庄司宇芽香','横谷昌宏','野村祐一','吉野弘幸','大野木宽','更多...','飞田刚','井上亚树子') LIMIT 0,6 [ RunTime:0.016910s ]
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.004400s ]
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.002386s ]
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.002495s ]
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.001694s ]
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.007136s ]