Movielogr

Home

movie poster

Rating: stars

Tags

Alamo Drafthouse Lamar

Seen 2 times

Seen on: 06/01/2011, 07/10/2010

View on: IMDb | TMDb

Get Him to the Greek (2010)

Directed by Nicholas Stoller

Comedy

Most recently watched by jenerator, noahphex, jenerator

Overview

Pinnacle records has the perfect plan to get their sinking company back on track: a comeback concert in LA featuring Aldous Snow, a fading rockstar who has dropped off the radar in recent years. Record company intern Aaron Green is faced with the monumental task of bringing his idol, out of control rock star Aldous Snow, back to LA for his comeback show.

Rated R | Length 109 minutes

Actors

Jamie Sives | Ato Essandoh | Rose Byrne | Tom Felton | Stephanie Faracy | Sean Combs | Colm Meaney | Mario López | Jonah Hill | Elisabeth Moss | Kristen Bell | T.J. Miller | Carlos Jacott | Christina Aguilera | Carla Gallo | Neal Brennan | Russell Brand | Sean Hurley | Dee Snider | Lars Ulrich | Ricky Schroder | Pink | Ryan Shiraki | Aziz Ansari | Kali Hawk | Christine Nguyen | Kristen Schaal | Rino Romano | Benjamin Kanes | Meredith Vieira | Natalina Maggio | Jonathan Ryland | Jim Piddock | Chris Wilson | José Ramón Rosario | Dayton Knoll | Zoe Richards | Kurt Loder | Brandon Johnson | Dinah Stabb | Diana Terranova | Lindsey Broad | Nick Kroll | Da'Vone McDonald | Billy Bush | Ellie Kemper | Jake Johnson | Pharrell Williams | Lonnie Henderson | Joyful Drake | Mike Viola | Tonya Kay | Lino Facioli | Robert Scott Howard | Derek Theler | Aiden Cardei | Jessica Ellerby | Thomas Nowell | Sarah Haskins | Nicole Sciacca | Peter Conboy | Meghan Markle | Zöe Salmon | Ivan Shaw | Karl Theobald | Jennifer Perry | Ray Siegle | Andrew Burlinson | Sean Mannion | Chad Cleven | Kirsten Roeters | Magali Widmer | George Aloi | Roger Joseph Manning Jr. | Kristen Marie Kelly | Dan Rothchild | Jill Jordan | Annie Hsu | Francesca Delbanco | Victor Indrizzo | Daniel Robaire | Alexandra Wright | Deanna Gibson | Jian Leonardo | Julia Tokarz | Daniela Dakich | Thomas J. Post | Richard Hochman | Tony van Silva | Paul Krugman | Meddy Ford | Rebecca Kinder | Brian Duprey | Tyler McKinney | Eric Marshall | Jonathan Chris Lopez | Vero Felice Monti | Danny O'Leary | Derek Ressallat | Gee Sekweyama | David Auerbach | Howard Strawbridge | Stephen G. Lucas | Lenny Widegren | Aurora Nonas-Barnes | Duane Sequira | Ronald J. Garner | Kyle Diamond | Thomas R. Wallek | Drew Anthony Carrano | Kelly Ann Buckman | Giusy Castiglione | Ava Vassileva | Joe Benson | Tom Chadwick | Michael Bravo

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Members / Movie Detail )  0.0275
Total Execution Time  0.0293
  GET DATA  
No GET data exists
  MEMORY USAGE  
548,352 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/movie_detail/6378
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0069 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '8957ec41c52f59dd52ede190d708fbf557d587f1'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('991dcdd4732f687a617b1221eabd9b3a', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8957ec41c52f59dd52ede190d708fbf557d587f1'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 6378
AND `MV`.`user_id` = 61
 LIMIT 1 
0.0003   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 61
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0033   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_name` AS `genre_name_01`, `G2`.`genre_name` AS `genre_name_02`, `G3`.`genre_name` AS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, 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_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MP` ON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1` ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2` ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3` ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMT` ON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRC` ON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVC` ON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_five_star` `STR` ON `MV`.`rating_id` = `STR`.`rating_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 `MV`.`movie_id` = 6378
AND `MV`.`user_id` = 61
ORDER BY `date_viewed` DESC 
0.0001   SET SESSION group_concat_max_len = 1024 
0.0002   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EV` ON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 6378 
0.0002   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MT` ON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 6378 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 61
 LIMIT 1 
0.0002   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 61
AND `MV`.`movie_id` = 6378
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_five_star` `MR`
WHERE `MR`.`rating_id` IS NULL
 LIMIT 1 
0.0003   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2` ON `MV`.`title_id` = `MV2`.`title_id` AND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 61
AND `MV`.`movie_id` = 6378
GROUP BY `MV2`.`movie_id`
ORDER BY `MV2`.`date_viewed` DESC 
0.0002   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 6378 
0.0002   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` = 2727
ORDER BY `date_viewed` DESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)