Movielogr

Home

movie poster

Average Rating: 9/10

View on: IMDb | TMDb

The Lord of the Rings: The Two Towers (2002)

Directed by Peter Jackson

Most recently watched by sleestakk, pknail

Overview

Frodo and Sam are trekking to Mordor to destroy the One Ring of Power while Gimli, Legolas and Aragorn search for the orc-captured Merry and Pippin. All along, nefarious wizard Saruman awaits the Fellowship members at the Orthanc Tower in Isengard.

Rated PG-13 | Length 179 minutes

Actors

Sean Bean | Peter Jackson | Elijah Wood | Viggo Mortensen | Cate Blanchett | Christopher Lee | Orlando Bloom | Barrie M. Osborne | Miranda Otto | John Rhys-Davies | Liv Tyler | Alan Lee | Ian McKellen | Sean Astin | Billy Boyd | Dominic Monaghan | Hugo Weaving | Craig Parker | Andy Serkis | Sala Baker | Bernard Hill | Brad Dourif | David Wenham | Karl Urban | Dan Hennah | John Noble | Paul Norell | Bruce Phillips | John Bach | Nathaniel Lees | Richard Knowles | Robbie Magasiva | John Leigh | Robert Young | Robyn Malcolm | Robert Pollock | Aron Eastwood | Allan Poppleton | Raymond Trickitt | Bruce Allpress | Jed Brophy | Owen Black | Alistair Browning | Tim Wong | Gareth Reeves | Piripi Waretini | Karlos Drinkwater | Alix Bushnell | Olivia Tennet | Miranda Rivers | Frank Edwards | Augie Davis | John Wraight | Siaosi Fonua | Victoria Beynon-Cole | Billy Jackson | Joseph Mika-Hunt | Bruce Hopkins | Lucas Hayward | Jason Hood | Matthew Saville | Dra McKay | Calum Gittins | Campbell Rousselle | Shane Dawson | Ben Fransham | Stephen Ure | Sean Button | Alexia Fairbrother | Allan Smith | Phil Grieve | Brent McIntyre | Rodney Cook | Ben Barrington | Sandro Kopp | Francis Mountjoy | Mana Hira Davis | Lani Jackson | Sam Comery | Dean Morganty | Kelley Kerr Young | Ryan Carey | Kester Fordham | Paris Howe Strewe | Lee Hartley | Katie Jackson | Ben Britton | Gareth Jensen | Jørn Benzon | Sam Kelly | Riley Brophy | Jarl Benzon | Dorothy Anne Bonner | Daniel Falconer | Frank Goldingham | Henry Mortensen | Samuel E. Shore | Greg Tozer | Jonathan Harding | Sam La Hood | Jono Manks | Clint Elvy | Frazer Anderson | Winham Hammond | Michael Lawrence | Don Langridge | Michael Fowler

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0175
Total Execution Time  0.0189
  GET DATA  
No GET data exists
  MEMORY USAGE  
529,744 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2398
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0034 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('5c24173565d226510fab4de758bef2a7', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5451bb98abafdef88edc72627dd3bde3239bfcec'
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` = 2398
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 2398
GROUP BY `title_id` 
0.0001   SET SESSION group_concat_max_len = 1024 
0.0002   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` = 2398
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2398 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 20 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)