Movielogr

movie poster

View on: IMDb | TMDb

Alexander (2004)

Directed by Oliver Stone

Overview

Alexander, the King of Macedonia, leads his legions against the giant Persian Empire. After defeating the Persians, he leads his army across the then known world, venturing farther than any westerner had ever gone, all the way to India.

Rated R | Length 175 minutes

Actors

Christopher Plummer | Oliver Stone | Jonathan Rhys Meyers | Rory McCann | Dale Dye | Anthony Hopkins | Connor Paolo | Val Kilmer | Rosario Dawson | Jared Leto | Brian Blessed | Tim Pigott-Smith | Angelina Jolie | Jessie Kamm | Fiona O'Shaughnessy | Peter Williamson | John Kavanagh | Gary Stretch | Féodor Atkine | Toby Kebbell | Laird Macintosh | Francisco Bosch | Neil Jackson | Garrett Lombard | Erol Sander | Peter Rnic | Rab Affleck | Brian McGrath | Annelise Hesme | Elliot Cowan | Denis Conway | Charlie Hollway | Colin Farrell | Michael Dixon | Joseph Morgan | Mick Lally | David Leon | John Reynolds | Raz Degan | David Bedella | Stéphane Ferrara | Nick Dunning | Jaran Ngamdee | Bin Bunluerit | Michelle Lukes | Benjamín Benítez | Tadhg Murphy | Evelina Manna | Rowley Irlam | Ian Beattie | Max Bollinger | Jason Croot | Nicolas D. Blake | Charles Haigh | Desmond O'Neill | Patrick Carroll | Morgan Christopher Ferris | Marie Meyer | Robert Earley | Aleczander Gordon | Benny Maslov | Monica Zamora | Monica Perego | Tania Matos | Gillian Grueber | Anjali Mehra | Suzanne Bullock | Marta Barahona | Greg Orvis | Abbie Hirst | Fahar Faizaan | John Whitby | Lee Anthony Parnell | Anthony James Berowne | Sam Green | Chris Aberdein | Jean Le Duc | Mohammed Tsouli | Harry Kent | Kate Eloise Whitfield | Anthony Jean Marie Kurt | Leighton Morrison | Isaac Mullins | Matthew Powell

  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Movie Detail )  0.0210
Total Execution Time  0.0224
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,608 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/movie_detail/6014
  CLASS/METHOD  
overview/movie_detail
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 10 (0.0044 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('434c6d043783bc2d90d6a6386c81ab1b'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3d4e563d90569ee6fa16df299d705a698b97914f'
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` = 6014
 LIMIT 1 
0.0002   SET SESSION group_concat_max_len 12288 
0.0021   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` = 6014
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` = 6014
ORDER BY 
`date_viewedDESC
 LIMIT 10 
0.0002   SELECT AVG(NULLIF(rating_id2)) AS `avg_rating`
FROM `ml_movies`
WHERE `title_id` = 6014 
0.0002   SELECT `star_rating`
FROM `ml_movie_ratings_ten_star`
WHERE `rating_id` = 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)