vBulletin - Explain SQL Queries (70)

SQL Query #1

SET @@sql_mode = ''

Time Before: 1611487258.17
Time After: 1611487258.1702
Time Taken: 0.00020694732666016
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(551)
#1 vB_Database->query_write('') in /core/vb/database.php(475)
#2 vB_Database->force_sql_mode('') in /core/vb/db/mysql/assertor.php(98)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:7]) in /core/vb/db/assertor.php(144)
#4 vB_dB_Assertor::init(array[len:4], array[len:7]) in /core/vb/vb.php(797)
#5 vB::getDbAssertor() in /core/vb/vb.php(525)
#6 vB::get_registry() in /core/vb/api.php(468)
#7 vB_Api->__construct() in /core/vb/api/options.php(27)
#8 vB_Api_Options->__construct() in /core/vb/api.php(172)
#9 vB_Api::instance('options') in /includes/api/interface/collapsed.php(185)
#10 Api_Interface_Collapsed->callApi('options', 'fetch') in /includes/vb5/template/options.php(63)
#11 vB5_Template_Options->fetchOptions() in /includes/vb5/template/options.php(55)
#12 vB5_Template_Options->getOptions() in /includes/vb5/template/options.php(25)
#13 vB5_Template_Options::instance() in /includes/vb5/cookie.php(136)
#14 vB5_Cookie::loadConfig() in /includes/vb5/cookie.php(52)
#15 vB5_Cookie::get('languageid', 1) in /includes/api/interface/collapsed.php(43)
#16 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#17 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(95)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #2

SELECT * FROM datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','vBUgChannelAccess','vBUgChannelPermissionsFrom','vBChannelTypes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	datastore	range	PRIMARY	PRIMARY	50		17	Using where

Time Before: 1611487258.1718
Time After: 1611487258.1728
Time Taken: 0.00098681449890137
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:293]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in /core/vb/datastore.php(538)
#7 vB_Datastore->do_db_fetch(array[len:17]) in /core/vb/datastore.php(493)
#8 vB_Datastore->fetch(array[len:17]) in /core/vb/datastore.php(177)
#9 vB_Datastore->getValue('options') in /core/vb/vb.php(532)
#10 vB::get_registry() in /core/vb/api.php(468)
#11 vB_Api->__construct() in /core/vb/api/options.php(27)
#12 vB_Api_Options->__construct() in /core/vb/api.php(172)
#13 vB_Api::instance('options') in /includes/api/interface/collapsed.php(185)
#14 Api_Interface_Collapsed->callApi('options', 'fetch') in /includes/vb5/template/options.php(63)
#15 vB5_Template_Options->fetchOptions() in /includes/vb5/template/options.php(55)
#16 vB5_Template_Options->getOptions() in /includes/vb5/template/options.php(25)
#17 vB5_Template_Options::instance() in /includes/vb5/cookie.php(136)
#18 vB5_Cookie::loadConfig() in /includes/vb5/cookie.php(52)
#19 vB5_Cookie::get('languageid', 1) in /includes/api/interface/collapsed.php(43)
#20 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#21 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(95)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #3

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '18.204.42.98' AND `idhash` = '09cd3e0310793b0dcc443bd98ff799a0' 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	session	ref	user_activity,guest_lookup	guest_lookup	51	const,const,const	1	Using index condition

Time Before: 1611487258.1768
Time After: 1611487258.1779
Time Taken: 0.0010840892791748
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:129]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('session', array[len:4], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('session', array[len:4]) in /core/vb/session.php(208)
#8 vB_Session->loadExistingSession('', array[len:2]) in /core/vb/session.php(408)
#9 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2], 0, 0) in /core/vb/session/web.php(31)
#10 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2], 0, 0) in /core/vb/session/webapi.php(72)
#11 vB_Session_WebApi->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2]) in /core/vb/session/webapi.php(66)
#12 vB_Session_WebApi::createSessionNew('', array[len:2]) in /core/vb/request/webapi.php(54)
#13 vB_Request_WebApi->createSessionNew('', array[len:2]) in /includes/api/interface/collapsed.php(75)
#14 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#15 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(95)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('d192b4e23e62be4d6d71b7005a67b3b9')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1783
Time After: 1611487258.179
Time Taken: 0.00070691108703613
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:77]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/language.php(73)
#9 vB_Language::getPhraseCache('d192b4e23e[len:32]') in /core/vb/language.php(49)
#10 vB_Language::getPhraseInfo(2) in /core/vb/session.php(749)
#11 vB_Session->loadLanguage() in /core/vb/session.php(849)
#12 vB_Session->fetch_userinfo() in /core/vb/vb.php(945)
#13 vB::setCurrentSession(vB_Session_WebApi) in /core/vb/request.php(193)
#14 vB_Request->setSession(vB_Session_WebApi) in /core/vb/request/webapi.php(55)
#15 vB_Request_WebApi->createSessionNew('', array[len:2]) in /includes/api/interface/collapsed.php(75)
#16 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#17 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(95)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #5

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1809
Time After: 1611487258.1812
Time Taken: 0.00029397010803223
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1398)
#9 vB5_Route::fetchCommonRoutes() in /core/vb/api/route.php(113)
#10 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #6

SELECT * FROM routenew
 WHERE `prefix` IN ('search','')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	range	prefix	prefix	202		2	Using index condition

Time Before: 1611487258.1813
Time After: 1611487258.1814
Time Taken: 0.00014710426330566
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:56]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb/api/route.php(148)
#7 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#8 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#9 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#10 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#11 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #7

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1817
Time After: 1611487258.1819
Time Taken: 0.00015616416931152
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/usercontext.php(140)
#9 vB_UserContext->reloadUserPerms() in /core/vb/usercontext.php(113)
#10 vB_UserContext->__construct(0, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7]) in /core/vb/vb.php(902)
#11 vB::getUserContext(0) in /core/vb/library/user.php(38)
#12 vB_Library_User->isBanned('0') in /core/vb/library/user.php(72)
#13 vB_Library_User->fetchBannedInfo('0') in /core/vb/api/route.php(173)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #8

SELECT * FROM page
 WHERE `pageid` = 12 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.1822
