Including Functions.php

Time Before: 0.00194 seconds
Time After: 0.00213 seconds
Time Taken: 0.00019 seconds

Memory Before: 456.047 KB
Memory After: 523.000 KB
Memory Used: 66.953 KB

Connect to Database on Server: localhost

Time Before: 0.00218 seconds
Time After: 0.00266 seconds
Time Taken: 0.00049 seconds

Memory Before: 522.977 KB
Memory After: 523.555 KB
Memory Used: 0.578 KB

Datastore Setup
SQL Query
SELECT *
FROM datastore
WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','navdata','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','activitystream','routes')
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore ALLPRIMARY   3369.70Using where

Time Before: 0.00346 seconds
Time After: 0.00418 seconds
Time Taken: 0.00072 seconds

Memory Before: 525.648 KB
Memory After: 668.891 KB
Memory Used: 143.242 KB

Time Before: 0.00282 seconds
Time After: 0.01462 seconds
Time Taken: 0.01180 seconds

Memory Before: 523.375 KB
Memory After: 982.820 KB
Memory Used: 459.445 KB

Session Handling
SQL Query
SELECT *
FROM session
WHERE userid = 0
	AND host = '3.227.235.71'
	AND idhash = '3c7d60415ea2b632239283a66e8d7d1e'
LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refuser_activity,guest_lookupguest_lookup83const,const,const2100.00 

Time Before: 0.01572 seconds
Time After: 0.01600 seconds
Time Taken: 0.00027 seconds

Memory Before: 1,144.508 KB
Memory After: 1,161.211 KB
Memory Used: 16.703 KB

SQL Query
SELECT languageid,
			phrasegroup_global AS phrasegroup_global,
			phrasegroup_posting AS phrasegroup_posting,
			phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
			phrasegroup_postbit AS phrasegroup_postbit,
			phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
			phrasegroup_inlinemod AS phrasegroup_inlinemod,
			phrasegroupinfo AS lang_phrasegroupinfo,
			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
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLElanguage systemPRIMARY   1100.00 

Time Before: 0.01679 seconds
Time After: 0.01740 seconds
Time Taken: 0.00060 seconds

Memory Before: 1,152.461 KB
Memory After: 1,261.102 KB
Memory Used: 108.641 KB

Time Before: 0.01515 seconds
Time After: 0.01757 seconds
Time Taken: 0.00242 seconds

Memory Before: 1,140.734 KB
Memory After: 1,252.969 KB
Memory Used: 112.234 KB

SQL Query
SELECT MAX(permissions & 1) AS perm
FROM cms_permissions
WHERE nodeid = 1 AND usergroupid IN (1)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcms_permissions constusergroupid,nodeidusergroupid8const,const1100.00 

Time Before: 0.02848 seconds
Time After: 0.02868 seconds
Time Taken: 0.00020 seconds

Memory Before: 1,461.695 KB
Memory After: 1,477.945 KB
Memory Used: 16.250 KB

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

Time Before: 0.02949 seconds
Time After: 0.02995 seconds
Time Taken: 0.00046 seconds

Memory Before: 1,529.297 KB
Memory After: 1,657.938 KB
Memory Used: 128.641 KB

End call of global.php: 0.037405014038086
SQL Query
SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'cms_priv_user_0'
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

Time Before: 0.03812 seconds
Time After: 0.03832 seconds
Time Taken: 0.00020 seconds

Memory Before: 2,000.703 KB
Memory After: 2,017.156 KB
Memory Used: 16.453 KB

SQL Query
UPDATE cache
SET locktime = 1566263238
WHERE cacheid = 'cms_priv_user_0'

Time Before: 0.03847 seconds
Time After: 0.03998 seconds
Time Taken: 0.00151 seconds

Memory Before: 2,005.352 KB
Memory After: 2,005.352 KB
Memory Used: 0.000 KB

SQL Query
SELECT vbcmspermissions FROM administrator WHERE userid = 0
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         no matching row in const table

Time Before: 0.04033 seconds
Time After: 0.04050 seconds
Time Taken: 0.00017 seconds

Memory Before: 2,001.438 KB
Memory After: 2,017.781 KB
Memory Used: 16.344 KB

SQL Query
SELECT nodeid,
			MAX(permissions & 1) AS canview, MAX(permissions & 2) AS cancreate , MAX(permissions & 4) AS canedit,
			MAX(permissions & 8) AS canpublish, MAX(permissions & 16) AS canusehtml, MAX(permissions & 32) AS candownload
			FROM cms_permissions p
			WHERE usergroupid IN (1)
			GROUP BY nodeid;
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEp refusergroupid,nodeidusergroupid4const1100.00Using index condition

Time Before: 0.04090 seconds
Time After: 0.04119 seconds
Time Taken: 0.00029 seconds

Memory Before: 2,001.969 KB
Memory After: 2,018.344 KB
Memory Used: 16.375 KB

