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
Snow White and the HuntsmanRupert Sanders201206/03/2012
Sound of My VoiceZal Batmanglij201105/15/2012
Sound of NoiseJohannes Stjärne Nilsson, Ola Simonsson201006/08/2012
South Park: Bigger, Longer & UncutTrey Parker199907/01/1999
SpadesJohn Wesley Norton201201/14/2012
Speed RacerLilly Wachowski, Lana Wachowski200805/10/2008
Spider BabyJack Hill196710/20/2012
Spider-ManSam Raimi200205/05/2002
Spider-Man 2Sam Raimi200406/29/2004
Spider-Man 3Sam Raimi200705/04/2007
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Source )  0.0310
Total Execution Time  0.0326
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,672 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/source/1/title/asc/410
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0235 seconds)  (Hide)
0.0007  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '7a03f3239218bf7b8a625f66acc5152d749f7c85'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('5c6106f4825ec9f4799a7d3c1597c1ac', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '7a03f3239218bf7b8a625f66acc5152d749f7c85'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0064  
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.0153  
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` ASC
 LIMIT 410, 10 ?>
0.0003  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 1
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)