Movielogr

Home

Movies by Tag

noahphex has logged 56 movies that were tagged with “horror movie night.”

Movies tagged with “horror movie night”
TitleDirector(s)Year ReleasedViewed On
Don't Be Afraid of the DarkJohn Newland197301/12/2011
HomebodiesLarry Yust197405/18/2011
Cathy's CurseEddy Matalon197711/16/2011
Mardi Gras MassacreJack Weis197803/09/2011
DeadlineMario Philip Azzopardi198005/23/2012
Scared to DeathWilliam Malone198004/13/2011
Night of the DemonJames C. Wasson198004/20/2011
Hospital MassacreBoaz Davidson198102/15/2012
Night to Dismember, ADoris Wishman198304/25/2012
Lift, TheDick Maas198301/05/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Tag )  0.0174
Total Execution Time  0.0189
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,728 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/tag/75/year/asc
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0070 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '72acabe6ff47792a911a272bda83ec2a3f585cf5'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('2811fa5ed3393eac9ce943e8aebd41f9', 300) AS ci_session_lock ?>
0.0006  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '72acabe6ff47792a911a272bda83ec2a3f585cf5'
AND `ip_address` = '216.73.216.6' ?>
0.0008  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0018  
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` = 75
GROUP BY `MT`.`title_id` ?>
0.0030  
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` = 75
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10 ?>
0.0002  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 75
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)