Movielogr

Home

movie poster

Average Rating: 5.5/10

View on: IMDb | TMDb

Rock 'n' Roll Nightmare (1987)

Directed by John Fasano

Most recently watched by sleestakk

Overview

At an old farmhouse, a family mysteriously dissapears at the hands of evil. Years later, hair metal band The Tritons comes to the farmhouse, whose barn now features a 24-track recording studio. Lead singer John Triton gets the band to perform their first night in the farmhouse after dinner, and weird little beasties suddenly appear, and strange things start to happen. Band members (and their tag along girlfriends) begin to act strangely and vanish one by one. Soon, only John Triton remains, and he holds a secret. Finally, the evil shows itself and a battle between heaven and hell ensues….

Length 83 minutes

Actors

Frank Dietz | Jon Mikl Thor | Lara Daans | Jim Cirile | Jillian Peri | Rusty Hamilton | Liane Abel Dietz | Carrie Schiffler | Cindy Cirile | Jesse D'Angelo | Teresa Simpson | Adam Fried | Denise Dicandia

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0240
Total Execution Time  0.0266
  GET DATA  
No GET data exists
  MEMORY USAGE  
516,160 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5151
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0037 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9eccc4fd23dc88c5d89f5d3bc352908d83510b78'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('70dfbab5bc1392f5708188f3d1e6fb1e', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9eccc4fd23dc88c5d89f5d3bc352908d83510b78'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 5151
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0013  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filename, 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, GROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actors, GROUP_CONCAT(DISTINCT(ACT.tmdb_actor_id) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actor_ids
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movie_posters` `MP` ON `MT`.`title_id` = `MP`.`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`
LEFT JOIN `ml_junction_movies_actors` `JMA` ON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 5151
GROUP BY `title_id` ?>
0.0003  
SET SESSION group_concat_max_len = 1024 ?>
0.0004  
SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 5151
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0003  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5151 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 13 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)