SELECT * FROM `zanpiancms_part` `part` LEFT JOIN `zanpiancms_story` `story` ON `story`.`story_vid`=`part`.`part_vid` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`part`.`part_vid` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`part`.`part_vid` WHERE `part_oid` = 3 AND `vod_id` = '29992' AND `part_status` = 1 LIMIT 1 [ RunTime:0.002297s ]
SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_wwm`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_xz`,`star_xx`,`star_area`,`star_zy`,`star_up`,`star_down`,`star_label`,`star_pinyin`,`star_jumpurl`,`star_hits` FROM `zanpiancms_star` WHERE `star_name` IN ('赵弈钦','沈羽洁','方晓东','郭嘉语','王泽轩') [ RunTime:0.013823s ]
SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_wwm`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_xz`,`star_xx`,`star_area`,`star_zy`,`star_up`,`star_down`,`star_label`,`star_pinyin`,`star_jumpurl`,`star_hits` FROM `zanpiancms_star` WHERE `star_name` = '初的见' [ RunTime:0.001222s ]
SELECT `part`.*,`story`.*,`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_part` `part` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`part`.`part_vid` LEFT JOIN `zanpiancms_story` `story` ON `story`.`story_vid`=`part`.`part_vid` WHERE `part_vid` = 29992 AND `part_status` = 1 ORDER BY `part_oid` ASC [ RunTime:0.006769s ]
SELECT `role_id`,`role_cid`,`role_vid`,`role_name`,`role_star` FROM `zanpiancms_role` WHERE `role_vid` = 29992 [ RunTime:0.001878s ]
SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_wwm`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_xz`,`star_xx`,`star_area`,`star_zy`,`star_up`,`star_down`,`star_label`,`star_pinyin`,`star_jumpurl`,`star_hits` FROM `zanpiancms_star` WHERE `star_name` = '赵弈钦' [ RunTime:0.001249s ]
SELECT `star_id`,`star_pid`,`star_cid`,`star_name`,`star_bm`,`star_wwm`,`star_pic`,`star_pic_thumb`,`star_pic_big`,`star_xb`,`star_sg`,`star_tz`,`star_mz`,`star_cstime`,`star_school`,`star_gs`,`star_xz`,`star_xx`,`star_area`,`star_zy`,`star_up`,`star_down`,`star_label`,`star_pinyin`,`star_jumpurl`,`star_hits` FROM `zanpiancms_star` WHERE `star_name` = '方晓东' [ RunTime:0.001591s ]
SELECT `story_id`,`story_cid`,`vod_id`,`vod_cid`,`vod_name`,`vod_pinyin` FROM `zanpiancms_story` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`story_vid` WHERE `story_status` = 1 AND `story_id` > 2974 ORDER BY `story_id` ASC LIMIT 1 [ RunTime:0.001422s ]
SELECT `story_id`,`story_cid`,`vod_id`,`vod_cid`,`vod_name`,`vod_pinyin` FROM `zanpiancms_story` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`story_vid` WHERE `story_status` = 1 AND `story_id` < 2974 ORDER BY `story_id` DESC LIMIT 1 [ RunTime:0.003535s ]
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,4 [ RunTime:0.004033s ]
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_mcid` RIGHT JOIN `zanpiancms_vod` `w` ON `w`.`vod_id`=`mcid_id` WHERE `mcid_mid` = 62 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,6 [ RunTime:0.003419s ]
