Connecting to database
Time before: 0.00020599365234375
Memory Before: 255KB
Time after: 0.00052905082702637
Time taken: 0.00032305717468262
Memory After: 264KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'smiliecache', 'bbcodecache', 'rankphp')
Time before: 0.00057601928710938
Memory Before: 265KB
Time after: 0.0014610290527344
Time taken: 0.000885009765625
Memory After: 304KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
datastore |
range |
PRIMARY |
PRIMARY |
17 |
|
9 |
Using index condition |
Parsing functions.php
Time before: 0.0027289390563965
Memory Before: 980KB
Time after: 0.0028369426727295
Time taken: 0.00010800361633301
Memory After: 985KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '162.158.78.231'
AND idhash = 'a214f7e5ff32e336abced6bb98e2de26'
LIMIT 1
Time before: 0.0029048919677734
Memory Before: 995KB
Time after: 0.020714998245239
Time taken: 0.017810106277466
Memory After: 1,000KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
Query:
SELECT languageid,
phrasegroup_wol AS phrasegroup_wol,
phrasegroup_user AS phrasegroup_user,
phrasegroup_global AS phrasegroup_global,
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 language
WHERE languageid = 1
Time before: 0.021122932434082
Memory Before: 1,002KB
Time after: 0.021606922149658
Time taken: 0.00048398971557617
Memory After: 1,007KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.0028789043426514
Memory Before: 992KB
End sessions.php processing
Time after: 0.021908044815063
Time taken: 0.019029140472412
Memory After: 1,055KB
Query:
SELECT * FROM style
WHERE (styleid = 10 AND userselect = 1)
OR styleid = 10
ORDER BY styleid ASC
LIMIT 1
Time before: 0.022749900817871
Memory Before: 1,203KB
Time after: 0.023086071014404
Time taken: 0.0003361701965332
Memory After: 1,206KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
style |
const |
PRIMARY |
PRIMARY |
2 |
const |
1 |
|
Query:
SELECT title, template
FROM template
WHERE templateid IN (1509,4625,1510,4626,4615,4616,4618,4623,4528,4529,4530,1494,4721,4779,4785,3093,2998,4041,3085,4685,4696,1515,4664,4803,4806,4813,4682,4683,4684,4774,4818,4817,4824,4823,4822,4819,4821,2177,2176)
Time before: 0.023581027984619
Memory Before: 1,318KB
Time after: 0.024245023727417
Time taken: 0.00066399574279785
Memory After: 1,320KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
template |
range |
PRIMARY |
PRIMARY |
4 |
|
39 |
Using index condition |
End call of global.php: 0.025310039520264
Query:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 0.025496959686279
Memory Before: 1,405KB
Time after: 0.025754928588867
Time taken: 0.00025796890258789
Memory After: 1,413KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
forum |
ALL |
|
|
|
|
67 |
|
Page generated in 0.02683306 seconds with 6 queries,
spending 0.020760297775269 doing MySQL queries and 0.0060727622247314 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('473f23761261251b71c38518f99b2e88', 0,
'162.158.78.231', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'a214f7e5ff32e336abced6bb98e2de26',
1615095116, '/cosarchive/member.php?u=10584&explain=1', 0, 0
,0, 0, 0,1
)
Time before: 0.027087926864624
Memory Before: 1,607KB
Time after: 0.027374029159546
Time taken: 0.00028610229492188
Memory After: 1,608KB