Time After: 1611487258.1824
Time Taken: 0.00015807151794434
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:49]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(26)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(49)
#9 vB5_Route_Page->__construct(array[len:13], array[len:1], 'searchJSON[len:60]', '') in /core/vb5/route.php(838)
#10 vB5_Route::selectBestRoute('search', 'searchJSON[len:60]', '', array[len:2]) in /core/vb/api/route.php(180)
#11 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#14 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#15 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #9

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		6	Using index condition

Time Before: 1611487258.1826
Time After: 1611487258.1827
Time Taken: 0.00014615058898926
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(30)
#9 vB5_Route_Page->getPage() in /core/vb5/route/page.php(49)
#10 vB5_Route_Page->__construct(array[len:13], array[len:1], 'searchJSON[len:60]', '') in /core/vb5/route.php(838)
#11 vB5_Route::selectBestRoute('search', 'searchJSON[len:60]', '', array[len:2]) in /core/vb/api/route.php(180)
#12 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_types.types')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1833
Time After: 1611487258.1835
Time Taken: 0.00019407272338867
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1], true, true) in /core/vb/types.php(181)
#9 vB_Types->loadTypes() in /core/vb/types.php(149)
#10 vB_Types->__construct() in /core/vb/types.php(165)
#11 vB_Types::instance() in /core/vb/library/node.php(40)
#12 vB_Library_Node->__construct() in /core/vb/library.php(41)
#13 vB_Library::instance('node') in /core/vb/usercontext.php(516)
#14 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 1, false, false) in /core/vb/usercontext.php(807)
#15 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#16 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #11

SELECT * FROM channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	channel	ALL	guid				73	Using where

Time Before: 1611487258.1847
Time After: 1611487258.185
Time Taken: 0.00025296211242676
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:518]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in /core/vb/library/content/channel.php(893)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/api/content/channel.php(134)
#8 vB_Api_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/library/node.php(2137)
#9 vB_Library_Node->fetchVMChannel() in /core/vb/usercontext.php(516)
#10 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 1, false, false) in /core/vb/usercontext.php(807)
#11 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#12 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #12

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1851
Time After: 1611487258.1853
Time Taken: 0.00015091896057129
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3580)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/library/node.php(825)
#10 vB_Library_Node->getNodeBare(1) in /core/vb/library/node.php(900)
#11 vB_Library_Node->getNode(1) in /core/vb/usercontext.php(517)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 1, false, false) in /core/vb/usercontext.php(807)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #13

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1854
Time After: 1611487258.1856
Time Taken: 0.00027585029602051
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1], true, false) in /core/vb/permissioncontext.php(804)
#9 vB_PermissionContext->loadChannelPermissions(1) in /core/vb/permissioncontext.php(692)
#10 vB_PermissionContext->getChannelPerm(1, 'forumpermissions', 'canview', 1) in /core/vb/usercontext.php(591)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 1, false, false) in /core/vb/usercontext.php(807)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#13 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #14

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.1859
Time After: 1611487258.1862
Time Taken: 0.00032615661621094
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(971)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(862)
#10 vB5_Route::getRouteByIdent('24') in /core/vb5/route.php(996)
#11 vB5_Route::getClassName('24', array[len:13]) in /core/vb5/route.php(1011)
#12 vB5_Route::getRoute('24', array[len:0], array[len:2]) in /core/vb5/route/page.php(166)
#13 vB5_Route_Page->getCanonicalRoute() in /core/vb5/route.php(475)
#14 vB5_Route->getCanonicalUrl() in /core/vb/api/route.php(260)
#15 vB_Api_Route->getRoute('search', 'searchJSON[len:60]') in /core/vb/api/wrapper.php(129)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(198)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #15

SELECT * FROM style
 WHERE `styleid` = 42 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	style	const	PRIMARY	PRIMARY	2	const	1

Time Before: 1611487258.1876
Time After: 1611487258.1881
Time Taken: 0.00047802925109863
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:51]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in /core/vb/library/style.php(586)
#8 vB_Library_Style->fetchStyleByID('42') in /core/vb/api/style.php(47)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in /core/vb/api/wrapper.php(129)
#10 vB_Api_Wrapper->__call('fetchStyleVars', array[len:1]) in /includes/api/interface/collapsed.php(198)
#11 Api_Interface_Collapsed->callApi('style', 'fetchStyleVars', array[len:1]) in /includes/vb5/template/stylevar.php(146)
#12 vB5_Template_Stylevar->fetchStyleVars() in /includes/vb5/template/stylevar.php(38)
#13 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#14 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#15 vB5_Frontend_Application::init('config.php') in /index.php(63)

SQL Query #16

SELECT * FROM template
 WHERE `templateid` IN (1716)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.1902
Time After: 1611487258.1904
Time Taken: 0.00023388862609863
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('preheader', 42) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('preheader', 42) in /core/vb/api/wrapper.php(129)
#10 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(198)
#11 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#12 vB5_Template_Cache->fetchTemplate('preheader') in /includes/vb5/template/cache.php(184)
#13 vB5_Template_Cache->getTemplate('preheader') in /includes/vb5/template.php(316)
#14 vB5_Template->render() in /includes/vb5/applicationabstract.php(542)
#15 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(155)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #17

UPDATE session SET `wol`='a:3:{s:6:\"action\";s:16:\"searching_forums\";s:6:\"params\";a:0:{}s:6:\"nodeid\";i:0;}',`pagekey`='',`location`='' 
 WHERE (`sessionhash` = '5b19cbd4cec09bf22339a7605c804bce') 
/**session**/

Time Before: 1611487258.1958
Time After: 1611487258.2056
Time Taken: 0.0097048282623291
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(551)
#1 vB_Database->query_write('') in /core/vb/db/query/update.php(115)
#2 vB_dB_Query_Update->doUpdates() in /core/vb/db/query/update.php(101)
#3 vB_dB_Query_Update->execSQL() in /core/vb/db/assertor.php(296)
#4 vB_dB_Assertor->assertQuery('session', array[len:5]) in /core/vb/api/wol.php(65)
#5 vB_Api_Wol->register('searching_forums', array[len:0]) in /core/vb/api/wrapper.php(129)
#6 vB_Api_Wrapper->__call('register', array[len:2]) in /includes/api/interface/collapsed.php(198)
#7 Api_Interface_Collapsed->callApi('wol', 'register', array[len:2]) in /includes/vb5/frontend/controller/search.php(171)
#8 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#9 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #18

				SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title as templatetitle
				FROM page AS page
				LEFT JOIN pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
				LEFT JOIN screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
				WHERE page.pageid = 12
			
