Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

American Pie (1999)

Directed by Paul Weitz

Most recently watched by sleestakk

Overview

At a high-school party, four friends find that losing their collective virginity isn’t as easy as they had thought. But they still believe that they need to do so before college. To motivate themselves, they enter a pact to all “score” by their senior prom.

Rated R | Length 95 minutes

Actors

Tara Reid | Casey Affleck | Clyde Kusatsu | Chris Weitz | Lawrence Pressman | Mena Suvari | Natasha Lyonne | Thomas Ian Nicholas | Jason Biggs | Chris Klein | Alyson Hannigan | Shannon Elizabeth | Eugene Levy | Chris Owen | James DeBello | Christina Milian | Jennifer Coolidge | Woody Schultz | Eddie Kaye Thomas | Eric Lively | Molly Cheek | Seann William Scott | Tara Subkoff | Jillian Bach | John Cho | Veronica Lauren | Alexandra Adi | Sasha Barrese | Tom DeLonge | Justin Isfeld | Marilyn Staley | Eli Marienthal | Marek Probosz | Akuyoe Graham | Travis Barker | Eden Riegel | Jim Henry | Mark Hoppus | Markus Botnick | Hilary Angelo | Clementine Ford | Monica McSwain | Linda Gehringer | Daniel Spink | Katie Lansdale | Ashton Dane | Fletcher Sheridan | Robyn Roth | Jamar Cargo | Travis Cody Aimer | Casey Erklin | Jami Philbrick | Jay Rossi | Jennifer Austin | Mark-Eugene Garcia | Ingrid K. Behrens | Scott Raynor | Sami Atayan | Lyle Tomlinson | Steven McAfoose | Jon Mark Fabiano | Peter McPartlin | Steven Hopkins | Richard Schoenberg | Donald J. Collins | Addison Krantz | Chris McGnie | Dustan Beitey | Kurt Zimmerman | Alex Nies | Amon Button | Annika Hays | Chris Loudos | Dan Coronel | Kirk Lamitie | Tri C. Nguyen | Todd Samuel Parker | Pete Pallad | J.D. Doyle | Lito Coronel | Ian Televik | Joshua Mele | Sean Whitacre | Jasmine Stocken | David Kuhn | Robby Murakami | Roger Sewell | Ryan Bates | Joe Park | Walter Toole | Travis Petraglia | Sean Elder | Gian Caputo | Garret Kellenberger | Timothy Sovay | Kevin Tidgewell | Jesse Patterson | Jeff Schwartz | Tom Christian | Amber Phillips | Crystal the Monkey | Sheypan Draus | Carmi Greene | Melissa Noble

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