Movielogr

Home

Horror Movie Project 2011

jenerator logged 25 movies during Horror Movie Project 2011. Back to Events Overview.

Movies logged during Horror Movie Project 2011
TitleDirector(s)Year ReleasedViewed On
Bud Abbott and Lou Costello Meet FrankensteinCharles Barton194810/03/2011
House of WaxAndré De Toth195310/08/2011
Pit and the Pendulum, TheRoger Corman196110/11/2011
Terror, TheRoger Corman196310/04/2011
DuelSteven Spielberg197110/04/2011
Exorcist, TheWilliam Friedkin197310/30/2011
Funhouse, TheTobe Hooper198110/30/2011
Dungeonmaster, TheSteven Ford, Charles Band, Ted Nicolaou, John Carl Buechler, Peter Manoogian, Rosemarie Turko, David Allen198410/12/2011
PhenomenaDario Argento198510/11/2011
Prince of DarknessJohn Carpenter198710/31/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies By Event )  0.0113
Total Execution Time  0.0129
  GET DATA  
No GET data exists
  MEMORY USAGE  
528,336 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/event/111/year/asc
  CLASS/METHOD  
members/movies_by_event
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0046 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9829308bbb658f8baf3ff870f63841e14b2c62ff'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('74a4120e34243a08f30d0e81b4c03005', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9829308bbb658f8baf3ff870f63841e14b2c62ff'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0010  
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` = 61
AND `EV`.`event_id` = 111
GROUP BY `MV`.`movie_id` ?>
0.0022  
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` = 61
AND `EV`.`event_id` = 111
GROUP BY `MV`.`title_id`
ORDER BY `year` ASC
 LIMIT 10 ?>
0.0003  
SELECT `event_title`, `event_description`
FROM `ml_movie_events` `EV`
WHERE `EV`.`event_id` = 111
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)