Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

The Big Year (2011)

Directed by David Frankel

Most recently watched by sleestakk

Overview

Three fanatical bird-watchers spend an entire year competing to spot the highest number of species as El Nino sends an extraordinary variety of rare breeds flying up into the U.S., but they quickly discover that there are more important things than coming out on top of the competition.

Rated PG | Length 102 minutes

Actors

Owen Wilson | Tim Blake Nelson | Dianne Wiest | David Lewis | Jim Parsons | Anjelica Huston | Steven Weber | Brian Dennehy | Kevin Pollak | Barry Shabaka Henley | John Cleese | JoBeth Williams | Rosamund Pike | Anthony Anderson | Corbin Bernsen | Terence Kelly | Christopher Redman | June Squibb | Nate Torrence | Gabrielle Rose | Zahf Paroo | Jesse Moss | Paul Campbell | Veena Sood | Joey Aresco | Steve Martin | Jack Black | Andrew Wilson | Joel McHale | Rashida Jones | Calum Worthy | Stacey Scowley | Al Roker | Cindy Busby | Marci T. House | William Samples | Bill Dow | Scott Patey | Greg Kean | Christopher Mann | Sheelah Megill | Michael Karl Richards | Michael Bean | Devon Weigel | Kate Gajdosik | Eva Allan | Morgan Brayton | Dee Jay Jackson | Ryan Caltagirone | Jan Bos | Jon Frankel | Craig Bockhorn | Doreen Ramus | Calvin Lee | Tshering Garie | Steve Darling | Kath Dugray

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0220
Total Execution Time  0.0233
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,048 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3686
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0042 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('018ff58b57b009f1d2b2870c60743909', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
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` = 3686
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0019   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` = 3686
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` = 3686
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3686 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)