/**fetch_page_pagetemplate_screenlayout**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	pagetemplate	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	screenlayout	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2061
Time After: 1611487258.2063
Time Taken: 0.00023102760314941
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:429]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('fetch_page[len:36]', array[len:1]) in /core/vb/api/page.php(77)
#6 vB_Api_Page->fetchPageById(12, array[len:2]) in /core/vb/api/wrapper.php(129)
#7 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(198)
#8 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/search.php(201)
#9 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#10 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #19

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('advanced_search','search_results') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		6	Using index condition

Time Before: 1611487258.2066
Time After: 1611487258.2067
Time Taken: 0.0001521110534668
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:135]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:2]) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/frontend/controller/search.php(208)
#11 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#12 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #20

SELECT * FROM template
 WHERE `templateid` IN (1554)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.207
Time After: 1611487258.2072
Time Taken: 0.00017189979553223
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('screenlayo[len:25]', 42) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('screenlayo[len:25]', 42) in /core/vb/api/wrapper.php(129)
#10 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(198)
#11 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#12 vB5_Template_Cache->fetchTemplate('screenlayo[len:25]') in /includes/vb5/template/cache.php(184)
#13 vB5_Template_Cache->getTemplate('screenlayo[len:25]') in /includes/vb5/template.php(316)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #21

SELECT * FROM widgetinstance
 WHERE `pagetemplateid` = 15 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widgetinstance	ref	pagetemplateid	pagetemplateid	4	const	3	Using where; Using filesort

Time Before: 1611487258.2074
Time After: 1611487258.2076
Time Taken: 0.00014710426330566
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:122]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:1], array[len:3]) in /core/vb/api/widget.php(932)
#7 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '') in /core/vb/api/widget.php(1070)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(506)
#11 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '15', '') in /includes/vb5/template.php(324) : eval()'d code(3)
#12 eval() in /includes/vb5/template.php(324)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#14 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#15 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #22

				SELECT widgetdefinition.*, widget.template
				FROM widgetdefinition AS widgetdefinition
				JOIN widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(14,29,52)
			
/**getWidgetdefinition**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widget	range	PRIMARY	PRIMARY	4		3	Using where
1	SIMPLE	widgetdefinition	ref	widgetid	widgetid	4	db00099133.widget.widgetid	2

Time Before: 1611487258.2077
Time After: 1611487258.2078
Time Taken: 0.0001528263092041
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:247]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('getWidgetdefinition', array[len:1]) in /core/vb/api/widget.php(955)
#6 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '') in /core/vb/api/widget.php(1070)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/wrapper.php(129)
#8 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2]) in /includes/api/interface/collapsed.php(198)
#9 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(506)
#10 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '15', '') in /includes/vb5/template.php(324) : eval()'d code(3)
#11 eval() in /includes/vb5/template.php(324)
#12 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#13 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#14 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #23

SELECT * FROM widgetinstance
 WHERE `widgetinstanceid` IN (53,51,52)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widgetinstance	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1611487258.2079
Time After: 1611487258.208
Time Taken: 0.0001368522644043
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:69]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:2], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('widgetinstance', array[len:2], false, 'widgetinstanceid') in /core/vb/api/widget.php(882)
#8 vB_Api_Widget->fetchWidgetInstances(array[len:3]) in /core/vb/api/widget.php(984)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '') in /core/vb/api/widget.php(1070)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(506)
#13 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '15', '') in /includes/vb5/template.php(324) : eval()'d code(3)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #24

SELECT * FROM widget
 WHERE `widgetid` IN (0,14,29,52)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	widget	range	PRIMARY	PRIMARY	4		4	Using where

Time Before: 1611487258.2081
Time After: 1611487258.2083
Time Taken: 0.00018095970153809
Memory Before: 2097152
Memory After: 2097152
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('widget', array[len:1], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('widget', array[len:1], false, 'widgetid') in /core/vb/api/widget.php(987)
#8 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '') in /core/vb/api/widget.php(1070)
#9 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/wrapper.php(129)
#10 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2]) in /includes/api/interface/collapsed.php(198)
#11 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(506)
#12 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '15', '') in /includes/vb5/template.php(324) : eval()'d code(3)
#13 eval() in /includes/vb5/template.php(324)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #25

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('widget_search_results_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle','generic_widgetcat') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		18	Using index condition

Time Before: 1611487258.2083
Time After: 1611487258.2092
Time Taken: 0.00082087516784668
Memory Before: 2097152
Memory After: 4194304
Memory Used: 2097152

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:260]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:6]) in /core/vb/api/widget.php(828)
#9 vB_Api_Widget->addWidgetTitles(array[len:3]) in /core/vb/api/widget.php(1032)
#10 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '') in /core/vb/api/widget.php(1070)
#11 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(506)
#14 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '15', '') in /includes/vb5/template.php(324) : eval()'d code(3)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #26

SELECT * FROM template
 WHERE `templateid` IN (1749,1565,684)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1611487258.2095
Time After: 1611487258.2099
Time Taken: 0.00037217140197754
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:3], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:3], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:3]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#14 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#15 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #27

SELECT * FROM site
 WHERE `siteid` = 1  
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	site	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2124
Time After: 1611487258.2126
Time Taken: 0.00022196769714355
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:49]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:site', array[len:3], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('vBForum:site', array[len:3]) in /core/vb/library/site.php(223)
#8 vB_Library_Site->getNavbar('header', '1', '/search?se[len:68]', '0', '0') in /core/vb/library/site.php(185)
#9 vB_Library_Site->loadHeaderNavbar('1', '/search?se[len:68]', '0', '0') in /core/vb/api/site.php(89)
#10 vB_Api_Site->loadHeaderNavbar('1', '/search?se[len:68]', '0', '0') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('loadHeaderNavbar', array[len:4]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('site', 'loadHeaderNavbar', array[len:4], false, true) in /includes/vb5/template/runtime.php(506)
#13 vB5_Template_Runtime::parseData('site', 'loadHeaderNavbar', '1', '/search?se[len:68]', '0', '0') in /includes/vb5/template.php(324) : eval()'d code(517)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #28

SELECT * FROM template
 WHERE `templateid` IN (1714,1765,1789,1767,1568,1784,1786)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		7	Using where

Time Before: 1611487258.2135
Time After: 1611487258.2137
Time Taken: 0.00026202201843262
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:9], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:9], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:9]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:10401]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #29

SELECT * FROM termine WHERE userid="0" AND rememberFrom <= "1611487258" AND end >= rememberFrom AND rememberFrom > 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	termine	ALL					4	Using where

Time Before: 1611487258.2146
Time After: 1611487258.2148
Time Taken: 0.00021791458129883
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/api/termine.php(53)
#2 vB_Api_Termine->getTermineForRemember(0) in /core/vb/api/wrapper.php(129)
#3 vB_Api_Wrapper->__call('getTermine[len:21]', array[len:1]) in /includes/api/interface/collapsed.php(198)
#4 Api_Interface_Collapsed->callApi('termine', 'getTermine[len:21]', array[len:1], false, true) in /includes/vb5/template/runtime.php(506)
#5 vB5_Template_Runtime::parseData('termine', 'getTermine[len:21]', 0) in /includes/vb5/template.php(324) : eval()'d code(1)
#6 eval() in /includes/vb5/template.php(324)
#7 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#8 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:10401]') in /includes/vb5/template.php(346)
#9 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#10 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#11 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#12 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#13 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #30

SELECT * FROM template
 WHERE `templateid` IN (1785,1649)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1611487258.2151
Time After: 1611487258.2153
Time Taken: 0.00021910667419434
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:2], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:2], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1994]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #31

SELECT * FROM template
 WHERE `templateid` IN (1686)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2158
Time After: 1611487258.2161
Time Taken: 0.0002439022064209
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\t[len:835]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1994]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #32

SELECT * FROM template
 WHERE `templateid` IN (1664)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2169
Time After: 1611487258.2172
Time Taken: 0.00031399726867676
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #33

SELECT * FROM tag
 WHERE `tagtext` IN ('rechtschreibung')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tag	const	tagtext	tagtext	102	const	1

Time Before: 1611487258.2184
Time After: 1611487258.219
Time Taken: 0.00063180923461914
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:tag', array[len:2]) in /core/vb/search/criteria.php(314)
#7 vB_Search_Criteria->add_tag_filter(array[len:1]) in /core/vb/api/search.php(1128)
#8 vB_Api_Search->json2criteria(array[len:2]) in /core/vb/api/search.php(103)
#9 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#10 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #34

INSERT INTO tagsearch (`tagid`,`dateline`) VALUES (81,1611487258)
/**tagsearch**/

