| 0.0003 |
SELECT GET_LOCK('bf29ee222af1225206f91244c0ddf015', 300) AS ci_session_lock
|
| 0.0004 |
SELECT `data`
FROM `ml_sessions`
WHERE `id` = 'd27428f330141fffa6c97d97610f37241a4006ed'
AND `ip_address` = '216.73.216.111'
|
| 0.0214 |
SELECT `MV`.`title_id`, `date_viewed`, `title`, `prefix`, `year`, `username`
FROM `ml_movie_titles` `MT`
JOIN `ml_movies` `MV` ON `MV`.`title_id` = `MT`.`title_id`
JOIN `ml_users` `MU` ON `MU`.`user_id` = `MV`.`user_id`
ORDER BY `date_viewed` DESC
LIMIT 10
|
| 0.0490 |
SELECT `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`
GROUP BY `title_id`
ORDER BY `title_count` DESC, MAX(date_viewed) DESC
LIMIT 10
|
| 0.0022 |
SELECT DISTINCT(JME.event_id), `event_title`, `event_start_date`, `event_end_date`
FROM `ml_junction_movies_events` `JME`
JOIN `ml_movie_events` `EV` ON `EV`.`event_id` = `JME`.`event_id`
ORDER BY `event_start_date` DESC
LIMIT 10
|
| 0.0013 |
SELECT L.list_id, COUNT(DISTINCT(JTL.title_id)) AS total, title, prefix, timestamp
FROM `ml_lists` `L`
LEFT JOIN `ml_junction_titles_lists` `JTL` ON `L`.`list_id` = `JTL`.`list_id`
GROUP BY `L`.`list_id`
ORDER BY `timestamp` DESC
LIMIT 10
|
| 0.0579 |
SELECT MAX(director_name) AS director_name, `DR`.`tmdb_director_id`, COUNT(DISTINCT(MV.title_id)) AS movies_viewed, COUNT(DISTINCT(MV.movie_id)) AS total_viewed
FROM `ml_movies` `MV`
JOIN `ml_junction_movies_directors` `JMD` ON `MV`.`title_id` = `JMD`.`title_id`
JOIN `ml_directors_new` `DR` ON `JMD`.`tmdb_director_id` = `DR`.`tmdb_director_id`
GROUP BY `DR`.`tmdb_director_id`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0007 |
SELECT `actor_name`, `tmdb_actor_id`, `total_viewed`, `movies_viewed`
FROM `ml_lookup_top_actors`
ORDER BY `total_viewed` DESC, `movies_viewed` DESC
LIMIT 10
|
| 0.0184 |
SELECT COUNT(title_id) as weekly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2025-12-16'
|
| 0.0157 |
SELECT COUNT(title_id) as monthly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2025-11-23'
|
| 0.0158 |
SELECT COUNT(title_id) as yearly_viewed
FROM `ml_movies`
WHERE `date_viewed` > '2024-12-23'
|
| 0.0158 |
SELECT COUNT(title_id) as current_year_viewed
FROM `ml_movies` `MV`
WHERE YEAR(MV.date_viewed) = '2025'
|
| 0.0002 |
SELECT COUNT(title_id) as total_viewed
FROM `ml_movies`
|
| 0.0726 |
SELECT
genre,
COUNT(genre) AS genre_count,
genre_name
FROM (
SELECT genre_id_01 AS genre
FROM ml_movies
UNION ALL
SELECT genre_id_02
FROM ml_movies
UNION ALL
SELECT genre_id_03 FROM ml_movies
) AS T1
JOIN ml_lookup_genres AS LG ON T1.genre = LG.genre_id
GROUP BY genre
ORDER BY genre_count DESC, genre_name ASC
LIMIT 10
|
| 0.0266 |
SELECT `JMT`.`tag_id`, COUNT(JMT.tag_id) AS tag_count, `tag`
FROM `ml_junction_movies_tags` `JMT`
JOIN `ml_tags` `TG` ON `TG`.`tag_id` = `JMT`.`tag_id`
JOIN `ml_movies` `MV` ON `MV`.`movie_id` = `JMT`.`movie_id`
GROUP BY `JMT`.`tag_id`
ORDER BY `tag_count` DESC, `tag` ASC
LIMIT 10
|
| 0.0251 |
SELECT MAX(IF(device_name IS NULL, 'No device listed', device_name)) AS device_name, COUNT(MV.device_id) AS device_count, IF(MV.device_id IS NULL, 0, MV.device_id) AS device_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_devices` `DV` ON `MV`.`device_id` = `DV`.`device_id`
GROUP BY `device_id`
ORDER BY `device_count` DESC, `device_name` ASC
LIMIT 10
|
| 0.0375 |
SELECT MAX(IF(format_name IS NULL, 'No format listed', format_name)) AS format_name, COUNT(MV.format_id) AS format_count, IF(MV.format_id IS NULL, 0, MV.format_id) AS format_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_formats` `FM` ON `MV`.`format_id` = `FM`.`format_id`
GROUP BY `format_id`
ORDER BY `format_count` DESC, `format_name` ASC
LIMIT 10
|
| 0.0301 |
SELECT MAX(IF(source_name IS NULL, 'No source listed', source_name)) AS source_name, COUNT(MV.source_id) AS source_count, IF(MV.source_id IS NULL, 0, MV.source_id) AS source_id
FROM `ml_movies` `MV`
LEFT JOIN `ml_lookup_sources` `SC` ON `MV`.`source_id` = `SC`.`source_id`
GROUP BY `source_id`
ORDER BY `source_count` DESC, `source_name` ASC
LIMIT 10
|