Movielogr

Home

Movies by Tag

jenerator has logged 42 movies that were tagged with “Alamo Drafthouse Ritz.”

Movies tagged with “Alamo Drafthouse Ritz”
TitleDirector(s)Year ReleasedViewed On
City of the Living DeadLucio Fulci198001/05/2010
Monster Squad, TheFred Dekker198701/09/2010
Raw ForceEdward D. Murphy198201/12/2010
Dark AngelCraig R. Baxley199001/19/2010
TransformersMichael Bay200702/06/2010
Singin' in the RainStanley Donen, Gene Kelly195203/06/2010
Hot Tub Time MachineSteve Pink201004/02/2010
Mad Max 2George Miller198104/04/2010
Fear No EvilFrank LaLoggia198105/25/2010
Race with the DevilJack Starrett197506/08/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Tag )  0.0125
Total Execution Time  0.0139
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,040 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/tag/489/date_viewed/asc
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0056 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '21ce3054080f7b11a865175b3156b3f682bfe137'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('370eaf780fb8eeba1c8d9f6b1ae78973', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '21ce3054080f7b11a865175b3156b3f682bfe137'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0011  
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` = 61
AND `TG`.`tag_id` = 489
GROUP BY `MT`.`title_id` ?>
0.0032  
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` = 61
AND `TG`.`tag_id` = 489
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 10 ?>
0.0003  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 489
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)