Movielogr

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Lady in the Water (2006)

Directed by M. Night Shyamalan

Most recently watched by sleestakk

Overview

Apartment building superintendent Cleveland Heep rescues what he thinks is a young woman from the pool he maintains. When he discovers that she is actually a character from a bedtime story who is trying to make the journey back to her home, he works with his tenants to protect his new friend from the creatures that are determined to keep her in our world.

Rated PG-13 | Length 110 minutes

Actors

Jeffrey Wright | Freddy Rodríguez | Grant Monohon | M. Night Shyamalan | Brian Steele | Bob Balaban | Paul Giamatti | Jeremy Howard | Jared Harris | Doug Jones | Noah Gray-Cabey | Bryce Dallas Howard | Sarita Choudhury | David Ogden Stiers | Tovah Feldshuh | Monique Gabriela Curnen | Mary Beth Hurt | Bill Irwin | Cindy Cheung | Joseph D. Reitman | John Boyd | Ethan Cohn | Joel Garland | Tom Mardirosian | June Kyoto Lu | Marilyn Torres | Kurt Carley | Carla Jimenez | Brian Weaver | George Bass | Nell Johnson | James Breen | Kevin Frank | Natasha Perez | Maricruz Hernandez | Walter Lafty | Mark Melchiorre Jr. | Nick Perri

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0256
Total Execution Time  0.0271
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,696 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4422
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0042 seconds)  (Hide)
0.0004   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.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
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` = 4422
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0016   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` = 4422
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` = 4422
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4422 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)