Movielogr

Home

movie poster

Average Rating: 8.5/10

View on: IMDb | TMDb

Infernal Affairs (2002)

Directed by Andrew Lau, Alan Mak

Most recently watched by sleestakk

Overview

Chan Wing Yan, a young police officer, has been sent undercover as a mole in the local mafia. Lau Kin Ming, a young mafia member, infiltrates the police force. Years later, their older counterparts, Chen Wing Yan and Inspector Lau Kin Ming, respectively, race against time to expose the mole within their midst.

Rated R | Length 101 minutes

Actors

Tony Leung Chiu-Wai | Edison Chen | Andy Lau | Eric Tsang | Anthony Wong | Kelly Chen | Shawn Yue | Gordon Lam Ka-Tung | Sammi Cheng | Chapman To | Courtney Wu | Tony Ho | Elva Hsiao | Dion Lam | Tam Kon-Chung | Wan Chi-keung | Addy Sung Gam-Loi | Berg Ng Ting-Yip | Simon Cheung Yuk-San | Wong Chi-Wang | Lai Chi-Wai | Chow Pok-Foo | So Wai-Nam | Au Hin-Wai | Benjamin Yuen Wai-Ho | Ho Chung-Wai | Hui Kam-Fung | Victy Wong | Yiu Man-Kei | Terry Lee Ji-Ming | Wong Kam-Hung | Lee Tin-Cheung | Simon Yu Sai-Tang | Tenny Chang Kin-Yung | Leung Ho-Kai | Chin Yiu-Wing | Che Jan-Bong | Alex Lee Yip-Kin | Kui Mei-Yee | Chaucharew Wichai | Cheng Wing Yee | Lee Wah-Chu | Mak Wai-Gok | Hui On-Tat | Ho Wing-Ning | Leung Chiu-Yee

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0208
Total Execution Time  0.0223
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4815
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0045 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5c63e7dda8ad846f1b707d27edd49878', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
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` = 4815
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0022   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filename, GROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directors, GROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_ids, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_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` `MP` ON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMD` ON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4815
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0004   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4815
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4815 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 19 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)