Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Elite Squad: The Enemy Within (2010)

Directed by José Padilha

Most recently watched by vivalaserdisc, sensoria

Overview

After a bloody invasion of the BOPE in the High-Security Penitentiary Bangu 1 in Rio de Janeiro to control a rebellion of interns, the Lieutenant-Colonel Roberto Nascimento and the second in command Captain André Matias are accused by the Human Right Aids member Diogo Fraga of execution of prisoners. Matias is transferred to the corrupted Military Police and Nascimento is exonerated from the BOPE by the Governor.

Length 115 minutes

Actors

Seu Jorge | Maria Ribeiro | Luciano Vidigal | Wagner Moura | André Ramiro | Milhem Cortaz | Emílio Orciollo Netto | Tainá Müller | Charles Fricks | Fabrício Boliveira | Roney Villela | Irandhir Santos | Pedro Van-Held | Sandro Rocha | André Mattos | Júlio Adrião | Thogun | Cadu Fávero | Juliana Schalch | Luca Bianchi | Adriano Garib | Prazeres Barbosa | Pierre Santos | Rose Abdallah | Rogério Trindade | Kikito Junqueira | Marcelo Freixo

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0231
Total Execution Time  0.0247
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,000 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2295
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '670a3089889b8c8d5a39790a7bf90120b4348e85'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('8bdfc8c0bba2ba5e0b8e50ab5e9ca658', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '670a3089889b8c8d5a39790a7bf90120b4348e85'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2295
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0017   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` = 2295
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0005   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` = 2295
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2295 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)