Movielogr

Home

Movies by Tag

sleestakk has logged 94 movies that were tagged with “RonP.”

Movies tagged with “RonP”
TitleDirector(s)Year ReleasedViewed On
Quentin Tarantino, Robert Rodriguez, Edgar Wright, Eli Roth, Rob Zombie04/07/2007
28 Weeks LaterJuan Carlos Fresnadillo200705/12/2007
36th Chamber of Shaolin, TheLiu Chia-Liang197801/08/2011
All the Boys Love Mandy LaneJonathan Levine200601/08/2011
AuditionTakashi Miike199908/28/2004
Bad SantaTerry Zwigoff200306/26/2004
Beast from 20,000 Fathoms, TheEugène Lourié195307/12/2012
Black AngelRoy William Neill194608/18/2012
Cabin FeverEli Roth200305/01/2004
CandymanBernard Rose199207/13/2012
  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Members / Movies By Tag )  0.0202
Total Execution Time  0.0222
  GET DATA  
No GET data exists
  MEMORY USAGE  
526,576 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/tag/576/title/asc
  CLASS/METHOD  
members/movies_by_tag
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0062 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '3ec833680e2a0b228b76143bb126e9dfb9448c0c'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('b60ec77e67e9b99dbd1fb9341d21ccb0', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '3ec833680e2a0b228b76143bb126e9dfb9448c0c'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0017  
SELECT `MT`.`title_id`
FROM `ml_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_id`
WHERE `MV`.`user_id` = 9
AND `TG`.`tag_id` = 576
GROUP BY `MT`.`title_id` ?>
0.0030  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `imdb_link`, MAX(date_viewed) AS date_viewed, MAX(MV.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_junction_movies_tags` `JMT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
LEFT JOIN `ml_movie_titles` `MT` ON `MT`.`title_id` = `MV`.`title_id`
LEFT JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_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` = 9
AND `TG`.`tag_id` = 576
GROUP BY `MT`.`title_id`
ORDER BY `title` ASC
 LIMIT 10 ?>
0.0003  
SELECT `tag`
FROM `ml_tags`
WHERE `tag_id` = 576
 LIMIT 1 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)