Including Functions.php

Time Before: 0.00347 seconds
Time After: 0.00866 seconds
Time Taken: 0.00518 seconds

Memory Before: 1,949.266 KB
Memory After: 2,710.789 KB
Memory Used: 761.523 KB

Connect to Database on Server: localhost

Time Before: 0.00871 seconds
Time After: 0.00900 seconds
Time Taken: 0.00030 seconds

Memory Before: 2,710.773 KB
Memory After: 2,711.727 KB
Memory Used: 0.953 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','iconcache','searchcloud')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY50 16100.00Using where

Time Before: 0.00948 seconds
Time After: 0.00984 seconds
Time Taken: 0.00036 seconds

Memory Before: 2,715.359 KB
Memory After: 2,716.320 KB
Memory Used: 0.961 KB

Time Before: 0.00908 seconds
Time After: 0.01087 seconds
Time Taken: 0.00179 seconds

Memory Before: 2,711.508 KB
Memory After: 3,478.953 KB
Memory Used: 767.445 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '18.232.188.251'
	AND idhash = '56dfcccec26bf52ac90238dd47f26102'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession ALL    12840.10Using where

Time Before: 0.01148 seconds
Time After: 0.01462 seconds
Time Taken: 0.00314 seconds

Memory Before: 3,514.945 KB
Memory After: 3,515.523 KB
Memory Used: 0.578 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_search AS phrasegroup_search,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroup_prefix AS phrasegroup_prefix,
			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 = 2
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage constPRIMARYPRIMARY2const1100.00 

Time Before: 0.01504 seconds
Time After: 0.01522 seconds
Time Taken: 0.00018 seconds

Memory Before: 3,526.047 KB
Memory After: 3,526.047 KB
Memory Used: 0.000 KB

Time Before: 0.01118 seconds
Time After: 0.01534 seconds
Time Taken: 0.00416 seconds

Memory Before: 3,510.117 KB
Memory After: 3,578.055 KB
Memory Used: 67.938 KB

SQL Query
SELECT *
FROM style
WHERE (styleid = 2 AND userselect = 1)
	OR styleid = 2
ORDER BY styleid ASC
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

Time Before: 0.01650 seconds
Time After: 0.01663 seconds
Time Taken: 0.00013 seconds

Memory Before: 3,658.102 KB
Memory After: 3,658.688 KB
Memory Used: 0.586 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (0,570,388,389,390,391,509,511,512,510,309,499,498,475,473,474,184,745,622,564,67,66,68,63,62,339,619,291,292,293,559,562,571,312,313,314,315,513,576,575,577,580,624,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,625,737,736,738,740,741,658,660,656,672,0,673,675,694,695)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 75100.00Using where

Time Before: 0.01769 seconds
Time After: 0.01818 seconds
Time Taken: 0.00049 seconds

Memory Before: 3,884.875 KB
Memory After: 3,886.859 KB
Memory Used: 1.984 KB

SQL Query
SELECT userip
FROM cybvilxh_guests AS cybvilxh_guests
WHERE userip = '18.232.188.251'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcybvilxh_guests ALL    42010.00Using where

Time Before: 0.02423 seconds
Time After: 0.02439 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,422.602 KB
Memory After: 5,423.125 KB
Memory Used: 0.523 KB

SQL Query
UPDATE cybvilxh_guests
SET dateline = '1585930976'
WHERE userip = '18.232.188.251'

Time Before: 0.02444 seconds
Time After: 0.03836 seconds
Time Taken: 0.01392 seconds

Memory Before: 5,423.313 KB
Memory After: 5,423.617 KB
Memory Used: 0.305 KB

SQL Query
DELETE FROM cybvilxh_guests WHERE dateline < '1585844576'

Time Before: 0.03841 seconds
Time After: 0.03866 seconds
Time Taken: 0.00026 seconds

Memory Before: 5,422.406 KB
Memory After: 5,422.758 KB
Memory Used: 0.352 KB

End call of global.php: 0.0394699573517
SQL Query
SELECT prefix.prefixsetid, prefix.prefixid, forumprefixset.forumid
FROM prefix AS prefix
INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = prefix.prefixsetid)
INNER JOIN forumprefixset AS forumprefixset ON
	(forumprefixset.prefixsetid = prefixset.prefixsetid)
ORDER BY prefixset.displayorder, prefix.displayorder
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEprefix indexprefixsetidprefixsetid31 1100.00Using index; Using temporary; Using filesort
1SIMPLEprefixset eq_refPRIMARYPRIMARY27mo0ojcco_vb.prefix.prefixsetid1100.00 
1SIMPLEforumprefixset index PRIMARY31 1100.00Using where; Using index; Using join buffer (Block Nested Loop)

