Including Functions.php

Time Before: 0.02580 seconds
Time After: 0.04002 seconds
Time Taken: 0.01421 seconds

Memory Before: 1,264.477 KB
Memory After: 2,188.352 KB
Memory Used: 923.875 KB

Connect to Database on Server: 127.0.0.1

Time Before: 0.04009 seconds
Time After: 0.04360 seconds
Time Taken: 0.00350 seconds

Memory Before: 2,188.320 KB
Memory After: 2,189.234 KB
Memory Used: 0.914 KB

SQL Query
SET @@sql_mode = ''

Time Before: 0.04508 seconds
Time After: 0.04538 seconds
Time Taken: 0.00029 seconds

Memory Before: 2,190.094 KB
Memory After: 2,190.680 KB
Memory Used: 0.586 KB

Datastore Setup
SQL Query
SELECT *
FROM vb_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','adv_modules','adv_portal_cale','adv_portal_home','adv_portal_opts','adv_portal_page','adv_portal_pars','adv_portal_stat','attachmentcache','bbcodecache','birthdaycache','eventcache','iconcache','maxloggedin','prefixcache','ranks','tagcloud','smiliecache','userstats')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastorerangePRIMARYPRIMARY50 31Using where

Time Before: 0.04729 seconds
Time After: 0.05043 seconds
Time Taken: 0.00314 seconds

Memory Before: 2,194.461 KB
Memory After: 2,194.570 KB
Memory Used: 0.109 KB

Time Before: 0.04636 seconds
Time After: 0.06213 seconds
Time Taken: 0.01577 seconds

Memory Before: 2,189.922 KB
Memory After: 4,888.922 KB
Memory Used: 2,699.000 KB

SQL Query
SELECT *
FROM vb_datastore
WHERE title IN ('wol_spiders')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastoreconstPRIMARYPRIMARY50const1 

Time Before: 0.06540 seconds
Time After: 0.06569 seconds
Time Taken: 0.00029 seconds

Memory Before: 5,214.195 KB
Memory After: 5,214.719 KB
Memory Used: 0.523 KB

Session Handling
SQL Query
SELECT *
FROM vb_session
WHERE userid = 0
	AND host = '3.80.223.123'
	AND idhash = '9cfcb1a0ad019d5aefd23135a7906d9d'
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionALL    475Using where

Time Before: 0.06703 seconds
Time After: 0.06761 seconds
Time Taken: 0.00058 seconds

Memory Before: 5,599.758 KB
Memory After: 5,600.203 KB
Memory Used: 0.445 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_adv_portal AS phrasegroup_adv_portal,
			phrasegroup_calendar AS phrasegroup_calendar,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_autopm_title AS phrasegroup_autopm_title,
			phrasegroup_autopm_text AS phrasegroup_autopm_text,
			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 vb_language
WHERE languageid = 2
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_languageconstPRIMARYPRIMARY2const1 

Time Before: 0.06869 seconds
Time After: 0.06918 seconds
Time Taken: 0.00049 seconds

Memory Before: 5,611.867 KB
Memory After: 5,611.578 KB
Memory Used: -0.289 KB

Time Before: 0.06640 seconds
Time After: 0.06955 seconds
Time Taken: 0.00315 seconds

Memory Before: 5,594.883 KB
Memory After: 5,714.750 KB
Memory Used: 119.867 KB

SQL Query
SELECT *
FROM vb_style
WHERE (styleid = 5 AND userselect = 1)
	OR styleid = 5
ORDER BY styleid ASC
LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_styleconstPRIMARYPRIMARY2const1 

Time Before: 0.08016 seconds
Time After: 0.08052 seconds
Time Taken: 0.00036 seconds

Memory Before: 6,035.516 KB
Memory After: 6,035.984 KB
Memory Used: 0.469 KB

SQL Query
SELECT title, template
FROM vb_template
WHERE templateid IN (1639,1649,1648,1671,1670,3663,1674,165,2262,1655,1656,186,3784,189,196,195,98,96,98,92,1664,1662,1663,3525,1651,3805,3806,3797,67,66,68,63,62,339,1088,291,292,293,559,562,571,312,313,314,315,513,576,575,3665,580,3600,3602,3598,3601,3488,1018,2128,3788,3787,1115,1113,1112,1114,1122,1123,1128,3531,3779,1238,1237,1250,2005,2004,2058,2126,2278,2279,2280,2645,3769,3751,2637,2636,3750,3723,3763,3765,3766,3764,2638,2639,2640,2641,2665,2666,2667,3673,2669,2670,3809,3810,3812,3811,3807,3808,2699,2704,2707,2703,2705,2706,2708,2700,2701,0,2702,2717,2719,2720,3161,3162,3527,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3212,3232,3233,3369,3370,3236,3237,3238,3245,3246,3406,3407,3532,3477,3478,3479,3480,3561)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 158Using where

Time Before: 0.08460 seconds
Time After: 0.08536 seconds
Time Taken: 0.00076 seconds

Memory Before: 6,327.305 KB
Memory After: 6,327.078 KB
Memory Used: -0.227 KB

