Movielogr

movie poster

Average Rating: 5/10

View on: IMDb | TMDb

New Police Story (2004)

Directed by Benny Chan

Most recently watched by sensoria

Overview

Sent into a drunken tailspin when his entire unit is killed by a gang of thrill-seeking punks, disgraced Hong Kong police inspector Wing needs help from his new rookie partner, with a troubled past of his own, to climb out of the bottle and track down the gang and its ruthless leader.

Rated R | Length 123 minutes

Actors

Jackie Chan | Wing Wong Wing | Andy On | Charlene Choi | Daniel Wu | Charlie Yeung | Nicholas Tse | Tak-bun Wong | Ken Lo | Terence Yin | Eason Chan | Philip Ng Wan-Lung | Liu Kai-chi | John Shum | Tats Lau | Yu Rong-Guang | Steven Cheung | Andrew Lin | Kenny Kwan | Winnie Leung | Carl Ng | Tony Ho | Roderick Lam | Wu Hao-kang | Mandy Chiang | Sun Chun | Asuka Higuchi | Anthony Carpio | Wu Bai | Luk Mei-Ling | Mak Cheung-Ching | Timmy Hung | Hiro Hayama | Park Hyun-Jin | Vincent Chik Miu-Chan | Samuel Pang | Coco Chiang Yi | Lee Ting-Fung | Tony Wong Yuk-Long | Lisa Lui Yau-Wai | Chun Lam | Eddie Li | Brenda Chan Kwai-Fan | Wong Chi-Wang | Heaven Ho Yat-Wah | Chan Tat-Kwong | Cheuk Wai-Man | Eric Kwok Wai-Leung | Cash Lee Chi-Keung | Dave Wong Kit | Au Hin-Wai | Maggie Fung Sze-Ting | He Jun | Wu Gang | Victy Wong | Koey Wong | Tai Yiu-Ming | Yip Chi-Ting | Lau Ho-Ngai | Wong Kam-Hung | Lee Tin-Cheung | Eddie Ho Wai-Yip | Joyce Lau Ho-Yan | Sandy Leung Man-Yi | Lau Ho-Chun | Martin Ma Tit-Leung | Leung Ho-Kai | Stephen Choi Bung-Kou | Sammy Hung | Nic Yan Si-Yue | Cheung Shek | Chong Yan-Ling | Pang Hoi-Kwan | Phoebe Tang Yun-Man | Alex Lee Yip-Kin | Jason Yip Wan-Keung | Monnie Chim Sau-Gwan | Fanny Yeung Cheung-Ha | Yoki Man Si-Kei | Cheung Hak | Louisa Ng Wai-Bing | Lam Chi-Pok | Ada To Chiu-Hung | Ringo Chen King | Chiu Man-Tung | Raymond Yu Siu-lun | Liu Jia | Lam Wai-Pen | Akai Lee Kai-Kit | Zac Koo Hau-Zheng | Lam Chi-Tai | Chung-yue Chiu | Tsang Kin-Yong | Ken Ling Hiu-Wa | Chan Wai-Ling | Lee Ji-Kei | Lee Wai-Leung | Cody Wong Hoi-Bik | Audio Traffic | Stephen Bohn | Stephen Julien | Tin-Chiu Hung

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0218
Total Execution Time  0.0231
  GET DATA  
No GET data exists
  MEMORY USAGE  
529,240 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2061
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0044 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2061
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0023   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM 
`ml_movie_titles` `MT`
LEFT JOIN `ml_movie_posters` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 2061
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0003   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2061
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2061 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 12 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)