Movielogr

Home

Movies by Format

sleestakk has logged 41 movies on Broadcast format. Back to Formats by Popularity.

Movies logged on Broadcast format
TitleDirector(s)Year ReleasedViewed On
Escape from New YorkJohn Carpenter198105/04/2012
Mega PiranhaStuart Gillard, Eric Forsberg201001/29/2011
Mega Python vs. GatoroidMary Lambert201101/29/2011
Ghost of Yotsuya, TheNobuo Nakagawa195901/17/2011
Los Angeles StreetfighterWoo-sang Park198501/16/2011
American Rhapsody, AnÉva Gárdos200101/09/2011
BerserkJim O'Connolly196701/07/2011
SuperstitionJames W. Roberson198201/26/2010
Killer Elite, TheSam Peckinpah197501/13/2010
Darktown StruttersWilliam Witney197501/10/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Format )  0.0210
Total Execution Time  0.0224
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/format/9/date_viewed/desc/20
  CLASS/METHOD  
members/movies_by_format
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0133 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '724a1cb5c3660148f15fd16801740d7474fe2d3c'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('6d235dca13b463ead00262b27d59095e', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '724a1cb5c3660148f15fd16801740d7474fe2d3c'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0067  
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` = 9
GROUP BY `MT`.`title_id` ?>
0.0052  
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` = 9
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` DESC
 LIMIT 20, 10 ?>
0.0002  
SELECT `format_name`
FROM `ml_lookup_formats`
WHERE `format_id` = 9
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)