Time Before: 0.04539 seconds
Time After: 0.04553 seconds
Time Taken: 0.00015 seconds

Memory Before: 5,866.906 KB
Memory After: 5,867.172 KB
Memory Used: 0.266 KB

SQL Query
SELECT hvquestion.questionid, COUNT(*) AS answers
FROM hvquestion AS hvquestion
LEFT JOIN hvanswer AS hvanswer
	ON (hvquestion.questionid = hvanswer.questionid)
WHERE hvanswer.answerid IS NOT NULL
	OR hvquestion.regex <> ''
GROUP BY hvquestion.questionid
ORDER BY RAND()
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEhvquestion indexPRIMARYPRIMARY4 6100.00Using temporary; Using filesort
1SIMPLEhvanswer refquestionidquestionid4mo0ojcco_vb.hvquestion.questionid1100.00Using where; Using index

Time Before: 0.04633 seconds
Time After: 0.04652 seconds
Time Taken: 0.00019 seconds

Memory Before: 5,911.891 KB
Memory After: 5,912.211 KB
Memory Used: 0.320 KB

SQL Query
INSERT INTO humanverify
	(hash, answer, dateline)
VALUES
	('19da524f2650e94d2822fbdcedfc9a89', '5', 1585930976)

Time Before: 0.04657 seconds
Time After: 0.05502 seconds
Time Taken: 0.00845 seconds

Memory Before: 5,911.570 KB
Memory After: 5,911.852 KB
Memory Used: 0.281 KB

SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'hvquestion'
	AND varname = 'question5'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEphrase refname_lang_typename_lang_type252const110.00Using index condition
1SIMPLEphrasetype constPRIMARYPRIMARY20const1100.00 

Time Before: 0.05534 seconds
Time After: 0.05550 seconds
Time Taken: 0.00016 seconds

Memory Before: 5,912.258 KB
Memory After: 5,912.719 KB
Memory Used: 0.461 KB

SQL Query
SELECT tagsearch.tagid, tag.tagtext, COUNT(*) AS searchcount
FROM tagsearch AS tagsearch
INNER JOIN tag AS tag ON (tagsearch.tagid = tag.tagid)
WHERE tagsearch.dateline > 1583338976
GROUP BY tagsearch.tagid, tag.tagtext
ORDER BY searchcount DESC
LIMIT 70
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtagsearch ALLtagid   19933.33Using where; Using temporary; Using filesort
1SIMPLEtag eq_refPRIMARYPRIMARY4mo0ojcco_vb.tagsearch.tagid1100.00 

Time Before: 0.05586 seconds
Time After: 0.05639 seconds
Time Taken: 0.00053 seconds

Memory Before: 5,914.641 KB
Memory After: 5,915.406 KB
Memory Used: 0.766 KB

SQL Query
REPLACE INTO datastore
	(title, data, unserialize)
