Movielogr

Home

Movies by Certification (MPAA Rating)

suspectk has logged 66 movies that were certified R by the MPAA.

Movies certified R
TitleDirector(s)Year ReleasedViewed On
Mexican, TheGore Verbinski200103/15/2001
Mystery TeamDan Eckman200909/07/2009
Neo NedVan Fischer200505/30/2012
New York, I Love YouNatalie Portman, Yvan Attal, Fatih Akin, Joshua Marston, Mira Nair, Brett Ratner, Allen Hughes, Randall Balsmeyer, Shekhar Kapur, Shunji Iwai, Jiang Wen200802/28/2010
Nines, TheJohn August200707/18/2009
Ninja AssassinJames McTeigue200911/30/2009
Pan's LabyrinthGuillermo del Toro200603/04/2007
Paris Je T'aimeIsabel Coixet, Tom Tykwer, Joel Coen, Ethan Coen, Christopher Doyle, Richard LaGravenese, Wes Craven, Gus Van Sant, Vincenzo Natali, Gurinder Chadha, Walter Salles, Alfonso Cuarón, Alexander Payne, Gérard Depardieu, Frédéric Auburtin, Olivier Assayas, Nobuhiro Suwa, Oliver Schmitz, Sylvain Chomet, Bruno Podalydès, Daniela Thomas200602/21/2010
Pineapple ExpressDavid Gordon Green200807/20/2009
Royal Tenenbaums, TheWes Anderson200112/04/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Cert )  0.0163
Total Execution Time  0.0177
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,024 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/suspectk/cert/R/title/asc/40
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0093 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cd65afa0b8299269224c63ec17bb2752b6238fb9'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('a22d9ced3f8d6e425d758e72fa54fecc', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cd65afa0b8299269224c63ec17bb2752b6238fb9'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'suspectk'
 LIMIT 1 
0.0044   SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 68
AND `MT`.`certification` = 'R'
GROUP BY `MT`.`title_id` 
0.0037   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_id, 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
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`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`
WHERE `MV`.`user_id` = 68
AND `MT`.`certification` = 'R'
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 40, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)