Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

(500) Days of Summer (2009)

Directed by Marc Webb

Most recently watched by Javitron, sensoria

Overview

Tom, greeting-card writer and hopeless romantic, is caught completely off-guard when his girlfriend, Summer, suddenly dumps him. He reflects on their 500 days together to try to figure out where their love affair went sour, and in doing so, Tom rediscovers his true passions in life.

Rated PG-13 | Length 95 minutes

Actors

Geoffrey Arend | Matthew Gray Gubler | Valente Rodriguez | Clark Gregg | Zooey Deschanel | Nicole Vicius | Maile Flanagan | Joseph Gordon-Levitt | Patricia Belcher | Chloë Grace Moretz | Darryl Alan Reed | Tim Lacatena | Jean-Paul Vignon | Jull Weber | Gus Carr | Richard McGonagle | Tracy Phillips | Rachel Boston | Minka Kelly | Yvette Nicole Brown | Kenneth Hughes | Ian Reed Kesler | Jennifer Hetrick | Sybil Azur | Nadine Ellis | Christopher 'War' Martinez | Reshma Gajjar | Gregory Thompson | Brandon Henschel | Darryl Sivad | Vivian Nixon | Christian Vincent | Bryan Anthony | Tiffany Granath | Alejandro Estornel | John R. Corella | Alexandra Nicole Hulme | John Mackie | Anthony Marciona | Charles Walker | Rebecca Lin | Jennifer Hamilton | Natalie Boren | Nathan Prevost | Michael Higgins | Gelsey Weiss | Katie Malia | Ryan Thomas | John Jacquet Jr. | Jennifer Lee Keyes | Samantha Krutzfeldt | Cheryl Baxter | Olivia Howard Bagg | Adam Emery | Jacob Stroop | Sid Wilner | Chris Connell | Pleasant Wayne | Eileen Álvarez | Kathryn Weisbeck | Michael Bodie | Kevin Michael | Nathaniel Flatt | Jamie Shea | Jason Robinson

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0209
Total Execution Time  0.0226
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,984 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2026
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0048 seconds)  (Hide)
0.0002   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5c63e7dda8ad846f1b707d27edd49878', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
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` = 2026
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0025   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` = 2026
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` = 2026
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2026 
0.0003   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)