Time Before: 1611487258.2194
Time After: 1611487258.2267
Time Taken: 0.0072929859161377
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(551)
#1 vB_Database->query_write('') in /core/vb/db/query/multipleinsert.php(114)
#2 vB_dB_Query_MultipleInsert->doMultipleInserts() in /core/vb/db/query/multipleinsert.php(89)
#3 vB_dB_Query_MultipleInsert->execSQL() in /core/vb/db/assertor.php(296)
#4 vB_dB_Assertor->assertQuery('vBDBSearch:tagsearch', array[len:3]) in /core/vb/api/tags.php(773)
#5 vB_Api_Tags->logSearchTags(array[len:1]) in /core/vb/api/search.php(1130)
#6 vB_Api_Search->json2criteria(array[len:2]) in /core/vb/api/search.php(103)
#7 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#8 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#11 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#12 eval() in /includes/vb5/template.php(324)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #35

SELECT * FROM searchlog
 WHERE `searchhash` IN ('be265a380ce23d0f37bf5990ec41a206') AND `userid` = 0  AND `dateline` >= 1611487198  AND `sortby` = 'created'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	ref	search,userfloodcheck,dateline	search	56	const,const,const,const	5	Using index condition; Using where; Using filesort

Time Before: 1611487258.2268
Time After: 1611487258.2282
Time Taken: 0.0013680458068848
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:209]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:1], array[len:2]) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('vBDbSearch:searchlog', array[len:1], array[len:2], 'searchhash') in /core/vb/search/core.php(341)
#8 vB_Search_Core->getFromCache(vB_Search_Criteria, array[len:2]) in /core/vb/api/search.php(115)
#9 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#10 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #36

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_readperms')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2283
Time After: 1611487258.2287
Time Taken: 0.0003809928894043
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:57]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/permissioncontext.php(559)
#9 vB_PermissionContext->getForumAccess(1) in /core/vb/usercontext.php(1047)
#10 vB_UserContext->getReadChannels() in /core/vb/api/search.php(138)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #37

SELECT COUNT(*) AS count FROM moderator
 WHERE `userid` = 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	moderator	ref	userid_nodeid	userid_nodeid	4	const	1	Using index

Time Before: 1611487258.2295
Time After: 1611487258.2297
Time Taken: 0.0002138614654541
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT COU[len:60]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:moderator', array[len:2], false) in /core/vb/db/assertor.php(591)
#7 vB_dB_Assertor->getField('vBForum:moderator', array[len:2]) in /core/vb/usercontext.php(1246)
#8 vB_UserContext->isForumModerator() in /core/vb/usercontext.php(1259)
#9 vB_UserContext->isModerator() in /core/vb/usercontext.php(1109)
#10 vB_UserContext->getReadChannels() in /core/vb/api/search.php(138)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #38

SELECT * FROM cache
 WHERE `cacheid` IN ('getSearchResults_2258798b87bd80b7440f0d2d08f2c22f')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2299
Time After: 1611487258.2306
Time Taken: 0.00073003768920898
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:94]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/search/core.php(48)
#9 vB_Search_Core->getTwoPassResults(vB_Search_Criteria) in /core/packages/vbdbsearch/core.php(231)
#10 vBDBSearch_Core->getResults(vB_Search_Criteria) in /core/vb/api/search.php(159)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #39

			SELECT node.nodeid, starter.parentid, starter.userid
			FROM node as node
			JOIN tagnode AS tagnode81 ON
					(node.nodeid = tagnode81.nodeid)  LEFT JOIN node AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter)

			WHERE tagnode81.tagid = 81 AND 
				node.inlist = 1 AND 
				node.contenttypeid <> 27 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,152652,161826,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR ( starter.parentid in (14,2,12177,20621,30444,44723,110,16433,31824,126) AND starter.userid = 0 )
 OR starter.parentid = 10 AND node.userid IN (0)))


			ORDER BY node.created DESC,node.nodeid ASC
			LIMIT 1000
			
