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
Fighting Fists of Shanghai Joe, TheMario Caiano197302/04/2012
Thunderbirds Are GODavid Lane196602/05/2012
Live a Little, Love a LittleNorman Taurog196802/06/2012
Nightmare on Elm Street, ASamuel Bayer201002/18/2012
XanaduRobert Greenwald198002/22/2012
Raiders of AtlantisRuggero Deodato198302/25/2012
Death Wish 3Michael Winner198502/25/2012
United Red ArmyKōji Wakamatsu200703/02/2012
We Are What We AreJorge Michel Grau201003/03/2012
Resurrect Dead: The Mystery of the Toynbee TilesJon Foy201103/04/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Format )  0.0421
Total Execution Time  0.0435
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,864 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/format/1/date_viewed/asc/470
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0355 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '54dbd107048b633379f8902827645f9265714504'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('00baa084fb43dcdf0577ea48d48e48be', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '54dbd107048b633379f8902827645f9265714504'
AND `ip_address` = '216.73.216.6' ?>
0.0109  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0085  
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.0152  
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 470, 10 ?>
0.0002  
SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 1
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)