Movielogr

movie poster

Average Rating: 5.5/10

View on: IMDb | TMDb

Dragon Wars: D-War (2007)

Directed by Shim Hyung-rae

Most recently watched by sleestakk

Overview

Based on the Korean legend, unknown creatures will return and devastate the planet. Reporter Ethan Kendrick is called in to investigate the matter.

Rated PG-13 | Length 90 minutes

Actors

Holmes Osborne | Robert Forster | Elizabeth Peña | Chris Mulkey | Jason Behr | Geoff Pierson | Matthias Hues | Gregory Hinton | Derek Mears | Kevin Breznahan | Aimee Garcia | Amanda Brooks | Craig Robinson | John Ales | Billy Gardell | NiCole Robinson | Cody Arens | Jody Carlson | Dominic Oliver | Craig Anton | Patricia Lee | Eloy Casados | Alexa Sheehan | Retta | Kaycee | Gerard Griesbaum | Anthony Molinari | Rob Roy Fitzgerald | Ricky Kim | Cheyenne Alexis Dean | Min Ji-hwan | Jane Silvia

  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Overview / Movie Detail )  0.0297
Total Execution Time  0.0317
  GET DATA  
No GET data exists
  MEMORY USAGE  
514,840 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4396
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0076 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('8b16ad9a0fbba2b3d1663ce3c6f3d35d', 300) AS ci_session_lock ?>
0.0009  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4396
 LIMIT 1 ?>
0.0003  
SET SESSION group_concat_max_len = 12288 ?>
0.0043  
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` = 4396
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` = 4396
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0002  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4396 ?>
0.0004  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 13 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)