Popular Tags

Testmovie  Onetag  Threetag2    Twotag    Test 

Top partners

12 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 `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`.`slug` = 'video' LIMIT 1110
10SELECT `MoviesTag`.`id`, `MoviesTag`.`movie_id`, `MoviesTag`.`tag_id` FROM `movies_tags` AS `MoviesTag` WHERE `MoviesTag`.`movie_id` IN (28) 110
11SELECT `Tag`.`id`, `Tag`.`tag`, `MoviesTag`.`id`, `MoviesTag`.`movie_id`, `MoviesTag`.`tag_id` FROM `tags` AS `Tag` JOIN `movies_tags` AS `MoviesTag` ON (`MoviesTag`.`movie_id` IN (28) AND `MoviesTag`.`tag_id` = `Tag`.`id`) 110
12SELECT 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