Movielogr

Home

movie poster

Average Rating: 8/10

View on: IMDb | TMDb

Night Watch (2004)

Directed by Timur Bekmambetov

Most recently watched by noahphex, jenerator, sleestakk

Overview

Among normal humans live the “Others” possessing various supernatural powers. They are divided up into the forces of light and the forces of the dark, who signed a truce several centuries ago to end a devastating battle. Ever since, the forces of light govern the day while the night belongs to their dark opponents. In modern day Moscow the dark Others actually roam the night as vampires while a “Night Watch” of light forces, among them Anton, the movie’s protagonist, try to control them and limit their outrage

Rated R | Length 114 minutes

Actors

Konstantin Khabenskiy | Mariya Poroshina | Vladimir Menshov | Galina Tyunina | Zhanna Friske | Viktor Verzhbitskiy | Nurzhuman Ikhtymbayev | Aleksei Maklakov | Aleksandr Samoylenko | Yuriy Kutsenko | Georgiy Dronov | Nikolay Olyalin | Rimma Markova | Igor Lifanov | Mariya Mironova | Anna Dubrovskaya | Dmitriy Martynov | Anna Slyusareva | Ilya Lagutenko | Konstantin Murzenko | Aleksey Chadov | Igor Gasparyan | Igor Savochkin | Viktoriya Smirnova | Anna Semenovich | Aleksandra Nazarova | Vladimir Sterzhakov | Igor Pismennyy | Valeriy Zolotukhin | Sergey Kalashnikov | Stepan Starchikov | Oleg Mokshantsev | Ekaterina Malikova | Anatoliy Gorin | Michail Solodko | Andrey Bogdanov | Romuald Makarenko | Galina Stakhanova | Marina Ivanova | Aleksandr Schurok | Kseniya Novikova | Sergey Prikhodko | Aleksandr Kozlov | Tatyana Shchankina | Vladimir Ivanov

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0206
Total Execution Time  0.0220
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,272 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3330
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0038 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('0fea357d757995380c040d3ea929c528', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
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` = 3330
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 3330
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 3330
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3330 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 18 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)