Movielogr

movie poster

Average Rating: 9.5/10

View on: IMDb | TMDb

The Raid (2012)

Directed by Gareth Evans

Most recently watched by sensoria, noahphex, zombiefreak, sleestakk, noahphex

Overview

Deep in the heart of Jakarta’s slums lies an impenetrable safe house for the world’s most dangerous killers and gangsters. Until now, the run-down apartment block has been considered untouchable to even the bravest of police. Cloaked under the cover of pre-dawn darkness and silence, an elite swat team is tasked with raiding the safe house in order to take down the notorious drug lord that runs it.  But when a chance encounter with a spotter blows their cover and news of their assault reaches the drug lord, the building’s lights are cut and all the exits blocked. Stranded on the sixth floor with no way out, the unit must fight their way through the city’s worst to survive their mission. Starring Indonesian martial arts sensation Iko Uwais.

Rated R | Length 101 minutes

Actors

Iko Uwais | Yayan Ruhian | Ray Sahetapy | Johannes Taslim | Ananda George | Pierre Gruno | Tegar Satrya | Verdi Solaiman | Iang Darmawan | R. Iman Aji | Yusuf Opilus | Donny Alamsyah | Henky Solaiman | Daffa Sikumbang | Very Tri Yulisman | Eka 'Piranha' Rahmadia | Umi Kulsum | Fikha Effendi | Yandi 'Piranha' Sutsina | Alfridus Godfred | Sunarto | Muhammad Yazid | Mus Danang Danar Dono | Rully Santoso | Melkias Ronald Torobi | Johanes Tuname | Sofyan Alop | Hanggi Maisya | Zaenal Arifin | Abraham Joshua B. Sitompul | Aji Setianto | Fachrudin Midun | Ardiansyah Putra | Engelius Rumbindi | Bastian Riffanie | Aliusman | Ubay Dillah | Taufik Arrahman | Acip Sumardi | Saifan Nur | Fiqih Hardana Yuanza | Eka Aprilyana | Ali Nurkoto | Achmad Supriatno | Muhammadu Dikko Yusufu | Nur Wahyu Santosa | Dedy Djunaedi | Ireng Sutarno | Sahlianto | Tuhen | Dedy Murphy Avivu | Saad Afero

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0235
Total Execution Time  0.0253
  GET DATA  
No GET data exists
  MEMORY USAGE  
522,688 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2402
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0052 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'f80eefc93e07c60dd5e564c7a8d20006ec8064dc'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('36b673b1d51ec4a22cf62e0160ee95e1'300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f80eefc93e07c60dd5e564c7a8d20006ec8064dc'
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` = 2402
 LIMIT 1 
0.0004   SET SESSION group_concat_max_len 12288 
0.0024   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` = 2402
GROUP BY 
`title_id
0.0003   SET SESSION group_concat_max_len 1024 
0.0004   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` = 2402
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2402 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 21 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)