SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'zhangchunzhong' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001639s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '张春仲' [ RunTime:0.001195s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (327,10808,12459,15247,16092,19572,25354,33035,34907) [ RunTime:0.001077s ]
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.008254s ]
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 `actors_name` = '张春仲' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_id` DESC LIMIT 0,12 [ RunTime:0.001756s ]
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.001664s ]
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.002277s ]
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.002142s ]
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,6 [ RunTime:0.005041s ]