SQL Query
SELECT moderator.*, user.username,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
FROM vb_moderator AS moderator
INNER JOIN vb_user AS user USING(userid)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorsystemuserid_forumid   1 
1SIMPLEuserconstPRIMARYPRIMARY4const1 

Time Before: 0.11445 seconds
Time After: 0.11464 seconds
Time Taken: 0.00019 seconds

Memory Before: 9,530.547 KB
Memory After: 9,531.320 KB
Memory Used: 0.773 KB

SQL Query
SELECT userip
FROM vb_cybvilxh_guests AS cybvilxh_guests
WHERE userip = '3.80.223.123'
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcybvilxh_guestsALL    56Using where

Time Before: 0.11806 seconds
Time After: 0.11848 seconds
Time Taken: 0.00042 seconds

Memory Before: 9,428.516 KB
Memory After: 9,429.008 KB
Memory Used: 0.492 KB

SQL Query
UPDATE vb_cybvilxh_guests
SET dateline = '1558633117'
WHERE userip = '3.80.223.123'

Time Before: 0.11920 seconds
Time After: 0.28603 seconds
Time Taken: 0.16683 seconds

Memory Before: 9,429.195 KB
Memory After: 9,429.523 KB
Memory Used: 0.328 KB

SQL Query
DELETE FROM vb_cybvilxh_guests WHERE dateline < '1558546717'

Time Before: 0.28628 seconds
Time After: 0.28681 seconds
Time Taken: 0.00053 seconds

Memory Before: 9,428.336 KB
Memory After: 9,428.719 KB
Memory Used: 0.383 KB

End call of global.php: 0.29120206832886
Processing Module: Навигация по сайту
Time Before: 0.29136
Time After: 0.29443
Time Taken: 0.00308

Memory Before: 9,021.102 KB
Memory After: 9,047.094 KB
Memory Used: 25.992 KB

Навигация по сайту module generated in 0.00308 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00308 doing PHP things.

Processing Module: Мы ВКонтакте
Time Before: 0.29467
Time After: 0.29475
Time Taken: 0.00008

Memory Before: 9,047.250 KB
Memory After: 9,047.938 KB
Memory Used: 0.688 KB

Мы ВКонтакте module generated in 0.00008 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00008 doing PHP things.

Processing Module: Сейчас на сайте
SQL Query
SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb_session AS session
LEFT JOIN vb_user AS user USING (userid)
WHERE session.lastactivity > 1558632217
	
ORDER BY username ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionALL    475Using where; Using temporary; Using filesort
1SIMPLEusereq_refPRIMARYPRIMARY4lddnsk_forum.session.userid1 

Time Before: 0.29702 seconds
Time After: 0.29793 seconds
Time Taken: 0.00091 seconds

Memory Before: 9,103.852 KB
Memory After: 9,104.227 KB
Memory Used: 0.375 KB

Time Before: 0.29492
Time After: 0.29859
Time Taken: 0.00366

Memory Before: 9,047.773 KB
Memory After: 9,053.445 KB
Memory Used: 5.672 KB

Сейчас на сайте module generated in 0.00366 seconds with 1 queries.
0.00091 seconds doing MySQL queries and 0.00275 doing PHP things.

Processing Module: Новости
SQL Query
SELECT attachmentid, filename, filesize, dateline, postid, IF(thumbnail_filesize > 0, 1, 0) AS hasthumbnail, counter, attachment.thumbnail, attachment.thumbnail_dateline, LENGTH(attachment.thumbnail) AS thumbnailsize, newwindow, visible
FROM vb_attachment AS attachment
LEFT JOIN vb_attachmenttype AS attachmenttype ON (attachment.extension = attachmenttype.extension)
WHERE postid IN(693,1997,12959,3293,16018,2,694,12971,12974,1,10,578,899,7190,25566,3695,4444,12882,7216,12962,12970,30002,9173,10380,12963,12968,12969,17726,26653,16555,16605,16607,17534,17535,23993,528,1915,7191,12965,16072,16724,16406,25982,15741,16969,17350,15068,9139,17951,796,7052,7172,11835,17081,21581,25947,25953,27485,28555,33709,7192,2072,34203)
	AND visible = 1
GROUP BY attachment.postid
ORDER BY attachmentid
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEattachmentrefpostid,visiblevisible2const21Using where; Using temporary; Using filesort
1SIMPLEattachmenttypeeq_refPRIMARYPRIMARY20lddnsk_forum.attachment.extension1 

Time Before: 0.30447 seconds
Time After: 0.30477 seconds
Time Taken: 0.00031 seconds

Memory Before: 9,350.398 KB
Memory After: 9,350.273 KB
Memory Used: -0.125 KB

