Movielogr

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

The Dead Pool (1988)

Directed by Buddy Van Horn

Most recently watched by vivalaserdisc

Overview

Dirty Harry Callahan returns for his final film adventure. Together with his partner Al Quan, he must investigate the systematic murder of actors and musicians. By the time Harry learns that the murders are a part of a sick game to predict the deaths of celebrities before they happen, it may be too late…

Rated R | Length 91 minutes

Actors

Clint Eastwood | Jim Carrey | Patricia Clarkson | Liam Neeson | David Hunt | Michael Currie | Evan C. Kim | Justin Whalin | W. Axl Rose | Slash | Duff McKagan | Izzy Stradlin | Steven Adler | Kristopher Logan | Lloyd Nelson | Michael Goodwin | Marc Alaimo | John Allen Vick | Ronnie Claire Edwards | Louis Giambalvo | George Orrison | Charles Martinet | Darwin Gillett | Jeff Richmond | Christopher P. Beale | Patrick N. Van Horn | Sigrid Wurschmidt | Victoria Bastel | Anthony Charnota | Shawn Elliott | Bill Wattenburg

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0262
Total Execution Time  0.0275
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,040 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2436
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0045 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a11276259a592dec36e8eaaf0be407ceb97537c5'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('f3f190298430214e742fd93d7aa27ccb', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a11276259a592dec36e8eaaf0be407ceb97537c5'
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` = 2436
 LIMIT 1 ?>
0.0002  
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 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` = 2436
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` = 2436
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0004  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2436 ?>
0.0003  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)