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.0542
Controller Execution Time ( Overview / Movie Detail )  0.0549
Total Execution Time  0.1105
  GET DATA  
No GET data exists
  MEMORY USAGE  
802,344 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/3523
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 9 (0.0049 seconds)  (Hide)
0.0011   SELECT GET_LOCK('3e2617a8c7089c0fc872710dab450577'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f935a6971e9e604bb57e56fe9e841119b50d602b'
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` = 3523
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0018   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` = 3523
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` = 3523
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 3523 
0.0004   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 16 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)