Connecting to database
Time before: 0.00017595291137695
Memory Before: 253KB
Time after: 0.00052309036254883
Time taken: 0.00034713745117188
Memory After: 262KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings')
Time before: 0.00057005882263184
Memory Before: 263KB
Time after: 0.0013411045074463
Time taken: 0.00077104568481445
Memory After: 298KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
datastore |
range |
PRIMARY |
PRIMARY |
17 |
|
6 |
Using index condition |
Parsing functions.php
Time before: 0.0024149417877197
Memory Before: 918KB
Time after: 0.0025479793548584
Time taken: 0.00013303756713867
Memory After: 923KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '162.158.79.244'
AND idhash = 'f69f9d4ab33dcf7196d546abae16c2dc'
LIMIT 1
Time before: 0.0026190280914307
Memory Before: 933KB
Time after: 0.020833969116211
Time taken: 0.01821494102478
Memory After: 938KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
Query:
SELECT languageid,
phrasegroup_messaging AS phrasegroup_messaging,
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.021238088607788
Memory Before: 939KB
Time after: 0.021692991256714
Time taken: 0.00045490264892578
Memory After: 945KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.0025930404663086
Memory Before: 930KB
End sessions.php processing
Time after: 0.022118091583252
Time taken: 0.019525051116943
Memory After: 973KB
Query:
SELECT * FROM style
WHERE (styleid = 10 AND userselect = 1)
OR styleid = 10
ORDER BY styleid ASC
LIMIT 1
Time before: 0.022881031036377
Memory Before: 1,080KB
Time after: 0.023233890533447
Time taken: 0.00035285949707031
Memory After: 1,084KB
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 (4812,4815,4798,4799,4672,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.02374005317688
Memory Before: 1,193KB
Time after: 0.024383068084717
Time taken: 0.00064301490783691
Memory After: 1,196KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
template |
range |
PRIMARY |
PRIMARY |
4 |
|
29 |
Using index condition |
End call of global.php: 0.025341033935547
Query:
SELECT text, languageid
FROM phrase
WHERE phrasetypeid = 1000
AND varname = 'emaildisabled'AND languageid IN (-1, 0, 1)
Time before: 0.025387048721313
Memory Before: 1,257KB
Time after: 0.025672912597656
Time taken: 0.00028586387634277
Memory After: 1,258KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
phrase |
range |
name_lang_type,languageid |
name_lang_type |
256 |
|
3 |
Using index condition |
Query:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 0.026021003723145
Memory Before: 1,264KB
Time after: 0.026267051696777
Time taken: 0.00024604797363281
Memory After: 1,271KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
forum |
ALL |
|
|
|
|
67 |
|
Page generated in 0.02733397 seconds with 7 queries,
spending 0.021315813064575 doing MySQL queries and 0.0060181569354248 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('e9f762668ffb7e24f4112e0b6cd42930', 0,
'162.158.79.244', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'f69f9d4ab33dcf7196d546abae16c2dc',
1614618533, '/cosarchive/sendmessage.php?explain=1', 0, 0
,0, 0, 0,3
)
Time before: 0.027580976486206
Memory Before: 1,455KB
Time after: 0.027782917022705
Time taken: 0.00020194053649902
Memory After: 1,456KB