Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1211512Patrick McDade
1212512Aubrey Plaza
1213512Alice Cooper
1214512Laura Cayouette
1215512Marek Vašut
1216512Karen Black
1217512Andy Milder
1218512Leo Lee
1219512Amy Esterle
1220512Tsuyoshi Ihara
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Popular Actors )  3.5677
Total Execution Time  3.5691
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,056 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/1210
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (3.5618 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
1.7606  
SELECT GET_LOCK('74c3dd68a3e999986c2cbcfb96119a1f', 300) AS ci_session_lock ?>
0.0005  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '393c5c406fdeddbaffd4c32ea779420c33d9f0da'
AND `ip_address` = '216.73.216.6' ?>
0.6872  
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.1130  
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 1210, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)