Movielogr

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

21 Jump Street (2012)

Directed by Phil Lord, Christopher Miller

Most recently watched by krazykat, Javitron, Javitron, sleestakk

Overview

In high school, Schmidt was a dork and Jenko was the popular jock. After graduation, both of them joined the police force and ended up as partners riding bicycles in the city park. Since they are young and look like high school students, they are assigned to an undercover unit to infiltrate a drug ring that is supplying high school students synthetic drugs.

Rated R | Length 109 minutes

Actors

Johnny Depp | Caroline Aaron | Ice Cube | DeRay Davis | Nick Offerman | Jonah Hill | Johnny Simmons | Luis Da Silva Jr. | Channing Tatum | Chris Parnell | Dave Franco | Brie Larson | Carol Sutton | Rob Riggle | Valerie Tian | Peter DeLuise | Dakota Johnson | Joe Chrest | Peter Epstein | Holly Robinson Peete | Anthony Molinari | Lindsey Broad | Randal Reeder | Ellie Kemper | Jake Johnson | Andrea Frankle | Spencer Boldman | Dax Flame | Geraldine Singer | Haley Farris | Johnny Pemberton | Candi Brooks | Mike Seal | Brittney Alger | Melissa Cordero | Charles Ferrara | Brett Lapeyrouse | Jaren Mitchell | Victor Paguia | Kevin Michael Murphy | Justin Hires | Turner Crumbley | Stanley Wong | Chanel Celaya | Joe Nin Williams | Rye Rye | Keith Kurtz | Dominic 'Taz' Alexander | Courtney Jarrell | Chad Hessler | Tiffney Wagoner | D.J. Mills | Andrea Madison | Hristo Birbochukov | Joshua Nelms | Beau DeLatte | Mark Adams | Brian H. Rossitto

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0234
Total Execution Time  0.0251
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,624 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3670
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0055 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'a97f1ead6bd330080a526539bba53d5d6be3e392'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('b880564058b1042c4c25c3c3fa6d76c1'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a97f1ead6bd330080a526539bba53d5d6be3e392'
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` = 3670
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0035   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 3670
GROUP BY 
`title_id
0.0001   SET SESSION group_concat_max_len 1024 
0.0003   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 3670
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3670 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)