在浪漫壮观、引人遐思的古希腊，奥林匹亚众神与人类之间的爱恨传奇至今为人津津乐道，而在这其中，荷马史诗《伊里亚特》所记录的特洛伊之战更是后世剧作家与观者反复演绎的经典作品。当特洛伊王子帕里斯（奥兰多·布鲁姆 Orlando Bloom 饰）受希腊斯巴达国王之邀赴宴之际，却迷恋上了国王的妻子海伦（黛安·克鲁格 Diane Kruger 饰），对方倾国倾城的容貌让他不能自已，遂将海伦带回自己的国家。此举引发了希腊诸国的愤怒，在迈锡尼国王阿伽门侬（布莱恩·考克斯 Brian Cox 饰）的号召下，一支强大的联军浩浩荡荡向特洛伊挺进。在随后长达十年的战争中，阿喀琉斯（布拉德·皮特 Brad Pitt 饰）、奥德修斯（肖恩·宾 Sean Bean 饰）、赫克托尔（艾瑞克·巴纳 Eric Bana 饰）等英雄各逞英豪，谱写了荡气回肠却又令人扼腕唏嘘的传奇史诗……
...
SELECT * FROM `zanpiancms_vod` `vod` LEFT JOIN `zanpiancms_actor` `actor` ON `actor`.`actor_vid`=`vod`.`vod_id` LEFT JOIN `zanpiancms_story` `story` ON `story`.`story_vid`=`vod`.`vod_id` WHERE `vod_id` = 9288 AND `vod_status` = 1 LIMIT 1 [ RunTime:0.002167s ]
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.000792s ]
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.000437s ]
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` DESC LIMIT 0,2 [ RunTime:0.000513s ]
SELECT `lines`.*,`role`.*,`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_lines` `lines` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`lines_vid` LEFT JOIN `zanpiancms_role` `role` ON `role`.`role_name`=lines_role and role.role_vid = lines_vid WHERE `lines_vid` = 9288 AND `lines_status` = 1 ORDER BY `lines_addtime` DESC LIMIT 0,3 [ RunTime:0.000807s ]
SELECT `music`.*,`star`.*,`vod_id`,`vod_pid`,`vod_cid`,`vod_mcid`,`vod_name`,`vod_aliases`,`vod_label`,`vod_pic`,`vod_pic_thumb`,`vod_pic_big`,`vod_title`,`vod_color`,`vod_actor`,`vod_director`,`vod_content`,`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_music` `music` LEFT JOIN `zanpiancms_vod` `vod` ON `vod`.`vod_id`=`music_vid` LEFT JOIN `zanpiancms_star` `star` ON `star`.`star_name`=`music_star` WHERE `music_vid` = 9288 AND `music_status` = 1 ORDER BY `music_addtime` DESC LIMIT 0,3 [ RunTime:0.000895s ]
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.000765s ]
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` = 30 AND `vod_status` = '1' ORDER BY `vod_addtime` DESC LIMIT 0,6 [ RunTime:0.004646s ]
