Movielogr

Home

Movies by Tag

noahphex has logged 127 movies that were tagged with “Alamo South.”

Movies tagged with “Alamo South”
TitleDirector(s)Year ReleasedViewed On
Good, the Bad, the Weird, TheKim Jee-woon200804/30/2010
FatsoArild Fröhlich200809/29/2010
Enter the VoidGaspar Noé200909/23/2010
Bad Lieutenant: Port of Call - New OrleansWerner Herzog200901/06/2010
Fantastic Mr. FoxWes Anderson200902/09/2010
MicmacsJean-Pierre Jeunet200907/05/2010
Runaways, TheFloria Sigismondi201004/03/2010
Red HillPatrick Hughes201009/30/2010
Mother's DayDarren Lynn Bousman201009/23/2010
CaranchoPablo Trapero201010/02/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Members / Movies By Tag )  0.0137
Total Execution Time  0.0154
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,048 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/tag/371/year/asc/10
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0068 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '919b80c4ede2df076f5dc3f17e67c3282cf4646e'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('b32bea26dfb9270677b81b64e0de0aa6', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '919b80c4ede2df076f5dc3f17e67c3282cf4646e'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 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` = 8
AND `TG`.`tag_id` = 371
GROUP BY `MT`.`title_id` ?>
0.0042  
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` = 371
GROUP BY `MT`.`title_id`
ORDER BY `year` ASC
 LIMIT 10, 10 ?>
0.0002  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 371
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)