Movielogr

movie poster

Average Rating: 6.5/10

View on: IMDb | TMDb

Battleship (2012)

Directed by Peter Berg

Most recently watched by noahphex, sensoria, sleestakk, KrazyKatAIC

Overview

When mankind beams a radio signal into space, a reply comes from ‘Planet G’, in the form of several alien crafts that splash down in the waters off Hawaii. Lieutenant Alex Hopper is a weapons officer assigned to the USS John Paul Jones, part of an international naval coalition which becomes the world’s last hope for survival as they engage the hostile alien force of unimaginable strength. While taking on the invaders, Hopper must also try to live up to the potential that his brother, and his fiancée’s father—an Admiral—expect of him.

Rated PG-13 | Length 131 minutes

Actors

Louis Lombardi | Liam Neeson | Peter MacNicol | Tadanobu Asano | Rami Malek | Adam Godley | Alexander Skarsgård | Michelle Arthur | Peter Berg | Stephen Bishop | David Jensen | Taylor Kitsch | Carson Aune | Gary Grubbs | Kyle Russell Clements | Bill Stinchcomb | Jesse Plemons | Jerry Ferrara | John Bell | Rihanna | Brooklyn Decker | Joe Chrest | George O'Hanlon Jr. | Hamish Linklater | Yutaka Takeuchi | John Tui | Doug Penty | James Rawlings | Josh Pence | Leni Ito | Rico McClinton | Drew Rausch | Austin Naulty | Lloyd Pitts | Kerry Cahill | Gregory D. Gadson | Jay Jackson | Rick Hoffman | Jordan Kirkwood | Joji Yoshida | Dustin J. Reno | Natalia Castellanos | Norman Vincent McLafferty | Dante Jimenez | Daven Arce | Ralph Richardson | Biunca Love | Jackie Johnson | John A Weaver | Dane Justman | Arlene Newman | Henry Duval

  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Movie Detail )  0.0224
Total Execution Time  0.0237
  GET DATA  
No GET data exists
  MEMORY USAGE  
521,760 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/4447
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0040 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('c8e0d1be7b7ef1c0b017072af391beee'300) AS ci_session_lock 
0.0002   SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'ac4b8cbbab21c1589110fabe648fecf31c8097fd'
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` = 4447
 LIMIT 1 
0.0002   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` = 4447
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0005   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` = 4447
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 4447 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 15 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)