The Arcive of Official vBulletin Modifications Site.

Daniel Thomas · #1 04-15-2009, 11:37 PM

I installed KX Debug and heres what I got...I hope this stuff is safe to post here. If any of yall can actually dissect what this stuff means, it would be a great help.

Code:

Template Usage:

    * (1)FORUMHOME
    * (1)ad_footer_end
    * (1)ad_footer_start
    * (1)ad_forumhome_afterforums
    * (1)ad_header_end
    * (1)ad_header_logo
    * (1)ad_navbar_below
    * (1)cyb_lastxhoursvisitors
    * (1)footer
    * (1)forumhome_event
    * (8)forumhome_forumbit_level1_nopost
    * (1)forumhome_forumbit_level1_post
    * (27)forumhome_forumbit_level2_post
    * (28)forumhome_lastpostby
    * (14)forumhome_loggedinuser
    * (1)forumhome_markread_script
    * (46)forumhome_subforumbit_post
    * (1)forumhome_subforumseparator_post
    * (1)gobutton
    * (1)header
    * (1)headinclude
    * (1)navbar
    * (9)navbar_notifications_menubit
    * (6)option
    * (1)spacer_close
    * (1)spacer_open
    * (1)vbplaza_navbar_buttons_left
    * (1)vbplaza_usercp_navbar_bottom 

Phrase Groups Available:

    * global
    * holiday

	
Included Files:

    * ./index.php
    * ./global.php
    * ./includes/init.php
    * ./includes/class_core.php
    * ./includes/config.php
    * ./includes/functions.php
    * ./includes/class_datastore.php
    * ./includes/datastore/datastore_cache.php
    * ./includes/class_hook.php
    * ./plugins/credits_plugins.php
    * ./includes/functions_credits.php
    * ./vbplaza/includes/functions.php
    * ./vbplaza/includes/plugins_global.php
    * ./includes/functions_notice.php
    * ./includes/functions_bigthree.php
    * ./includes/functions_forumlist.php
    * ./includes/functions_calendar.php
    * ./includes/functions_user.php 

Hooks Called:

    * init_startup
    * fetch_userinfo_query
    * fetch_musername
    * vbplaza_build_username_style_complete
    * vbplaza_build_usertitle_style_complete
    * fetch_userinfo
    * cache_permissions
    * style_fetch
    * cache_templates
    * global_start
    * parse_templates
    * notices_check_start
    * notifications_list
    * global_setup_complete
    * forumhome_start
    * forumhome_event
    * forumhome_loggedinuser_query
    * forumhome_loggedinuser
    * cache_ordered_forums
    * forumbit_subforumbit
    * forumbit_subforumbit2
    * forumbit_display
    * forumhome_complete

In the Messages drop down I got:
like 30 returning default icon messages
at the end "php_sapi_name(): apache2handler

Queries Executed:

Code:

SQL Query

SELECT *
FROM datastore
WHERE title IN ('credits_central','credits_forum_overrides','credits_interest')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	50	 	3	Using where

Time Before: 0.06076 seconds
Time After: 0.06087 seconds
Time Taken: 0.00012 seconds
Session Handling
SQL Query

SELECT *
FROM session
WHERE sessionhash = '1c5416e5093187ce37966a8d28de3c2f'
	AND lastactivity > 1239834778
	AND idhash = '57d8fa56204064a0f608d7c09072e6f6'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	const	PRIMARY	PRIMARY	32	const	1	 

Time Before: 0.06225 seconds
Time After: 0.06242 seconds
Time Taken: 0.00016 seconds
SQL Query

SELECT 
	userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
	language.phrasegroup_global AS phrasegroup_global,
	language.phrasegroup_holiday AS phrasegroup_holiday,
	language.options AS lang_options,
	language.languagecode AS lang_code,
	language.charset AS lang_charset,
	language.locale AS lang_locale,
	language.imagesoverride AS lang_imagesoverride,
	language.dateoverride AS lang_dateoverride,
	language.timeoverride AS lang_timeoverride,
	language.registereddateoverride AS lang_registereddateoverride,
	language.calformat1override AS lang_calformat1override,
	language.calformat2override AS lang_calformat2override,
	language.logdateoverride AS lang_logdateoverride,
	language.decimalsep AS lang_decimalsep,
	language.thousandsep AS lang_thousandsep
	
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 

WHERE user.userid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1	 
1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1	 
1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1	 
1	SIMPLE	language	system	PRIMARY	 	 	 	1	 

