Movielogr

Home

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
2081310Brian J. White
2082310Tim Plester
2083310Jemaine Clement
2084310Dale Dye
2085310Brian Gleeson
2086310R.A. Rondell
2087310Sam Spruell
2088310Martin Wuttke
2089310David Bamber
2090310Rafe Spall
  BENCHMARKS  
Loading Time: Base Classes  0.0016
Controller Execution Time ( Overview / Popular Actors )  1.7531
Total Execution Time  1.7547
  GET DATA  
No GET data exists
  MEMORY USAGE  
513,224 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/2080
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 4 (1.7472 seconds)  (Hide)
0.0003  
SELECT GET_LOCK('3b6e357544c6d9490d0c68baf4a60138', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a1747d6517ca7e03051e9469910b26040234a78f'
AND `ip_address` = '216.73.217.47' ?>
0.6429  
SELECT COUNT(DISTINCT JMA.tmdb_actor_id) AS total
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `MV`.`title_id` = `JMA`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id` ?>
1.1037  
SELECT MAX(actor_name) AS actor_name, `ACT`.`tmdb_actor_id`, COUNT(DISTINCT MV.movie_id) AS total_viewed, COUNT(DISTINCT MV.title_id) AS movies_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_actors` `JMA` ON `MV`.`title_id` = `JMA`.`title_id`
JOIN `ml_actors_new` `ACT` ON `JMA`.`tmdb_actor_id` = `ACT`.`tmdb_actor_id`
GROUP BY `ACT`.`tmdb_actor_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
 LIMIT 2080, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)