/**getSearchResults**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tagnode81	ref	PRIMARY,id_type_user,id_type_node,id_type_tag	id_type_tag	4	const	4	Using index; Using temporary; Using filesort
1	SIMPLE	node	eq_ref	PRIMARY,node_user,node_ppreview,node_showapproved,node_ctypid_userid_dispo_idx,nodeid,contenttypeid_parentid,node_inlist	PRIMARY	4	db00099133.tagnode81.nodeid	1	Using where
1	SIMPLE	starter	eq_ref	PRIMARY,nodeid	PRIMARY	4	func	1	Using where

Time Before: 1611487258.231
Time After: 1611487258.2329
Time Taken: 0.0018219947814941
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\tSELECT[len:870]') in /core/packages/vbdbsearch/db/mysql/querydefs.php(494)
#4 vBDBSearch_dB_MYSQL_QueryDefs->getSearchResults(array[len:3], vB_Database_MySQLi, false, false) in /core/vb/db/query/method.php(175)
#5 vB_dB_Query_Method->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBDBSearch[len:27]', array[len:3], false) in /core/vb/db/assertor.php(686)
#7 vB_dB_Assertor->getColumn('vBDBSearch[len:27]', 'nodeid', array[len:3]) in /core/packages/vbdbsearch/core.php(247)
#8 vBDBSearch_Core->getResults(vB_Search_Criteria) in /core/vb/api/search.php(159)
#9 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(127)
#10 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #40

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,results,results_count)
			VALUES
				('1','0','18.204.42.98','be265a380ce23d0f37bf5990ec41a206','created','desc','0.003230094909668','1611487258','0','{\"tag\":[\"rechtschreibung\"],\"ignore_protected\":1}','33978','1')

Time Before: 1611487258.233
Time After: 1611487258.2434
Time Taken: 0.010380983352661
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(551)
#1 vB_Database->query_write('') in /core/packages/vbdbsearch/db/mysql/querydefs.php(663)
#2 vBDBSearch_dB_MYSQL_QueryDefs->cacheResults(array[len:1], vB_Database_MySQLi, false, false) in /core/vb/db/query/method.php(175)
#3 vB_dB_Query_Method->execSQL() in /core/vb/db/assertor.php(296)
#4 vB_dB_Assertor->assertQuery('vBDBSearch[len:23]', array[len:2]) in /core/vb/search/core.php(283)
#5 vB_Search_Core->cacheResults(array[len:1], vB_Search_Criteria, 0.003230094909668, '1') in /core/vb/api/search.php(163)
#6 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(127)
#7 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(215)
#8 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#11 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#12 eval() in /includes/vb5/template.php(324)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #41

SELECT * FROM searchlog
 WHERE `searchlogid` = 34932734 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	searchlog	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2437
Time After: 1611487258.2443
Time Taken: 0.00066208839416504
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:3], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('vBDbSearch:searchlog', array[len:3]) in /core/vb/search/core.php(415)
#8 vB_Search_Core->getCache(34932734) in /core/vb/api/search.php(275)
#9 vB_Api_Search->getMoreNodes(34932734, '15', NULL) in /core/vb/api/search.php(391)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #42

SELECT * FROM cache
 WHERE `cacheid` IN ('node_33978_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2448
Time After: 1611487258.2455
Time Taken: 0.00072693824768066
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3580)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/library/node.php(1250)
#10 vB_Library_Node->cleanNodeList(array[len:1], true) in /core/vb/library/node.php(1358)
#11 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#12 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #43

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_UserWPerms_2_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Time Before: 1611487258.2458
Time After: 1611487258.246
Time Taken: 0.00022506713867188
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/user.php(827)
#9 vB_Library_User->preloadUserInfo(array[len:1]) in /core/vb/library/node.php(1866)
#10 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#11 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#12 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #44

SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid IN (2)
					/** fetchUserinfo **/

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	userfield	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	usertextfield	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2461
Time After: 1611487258.2466
Time Taken: 0.00049781799316406
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT \n\t\t[len:449]') in /core/vb/db/mysql/querydefs.php(3882)
#4 vB_dB_MYSQL_QueryDefs->fetchUserinfo(array[len:4], vB_Database_MySQLi, false, false) in /core/vb/db/query/method.php(175)
#5 vB_dB_Query_Method->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('fetchUserinfo', array[len:2]) in /core/vb/library/user.php(872)
#7 vB_Library_User->preloadUserInfo(array[len:1]) in /core/vb/library/node.php(1866)
#8 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#9 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #45

SELECT * FROM cache
 WHERE `cacheid` IN ('node_33796_lvl1data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2469
Time After: 1611487258.2475
Time Taken: 0.00060200691223145
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3580)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/library/node.php(966)
#10 vB_Library_Node->getNodes(array[len:1]) in /core/vb/library/node.php(1869)
#11 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#12 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#13 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#14 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#16 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#17 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#18 eval() in /includes/vb5/template.php(324)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #46

SELECT * FROM routenew
 WHERE `routeid` IN (375)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.2477
Time After: 1611487258.2482
Time Taken: 0.00051689147949219
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:49]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(952)
#7 vB5_Route::preloadRoutes(array[len:1]) in /core/vb/library/node.php(1877)
#8 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#9 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #47

SELECT * FROM cache
 WHERE `cacheid` IN ('vBAtchmnts_33978')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2485
Time After: 1611487258.249
Time Taken: 0.00049996376037598
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:61]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/node.php(1704)
#9 vB_Library_Node->fetchNodeAttachments(array[len:1]) in /core/vb/library/node.php(1888)
#10 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#11 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#12 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#13 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(324)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #48

				SELECT cl.parent AS nodeid, count(a.nodeid) AS count
				FROM closure AS cl
				INNER JOIN attach AS a ON (a.nodeid = cl.child)
				WHERE cl.parent in (33978)
				GROUP BY cl.parent
			
