Movielogr

Home

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

The Hunt for Red October (1990)

Directed by John McTiernan

Most recently watched by sleestakk

Overview

A new technologically-superior Soviet nuclear sub, the Red October, is heading for the U.S. coast under the command of Captain Marko Ramius. The American government thinks Ramius is planning to attack. Lone CIA analyst Jack Ryan has a different idea: he thinks Ramius is planning to defect, but he has only a few hours to find him and prove it - because the entire Russian naval and air commands are trying to find Ramius, too. The hunt is on!

Rated PG-13 | Length 135 minutes

Actors

Scott Glenn | Sean Connery | Larry Ferguson | Tomas Arana | Shane Black | Rick Ducommun | Stellan Skarsgård | Gates McFadden | Peter Zinner | Jeffrey Jones | Sam Neill | Peter Jason | Alec Baldwin | Richard Jordan | Tim Curry | Joss Ackland | James Earl Jones | Timothy Carhart | Fred Thompson | Sven-Ole Thorsen | Peter Firth | Courtney B. Vance | Tom Fisher | Andrew Divoff | Ray Reinhardt | Ronald Guttman | Ned Vaughn | Pete Antico | Anatoli Davydov | George Saunders | Ivan Ivanov | David Sederholm | Anthony Peck | F.J. O'Neil | Artur Cybulski | Ben Hartigan | John Shepherd | Robert Buckingham | Daniel Davis | Don Oscar Smith | A.C. Lyles | Boris Lee Krutonog | Krzysztof Janczar | Ping Wu | Ivan G'Vera | Mark Draxton | Kenton Kovell | Radu Gavor | Michael Welden | John McTiernan Sr. | William Bell Sullivan | Herman Sinitzyn | Michael George Benko | Vlado Benden | George H. Billy | Reed Popovich | Tony Veneto | Louise Borras | Denise E. James

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0197
Total Execution Time  0.0210
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,232 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5704
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0046 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.0003   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` = 5704
 LIMIT 1 
0.0003   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 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` = 5704
GROUP BY `title_id` 
0.0001   SET SESSION group_concat_max_len = 1024 
0.0003   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` = 5704
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5704 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)