Movielogr

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Tropic Thunder (2008)

Directed by Ben Stiller

Most recently watched by sleestakk

Overview

A group of self-absorbed actors set out to make the most expensive war film ever. After ballooning costs force the studio to cancel the movie, the frustrated director refuses to stop shooting, leading his cast into the jungles of Southeast Asia, where they encounter real bad guys.

Rated R | Length 107 minutes

Actors

Jay Baruchel | Tom Cruise | Nick Nolte | Tobey Maguire | Robert Downey Jr. | Steve Coogan | Alicia Silverstone | Ben Stiller | Miko Hughes | Jon Voight | Matthew McConaughey | Justin Theroux | Christine Taylor | Bill Hader | Reggie Lee | Jason Bateman | Amy Stiller | Jennifer Love Hewitt | Rachel Avery | Brandon T. Jackson | Trieu Tran | Danny McBride | Valerie Azlynn | Jack Black | Maria Menounos | Lance Bass | Tyra Banks | James Lew | Yvette Nicole Brown | David Pressman | Mini Anden | Simon Rhee | John Garry | Nadine Ellis | Anthony Ruivivar | Matt Levin | Anya Monzikova | Natalie Cohen | Linda Bella | Andrea De Oliveira | Brandon Soo Hoo | Jeff Kahn | Jasmine Dustin | Gaku Space | Chad Mountain | Jeff Weidemann | Eric Feliciano | Jillian Johnston | Eric Winzenried | Kaylee Dodson | Jobeth Wagner | Becca Sweitzer | Brittany Perry-Russell | Rod Tate | Dempsey Silva | Darryl Farmer | Jel Galiza | Mike Hoagland | Denise Bradley | Ella Christopher | Larry Cruz | Angela Daun | Clark DeVol | David D. Espinoza | Dave Johnson | Lesley Nicole Lewis | Fadhia Carmelle Marcelin | Samantha Sadoff | Kaye Marie Talise | Sandra Valladares | Julie Van | J. Thomas Chon | Jacob Chon

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0187
Total Execution Time  0.0200
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,528 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4377
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0048 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '5d197095ec5a1c6e3a67356e1626eaaf137b46ed'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('dd63578f369761c9a890bb352daff0e7'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5d197095ec5a1c6e3a67356e1626eaaf137b46ed'
AND `ip_address` = '216.73.216.137' 
0.0003   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4377
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0025   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` = 4377
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` = 4377
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4377 
0.0001   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)