Connecting to database
Time before: 0.00019407272338867
Memory Before: 254KB
Time after: 0.00057196617126465
Time taken: 0.00037789344787598
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.00062298774719238
Memory Before: 264KB
Time after: 0.0079360008239746
Time taken: 0.0073130130767822
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.0091190338134766
Memory Before: 929KB
Time after: 0.0092229843139648
Time taken: 0.00010395050048828
Memory After: 934KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '172.69.62.32'
AND idhash = '14cf6217516449dd92c787ba7d29e394'
LIMIT 1
Time before: 0.0092949867248535
Memory Before: 944KB
Time after: 0.027678966522217
Time taken: 0.018383979797363
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.028130054473877
Memory Before: 951KB
Time after: 0.028611898422241
Time taken: 0.00048184394836426
Memory After: 956KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.0092670917510986
Memory Before: 941KB
End sessions.php processing
Time after: 0.029053926467896
Time taken: 0.019786834716797
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.029680013656616
Memory Before: 1,085KB
Time after: 0.030054092407227
Time taken: 0.00037407875061035
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.03059196472168
Memory Before: 1,200KB
Time after: 0.059791088104248
Time taken: 0.029199123382568
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.0609450340271
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 > 1618133761
Time before: 0.06129789352417
Memory Before: 1,271KB
Time after: 0.079771995544434
Time taken: 0.018474102020264
Memory After: 1,275KB
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.080415964126587
Memory Before: 1,285KB
Time after: 0.080761909484863
Time taken: 0.00034594535827637
Memory After: 1,292KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
forum |
ALL |
|
|
|
|
67 |
|
Page generated in 0.08515596 seconds with 7 queries,
spending 0.074949979782104 doing MySQL queries and 0.010205980217896 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('6fd0d9e281bc4c838f89ac454a6f1d78', 0,
'172.69.62.32', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '14cf6217516449dd92c787ba7d29e394',
1618135561, '/cosarchive/index.php?&explain=1', 0, 0
,0, 0, 0,0
)
Time before: 0.08556604385376
Memory Before: 1,521KB
Time after: 0.086353063583374
Time taken: 0.00078701972961426
Memory After: 1,521KB