Popular Tags

Twotag Test Onetag Testmovie Threetag2

Top partners

adult dating

sex shop

Your link here?

testmovie

Runtime: 1 min

Date: 07 June 2008, 13:34

Ok, this is a test-summary. Here comes the "omschrijving" of the movie

Tags: tag tag

Link to this page: http://www.naughtyyou.com/movies/view/testmovie-4

This text will be replaced

12 queries took 3 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	0
3	DESCRIBE `aros_acos`	7	7	0
4	DESCRIBE `movies`	15	15	1
5	DESCRIBE `users`	38	38	1
6	DESCRIBE `movies_tags`	3	3	0
7	DESCRIBE `tags`	2	2	0
8	DESCRIBE `languages`	4	4	0
9	SELECT `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` = 'testmovie-4' LIMIT 1	1	1	0
10	SELECT `MoviesTag`.`id`, `MoviesTag`.`movie_id`, `MoviesTag`.`tag_id` FROM `movies_tags` AS `MoviesTag` WHERE `MoviesTag`.`movie_id` IN (27)	2	2	0
11	SELECT `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 (27) AND `MoviesTag`.`tag_id` = `Tag`.`id`)	2	2	0
12	SELECT 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 25	7	7	0

12 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `aros`

DESCRIBE `acos`

DESCRIBE `aros_acos`

DESCRIBE `movies`

DESCRIBE `users`

DESCRIBE `movies_tags`

DESCRIBE `tags`

DESCRIBE `languages`

SELECT `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` = 'testmovie-4' LIMIT 1

SELECT `MoviesTag`.`id`, `MoviesTag`.`movie_id`, `MoviesTag`.`tag_id` FROM `movies_tags` AS `MoviesTag` WHERE `MoviesTag`.`movie_id` IN (27)

SELECT `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 (27) AND `MoviesTag`.`tag_id` = `Tag`.`id`)

SELECT 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 25

Popular Tags

Friends

Top partners

testmovie