Movielogr

Home

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
Cockneys vs ZombiesMatthias Hoene201209/27/2012
Universal Soldier: Day of ReckoningJohn Hyams201209/22/2012
Room 237Rodney Ascher201209/23/2012
Tower BlockRonnie Thompson, James Nunn201209/23/2012
History of Future Folk, TheJeremy Kipp Walker, John Mitchell201209/27/2012
Doomsday BookKim Jee-woon, Yim Pil-sung201209/20/2012
HailAmiel Courtin-Wilson201209/20/2012
DreddPete Travis201209/20/2012
Here Comes the DevilAdrián García Bogliano201209/20/2012
Collection, TheMarcus Dunstan201209/21/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0028
Controller Execution Time ( Members / Movies By Event )  0.0227
Total Execution Time  0.0256
  GET DATA  
No GET data exists
  MEMORY USAGE  
528,752 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/event/171/year/desc/20
  CLASS/METHOD  
members/movies_by_event
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0035 seconds)  (Hide)
0.0002  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a2976800c90e76b701fefe3ea45760e13c742cbb'
AND `ip_address` = '216.73.216.48' ?>
0.0001  
SELECT GET_LOCK('bd3389c561111046919ac1b47dba0d11', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a2976800c90e76b701fefe3ea45760e13c742cbb'
AND `ip_address` = '216.73.216.48' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0007  
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.0019  
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` DESC
 LIMIT 20, 10 ?>
0.0002  
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)