Movielogr

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

The Specials (2000)

Directed by Craig Mazin

Most recently watched by noahphex

Overview

America’s 7th Best Superhero Team, the Specials, are a group of geeks and oddballs. We get to see one day in their lives as fan and new member Nightbird joins the group, just in time for the group to get a new line of action figures. But the members’ extreme personalities and personal issues threaten to rip the group apart.

Rated R | Length 82 minutes

Actors

Taryn Manning | Rob Lowe | Jamie Kennedy | Barry Del Sherman | James Gunn | Paget Brewster | Thomas Haden Church | Jordan Ladd | Judy Greer | Matt Champagne | Lauren Cohn | John Doe | Sean Gunn | Jenna Fischer | Jim Zulevic | Mark Gottwald | Mark A. Altman | Samantha Cannon | Jordan Warkol | Melissa Joan Hart | Chase Masterson | Judith Drake | Michael Weatherly | Patricia Gaul | Abdul Salaam El Razzac | Robert Meyer Burnett | Kelly Coffield Park | Lee Kirk | Beau Weaver | Frank Medrano | Mike Schwartz | Chuti Tiu | Tom Dorfmeister | Christopher Shea | Louis Martin Braga III | Johnny Mountain | Scott Torrence | Valerie Long | Brian Gunn

  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Movie Detail )  0.0289
Total Execution Time  0.0306
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/2715
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0042 seconds)  (Hide)
0.0003   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '8d8937cc38425818c653e56a96d013af0ef3ccf8'
AND `ip_address` = '216.73.216.111' 
0.0002   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.0004   SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 2715
 LIMIT 1 
0.0003   SET SESSION group_concat_max_len 12288 
0.0016   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` = 2715
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` = 2715
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 2715 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)