Time Before: 0.06465 seconds
Time After: 0.06749 seconds
Time Taken: 0.00283 seconds

Time Before: 0.06144 seconds
Time After: 0.06865 seconds
Time Taken: 0.00721 seconds
SQL Query

SELECT access.*, forum.forumid,
	FIND_IN_SET(access.forumid, forum.parentlist) AS ordercontrol
FROM forum AS forum
INNER JOIN access AS access ON (access.userid = 1 AND FIND_IN_SET(access.forumid, forum.parentlist))
ORDER BY ordercontrol DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access	ref	PRIMARY	PRIMARY	4	const	1	Using where; Using temporary; Using filesort
1	SIMPLE	forum	ALL	 	 	 	 	90	Using where

Time Before: 0.07407 seconds
Time After: 0.07418 seconds
Time Taken: 0.00011 seconds
SQL Query

SELECT calendarpermission.usergroupid, calendarpermission.calendarpermissions,calendar.calendarid,calendar.title, displayorder
FROM calendar AS calendar
LEFT JOIN calendarpermission AS calendarpermission ON
	(calendarpermission.calendarid = calendar.calendarid AND usergroupid IN (6))
ORDER BY displayorder ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	calendar	system	 	 	 	 	1	 
1	SIMPLE	calendarpermission	system	 	 	 	 	0	const row not found

Time Before: 0.07506 seconds
Time After: 0.07517 seconds
Time Taken: 0.00011 seconds
SQL Query

SELECT *
FROM style
WHERE (styleid = 25)
	OR styleid = 24
ORDER BY styleid DESC
LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	style	range	PRIMARY	PRIMARY	2	 	2	Using where

Time Before: 0.07675 seconds
Time After: 0.07701 seconds
Time Taken: 0.00027 seconds
SQL Query

SELECT title, template
FROM template
WHERE templateid IN (17991,18083,18085,18086,18087,18088,18089,18090,18091,18093,18094,18095,18096,18097,18092,18084,0,15725,15647,18490,17993,17992,17994,16453,17988,18265,15617,15618,18218,18219,18485,18488,18497,18238,18239,18240,18241,18439,18502,18501,18503,18506,1354,1355,1356,14897,14894,14895,14882,14884,16435,16352,16337,16338,16339,16340,16342,16341,16343,16344,16345,16346,16347,17923,17924,17925,17926,18527,18554,18570)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4	 	70	Using where

Time Before: 0.08075 seconds
Time After: 0.08140 seconds
Time Taken: 0.00065 seconds
SQL Query

SELECT * FROM credits_bank WHERE userid = 1 AND status = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	credits_bank	ALL	 	 	 	 	139	Using where

Time Before: 0.53086 seconds
Time After: 0.53099 seconds
Time Taken: 0.00014 seconds
SQL Query

SELECT COUNT(post.dateline) AS pcount 
FROM post AS post FORCE INDEX (dateline)
INNER JOIN thread AS thread USING (threadid)
WHERE post.dateline > 1239828223
AND thread.forumid IN (0196,3,155,197,4,208,216,1,2,28,9,168,169,170,183,211,212,214,171,172,173,198,210,215,5,6,156,157,158,159,213,12,14,130,21,153,95,32,31,94,34,111,107,207,40,113,29,30,160,194,75,176,35,190,191,199,200,201,202,203,164,177,178,195,179,180,181,182,152,166,167,175,154,205,161,162,163,165,192,186,204,209,187,188,189,193,131,132,127,129)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	post	range	dateline	dateline	4	 	77	Using where
1	SIMPLE	thread	eq_ref	PRIMARY,forumid	PRIMARY	4	pwmania_forums.post.threadid	1	Using where

Time Before: 0.53372 seconds
Time After: 0.53381 seconds
Time Taken: 0.00010 seconds
SQL Query

SELECT COUNT(dateline) AS rcount 
FROM reputation 
WHERE userid = 1 
AND dateline > 1239742528

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	reputation	ref	userid,dateline	userid	4	const	63	Using where

Time Before: 0.53459 seconds
Time After: 0.53468 seconds
Time Taken: 0.00009 seconds
SQL Query

SELECT id
FROM cyb_chatbox AS cyb_chatbox
WHERE dateline > '1239828223'

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cyb_chatbox	ALL	 	 	 	 	914	Using where

Time Before: 0.53570 seconds
Time After: 0.53579 seconds
Time Taken: 0.00009 seconds
SQL Query

SELECT noticeid
FROM noticedismissed AS noticedismissed
WHERE noticedismissed.userid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	noticedismissed	ref	userid	userid	4	const	1	Using where

