黄子华饰演的警察在一次抢劫案被车撞击导致半身不遂,同案中负责为歹徒开车的流氓李修贤则中枪变成植物人。黄子华不想象废人般过下半生,在智慧老人夺舍后变身的吴倩莲指导下,利用李修贤的躯体重生。不料李修贤原来是个可恶的人渣,在他家乡大屿山恶名远播。新的李修贤却聪明灵俐而有正义感,光 看他如何还债及重获三个老婆的芳心便趣味十足。知道内情的妹妹蔡少芬公开单恋哥哥,以及黄子华每次对李家的女人想入非非便要上厕所等成人趣味的安排也乐而不淫,颇令人有意外惊喜之感。
夺舍,在道教中指夺取别人的身体驱壳以求得生存。警官Tommy(黄子华饰)最喜欢哼的一句歌就是:“Tell Laura I love her。”,他的女友Laura也是警察,喜欢周华健,家里有一个华健的纸板人像。Tommy在和匪徒的交战中被车撞击导致下身瘫痪,大小便失禁。“夺舍”成功的吴倩莲原来是失意女子从楼上...
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` = 6355 AND `vod_status` = 1 LIMIT 1 [ RunTime:0.001414s ]
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.001129s ]
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.000647s ]
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_cid` IN ('17','18','19','20','21','25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75') AND `actors_name` = '葛静' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_hits_month` DESC LIMIT 0,9 [ RunTime:0.003214s ]
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_cid` IN ('25','26','27','28','29','30','31','32','33','66','67','68','69','70','71','72','73','74','75','17','18','19','20','21') AND `actors_name` = '葛静' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_hits_month` DESC LIMIT 0,3 [ RunTime:0.003276s ]
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` = 6355 AND `lines_status` = 1 ORDER BY `lines_addtime` DESC LIMIT 0,3 [ RunTime:0.001079s ]
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` = 6355 AND `music_status` = 1 ORDER BY `music_addtime` DESC LIMIT 0,3 [ RunTime:0.001093s ]
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.000985s ]
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_id` <> '6355' AND `actors_name` = 'Array' AND `actors_type` = 1 AND `vod_status` = '1' GROUP BY `actors_id` ORDER BY `vod_addtime` DESC LIMIT 0,6 [ RunTime:0.001278s ]