Movielogr

HorrorHound Weekend: Indianapolis 2012

HorrorHound Magazine presents a series of Midwest Horror Conventions based out of Indianapolis, Indiana, Columbus, Ohio and Cincinnati, Ohio! Fans will be able to meet some of the biggest icons in horror history (photo ops and autograph sessions) while shopping around for some of the newest or rarest classic horror toys, t-shirts, posters, displays, dvds, masks and other assorted goodies. Movie premieres and screenings will be included with every show, as well as special celebrity panels, and so much more. You can also stop by and say hi to the HorrorHound staff, all while picking up the latest issue. HorrorHound Weekend Indianapolis takes place at the Marriott East in conjunction with the hugely popular MaskFest, the largest display of mask makers and special effects exhibits in the Midwest. More surprises are in store - to help make this the biggest and most exciting horror event the mid-west can remember.

sleestakk logged 5 movies during HorrorHound Weekend: Indianapolis 2012. Back to Events Overview.

Movies logged during HorrorHound Weekend: Indianapolis 2012
TitleDirector(s)Year ReleasedViewed On
Awakened, TheLou Simon, Douglas Villalba201209/08/2012
Caesar and Otto's Deadly XmasDave Campfield201209/07/2012
Dear God No!James Bickert201109/07/2012
It's in the BloodScooter Downey201209/08/2012
Wicked, ThePeter Winther201309/09/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Movies By Event )  0.0115
Total Execution Time  0.0130
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,152 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/event/168
  CLASS/METHOD  
members/movies_by_event
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0036 seconds)  (Hide)
0.0004   SELECT 1
FROM 
`ml_sessions`
WHERE `id` = '3f556e6bbb871941838b55e40fee7a91fee27bdb'
AND `ip_address` = '216.73.216.111' 
0.0002   SELECT GET_LOCK('d9470d70367291fc60a2c570ae363535'300) AS ci_session_lock 
0.0003   SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3f556e6bbb871941838b55e40fee7a91fee27bdb'
AND `ip_address` = '216.73.216.111' 
0.0004   SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 
LIMIT 1 
0.0008   SELECT `MV`.`movie_id`
FROM `ml_junction_movies_events` `JME`
LEFT JOIN `ml_movies` `MVON `MV`.`movie_id` = `JME`.`movie_id`
LEFT JOIN `ml_movie_events` `EVON `EV`.`event_id` = `JME`.`event_id`
JOIN `ml_movie_titles` `MTON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND `EV`.`event_id` = 168
GROUP BY 
`MV`.`movie_id
0.0012   SELECT `EV`.`event_id`, `event_title`, `event_start_date`, `event_end_date`, `title`, `prefix`, `MV`.`title_id`, MAX(date_viewed) AS date_viewedMAX(MV.movie_id) AS movie_id, `MT`.`year`, GROUP_CONCAT(DISTINCT(DR.director_name) ORDER BY DR.tmdb_director_id ASC SEPARATOR "|") AS directorsGROUP_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` `MVON `MV`.`movie_id` = `JME`.`movie_id`
LEFT JOIN `ml_movie_events` `EVON `EV`.`event_id` = `JME`.`event_id`
JOIN `ml_movie_titles` `MTON `MV`.`title_id` = `MT`.`title_id`
LEFT JOIN `ml_junction_movies_directors` `JMDON `MT`.`title_id` = `JMD`.`title_id`
LEFT JOIN `ml_directors_new` `DRON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
WHERE `MV`.`user_id` = 9
AND `EV`.`event_id` = 168
GROUP BY 
`MV`.`title_id`
ORDER BY `titleASC
 LIMIT 10 
0.0003   SELECT `event_title`, `event_description`
FROM `ml_movie_events` `EV`
WHERE `EV`.`event_id` = 168
 LIMIT 1 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)