Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1301212Lex Shrapnel
1302212Nicholas Hoult
1303212Kenneth Choi
1304212Paul Birchard
1305212Marco Sanchez
1306212Jay Scully
1307212James Eckhouse
1308212Dennis Dun
1309212Hans Matheson
1310212J. J. Feild
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Popular Actors )  1.8495
Total Execution Time  1.8509
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,032 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/1300
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (1.8434 seconds)  (Hide)
0.0005  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f9d696ae1f5d82bf7981957bed9047ade5dc598c'
AND `ip_address` = '216.73.216.6' ?>
0.1718  
SELECT GET_LOCK('d801fab215b7be16cb0d6e26abcfd935', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f9d696ae1f5d82bf7981957bed9047ade5dc598c'
AND `ip_address` = '216.73.216.6' ?>
0.5952  
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.0756  
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 1300, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)