Movielogr

Home

movie poster

Average Rating: 4.5/10

View on: IMDb | TMDb

The Day the Earth Stood Still (2008)

Directed by Scott Derrickson

Most recently watched by sensoria

Overview

A representative of an alien race that went through drastic evolution to survive its own climate change, Klaatu comes to Earth to assess whether humanity can prevent the environmental damage they have inflicted on their own planet. When barred from speaking to the United Nations, he decides humankind shall be exterminated so the planet can survive.

Rated PG-13 | Length 104 minutes

Actors

Kyle Chandler | Jennifer Connelly | Keanu Reeves | Kathy Bates | John Cleese | Robert Knepper | James Hong | Leanne Adachi | Roger R. Cross | Serge Houde | Ty Olsson | David Richmond-Peck | Ken Kirzinger | Jake McLaughlin | Brandon T. Jackson | Mousa Kraish | John Rothman | Hiro Kanagawa | Kurt Max Runte | Daniel Bacon | J.C. MacKenzie | Shaine Jones | Jon Hamm | Shaker Paleja | Ben Cotton | Lorena Gale | Joshua Close | Daniel Wisler | Heather Doerksen | Rukiya Bernard | Bill Mondy | Richard Tillman | Juan Riedinger | Geoff Meed | Sunita Prasad | Matt Adler | Patrick Sabongui | Andrew Wheeler | Richard Keats | Marci T. House | Jaden Smith | Reese Alexander | George Sharperson | Michael Hogan | Brad Dryborough | Dean Redman | Camille Atebe | Tanya Champoux | Jacob Blair | Terence Dament | Darien Provost | Craig Stanghetta | Blair Redford | Josue Aguirre | Sam Gilroy | Douglas Chapman | Aaron Craven | Judith Maxie | William 'Big Sleeps' Stewart | Kevan Kase | Dawn Chubai | Stefanie Samuels | Thomas Bradshaw | Jay-Nicolas Hackleman | Mark Kogan | Stefan Busse | Daniel St. Andrews | Ed Fong | Sandy Colton

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