Movielogr

Home

Movies by Format

sleestakk has logged 488 movies on Film format. Back to Formats by Popularity.

Movies logged on Film format
TitleDirector(s)Year ReleasedViewed On
Matrix, TheLilly Wachowski, Lana Wachowski199904/04/1999
Master of the Flying GuillotineJimmy Wang Yu197606/01/2012
Master, ThePaul Thomas Anderson201210/06/2012
MasqueradeChoo Chang-min201210/02/2012
Mark of the VampireTod Browning193510/13/2012
Loved Ones, TheSean Byrne200906/01/2012
Lost in TranslationSofia Coppola200310/18/2003
Lord of the Rings: The Two Towers, ThePeter Jackson200212/25/2002
Lord of the Rings: The Return of the King, ThePeter Jackson200303/14/2004
Lord of the Rings: The Fellowship of the Ring, ThePeter Jackson200112/20/2001
  BENCHMARKS  
Loading Time: Base Classes  0.0024
Controller Execution Time ( Members / Movies By Format )  0.0330
Total Execution Time  0.0355
  GET DATA  
No GET data exists
  MEMORY USAGE  
540,072 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/format/3/title/desc/220
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0228 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3a9ece5d72bb0b210fbaedc2e4b02a1d16fd0482'
AND `ip_address` = '216.73.216.57' 
0.0002   SELECT GET_LOCK('a27b1cd18396184db0a3a891622aad86', 300) AS ci_session_lock 
0.0004   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3a9ece5d72bb0b210fbaedc2e4b02a1d16fd0482'
AND `ip_address` = '216.73.216.57' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0077   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`.`format_id` = 3
GROUP BY `MT`.`title_id` 
0.0134   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`.`format_id` = 3
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 220, 10 
0.0003   SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 3
 LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)