Connecting to database
Time before: 0.00017189979553223
Memory Before: 256KB
Time after: 0.00066709518432617
Time taken: 0.00049519538879395
Memory After: 265KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings')
Time before: 0.00071907043457031
Memory Before: 266KB
Time after: 0.0014870166778564
Time taken: 0.00076794624328613
Memory After: 301KB
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.0033040046691895
Memory Before: 921KB
Time after: 0.0034089088439941
Time taken: 0.00010490417480469
Memory After: 926KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '172.69.63.90'
AND idhash = 'f69f9d4ab33dcf7196d546abae16c2dc'
LIMIT 1
Time before: 0.0034830570220947
Memory Before: 936KB
Time after: 0.02350902557373
Time taken: 0.020025968551636
Memory After: 941KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
Query:
SELECT languageid,
phrasegroup_fronthelp AS phrasegroup_fronthelp,
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.024036884307861
Memory Before: 942KB
Time after: 0.024476051330566
Time taken: 0.00043916702270508
Memory After: 948KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.0034570693969727
Memory Before: 933KB
End sessions.php processing
Time after: 0.024888038635254
Time taken: 0.021430969238281
Memory After: 981KB
Query:
SELECT * FROM style
WHERE (styleid = 10 AND userselect = 1)
OR styleid = 10
ORDER BY styleid ASC
LIMIT 1
Time before: 0.025680065155029
Memory Before: 1,095KB
Time after: 0.026060104370117
Time taken: 0.00038003921508789
Memory After: 1,099KB
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 (4609,4610,4611,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.026510953903198
Memory Before: 1,208KB
Time after: 0.063955068588257
Time taken: 0.037444114685059
Memory After: 1,211KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
template |
range |
PRIMARY |
PRIMARY |
4 |
|
27 |
Using index condition |
End call of global.php: 0.065102100372314
Query:
SELECT * FROM bbcode ORDER BY bbcodetag, twoparams
Time before: 0.065315008163452
Memory Before: 1,298KB
Time after: 0.084105968475342
Time taken: 0.01879096031189
Memory After: 1,302KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
bbcode |
ALL |
|
|
|
|
8 |
Using filesort |
Page generated in 0.08595991 seconds with 6 queries,
spending 0.078343391418457 doing MySQL queries and 0.007616518581543 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('265c60f9c4aa23fe6e9a09b73f38310f', 0,
'172.69.63.90', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'f69f9d4ab33dcf7196d546abae16c2dc',
1614808144, '/cosarchive/misc.php?do=bbcode&explain=1', 0, 0
,0, 0, 0,0
)
Time before: 0.086651086807251
Memory Before: 1,608KB
Time after: 0.086878061294556
Time taken: 0.00022697448730469
Memory After: 1,608KB