VALUES
	('searchcloud', 'a:3:{s:4:\"tags\";a:14:{s:7:\"airshou\";a:5:{s:5:\"tagid\";s:3:\"292\";s:7:\"tagtext\";s:7:\"airshou\";s:11:\"searchcount\";s:2:\"22\";s:5:\"level\";d:5;s:11:\"tagtext_url\";s:7:\"airshou\";}s:5:\"اللغه\";a:5:{s:5:\"tagid\";s:2:\"38\";s:7:\"tagtext\";s:5:\"اللغه\";s:11:\"searchcount\";s:2:\"14\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:15:\"%C7%E1%E1%DB%E5\";}s:21:\"الموزاييكـ في الديكور\";a:5:{s:5:\"tagid\";s:1:\"3\";s:7:\"tagtext\";s:21:\"الموزاييكـ في الديكور\";s:11:\"searchcount\";s:2:\"10\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:59:\"%C7%E1%E3%E6%D2%C7%ED%ED%DF%DC+%DD%ED+%C7%E1%CF%ED%DF%E6%D1\";}s:8:\"انجليزيه\";a:5:{s:5:\"tagid\";s:2:\"39\";s:7:\"tagtext\";s:8:\"انجليزيه\";s:11:\"searchcount\";s:2:\"12\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:24:\"%C7%E4%CC%E1%ED%D2%ED%E5\";}s:6:\"برنامج\";a:5:{s:5:\"tagid\";s:2:\"36\";s:7:\"tagtext\";s:6:\"برنامج\";s:11:\"searchcount\";s:1:\"8\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:18:\"%C8%D1%E4%C7%E3%CC\";}s:5:\"تعليم\";a:5:{s:5:\"tagid\";s:2:\"37\";s:7:\"tagtext\";s:5:\"تعليم\";s:11:\"searchcount\";s:2:\"12\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:15:\"%CA%DA%E1%ED%E3\";}s:21:\"تهنئة،عيد،ميلآد،2015،\";a:5:{s:5:\"tagid\";s:1:\"2\";s:7:\"tagtext\";s:21:\"تهنئة،عيد،ميلآد،2015،\";s:11:\"searchcount\";s:2:\"16\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:55:\"%CA%E5%E4%C6%C9%A1%DA%ED%CF%A1%E3%ED%E1%C2%CF%A12015%A1\";}s:19:\"خلفيات،جالكسي،ايفون\";a:5:{s:5:\"tagid\";s:1:\"5\";s:7:\"tagtext\";s:19:\"خلفيات،جالكسي،ايفون\";s:11:\"searchcount\";s:2:\"10\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:57:\"%CE%E1%DD%ED%C7%CA%A1%CC%C7%E1%DF%D3%ED%A1%C7%ED%DD%E6%E4\";}s:21:\"دروس،حصريه، على، موج،\";a:5:{s:5:\"tagid\";s:1:\"1\";s:7:\"tagtext\";s:21:\"دروس،حصريه، على، موج،\";s:11:\"searchcount\";s:1:\"9\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:59:\"%CF%D1%E6%D3%A1%CD%D5%D1%ED%E5%A1+%DA%E1%EC%A1+%E3%E6%CC%A1\";}s:22:\"رمزيات،اتحاد،بلاك،2015\";a:5:{s:5:\"tagid\";s:1:\"4\";s:7:\"tagtext\";s:22:\"رمزيات،اتحاد،بلاك،2015\";s:11:\"searchcount\";s:2:\"13\";s:5:\"level\";d:2;s:11:\"tagtext_url\";s:58:\"%D1%E3%D2%ED%C7%CA%A1%C7%CA%CD%C7%CF%A1%C8%E1%C7%DF%A12015\";}s:5:\"مجانا\";a:5:{s:5:\"tagid\";s:2:\"40\";s:7:\"tagtext\";s:5:\"مجانا\";s:11:\"searchcount\";s:2:\"15\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:15:\"%E3%CC%C7%E4%C7\";}s:25:\"مصمم،رمزيات،بلاك،انستغرام\";a:5:{s:5:\"tagid\";s:1:\"6\";s:7:\"tagtext\";s:25:\"مصمم،رمزيات،بلاك،انستغرام\";s:11:\"searchcount\";s:2:\"14\";s:5:\"level\";d:3;s:11:\"tagtext_url\";s:75:\"%E3%D5%E3%E3%A1%D1%E3%D2%ED%C7%CA%A1%C8%E1%C7%DF%A1%C7%E4%D3%CA%DB%D1%C7%E3\";}s:3:\"نقش\";a:5:{s:5:\"tagid\";s:3:\"293\";s:7:\"tagtext\";s:3:\"نقش\";s:11:\"searchcount\";s:2:\"18\";s:5:\"level\";d:4;s:11:\"tagtext_url\";s:9:\"%E4%DE%D4\";}s:6:\"واتساب\";a:5:{s:5:\"tagid\";s:3:\"291\";s:7:\"tagtext\";s:6:\"واتساب\";s:11:\"searchcount\";s:1:\"8\";s:5:\"level\";d:1;s:11:\"tagtext_url\";s:18:\"%E6%C7%CA%D3%C7%C8\";}}s:5:\"count\";i:14;s:8:\"dateline\";i:1585930976;}', 1)

Time Before: 0.05662 seconds
Time After: 0.06560 seconds
Time Taken: 0.00898 seconds

Memory Before: 5,928.336 KB
Memory After: 5,925.766 KB
Memory Used: -2.570 KB

SQL Query
UPDATE ads_bnr AS ads_bnr SET ads_bnr.views = ads_bnr.views + 1 WHERE id IN(29)

Time Before: 0.06938 seconds
Time After: 0.07396 seconds
Time Taken: 0.00458 seconds

Memory Before: 6,672.664 KB
Memory After: 6,672.984 KB
Memory Used: 0.320 KB

SQL Query
UPDATE session
SET lastactivity = 1585930976, location = '/vb/search.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'e9af8c5d8b975d83531839b4a9ce0a4f'

Time Before: 0.07410 seconds
Time After: 0.07420 seconds
Time Taken: 0.00010 seconds

Memory Before: 6,676.281 KB
Memory After: 6,676.469 KB
Memory Used: 0.188 KB

Page generated in 0.0676538944244 seconds with 17 queries, spending 0.0425543785095 doing MySQL queries and 0.0250995159149 doing PHP things.
Shutdown Queries:
DISABLED