Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
2811121Noel Gugliemi
2821021David Jensen
2831021John Landis
2841021Richard Jenkins
2851021T.J. Miller
2861021Danny Huston
2871021Jon Gries
2881021Steve Carell
2891021Liam Cunningham
2901021Adrian Rawlins
  BENCHMARKS  
Loading Time: Base Classes  0.0020
Controller Execution Time ( Overview / Popular Actors )  2.1057
Total Execution Time  2.1078
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,320 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/280
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (2.0983 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '2b083705bdb396a37a376322ac9a863caf32fc44'
AND `ip_address` = '216.73.216.209' ?>
0.0002  
SELECT GET_LOCK('8a029129b6d9e0393422a4f9695e2626', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '2b083705bdb396a37a376322ac9a863caf32fc44'
AND `ip_address` = '216.73.216.209' ?>
0.7285  
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.3691  
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 280, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)