Movielogr

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

The Baby's Room (2006)

Directed by Álex de la Iglesia

Most recently watched by noahphex

Overview

Juan and Sonia arrive at a large old house, an ideal place to raise their newborn son. When, one night before going to bed, they check the operation of the monitoring device installed in the baby’s room, they discover that someone is sitting next to the crib.

Length 80 minutes

Actors

Leonor Watling | Antonio de la Torre | Antonio Dechent | Sancho Gracia | Javier Gutiérrez | Asunción Balaguer | Ramón Barea | Terele Pávez | María Asquerino | Rodolfo Sancho | Eulalia Ramón | Juanma Pagazaurtundua | Cesáreo Estébanez | Manuel Tallafé | Gracia Olayo | Enrique Martínez | Francisco Muñoz | Isidro Montalvo | Elena Jiménez | Carolo Ruiz | Penélope Velasco | Adolfo Lasarte | Carmina Rodríguez | César De Juan | Christopher Torres | Eduardo Uceda | Isidro Grimaidos | Vanesa Espín | Márgara Fernández | Marta Bódalo | Jesús Pardo | Alfonso Morlón

  BENCHMARKS  
Loading Time: Base Classes  0.0100
Controller Execution Time ( Overview / Movie Detail )  0.0357
Total Execution Time  0.0457
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,112 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3457
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0078 seconds)  (Hide)
0.0010  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '219d7c9ec1235d28887c44edeef109d635d51ae7'
AND `ip_address` = '216.73.216.6' ?>
0.0008  
SELECT GET_LOCK('786c08d06011a8338ff56ac3c57b6055', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '219d7c9ec1235d28887c44edeef109d635d51ae7'
AND `ip_address` = '216.73.216.6' ?>
0.0025  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3457
 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 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` = 3457
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` = 3457
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0004  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3457 ?>
0.0004  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)