Movielogr

Home

movie poster

View on: IMDb | TMDb

Shrek the Third (2007)

Directed by Chris Miller

Overview

The King of Far Far Away has died and Shrek and Fiona are to become King & Queen. However, Shrek wants to return to his cozy swamp and live in peace and quiet, so when he finds out there is another heir to the throne, they set off to bring him back to rule the kingdom.

Rated PG | Length 93 minutes

Actors

Eddie Murphy | Antonio Banderas | Rupert Everett | Julie Andrews | Cameron Diaz | Ian McShane | John Cleese | Eric Idle | Guillaume Aretos | Mike Myers | Kelly Asbury | Conrad Vernon | Cody Cameron | Christopher Knights | Chris Miller | Aron Warner | Amy Sedaris | Justin Timberlake | John Krasinski | Tom McGrath | Seth Rogen | Larry King | Maya Rudolph | Amy Poehler | Cheri Oteri | Sean Bishop | Tom Kane | Dante James Hauser | Susanne Blakeslee | Kari Wahlgren | Walt Dohrn | Mark Valley | Regis Philbin | Alina Phelan | Latifa Ouaou | David P. Smith | Andrew Birch | Jasper Johannes Andrews | Kelly Cooney | Zachary James Bernard | Jordan Alexander Hauser

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Overview / Movie Detail )  0.0225
Total Execution Time  0.0243
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,712 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6845
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0061 seconds)  (Hide)
0.0002   SELECT 1
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
AND `ip_address` = '216.73.216.111' 
0.0001   SELECT GET_LOCK('35517b52ac0b9236e38b69209c6c7c0c', 300) AS ci_session_lock 
0.0001   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
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` = 6845
 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` = 6845
GROUP BY `title_id` 
0.0026   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` = 6845
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6845 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)