Movielogr

Home

movie poster

View on: IMDb | TMDb

The English Patient (1996)

Directed by Anthony Minghella

Overview

In the 1930s, Count Almásy is a Hungarian map maker employed by the Royal Geographical Society to chart the vast expanses of the Sahara Desert along with several other prominent explorers. As World War II unfolds, Almásy enters into a world of love, betrayal, and politics.

Rated R | Length 162 minutes

Actors

Jürgen Prochnow | Juliette Binoche | Sebastian Schipper | Willem Dafoe | Ralph Fiennes | Kristin Scott Thomas | Naveen Andrews | Colin Firth | Julian Wadham | Kevin Whately | Clive Merrison | Nino Castelnuovo | Hichem Rostom | Peter Rühring | Geordie Johnson | Torri Higginson | Liisa Repo-Martell | Ray Coulthard | Philip Whitchurch | Matthew Ferguson | Sebastian Rudolph | Anthony Smee | Rim Turkhi | Lee Ross | Amanda Walker | Dominic Mafham | Simon Sherlock | Jason Done | Gregor Truter | Roger Morlidge | Sondos Belhassen | Sonia Mankaï | Salah Miled | Abdellatif Hamrouni | Fritz Eggert | Thoraya Sehill | Samy Azaiez | Habib Chetoui | Philippa Day | Paul Kant

  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Movie Detail )  0.0223
Total Execution Time  0.0237
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,704 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6644
  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` = 'ecf169f665793d2d227d2544fc73c59956f0452c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('dec3988d182f21d16f58e9c2027d2707', 300) AS ci_session_lock 
0.0004   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` = 6644
 LIMIT 1 
0.0003   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` = 6644
GROUP BY `title_id` 
0.0003   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` = 6644
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6644 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)