------------------------------
Output for debugging:
------------------------------
0,07923 sec - 1) returnFirst: SELECT * FROM splace WHERE splaceID = 12
0,07944 sec - 2) returnFirst: SELECT * FROM ban WHERE splaceID = 12 AND ip LIKE '38.103.63.17'
0,09297 sec - currentuserID: 0
0,09317 sec - 3) doSQL: INSERT into pageview(splaceID, moduleID, ID, userID, groupID, visitorID, phpsessID, ip, datetime) VALUES (12, 0, 0, 0, 0, 0, 'e8e400e539c29bb8da33e685e55c9d2a', '38.103.63.17', NOW())
0,09357 sec - userID:
groupID:
moduleID:
parentID:
mapID:
MenuID:
ID:
reactieID:
subID:
0,09363 sec - 4) returnFirst: SELECT * FROM subsplace WHERE userID = 0 AND groupID = 0
0,09386 sec - 5) getQuery: SELECT * from module WHERE splaceID = 12 AND showNormal > 0 order by volgorde
0,09444 sec - 6) getQuery: SELECT modulecontenttype.* FROM modulecontenttype LEFT JOIN module ON(module.moduleID = modulecontenttype.moduleID) WHERE module.splaceID = 12 OR modulecontenttype.moduleID = 0 GROUP BY modulecontenttype.contenttypeID, modulecontenttype.moduleID
0,09569 sec - 7) getQuery: SELECT * FROM module WHERE splaceID = 12
0,09624 sec - 8) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 12 AND module.moduleID = 1
0,09647 sec - 9) returnFirst: SELECT * FROM module WHERE moduleID = 1
0,09664 sec - 10) getQuery: SELECT * from childtype WHERE moduletypeID = 4 AND contenttypeID = 0 order by volgorde
0,09676 sec - 11) returnFirst: SELECT * FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 1 AND contenttype.contenttypeID = 9
0,09708 sec - 12) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, user.score as userscore from content LEFT JOIN user ON (content.creatorID = user.userID) WHERE content.parentID = 0 AND content.moduleID = 1 AND content.contenttypeID = 9 AND content.userID=0 AND content.groupID=0 ORDER BY volgorde
0,09852 sec - 13) returnFirst: SELEcT * FROM content WHERE contentID = 5
0,09927 sec - 14) returnFirst: SELEcT * FROM content WHERE contentID = 37331
0,09986 sec - 15) returnFirst: SELEcT * FROM content WHERE contentID = 13
0,10041 sec - 16) returnFirst: SELEcT * FROM content WHERE contentID = 37995
0,10096 sec - 17) returnFirst: SELEcT * FROM content WHERE contentID = 34
0,10156 sec - 18) returnFirst: SELEcT * FROM content WHERE contentID = 35
0,10213 sec - 19) returnFirst: SELEcT * FROM content WHERE contentID = 37333
0,10285 sec - 20) getQuery: SELECT * from childtype WHERE moduletypeID = 4 AND contenttypeID = 9 order by volgorde
0,10298 sec - 21) returnFirst: SELECT * FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 1 AND contenttype.contenttypeID = 8
0,10374 sec - 22) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, user.score as userscore, xc_page.*, content.contentID as contentID from content LEFT JOIN user ON (content.creatorID = user.userID) LEFT JOIN xc_page ON (xc_page.contentID = content.contentID) WHERE content.parentID = 5 AND content.contenttypeID = 8 ORDER BY volgorde
0,10742 sec - 23) returnQuery: SELECT extendTable AS result FROM contenttype WHERE contenttypeID = 8
0,36998 sec - 24) doSQL: UPDATE content SET views = views + 1 WHERE contentID = 6
0,37435 sec - 25) getNumRows: SELECT * FROM childtype, module WHERE childtype.moduletypeID = module.moduletypeID AND module.moduleID = 1
0,37479 sec - 26) getQuery: SELECT * FROM block, module WHERE block.moduleID = module.moduleID AND block.splaceID = 12 AND block.target LIKE '%;1;%' AND block.position like '1%' order by block.volgorde
0,37503 sec - 27) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 12 AND module.moduleID = 2
0,37551 sec - 28) returnFirst: SELECT * FROM module WHERE moduleID = 2
0,37578 sec - 29) returnQuery: SELECT childtype.type as result FROM module, childtype WHERE module.moduleID = 2 AND module.moduletypeID = childtype.moduletypeID AND childtype.contenttypeID = 0
0,37593 sec - 30) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, user.score as userscore, parent.contentID as parentID, parent.titel as parenttitel from content LEFT JOIN content as parent ON (content.parentID = parent.contentID) LEFT JOIN user ON (content.creatorID = user.userID) WHERE content.moduleID = 2 AND content.parentID >= 0 AND content.userID=0 AND content.groupID=0 AND content.contenttypeID <> 4 AND content.contenttypeID > 0 ORDER BY createdate DESC LIMIT 0, 5
0,38537 sec - 31) returnFirst: SELEcT * FROM content WHERE contentID = 36
0,38636 sec - 32) returnFirst: SELEcT * FROM content WHERE contentID = 31748
0,38772 sec - 33) returnFirst: SELECT *, contenttype.contenttypeID as contenttypeID FROM contenttype LEFT JOIN modulecontenttype ON (contenttype.contenttypeID = modulecontenttype.contenttypeID AND (modulecontenttype.moduleID = 2 OR modulecontenttype.moduleID = 0)) WHERE contenttype.contenttypeID = 1
0,38898 sec - 34) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 12 AND module.moduleID = 3
0,39035 sec - 35) returnFirst: SELECT * FROM module WHERE moduleID = 3
0,39082 sec - 36) returnQuery: SELECT moduletypeID as result FROM module WHERE moduleID = 3
0,39097 sec - 37) returnQuery: SELECT MAX(childtypeID) as result FROM childtype WHERE moduletypeID = 11
0,39359 sec - 38) returnFirst: SELECT *, contenttype.contenttypeID as contenttypeID FROM contenttype LEFT JOIN modulecontenttype ON (contenttype.contenttypeID = modulecontenttype.contenttypeID AND (modulecontenttype.moduleID = 3 OR modulecontenttype.moduleID = 0)) WHERE contenttype.contenttypeID = 22
0,39386 sec - 39) getQuery: SELECT content.*, user.username, user.avatar, user.profileID as profileID, xc_activity.*, content.contentID as contentID from content LEFT JOIN user ON (content.creatorID = user.userID) LEFT JOIN xc_activity ON (xc_activity.contentID = content.contentID) WHERE content.moduleID = 3 AND content.contenttypeID = 22 AND content.userID=0 AND content.groupID=0 AND xc_startdatum >= '2008-07-05 00:00:00' order by xc_startdatum LIMIT 0, 5
0,40766 sec - 40) returnFirst: SELEcT * FROM content WHERE contentID = 27612
0,40935 sec - 41) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 12 AND module.moduleID = 4
0,4099 sec - 42) returnFirst: SELECT * FROM module WHERE moduleID = 4
0,41008 sec - 43) getQuery: SELECT file.*, content.* from attachment LEFT JOIN file ON (attachment.fileID = file.fileID) LEFT JOIN content ON (attachment.contentID = content.contentID) WHERE content.moduleID = 4 AND attachment.type = 4 order by RAND() LIMIT 0,100
0,65458 sec - 44) returnFirst: SELEcT * FROM content WHERE contentID = 1550
0,65566 sec - 45) returnFirst: SELEcT * FROM content WHERE contentID = 35212
0,65643 sec - 46) getQuery: SELECT * FROM banner WHERE splaceID = 12 AND fileID > 0 AND date_start <= '2008-07-05 20:28:48' AND date_end >= '2008-07-05 20:28:48' order by RAND()
0,65689 sec - 47) returnFirst: SELECT * FROM file WHERE fileID = 10669
0,65724 sec - 48) doSQL: UPDATE banner SET views = views + 1 WHERE bannerID = 6