Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
2011024Ed Helms
2021024Pete Postlethwaite
2031024Rutger Hauer
204924Tony Curran
205924Kenny Baker
206924Scarlett Johansson
207924Shun Sugata
208824David Leitch
209724James Parks
210724Rade Serbedzija
  BENCHMARKS  
Loading Time: Base Classes  0.0017
Controller Execution Time ( Overview / Popular Actors )  2.1162
Total Execution Time  2.1179
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,176 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/200
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (2.1104 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'feade8d6324ddec759069ed06820c08c866e8778'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('db971805e77b864362ec04d5fea04ee3', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'feade8d6324ddec759069ed06820c08c866e8778'
AND `ip_address` = '216.73.216.6' ?>
0.7639  
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.3457  
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 200, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)