Movielogr

Home

Movies by Source

noahphex has logged 457 movies with No source listed. Back to Sources by Popularity.

Movies logged with No source listed
TitleDirector(s)Year ReleasedViewed On
Never Sleep Again: The Elm Street LegacyDaniel Farrands, Andrew Kasch201005/16/2010
Ip Man 2Wilson Yip201007/24/2010
Fast & FuriousJustin Lin200904/24/2011
NeighborRobert A. Masciantonio200908/07/2010
Lake MungoJoel Anderson200901/15/2010
Best Worst MovieMichael Stephenson200901/17/2010
Hangover, TheTodd Phillips200902/06/2010
Storm Warriors, TheDanny Pang, Oxide Pang Chun200903/27/2011
Box, TheRichard Kelly200901/23/2010
Basement JackMichael Shelton200901/23/2010
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Source )  0.0272
Total Execution Time  0.0286
  GET DATA  
No GET data exists
  MEMORY USAGE  
535,776 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/200/year/desc/170
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 6 (0.0196 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f9c60b5dd7c81b7cc6c064f3e2f72fd631c727af'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('ff3ccf072c5a74ba1ccf654ae5e349cd', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f9c60b5dd7c81b7cc6c064f3e2f72fd631c727af'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0069  
SELECT `MT`.`title_id`
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 8
AND `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id` ?>
0.0117  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, MAX(date_viewed) AS date_viewed, `imdb_link`, MAX(movie_id) AS movie_id, 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_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` 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 `MV`.`source_id` IS NULL
GROUP BY `MT`.`title_id`
ORDER BY `year` DESC
 LIMIT 170, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)