Movielogr

Home

movie poster

Average Rating: 10/10

View on: IMDb | TMDb

Wet Hot American Summer (2001)

Directed by David Wain

Most recently watched by noahphex

Overview

The setting is Camp Firewood, the year 1981. It’s the last day before everyone goes back to the real world, but there’s still a summer’s worth of unfinished business to resolve. At the center of the action is camp director Beth, who struggles to keep order while she falls in love with the local astrophysics professor. He is busy trying to save the camp from a deadly piece of NASA’s Skylab which is hurtling toward earth. All that, plus: a dangerous waterfall rescue, love triangles, misfits, cool kids, and talking vegetable cans. The questions will all be resolved, of course, at the big talent show at the end of the day.

Rated R | Length 97 minutes

Actors

Zak Orth | Elizabeth Banks | David Hyde Pierce | Joe Lo Truglio | Janeane Garofalo | Michael Showalter | Marguerite Moreau | Michael Ian Black | A.D. Miles | Paul Rudd | Christopher Meloni | Molly Shannon | Bradley Cooper | Judah Friedlander | Peter Salett | Amy Poehler | Donna Mitchell | Samm Levine | Kyle Gallner | Kevin Sussman | Ken Marino | Cassidy Ladden | Avi Setton | Marisa Ryan | Gideon Jacobs | H. Jon Benjamin | Ian Helfer | Dan Klein | Whitney Vance | Bob Walz | Nina Hellman | Liam Norton | Gabriel Millman | Kevin Thomas Conroy | Christopher Cusumano | Madeline Blue | Jacob Shoesmith Fox | Benjamin Coppola | Jake Fogelnest | Jordan MacLean | Kathleen Pandolfo | Zachary Montgomery-Wicks | Danny Hopkins | Christopher Connors | Matt Carmeci | Stephen O'Brien | Timothy Gasiewski | Angel Berlane | Christi Berlane | Joseph Kariuki | Joe Bryan | Christine Loebsack | Sandra Kennedy | Keith Oney

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0198
Total Execution Time  0.0212
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,456 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3543
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('edfd47a5cb67737440e3f983b6c59307', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cc9a0e365aef4ead9867fea5e6a1f3a75245754e'
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` = 3543
 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 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` = 3543
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` = 3543
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3543 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 22 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)