Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
7173111Ann Longo
7173211Parrie Hodges
7173311Ray Uhler
7173411Ya'lita Thompson
7173511Lindsay Lefler
7173611Danny Gellis
7173711Ray Martucci
7173811Rene Botana
7173911Jane Chastain
7174011Joel Fredrick
  BENCHMARKS  
Loading Time: Base Classes  0.0012
Controller Execution Time ( Overview / Popular Actors )  1.9944
Total Execution Time  1.9957
  GET DATA  
No GET data exists
  MEMORY USAGE  
514,400 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/71730
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (1.9844 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.0252  
SELECT GET_LOCK('dfb7927c135074f825c7936b5ddbb206', 300) AS ci_session_lock ?>
0.0008  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'c93a64dc1c13a252718433c0c86521096a15224b'
AND `ip_address` = '216.73.216.6' ?>
0.7324  
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.2257  
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 71730, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)