Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1381811Greg Collins
1382811Terence Stamp
1383811Kirk Douglas
1384811Peter Lorre
1385811Rip Torn
1386811Christopher George
1387811Jon Polito
1388811Brandon Molale
1389811Tim Thomerson
1390811Pat Roach
  BENCHMARKS  
Loading Time: Base Classes  0.0019
Controller Execution Time ( Overview / Popular Actors )  2.3923
Total Execution Time  2.3943
  GET DATA  
No GET data exists
  MEMORY USAGE  
513,232 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/1380
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 4 (2.3857 seconds)  (Hide)
0.0002  
SELECT GET_LOCK('626db1e63aec5d1d34742d7e79112770', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '0dc958209be184e8c208e41789584c8ad1c96a60'
AND `ip_address` = '216.73.216.6' ?>
0.7718  
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.6133  
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 1380, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)