Movielogr

Movies by Tag

noahphex has logged 37 movies that were tagged with “alamo south lamar.”

Movies tagged with “alamo south lamar”
TitleDirector(s)Year ReleasedViewed On
No Rest for the WickedEnrique Urbizu201109/25/2012
Come Out and PlayMakinov201209/25/2012
Miami ConnectionY.K. Kim, Woo-sang Park198709/25/2012
AntiviralBrandon Cronenberg201209/24/2012
Holy MotorsLeos Carax201209/24/2012
Black OutArne Toonen201209/24/2012
TapedDiederik Van Rooijen201209/24/2012
Room 237Rodney Ascher201209/23/2012
Two RabbitsAfonso Poyart201209/23/2012
American Scream, TheMichael Stephenson201209/23/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Tag )  0.0123
Total Execution Time  0.0136
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,024 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/tag/800/date_viewed/desc/10
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0045 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '49e4d08b9ff57a230990eba378e15b2152ad1d60'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('77bfe712d2e7e312632e4bffe27a9311', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '49e4d08b9ff57a230990eba378e15b2152ad1d60'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0010  
SELECT `MT`.`title_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_id`
WHERE `MV`.`user_id` = 8
AND `TG`.`tag_id` = 800
GROUP BY `MT`.`title_id` ?>
0.0020  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, MAX(date_viewed) AS date_viewed, MAX(MV.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_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_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` = 8
AND `TG`.`tag_id` = 800
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` DESC
 LIMIT 10, 10 ?>
0.0003  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 800
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)