Movielogr

Home

movie poster

View on: IMDb | TMDb

Shortbus (2006)

Directed by John Cameron Mitchell

Overview

A group of New Yorkers caught up in their romantic/sexual milieu converge at Shortbus, an underground Brooklyn salon infamous for its blend of art, music, politics, and carnality, and loosely inspired by various underground NYC gatherings that took place in the early 2000s. Here, gay couple Jamie and James meet Ceth, a young ex-model and aspiring singer.

Rated NR | Length 101 minutes

Actors

David Pittu | Jonathan Caouette | John Cameron Mitchell | Miriam Shor | Jay Brannan | Lindsay Beamish | PJ DeBoy | Raphael Barker | Paul Dawson | Peter Stickles | Sook-Yin Lee | Justin Hagan | Ray Rivas | Bitch | Shanti Carson | Bradford Scobie | Reg Vermue | Adam Hardman | Alan Mandell | Jan Hilmer | Stephen Kent Jusick | Yolonda Ross | Jocelyn Samson | Daniela Sea | Rachael C. Smith | Derek Jackson | Mary Beth Peil | Tristan Taormino | Justin Bond | Mickey Cottrell | Dirty Martini | Eric Gilliland | Jeff Whitty | Rachel Friedman | Lex Vaughn | Murray Hill | Scott Matthew | The World Famous *BoB* | Paul Oakley Stovall | Ethan Eunson-Conn | Tanya Gagné | Adrienne Truscott | Timmy Young | Jasper James | Grace Kahng | Harry Slattery | Ralph Gunderman

  BENCHMARKS  
Loading Time: Base Classes  0.0022
Controller Execution Time ( Overview / Movie Detail )  0.0235
Total Execution Time  0.0258
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,936 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/7016
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0047 seconds)  (Hide)
0.0003   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('434c6d043783bc2d90d6a6386c81ab1b', 300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
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` = 7016
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0023   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` = 7016
GROUP BY `title_id` 
0.0002   SET SESSION group_concat_max_len = 1024 
0.0003   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` = 7016
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 7016 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)