Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
211424Tom Hiddleston
2121723Vincent Price
2131723Owen Wilson
2141623Lin Shaye
2151623Bill Moseley
2161523Bill Murray
2171423Sam Rockwell
2181323Christopher Plummer
2191323Kevin Corrigan
2201223Ian McKellen
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Popular Actors )  1.7355
Total Execution Time  1.7368
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,360 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/210
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (1.7297 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
0.0203  
SELECT GET_LOCK('74c3dd68a3e999986c2cbcfb96119a1f', 300) AS ci_session_lock ?>
0.0003  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
0.6323  
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.0765  
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 210, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)