Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1571411Stephanie Faracy
1572411Dendrie Taylor
1573411Wentworth Miller
1574411Brad Garrett
1575411Jernard Burks
1576411Adam Wingard
1577411Tommy Nix
1578411Jeff Imada
1579411Sean Reid
1580411Jade Ramsey
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Popular Actors )  1.7860
Total Execution Time  1.7875
  GET DATA  
No GET data exists
  MEMORY USAGE  
513,240 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/1570
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 4 (1.7795 seconds)  (Hide)
0.0003  
SELECT GET_LOCK('b05ca07bc5a2f2191823eb2405cdd219', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '73074ae958daf8bc628c8cf8d2cf3f46a02c27eb'
AND `ip_address` = '216.73.216.82' ?>
0.6297  
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.1492  
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 1570, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)