Movielogr

movie poster

View on: IMDb | TMDb

The Double (2011)

Directed by Michael Brandt

Overview

The mysterious murder of a US senator bearing the distinctive trademark of the legendary Soviet assassin ‘Cassius’, forces retired CIA operative, Paul Shepherson to team with rookie FBI agent, Ben Geary to solve the crime. Having spent his career chasing Cassius, Shepherdson is convinced his nemesis is long dead, but is pushed to take on the case by his former supervisor, Tom Highland. Geary, who wrote his Master’s thesis on Shepherdson’s pursuit of the Soviet killer, is certain that Cassius has resurfaced.

Rated PG-13 | Length 98 minutes

Actors

Richard Gere | Jimmy Ortega | Martin Sheen | Matt McColm | Topher Grace | Stephen Moyer | Stana Katic | Lawrence Gilliard Jr. | Tamer Hassan | Odette Annable | Chris Marquette | Ele Bardha | Jeffrey Pierce | Hugh Maguire | David Shackelford | Ed Kelly | Darcy Leutzinger | Yuriy Sardarov | Nicole Forester | Dan Lemieux | Nina Kircher | Sonja Crosby | Maxfield Lund | Randy Flagler | Andy Manning | Johnny Otto | Ella Maltby | Danny Maze | Jimmy Rhoades | Ivan Fedorov | Mike Kraft | Devin Scillian | Jamie Ridge

  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Overview / Movie Detail )  0.0207
Total Execution Time  0.0225
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,832 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6010
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0036 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('ef74624ec06051b8b8efa86fe40d6c4e'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
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` = 6010
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0013   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` = 6010
GROUP BY 
`title_id
0.0002   SET SESSION group_concat_max_len 1024 
0.0003   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` = 6010
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6010 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)