Movielogr

Home

Movies by Format

sleestakk has logged 600 movies on DVD format. Back to Formats by Popularity.

Movies logged on DVD format
TitleDirector(s)Year ReleasedViewed On
Doctor StrangeDick Sebast, Jay Oliva, Patrick Archibald200702/03/2009
Wild Bunch, TheSam Peckinpah196902/03/2009
Okatsu the FugitiveNobuo Nakagawa196902/04/2009
Bubba Ho-tepDon Coscarelli200202/09/2009
Quick-draw OkatsuNobuo Nakagawa196902/10/2009
Curious Dr. Humpp, TheEmilio Vieyra, Jerald Intrator196902/10/2009
DodgeBall: A True Underdog StoryRawson Marshall Thurber200402/11/2009
Lupin the Third: Island of AssassinsHiroyuki Yano199702/11/2009
Cartoon NoirJiří Barta, Pedro Serrazina, Piotr Dumała, Suzan Pitt, Paul Vester, Julie Zammarchi199902/12/2009
Eko Eko Azarak: Wizard of DarknessShimako Sato199502/12/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Format )  0.0325
Total Execution Time  0.0340
  GET DATA  
No GET data exists
  MEMORY USAGE  
540,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/format/1/date_viewed/asc/150
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0248 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3816ae9a5aa620828b343256f641da75d8e52f79'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0817892d79791252a30c194c7582c412', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3816ae9a5aa620828b343256f641da75d8e52f79'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 
0.0071   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` = 1
GROUP BY `MT`.`title_id` 
0.0164   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` = 1
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 150, 10 
0.0003   SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 1
 LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)