SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'huangyishan' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001332s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '黄一山' [ RunTime:0.001079s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (4536,4713,9337,10572,11543,11886,12089,15004,17358,17835,18171,19471,19611,30287,33713,35448,35925,38557) [ RunTime:0.001698s ]
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 ('张耀扬','吴孟达','张敏','周星驰','陈国新','苑琼丹','秦沛','周比利','郑家生','黎彼得','谷德昭','梁荣忠','张学友','林雪','黄一飞','郑祖','古巨基','李力持','林国斌','钟丽缇','王泽丰','叶念琛','刘锡明','翁虹','吴启华','孙耀威','肖荣','钱道远','熊欣欣','陈卓','李若彤','季天笙','朱凌锋','彭禺厶','赵闪闪','李健仁','盛英豪','柳航','杨能','朱咪咪','施扬平','朱岩','刘国伟','张鑫炎','邱建国','靳德茂','计春华','王群','翟星月','秦汉擂','刘汉兆','王韬','冯靖乔','余少群','何杜娟','周子扬','马敬涵','梁杰','周浩晖','贺刚','张全蛋','金宁','崔冬辰','房映华','杨子鸣','李立刚','徐少强','高广泽','房立超','岳昊','林正英','王祖贤','成奎安','黄秋生','叶成康','何东','刘忆单','赫富有','彭小龙','文影','胡雪文','何莲洲','林建明','王强','石班瑜','元秋','陈奕名','何文辉','南笙','谢苗','周枫平','Ma','Zhongxuan','马中轩','赵国燕王','景东','黄莞乔','王涵','陈子晞','谢其均','冯一村','马毅','杜玉明','孙子钧','许慧强','吕熙') AND `star_status` = 1 ORDER BY field(star_name,'张耀扬','吴孟达','张敏','周星驰','陈国新','苑琼丹','秦沛','周比利','郑家生','黎彼得','谷德昭','梁荣忠','张学友','林雪','黄一飞','郑祖','古巨基','李力持','林国斌','钟丽缇','王泽丰','叶念琛','刘锡明','翁虹','吴启华','孙耀威','肖荣','钱道远','熊欣欣','陈卓','李若彤','季天笙','朱凌锋','彭禺厶','赵闪闪','李健仁','盛英豪','柳航','杨能','朱咪咪','施扬平','朱岩','刘国伟','张鑫炎','邱建国','靳德茂','计春华','王群','翟星月','秦汉擂','刘汉兆','王韬','冯靖乔','余少群','何杜娟','周子扬','马敬涵','梁杰','周浩晖','贺刚','张全蛋','金宁','崔冬辰','房映华','杨子鸣','李立刚','徐少强','高广泽','房立超','岳昊','林正英','王祖贤','成奎安','黄秋生','叶成康','何东','刘忆单','赫富有','彭小龙','文影','胡雪文','何莲洲','林建明','王强','石班瑜','元秋','陈奕名','何文辉','南笙','谢苗','周枫平','Ma','Zhongxuan','马中轩','赵国燕王','景东','黄莞乔','王涵','陈子晞','谢其均','冯一村','马毅','杜玉明','孙子钧','许慧强','吕熙') LIMIT 0,6 [ RunTime:0.013232s ]
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.002483s ]
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.001774s ]
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.002650s ]
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.002393s ]
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.006828s ]