Movielogr

movie poster

Average Rating: 9/10

View on: IMDb | TMDb

Chicago (2002)

Directed by Rob Marshall

Most recently watched by pknail

Overview

Murderesses Velma Kelly and Roxie Hart find themselves on death row together and fight for the fame that will keep them from the gallows in 1920s Chicago.

Rated PG-13 | Length 113 minutes

Actors

Lucy Liu | Richard Gere | Catherine Zeta-Jones | Jayne Eastwood | John C. Reilly | Eve Crawford | Renée Zellweger | Colm Feore | Christine Baranski | Queen Latifah | Dominic West | Taye Diggs | Cliff Saunders | Chita Rivera | Susan Misner | Denise Faye | Deidre Goodwin | Mýa | Ekaterina Chtchelkanova | Jonathan Whittaker | Sean McCann | Joseph Scoren | Laura Dean | Roman Podhora | Brendan Wall | Conrad Dunn | Darren Lee | Rick Negron | Karen Holness | Jeff Pustil | Monique Ganderton | Sara Ramirez | Michelle Johnston | Jeff Clarke | Scott Fowler | Marty Moreau | Robbie Rox | Nicki Richards | Kathryn Zenna | April Morgan | Sean Palmer | Robert Montano | Blake McGrath | Ken Ard | Sean Wayne Doyle | Harrison Beal | Cynthia Onrubia | Paul Becker | Desmond Richardson | Danielle Rueda-Watts | Robert Smith | Vicky Lambert | Steve Behal | Eric Troyer | Joey Pizzi | Troy P. Liddell | Gregory Mitchell | Tara Nicole Hughes | Melanie A. Gage | Sebastian La Cause | Kelsey Chace | Rhonda Roberts | Sheri Godfrey | Faye Rauw | Ted Banfalvi | Shaun Amyot | Mary Ann Lamb | Jocelyn Dowling | Bruce Beaton | Natalie Willes | Martin Samuel | Roxane Barlow | Brittany Gray | Catherine Chiarelli | Patrick Salvagna | Timothy Shew | Bill Corsair | Margaret Dorn | Leigh Torlage | Jodi McFadden | Karine Plantadit | Amber-Kelly Mackereth | Karen Andrew | Scott Wise | Cleve Asbury | Sergio Trujillo | Rod Campbell | Darius De Haas | Robyn Wong | Capathia Jenkins | Marc Calamia | Niki Wray | Bill Britt | Gerry Fiorini | Elizabeth Law | Brett Caruso | Charley King | Jennifer Savelli | Theresa Coombe | Lisa Ferguson | Melissa Flerangile | Michelle Galati | Jean-Luc Côté | Edgar Godineaux | Bill Hartung | Jason Sermonia | Jeff Siebert | Stacy Clark Baisley | Megan Fehlberg | Rachel Jacobs | Rebecca Leonard | Erin Michie | Dana Calitri | Kate Coffman-Lloyd | Curtis King Jr. | Audrey Martells | Dennis Collins | Willie Falk | Alfonzo Thornton

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0251
Total Execution Time  0.0266
  GET DATA  
No GET data exists
  MEMORY USAGE  
529,528 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2390
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0052 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('01ca37e9d2f753d88b3e751725b82248'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd1e0e9768e2b13f50738d14771d0af01dde0a4ec'
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` = 2390
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0028   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` = 2390
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` = 2390
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2390 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 20 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)