Movielogr

Home

Movies by Tag

noahphex has logged 34 movies that were tagged with “On Demand.”

Movies tagged with “On Demand”
TitleDirector(s)Year ReleasedViewed On
Myth of the American Sleepover, TheDavid Robert Mitchell201108/14/2011
Neon FleshPaco Cabezas201004/23/2011
New York Says Thank YouScott Rettberg004/30/2011
PrimalJosh Reed201010/01/2010
RabiesNavot Papushado, Aharon Keshales201004/30/2011
Red StateKevin Smith201109/04/2011
Resurrect Dead: The Mystery of the Toynbee TilesJon Foy201108/14/2011
Road to NowhereMonte Hellman201008/29/2011
Seven DaysDaniel Grou201001/31/2010
Taking WoodstockAng Lee200901/01/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Tag )  0.0130
Total Execution Time  0.0146
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,760 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/tag/372/title/asc/20
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0050 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'de0cdc9f043db56df9473b66fa0bf59d6037421a'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('073a456976d2605460d3abdd1a9c40fa', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'de0cdc9f043db56df9473b66fa0bf59d6037421a'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0011  
SELECT `MT`.`title_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_id`
WHERE `MV`.`user_id` = 8
AND `TG`.`tag_id` = 372
GROUP BY `MT`.`title_id` ?>
0.0024  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, MAX(date_viewed) AS date_viewed, MAX(MV.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_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_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` = 8
AND `TG`.`tag_id` = 372
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 20, 10 ?>
0.0003  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 372
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)