Movielogr

Home

movie poster

View on: IMDb | TMDb

Down Periscope (1996)

Directed by David S. Ward

Overview

Maverick Navy Lieutenant Commander Tom Dodge will never be a textbook officer, but he’s a brilliant seaman who’s always wanted to command a nuclear submarine — he’s been given one last chance to clean up his record. Unfortunately, Admiral Graham, his nemesis, would rather sink the fleet than give Dodge his own boat. So, Graham stacks the deck against him and assigns Dodge to the Stingray, a diesel-powered WW2 submarine that can barely keep afloat. To make matters worse, Dodge’s crew is a collection of maladjusted, mistake-prone misfits. Then, he’s tagged the “enemy” in a crucial war game, and ordered to take on the U.S. Navy’s best.

Rated PG-13 | Length 92 minutes

Actors

William H. Macy | Harry Dean Stanton | Bruce Dern | Kelsey Grammer | Rip Torn | Patton Oswalt | Harland Williams | Toby Huss | Dennis Fimple | Pierrino Mascarino | Lauren Holly | Joseph Latimore | Rob Schneider | Duane Martin | Bradford Tatum | Jamie James | Matt Landers | James Martin Jr. | John Shepherd | James Harper | Gabrielle Wagner | Jonathan Penner | Ken Hudson Campbell | Felipe Rose | Michael Connors | James Eric Anzalone | Ancel Cook | Bruce Holman | Jordan Marder | Elliot Easton | Joe Soto | Rudy Hornish | Tommy Terrell | Paul Tranghese | Mitchell R. Danton | Jackson Sleet | Annie Talbot | Andrew Christian English | Joseph Keawkalaya | Todd Odom | Theodore Carl Soderberg | Eugene Daniel | Bob Dini | Steve Giralo | Robert Grochau

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0207
Total Execution Time  0.0222
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,320 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5837
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0005   SELECT 1
FROM `ml_sessions`
WHERE `id` = '882bbc90480d383bb22c265c8deb41f1d00623eb'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('ece41cbce079af44cd775de6bdb8316c', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '882bbc90480d383bb22c265c8deb41f1d00623eb'
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` = 5837
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 5837
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` = 5837
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5837 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)