Movielogr

Events Overview

sensoria has watched movies at 22 events.

All events for sensoria
StartEndEvent
02/25/201202/26/2012February 2012 Movie Night
12/10/201112/11/2011Christmas Movie Night 2011
10/29/201110/30/2011Halloween Movie Night 2011
10/15/201110/16/2011Music Box Massacre
09/03/201109/04/2011September Movie Night 2011
08/06/201108/07/2011Terror in the Aisles 8
07/23/201107/23/2011POTADay
04/23/201104/24/2011Impromptu April Movie Night 2011
03/19/201103/20/2011Sci-Fi Spectacular 5
02/19/201102/20/2011February Movie Night 2011
  BENCHMARKS  
Loading Time: Base Classes  0.0027
Controller Execution Time ( Members / Movies All Events )  0.0253
Total Execution Time  0.0281
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,384 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sensoria/events/10
  CLASS/METHOD  
members/movies_all_events
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0141 seconds)  (Hide)
0.0002  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '3ef41461b3715945f3c79bf49194dccecd017446'
AND `ip_address` = '216.73.216.226' ?>
0.0001  
SELECT GET_LOCK('9c4db45ad09d15f1f4a1e6765ccdf239', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3ef41461b3715945f3c79bf49194dccecd017446'
AND `ip_address` = '216.73.216.226' ?>
0.0002  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sensoria'
 LIMIT 1 ?>
0.0044  
SELECT DISTINCT(EV.event_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`
WHERE `MV`.`user_id` = 1 ?>
0.0041  
SELECT DISTINCT(EV.event_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`
WHERE `MV`.`user_id` = 1 ?>
0.0048  
SELECT DISTINCT(EV.event_id), `event_title`, `event_start_date`, `event_end_date`
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`
WHERE `MV`.`user_id` = 1
ORDER BY `event_start_date` DESC
 LIMIT 10, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)