/**getDescendantAttachCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	ref	closure_uniq,parent_2,child	closure_uniq	4	const	6	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	db00099133.cl.child	1	Using index

Time Before: 1611487258.2492
Time After: 1611487258.2501
Time Taken: 0.00086283683776855
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:221]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('vBForum:ge[len:32]', array[len:1], false) in /core/vb/db/assertor.php(643)
#6 vB_dB_Assertor->getRows('vBForum:ge[len:32]', array[len:1]) in /core/vb/library/node.php(1934)
#7 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#8 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#9 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#10 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #49

				SELECT cl.parent AS nodeid, count(child.nodeid) AS count
				FROM closure AS cl
				INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
				WHERE cl.parent in (33978) AND child.contenttypeid = 16
				GROUP BY cl.parent
			
/**getDescendantPhotoCount**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	ref	closure_uniq,parent_2,child	closure_uniq	4	const	6	Using index
1	SIMPLE	child	ref	node_ctypid_userid_dispo_idx,nodeid	nodeid	6	db00099133.cl.child,const	1	Using index

Time Before: 1611487258.2503
Time After: 1611487258.2513
Time Taken: 0.0010180473327637
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:308]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('vBForum:ge[len:31]', array[len:2], false) in /core/vb/db/assertor.php(643)
#6 vB_dB_Assertor->getRows('vBForum:ge[len:31]', array[len:2]) in /core/vb/library/node.php(1941)
#7 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#8 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#9 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#10 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(324)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #50

SELECT * FROM closure
 WHERE `child` IN (33978) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	child	child	4	const	5	Using where

Time Before: 1611487258.2515
Time After: 1611487258.2523
Time Taken: 0.00078916549682617
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in /core/vb/library/node.php(3354)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in /core/vb/library/node.php(1948)
#8 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#9 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #51

SELECT * FROM cache
 WHERE `cacheid` IN ('node_33978_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2525
Time After: 1611487258.2533
Time Taken: 0.00079894065856934
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3580)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in /core/vb/library/content.php(2337)
#10 vB_Library_Content->getRawContent(array[len:1]) in /core/vb/library/content.php(2306)
#11 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#12 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#13 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#14 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#15 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#16 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#17 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#18 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#19 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#20 eval() in /includes/vb5/template.php(324)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#26 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#27 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #52

SELECT * FROM closure
 WHERE `child` IN (33796) 
 ORDER BY `child` ASC, `depth` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	closure	ref	child	child	4	const	4	Using where

Time Before: 1611487258.2546
Time After: 1611487258.2555
Time Taken: 0.00096917152404785
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in /core/vb/library/node.php(3354)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in /core/vb/library/node.php(930)
#8 vB_Library_Node->getNodeParents(33796) in /core/vb/library/node.php(905)
#9 vB_Library_Node->getNode(33796, true, false) in /core/vb/api/socialgroup.php(68)
#10 vB_Api_SocialGroup->isSGNode(33796) in /core/vb/usercontext.php(1688)
#11 vB_UserContext->getCanCreate('33796') in /core/vb/usercontext.php(2171)
#12 vB_UserContext->fetchPermsForChannels(array[len:1]) in /core/vb/library/content.php(2871)
#13 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/library/content/text.php(858)
#14 vB_Library_Content_Text->assembleContent(array[len:1]) in /core/vb/library/content.php(2308)
#15 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#16 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#17 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#18 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#19 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#20 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#21 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#22 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#23 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#24 eval() in /includes/vb5/template.php(324)
#25 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#26 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#27 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#28 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#29 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#30 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#31 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #53

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		51	Using index condition

Time Before: 1611487258.2574
Time After: 1611487258.2578
Time Taken: 0.00036907196044922
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:476]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:17]) in /core/vb/library/content/infraction.php(67)
#9 vB_Library_Content_Infraction->__construct() in /core/vb/library.php(41)
#10 vB_Library::instance('content_infraction') in /core/vb/library/content.php(3105)
#11 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/library/content/text.php(858)
#12 vB_Library_Content_Text->assembleContent(array[len:1]) in /core/vb/library/content.php(2308)
#13 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#14 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#15 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#16 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#17 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#18 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#19 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#20 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#21 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#22 eval() in /includes/vb5/template.php(324)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#25 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#26 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#27 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#28 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#29 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #54

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2583
Time After: 1611487258.2587
Time Taken: 0.00033712387084961
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/usercontext.php(140)
#9 vB_UserContext->reloadUserPerms() in /core/vb/usercontext.php(113)
#10 vB_UserContext->__construct(2, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7]) in /core/vb/vb.php(902)
#11 vB::getUserContext(2) in /core/vb/library/content.php(3245)
#12 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/library/content/text.php(858)
#13 vB_Library_Content_Text->assembleContent(array[len:1]) in /core/vb/library/content.php(2308)
#14 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#15 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#16 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#17 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#18 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#19 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#20 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#21 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#22 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#23 eval() in /includes/vb5/template.php(324)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#26 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#27 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#28 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#29 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#30 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #55

SELECT * FROM cache
 WHERE `cacheid` IN ('vBUserRep_2')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.259
Time After: 1611487258.2593
Time Taken: 0.00028300285339355
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:56]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3287)
#9 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/library/content/text.php(858)
#10 vB_Library_Content_Text->assembleContent(array[len:1]) in /core/vb/library/content.php(2308)
#11 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#12 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#13 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#14 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#15 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#16 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#17 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#18 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#19 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#20 eval() in /includes/vb5/template.php(324)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#26 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#27 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #56

				SELECT cl.*, node.nodeid, node.userid, node.parentid, node.routeid, node.title, node.urlident,
					node.contenttypeid, node.publishdate, node.unpublishdate, node.showpublished, node.starter,
					node.lastcontentid
				FROM closure AS cl
					INNER JOIN node AS node ON node.nodeid = cl.parent
				WHERE cl.child IN (33978)
				ORDER by cl.child ASC, cl.depth ASC
/**getParents**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cl	ref	closure_uniq,parent_2,child	child	4	const	5	Using where
1	SIMPLE	node	eq_ref	PRIMARY,nodeid	PRIMARY	4	db00099133.cl.parent	1

Time Before: 1611487258.2597
Time After: 1611487258.2611
Time Taken: 0.0013818740844727
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:386]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('vBForum:getParents', array[len:1], false) in /core/vb/db/assertor.php(643)
#6 vB_dB_Assertor->getRows('vBForum:getParents', array[len:1]) in /core/vb/library/node.php(3755)
#7 vB_Library_Node->getParents(array[len:1]) in /core/vb/library/content/text.php(873)
#8 vB_Library_Content_Text->assembleContent(array[len:1]) in /core/vb/library/content.php(2308)
#9 vB_Library_Content->getFullContent(array[len:1], false) in /core/vb/library/content/text.php(82)
#10 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#11 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#12 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#13 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#14 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#16 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#17 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#18 eval() in /includes/vb5/template.php(324)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #57

SELECT * FROM cache
 WHERE `cacheid` IN ('vBProfileFields')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.2615
Time After: 1611487258.2618
Time Taken: 0.00033712387084961
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content/text.php(132)
#9 vB_Library_Content_Text->addContentInfo(array[len:1]) in /core/vb/library/content/text.php(84)
#10 vB_Library_Content_Text->getFullContent(array[len:1]) in /core/vb/library/node.php(1957)
#11 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#12 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#13 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#14 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#16 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#17 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#18 eval() in /includes/vb5/template.php(324)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #58

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM user as user
				LEFT JOIN customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (2,664)
/**fetchAvatarsForUsers**/

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	user	range	PRIMARY	PRIMARY	4		2	Using where
1	SIMPLE	customavatar	eq_ref	PRIMARY	PRIMARY	4	db00099133.user.userid	1
1	SIMPLE	avatar	eq_ref	PRIMARY	PRIMARY	2	db00099133.user.avatarid	1	Using where

