Movielogr

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

New York, I Love You (2008)

Directed by Natalie Portman, Yvan Attal, Fatih Akin, Joshua Marston, Mira Nair, Brett Ratner, Allen Hughes, Randall Balsmeyer, Shekhar Kapur, Shunji Iwai, Jiang Wen

Most recently watched by suspectk

Overview

New York, I Love You delves into the intimate lives of New Yorkers as they grapple with, delight in and search for love. Journey from the Diamond District in the heart of Manhattan, through Chinatown and the Upper East Side, towards the Village, into Tribeca, and Brooklyn as lovers of all ages try to find romance in the Big Apple.

Rated R | Length 103 minutes

Actors

Robin Wright | Orlando Bloom | Natalie Portman | Ethan Hawke | Andy Garcia | Julie Christie | Chris Cooper | James Caan | Eli Wallach | Burt Young | John Hurt | Jacinda Barrett | Christina Ricci | Cloris Leachman | Shia LaBeouf | Hayden Christensen | Anton Yelchin | Maggie Q | Justin Bartha | Shu Qi | Bradley Cooper | Olivia Thirlby | Rachel Bilson | Eva Amurri | Blake Lively | Jillian Bach | Dan Ziskie | Drea de Matteo | Irrfan Khan | Clem Moorman | Elizabeth Hobgood | Uğur Yücel | J. Salome Martinez | Taylor Geare | Carlos Acosta | Andy Karl | Duane Cooper | Emilie Ohana | Rebecca Kaasa | Jeff Chena | Vedant Gokhale | Robert d Scott | Abe Karpen | Amy Raudenbush | Hiroshi Hsu | Richard Cheng

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0273
Total Execution Time  0.0286
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,872 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4621
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0085 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ed1d4d424b6fa343aefbd8471a03e5f65c462fb4'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('803633fef99e958da1a023f4458e39a4'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ed1d4d424b6fa343aefbd8471a03e5f65c462fb4'
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` = 4621
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0061   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 4621
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 4621
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4621 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)