SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'liudehua' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001318s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '刘德华' [ RunTime:0.001656s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (14762,11298,6700,13739,13140,12017,4531,11453,11450,11186,6843,10711,10125,10075,10015,9199,14966,14982,15487,15817,15830,16044,16167,16367,16585,16631,16916,17041,18095,18755,19766,38075,37083,26642,26654,27480,32922) [ RunTime:0.002925s ]
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 ('','邱淑贞','程东','成奎安','王晶','李子雄','吴孟达','关之琳','周星驰','梁柏坚','樊志刚','方中信','吴倩莲','韦家辉','杜琪峰','梁咏琪','古天乐','刘青云','钟继昌','林超荣','邱礼涛','袁洁莹','毛舜筠','梁朝伟','司徒安','陈惠敏','姚炜','简慧真','万梓良','叶伟忠','阮世生','徐达初','潘文杰','王钟','罗美薇','莫少聪','黄小庄','张志光','哈智超','罗耀辉','冯德伦','让·雷诺','杨祐宁','张静初','舒淇','江均','洪金宝','冯嘉怡','李勤勤','朱雨辰','南燕','郑则仕','龙方','黎姿','何家劲','徐锦江','李美凤','麦当杰','麦当雄','萧若元','曾瑾昌','陈法蓉','黄秋生','王杰','向华胜','元奎','黄智强','陈玉莲','谭咏麟','陈木胜','刘江','朱铁和','陈文强','刘国昌','张敏','郭富城','林岭东','秦沛','姜大卫','石田纯一','钟楚红','庹宗华','孙鹏','吴念真','杜国威','许鞍华','叶德娴','周海媚','韦基舜','黄泰来','仙杜拉','罗烈','吴家丽','马斯晨','林建明','倪雪','梁本熙','迂凡','陈国新','陈德容','周润发','王祖贤','向华强','吕秀菱','岳翎','方刚','柯受良','黎大炜','黎杰','关秀媚','吴毅将','张学友','陈冠希','余文乐','林苑','黄精甫','杜致朗','张国荣','宁静','李蕙敏','吴兴国','邹凯光','邵丽琼','陈百祥','陈松勇','李嘉欣','张家辉','张坚庭','翁虹','信息','常盘贵子','因泰拉·贾龙珀拉','陈荣宗','潘源良','李仁港','Thomas','James','Hudak','Jr.','张耀扬','刘伟强','刘嘉玲','李冰冰','梁家辉','邓超','徐克','张家鲁','倪妮','谢君豪','姜皓文','李敏','李昇','曾志伟','陈慧琳','麦兆辉','庄文强','王家卫','张曼玉','尔冬升','罗志良','钱嘉乐','吴大维','高振伟','萧荣','刘家良','刘家辉','季天笙','郑少秋') AND `star_status` = 1 ORDER BY field(star_name,'','','','邱淑贞','程东','成奎安','王晶','李子雄','吴孟达','关之琳','周星驰','梁柏坚','樊志刚','方中信','吴倩莲','韦家辉','杜琪峰','梁咏琪','古天乐','刘青云','钟继昌','林超荣','邱礼涛','袁洁莹','毛舜筠','梁朝伟','司徒安','陈惠敏','姚炜','简慧真','万梓良','叶伟忠','阮世生','徐达初','潘文杰','王钟','罗美薇','莫少聪','黄小庄','张志光','哈智超','罗耀辉','冯德伦','让·雷诺','杨祐宁','张静初','舒淇','江均','洪金宝','冯嘉怡','李勤勤','朱雨辰','南燕','郑则仕','龙方','黎姿','何家劲','徐锦江','李美凤','麦当杰','麦当雄','萧若元','曾瑾昌','陈法蓉','黄秋生','王杰','向华胜','元奎','黄智强','陈玉莲','谭咏麟','陈木胜','刘江','朱铁和','陈文强','刘国昌','张敏','郭富城','林岭东','秦沛','姜大卫','石田纯一','钟楚红','庹宗华','孙鹏','吴念真','杜国威','许鞍华','叶德娴','周海媚','韦基舜','黄泰来','仙杜拉','罗烈','吴家丽','马斯晨','林建明','倪雪','梁本熙','迂凡','陈国新','陈德容','周润发','王祖贤','向华强','吕秀菱','岳翎','方刚','柯受良','黎大炜','黎杰','关秀媚','吴毅将','张学友','陈冠希','余文乐','林苑','黄精甫','杜致朗','张国荣','宁静','李蕙敏','吴兴国','邹凯光','邵丽琼','陈百祥','陈松勇','李嘉欣','张家辉','张坚庭','翁虹','信息','常盘贵子','因泰拉·贾龙珀拉','陈荣宗','潘源良','李仁港','Thomas','James','Hudak','Jr.','张耀扬','刘伟强','刘嘉玲','李冰冰','梁家辉','邓超','徐克','张家鲁','倪妮','谢君豪','姜皓文','李敏','李昇','曾志伟','陈慧琳','麦兆辉','庄文强','王家卫','张曼玉','尔冬升','罗志良','钱嘉乐','吴大维','高振伟','萧荣','刘家良','刘家辉','季天笙','郑少秋') LIMIT 0,6 [ RunTime:0.017699s ]
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.003096s ]
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.002250s ]
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.002879s ]
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.002790s ]
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.006946s ]
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` = '' AND `star_status` = 1 ORDER BY field(star_name,'','','') LIMIT 0,6 [ RunTime:0.001382s ]