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
American GangsterRidley Scott200711/04/2007
HounddogDeborah Kampmeier200703/08/2010
Guide to Recognizing Your Saints, ADito Montiel200603/19/2010
Pan's LabyrinthGuillermo del Toro200603/04/2007
BrickRian Johnson200601/31/2010
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
12 and HoldingMichael Cuesta200605/28/2012
Neo NedVan Fischer200505/30/2012
Sin CityQuentin Tarantino, Frank Miller, Robert Rodriguez200504/03/2005
History of Violence, ADavid Cronenberg200510/02/2005
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Cert )  0.0143
Total Execution Time  0.0157
  GET DATA  
No GET data exists
  MEMORY USAGE  
539,720 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/suspectk/cert/R/year/desc/40
  CLASS/METHOD  
members/movies_by_cert
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0071 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'acb825b6dd6a3fb33fc3a7c3e9c1bea6547c50e1'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('9d3d374132b7f8b69011f9ede60b0e70', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'acb825b6dd6a3fb33fc3a7c3e9c1bea6547c50e1'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'suspectk'
 LIMIT 1 
0.0024   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.0038   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 `year` DESC
 LIMIT 40, 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)