Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
2021410Mark Hicks
2022410Federico Luppi
2023410Max Minghella
2024410Bradley Whitford
2025410Robert Tapert
2026410Alison Pill
2027410Akio Ôtsuka
2028410Peter Lewis
2029410Vera Miles
2030410David Ryall
  BENCHMARKS  
Loading Time: Base Classes  0.0103
Controller Execution Time ( Overview / Popular Actors )  2.1870
Total Execution Time  2.1986
  GET DATA  
No GET data exists
  MEMORY USAGE  
731,624 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/2020
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 4 (2.1574 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('3247191ce2f1bf7a1beb9bd5ed9bdcf6', 300) AS ci_session_lock ?>
0.0006  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '762157601b6054ef80a3228a89c5bed1d13ece11'
AND `ip_address` = '216.73.217.47' ?>
0.9983  
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.1583  
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 2020, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)