Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
7172111Frank Heins
7172211Harvey Hogan
7172311Ted McElwee
7172411Walter Helbig
7172511Victor Dickerson
7172611David M. Sheppard
7172711Paul Barman
7172811Karen Spitzer
7172911McKinley Page
7173011Francisco Fabian
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Popular Actors )  2.6138
Total Execution Time  2.6151
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,472 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/71720
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (2.6077 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('dfb7927c135074f825c7936b5ddbb206', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.9521  
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.6547  
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 71720, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)