Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

American Pie Presents: The Naked Mile (2006)

Directed by Joe Nussbaum

Most recently watched by noahphex

Overview

When Erik Stifler realizes that he’s the only Stifler family member who might graduate high school a virgin, he decides to live up to his legacy. After some well-meaning advice from Jim’s dad, Erik’s ready to take his chances at the annual and infamous Naked Mile race, where his devoted friends and some uninhibited sorority girls will create the most outrageous weekend ever.

Rated R | Length 97 minutes

Actors

Christopher McDonald | Melanie Merkosky | Eugene Levy | John White | Jessy Schram | Steve Talley | Maria Ricossa | Kevin Jubinville | Joe Bostick | Liz Gordon | Jordan Prentice | Jake Siegel | Jennifer Miller | Jordan Madley | Ross Thomas | Jessica Booker | Devon Bostick | Candace Kroslak | Dan Petronijevic | Stuart Clow | Jon Cor | Alexis Maitland | Bill Turnbull | Pete Zedlacher | Shomari Downer | Jax Smith | Mika Winkler | Alyssa Nicole Pallett | Ajay Fry | Joanne Alderson | Will Weldon | Stevie Lee | J.J. Gallo | Angelique Lewis | Michelle Suppa | Stephany Sexton | David Klar | Colin Moult | Stewart Downs | Michelle Cormier | Chris Rutte | Ricky Frederick | Brad Kingston | Michael Miller | Lauren Boutette | Trisha Echeverria | Jennifer Gouveia

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0213
Total Execution Time  0.0227
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,944 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2974
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0037 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('018ff58b57b009f1d2b2870c60743909', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
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` = 2974
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0016   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` = 2974
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` = 2974
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2974 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)