Movielogr

Movies seen that were released in the 1930s

sleestakk has logged 18 movies that were released in the 1930s.

Movies released in the 1930s by year
YearNumber of movies logged
19314
19322
19334
19342
19353
19361
19382
  BENCHMARKS  
Loading Time: Base Classes  0.0032
Controller Execution Time ( Members / Movies Seen By Decade Years )  0.0325
Total Execution Time  0.0357
  GET DATA  
No GET data exists
  MEMORY USAGE  
505,792 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/decade/1930
  CLASS/METHOD  
members/movies_seen_by_decade_years
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0212 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '5924d94783e475cb8887dd1dc751806b9e12acf2'
AND `ip_address` = '216.73.217.135' ?>
0.0002  
SELECT GET_LOCK('7ca3113a551375eb9c1034baa0047335', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '5924d94783e475cb8887dd1dc751806b9e12acf2'
AND `ip_address` = '216.73.217.135' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0103  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND SUBSTR(MT.year,1,3) = 193
GROUP BY `MT`.`title_id` ?>
0.0100  
SELECT `year`, COUNT(DISTINCT(MT.title_id)) AS total
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 9
AND SUBSTR(MT.year,1,3) = 193
GROUP BY `year`
ORDER BY `year` ASC ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)