Movielogr

Home

movie poster

View on: IMDb | TMDb

War (2007)

Directed by Philip G. Atwell

Overview

FBI agent Jack Crawford is out for revenge when his partner is killed and all clues point to the mysterious assassin Rogue. But when Rogue turns up years later to take care of some unfinished business, he triggers a violent clash of rival gangs. Will the truth come out before it’s too late? And when the dust settles, who will remain standing?

Rated R | Length 103 minutes

Actors

Jason Statham | Jet Li | Eric Keenleyside | Saul Rubinek | Ryo Ishibashi | Devon Aoki | John Lone | Terry Chen | Aaron Pearl | Nadia Farès | John Novak | Luis Guzmán | Kenneth Choi | Andrea Roth | Aaron Au | Hiro Kanagawa | Sung Kang | Tim Perez | Mathew St. Patrick | Nadine Velazquez | Mark Cheng | Kane Kosugi | Kennedy Montano | Steph Song | Annika Foo | Nicholas Elia | Ildiko Ferenczi | Warren Takeuchi | Peter Shinkoda | Brian Ho | Allan Lysell | Randy Lee | Johnson Phan | Larry Lam | Jennifer Chang | Jung-Yul Kim | Bruce Bellocchi | Don Lew | Lucy Lu | Jennifer Chung | Tran Thi Thu | Wilken Yam | Mitchell A. Lee Yuen

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0211
Total Execution Time  0.0224
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,704 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5879
  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.0001   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707', 300) AS ci_session_lock 
0.0001   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` = 5879
 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` = 5879
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` = 5879
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5879 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)