Movielogr

movie poster

View on: IMDb | TMDb

Walk on Water (2004)

Directed by Eytan Fox

Overview

Eyal, an Israeli Mossad agent, is given the mission to track down and kill the very old Alfred Himmelman, an ex-Nazi officer, who might still be alive. Pretending to be a tourist guide, he befriends his grandson Axel, in Israel to visit his sister Pia. The two men set out on a tour of the country, during which Axel challenges Eyal’s values.

Length 103 minutes

Actors

Lior Ashkenazi | Knut Berger | Caroline Peters | Gideon Shemer | Carola Regnier | Hanns Zischler | Ernest Lenart

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Movie Detail )  0.0282
Total Execution Time  0.0297
  GET DATA  
No GET data exists
  MEMORY USAGE  
505,472 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6473
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '997bee3cc629500029eff8906a6e548b192a5578'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('ae355e04f5f330768f3547da28600209', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '997bee3cc629500029eff8906a6e548b192a5578'
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` = 6473
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0021  
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` = 6473
GROUP BY `title_id` ?>
0.0002  
SET SESSION group_concat_max_len = 1024 ?>
0.0005  
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` = 6473
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0002  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6473 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)