SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'wumengda' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001144s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '吴孟达' [ RunTime:0.001556s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (2678,4524,4531,4536,4564,4713,9212,9473,10092,10817,10843,10910,11278,11384,11700,12017,13140,17133,18003,18757,19824,30618,31716,31720,32947,34491,38079) [ RunTime:0.003648s ]
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.026684s ]
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.004234s ]
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.003679s ]
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.003079s ]
SELECT COUNT(*) AS think_count FROM `zanpiancms_role` `role` LEFT JOIN `zanpiancms_vod` `v` ON `v`.`vod_id`=`role`.`role_vid` WHERE `role_star` = '吴孟达' AND `role_status` = 1 LIMIT 1 [ RunTime:0.002079s ]
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_addtime` DESC LIMIT 0,12 [ RunTime:0.004660s ]
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.008790s ]