Movielogr

Home

jenerator’s Most Popular Movies

Most Popular Movies
No.ViewsMovie Title
2711Go West
2721Love Happy
2731Hesher
2741Sukiyaki Western Django
2751Room Service
2761Formosa Betrayed
2771A Day at the Races
2781Fast Times at Ridgemont High
279120,000 Leagues Under the Sea
28013-D Sex and Zen: Extreme Ecstasy
  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Members / Popular Movies )  0.0267
Total Execution Time  0.0282
  GET DATA  
No GET data exists
  MEMORY USAGE  
519,512 bytes
  POST DATA  
No POST data exists
  URI STRING  
members/jenerator/movies/270
  CLASS/METHOD  
members/popular_movies
  DATABASE:  movielogr_dev (Members:$db)   QUERIES: 7 (0.0171 seconds)  (Hide)
0.0004  
SELECT 1
FROM `ml_sessions`
WHERE `id` = 'a4d55b0f0a1579ad29c51947446bc979397e67b2'
AND `ip_address` = '216.73.216.6' ?>
0.0002  
SELECT GET_LOCK('6962ea024cb42c18d4291998ae46384e', 300) AS ci_session_lock ?>
0.0002  
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'a4d55b0f0a1579ad29c51947446bc979397e67b2'
AND `ip_address` = '216.73.216.6' ?>
0.0005  
SELECT `username`, `user_id`
FROM `ml_users`
WHERE `username` = 'jenerator'
 LIMIT 1 ?>
0.0065  
SELECT `MV`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 61
GROUP BY `title_id` ?>
0.0034  
SELECT `MV`.`title_id`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 61
GROUP BY `title_id` ?>
0.0059  
SELECT MAX(MV.movie_id) AS movie_id, `MV`.`title_id`, COUNT(MV.title_id) AS title_count, `title`, `prefix`, `year`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
WHERE `MV`.`user_id` = 61
GROUP BY `title_id`
ORDER BY `title_count` DESC, MAX(date_viewed) DESC
 LIMIT 270, 10 ?>
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)