Movielogr

Fantastic Fest 2012

Ran from 20th-27th of September at Alamo South Lamar in Austin, TX

noahphex logged 46 movies during Fantastic Fest 2012. Back to Events Overview.

Movies logged during Fantastic Fest 2012
TitleDirector(s)Year ReleasedViewed On
HailAmiel Courtin-Wilson201209/20/2012
DreddPete Travis201209/20/2012
Here Comes the DevilAdrián García Bogliano201209/20/2012
Collection, TheMarcus Dunstan201209/21/2012
Conspiracy, TheChristopher MacBride201209/21/2012
SinisterScott Derrickson201209/21/2012
Errors of the Human BodyEron Sheean201209/23/2012
BestiesRebecca Perry Cutter201209/22/2012
Unit 7Alberto Rodríguez201209/22/2012
Berberian Sound StudioPeter Strickland201209/22/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0023
Controller Execution Time ( Members / Movies By Event )  0.0125
Total Execution Time  0.0149
  GET DATA  
No GET data exists
  MEMORY USAGE  
528,488 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/event/171/year/asc/30
  CLASS/METHOD  
members/movies_by_event
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0056 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '48f283878c9741188e98ed7ec9632c1aa331340d'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('996911e7fa40ce67d6b4fdde1ff0ef53', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '48f283878c9741188e98ed7ec9632c1aa331340d'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0014  
SELECT `MV`.`movie_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JME`.`movie_id`
LEFT JOIN `ml_movie_events` `EV` ON `EV`.`event_id` = `JME`.`event_id`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND `EV`.`event_id` = 171
GROUP BY `MV`.`movie_id` ?>
0.0029  
SELECT `EV`.`event_id`, `event_title`, `event_start_date`, `event_end_date`, `title`, `prefix`, `MV`.`title_id`, MAX(date_viewed) AS date_viewed, MAX(MV.movie_id) AS movie_id, `MT`.`year`, 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_events` `JME`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JME`.`movie_id`
LEFT JOIN `ml_movie_events` `EV` ON `EV`.`event_id` = `JME`.`event_id`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_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 `EV`.`event_id` = 171
GROUP BY `MV`.`title_id`
ORDER BY `year` ASC
 LIMIT 30, 10 ?>
0.0003  
SELECT `event_title`, `event_description`
FROM `ml_movie_events` `EV`
WHERE `EV`.`event_id` = 171
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)