Movielogr

Home

movie poster

Average Rating: 5/10

View on: IMDb | TMDb

Street Kings 2: Motor City (2011)

Directed by Chris Fisher

Most recently watched by sensoria

Overview

Detroit detective Marty Kingston (Liotta) is the leader of an undercover narcotics team, whose members are being systematically murdered one by one. To solve the brutal killings, Kingston joins forces with a cocky, young homicide detective. But neither of them is prepared for the shocking corruption their investigation will uncover — stunning secrets that will set both men on a violent collision course with betrayal and vengeance.

Rated R | Length 93 minutes

Actors

Kevin Chapman | Ray Liotta | Shawn Hatosy | Clifton Powell | Gordon Michaels | Ele Bardha | Linda Boston | Julia Ho | Charlotte Ross | Jack Moore | Ron Causey | Steven Hauptman | Tim Holmes | Inbar Lavi | Tiren Jhames | Stephanie Cotton | Corey Emanuel Wilson | Joe Tinpan | Sidi Henderson | Otis Youngsmith | Scott Norman | Wendy Aaron | Jay Harper | Lisa Lauren Smith | Roland Matthews | Nesti Gee | Amanda Wright | Isaac Ellis | Tia Fletcher | Christopher L. Dixon | Tim Craiger | Chancler Haynes | Noli McCool | Victor Pytko

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Movie Detail )  0.0335
Total Execution Time  0.0351
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4953
  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` = '22f777a1f06f69e98506402a087cde14c36b813a'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('3a471159f14e538772ee43e887371afe', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '22f777a1f06f69e98506402a087cde14c36b813a'
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` = 4953
 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 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` = 4953
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` = 4953
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0004   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4953 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 12 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)