Movielogr

Home

movie poster

View on: IMDb | TMDb

Syriana (2005)

Directed by Stephen Gaghan

Overview

The Middle Eastern oil industry is the backdrop of this tense drama, which weaves together numerous story lines. Bennett Holiday is an American lawyer in charge of facilitating a dubious merger of oil companies, while Bryan Woodman, a Switzerland-based energy analyst, experiences both personal tragedy and opportunity during a visit with Arabian royalty. Meanwhile, veteran CIA agent Bob Barnes uncovers an assassination plot with unsettling origins.

Rated R | Length 128 minutes

Actors

William Hurt | Christopher Plummer | George Clooney | Tim Blake Nelson | Matt Damon | Peter Gerety | Bahar Soomekh | Jeffrey Wright | Chris Cooper | Amanda Peet | Alexander Siddig | Kayvan Novak | Amr Waked | Robert Foxworth | Nicky Henson | Nicholas Art | Steven Hinkle | Daisy Tormé | Richard Lintern | Jocelyn Quivrin | Mazhar Munir | Shahid Ahmed | Bikram Singh Bhamra | Roger Yuan | Jamey Sheridan | Max Minghella | Nadim Sawalha | Akbar Kurtha | Sonnell Dadral | Mark Strong | Badria Timimi | David Clennon | Viola Davis | Donna Mitchell | Randall Boffman | Susan Duvall | Ozzie Yue | Anna George | Mike Monroe | Susan Halsey Singer | Lauren Minite | Susan Allenback | Elena Rosa | Katherine Hoskins Mackey | Linda E. Williams | Wendy Kush

  BENCHMARKS  
Loading Time: Base Classes  0.0025
Controller Execution Time ( Overview / Movie Detail )  0.0212
Total Execution Time  0.0237
  GET DATA  
No GET data exists
  MEMORY USAGE  
518,952 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6108
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0041 seconds)  (Hide)
0.0004   SELECT 1
FROM `ml_sessions`
WHERE `id` = '3881a0483f2d8ebe22f2d0e2e6d8ea264b1aae3c'
AND `ip_address` = '216.73.216.111' 
0.0003   SELECT GET_LOCK('ef74624ec06051b8b8efa86fe40d6c4e', 300) AS ci_session_lock 
0.0004   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` = 6108
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len = 12288 
0.0015   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` = 6108
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` `MV` ON `MV`.`user_id` = `MU`.`user_id`
JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
WHERE `MT`.`title_id` = 6108
ORDER BY `date_viewed` DESC
 LIMIT 10 
0.0003   SELECT AVG(NULLIF(rating_id, 2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6108 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 0 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)