Fotoalbums / TKB-feest

img_1834.jpg - TKB-feest

Foto gemaakt op: 2010-05-27 09:25:00, views: 320.
(default) 35 queries took 291 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `photoalbums`10109
2DESCRIBE `photos`13139
3DESCRIBE `donitasusers`414111
4DESCRIBE `groups_users`4410
5DESCRIBE `groups`8810
6DESCRIBE `metagroups`5510
7DESCRIBE `groupfunctions`3310
8SET NAMES 'UTF8'00
9DESCRIBE `messageboards_metagroups`4410
10DESCRIBE `messageboards`4410
11DESCRIBE `notes`5510
12DESCRIBE `notes_metagroups`4410
13DESCRIBE `comments`111110
14DESCRIBE `calendars_metagroups`4410
15DESCRIBE `calendars`2210
16DESCRIBE `calendaritems`101010
17DESCRIBE `photo_votes`6610
18DESCRIBE `logs`101010
19SELECT `Photo`.`id`, `Photo`.`views`, `Photo`.`photoalbum_id`, `Photo`.`user_id`, `Photo`.`title`, `Photo`.`date`, `Photo`.`filename`, `Photo`.`exif`, `Photo`.`isvisible`, `Photo`.`modified`, `Photo`.`created`, `Photo`.`votes`, `Photo`.`rating`, `Photoalbum`.`id`, `Photoalbum`.`user_id`, `Photoalbum`.`name`, `Photoalbum`.`intro`, `Photoalbum`.`dir`, `Photoalbum`.`preview`, `Photoalbum`.`date`, `Photoalbum`.`isvisible`, `Photoalbum`.`created`, `Photoalbum`.`modified`, `Donitasuser`.`id`, `Donitasuser`.`username`, `Donitasuser`.`password`, `Donitasuser`.`displayname`, `Donitasuser`.`email`, `Donitasuser`.`website`, `Donitasuser`.`created`, `Donitasuser`.`modified`, `Donitasuser`.`address`, `Donitasuser`.`streetnumber`, `Donitasuser`.`zipcode`, `Donitasuser`.`city`, `Donitasuser`.`phonenumber`, `Donitasuser`.`mobilenumber`, `Donitasuser`.`name`, `Donitasuser`.`firstname`, `Donitasuser`.`tussenvoegsel`, `Donitasuser`.`lastname`, `Donitasuser`.`msn`, `Donitasuser`.`birthday`, `Donitasuser`.`length`, `Donitasuser`.`nevobonumber`, `Donitasuser`.`registrationtype`, `Donitasuser`.`registrationnumber`, `Donitasuser`.`position`, `Donitasuser`.`quote`, `Donitasuser`.`aboutuser`, `Donitasuser`.`userstatus`, `Donitasuser`.`receivenewsletter`, `Donitasuser`.`gg_check`, `Donitasuser`.`showsmileys`, `Donitasuser`.`showimages`, `Donitasuser`.`shirtnumber`, `Donitasuser`.`numberofpostsperpage`, `Donitasuser`.`mijndonitas`, `Donitasuser`.`old_user_id`, `Donitasuser`.`study`, `Donitasuser`.`civilstatus`, `Donitasuser`.`lastlogin`, `Donitasuser`.`logins`, `Donitasuser`.`rsskey` FROM `photos` AS `Photo` LEFT JOIN `photoalbums` AS `Photoalbum` ON (`Photo`.`photoalbum_id` = `Photoalbum`.`id`) LEFT JOIN `donitasusers` AS `Donitasuser` ON (`Photo`.`user_id` = `Donitasuser`.`id`) WHERE `Photo`.`id` = 9983 and `Photoalbum`.`isvisible` = 1 AND `Photo`.`isvisible` = 1 LIMIT 11118
20SELECT `PhotoVote`.`id`, `PhotoVote`.`photo_id`, `PhotoVote`.`donitasuser_id`, `PhotoVote`.`vote`, `PhotoVote`.`created`, `PhotoVote`.`modified` FROM `photo_votes` AS `PhotoVote` WHERE `PhotoVote`.`photo_id` = (9983) 000
21SELECT `Photo`.`id`, `Photo`.`views`, `Photo`.`photoalbum_id`, `Photo`.`user_id`, `Photo`.`title`, `Photo`.`date`, `Photo`.`filename`, `Photo`.`exif`, `Photo`.`isvisible`, `Photo`.`modified`, `Photo`.`created`, `Photo`.`votes`, `Photo`.`rating`, `Photoalbum`.`id`, `Photoalbum`.`user_id`, `Photoalbum`.`name`, `Photoalbum`.`intro`, `Photoalbum`.`dir`, `Photoalbum`.`preview`, `Photoalbum`.`date`, `Photoalbum`.`isvisible`, `Photoalbum`.`created`, `Photoalbum`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`displayname`, `User`.`email`, `User`.`website`, `User`.`created`, `User`.`modified`, `User`.`address`, `User`.`streetnumber`, `User`.`zipcode`, `User`.`city`, `User`.`phonenumber`, `User`.`mobilenumber`, `User`.`name`, `User`.`firstname`, `User`.`tussenvoegsel`, `User`.`lastname`, `User`.`msn`, `User`.`birthday`, `User`.`length`, `User`.`nevobonumber`, `User`.`registrationtype`, `User`.`registrationnumber`, `User`.`position`, `User`.`quote`, `User`.`aboutuser`, `User`.`userstatus`, `User`.`receivenewsletter`, `User`.`gg_check`, `User`.`showsmileys`, `User`.`showimages`, `User`.`shirtnumber`, `User`.`numberofpostsperpage`, `User`.`mijndonitas`, `User`.`old_user_id`, `User`.`study`, `User`.`civilstatus`, `User`.`lastlogin`, `User`.`logins`, `User`.`rsskey` FROM `photos` AS `Photo` LEFT JOIN `photoalbums` AS `Photoalbum` ON (`Photo`.`photoalbum_id` = `Photoalbum`.`id`) LEFT JOIN `donitasusers` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`photoalbum_id` = 100 AND `Photo`.`date` >= '2010-04-24 20:27:13' AND `Photo`.`id` > '9983' ORDER BY `Photo`.`date` ASC,`Photo`.`filename` ASC LIMIT 11121
22SELECT `Photo`.`id`, `Photo`.`views`, `Photo`.`photoalbum_id`, `Photo`.`user_id`, `Photo`.`title`, `Photo`.`date`, `Photo`.`filename`, `Photo`.`exif`, `Photo`.`isvisible`, `Photo`.`modified`, `Photo`.`created`, `Photo`.`votes`, `Photo`.`rating`, `Photoalbum`.`id`, `Photoalbum`.`user_id`, `Photoalbum`.`name`, `Photoalbum`.`intro`, `Photoalbum`.`dir`, `Photoalbum`.`preview`, `Photoalbum`.`date`, `Photoalbum`.`isvisible`, `Photoalbum`.`created`, `Photoalbum`.`modified`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`displayname`, `User`.`email`, `User`.`website`, `User`.`created`, `User`.`modified`, `User`.`address`, `User`.`streetnumber`, `User`.`zipcode`, `User`.`city`, `User`.`phonenumber`, `User`.`mobilenumber`, `User`.`name`, `User`.`firstname`, `User`.`tussenvoegsel`, `User`.`lastname`, `User`.`msn`, `User`.`birthday`, `User`.`length`, `User`.`nevobonumber`, `User`.`registrationtype`, `User`.`registrationnumber`, `User`.`position`, `User`.`quote`, `User`.`aboutuser`, `User`.`userstatus`, `User`.`receivenewsletter`, `User`.`gg_check`, `User`.`showsmileys`, `User`.`showimages`, `User`.`shirtnumber`, `User`.`numberofpostsperpage`, `User`.`mijndonitas`, `User`.`old_user_id`, `User`.`study`, `User`.`civilstatus`, `User`.`lastlogin`, `User`.`logins`, `User`.`rsskey` FROM `photos` AS `Photo` LEFT JOIN `photoalbums` AS `Photoalbum` ON (`Photo`.`photoalbum_id` = `Photoalbum`.`id`) LEFT JOIN `donitasusers` AS `User` ON (`Photo`.`user_id` = `User`.`id`) WHERE `Photo`.`photoalbum_id` = 100 AND `Photo`.`date` <= '2010-04-24 20:27:13' AND `Photo`.`id` < '9983' ORDER BY `Photo`.`date` DESC,`Photo`.`filename` DESC LIMIT 1111
23SELECT COUNT(*) AS `count` FROM `photos` AS `Photo` WHERE `Photo`.`id` = 9983 110
24UPDATE `photos` SET `views` = 320, `modified` = '2012-05-18 10:32:48' WHERE `photos`.`id` = 998311
25DESCRIBE `newsitems`9910
26DESCRIBE `attachments`121210
27DESCRIBE `attachments_newsitems`3310
28DESCRIBE `smileys`3310
29SELECT `Newsitem`.`id`, `Newsitem`.`title`, `Newsitem`.`message`, `Newsitem`.`preview` FROM `newsitems` AS `Newsitem` LEFT JOIN `metagroups` AS `Metagroup` ON (`Newsitem`.`metagroup_id` = `Metagroup`.`id`) WHERE isledenonly = 0 AND (metagroup_id = 31 OR metagroup_id = 3 OR metagroup_id = 45 OR metagroup_id = 35 OR metagroup_id = 34 OR metagroup_id = 33 OR metagroup_id = 32 OR metagroup_id = 36 OR metagroup_id = 42 OR metagroup_id = 40 OR metagroup_id = 39 OR metagroup_id = 43 OR metagroup_id = 15 OR metagroup_id = 14 OR metagroup_id = 50 OR metagroup_id = 51 OR metagroup_id = 41 ) AND (enddate > now() OR enddate = "0000-00-00 00:00:00" or enddate is null or enddate < date) AND date < now() ORDER BY `date` desc LIMIT 4441
30SELECT `Attachment`.`internalfilename`, `Attachment`.`showafter`, `Attachment`.`id`, `Attachment`.`size`, `Attachment`.`filename`, `Attachment`.`title`, `Attachment`.`categorie`, `Attachment`.`isloginrequired`, `Attachment`.`isdownload`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`user_id`, `AttachmentsNewsitem`.`id`, `AttachmentsNewsitem`.`attachment_id`, `AttachmentsNewsitem`.`newsitem_id` FROM `attachments` AS `Attachment` JOIN `attachments_newsitems` AS `AttachmentsNewsitem` ON (`AttachmentsNewsitem`.`newsitem_id` IN (424, 396, 392, 388) AND `AttachmentsNewsitem`.`attachment_id` = `Attachment`.`id`) 110
31DESCRIBE `matches`272710
32DESCRIBE `clubs`449
33DESCRIBE `sportshalls`9910
34DESCRIBE `nevobo_regions`4410
35SELECT `Calendaritem`.`id`, `Calendaritem`.`calendar_id`, `Calendaritem`.`startdate`, `Calendaritem`.`enddate`, `Calendaritem`.`title`, `Calendaritem`.`info`, `Calendaritem`.`location`, `Calendaritem`.`url`, `Calendaritem`.`modified`, `Calendaritem`.`created`, `Calendar`.`id`, `Calendar`.`name` FROM `calendaritems` AS `Calendaritem` LEFT JOIN `calendars` AS `Calendar` ON (`Calendaritem`.`calendar_id` = `Calendar`.`id`) WHERE calendar_id = 1 AND ((enddate > now() or enddate = "0000-00-00 00:00:00" or enddate is null or enddate < startdate) OR (enddate is null OR enddate < now())) AND startdate > now() ORDER BY `startdate` ASC 001