SELECT * FROM `zanpiancms_star` WHERE `star_pinyin` = 'zhouxingchi' AND `star_status` = 1 LIMIT 1 [ RunTime:0.001597s ]
SELECT `actors_id` FROM `zanpiancms_actors` WHERE `actors_name` = '周星驰' [ RunTime:0.001099s ]
SELECT `actors_name` FROM `zanpiancms_actors` WHERE `actors_id` IN (2227,2678,4523,4524,4526,4531,4532,4533,4536,4713,17651,18828,19504,30618,31715,31720,31729) [ RunTime:0.001590s ]
SELECT COUNT(*) AS think_count FROM `zanpiancms_star` WHERE `star_name` IN ('','李力持','叶进','黄老邪','梁克逊','邓兆尊','曾守明','梁小熊','梁思浩','黄一飞','古明华','李健仁','于荣光','黄锦江','郑祖','陈宝莲','罗家英','袁咏仪','杜琪峰','卢海鹏','苑琼丹','梅艳芳','黄秋生','吴孟达','张曼玉','曾江','顾美华','陈观泰','胡慧中','方中信','朱咪咪','梁家仁','秦沛','吴家丽','施念慈','曾近荣','李兆基','吴志雄','叶竞生','段伟伦','卢惠光','关秀媚','林熙蕾','吴君如','王晶','张家辉','胡枫','刘以达','邱淑贞','程东','成奎安','李子雄','关之琳','刘德华','张敏','陈欣健','周海媚','陈百祥','张达明','陈豪','黄伟文','林保怡','莫文蔚','葛民辉','张耀扬','陈国新','黄一山','周比利','郑家生','黎彼得','谷德昭','梁荣忠','张学友','林雪','古巨基','林国斌','钟丽缇','王宝强','鄂靖文','张全蛋','景如洋','张琪','邱礼涛','江玉仪','李思臻','赵博君','李修贤','何家驹','黄光亮','黄柏文','冯瑞熊','历苏','林正英','陈山河','陈龙','陈会毅','黄炳耀','吴镇宇','罗慧娟','蓝洁瑛','刘家豪','张华标','柏安妮','林俊贤','何东','左颂升','朱茵','张莽','卢雄','谭淑梅','黄智贤','周志辉','侯焕玲') AND `star_status` = 1 LIMIT 1 [ RunTime:0.016798s ]
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,32 [ RunTime:0.017060s ]
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.003385s ]
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.003655s ]
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.002584s ]
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.002153s ]
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_status` = 1 ORDER BY `star_hits_day` DESC LIMIT 0,6 [ RunTime:0.001939s ]