Connecting to database
Time before: 0.00018095970153809
Memory Before: 254KB
Time after: 0.00054097175598145
Time taken: 0.00036001205444336
Memory After: 263KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'userstats', 'birthdaycache', 'maxloggedin', 'iconcache', 'eventcache', 'mailqueue')
Time before: 0.00059199333190918
Memory Before: 264KB
Time after: 0.022176027297974
Time taken: 0.021584033966064
Memory After: 304KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
datastore |
range |
PRIMARY |
PRIMARY |
17 |
|
12 |
Using index condition |
Parsing functions.php
Time before: 0.023415088653564
Memory Before: 929KB
Time after: 0.023524045944214
Time taken: 0.00010895729064941
Memory After: 934KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '162.158.78.231'
AND idhash = 'fa60a4536908419506a6a027a1cff624'
LIMIT 1
Time before: 0.023598909378052
Memory Before: 944KB
Time after: 0.042644023895264
Time taken: 0.019045114517212
Memory After: 949KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
Query:
SELECT languageid,
phrasegroup_holiday AS phrasegroup_holiday,
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.043056964874268
Memory Before: 951KB
Time after: 0.043493986129761
Time taken: 0.00043702125549316
Memory After: 956KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.023569107055664
Memory Before: 941KB
End sessions.php processing
Time after: 0.043942928314209
Time taken: 0.020373821258545
Memory After: 982KB
Query:
SELECT * FROM style
WHERE (styleid = 10 AND userselect = 1)
OR styleid = 10
ORDER BY styleid ASC
LIMIT 1
Time before: 0.044574975967407
Memory Before: 1,085KB
Time after: 0.044941902160645
Time taken: 0.0003669261932373
Memory After: 1,088KB
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 (1501,4593,1502,4595,4596,1503,1505,4599,4600,0,4601,4602,4603,4604,1504,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.045432090759277
Memory Before: 1,200KB
Time after: 0.065850973129272
Time taken: 0.020418882369995
Memory After: 1,202KB
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.066904067993164
Query:
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1614694811
Time before: 0.067044019699097
Memory Before: 1,271KB
Time after: 0.085180044174194
Time taken: 0.018136024475098
Memory After: 1,282KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
user |
eq_ref |
PRIMARY |
PRIMARY |
4 |
cos_oldposts.session.userid |
1 |
|
Query:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum
Time before: 0.085885047912598
Memory Before: 1,326KB
Time after: 0.086189985275269
Time taken: 0.0003049373626709
Memory After: 1,334KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
forum |
ALL |
|
|
|
|
67 |
|
Page generated in 0.08997107 seconds with 7 queries,
spending 0.080652952194214 doing MySQL queries and 0.0093181178057861 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('188a6b56a933e6ee0e6f8ab93bbe361f', 0,
'162.158.78.231', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'fa60a4536908419506a6a027a1cff624',
1614696611, '/cosarchive/index.php?explain=1', 0, 0
,0, 0, 0,0
)
Time before: 0.090267896652222
Memory Before: 1,563KB
Time after: 0.090858936309814
Time taken: 0.00059103965759277
Memory After: 1,563KB