Movielogr

Home

Movies by Format

Javitron has logged 43 movies on No format listed format. Back to Formats by Popularity.

Movies logged on No format listed format
TitleDirector(s)Year ReleasedViewed On
Master, ThePaul Thomas Anderson201209/30/2012
Men in Black 3Barry Sonnenfeld201205/27/2012
Miami ConnectionY.K. Kim, Woo-sang Park198709/21/2012
Mission: Impossible IIIJ.J. Abrams200609/08/2012
Modern TimesCharlie Chaplin193605/05/2012
No Rest for the WickedEnrique Urbizu201109/23/2012
PetsRaphael Nussbaum197308/22/2012
Pineapple ExpressDavid Gordon Green200808/26/2012
Pootie TangLouis C.K.200109/09/2012
Quarantine 2: TerminalJohn Pogue201110/05/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movies By Format )  0.0888
Total Execution Time  0.0905
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,008 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/Javitron/format/200/title/asc/20
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0788 seconds)  (Hide)
0.0020  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0722  
SELECT GET_LOCK('8b16ad9a0fbba2b3d1663ce3c6f3d35d', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0007  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'Javitron'
 LIMIT 1 ?>
0.0018  
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` = 45
AND `MV`.`format_id` = 0
GROUP BY `MT`.`title_id` ?>
0.0019  
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` = 45
AND `MV`.`format_id` = 0
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 20, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)