Movielogr

Home

movie poster

View on: IMDb | TMDb

Night at the Museum: Battle of the Smithsonian (2009)

Directed by Shawn Levy

Overview

Hapless museum night watchman Larry Daley must help his living, breathing exhibit friends out of a pickle now that they’ve been transferred to the archives at the Smithsonian Institution. Larry’s (mis)adventures this time include close encounters with Amelia Earhart, Abe Lincoln and Ivan the Terrible.

Rated PG | Length 105 minutes

Actors

Brad Garrett | Jay Baruchel | Thomas Lennon | Owen Wilson | Robin Williams | Alain Chabat | Steve Coogan | Hank Azaria | Ben Stiller | Amy Adams | Christopher Guest | Clint Howard | Shawn Levy | Jake Cherry | Ricky Gervais | Patrick Gallagher | Rami Malek | Mizuo Peck | Bill Hader | Jon Bernthal | Jonah Hill | Matthew Harrison | Eugene Levy | Ed Helms | Samuel Patrick Chu | Clifton MaCabe Murray | Dan Joffre | Darryl Quon | Craig Robinson | George Foreman | Joe Jonas | Caroll Spinney | Mindy Kaling | Nick Jonas | Kevin Jonas | Keith Powell | Matty Finochio | Kai James | Sophie Levy | Tess Levy | Alberta Mayne | Christina Schild | Randy Lee | Robert Thurston | Rick Dobran | Josh Byer | Kerry van der Griend | Thomas Morley | Regina Taufen | Dave Hospes | Paul Chih-Ping Cheng | Augustus Oicle | Gerald Wong | Crystal the Monkey

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