Movielogr

Home

movie poster

Average Rating: 9/10

View on: IMDb | TMDb

I Saw the Devil (2010)

Directed by Kim Jee-woon

Most recently watched by noahphex, jenerator, sensoria, noahphex

Overview

Kyung-chul is a dangerous psychopath who kills for pleasure. Soo-hyeon, a top-secret agent, decides to track down the murderer himself. He promises himself that he will do everything in his power to take vengeance against the killer, even if it means that he must become a monster himself.

Rated R | Length 144 minutes

Actors

Jeon Kuk-Hwan | Lee Byung-hun | Min-sik Choi | Cheon Ho-Jin | Choi Jin-ho | Choi Moo-seong | Nam Bo-ra | Jo Deok-Jae | Son Young-Soon | Kim Kap-soo | Lee Joon-hyuk | Kim In-seo | Park Seo-Yeon | Oh San-ha | Kim Yoon-seo | Um Tae-goo | Yoon Chae-yeong | Kim Kang-il | Lee Seol‑gu | Jeong Mi-nam | Jang Jeong-won | Kim Yeong-chan | Goo Yong-wan | Kim Dae-hye | Kim Jae-geon | Park Ji-yeon | Nam Hyeon-joo | Sin Jeong-hoon | Han Se-joo | Park Jeong-gi | Jo Myeong-yeon | Kim Bong-soo | Sin Sin-Beom | Seol Chang-hee | Han Chul-woo | Yoon Byung-hee | Jung Tae-sung

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0180
Total Execution Time  0.0193
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2158
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '22f777a1f06f69e98506402a087cde14c36b813a'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3a471159f14e538772ee43e887371afe', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '22f777a1f06f69e98506402a087cde14c36b813a'
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` = 2158
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 2158
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` = 2158
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2158 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 20 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)