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
Flight of the PhoenixJohn Moore200412/25/2004
Life Aquatic with Steve Zissou, TheWes Anderson200412/27/2004
Nobody KnowsHirokazu Kore-eda200405/04/2006
Kill Bill: Vol. 1Quentin Tarantino200311/27/2003
Pirates of the Caribbean: The Curse of the Black PearlGore Verbinski200307/27/2003
House of 1000 CorpsesRob Zombie200304/12/2003
Freddy vs. JasonRonny Yu200308/23/2003
UnderworldLen Wiseman200309/21/2003
League of Extraordinary Gentlemen, TheStephen Norrington200307/11/2003
HulkAng Lee200306/19/2003
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Format )  0.0300
Total Execution Time  0.0317
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,872 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/format/3/year/desc/310
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0226 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a801e6a94d190e946e576d4e53662b7e31bfdfe5'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('c2f1c351af6a3752551e2bcbf91b5efd', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a801e6a94d190e946e576d4e53662b7e31bfdfe5'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
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` = 3
GROUP BY `MT`.`title_id` ?>
0.0127  
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 `year` DESC
 LIMIT 310, 10 ?>
0.0002  
SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 3
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)