Movielogr

Home

Movies seen in February, 2011

noahphex has logged 55 movies in February, 2011. Back to Movies seen in 2011

Movies logged in February, 2011
TitleDirector(s)Year ReleasedViewed On
Dream HomePang Ho-cheung201002/21/2011
Duke of Earl198102/26/2011
Electra Glide in BlueJames William Guercio197302/10/2011
FRED: The MovieClay Weiner201002/26/2011
Furry VengeanceRoger Kumble201002/26/2011
GlitterVondie Curtis-Hall200102/26/2011
Happy CampersDaniel Waters200102/18/2011
House by the Cemetery, TheLucio Fulci198102/15/2011
House II: The Second StoryEthan Wiley198702/19/2011
HuskBrett Simmons201102/08/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Members / Movies Seen By Month )  0.0216
Total Execution Time  0.0232
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,688 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/stats/2011/02/title/asc/20
  CLASS/METHOD  
members/movies_seen_by_month
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0150 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '9c0391d0fda1698c853208b7796a570497db7ebd'
AND `ip_address` = '216.73.216.6' ?>
0.0007  
SELECT GET_LOCK('674c75439c2290c07f2bd07be4791f91', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '9c0391d0fda1698c853208b7796a570497db7ebd'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0059  
SELECT `MV`.`movie_id`
FROM `ml_movies` `MV`
JOIN `ml_movie_titles` `MT` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND YEAR(MV.date_viewed) = 2011
AND MONTH(MV.date_viewed) = 2
GROUP BY `MV`.`movie_id` ?>
0.0073  
SELECT `MV`.`movie_id`, `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, `date_viewed`, `date_created`, 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_movies` `MV`
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 YEAR(MV.date_viewed) = 2011
AND MONTH(MV.date_viewed) = 2
GROUP BY `MV`.`movie_id`
ORDER BY `title` ASC, `date_created` ASC
 LIMIT 20, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)