Movielogr

Home

movie poster

Average Rating: 5/10

View on: IMDb | TMDb

The Day After Tomorrow (2004)

Directed by Roland Emmerich

Most recently watched by sleestakk

Overview

After years of increases in the greenhouse effect, havoc is wreaked globally in the form of catastrophic hurricanes, tornadoes, tidal waves, floods and the beginning of a new Ice Age. Paleoclimatologist Jack Hall tries to warn the world while also shepherding to safety his son, trapped in New York after the city is overwhelmed by the start of the new big freeze.

Rated PG-13 | Length 124 minutes

Actors

Ian Holm | Jake Gyllenhaal | Glenn Plummer | Tamlyn Tomita | Emmy Rossum | Richard McMillan | Dennis Quaid | Dash Mihok | Jay O. Sanders | Sela Ward | Austin Nichols | Arjay Smith | Sasha Roiz | Nassim Sharara | Carl Alacchi | Kenneth Welsh | Michel 'Gish' Abou-Samah | Nestor Serrano | John Maclaren | Alan Fawcett | Sheila McCarthy | Russell Yuen | Christopher Britton | Christian Tessier | Joe Cobden | Perry King | Mimi Kuzyk | Adrian Lester | Karen Glave | Matt Adler | Amy Sloan | Richard Zeman | Caroline Keenan | Vitali Makarov | Nobuya Shimamoto | Robin Wilcock | Kenneth Moskow | Rick Hoffman

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0203
Total Execution Time  0.0216
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,720 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4897
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '99a5149588c3c6e731b58f9f7afc0e5ca6d5be60'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('45e395eeeb132659ba8133a1f1b0b532', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '99a5149588c3c6e731b58f9f7afc0e5ca6d5be60'
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` = 4897
 LIMIT 1 
0.0002   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` = 4897
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` = 4897
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4897 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 12 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)