Movielogr

Home

movie poster

View on: IMDb | TMDb

The War of the Roses (1989)

Directed by Danny DeVito

Overview

The Roses, Barbara and Oliver, live happily as a married couple. Then she starts to wonder what life would be like without Oliver, and likes what she sees. Both want to stay in the house, and so they begin a campaign to force each other to leave. In the middle of the fighting is D’Amato, the divorce lawyer. He gets to see how far both will go to get rid of the other, and boy do they go far.

Rated R | Length 116 minutes

Actors

Dan Castellaneta | Danny DeVito | Sean Astin | G. D. Spradlin | Kathleen Turner | Michael Douglas | Peter Brocco | Roy Brocksmith | Peter Donat | Marianne Sägebrecht | Robert Harper | Peter Hansen | Ellen Crawford | David Wohl | Susan Isaacs | Patricia Allison | Shirley Mitchell | Tony Crane | Heather Fairfield | Trenton Teigen | Philip Perlman | Vickilyn Reynolds | Gloria Cromwell | Michael Adler | Mary Fogarty | Harlan Arnold | Prince Hughes | Lisa Howard | Popeye | Danitra Vance | Eunice Suarez | Jeff Thomas | Ryan Wickers | Jacqueline Cassell | Rika Hofmann | Bethany McKinney | Julia Elliott | Shaun Wickers | Catherine Donohue | Mary Donohue | Sue Palka | Morris Jones

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0195
Total Execution Time  0.0207
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6568
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0036 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
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` = 6568
 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` = 6568
GROUP BY `title_id` 
0.0001   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` = 6568
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6568 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)