SQL Query
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, user.*, userfield.*, userfield.field11 AS gender, usergroup.opentag, usergroup.closetag, thread.threadid, post.title, thread.replycount, thread.lastposter AS postusername, postuserid, thread.lastpost AS postdateline, sticky, thread.attach, thread.lastpostid, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext
, allowsmilie, pagetext_html, postparsed.hasimages, avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
FROM vb_thread AS thread
LEFT JOIN vb_post AS post ON (post.postid = thread.lastpostid)
LEFT JOIN vb_user AS user ON (user.userid = post.userid)
LEFT JOIN vb_userfield AS userfield ON (userfield.userid = post.userid)
LEFT JOIN vb_usergroup AS usergroup ON (usergroup.usergroupid = user.displaygroupid)
 LEFT JOIN vb_postparsed AS postparsed ON (postparsed.postid = post.postid AND postparsed.styleid = 5 AND postparsed.languageid = 2) LEFT JOIN vb_avatar as avatar ON (avatar.avatarid = user.avatarid)
	LEFT JOIN vb_customavatar as customavatar ON (customavatar.userid = user.userid)
WHERE thread.threadid IN(102,225,241,298,1113,2,103,944,945,1,6,85,125,546,1662,335,354,925,551,929,943,1932,679,740,930,941,942,1201,1742,1139,1143,1145,1182,1183,1601,74,221,547,932,1118,1148,1164,1685,1092,1158,1176,1055,677,1219,116,535,544,851,1163,1433,1681,1682,1786,1845,2267,548,227,2317)



ORDER BY sticky DESC, thread.lastpost DESC
LIMIT 4
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEavatarsystemPRIMARY   0const row not found
1SIMPLEthreadrangePRIMARYPRIMARY4 63Using where; Using filesort
1SIMPLEposteq_refPRIMARYPRIMARY4lddnsk_forum.thread.lastpostid1 
1SIMPLEusereq_refPRIMARYPRIMARY4lddnsk_forum.post.userid1 
1SIMPLEuserfieldeq_refPRIMARYPRIMARY4lddnsk_forum.post.userid1 
1SIMPLEusergroupeq_refPRIMARYPRIMARY2lddnsk_forum.user.displaygroupid1 
1SIMPLEpostparsedeq_refPRIMARYPRIMARY8lddnsk_forum.post.postid,const,const1 
1SIMPLEcustomavatareq_refPRIMARYPRIMARY4lddnsk_forum.user.userid1 

Time Before: 0.30670 seconds
Time After: 0.30720 seconds
Time Taken: 0.00050 seconds

Memory Before: 9,356.227 KB
Memory After: 9,355.180 KB
Memory Used: -1.047 KB

Time Before: 0.29880
Time After: 0.31702
Time Taken: 0.01822

Memory Before: 9,053.195 KB
Memory After: 9,189.555 KB
Memory Used: 136.359 KB

Новости module generated in 0.01822 seconds with 2 queries.
0.00080 seconds doing MySQL queries and 0.01742 doing PHP things.

Processing Module: Последние темы
SQL Query
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, thread.lastpostid, pollid, thread.forumid, thread.open, sticky
, thread.iconid AS threadiconid, iconpath AS threadiconpath, thread.attach
FROM vb_thread as thread
 LEFT JOIN vb_icon AS icon ON (icon.iconid = thread.iconid)
WHERE open != 10
	AND thread.visible = 1 AND thread.lastpost > 1556041117
	 AND thread.forumid NOT IN(238,231,64,10,24,23,27,110,242,7,9,8,18,19)
ORDER BY lastpost DESC
LIMIT 5
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEthreadrangeforumid,lastpostlastpost4 1Using where
1SIMPLEiconeq_refPRIMARYPRIMARY2lddnsk_forum.thread.iconid1 

Time Before: 0.31957 seconds
Time After: 0.32033 seconds
Time Taken: 0.00076 seconds

Memory Before: 9,255.906 KB
Memory After: 9,255.844 KB
Memory Used: -0.063 KB

Time Before: 0.31724
Time After: 0.32121
Time Taken: 0.00397

Memory Before: 9,189.391 KB
Memory After: 9,186.266 KB
Memory Used: -3.125 KB

Последние темы module generated in 0.00397 seconds with 1 queries.
0.00076 seconds doing MySQL queries and 0.00321 doing PHP things.

Processing Module: Список серверов
Time Before: 0.32142
Time After: 0.32760
Time Taken: 0.00618

Memory Before: 9,186.305 KB
Memory After: 9,212.453 KB
Memory Used: 26.148 KB

Список серверов module generated in 0.00618 seconds with 0 queries.
0 seconds doing MySQL queries and 0.00618 doing PHP things.

SQL Query
UPDATE vb_session
SET lastactivity = 1558633117, location = '/cmps_index.php?explain=1', inforum = 0, inthread = 0, incalendar = 0, badlocation = 0
WHERE sessionhash = 'b0801dc08ec3660295899ff24fa96cb7'

Time Before: 0.33215 seconds
Time After: 0.33262 seconds
Time Taken: 0.00046 seconds

Memory Before: 9,636.711 KB
Memory After: 9,637.031 KB
Memory Used: 0.320 KB

Page generated in 0.33016395568848 seconds with 16 queries, spending 0.17091417312622 doing MySQL queries and 0.15924978256226 doing PHP things.
Shutdown Queries:
DISABLED