Including Functions.php

Time Before: 0.01366 seconds
Time After: 0.03623 seconds
Time Taken: 0.02256 seconds

Memory Before: 1,482.305 KB
Memory After: 2,662.063 KB
Memory Used: 1,179.758 KB

Connect to Database on Server: localhost

Time Before: 0.03636 seconds
Time After: 0.03661 seconds
Time Taken: 0.00025 seconds

Memory Before: 2,662.793 KB
Memory After: 2,664.520 KB
Memory Used: 1.727 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.03687 seconds
Time After: 0.03697 seconds
Time Taken: 0.00010 seconds

Memory Before: 2,663.449 KB
Memory After: 2,664.145 KB
Memory Used: 0.695 KB

Datastore Setup
SQL Query
SELECT *
FROM Club_datastore
WHERE title IN ('iconcache','noavatarperms','smiliecache','bbcodecache','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_datastorerangePRIMARYPRIMARY50 17Using where

Time Before: 0.03799 seconds
Time After: 0.08813 seconds
Time Taken: 0.05014 seconds

Memory Before: 2,666.191 KB
Memory After: 2,666.578 KB
Memory Used: 0.387 KB

Time Before: 0.03705 seconds
Time After: 0.09593 seconds
Time Taken: 0.05889 seconds

Memory Before: 2,662.957 KB
Memory After: 4,105.348 KB
Memory Used: 1,442.391 KB

Session Handling
SQL Query
SELECT *
FROM Club_session
WHERE sessionhash = '29041270d2e48d07cd04f31e16e7d637'
	AND lastactivity > 1284054572
	AND idhash = 'd0b63444099757fedc3d79aa837e804c'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_sessionconstPRIMARY,guest_lookupPRIMARY32const1 

Time Before: 0.09819 seconds
Time After: 0.09929 seconds
Time Taken: 0.00110 seconds

Memory Before: 4,139.230 KB
Memory After: 4,139.719 KB
Memory Used: 0.488 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_user AS phrasegroup_user,
			phrasegroup_infractionlevel AS phrasegroup_infractionlevel,
			options AS lang_options,
			languagecode AS lang_code,
			charset AS lang_charset,
			locale AS lang_locale,
			imagesoverride AS lang_imagesoverride,
			dateoverride AS lang_dateoverride,
			timeoverride AS lang_timeoverride,
			registereddateoverride AS lang_registereddateoverride,
			calformat1override AS lang_calformat1override,
			calformat2override AS lang_calformat2override,
			logdateoverride AS lang_logdateoverride,
			decimalsep AS lang_decimalsep,
			thousandsep AS lang_thousandsep
FROM Club_language
WHERE languageid = 3
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_languageconstPRIMARYPRIMARY2const1 

Time Before: 0.10154 seconds
Time After: 0.11267 seconds
Time Taken: 0.01113 seconds

Memory Before: 4,146.219 KB
Memory After: 4,146.172 KB
Memory Used: -0.047 KB

Time Before: 0.09724 seconds
Time After: 0.11298 seconds
Time Taken: 0.01574 seconds

Memory Before: 4,135.133 KB
Memory After: 4,269.402 KB
Memory Used: 134.270 KB

SQL Query
SELECT *
FROM Club_style
WHERE (styleid = 6 AND userselect = 1)
	OR styleid = 6
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_styleconstPRIMARYPRIMARY2const1 

Time Before: 0.15978 seconds
Time After: 0.17026 seconds
Time Taken: 0.01048 seconds

Memory Before: 4,801.371 KB
Memory After: 4,801.902 KB
Memory Used: 0.531 KB

SQL Query
SELECT title, template
FROM Club_template
WHERE templateid IN (7623,7615,7620,5771,7225,7224,5716,7226,7232,7233,7234,7235,7228,7231,7230,7217,7406,7407,7408,7622,7638,7621,0,7619,7618,7515,7523,7524,7683,7673,7684,8009,0,0,7092,7086,5842,7090,7091,5845,7088,7413,7697,7359,7360,7361,7362,7676,7677,7678,7682,7699,7382,7383,7385,7386,7614,7717,7716,7718,7721,7206,7205,7209,5847,2925,2936,2937,2938,2940,2941,2939,5751,7810,0,7811,7812,7849,5891,7908,2797,2798,2886,0,2889,2890,2891,2892,2893,2898,2900,5892,2847,2848,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2849,2870,2871,2869,2879,2880,5433,5434,4041,5890,5887,5888,5333,5334,5335,5336,5337)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_templaterangePRIMARYPRIMARY4 126Using where

Time Before: 0.17632 seconds
Time After: 0.19369 seconds
Time Taken: 0.01737 seconds

Memory Before: 5,419.172 KB
Memory After: 5,419.148 KB
Memory Used: -0.023 KB

SQL Query
SELECT MAX(permissions & 1) AS perm FROM Club_cms_permissions
	WHERE	nodeid = 1 AND usergroupid in (1)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_cms_permissionsrefnodeidnodeid4const14Using where

Time Before: 0.20518 seconds
Time After: 0.20537 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,850.863 KB
Memory After: 5,851.430 KB
Memory Used: 0.566 KB

SQL Query
SELECT template
FROM Club_template
WHERE templateid = 2846
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEClub_templateconstPRIMARYPRIMARY4const1 

Time Before: 0.20819 seconds
Time After: 0.20836 seconds
Time Taken: 0.00017 seconds

Memory Before: 5,789.656 KB
Memory After: 5,790.250 KB
Memory Used: 0.594 KB

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 Club_user AS user
LEFT JOIN Club_avatar AS avatar ON avatar.avatarid = user.avatarid
LEFT JOIN Club_customavatar AS customavatar ON customavatar.userid = user.userid
WHERE user.userid = 0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Time Before: 0.21394 seconds
Time After: 0.21426 seconds
Time Taken: 0.00032 seconds

Memory Before: 6,012.988 KB
Memory After: 6,013.246 KB
Memory Used: 0.258 KB

SQL Query
SELECT userip
FROM Club_vsavilxh_guests AS vsavilxh_guests
WHERE userip = '38.107.191.84'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvsavilxh_guestsALL    50Using where

Time Before: 0.21866 seconds
Time After: 0.21916 seconds
Time Taken: 0.00050 seconds

Memory Before: 6,130.270 KB
Memory After: 6,130.828 KB
Memory Used: 0.559 KB

SQL Query
UPDATE Club_vsavilxh_guests
SET dateline = '1284055472'
WHERE userip = '38.107.191.84'

Time Before: 0.21931 seconds
Time After: 0.22225 seconds
Time Taken: 0.00294 seconds

Memory Before: 6,130.457 KB
Memory After: 6,130.957 KB
Memory Used: 0.500 KB

SQL Query
DELETE FROM Club_vsavilxh_guests WHERE dateline < '1283969072'

Time Before: 0.22236 seconds
Time After: 0.22254 seconds
Time Taken: 0.00018 seconds

Memory Before: 6,130.031 KB
Memory After: 6,130.570 KB
Memory Used: 0.539 KB

End call of global.php: 0.22284388542175
SQL Query
SELECT text, languageid, special
FROM Club_phrase AS phrase
LEFT JOIN Club_phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'nopermission_loggedout' AND languageid IN (-1, 0, 3)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type276 3Using where
1SIMPLEClub_phrasetypeconstPRIMARYPRIMARY20const1 

Time Before: 0.23025 seconds
Time After: 0.23054 seconds
Time Taken: 0.00028 seconds

Memory Before: 6,246.789 KB
Memory After: 6,247.238 KB
Memory Used: 0.449 KB

SQL Query
UPDATE Club_session
SET lastactivity = 1284055472, location = '/usercp.php?explain=1', inforum = 0, inthread = 0, badlocation = 1, bypass = 0
WHERE sessionhash = '29041270d2e48d07cd04f31e16e7d637'

Time Before: 0.25530 seconds
Time After: 0.25578 seconds
Time Taken: 0.00047 seconds

Memory Before: 6,570.684 KB
Memory After: 6,571.078 KB
Memory Used: 0.395 KB

Page generated in 0.2529878616333 seconds with 14 queries, spending 0.095624685287476 doing MySQL queries and 0.15736317634583 doing PHP things.
Shutdown Queries:
DISABLED