Movielogr

movie poster

Rating: 4 stars

Tags

Alamo Drafthouse Lamar

Seen 1 time

Seen on: 07/01/2011

View on: IMDb | TMDb

Transformers: Dark of the Moon (2011)

Directed by Michael Bay

Action

Most recently watched by sensoria, noahphex, jenerator

Overview

The Autobots continue to work for NEST, now no longer in secret. But after discovering a strange artifact during a mission in Chernobyl, it becomes apparent to Optimus Prime that the United States government has been less than forthright with them.

Rated PG-13 | Length 154 minutes

Actors

John Turturro | Hugo Weaving | David St. James | James Remar | Leonard Nimoy | Elya Baskin | Robert Foxworth | Frances McDormand | John Malkovich | Tyrese Gibson | Jennifer Williams | Shia LaBeouf | Francesco Quinn | Glenn Morshower | Mindy Sterling | George Coe | Kevin Dunn | Frank Welker | Patrick Dempsey | Josh Duhamel | Peter Cullen | Mark Ryan | Alan Tudyk | Maile Flanagan | Kathleen Gati | Julie White | John Di Maggio | Keiko Agena | Josh Kelly | Tom Virtue | Ravil Isyanov | Rich Hutchman | Lester Speight | Danny McCarthy | Ron Bottitta | Annie O'Donnell | Tom Kenny | Charlie Adler | Ken Jeong | Jess Harnell | Drew Pillsbury | Yasen Peyankov | Meredith Monroe | Keith Szarabajka | Greg Berg | Peter Murnik | Bill O'Reilly | Andrew Daly | Inna Korobkina | Buzz Aldrin | Ken Takemoto | Reno Wilson | Michael Daniel Cassady | Don Jeanes | Jack Axelrod | Alan Pietruszewski | Iqbal Theba | Lindsey Ginter | Kevin Sizemore | Brett Stimely | Anthony Azizi | John Turk | Scott Krinsky | Rosie Huntington-Whiteley | Christian Baha | Zoran Radanovich | Chris Sheffield | LaMonica Garrett | Larry Clarke | Sammy Sheik | Eugene Alper | Brian Call | Jay Gates | Derek Miller | Charlotte Labadie | Darren O'Hare | Cory Tucker | Mikal Vega | John H. Tobin | Stephen Monroe Taylor | Kenny Sheard | Patrick Pankhurst | Katherine Sigismund | Markiss McFadden | Michael Loeffelholz | Thomas Crawford | Scott C. Roe | James D. Weston II | Sean Murphy | Mark Golden | Peter A Kelly | Luis Echagarruga | Aaron Garrido | Dustin Dennard | Nick Bickle | Ajay James | Brett Lynch | Chris A. Robinson | Mitch Bromwell | Leidy Mazo | Danielle Fornarelli | Scott Paulson | John S. McAfee | Rebecca Cooper

Comments

No comments yet. Log in and be the first!

  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movie Detail )  0.0277
Total Execution Time  0.0293
  GET DATA  
No GET data exists
  MEMORY USAGE  
547,920 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/movie_detail/6631
  CLASS/METHOD  
members/movie_detail
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 17 (0.0072 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '5cdc30b9d092d19926eef39ff1c45d8c4705a7e9'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('6e626a08089f12abe0fd22c40b60fec6'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5cdc30b9d092d19926eef39ff1c45d8c4705a7e9'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 
LIMIT 1 
0.0003   SELECT `MV`.`title_id`, `MT`.`tmdb_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MVON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`movie_id` = 6631
AND `MV`.`user_id` = 61
 LIMIT 1 
0.0004   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 61
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0029   SELECT `MV`.`title_id`, `MV`.`movie_id`, COUNT(DISTINCT MV.title_id) AS mv_count, `title`, `prefix`, `year`, `imdb_link`, `MT`.`imdb_id`, `MT`.`tmdb_id`, `overview`, `certification`, `runtime`, `genre_id_01`, `genre_id_02`, `genre_id_03`, MAX(MP.filename) AS filename, `G1`.`genre_nameAS `genre_name_01`, `G2`.`genre_nameAS `genre_name_02`, `G3`.`genre_nameAS `genre_name_03`, `date_viewed`, `notes`, `MV`.`format_id`, `FMT`.`format_name`, `MV`.`source_id`, `SRC`.`source_name`, `MV`.`device_id`, `DVC`.`device_name`, `MV`.`rating_id`, `STR`.`star_rating`, `rewatch`, GROUP_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_movies` `MVON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_movie_posters` `MPON `MV`.`title_id` = `MP`.`title_id`
LEFT JOIN `ml_lookup_genres` `G1ON `MV`.`genre_id_01` = `G1`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G2ON `MV`.`genre_id_02` = `G2`.`genre_id`
LEFT JOIN `ml_lookup_genres` `G3ON `MV`.`genre_id_03` = `G3`.`genre_id`
LEFT JOIN `ml_lookup_formats` `FMTON `MV`.`format_id` = `FMT`.`format_id`
LEFT JOIN `ml_lookup_sources` `SRCON `MV`.`source_id` = `SRC`.`source_id`
LEFT JOIN `ml_lookup_devices` `DVCON `MV`.`device_id` = `DVC`.`device_id`
LEFT JOIN `ml_movie_ratings_five_star` `STRON `MV`.`rating_id` = `STR`.`rating_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 `MV`.`movie_id` = 6631
AND `MV`.`user_id` = 61
ORDER BY 
`date_viewedDESC 
0.0002   SET SESSION group_concat_max_len 1024 
0.0003   SELECT `event_title`, `JME`.`event_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movie_events` `EVON `JME`.`event_id` = `EV`.`event_id`
WHERE `JME`.`movie_id` = 6631 
0.0002   SELECT `tag`, `JMT`.`tag_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_tags` `MTON `JMT`.`tag_id` = `MT`.`tag_id`
WHERE `JMT`.`movie_id` = 6631 
0.0002   SELECT `star_rating`
FROM `ml_users`
WHERE `ml_users`.`user_id` = 61
 LIMIT 1 
0.0002   SELECT `rating_id`
FROM `ml_movies` `MV`
WHERE `MV`.`user_id` = 61
AND `MV`.`movie_id` = 6631
 LIMIT 1 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_five_star` `MR`
WHERE `MR`.`rating_id` = '18'
 
LIMIT 1 
0.0003   SELECT `MV2`.`date_viewed`, `MV2`.`movie_id`
FROM `ml_movies` `MV`
LEFT JOIN `ml_movies` `MV2ON `MV`.`title_id` = `MV2`.`title_idAND `MV`.`user_id` = `MV2`.`user_id`
WHERE `MV`.`user_id` = 61
AND `MV`.`movie_id` = 6631
GROUP BY 
`MV2`.`movie_id`
ORDER BY `MV2`.`date_viewedDESC 
0.0002   SELECT `comment_id`, `comment`, `commenter_id`, `timestamp`, `username`, `email_address`
FROM `ml_comments` `MC`
JOIN `ml_users` `MUON `MU`.`user_id` = `MC`.`commenter_id`
WHERE `movie_id` = 6631 
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` = 3209
ORDER BY 
`date_viewedDESC
 LIMIT 10 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)