Movielogr

movie poster

View on: IMDb | TMDb

National Treasure (2004)

Directed by Jon Turteltaub

Overview

Modern treasure hunters, led by archaeologist Ben Gates, search for a chest of riches rumored to have been stashed away by George Washington, Thomas Jefferson and Benjamin Franklin during the Revolutionary War. The chest’s whereabouts may lie in secret clues embedded in the Constitution and the Declaration of Independence, and Gates is in a race to find the gold before his enemies do.

Rated PG | Length 131 minutes

Actors

Sean Bean | Christopher Plummer | Harvey Keitel | Mark Pellegrino | Nicolas Cage | Jody Halse | Diane Kruger | Jon Voight | Arabella Field | Armando Riesco | Justin Bartha | David Dayan Fisher | Annie Parisse | Jason Earles | Stewart Finlay-McLennan | Oleg Taktarov | Don McManus | Ron Canada | Deborah Yates | Michael Russo | Erik King | Rod McLachlan | Antony Alda | Terrence Currier | Stephen A. Pope | Sharon Wilkins | Heidi Albertsen | Joshua Bitton | Alexandra Balahoutis | Dior Raye | Hunter Gomez | Yves Michel-Beneche | Elizabeth Greenberg | Liam Noble | Fern D. Baguidy Jr. | Thomas Q. Morris | John Travis | Adriana Alveario

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0199
Total Execution Time  0.0215
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6016
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('ef74624ec06051b8b8efa86fe40d6c4e'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
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` = 6016
 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 filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 6016
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0003   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6016
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6016 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)