Movielogr

Home

Movies by Tag

sleestakk has logged 57 movies that were tagged with “movie night.”

Movies tagged with “movie night”
TitleDirector(s)Year ReleasedViewed On
All the Boys Love Mandy LaneJonathan Levine200601/08/2011
Mad Max 2George Miller198102/25/2012
Raiders of AtlantisRuggero Deodato198302/25/2012
Death Wish 3Michael Winner198502/25/2012
ThingsAndrew Jordan198905/05/2012
Brain DamageFrank Henenlotter198805/05/2012
Undisputed II: Last Man StandingIsaac Florentine200605/05/2012
Power, TheByron Haskin196807/07/2012
No Blade of GrassCornel Wilde197007/07/2012
Eye of the DevilJ. Lee Thompson196607/07/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0022
Controller Execution Time ( Members / Movies By Tag )  0.0132
Total Execution Time  0.0154
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,240 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/tag/138/date_viewed/asc/40
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0038 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'eb97c00b116b07aa4afdd8d32e9d74749bf2e6c2'
AND `ip_address` = '216.73.216.226' ?>
0.0002  
SELECT GET_LOCK('459b1ded37d1d546211a17047eee5a21', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'eb97c00b116b07aa4afdd8d32e9d74749bf2e6c2'
AND `ip_address` = '216.73.216.226' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0009  
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` = 138
GROUP BY `MT`.`title_id` ?>
0.0018  
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` = 138
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 40, 10 ?>
0.0002  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 138
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)