Movielogr

Home

Movies by Source

noahphex has logged 332 movies at the Theater. Back to Sources by Popularity.

Movies logged at the Theater
TitleDirector(s)Year ReleasedViewed On
Errors of the Human BodyEron Sheean201209/23/2012
Enter the VoidGaspar Noé200909/23/2010
El InfiernoLuis Estrada201009/24/2011
El Bulli: Cooking in ProgressGereon Wetzel201103/12/2011
EdenMegan Griffiths201203/11/2012
Ecstasy of Order: The Tetris MastersAdam Cornelius201205/07/2012
DuelSteven Spielberg197110/04/2011
Due DateTodd Phillips201012/01/2010
DriveNicolas Winding Refn201109/17/2011
DreddPete Travis201209/20/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Members / Movies By Source )  0.0281
Total Execution Time  0.0296
  GET DATA  
No GET data exists
  MEMORY USAGE  
534,608 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/noahphex/source/1/title/desc/220
  CLASS/METHOD  
members/movies_by_source
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0221 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '4810dfa3c8619189f3aa559057a1f9387efe4deb'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('9996b6d188d513786d8e666a7466250b', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '4810dfa3c8619189f3aa559057a1f9387efe4deb'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'noahphex'
 LIMIT 1 ?>
0.0074  
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` = 1
GROUP BY `MT`.`title_id` ?>
0.0131  
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` = 1
GROUP BY `MT`.`title_id`
ORDER BY `title` DESC
 LIMIT 220, 10 ?>
0.0005  
SELECT `source_name`
FROM `ml_lookup_sources`
WHERE `source_id` = 1
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)