SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'luojiaying' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001356s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '罗家英' [ RunTime:0.001170s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (2227,4526,4533,9037,10062,10180,10228,10258,10878,10920,11282,11502,11674,12386,15176,15337,16401,16575,17074,17564,18032,19157,21219,26608,27452,34491,36998) [ RunTime:0.003490s ]
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.016352s ]
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.002844s ]
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.003310s ]
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.002161s ]
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.002240s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count 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` ) `_group_count_` LIMIT 1 [ RunTime:0.001489s ]
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_addtime` DESC LIMIT 0,32 [ RunTime:0.003255s ]
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.006954s ]