Movielogr

Home

movie poster

View on: IMDb | TMDb

Troy (2004)

Directed by Wolfgang Petersen

Overview

In year 1250 B.C. during the late Bronze age, two emerging nations begin to clash. Paris, the Trojan prince, convinces Helen, Queen of Sparta, to leave her husband Menelaus, and sail with him back to Troy. After Menelaus finds out that his wife was taken by the Trojans, he asks his brother Agamemnon to help him get her back. Agamemnon sees this as an opportunity for power. They set off with 1,000 ships holding 50,000 Greeks to Troy.

Rated R | Length 163 minutes

Actors

Sean Bean | Orlando Bloom | Brad Pitt | Julian Glover | John Shrapnel | Brian Cox | Julie Christie | Brendan Gleeson | James Cosmo | Eric Bana | Diane Kruger | Saffron Burrows | Rose Byrne | Garrett Hedlund | Jacob Smith | Siri Svegler | Vincent Regan | Tyler Mane | Peter O'Toole | Adoni Maropis | Nathan Jones | Trevor Eve | Nigel Terry | Owain Yeoman | Ken Bones | Manuel Cauchi | Mark Lewis Jones | Joshua Richards | Frankie Fitzgerald | Louis Dempsey | Lucie Barat | Tim Chipping | Desislava Stefanova | Tanja Tzarovska | Luke Tal | Matthew Tal | Alex King

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