Movielogr

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

Freddy vs. Jason (2003)

Directed by Ronny Yu

Most recently watched by noahphex, sleestakk

Overview

Disfigured serial killer Freddy Krueger, who attacks his victims in their dreams, has lost much of his power since citizens of his town have become less afraid of him. Enlisting the help of fellow violent murderer Jason Voorhees, Freddy orchestrates a new killing spree. However, when the hockey-mask-wearing psychopath won’t stop chopping up Freddy’s intended victims, the two ghouls start to battle each other.

Rated R | Length 97 minutes

Actors

Robert Englund | Zack Ward | Robert Shaye | Monica Keena | Evangeline Lilly | Garry Chalk | Katharine Isabelle | Brendan Fletcher | Kyle Labine | Alex Green | Ken Kirzinger | Jason Ritter | Eileen Pedde | Chris Gauthier | Lochlyn Munro | Chris Marquette | Viv Leacock | Alistair Abell | Brent Chapman | Tom Butler | David Kopp | Kelly Rowland | Paula Shaw | Kimberley Warnat | Jesse Hutch | Colby Johannson | Claire Riley | Óscar Gutiérrez | Odessa Munroe | Spencer Stump | Joëlle Antonissen | Kevin Hansen | Jamie Mayo | Blake Mawson | Tony Willett | Sharon Peters | Sarah-Anne Hepher | Kirsti Forbes | Taryn McCulloch | Sean Tyler Foley | Jacqueline Stewart | Laura Boddington | Colton Shock | Spencer Doduk | Anysha Berthot | Zara McDowell | Sasha Piltsin

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0213
Total Execution Time  0.0231
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,424 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3337
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0fea357d757995380c040d3ea929c528'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3337
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0017   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 3337
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0004   SELECT `username`, `date_viewed`, `MV`.`movie_id`
FROM `ml_users` `MU`
JOIN `ml_movies` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 3337
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3337 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)