Movielogr

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

Hot Tub Time Machine (2010)

Directed by Steve Pink

Most recently watched by Javitron, noahphex, jenerator, suspectk

Overview

Four pals are stuck in a rut in adulthood: Adam has just been dumped, Lou is a hopeless party animal, Craig is a henpecked husband, and Jacob does nothing but play video games in his basement. But they get a chance to brighten their future by changing their past after a night of heavy drinking in a ski-resort hot tub results in their waking up in 1986.

Rated R | Length 101 minutes

Actors

Thomas Lennon | Crispin Glover | John Cusack | Robert Wu | Lynda Boyd | Rob LaBelle | Lizzy Caplan | Rob Corddry | Clark Duke | Chevy Chase | William Zabka | Crystal Lowe | Diora Baird | Viv Leacock | Sebastian Stan | Charlie McDermott | Craig Robinson | Luke Ryan | Kellee Stewart | Ecstasia Sanders | Jessica Paré | Amy Esterle | Collette Wolfe | Lyndsy Fonseca | Julia Maxwell | Geoff Gustafson | Cole Carson | Paul Dzenkiw | Jacob Blair | Daren A. Herbert | Marie West | Josh Heald | Eli Jane | Adrienne Rusk | Michael Roberds | Keith Roenke | Blaine Anderson | Rhys Williams | Crystal Tisiga | Willy Lavendel | Amber Hay | Jamie Switch | Lars Anderson | Aliu Oyofo | Jake Rose | Brook Bennett | Austin Warren | Adam Sabla | Jocelyn C. Waugh | Curtis Santiago | Ryan Guldemond | Jeremy Page | Anthony Dallas | Odessa Rojen | Chad Garner | Donald MacDonald | Chad MacDonald | Anthony Pagni | Megan Holmes | Eddie Ruttle | Heathcliffe Scaddan | Peter Wilson | Brent Lister | Natalia Dawn | Ava Leemet

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0204
Total Execution Time  0.0221
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,848 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2631
  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` = '44235449f42b5dbcb47496563fe259ef36f95d41'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('b281fa6139172cf04ecaed1118adde55'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '44235449f42b5dbcb47496563fe259ef36f95d41'
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` = 2631
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0018   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` = 2631
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2631
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2631 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)