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
Sword of Doom, TheKihachi Okamoto196602/22/2009
War of the Gargantuas, TheIshirô Honda196603/06/2009
Invasion of Astro-MonsterIshirô Honda196501/26/2009
Hercules, Prisoner of EvilAntonio Margheriti196403/18/2009
Dr. Strangelove or: How I Learned to Stop Worrying and Love the BombStanley Kubrick196401/02/1999
Black SabbathMario Bava196304/19/2009
Hercules in the Haunted WorldMario Bava196103/05/2009
Hercules and the Captive WomenVittorio Cottafavi196103/21/2009
Toby Tyler or Ten Weeks with a CircusCharles Barton196001/28/2010
Corridors of BloodRobert Day195806/02/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0021
Controller Execution Time ( Members / Movies By Source )  0.0249
Total Execution Time  0.0271
  GET DATA  
No GET data exists
  MEMORY USAGE  
531,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/source/5/year/desc/180
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0183 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'd65e21b975cedd99250060e42d39e93b52949eca'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('95536d680fc78fed4cd538ea6f90c1b9', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd65e21b975cedd99250060e42d39e93b52949eca'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0093   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.0077   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 180, 10 
0.0002   SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 5
 LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)