Movielogr

Home

movie poster

Rating: 7 stars

Seen 1 time

Seen on: 06/03/2000

View on: IMDb | TMDb

American Pie (1999)

Directed by Paul Weitz

Comedy

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

Viewing Notes

Finally caught up with this… and it’s actually pretty funny.

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movie Detail )  0.0331
Total Execution Time  0.0348
  GET DATA  
No GET data exists
  MEMORY USAGE  
543,096 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/movie_detail/8303
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 16 (0.0135 seconds)  (Hide)
0.0002   SELECT GET_LOCK('3c6462e88084e0bde4c92758137ad2e8', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c0e10e80e06989beac91e88324904f1ab121e290'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 8303
AND `MV`.`user_id` = 9
 LIMIT 1 
0.0003   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 9
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0095   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_name` AS `genre_name_01`, `G2`.`genre_name` AS `genre_name_02`, `G3`.`genre_name` AS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, 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_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MP` ON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1` ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2` ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3` ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMT` ON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRC` ON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVC` ON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_ten_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_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 `MV`.`movie_id` = 8303
AND `MV`.`user_id` = 9
ORDER BY `date_viewed` DESC 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0003   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EV` ON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 8303 
0.0003   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MT` ON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 8303 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 9
 LIMIT 1 
0.0002   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 9
AND `MV`.`movie_id` = 8303
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star` `MR`
WHERE `MR`.`rating_id` = '16'
 LIMIT 1 
0.0004   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2` ON `MV`.`title_id` = `MV2`.`title_id` AND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 9
AND `MV`.`movie_id` = 8303
GROUP BY `MV2`.`movie_id`
ORDER BY `MV2`.`date_viewed` DESC 
0.0002   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 8303 
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` = 4877
ORDER BY `date_viewed` DESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)