SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'wangjing3' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001853s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '王晶' [ RunTime:0.001073s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (1437,4526,4531,9142,9248,9349,9405,9430,9473,9937,10134,10139,10692,10769,10786,11308,11332,11405,11453,11655,11681,12412,14232,15794,15817,15830,15919,16156,16160,16167,16631,16916,17041,17660,18029,18200,18295,18755,18862,19509,19564,19823,19824,20571,25373,27997,35146,35475,37072,37134,37196,37416) [ RunTime:0.002766s ]
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 ('谢霆锋','杜汶泽','Chapman','伍允龙','童飞','沈震轩','王敏德','张晋','许绍雄','吴辰君','高虎','景甜','To','周润发','苑琼丹','施念慈','曾近荣','李兆基','吴志雄','叶竞生','段伟伦','卢惠光','关秀媚','林熙蕾','吴君如','张家辉','周星驰','胡枫','罗家英','刘以达','邱淑贞','程东','成奎安','李子雄','吴孟达','关之琳','刘德华','刘仪伟','关悦','谢娜','孙天宇','黄磊','阮继志','蓝乃才','崔秀丽','狄威','张曼玉','钱小豪','张达明','陈国坤','Meng','Yao','孟瑶','佐伯俊道','曾志伟','早见优','泰迪·罗宾','陈百祥','谭咏麟','曹建南','舒淇','张可颐','罗嘉良','吴镇宇','黄子华','霍耀良','谢天华','彭丹','朱茵','刘青云','姜国民','徐锦江','邱意浓','云千千','文咏珊','林峯','古天乐','甄子丹','王爱玲','黄精甫','毛俊杰','胡然','洪金宝','安志杰','刘洋','陈法拉','任达华','苗侨伟','陈丽华','曾瑾昌','韦家辉','邓特希','司徒锦源','曾华倩','刘嘉玲','梁朝伟','麦子善','黄树棠','吴彦祖','丁晟','于荣光','孙红雷','尤勇智','黄秋生','刘烨','邓萃雯','龙方','王祖贤','李修贤','向华胜','元奎','黄智强','陈玉莲','吴倩莲','梁家辉','何嘉莉','冯德伦','周海媚','方中信','陈锦鸿','刘仕裕','郭秀云','陈山河','董骠','陈惠敏','夏文汐','黄光亮','邱月清','林立三','朱威廉','谭锐铭','万梓良','陈国新','陈德容','张敏','向华强','黄锦燊','刘雅丽','廖伟雄','杜少明','黄新','林权泽','陈小春','钟欣潼','余文乐','黄伊汶','林雪','钟少雄','梁咏琪','吴毅将','陈松勇','李嘉欣','黄泰来','叶德娴','张坚庭','翁虹','信息','黄日华','惠英红','戴良纯','顾冠忠','黎明','袁咏仪','郑则仕','冯淬帆','张学友','陈奕诗','萧荣','罗文','黄炳耀','李灿森','黄泆潼','姜皓文','Thomas','James','Hudak','Jr.','张耀扬','刘伟强','张兆辉','阚家伟','元彪','林正英','陈勋奇','陈龙','杜林宏','李彬','张宏刚','罗妞','王繁钦','陈法蓉','葛民辉','释小龙','方力申','司光敏','李佳佳','应采儿','甄琪','白客','苗苗','张颂文','宋洋','王奕权','黄苇','黄旻旻','陈乘风','李静睿','秦晔','雪灵之','桐华','杨欢','秦榛','檀健次','王弘毅','邓为','张晚意','杨紫','梅艳芳','陈友','叶童','钟镇涛','曹思诗','何浩文','林子聪','陈浩民','阙玥','郑伊健','何洁','王光利','文凯玲','周秀娜','徐若瑄','蔡洁') AND `star_status` = 1 ORDER BY field(star_name,'谢霆锋','杜汶泽','Chapman','伍允龙','童飞','沈震轩','王敏德','张晋','许绍雄','吴辰君','高虎','景甜','To','周润发','苑琼丹','施念慈','曾近荣','李兆基','吴志雄','叶竞生','段伟伦','卢惠光','关秀媚','林熙蕾','吴君如','张家辉','周星驰','胡枫','罗家英','刘以达','邱淑贞','程东','成奎安','李子雄','吴孟达','关之琳','刘德华','刘仪伟','关悦','谢娜','孙天宇','黄磊','阮继志','蓝乃才','崔秀丽','狄威','张曼玉','钱小豪','张达明','陈国坤','Meng','Yao','孟瑶','佐伯俊道','曾志伟','早见优','泰迪·罗宾','陈百祥','谭咏麟','曹建南','舒淇','张可颐','罗嘉良','吴镇宇','黄子华','霍耀良','谢天华','彭丹','朱茵','刘青云','姜国民','徐锦江','邱意浓','云千千','文咏珊','林峯','古天乐','甄子丹','王爱玲','黄精甫','毛俊杰','胡然','洪金宝','安志杰','刘洋','陈法拉','任达华','苗侨伟','陈丽华','曾瑾昌','韦家辉','邓特希','司徒锦源','曾华倩','刘嘉玲','梁朝伟','麦子善','黄树棠','吴彦祖','丁晟','于荣光','孙红雷','尤勇智','黄秋生','刘烨','邓萃雯','龙方','王祖贤','李修贤','向华胜','元奎','黄智强','陈玉莲','吴倩莲','梁家辉','何嘉莉','冯德伦','周海媚','方中信','陈锦鸿','刘仕裕','郭秀云','陈山河','董骠','陈惠敏','夏文汐','黄光亮','邱月清','林立三','朱威廉','谭锐铭','万梓良','陈国新','陈德容','张敏','向华强','黄锦燊','刘雅丽','廖伟雄','杜少明','黄新','林权泽','陈小春','钟欣潼','余文乐','黄伊汶','林雪','钟少雄','梁咏琪','吴毅将','陈松勇','李嘉欣','黄泰来','叶德娴','张坚庭','翁虹','信息','黄日华','惠英红','戴良纯','顾冠忠','黎明','袁咏仪','郑则仕','冯淬帆','张学友','陈奕诗','萧荣','罗文','黄炳耀','李灿森','黄泆潼','姜皓文','Thomas','James','Hudak','Jr.','张耀扬','刘伟强','张兆辉','阚家伟','元彪','林正英','陈勋奇','陈龙','杜林宏','李彬','张宏刚','罗妞','王繁钦','陈法蓉','葛民辉','释小龙','方力申','司光敏','李佳佳','应采儿','甄琪','白客','苗苗','张颂文','宋洋','王奕权','黄苇','黄旻旻','陈乘风','李静睿','秦晔','雪灵之','桐华','杨欢','秦榛','檀健次','王弘毅','邓为','张晚意','杨紫','梅艳芳','陈友','叶童','钟镇涛','曹思诗','何浩文','林子聪','陈浩民','阙玥','郑伊健','何洁','王光利','文凯玲','周秀娜','徐若瑄','蔡洁') LIMIT 0,6 [ RunTime:0.015060s ]
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.002002s ]
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.001537s ]
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.001630s ]
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.001137s ]
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.002185s ]
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.005066s ]