Movielogr

Home

movie poster

Average Rating: 7.5/10

View on: IMDb | TMDb

They Live (1988)

Directed by John Carpenter

Most recently watched by sensoria

Overview

Nada, a wanderer without meaning in his life, discovers a pair of sunglasses capable of showing the world the way it truly is. As he walks the streets of Los Angeles, Nada notices that both the media and the government are comprised of subliminal messages meant to keep the population subdued, and that most of the social elite are skull-faced aliens bent on world domination. With this shocking discovery, Nada fights to free humanity from the mind-controlling aliens.

Rated R | Length 94 minutes

Actors

Larry J. Franco | Peter Jason | Norman Alden | Matt McColm | John Carpenter | Tommy Morrison | Robert V. Greene | Meg Foster | Roddy Piper | John F. Goff | George Buck Flower | Raymond St. Jacques | Sy Richardson | Al Leong | Keith David | Norman Howell | John Lawrence | Jon Paul Jones | Norman D. Wilson | Susan Barnes | Susan Blanchard | Eileen Wesson | Jeff Imada | Jeb Stuart Adams | Robert Grasmere | Christine Baur | Jason Robards III | Stratton Leopold | Kerry Rossall | Gregory J. Barnett | Wendy Brainard | Lucille Meredith | Dana Bratton | Thelma Lee | Rezza Shan | Tom Searle | Vince Inneo | Dennis Michael | Nancy Gee | Claudia Stanlee | Jim Nickerson | Michelle Costello | Helen Kelly | Jennifer Austin | Michael Forino | Gunnar Magg | Bob Hudson | Cibby Danyla

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0212
Total Execution Time  0.0224
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2299
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0043 seconds)  (Hide)
0.0005   SELECT 1
FROM `ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT GET_LOCK('0fea357d757995380c040d3ea929c528', 300) AS ci_session_lock 
0.0003   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` = 2299
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 2299
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` = 2299
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2299 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 17 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)