Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Robot Jox (1989)

Directed by Stuart Gordon

Most recently watched by sleestakk

Overview

50 years after a nuclear war, the two superpowers handle territorial disputes in a different way. Each fields a giant robot to fight one-on-one battles in official matches, each piloted by a man inside, known as robot jockeys or jox. The contest for possession of Alaska will be fought by two of the best. The conscientious Achilles fights for the Americans. Opposing him is a Russian, Alexander.

Rated PG | Length 85 minutes

Actors

Gary Houston | Hilary Mason | Robert Sampson | Larry Dolgin | Stuart Gordon | Jeffrey Combs | Thyme Lewis | Ian Patrick Williams | Carolyn Purdy-Gordon | Danny Kamekona | Jason Marsden | Paul Koslo | Hal Yamanouchi | Gary Graham | Anne-Marie Johnson | Geoffrey Copleston | Bruce McGuire | Del Russel | James Sampson | David Cameron | Wayne Brewer | Alex Vitale | Russel Case | Michael Alldredge | Claire Hardwick | John Shannon | Steve Pelot | Mark D'Auria | Jacob Wheeler | Luca Amitrano | Jenai Ricci | Jillian Gordon | Suzanna Gordon | Marisa Menkins | Michael Vermaaten | Sung Yee Tchao | Matteo Barzini | Daniel Lederman

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Overview / Movie Detail )  0.0239
Total Execution Time  0.0258
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,760 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4354
  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` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('018ff58b57b009f1d2b2870c60743909', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5b1bec35c8a6f7baba5d815573144835332d9da6'
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` = 4354
 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` = 4354
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` = 4354
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4354 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)