Movielogr

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

RoboCop 3 (1993)

Directed by Fred Dekker

Most recently watched by noahphex

Overview

The mega corporation Omni Consumer Products is still bent on creating their pet project, Delta City, to replace the rotting city of Detroit. Unfortunately, the inhabitants of the area have no intention of abandoning their homes simply for desires of the company. To this end, OCP have decided to force them to leave by employing a ruthless mercenary army to attack and harass them. An underground resistance begins and in this fight, RoboCop must decide where his loyalties lie.

Rated PG-13 | Length 104 minutes

Actors

Shane Black | Daniel von Bargen | Lee Arenberg | Kurtwood Smith | Ray Wise | Rick Seaman | Rip Torn | Mako | Bradley Whitford | John Castle | Stanley Anderson | Stephen Root | CCH Pounder | Robert DoQui | Robert John Burke | Paul McCrane | Bruce Locke | Wilbur Fitzgerald | Nancy Allen | Felton Perry | Jesse D. Goins | Mario Machado | Remy Ryan | Jodi Long | John Posey | S.D. Nemeth | Edith Ivey | Jill Hennessy | Gary Bullock | Curtis Taylor | Jeff Garlin | Michael H. Moss | Alex Van | Calvin Jung | David de Vries | Eva LaRue | Blaise Corrigan | James Lorinz | Ken Strong | Angie Bolling | Kenny Jones | Lonnie R. Smith Jr. | Eddie Billups | Judson Vaughn | Doug Yasuda | Graciela Marin | Ron Leggett | John Nesci | Randall Taylor | Kenny Raskin | Marc Gowan | Thomas Boyd | Tommy Chappelle | Beth Burns | Randy Randolph | Bryan Mercer | Gordon Mark | Dianne Butler

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Overview / Movie Detail )  0.0238
Total Execution Time  0.0257
  GET DATA  
No GET data exists
  MEMORY USAGE  
520,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3251
  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` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
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` = 3251
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0019   SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, MAX(MP.filename) AS filenameGROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_CONCAT(DISTINCT(DR.tmdb_director_id) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS director_idsGROUP_CONCAT(DISTINCT(ACT.actor_name) ORDER BY ACT.tmdb_actor_id ASC SEPARATOR "|") AS actorsGROUP_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` `MPON `MT`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
LEFT JOIN `ml_junction_movies_actors` `JMAON `MT`.`title_id` = `JMA`.`title_id`
LEFT JOIN `ml_actors_new` `ACTON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `MT`.`title_id` = 3251
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` `MVON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MTON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 3251
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3251 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)