Movielogr

Home

movie poster

View on: IMDb | TMDb

Toy Story 2 (1999)

Directed by John Lasseter

Overview

Andy heads off to Cowboy Camp, leaving his toys to their own devices. Things shift into high gear when an obsessive toy collector named Al McWhiggen, owner of Al’s Toy Barn kidnaps Woody. Andy’s toys mount a daring rescue mission, Buzz Lightyear meets his match and Woody has to decide where he and his heart truly belong.

Rated G | Length 92 minutes

Actors

Andrew Stanton | Lee Unkrich | Tom Hanks | Joan Cusack | Wayne Knight | Kelsey Grammer | Don Rickles | John Lasseter | Jeff Pidgeon | John Ratzenberger | Joe Ranft | R. Lee Ermey | Annie Potts | Laurie Metcalf | Tim Allen | Jim Varney | Wallace Shawn | Frank Welker | Jack Angel | Dave Foley | Mary Kay Bergman | Pat Fraley | Corey Burton | Carly Schroeder | Estelle Harris | Philip Proctor | Jodi Benson | Rodger Bumpass | Debi Derryberry | Bob Bergen | Bill Farmer | Mickie McGowan | Jess Harnell | Jonathan Harris | Jan Rabson | Sherry Lynn | John Morris | Nicolette Little | Andi Peters | Madylin Sweeten | Sheryl Bernstein | Rachel Davey | Jessica Evans | Hannah Unkrich

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0261
Total Execution Time  0.0274
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,744 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6875
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'e4952d60378f65beb1a10fca432d660422145654'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('ebbd19626388ede54331431cb5c2b306', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'e4952d60378f65beb1a10fca432d660422145654'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 6875
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0016   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` = 6875
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` = 6875
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6875 
0.0003   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)