Movielogr

Actors by Popularity

71,746 Actors by Popularity
No.MoviesViewsActor
1311427Ray Winstone
1321327Eddie Marsan
1331327Michael Sheen
1341327Jack McGee
1351327James Earl Jones
1361227Deep Roy
1371227David Thewlis
1381127Nicky Katt
1391027Thomas Lennon
1401027Jun Kunimura
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Overview / Popular Actors )  3.0620
Total Execution Time  3.0636
  GET DATA  
No GET data exists
  MEMORY USAGE  
516,288 bytes
  POST DATA  
No POST data exists
  URI STRING  
overview/actors/130
  CLASS/METHOD  
overview/popular_actors
  DATABASE:  movielogr_dev (Overview:$db)   QUERIES: 5 (3.0554 seconds)  (Hide)
0.0003  
SELECT 1
FROM `ml_sessions`
WHERE `id` = '278b942ed0940038c83c89f8f3c8c07cb0914916'
AND `ip_address` = '216.73.216.6' ?>
1.5360  
SELECT GET_LOCK('642c9bd477079c36f2901df530108dae', 300) AS ci_session_lock ?>
0.0004  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = '278b942ed0940038c83c89f8f3c8c07cb0914916'
AND `ip_address` = '216.73.216.6' ?>
0.5373  
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` ?>
0.9816  
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 130, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)