Movielogr

Home

Movies by Tag

sleestakk has logged 32 movies that were tagged with “31 in 31 challenge.”

Movies tagged with “31 in 31 challenge”
TitleDirector(s)Year ReleasedViewed On
Alone in the DarkJack Sholder198210/08/2012
Bad Seed, TheMervyn LeRoy195610/16/2012
Beyond, TheLucio Fulci198110/14/2012
Bled WhiteJose Carlos Gomez201210/14/2012
CrittersStephen Herek198610/04/2012
Die, Monster, Die!Daniel Haller196510/07/2012
Dr. Terror's House of HorrorsFreddie Francis196510/13/2012
Eddie: The Sleepwalking CannibalBoris Rodriguez201210/14/2012
FoundScott Schirmer201210/19/2012
FrankenweenieTim Burton201210/11/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Tag )  0.0133
Total Execution Time  0.0147
  GET DATA  
No GET data exists
  MEMORY USAGE  
525,376 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/tag/1178
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0048 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0005  
SELECT GET_LOCK('8b16ad9a0fbba2b3d1663ce3c6f3d35d', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'eb3f700b0237f2fab08a6da54bbcf20ac8659ec5'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0012  
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` = 9
AND `TG`.`tag_id` = 1178
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` = 9
AND `TG`.`tag_id` = 1178
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10 ?>
0.0002  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 1178
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)