Popular Tags

Onetag  Test  Threetag2  Twotag      Testmovie 

Top partners

13 queries took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `aros`771
2DESCRIBE `acos`771
3DESCRIBE `aros_acos`771
4DESCRIBE `movies`15151
5DESCRIBE `users`38381
6DESCRIBE `movies_tags`330
7DESCRIBE `tags`220
8DESCRIBE `languages`440
9SELECT `Tag`.`id`, `Tag`.`tag` FROM `tags` AS `Tag` WHERE `Tag`.`tag` = 'Test' LIMIT 1110
10SELECT `Movie`.`id`, `Movie`.`filename`, `Movie`.`screenshot`, `Movie`.`language_id`, `Movie`.`user_id`, `Movie`.`slug`, `Movie`.`title`, `Movie`.`summary`, `Movie`.`tags`, `Movie`.`runtime`, `Movie`.`created`, `Movie`.`modified`, `Movie`.`removed`, `Movie`.`encoded`, `Movie`.`random_filename`, `MoviesTag`.`id`, `MoviesTag`.`movie_id`, `MoviesTag`.`tag_id` FROM `movies` AS `Movie` JOIN `movies_tags` AS `MoviesTag` ON (`MoviesTag`.`tag_id` IN (10) AND `MoviesTag`.`movie_id` = `Movie`.`id`) WHERE `Movie`.`removed` <> 1 21210
11SELECT COUNT(*) AS `count` FROM `movies` AS `Movie` LEFT JOIN `users` AS `User` ON (`Movie`.`user_id` = `User`.`id`) WHERE `Movie`.`removed` <> 1 AND `Movie`.`encoded` <> 0 AND `Movie`.`tags` LIKE '%Test%' 110
12SELECT `Movie`.`id`, `Movie`.`filename`, `Movie`.`screenshot`, `Movie`.`language_id`, `Movie`.`user_id`, `Movie`.`slug`, `Movie`.`title`, `Movie`.`summary`, `Movie`.`tags`, `Movie`.`runtime`, `Movie`.`created`, `Movie`.`modified`, `Movie`.`removed`, `Movie`.`encoded`, `Movie`.`random_filename`, `User`.`id`, `User`.`match_id`, `User`.`group`, `User`.`birthday`, `User`.`status`, `User`.`authority`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`dad`, `User`.`mom`, `User`.`kids`, `User`.`country`, `User`.`state`, `User`.`city`, `User`.`city_description`, `User`.`family_description`, `User`.`picture`, `User`.`pets`, `User`.`religion`, `User`.`drivinglicense`, `User`.`education`, `User`.`months_desired`, `User`.`preferred_start`, `User`.`special_needs`, `User`.`weekly_household_hours`, `User`.`references`, `User`.`dearfamily`, `User`.`dearaupair`, `User`.`last_login`, `User`.`last_activity`, `User`.`htmlEmail`, `User`.`created`, `User`.`modified`, `User`.`first_name`, `User`.`last_name`, `User`.`country_id`, `User`.`rights` FROM `movies` AS `Movie` LEFT JOIN `users` AS `User` ON (`Movie`.`user_id` = `User`.`id`) WHERE `Movie`.`removed` <> 1 AND `Movie`.`encoded` <> 0 AND `Movie`.`tags` LIKE '%Test%' LIMIT 8880
13SELECT tag,count(movies_tags.tag_id) as quantity FROM movies_tags LEFT JOIN tags ON tags.id = movies_tags.tag_id GROUP BY tag_id ORDER BY quantity DESC LIMIT 25770