Connecting to database
Time before: 0.00020003318786621
Memory Before: 255KB
Time after: 0.00060105323791504
Time taken: 0.00040102005004883
Memory After: 264KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings')
Time before: 0.00065398216247559
Memory Before: 265KB
Time after: 0.001507043838501
Time taken: 0.00085306167602539
Memory After: 300KB
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.0026230812072754
Memory Before: 920KB
Time after: 0.0027360916137695
Time taken: 0.00011301040649414
Memory After: 924KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '172.68.65.161'
AND idhash = 'f69f9d4ab33dcf7196d546abae16c2dc'
LIMIT 1
Time before: 0.0028080940246582
Memory Before: 934KB
Time after: 0.022195100784302
Time taken: 0.019387006759644
Memory After: 939KB
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.022691011428833
Memory Before: 941KB
Time after: 0.023222923278809
Time taken: 0.00053191184997559
Memory After: 946KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.0027790069580078
Memory Before: 932KB
End sessions.php processing
Time after: 0.023596048355103
Time taken: 0.020817041397095
Memory After: 975KB
Query:
SELECT NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid,
deletionlog.username AS del_username, deletionlog.reason AS del_reason,
thread.*
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON (deletionlog.primaryid = thread.threadid AND deletionlog.type = 'thread')
WHERE thread.threadid = 23414
Time before: 0.024280071258545
Memory Before: 1,083KB
Time after: 0.024637937545776
Time taken: 0.00035786628723145
Memory After: 1,090KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
thread |
const |
PRIMARY |
PRIMARY |
4 |
const |
1 |
|
deletionlog |
const |
PRIMARY |
PRIMARY |
5 |
const,const |
0 |
unique row not found |
Query:
SELECT * FROM style
WHERE (styleid = 10 AND userselect = 1)
OR styleid = 10
ORDER BY styleid ASC
LIMIT 1
Time before: 0.02497410774231
Memory Before: 1,094KB
Time after: 0.025191068649292
Time taken: 0.00021696090698242
Memory After: 1,098KB
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,4676,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.025712013244629
Memory Before: 1,207KB
Time after: 0.026289939880371
Time taken: 0.00057792663574219
Memory After: 1,210KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
template |
range |
PRIMARY |
PRIMARY |
4 |
|
30 |
Using index condition |
End call of global.php: 0.027116060256958
Query:
SELECT text, languageid
FROM phrase
WHERE phrasetypeid = 1000
AND varname = 'emaildisabled'AND languageid IN (-1, 0, 1)
Time before: 0.027162075042725
Memory Before: 1,272KB
Time after: 0.027451992034912
Time taken: 0.0002899169921875
Memory After: 1,273KB
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.027781963348389
Memory Before: 1,280KB
Time after: 0.028057098388672
Time taken: 0.0002751350402832
Memory After: 1,287KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
forum |
ALL |
|
|
|
|
67 |
|
Page generated in 0.02928305 seconds with 8 queries,
spending 0.02289080619812 doing MySQL queries and 0.0063922438018799 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('14528b7ef7d68564753b0ed70e21b4fa', 0,
'172.68.65.161', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 'f69f9d4ab33dcf7196d546abae16c2dc',
1614613767, '/cosarchive/sendmessage.php?do=sendtofriend&t=23414&explain=1', 0, 0
,0, 0, 0,3
)
Time before: 0.029530048370361
Memory Before: 1,468KB
Time after: 0.029787063598633
Time taken: 0.00025701522827148
Memory After: 1,469KB