Movielogr

Home

Movies by Source

sleestakk has logged 193 movies that were Rented. Back to Sources by Popularity.

Movies logged that were Rented
TitleDirector(s)Year ReleasedViewed On
Rampo NoirAkio Jissoji, Atsushi Kaneko, Hisayasu Satô, Suguru Takeuchi200503/27/2009
Motel, The200501/20/2011
Proposition, TheJohn Hillcoat200505/26/2007
Tokyo ZombieSakichi Satô200504/17/2009
NanaKentarô Ohtani200502/19/2009
Funky Forest: The First ContactKatsuhito Ishii, Hajime Ishimine, Shunichiro Miki200505/08/2012
MiracleGavin O'Connor200406/19/2004
Kamikaze GirlsTetsuya Nakashima200402/16/2009
MarebitoTakashi Shimizu200408/26/2006
Three… ExtremesPark Chan-wook, Takashi Miike, Fruit Chan200403/11/2006
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0227
Total Execution Time  0.0243
  GET DATA  
No GET data exists
  MEMORY USAGE  
535,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/source/5/year/desc/50
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0151 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'cdc948777a5ab6f0fa8c1950b8e52248faf1cdba'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('acae21903e6fabc9c32001bba8d44f73', 300) AS ci_session_lock ?>
0.0009  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'cdc948777a5ab6f0fa8c1950b8e52248faf1cdba'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0056  
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND `MV`.`source_id` = 5
GROUP BY `MT`.`title_id` ?>
0.0075  
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` = 9
AND `MV`.`source_id` = 5
GROUP BY `MT`.`title_id`
ORDER BY `year` DESC
 LIMIT 50, 10 ?>
0.0003  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 5
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)