Fora
TitelSub-itemsBeoordeling
Gastenboek5
In het gastenboek kunnen bezoekers van de website een bericht achterlaten.
1 forum
------------------------------ Output for debugging: ------------------------------ GET : moduleID -> 3
0.07585 sec - 1) returnFirst: SELECT * FROM splace WHERE splaceID = 12
0.07639 sec - 2) returnFirst: SELECT * FROM ban WHERE splaceID = 12 AND ip LIKE '38.107.191.81'
0.08776 sec - currentuserID: 0 0.0879 sec - 3) doSQL: INSERT into pageview(splaceID, moduleID, ID, userID, groupID, visitorID, phpsessID, ip, datetime) VALUES (12, 3, 0, 0, 0, 0, '6d1f017694c693fc278d5165aaaf87ca', '38.107.191.81', NOW())
0.08843 sec - userID:
groupID:
moduleID: 3
parentID:
mapID:
MenuID:
ID:
reactieID:
subID:
0.08848 sec - 4) returnFirst: SELECT * FROM subsplace WHERE userID = 0 AND groupID = 0
0.08893 sec - 5) 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.09004 sec - 6) getQuery: SELECT * FROM module WHERE splaceID = 12
0.09153 sec - 7) getQuery: SELECT * from module WHERE splaceID = 12 AND showNormal > 0 order by volgorde
0.09258 sec - 8) returnFirst: SELECT * from module LEFT JOIN moduletype ON (module.moduletypeID = moduletype.moduletypeID) WHERE module.splaceID = 12 AND module.moduleID = 3
0.09357 sec - 9) returnFirst: SELECT * FROM module WHERE moduleID = 3
0.09403 sec - 10) getQuery: SELECT * from childtype WHERE moduletypeID = 5 AND contenttypeID = 0 order by volgorde
0.09452 sec - 11) returnFirst: SELECT * FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 3 AND contenttype.contenttypeID = 12
0.09566 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 = 3 AND content.contenttypeID = 12 AND content.userID=0 AND content.groupID=0 ORDER BY volgorde
0.10105 sec - Contenttype ID: 12 => type: menufolder
0.10121 sec - 13) returnFirst: SELEcT * FROM content WHERE contentID = 19509
0.10202 sec - 14) returnFirst: SELEcT * FROM content WHERE contentID = 1252
0.10271 sec - 15) returnFirst: SELEcT * FROM content WHERE contentID = 1254
0.10331 sec - 16) returnFirst: SELEcT * FROM content WHERE contentID = 13924
0.10393 sec - 17) returnFirst: SELEcT * FROM content WHERE contentID = 16608
0.10467 sec - 18) returnFirst: SELEcT * FROM content WHERE contentID = 1257
0.10525 sec - 19) returnFirst: SELEcT * FROM content WHERE contentID = 1255
0.10585 sec - 20) returnFirst: SELEcT * FROM content WHERE contentID = 1256
0.14776 sec - 21) returnFirst: SELEcT * FROM content WHERE contentID = 20705
0.14864 sec - 22) returnFirst: SELEcT * FROM content WHERE contentID = 1258
0.14929 sec - 23) returnFirst: SELEcT * FROM content WHERE contentID = 1253
0.15009 sec - 24) returnFirst: SELECT *, contenttype.contenttypeID as contenttypeID FROM contenttype, modulecontenttype WHERE contenttype.contenttypeID = modulecontenttype.contenttypeID AND modulecontenttype.moduleID = 3 AND contenttype.contenttypeID = 12
0.15092 sec - 25) 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 = 3 AND content.contenttypeID = 12 AND content.userID=0 AND content.groupID=0 ORDER BY volgorde
0.15651 sec - 26) getNumRows: SELECT * FROM childtype, module WHERE childtype.moduletypeID = module.moduletypeID AND module.moduleID = 3
0.15734 sec - 27) getQuery: SELECT * FROM block, module WHERE block.moduleID = module.moduleID AND block.splaceID = 12 AND block.target LIKE '%;3;%' AND block.position like '1%' order by block.volgorde
0.15783 sec - 28) returnFirst: SELECT * FROM banner WHERE bannerID = 1 AND splaceID = 12 AND fileID > 0 AND date_start <= '2010-09-05 17:10:02' AND date_end >= '2010-09-05 17:10:02'