Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Letters to Juliet (2010)

Directed by Gary Winick

Most recently watched by suspectk

Overview

An American girl on vacation in Italy finds an unanswered “letter to Juliet”—one of thousands of missives left at the fictional lover’s Verona courtyard, which are typically answered by the “secretaries of Juliet”—and she goes on a quest to find the lovers referenced in the letter.

Rated PG | Length 105 minutes

Actors

Gael García Bernal | Marina Massironi | Silvana Bosi | Vanessa Redgrave | Oliver Platt | Fabio Testi | Franco Nero | Angelo Infanti | Milena Vukotic | Luisa De Santis | Amanda Seyfried | Remo Remotti | Marcia DeBonis | Giordano Formenti | Luisa Ranieri | Ivana Lotito | Lidia Biondi | Giacomo Piperno | Sandro Dori | Hilary Edson | Ashley Lilley | Christopher Egan | Uzimann | Peter Arpesella | Daniel Emilio Baldock | Elio Veller | Paolo Arvedi | Dario Conti | Sara Armentano | Benito Deotto | Marcello Catania | Adriano Guerri | Stefano Guerrini | Robbie Neigeborn | Ginevra Iorio | Laura Jane Jones | Gabriele Manfredi | Antonio Randazzo

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0230
Total Execution Time  0.0244
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,624 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4666
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0051 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '594bcbc84cd82a75be55e8b51990cc39816eba37'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT GET_LOCK('dd99c65fff02bbc4877f1c1d0c91de57', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '594bcbc84cd82a75be55e8b51990cc39816eba37'
AND `ip_address` = '216.73.216.137' 
0.0012   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4666
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 4666
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` = 4666
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4666 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)