Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

S.W.A.T. (2003)

Directed by Clark Johnson

Most recently watched by suspectk

Overview

Hondo Harrelson recruits Jim Street to join an elite unit of the Los Angeles Police Department. Together they seek out more members, including tough Deke Kay and single mom Chris Sanchez. The team’s first big assignment is to escort crime boss Alex Montel to prison. It seems routine, but when Montel offers a huge reward to anyone who can break him free, criminals of various stripes step up for the prize.

Rated PG-13 | Length 117 minutes

Actors

Samuel L. Jackson | Josh Charles | Ken Davitian | Octavia Spencer | Gregory Sporleder | Denis Arndt | Neal H. Moritz | Brian Van Holt | Olivier Martinez | Jeremy Renner | Michelle Rodriguez | Domenick Lombardozzi | Michael Papajohn | Larry Poindexter | Reed Diamond | LL Cool J | Reg E. Cathey | Clark Johnson | Max Thayer | Noel Gugliemi | Ashley Scott | Colin Farrell | James DuMont | Matt Gerald | Jeff Wincott | Benjamin King | Marcio Rosario | Lindsey Ginter | Alex Trebek | Page Kennedy | Sergio Kato | Tricia Kelly | Jay Montalvo

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0192
Total Execution Time  0.0205
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,528 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4573
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0039 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = 'fc10446e35b952af9add9fbaead90e29163c9135'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT GET_LOCK('3e07e022fb460450f98b0cfb19ce9d70', 300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'fc10446e35b952af9add9fbaead90e29163c9135'
AND `ip_address` = '216.73.216.137' 
0.0002   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 4573
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0014   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` = 4573
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0005   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` = 4573
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4573 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 14 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)