Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
112147Brian Cox
121944Michael Caine
131344Cillian Murphy
141244Robert Downey Jr.
152843Frank Welker
163042Dick Miller
172042Robbie Coltrane
181942Bill Nighy
191742Natalie Portman
201342Jeremy Renner
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Popular Actors )  1.9937
Total Execution Time  1.9954
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,904 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/10
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (1.9831 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '615a88b422f0917989008833354a4d50139947e9'
AND `ip_address` = '216.73.216.6' ?>
0.0004  
SELECT GET_LOCK('365e7338d80655d50ed103c360c8628e', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '615a88b422f0917989008833354a4d50139947e9'
AND `ip_address` = '216.73.216.6' ?>
0.7285  
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.2537  
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 10, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)