Movielogr

Home

movie poster

View on: IMDb | TMDb

To Die For (1995)

Directed by Gus Van Sant

Overview

Suzanne Stone wants to be a world-famous news anchor and she is willing to do anything to get what she wants. What she lacks in intelligence, she makes up for in cold determination and diabolical wiles. As she pursues her goal with relentless focus, she is forced to destroy anything and anyone that may stand in her way, regardless of the ultimate cost or means necessary.

Rated R | Length 106 minutes

Actors

David Cronenberg | Gerry Quigley | Casey Affleck | Kurtwood Smith | Nicole Kidman | Alison Folland | Matt Dillon | Susan Traylor | Wayne Knight | Dan Hedaya | Joyce Maynard | Buck Henry | Illeana Douglas | Colleen Williams | Ron Gabriel | Eve Crawford | Holland Taylor | Michael Rispoli | George Segal | Katie Griffin | Tamara Gorski | Tim Hopper | Kyra Harper | Conrad Coates | Nicholas Pasco | Joaquin Phoenix | Rain Phoenix | Chris Phillips | Philip Williams | Sean Ryan | Maria Tucci | Simon Richards | David Collins | Adam Roth | Janet Lo | Graeme Millington | Tom Forrester | Alan Edward Lewis | Nadine MacKinnon | Ian Heath | Tom Quinn | Peter Glen | Amber-Lee Campbell | Susan Backs | Carla Renee | Mischa | Andrew Scott

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0205
Total Execution Time  0.0219
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,968 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6737
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0046 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '01d654fdfd9507ca97e402a78dfcf493b84cad68'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT GET_LOCK('4f962d0d65b9bc30004a76b38cd5f6f0', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '01d654fdfd9507ca97e402a78dfcf493b84cad68'
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` = 6737
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0021   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` = 6737
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` = 6737
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6737 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)