Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Case 39 (2009)

Directed by Christian Alvart

Most recently watched by sensoria, noahphex

Overview

In her many years as a social worker, Emily Jenkins believes she has seen it all, until she meets 10-year-old Lilith and the girl’s cruel parents. Emily’s worst fears are confirmed when the parents try to harm the child, and so Emily assumes custody of Lilith while she looks for a foster family. However, Emily soon finds that dark forces surround the seemingly innocent girl, and the more she tries to protect Lilith, the more horrors she encounters.

Rated R | Length 109 minutes

Actors

Callum Keith Rennie | Ian McShane | Jodelle Ferland | Renée Zellweger | Mary Black | Colin Lawrence | Andrew Airlie | Bradley Cooper | Sarah-Jane Redmond | Daniel Bacon | Darryl Quon | Cynthia Stevenson | Fulvio Cecere | Domenico D'Ambrosio | Benita Ha | Adrian Lester | Bill Mondy | Charles Zuckermann | Alisen Down | Kerry O'Malley | Vanesa Tomasino | Alexander Conti | Phillip Mitchell | Lesley Ewen | Taya Calicetto | Suzanne Bastien | Fran Gebhard | Dalias Blake | David Patrick Green | Michael Bean | Darren E. Scott | Philip Cabrita | J. Winston Carroll | Dee Jay Jackson | Yvonne Valdez | Jane Braithwaite | Paul Duchart | Dagmar Midcap

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0226
Total Execution Time  0.0240
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,512 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2005
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0037 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f49b335b4d6731befab74d9de024ab52bfbdfe5a'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('9748edb4d7b06dcb95b59880cb9f2b98', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f49b335b4d6731befab74d9de024ab52bfbdfe5a'
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` = 2005
 LIMIT 1 
0.0002   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` = 2005
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 2005
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2005 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)