Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1911324Cate Blanchett
1921224Michael Clarke Duncan
1931224Peter Jason
1941224Woody Harrelson
1951224Mickey Rourke
1961124John Cho
1971024Pete Postlethwaite
1981024Jeff Bridges
1991024Rutger Hauer
2001024Viola Davis
  BENCHMARKS  
Loading Time: Base Classes  0.0018
Controller Execution Time ( Overview / Popular Actors )  4.7115
Total Execution Time  4.7133
  GET DATA  
No GET data exists
  MEMORY USAGE  
516,296 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/190
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (4.7043 seconds)  (Hide)
0.0002  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '6a9d787d727e401830937f3a7a4723a99adfff9a'
AND `ip_address` = '216.73.216.6' ?>
2.3953  
SELECT GET_LOCK('d38a559074958de38d6983d3dbc5d3da', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '6a9d787d727e401830937f3a7a4723a99adfff9a'
AND `ip_address` = '216.73.216.6' ?>
0.8801  
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.4282  
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 190, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)