Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1221512Ian McDiarmid
1222512Borislav Iliev
1223512Matt Ward
1224512Eric Chase Anderson
1225512Andy Milder
1226512Elizabeth Reaser
1227512Jay Amor
1228512Leo Lee
1229512Maile Flanagan
1230512Phil Fondacaro
  BENCHMARKS  
Loading Time: Base Classes  0.0013
Controller Execution Time ( Overview / Popular Actors )  1.8392
Total Execution Time  1.8405
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,072 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/1220
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (1.8334 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
0.1027  
SELECT GET_LOCK('74c3dd68a3e999986c2cbcfb96119a1f', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
0.6363  
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.0937  
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 1220, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)