Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
6711015Robert Williams
6721015Ethan Suplee
6731015Greg Bronson
6741015Christopher Lloyd
6751015Charlton Heston
6761015Adrien Brody
6771015Jon Voight
6781015Tracey Walter
679915John Ortiz
680915Wes Craven
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Popular Actors )  1.8153
Total Execution Time  1.8170
  GET DATA  
No GET data exists
  MEMORY USAGE  
513,488 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/670
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 4 (1.8090 seconds)  (Hide)
0.0003  
SELECT GET_LOCK('8fd40c927f6437bb900aa33d40fffc5b', 300) AS ci_session_lock ?>
0.0006  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'b2fc5fe39c51dc9227983f5ea0012a4058c89a28'
AND `ip_address` = '216.73.216.82' ?>
0.6709  
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.1371  
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 670, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)