SQL Query
REPLACE INTO cache
SET cacheid = 'cms_priv_user_0',
	expires = 1566263538,
	created = 1566263238,
	locktime = 0,
	data = "a:10:{s:7:\"canview\";a:1:{i:0;s:1:\"1\";}s:9:\"cancreate\";a:1:{i:0;i:-1;}s:7:\"canedit\";a:1:{i:0;i:-1;}s:10:\"canpublish\";a:1:{i:0;i:-1;}s:10:\"canusehtml\";a:1:{i:0;i:-1;}s:5:\"admin\";i:0;s:11:\"candownload\";a:1:{i:0;s:1:\"1\";}s:7:\"alledit\";a:1:{i:0;i:-1;}s:8:\"viewonly\";a:1:{i:0;s:1:\"1\";}s:7:\"allview\";a:1:{i:0;s:1:\"1\";}}",
	serialized = '1'

Time Before: 0.04169 seconds
Time After: 0.04288 seconds
Time Taken: 0.00120 seconds

Memory Before: 2,029.430 KB
Memory After: 2,028.805 KB
Memory Used: -0.625 KB

SQL Query
SELECT bm.userid, bm.permissions, bm.type, user.username
FROM blog_moderator AS bm
INNER JOIN user AS user USING (userid)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEbm ALLuserid   1100.00 
1SIMPLEuser eq_refPRIMARYPRIMARY4vb_local.bm.userid1100.00 

Time Before: 0.04351 seconds
Time After: 0.04375 seconds
Time Taken: 0.00024 seconds

Memory Before: 2,030.750 KB
Memory After: 2,046.938 KB
Memory Used: 16.188 KB

SQL Query
SELECT
	blog.blogid, blog.title, blog.dateline, blog.state, blog.options AS blogoptions, user.*, blog.postedby_userid, blog.postedby_username,
	blog_user.title AS blogtitle, blog_user.bloguserid,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.infractiongroupid, options_ignore, options_buddy, options_member, options_guest, blog_user.bloguserid
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

FROM blog AS blog 
LEFT JOIN user AS user ON (user.userid = blog.postedby_userid)
INNER JOIN user AS user2 ON (user2.userid = blog.userid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE blog.state IN('visible')
	AND blog.dateline <= 1566263238
	AND blog.pending = 0
	AND blog.dateline >= 1563584838
	AND options_guest & 1
	AND ~blog.options & 8

ORDER BY blog.dateline DESC
LIMIT 10
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEblog refdateline,state,userid,pendingstate1const118.71Using where
1SIMPLEuser eq_refPRIMARYPRIMARY4vb_local.blog.postedby_userid1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2vb_local.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4vb_local.user.userid1100.00 
1SIMPLEblog_user eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using where
1SIMPLEuser2 eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using index

Time Before: 0.04500 seconds
Time After: 0.04609 seconds
Time Taken: 0.00109 seconds

Memory Before: 2,034.719 KB
Memory After: 2,066.227 KB
Memory Used: 31.508 KB

SQL Query
SELECT title, template
FROM template
WHERE templateid IN (12,47,115,64,10,9,8,536,534,77,98,50,51,52,59,92,93,99,95,96,97,94,100,101,102,104,105,106,107,103,112,109,5,758,760,67,58,66,967,999,1000,1020,0,0,426,420,419,424,425,423,422,427,428,429,735,1009,681,685,682,683,684,1039,0,0,1019,980,705,706,708,709,932,1051,1033,983,984,532,531,535,519,524,520,526,527,522,523,525,464,466,468,470,472,698,693,696,697,777,778,699,694,691,692,990,85,0,0,0,0)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEtemplate rangePRIMARYPRIMARY4 100100.00Using where

Time Before: 0.05008 seconds
Time After: 0.05128 seconds
Time Taken: 0.00120 seconds

Memory Before: 2,218.844 KB
Memory After: 2,482.695 KB
Memory Used: 263.852 KB

SQL Query
SELECT blog.blogid, user.username, blogtextid, blog.title, blog_text.dateline, blog_text.pagetext, user.*, blog_user.title AS blogtitle, blog_text.title AS commenttitle,
	blog_text.state,
	IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, user.infractiongroupid, options_ignore, options_buddy, options_member, options_guest
	,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight

FROM blog_text AS blog_text
LEFT JOIN blog AS blog ON (blog.blogid = blog_text.blogid)
LEFT JOIN user AS user ON (user.userid = blog_text.userid)
INNER JOIN user AS user2 ON (user2.userid = blog.userid)
LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)

LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

WHERE blog.state IN('visible')
	AND blog.dateline <= 1566263238
	AND blog.pending = 0
	AND blog_text.state IN('visible')
	AND blog.firstblogtextid <> blog_text.blogtextid
	AND blog_text.dateline >= 1565658438
	AND options_guest & 1
	AND ~blog.options & 8

