Movielogr

Home

Movies by Source

sleestakk has logged 537 movies at the Theater. Back to Sources by Popularity.

Movies logged at the Theater
TitleDirector(s)Year ReleasedViewed On
Yor, the Hunter from the FutureAntonio Margheriti198307/28/2012
Yellow SubmarineGeorge Dunning196805/10/2012
xXxRob Cohen200208/18/2002
XtroHarry Bromley Davenport198210/25/2012
X2Bryan Singer200305/10/2003
X-Men: The Last StandBrett Ratner200605/27/2006
X-Men Origins: WolverineGavin Hood200905/01/2009
X-MenBryan Singer200007/14/2000
X Files: I Want to Believe, TheChris Carter200807/26/2008
Wrestler, TheDarren Aronofsky200801/25/2009
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Source )  0.0355
Total Execution Time  0.0370
  GET DATA  
No GET data exists
  MEMORY USAGE  
524,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/source/1/title/desc/10
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0276 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('d0cb27f4c8c2918a8439adc9c5610f0a', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'b528d9b9aa7982c038be13ff5374916ba0260a4b'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0100  
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND `MV`.`source_id` = 1
GROUP BY `MT`.`title_id` ?>
0.0164  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_id, 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
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`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`
WHERE `MV`.`user_id` = 9
AND `MV`.`source_id` = 1
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 10, 10 ?>
0.0002  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 1
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)