Sponsoren

Menzis

Goede zorg voor iedereen, dat is het uitgangspunt van Menzis. Wij willen goede zorg voor iedereen bereikbaar en betaalbaar houden. Juist daarom werkt Menzis samen met onder andere zorgaanbieders en patiëntenverenigingen. En Menzis is een onderlinge waarborgmaatschappij: onze ledenraad heeft het voor het zeggen.

www.menzis.nl

(default) 66 queries took 251 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `contentgroups`449
2DESCRIBE `contentgroups_htmlpages`4410
3DESCRIBE `htmlpages`7710
4SET NAMES 'UTF8'00
5DESCRIBE `donitasusers`414111
6DESCRIBE `groups_users`4410
7DESCRIBE `groups`8810
8DESCRIBE `metagroups`5510
9DESCRIBE `groupfunctions`3310
10DESCRIBE `messageboards_metagroups`4410
11DESCRIBE `messageboards`4410
12DESCRIBE `notes`5510
13DESCRIBE `notes_metagroups`4410
14DESCRIBE `comments`111110
15DESCRIBE `calendars_metagroups`4410
16DESCRIBE `calendars`2210
17DESCRIBE `calendaritems`101010
18SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 LIMIT 1110
19SELECT `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` WHERE `ContentgroupsHtmlpage`.`contentgroup_id` = (9) ORDER BY `ContentgroupsHtmlpage`.`ordering` ASC 17170
20SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 108 110
21SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 112 110
22SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 101 110
23SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 104 110
24SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 105 110
25SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 85 110
26SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 44 110
27SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 54 110
28SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 45 110
29SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 113 110
30SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 107 110
31SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 102 110
32SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 86 110
33SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 103 110
34SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 41 110
35SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 42 110
36SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id` FROM `htmlpages` AS `Htmlpage` WHERE `Htmlpage`.`id` = 110 110
37SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
38SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
39SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
40SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
41SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
42SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
43SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
44SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
45SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
46SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
47SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
48SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
49SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
50SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
51SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
52SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
53SELECT `Contentgroup`.`id`, `Contentgroup`.`name`, `Contentgroup`.`modified`, `Contentgroup`.`created` FROM `contentgroups` AS `Contentgroup` WHERE `Contentgroup`.`id` = 9 110
54SELECT `Htmlpage`.`id`, `Htmlpage`.`textid`, `Htmlpage`.`title`, `Htmlpage`.`content`, `Htmlpage`.`loginrequired`, `Htmlpage`.`request`, `Htmlpage`.`group_id`, `ContentgroupsHtmlpage`.`id`, `ContentgroupsHtmlpage`.`htmlpage_id`, `ContentgroupsHtmlpage`.`contentgroup_id`, `ContentgroupsHtmlpage`.`ordering` FROM `htmlpages` AS `Htmlpage` JOIN `contentgroups_htmlpages` AS `ContentgroupsHtmlpage` ON (`ContentgroupsHtmlpage`.`contentgroup_id` = 9 AND `ContentgroupsHtmlpage`.`htmlpage_id` = `Htmlpage`.`id`) 17170
55DESCRIBE `newsitems`9910
56DESCRIBE `attachments`121210
57DESCRIBE `attachments_newsitems`3310
58DESCRIBE `smileys`3310
59DESCRIBE `logs`101010
60SELECT `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
61SELECT `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
62DESCRIBE `matches`272710
63DESCRIBE `clubs`449
64DESCRIBE `sportshalls`9910
65DESCRIBE `nevobo_regions`4410
66SELECT `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