Movielogr

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.0018
Controller Execution Time ( Overview / Movie Detail )  0.0407
Total Execution Time  0.0425
  GET DATA  
No GET data exists
  MEMORY USAGE  
512,624 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5879
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 9 (0.0133 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('1553c189226ba76d51e2ab87d808dd79', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9e38e9a5a9eba6278c99afd25c71a64e8e65b6a6'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 5879
 LIMIT 1 ?>
0.0028  
SET SESSION group_concat_max_len = 12288 ?>
0.0081  
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.0003  
SET SESSION group_concat_max_len = 1024 ?>
0.0006  
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.0003  
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)