Movielogr

Home

Thomas Rosales, Jr.

sleestakk has logged 10 out of 44 movies featuring Thomas Rosales, Jr.. Back to Actors by Popularity.

Movies logged featuring Thomas Rosales, Jr.
TitleDirector(s)Year ReleasedWatchedViewed On
La BambaLuis Valdez1987NoN/A
Last Man StandingWalter Hill1996NoN/A
VampiresJohn Carpenter1998NoN/A
Man's Best FriendJohn Lafia1993NoN/A
HulkAng Lee2003Yes06/19/2003
Once Upon a Time in MexicoRobert Rodriguez2003Yes09/12/2003
Superhero MovieCraig Mazin2008Yes01/06/2009
Ocean's ElevenSteven Soderbergh2001Yes02/01/2009
L.A. ConfidentialCurtis Hanson1997Yes05/01/2009
Green Hornet, TheMichel Gondry2011Yes01/14/2011
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Members / Movies By Actor )  0.0137
Total Execution Time  0.0150
  GET DATA  
No GET data exists
  MEMORY USAGE  
527,736 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/sleestakk/actor/43010/date_viewed/asc/30
  CLASS/METHOD  
members/movies_by_actor
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 9 (0.0071 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '7a8d3668ec5d54284bdbf7299a407a0be191ade2'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT GET_LOCK('1e6b0ba9ef886fc9966de0766d6fbb35', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '7a8d3668ec5d54284bdbf7299a407a0be191ade2'
AND `ip_address` = '216.73.216.6' ?>
0.0003  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'sleestakk'
 LIMIT 1 ?>
0.0010  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 43010
GROUP BY `MT`.`title_id` ?>
0.0014  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 43010
GROUP BY `MT`.`title_id` ?>
0.0009  
SELECT DISTINCT(MT.title_id)
FROM `ml_movie_titles` `MT`
LEFT JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
WHERE `JMA`.`tmdb_actor_id` = 43010
AND `MV`.`user_id` = 9
GROUP BY `MT`.`title_id` ?>
0.0022  
SELECT `MT`.`title_id`, `title`, `prefix`, `year`, `tmdb_id`, MAX(MV.movie_id) AS movie_id, MAX(date_viewed) AS date_viewed, MAX(actor_name) AS actor_name, `ACT`.`tmdb_actor_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` AND `MV`.`user_id` = 9
JOIN `ml_junction_movies_actors` `JMA` ON `JMA`.`title_id` = `MT`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_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 `JMA`.`tmdb_actor_id` = 43010
GROUP BY `MT`.`title_id`
ORDER BY `date_viewed` ASC
 LIMIT 30, 10 ?>
0.0002  
SELECT `actor_name`
FROM `ml_actors_new`
WHERE `tmdb_actor_id` = 43010 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)