Movielogr

Home

Movies by Source

sensoria has logged 34 movies that were Owned. Back to Sources by Popularity.

Movies logged that were Owned
TitleDirector(s)Year ReleasedViewed On
Let the Right One InTomas Alfredson200802/21/2009
Matrix, TheLilly Wachowski, Lana Wachowski199908/15/2012
Mega Shark vs. Giant OctopusJack Perez200905/30/2009
No Blade of GrassCornel Wilde197007/08/2012
Ong Bak 3Tony Jaa, Panna Rittikrai201006/12/2012
Power, TheByron Haskin196807/07/2012
RoninJohn Frankenheimer199812/08/2013
Shining, TheStanley Kubrick198009/07/2012
SplinterToby Wilkins200805/07/2013
Star TrekJ.J. Abrams200903/27/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Members / Movies By Source )  0.0534
Total Execution Time  0.0554
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,488 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/source/4/title/asc/20
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0436 seconds)  (Hide)
0.0285  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '359481d662904730536c346f76267da94198e5ed'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('2d459ce8edb4e281ebc378347f95701a', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '359481d662904730536c346f76267da94198e5ed'
AND `ip_address` = '216.73.216.6' ?>
0.0034  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0060  
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` = 1
AND `MV`.`source_id` = 4
GROUP BY `MT`.`title_id` ?>
0.0049  
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` = 1
AND `MV`.`source_id` = 4
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 20, 10 ?>
0.0002  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 4
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)