ORDER BY blog_text.dateline DESC
LIMIT 10
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEblog_text rangeblogid,datelinedateline4 133.33Using index condition; Using where
1SIMPLEblog eq_refPRIMARY,dateline,state,userid,pendingPRIMARY4vb_local.blog_text.blogid15.00Using where
1SIMPLEblog_user eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using where
1SIMPLEuser eq_refPRIMARYPRIMARY4vb_local.blog_text.userid1100.00 
1SIMPLEavatar eq_refPRIMARYPRIMARY2vb_local.user.avatarid1100.00Using where
1SIMPLEcustomavatar eq_refPRIMARYPRIMARY4vb_local.user.userid1100.00 
1SIMPLEuser2 eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using index

Time Before: 0.05832 seconds
Time After: 0.05893 seconds
Time Taken: 0.00061 seconds

Memory Before: 2,508.836 KB
Memory After: 2,523.555 KB
Memory Used: 14.719 KB

SQL Query
SELECT text, languageid, special
FROM phrase AS phrase
LEFT JOIN phrasetype USING (fieldname)
WHERE phrase.fieldname = 'error'
	AND varname = 'blog_no_comments' AND languageid IN (-1, 0, 1)
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEphrase rangename_lang_type,languageidname_lang_type276 3100.00Using index condition
1SIMPLEphrasetype constPRIMARYPRIMARY20const1100.00 

Time Before: 0.05977 seconds
Time After: 0.06015 seconds
Time Taken: 0.00038 seconds

Memory Before: 2,505.555 KB
Memory After: 2,521.742 KB
Memory Used: 16.188 KB

SQL Query
SELECT COUNT(*) AS total,
			FROM_UNIXTIME(dateline - 0, '%c-%e-%Y') AS period
			FROM blog AS blog
			LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
			WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND dateline >= 1563667200 AND dateline < 1566263238
			GROUP BY period
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEblog refdateline,state,userid,pendingstate1const1186.14Using index condition; Using where; Using temporary; Using filesort
1SIMPLEblog_user eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using where

Time Before: 0.06091 seconds
Time After: 0.06240 seconds
Time Taken: 0.00148 seconds

Memory Before: 2,511.086 KB
Memory After: 2,527.781 KB
Memory Used: 16.695 KB

SQL Query
SELECT MAX(dateline) AS dateline
			FROM blog AS blog
			LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
			WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND dateline <= 1564617599
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEblog refdateline,state,useridstate1const1199.01Using index condition; Using where
1SIMPLEblog_user eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using where

Time Before: 0.06758 seconds
Time After: 0.06858 seconds
Time Taken: 0.00100 seconds

Memory Before: 2,546.258 KB
Memory After: 2,562.477 KB
Memory Used: 16.219 KB

SQL Query
SELECT SQL_CALC_FOUND_ROWS attach, blog.blogid, blog.dateline, blog.rating
				
				
				FROM blog AS blog
				
				LEFT JOIN blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
				
				WHERE blog.dateline >= 1566176838 AND options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND blog.pending = 0 AND blog.dateline <= 1566263238
				
			
			ORDER BY blog.dateline DESC
			LIMIT 0, 5
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEblog rangedateline,state,userid,pendingdateline4 15.00Using index condition; Using where
1SIMPLEblog_user eq_refPRIMARYPRIMARY4vb_local.blog.userid1100.00Using where

Time Before: 0.07509 seconds
Time After: 0.07540 seconds
Time Taken: 0.00030 seconds

Memory Before: 2,522.758 KB
Memory After: 2,538.539 KB
Memory Used: 15.781 KB

SQL Query
SELECT FOUND_ROWS()
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLE         No tables used

Time Before: 0.07562 seconds
Time After: 0.07572 seconds
Time Taken: 0.00011 seconds

Memory Before: 2,537.789 KB
Memory After: 2,554.195 KB
Memory Used: 16.406 KB

SQL Query
REPLACE INTO cacheevent
	(cacheid, event)
VALUES ('cms_priv_user_0', 'cms_permissions_change'),
	('cms_priv_user_0', 'permissions_0')

Time Before: 0.07937 seconds
Time After: 0.08106 seconds
Time Taken: 0.00169 seconds

Memory Before: 2,682.805 KB
Memory After: 2,682.742 KB
Memory Used: -0.063 KB

SQL Query
UPDATE session
SET lastactivity = 1566263238, location = '/blog.php?do=list&span=24&explain=1', badlocation = 0
WHERE sessionhash = 'd61cd0879094da9b71c78dadd54e21be'

Time Before: 0.08115 seconds
Time After: 0.08139 seconds
Time Taken: 0.00023 seconds

Memory Before: 2,682.609 KB
Memory After: 2,682.484 KB
Memory Used: -0.125 KB

Page generated in 0.078999042510986 seconds with 21 queries, spending 0.014448165893555 doing MySQL queries and 0.064550876617432 doing PHP things.
Shutdown Queries:
DISABLED