Time Before: 1611487258.2626
Time After: 1611487258.2637
Time Taken: 0.0011589527130127
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT use[len:446]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(296)
#5 vB_dB_Assertor->assertQuery('vbForum:fe[len:28]', array[len:1]) in /core/vb/api/user.php(1505)
#6 vB_Api_User->fetchAvatars(array[len:2], true, array[len:0]) in /core/vb/library/node.php(1440)
#7 vB_Library_Node->addOptionalContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(2030)
#8 vB_Library_Node->addFullContentInfo(array[len:1], array[len:2]) in /core/vb/library/node.php(1359)
#9 vB_Library_Node->getFullContentforNodes(array[len:1], array[len:2]) in /core/vb/api/search.php(393)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(220)
#11 vB_Api_Search->getInitialResults('{"tag":"re[len:48]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(129)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(198)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(523)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(324) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(324)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #59

SELECT * FROM template
 WHERE `templateid` IN (1592,1776,1774,1460)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		4	Using where

Time Before: 1611487258.2654
Time After: 1611487258.2696
Time Taken: 0.0041840076446533
Memory Before: 4194304
Memory After: 4194304
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:68]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:4], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:4], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:4]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\r\n\r\n\r\n\r\n[len:11381]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #60

SELECT * FROM template
 WHERE `templateid` IN (1283,1282)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		2	Using where

Time Before: 1611487258.292
Time After: 1611487258.2925
Time Taken: 0.00049781799316406
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:2], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:2], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\r\n[len:4521]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\r\n\r\n\r\n\r\n[len:11381]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #61

SELECT * FROM template
 WHERE `templateid` IN (1763)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.295
Time After: 1611487258.2953
Time Taken: 0.00034093856811523
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('\r\n<div cla[len:1367]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\r\n[len:4521]') in /includes/vb5/template.php(346)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\r\n\r\n\r\n\r\n[len:11381]') in /includes/vb5/template.php(346)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:11578]') in /includes/vb5/template.php(346)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#22 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#23 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #62

SELECT * FROM template
 WHERE `templateid` IN (1739,1764,1779,616,1787,1790)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	range	PRIMARY	PRIMARY	4		6	Using where

Time Before: 1611487258.2994
Time After: 1611487258.2999
Time Taken: 0.00050592422485352
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:77]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:6], 42, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:6], 42) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#11 vB5_Template_Cache->fetchTemplate(array[len:6]) in /includes/vb5/template/cache.php(110)
#12 vB5_Template_Cache->replacePlaceholders('</div>\r\n\t<[len:13404]') in /includes/vb5/template.php(346)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(346)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #63

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('login_or_sign_up','you_can_also_login_as','logo','powered_by_vbulletin_title','search','filter_search','sections','navbar_home','navbar_articles','navbar_absprachenmediation','navbar_themenfilter','navbar_aktive_themen','navbar_regeln','navbar_faq','home','search_in_titles_only','notice_1_html','announcement','no_announcement','collapse','expand','page_title','x_result_in_y_seconds','keywords','members','started_posts_only','tags','enter_tags','you_can_also_choose_from_popular_tags_link','sort_by','relevance','title','date_started_post','date_last_update','replies','likes','order','descending','ascending','x_started_a_topic_y_with_prefix','in_x_channel','see_less','see_more','go_to_post','last_edited_by_x_on_y_at_z','posts_lower','likes_lower','previous','next','navbar_contact_us','navbar_impressum','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','cancel') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		177	Using index condition

Time Before: 1611487258.3034
Time After: 1611487258.3157
Time Taken: 0.012331962585449
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:1013]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:61]) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(168)
#11 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(89)
#12 vB5_Template_Phrase->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(448)
#13 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #64

SELECT * FROM routenew
 WHERE `routeid` IN ('advanced_search','search','376','profile','375','register','help')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	routenew	range	PRIMARY	PRIMARY	4		3	Using where

Time Before: 1611487258.3213
Time After: 1611487258.3222
Time Taken: 0.00086307525634766
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:112]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(952)
#7 vB5_Route::preloadRoutes(array[len:7]) in /core/vb/api/route.php(467)
#8 vB_Api_Route->preloadRoutes(array[len:7]) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('preloadRoutes', array[len:1]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('route', 'preloadRoutes', array[len:1]) in /includes/vb5/template/url.php(210)
#11 vB5_Template_Url->finalBuildUrls(array[len:9]) in /includes/vb5/template/url.php(316)
#12 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(452)
#13 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #65

SELECT * FROM page
 WHERE `pageid` = 2 
 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	page	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.3233
Time After: 1611487258.3236
Time Taken: 0.0003211498260498
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(618)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(26)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(49)
#9 vB5_Route_Page->__construct(array[len:13], array[len:0], '', '') in /core/vb5/route.php(1268)
#10 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:5]) in /core/vb5/route.php(1233)
#11 vB5_Route::buildUrls(array[len:9]) in /core/vb/api/route.php(434)
#12 vB_Api_Route->getUrls(array[len:9]) in /core/vb/api/wrapper.php(129)
#13 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(198)
#14 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(264)
#15 vB5_Template_Url->finalBuildUrls(array[len:9]) in /includes/vb5/template/url.php(316)
#16 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(452)
#17 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#19 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#20 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #66

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82efb6117736147_title','page_4ecbdac82efb6117736147_metadesc') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		6	Using index condition

