Connecting to database
Time before: 0.00016403198242188
Memory Before: 253KB
Time after: 0.00057101249694824
Time taken: 0.00040698051452637
Memory After: 262KB
Query:
SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache', 'arcadesettings', 'smiliecache', 'bbcodecache')
Time before: 0.00061702728271484
Memory Before: 263KB
Time after: 0.0014340877532959
Time taken: 0.00081706047058105
Memory After: 302KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
datastore |
range |
PRIMARY |
PRIMARY |
17 |
|
8 |
Using index condition |
Parsing functions.php
Time before: 0.0031259059906006
Memory Before: 978KB
Time after: 0.0032610893249512
Time taken: 0.00013518333435059
Memory After: 983KB
Query:
SELECT *
FROM session
WHERE userid = 0
AND host = '173.245.54.176'
AND idhash = '63427e432f933117f699128b80c5eb2a'
LIMIT 1
Time before: 0.0033359527587891
Memory Before: 993KB
Time after: 0.043313980102539
Time taken: 0.03997802734375
Memory After: 998KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
session |
ALL |
|
|
|
|
32004 |
Using where |
Query:
SELECT languageid,
phrasegroup_showthread AS phrasegroup_showthread,
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.043946981430054
Memory Before: 1,000KB
Time after: 0.044832944869995
Time taken: 0.00088596343994141
Memory After: 1,005KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
language |
system |
PRIMARY |
|
|
|
1 |
|
Processing sessions.php
Time before: 0.003309965133667
Memory Before: 990KB
End sessions.php processing
Time after: 0.045202016830444
Time taken: 0.041892051696777
Memory After: 1,033KB
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.046025037765503
Memory Before: 1,145KB
Time after: 0.046690940856934
Time taken: 0.00066590309143066
Memory After: 1,152KB
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.04749608039856
Memory Before: 1,156KB
Time after: 0.047792911529541
Time taken: 0.00029683113098145
Memory After: 1,160KB
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 (4724,4725,4528,4529,4530,1494,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.048427104949951
Memory Before: 1,269KB
Time after: 0.049405097961426
Time taken: 0.00097799301147461
Memory After: 1,272KB
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.050681114196777
Query:
SELECT COUNT(*) AS total
FROM post AS post
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE threadid=23414 AND visible=1 AND deletionlog.primaryid IS NULL
Time before: 0.051054000854492
Memory Before: 1,340KB
Time after: 0.094510078430176
Time taken: 0.043456077575684
Memory After: 1,342KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
post |
ref |
threadid |
threadid |
4 |
const |
1 |
Using where |
deletionlog |
eq_ref |
PRIMARY |
PRIMARY |
5 |
cos_oldposts.post.postid,const |
1 |
Using where; Not exists; Using index |
Query:
SELECT post.*,post.username AS postusername,user.username
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
WHERE post.threadid=23414 AND post.visible=1 AND deletionlog.primaryid IS NULL
ORDER BY dateline
LIMIT 0, 30
Time before: 0.095412969589233
Memory Before: 1,344KB
Time after: 0.12056708335876
Time taken: 0.025154113769531
Memory After: 1,350KB
table |
type |
possible_keys |
key |
key_len |
ref |
rows |
Extra |
post |
ref |
threadid |
threadid |
4 |
const |
1 |
Using where; Using filesort |
user |
eq_ref |
PRIMARY |
PRIMARY |
4 |
cos_oldposts.post.userid |
1 |
|
deletionlog |
eq_ref |
PRIMARY |
PRIMARY |
5 |
cos_oldposts.post.postid,const |
1 |
Using where; Not exists; Using index |
Page generated in 0.12839389 seconds with 8 queries,
spending 0.1126389503479 doing MySQL queries and 0.0157549396521 doing PHP things.
Shutdown Queries:
Query:
INSERT INTO session
(sessionhash, userid, host, useragent, idhash, lastactivity, location, bypass, styleid
,inforum, inthread, incalendar, badlocation
)
VALUES
('7046d66495a8f429d1949e64aac228ff', 0,
'173.245.54.176', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '63427e432f933117f699128b80c5eb2a',
1615017586, '/cosarchive/printthread.php?t=23414&explain=1', 0, 0
,98, 23414, 0,0
)
Time before: 0.12871789932251
Memory Before: 1,504KB
Time after: 0.1289849281311
Time taken: 0.00026702880859375
Memory After: 1,504KB