Time Before: 0.54545 seconds
Time After: 0.54557 seconds
Time Taken: 0.00012 seconds
SQL Query

SELECT template
FROM template
WHERE templateid = 18478

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1	 

Time Before: 0.55187 seconds
Time After: 0.55197 seconds
Time Taken: 0.00010 seconds
End call of global.php: 0.558423995972
SQL Query

SELECT
	user.username, (user.options & 512) AS invisible, user.usergroupid,
	session.userid, session.inforum, session.lastactivity, session.badlocation,
	IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
	
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)

WHERE session.lastactivity > 1239834778
	
ORDER BY username ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ALL	 	 	 	 	100	Using where; Using temporary; Using filesort
1	SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	pwmania_forums.session.userid	1	 

Time Before: 0.56257 seconds
Time After: 0.56403 seconds
Time Taken: 0.00146 seconds
SQL Query

SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount, lastpostid, lastprefixid
	
FROM forum AS forum

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	forum	ALL	 	 	 	 	90	 

Time Before: 0.57410 seconds
Time After: 0.57452 seconds
Time Taken: 0.00042 seconds
SQL Query

SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM moderator AS moderator
INNER JOIN user AS user USING(userid)
WHERE moderator.userid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1	 
1	SIMPLE	moderator	ref	userid_forumid	userid_forumid	4	const	1	Using where

Time Before: 0.58117 seconds
Time After: 0.58150 seconds
Time Taken: 0.00033 seconds
SQL Query

SELECT user.avatarid, user.avatarrevision, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline,
	customavatar.width, customavatar.height, customavatar.width_thumb, customavatar.height_thumb
FROM user AS user
LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1	 
1	SIMPLE	avatar	const	PRIMARY	PRIMARY	2	const	0	unique row not found
1	SIMPLE	customavatar	const	PRIMARY	PRIMARY	4	const	1	 

Time Before: 0.64494 seconds
Time After: 0.64535 seconds
Time Taken: 0.00041 seconds
SQL Query

select p.threadid, t.forumid from post p left join thread t on(t.threadid = p.threadid) where p.userid = 1

Time Before: 0.64580 seconds
Time After: 0.64848 seconds
Time Taken: 0.00268 seconds
SQL Query

select count(*) as newposts from post where dateline >= 1239828223 and visible = 1

Time Before: 0.67740 seconds
Time After: 0.67750 seconds
Time Taken: 0.00010 seconds
SQL Query

select count(*) as newthreads from thread where dateline >= 1239828223 and visible = 1 and sticky in(0,1)

Time Before: 0.67769 seconds
Time After: 0.67777 seconds
Time Taken: 0.00009 seconds
SQL Query

select count(*) as lastposts from post where visible = 1 and dateline >= 1239749278

Time Before: 0.67800 seconds
Time After: 0.68085 seconds
Time Taken: 0.00285 seconds
SQL Query

SELECT userid, username, usergroupid, displaygroupid, lastactivity, IF(user.options & 512, 1, 0) AS invisible
FROM user AS user
WHERE lastactivity > 1239749278
ORDER BY username ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	lastactivity	lastactivity	4	 	422	Using where; Using filesort

Time Before: 0.68183 seconds
Time After: 0.68713 seconds
Time Taken: 0.00531 seconds
SQL Query

SELECT userip, dateline
FROM cybvilxh_guests AS cybvilxh_guests
WHERE dateline > 1239749278

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cybvilxh_guests	ALL	 	 	 	 	1337	Using where

Time Before: 0.77844 seconds
Time After: 0.78353 seconds
Time Taken: 0.00509 seconds
SQL Query

UPDATE session
SET lastactivity = 1239835678, location = '/index.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = '1c5416e5093187ce37966a8d28de3c2f'

Time Before: 0.79350 seconds
Time After: 0.79380 seconds
Time Taken: 0.00030 seconds
SQL Query

UPDATE user
SET lastactivity = 1239835678
WHERE userid = 1

Time Before: 0.79396 seconds
Time After: 0.79453 seconds
Time Taken: 0.00058 seconds
Page generated in 0.790579080582 seconds with 28 queries, spending 0.0247750282288 doing MySQL queries and 0.765804052353 doing PHP things. Shutdown Queries: DISABLED

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03378 seconds Memory Usage 2,275KB Queries Executed 12 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_onlinestatus (1)postbit_wrapper (1)showthread_list (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_threadedmode.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids_threaded showthread_threaded_construct_link showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!