Movielogr

Home

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Silent Hill (2006)

Directed by Christophe Gans

Most recently watched by sleestakk, sensoria

Overview

Rose, a desperate mother takes her adopted daughter, Sharon, to the town of Silent Hill in an attempt to cure her of her ailment. After a violent car crash, Sharon disappears and Rose begins a desperate search to get her back. She descends into the center of the twisted reality of a town’s terrible secret. Pursued by grotesquely deformed creatures and townspeople stuck in permanent purgatory, Rose begins to uncover the truth behind the apocalyptic disaster that burned the town 30 years earlier.

Rated R | Length 125 minutes

Actors

Sean Bean | Alice Krige | Nicky Guadagni | Radha Mitchell | Laurie Holden | Kim Coates | Tanya Allen | Jodelle Ferland | Colleen Williams | Ron Gabriel | Derek Ritschel | Eve Crawford | Amanda Hiebert | Roberto Campanella | Maxine Dumont | Deborah Kara Unger | Christopher Britton | Lorry Ayers | Stephen R. Hart | Elizabeth Harpur | Janet Land | Nicole Ann St. Hill | Zsuzsanna Cseh | Hannah Fleming | Chantelle Leonardo | Carrie Eklund | Victor Sutton | Melissa Panton | Rhoslynne Bugay | Samantha Hayes | Noelle Boggio | Yvonne Ng | Michael Cota | Florence MacGregor | Lynn Woodman | Holly Makarchuk | Tatiana Haas | Emily Lineham | Donna Milburn | Nadia Barosso | Victoria Boland | Alicia Bundy | Rachel Crowther | Judit Kovacs | Stephanie Lauder | Onika Ndukwe | Kat Olsen | Sylwia Pluta | Lisa Shaw | Tamara Smeaton

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0261
Total Execution Time  0.0275
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,640 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4417
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('5c63e7dda8ad846f1b707d27edd49878', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c7bea41d7b5a3476aa4b92f96dc946930ef18d3e'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4417
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 4417
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0003   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` = 4417
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4417 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)