Time Before: 1611487258.3238
Time After: 1611487258.324
Time Taken: 0.00023007392883301
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(30)
#9 vB5_Route_Page->getPage() in /core/vb5/route/page.php(49)
#10 vB5_Route_Page->__construct(array[len:13], array[len:0], '', '') in /core/vb5/route.php(1268)
#11 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:5]) in /core/vb5/route.php(1233)
#12 vB5_Route::buildUrls(array[len:9]) in /core/vb/api/route.php(434)
#13 vB_Api_Route->getUrls(array[len:9]) in /core/vb/api/wrapper.php(129)
#14 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(198)
#15 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(264)
#16 vB5_Template_Url->finalBuildUrls(array[len:9]) in /includes/vb5/template/url.php(316)
#17 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(452)
#18 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#20 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#21 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #67

SELECT * FROM cache
 WHERE `cacheid` IN ('node_33796_lvl3data')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.3244
Time After: 1611487258.325
Time Taken: 0.00060391426086426
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3580)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in /core/vb/library/content.php(2337)
#10 vB_Library_Content->getRawContent(array[len:1]) in /core/vb/library/content.php(2278)
#11 vB_Library_Content->getBareContent(array[len:1]) in /core/vb/library/content/channel.php(369)
#12 vB_Library_Content_Channel->getBareContent(33796) in /core/vb5/route/conversation.php(29)
#13 vB5_Route_Conversation->__construct(array[len:13], array[len:14], '', '') in /core/vb5/route.php(1268)
#14 vB5_Route::bulkFetchUrls('vB5_Route_[len:22]', array[len:1]) in /core/vb5/route.php(1233)
#15 vB5_Route::buildUrls(array[len:9]) in /core/vb/api/route.php(434)
#16 vB_Api_Route->getUrls(array[len:9]) in /core/vb/api/wrapper.php(129)
#17 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(198)
#18 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(264)
#19 vB5_Template_Url->finalBuildUrls(array[len:9]) in /includes/vb5/template/url.php(316)
#20 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(452)
#21 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #68

SELECT * FROM cache
 WHERE `cacheid` IN ('vbnodetext_pre_33978_42_0:09f14d73cd828b8c283774e754116338')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cache	const	PRIMARY	PRIMARY	66	const	1

Time Before: 1611487258.3277
Time After: 1611487258.3284
Time Taken: 0.00075101852416992
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:103]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read(array[len:1]) in /includes/vb5/template/nodetext.php(502)
#9 vB5_Template_NodeText->fetchNodeText() in /includes/vb5/template/nodetext.php(416)
#10 vB5_Template_NodeText->replacePlaceholders('\r\n\t\t<meta [len:90725]') in /includes/vb5/template.php(455)
#11 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#12 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#13 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#14 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #69

SELECT * FROM template
 WHERE `templateid` IN (1702)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	template	const	PRIMARY	PRIMARY	4	const	1

Time Before: 1611487258.332
Time After: 1611487258.3324
Time Taken: 0.0003969669342041
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:53]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('debug_info', 42) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('debug_info', 42) in /core/vb/api/wrapper.php(129)
#10 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(198)
#11 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#12 vB5_Template_Cache->fetchTemplate('debug_info') in /includes/vb5/template/cache.php(184)
#13 vB5_Template_Cache->getTemplate('debug_info') in /includes/vb5/template.php(502)
#14 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

SQL Query #70

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (2,0,-1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	phrase	range	name_lang_type,languageid	name_lang_type	254		75	Using index condition

Time Before: 1611487258.3373
Time After: 1611487258.3377
Time Taken: 0.00034999847412109
Memory Before: 6291456
Memory After: 6291456
Memory Used: 0

#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(566)
#1 vB_Database->query_read('') in /core/vb/db/result.php(125)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(62)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:500]', false) in /core/vb/db/query/select.php(118)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(96)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(296)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(643)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(231)
#8 vB_Api_Phrase->fetch(array[len:25]) in /core/vb/api/wrapper.php(129)
#9 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(198)
#10 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(168)
#11 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(89)
#12 vB5_Template_Phrase->replacePlaceholders('<div id="d[len:50016]') in /includes/vb5/template.php(512)
#13 vB5_Template->renderDelayed('\r\n\t\t<meta [len:90725]', false) in /includes/vb5/template.php(350)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(308)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(328)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(89)

vBulletin - Explain SQL Queries (70)

SQL Query #1

SQL Query #2

SQL Query #3

SQL Query #4

SQL Query #5

SQL Query #6

SQL Query #7

SQL Query #8

SQL Query #9

SQL Query #10

SQL Query #11

SQL Query #12

SQL Query #13

SQL Query #14

SQL Query #15

SQL Query #16

SQL Query #17

SQL Query #18

SQL Query #19

SQL Query #20

SQL Query #21

SQL Query #22

SQL Query #23

SQL Query #24

SQL Query #25

SQL Query #26

SQL Query #27

SQL Query #28

SQL Query #29

SQL Query #30

SQL Query #31

SQL Query #32

SQL Query #33

SQL Query #34

SQL Query #35

SQL Query #36

SQL Query #37

SQL Query #38

SQL Query #39

SQL Query #40

SQL Query #41

SQL Query #42

SQL Query #43

SQL Query #44

SQL Query #45

SQL Query #46

SQL Query #47

SQL Query #48

SQL Query #49

SQL Query #50

SQL Query #51

SQL Query #52

SQL Query #53

SQL Query #54

SQL Query #55

SQL Query #56

SQL Query #57

SQL Query #58

SQL Query #59

SQL Query #60

SQL Query #61

SQL Query #62

SQL Query #63

SQL Query #64

SQL Query #65

SQL Query #66

SQL Query #67

SQL Query #68

SQL Query #69

SQL Query #70

70 Queries Run : Total SQL time was 0.075581 seconds , Total PHP time was 0.092106 seconds , Overall time was 0.167687 seconds.