Movielogr

Home

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

Shrek Forever After (2010)

Directed by Mike Mitchell

Most recently watched by jenerator, testguy

Overview

A bored and domesticated Shrek pacts with deal-maker Rumpelstiltskin to get back to feeling like a real ogre again, but when he’s duped and sent to a twisted version of Far Far Away—where Rumpelstiltskin is king, ogres are hunted, and he and Fiona have never met—he sets out to restore his world and reclaim his true love.

Rated PG | Length 93 minutes

Actors

Eddie Murphy | Antonio Banderas | Kathy Griffin | Julie Andrews | Mary Kay Place | Cameron Diaz | John Cleese | Mike Myers | Conrad Vernon | Cody Cameron | Christopher Knights | Chris Miller | Aron Warner | Frank Welker | Lake Bell | Jane Lynch | Larry King | Mike Mitchell | Craig Robinson | Jon Hamm | Miles Bakshi | Nina Zoe Bakshi | Ashley Boettcher | Kristen Schaal | Billie Hayes | Walt Dohrn | Meredith Vieira | Regis Philbin | Ryan Seacrest | James Ryan | Brian Hopkins | Jasper Johannes Andrews | Ollie Mitchell | Jeremy Hollingworth | Danielle Soibelman

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0195
Total Execution Time  0.0211
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3855
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('01ca37e9d2f753d88b3e751725b82248', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3855
 LIMIT 1 
0.0003   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 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` = 3855
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` = 3855
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3855 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)