Movielogr

Home

Movies by Format

Javitron has logged 18 movies on Film format. Back to Formats by Popularity.

Movies logged on Film format
TitleDirector(s)Year ReleasedViewed On
Best Exotic Marigold Hotel, TheJohn Madden201205/12/2012
Beyond the Black RainbowPanos Cosmatos201006/07/2012
Dark Knight Rises, TheChristopher Nolan201207/20/2012
Daughters of SatanHollingsworth Morse197206/23/2012
Dr. GigglesManny Coto199208/01/2012
Killer JoeWilliam Friedkin201108/12/2012
Mad Max 2George Miller198105/19/2012
Moonrise KingdomWes Anderson201206/07/2012
Out of the DarkMichael Schroeder198806/23/2012
ParaNormanSam Fell, Chris Butler201209/01/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Members / Movies By Format )  0.0133
Total Execution Time  0.0145
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,896 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/Javitron/format/3
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0067 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('dfb7927c135074f825c7936b5ddbb206', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'Javitron'
 LIMIT 1 ?>
0.0025  
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` = 3
GROUP BY `MT`.`title_id` ?>
0.0027  
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` = 3
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 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)