Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1511126Kevin Dunn
1521126Reggie Lee
1531026James Phelps
1541026Matthew Lewis
1551026Oliver Phelps
1561026Bonnie Wright
1571026Josh Herdman
1581026Devon Murray
159926Michael Bowen
160926Corey Johnson
  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Overview / Popular Actors )  4.9834
Total Execution Time  4.9855
  GET DATA  
No GET data exists
  MEMORY USAGE  
516,248 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/150
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (4.9764 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'f74e1a84cc7f2b8ff1393e400a5f729d01b4bbc8'
AND `ip_address` = '216.73.216.6' ?>
3.3037  
SELECT GET_LOCK('096706896ee9cf22829e54f0d16fe2ac', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'f74e1a84cc7f2b8ff1393e400a5f729d01b4bbc8'
AND `ip_address` = '216.73.216.6' ?>
0.6042  
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.0678  
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 150, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)