Hans Albers Klause

Willkommen Zur Fotogallerie von Hans-Albers-Klause Kneipe
Bitte wählen sie aus ob sie die Fotos nach datum suchen möchten oder nach event! Nach der Auswahl werden sie zur Fotogallerie weitergeleitet.

Scroll Up Scroll Down

(default) 11 queries took 7 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `photos`	17	17	1
2	DESCRIBE `statuses`	10	10	1
3	DESCRIBE `albums`	7	7	1
4	DESCRIBE `users`	13	13	1
5	DESCRIBE `groups`	5	5	1
6	DESCRIBE `news`	7	7	1
7	SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` LEFT JOIN `statuses` AS `Status` ON (`Photo`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `albums` AS `Album` ON (`Photo`.`album_id` = `Album`.`id`) WHERE 1 = 1	1	1	0
8	SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`body`, `Photo`.`created`, `Photo`.`modified`, `Photo`.`status_id`, `Photo`.`published`, `Photo`.`tags`, `Photo`.`type`, `Photo`.`attachmentName`, `Photo`.`attachmentType`, `Photo`.`attachmentLocation`, `Photo`.`attachmentSize`, `Photo`.`attachmentWidth`, `Photo`.`attachmentHeight`, `Photo`.`album_id`, `Photo`.`user_id`, `Status`.`id`, `Status`.`name`, `Status`.`post_count`, `Status`.`comment_count`, `Status`.`album_count`, `Status`.`photo_count`, `Status`.`media_count`, `Status`.`link_count`, `Status`.`news_count`, `Status`.`guestbook_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`subscribed`, `User`.`comment_count`, `User`.`album_count`, `User`.`photo_count`, `User`.`post_count`, `User`.`status`, `User`.`group_id`, `Album`.`id`, `Album`.`name`, `Album`.`body`, `Album`.`created`, `Album`.`user_id`, `Album`.`status_id`, `Album`.`photo_count` FROM `photos` AS `Photo` LEFT JOIN `statuses` AS `Status` ON (`Photo`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `albums` AS `Album` ON (`Photo`.`album_id` = `Album`.`id`) WHERE 1 = 1 ORDER BY `Photo`.`id` DESC LIMIT 150	0	0	1
9	SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1	2	2	0
10	SELECT `User`.`id`, `User`.`name` FROM `users` AS `User` WHERE 1 = 1	3	3	0
11	SELECT `Album`.`id`, `Album`.`name` FROM `albums` AS `Album` WHERE 1 = 1	1	1	0

(default) 11 queries took 7 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `photos`

DESCRIBE `statuses`

DESCRIBE `albums`

DESCRIBE `users`

DESCRIBE `groups`

DESCRIBE `news`

SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` LEFT JOIN `statuses` AS `Status` ON (`Photo`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `albums` AS `Album` ON (`Photo`.`album_id` = `Album`.`id`) WHERE 1 = 1

SELECT `Photo`.`id`, `Photo`.`title`, `Photo`.`body`, `Photo`.`created`, `Photo`.`modified`, `Photo`.`status_id`, `Photo`.`published`, `Photo`.`tags`, `Photo`.`type`, `Photo`.`attachmentName`, `Photo`.`attachmentType`, `Photo`.`attachmentLocation`, `Photo`.`attachmentSize`, `Photo`.`attachmentWidth`, `Photo`.`attachmentHeight`, `Photo`.`album_id`, `Photo`.`user_id`, `Status`.`id`, `Status`.`name`, `Status`.`post_count`, `Status`.`comment_count`, `Status`.`album_count`, `Status`.`photo_count`, `Status`.`media_count`, `Status`.`link_count`, `Status`.`news_count`, `Status`.`guestbook_count`, `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`created`, `User`.`modified`, `User`.`subscribed`, `User`.`comment_count`, `User`.`album_count`, `User`.`photo_count`, `User`.`post_count`, `User`.`status`, `User`.`group_id`, `Album`.`id`, `Album`.`name`, `Album`.`body`, `Album`.`created`, `Album`.`user_id`, `Album`.`status_id`, `Album`.`photo_count` FROM `photos` AS `Photo` LEFT JOIN `statuses` AS `Status` ON (`Photo`.`status_id` = `Status`.`id`) LEFT JOIN `users` AS `User` ON (`Photo`.`user_id` = `User`.`id`) LEFT JOIN `albums` AS `Album` ON (`Photo`.`album_id` = `Album`.`id`) WHERE 1 = 1 ORDER BY `Photo`.`id` DESC LIMIT 150

SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1

SELECT `User`.`id`, `User`.`name` FROM `users` AS `User` WHERE 1 = 1

SELECT `Album`.`id`, `Album`.`name` FROM `albums` AS `Album` WHERE 1 = 1

Willkommen zur Hans Albers Klause