Movielogr

Home

movie poster

Average Rating: 9.5/10

View on: IMDb | TMDb

Black Hawk Down (2001)

Directed by Ridley Scott

Most recently watched by sensoria, sensoria

Overview

When U.S. Rangers and an elite Delta Force team attempt to kidnap two underlings of a Somali warlord, their Black Hawk helicopters are shot down, and the Americans suffer heavy casualties, facing intense fighting from the militia on the ground.

Rated R | Length 145 minutes

Actors

Orlando Bloom | William Fichtner | Ewen Bremner | George Harris | Josh Hartnett | Tom Hardy | Brendan Sexton III | Ewan McGregor | Tom Sizemore | Tom Guiry | Zeljko Ivanek | Kim Coates | Eric Bana | Steven Ford | Sam Shepard | Gregory Sporleder | Jason Isaacs | Ron Eldard | Charlie Hofheimer | Hugh Dancy | Brian Van Holt | Matthew Marsden | Nikolaj Coster-Waldau | Johnny Strong | Glenn Morshower | Enrique Murciano | Jeremy Piven | Carmine Giovinazzo | Razaaq Adoti | Treva Etienne | Jason Hildebrandt | Richard Tyson | Ty Burrell | Corey Johnson | Gabriel Casseus | Boyd Kestner | Giannina Facio | Ioan Gruffudd | Danny Hoch | Marcus Ashley | Nikky Smedley | Tac Fitzgerald | Norman Campbell Rees | Kent Linville | Tommy Dallace | Gibson Rickenbacker

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0227
Total Execution Time  0.0242
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,224 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4089
  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` = '22f777a1f06f69e98506402a087cde14c36b813a'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3a471159f14e538772ee43e887371afe', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '22f777a1f06f69e98506402a087cde14c36b813a'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4089
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0019   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` = 4089
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` = 4089
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4089 
0.0003   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 21 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)