Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
651216Jon Lee Brody
652216Joseph Gatt
6531315Harold Miller
6541215Luis Guzmán
6551215Rance Howard
6561215Anjelica Huston
6571215Paul Frees
6581215James Cromwell
6591215Susumu Terajima
6601115Vince Vaughn
  BENCHMARKS  
Loading Time: Base Classes  0.0014
Controller Execution Time ( Overview / Popular Actors )  2.7871
Total Execution Time  2.7885
  GET DATA  
No GET data exists
  MEMORY USAGE  
515,288 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/650
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (2.7804 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a378bf86f3b66d7011c534f3dcc9fb682197c095'
AND `ip_address` = '216.73.216.159' ?>
1.1218  
SELECT GET_LOCK('67d7878622d6e0c1efba9f64b9bff15b', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a378bf86f3b66d7011c534f3dcc9fb682197c095'
AND `ip_address` = '216.73.216.159' ?>
0.5894  
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.0686  
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 650, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)