Movielogr

Home

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

Nick and Norah's Infinite Playlist (2008)

Directed by Peter Sollett

Most recently watched by sleestakk

Overview

Nick cannot stop obsessing over his ex-girlfriend, Tris, until Tris’ friend Norah suddenly shows interest in him at a club. Thus begins an odd night filled with ups and downs as the two keep running into Tris and her new boyfriend while searching for Norah’s drunken friend, Caroline, with help from Nick’s band mates. As the night winds down, the two have to figure out what they want from each other.

Rated PG-13 | Length 89 minutes

Actors

Jay Baruchel | Alexis Dziena | Frankie Faison | Kevin Corrigan | Rafi Gavron | Michael Cera | Eddie Kaye Thomas | Kat Dennings | Aaron Yoo | Seth Meyers | Andy Samberg | John Cho | Rachel Cohn | David Levithan | Lorene Scafaria | Ari Graynor | Cassidy Gard | Jonathan B. Wright | Nora Burns | Justin Rice | Christian Rudder | Ruth Maleczech | Billy Griffith | John Cantwell | Glenn Kubota | Marcel Simoneau | Zachary Booth | Devendra Banhart | Richard Waddingham | Stephanie Ellis | Mimi Imfurst | Bill Walters | Joey Auzenne | Rachel Kiri Walker | Marika Daciuk | Nicole Pursell | Lance R. Marshall | Kiki Valentine | Natalia Fedner | Joseph Basile | Marilyn McDonald | Philip E Jones | Jonesy | Frank Pelligra | Steve Antonucci | Adam S. Phillips | Giorgio Angelini | Jill Sayre | Sam Rocco | Eric Bernat | Kelly Mandruk | Joe Giorgio | Simon Dasher | Darbie Nowatka | Cully Symington | Jeremy Haines | Sammy Marc Rubin | Toney Chem | Vanessa Hardy | The Nellie Olesons | R.J. Romano | Richard S. Sargent | Michelle Taylor | Justin Wood | C. Vincent Woodhull

  BENCHMARKS  
Loading Time: Base Classes  0.0022
Controller Execution Time ( Overview / Movie Detail )  0.0241
Total Execution Time  0.0263
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,360 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4928
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0048 seconds)  (Hide)
0.0005   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4928
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0020   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` = 4928
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` = 4928
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4928 
0.0003   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)