Movielogr

Home

movie poster

View on: IMDb | TMDb

Dune (1984)

Directed by David Lynch

Overview

In the year 10,191, the most precious substance in the universe is the spice Melange. The spice extends life. The spice expands consciousness. The spice is vital to space travel.  The spice exists on only one planet in the entire universe, the vast desert planet Arrakis, also known as Dune.  Its native inhabitants, the Fremen, have long held a prophecy that a man would come, a messiah who would lead them to true freedom.

Rated PG-13 | Length 137 minutes

Actors

Sean Young | Jürgen Prochnow | Dean Stockwell | Sting | Brad Dourif | Max von Sydow | Patrick Stewart | Alicia Witt | David Lynch | Everett McGill | Kyle MacLachlan | Jack Nance | Angélica Aragón | Francesca Annis | Leonardo Cimino | José Ferrer | Linda Hunt | Freddie Jones | Richard Jordan | Virginia Madsen | Silvana Mangano | Kenneth McMillan | Siân Phillips | Margarita Sanz | Paul L. Smith | Judd Omen | Jacqueline Voltaire | Danny Corkill | Ramón Menéndez | Claudia Ramírez | Molly Wryn | Honorato Magaloni | Ernesto Laguardia | Julieta Rosen | Ana Ofelia Murguía | Humberto Elizondo | Thomas Ebert | John Sabol | Ricardo Hill

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0348
Total Execution Time  0.0364
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,888 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/5873
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0098 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT GET_LOCK('35517b52ac0b9236e38b69209c6c7c0c', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '1ebcef30dc992a7b1bfc3d63c98f6d72449a124c'
AND `ip_address` = '216.73.216.111' 
0.0055   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 5873
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len = 12288 
0.0020   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` = 5873
GROUP BY `title_id` 
0.0002   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` = 5873
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 5873 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)