Movielogr

Home

Movies by Tag

zombiefreak has logged 61 movies that were tagged with “RD's Place.”

Movies tagged with “RD's Place”
TitleDirector(s)Year ReleasedViewed On
Night Evelyn Came Out of the Grave, TheEmilio Miraglia197107/18/2012
Night to Dismember, ADoris Wishman198304/25/2012
Of Unknown OriginGeorge P. Cosmatos198305/16/2012
PinocchioCorey Allen197101/18/2012
Pinocchio's RevengeKevin Tenney199606/06/2012
Runestone, TheWillard Carroll199104/04/2012
ScreamersChristian Duguay199509/05/2012
Shanty TrampJoseph G. Prieto196702/15/2012
Silent MadnessSimon Nuchtern198402/29/2012
Sometimes Aunt Martha Does Dreadful ThingsThomas Casey197106/27/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Tag )  0.0127
Total Execution Time  0.0140
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,664 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/zombiefreak/tag/207/title/asc/40
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0066 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '2dded297c9b6e233e24baadfda0849d37385960b'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('26e944de45a4204b18437de2ba37a01e', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '2dded297c9b6e233e24baadfda0849d37385960b'
AND `ip_address` = '216.73.216.6' ?>
0.0005  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'zombiefreak'
 LIMIT 1 ?>
0.0015  
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` = 40
AND `TG`.`tag_id` = 207
GROUP BY `MT`.`title_id` ?>
0.0035  
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` = 40
AND `TG`.`tag_id` = 207
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 40, 10 ?>
0.0003  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 207
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)