Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Get Him to the Greek (2010)

Directed by Nicholas Stoller

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

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Overview / Movie Detail )  0.0238
Total Execution Time  0.0256
  GET DATA  
No GET data exists
  MEMORY USAGE  
530,640 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2727
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0050 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0004   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` = 2727
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0026   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` = 2727
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` = 2727
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2727 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)