Movielogr

Home

Movies by Format

krazykat has logged 118 movies on Streaming format. Back to Formats by Popularity.

Movies logged on Streaming format
TitleDirector(s)Year ReleasedViewed On
Galaxy of TerrorBruce D. Clark198110/19/2012
ThiefMichael Mann198105/06/2012
House Where Evil Dwells, TheKevin Connor198210/09/2012
Thing, TheJohn Carpenter198210/01/2012
Living Dead Girl, TheJean Rollin198210/11/2012
Dead Men Don't Wear PlaidCarl Reiner198205/26/2012
Toxic Avenger, TheLloyd Kaufman, Michael Herz198408/08/2012
Stuff, TheLarry Cohen198510/14/2012
CreatureWilliam Malone198510/11/2012
Alien PredatorsDeran Sarafian198610/08/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Format )  0.0129
Total Execution Time  0.0145
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,160 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/krazykat/format/5/year/asc/30
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0060 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '2c7210d65b264d9f8fee8747667a48c9cd24aa85'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('8ac5ea3206057dbea0cd087abdc4e252', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '2c7210d65b264d9f8fee8747667a48c9cd24aa85'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'krazykat'
 LIMIT 1 ?>
0.0013  
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` = 10
AND `MV`.`format_id` = 5
GROUP BY `MT`.`title_id` ?>
0.0035  
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` = 10
AND `MV`.`format_id` = 5
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 30, 10 ?>
0.0002  
SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 5
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)