Movielogr

movie poster

Average Rating: 7/10

View on: IMDb | TMDb

Brooklyn Castle (2012)

Directed by Katie Dellamaggiore

Most recently watched by sensoria, noahphex

Overview

Brooklyn Castle is a documentary about I.S. 318 – an inner-city school where more than 65 percent of students are from homes with incomes below the federal poverty level – that also happens to have the best, most winning junior high school chess team in the country. (If Albert Einstein, who was rated 1800, were to join the team, he’d only rank fifth best.) Chess has transformed the school from one cited in 2003 as a “school in need of improvement” to one of New York City’s best. But a series of recession-driven public school budget cuts now threaten to undermine those hard-won successes.

Rated PG | Length 101 minutes

Actors

John Galvin | Elizabeth Vicary | Rochelle Ballantyne | Pobo Efekoro | Justus Williams | Alex Stripunsky | James Stallings | Maurice Ashley | Alexis Paredes | Miron Sher | Patrick Johnston | Fortunato Rubio | James Black, Jr

  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Overview / Movie Detail )  0.0235
Total Execution Time  0.0254
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,416 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3523
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0037 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'b5ab33fb8282606575de8561eab4102128828e5b'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('9e218f1672658f6dc3e3a20d8533befb', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'b5ab33fb8282606575de8561eab4102128828e5b'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `MT`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
WHERE `MT`.`title_id` = 3523
 LIMIT 1 ?>
0.0002  
SET SESSION group_concat_max_len = 12288 ?>
0.0011  
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` = 3523
GROUP BY `title_id` ?>
0.0003  
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` = 3523
ORDER BY `date_viewed` DESC
 LIMIT 10 ?>
0.0003  
SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3523 ?>
0.0002  
SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)