Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

The Living and the Dead (2006)

Directed by Simon Rumley

Most recently watched by noahphex

Overview

Lord Donald and Lady Nancy reside in the magnificent but run-down Longleigh House with James, their mentally disabled adult son. Nancy has fallen seriously ill and Donald is preparing to sell the house to raise enough money to pay for an operation. He arranges for the family nurse, Mary, to take care of Nancy while he leaves to tend to the sale. However, James wants to prove to his father that he can look after his mother on his own and decides to lock Mary out of the house. It isn’t long before James starts mixing his mother’s pills and forgetting to take his own medication, and as the stress of looking after his mother increases, so too does the severity of his own condition.

Length 83 minutes

Actors

Leo Bill | Roger Lloyd-Pack | Sarah Ball | Kate Fahy | Richard Wills-Cotton | Neil Conrich

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Overview / Movie Detail )  0.0263
Total Execution Time  0.0283
  GET DATA  
No GET data exists
  MEMORY USAGE  
506,680 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3158
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'dea1f79a000a01cf87a6553b5cbc2b237859ca04'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('3b1740ed003f808a04eac73db49f073d', 300) AS ci_session_lock ?>
0.0008  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'dea1f79a000a01cf87a6553b5cbc2b237859ca04'
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` = 3158
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0012  
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` = 3158
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` = 3158
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0003  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3158 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)