Movielogr

Home

movie poster

Average Rating: 6/10

View on: IMDb | TMDb

Fish Tank (2009)

Directed by Andrea Arnold

Most recently watched by noahphex

Overview

Mia is a rebellious teenager on the verge of being kicked out of school. Her hard-partying mother, Joanne, neglects Mia’s welfare in favor of her own, and her younger sister hangs out with a much older crowd. Sparks fly between Mia and Connor, Joanne’s new boyfriend, and he encourages Mia to pursue her interest in dance. As the boundaries of the relationships become blurred, Mia and Joanne compete for Connor’s affection.

Rated NR | Length 123 minutes

Actors

Kierston Wareing | Michael Fassbender | Harry Treadaway | Katie Jarvis | Grant Wild | Sarah Bayes | Anthony Geary | Jack Gordon | Jason Maza | Rebecca Griffiths | Kirsty Smith | Sydney Mary Nash | Carrie-Ann Savill | Toyin Ogidi | Charlotte Collins | Chelsea Chase | Brooke Hobby | Joanna Horton | Nick Staverson | Geoff McCracken | Val King | Peter Roue | Charlie Baker | Kishana Thomas | Raquel Thomas | Natasha Ilic | Maxine Brogan | Kirsty Page | Georgia Crane

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