SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'guanzhilin' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001011s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '关之琳' [ RunTime:0.001069s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (4531,6754,10180,10843,11035,11092,11453,12989,13739,14665,15260,15484,16480,16622,17815,18755,18849,21817,30928) [ RunTime:0.001901s ]
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.','张耀扬','刘伟强','吕良伟','吴启华','方中信','陆剑明','李修贤','黄光亮','弗农·威尔斯','奥丽维娅·赫西','南燕','龙添武','Deborah','Grant','鲁亦诗') AND `star_status` = 1 ORDER BY field(star_name,'邱淑贞','程东','成奎安','王晶','李子雄','吴孟达','周星驰','刘德华','徐克','郭晋安','郑则仕','莫少聪','赵文卓','李连杰','金城武','杨采妮','罗家英','程小东','林伟伦','邵丽琼','司徒卓汉','林纪陶','黄泰来','李殿朗','张学友','黎明','叶广俭','袁若光','方志豪','袁和平','仇云波','郑裕玲','吴大维','甄子丹','龙逸升','李丽丽','陈观泰','何家劲','惠英红','向华胜','元奎','黄智强','陈玉莲','谭咏麟','张炭','洪金宝','赵长军','杨丽菁','杨凡','狄龙','林岭东','秦沛','姜大卫','吴倩莲','司徒慧焯','钟少雄','倪大红','张光北','张丰毅','周润发','柯俊雄','陈欣健','黄锦燊','刘成汉','林青霞','李嘉欣','邓碧燕','陈天璇','郑少秋','利智','刘嘉玲','王小凤','区丁平','文隽','邱戴安平','张锦满','万梓良','张卫健','范秀明','陈永祥','吴锦源','吴伟硕','任达华','叶童','叶玉卿','尹扬明','钱永强','张祖儿','刘善民','舒淇','Thomas','James','Hudak','Jr.','张耀扬','刘伟强','吕良伟','吴启华','方中信','陆剑明','李修贤','黄光亮','弗农·威尔斯','奥丽维娅·赫西','南燕','龙添武','Deborah','Grant','鲁亦诗') LIMIT 0,6 [ RunTime:0.014113s ]
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.002320s ]
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.002319s ]
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.001911s ]
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.001558s ]
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.002338s ]