vBulletin - Explain SQL Queries (64)

Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)

SQL Query #1

SET @@sql_mode = ''
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(504)
#1 vB_Database->query_write('SET @@sql_mode = ''') in /core/vb/database.php(428)
#2 vB_Database->force_sql_mode('') in /core/vb/db/mysql/assertor.php(116)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:8]) in /core/vb/db/mysql/assertor.php(39)
#4 vB_dB_MYSQL_Assertor->__construct(array[len:8]) in /core/vb/db/assertor.php(131)
#5 vB_dB_Assertor::init(array[len:8]) in /core/vb/vb.php(598)
#6 vB::getDbAssertor() in /core/vb/vb.php(482)
#7 vB::get_registry() in /core/vb/api.php(449)
#8 vB_Api->__construct() in /core/vb/api/options.php(27)
#9 vB_Api_Options->__construct() in /core/vb/api.php(156)
#10 vB_Api::instance('options') in /includes/api/interface/collapsed.php(176)
#11 Api_Interface_Collapsed->callApi('options', 'fetch') in /includes/vb5/template/options.php(63)
#12 vB5_Template_Options->fetchOptions() in /includes/vb5/template/options.php(55)
#13 vB5_Template_Options->getOptions() in /includes/vb5/template/options.php(25)
#14 vB5_Template_Options::instance() in /includes/vb5/cookie.php(136)
#15 vB5_Cookie::loadConfig() in /includes/vb5/cookie.php(52)
#16 vB5_Cookie::get('languageid', 1) in /includes/api/interface/collapsed.php(34)
#17 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#18 Api_InterfaceAbstract::instance() 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(84)

SQL Query #2

SELECT * FROM vb_datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','vBUgChannelAccess','vBUgChannelPermissionsFrom','vBChannelTypes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_datastoreALLPRIMARY   40Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:296]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:296]', 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(277)
#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:1]) in /core/vb/datastore.php(177)
#9 vB_Datastore->getValue('options') in /core/vb/vb.php(489)
#10 vB::get_registry() in /core/vb/api.php(449)
#11 vB_Api->__construct() in /core/vb/api/options.php(27)
#12 vB_Api_Options->__construct() in /core/vb/api.php(156)
#13 vB_Api::instance('options') in /includes/api/interface/collapsed.php(176)
#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(34)
#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(84)

SQL Query #3

SELECT * FROM vb_session
 WHERE `userid` = 0 AND `host` = '3.95.139.100' AND `idhash` = 'b35bea338547e9aba68a20321d61f9ae' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_sessionrefuser_activity,guest_lookupguest_lookup51const,const,const1Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:132]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:132]', 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(277)
#6 vB_dB_Assertor->assertQuery('session', array[len:4], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('session', array[len:3]) in /core/vb/session.php(210)
#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:7], '', 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:7], '', 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:7], '', 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(66)
#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(84)

SQL Query #4

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('d2ff5b1b76fa412e454b18eada8938c9') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:80]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:80]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('d2ff5b1b76[len:32]') in /core/vb/language.php(73)
#9 vB_Language::getPhraseCache('d2ff5b1b76[len:32]') in /core/vb/language.php(49)
#10 vB_Language::getPhraseInfo(1) 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(746)
#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(66)
#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(84)

SQL Query #5

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vB_CommonRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:63]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vB_CommonRoutes') in /core/vb5/route.php(1398)
#9 vB5_Route::fetchCommonRoutes() in /core/vb/api/route.php(113)
#10 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#11 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2])
#13 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#16 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#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(84)

SQL Query #6

SELECT * FROM vb_routenew
 WHERE `prefix` IN ('member/820928-larryornaw','member') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_routenewrangeprefixprefix202 4Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:83]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb/api/route.php(148)
#7 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#8 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#9 vB_Api_Wrapper->__call('getRoute', array[len:2])
#10 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#11 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#12 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#13 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#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(84)

SQL Query #7

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vB_UserPerms0') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:61]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vB_UserPerms0') 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:8]) in /core/vb/vb.php(703)
#11 vB::getUserContext('0') in /core/vb/library/user.php(35)
#12 vB_Library_User->isBanned('0') in /core/vb/library/user.php(69)
#13 vB_Library_User->fetchBannedInfo(false) in /core/vb/api/route.php(173)
#14 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#15 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2])
#17 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#18 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#20 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#21 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#23 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#24 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #8

SELECT 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM vb_user AS user
				LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) WHERE user.userid IN (820928)
					/** fetchUserinfo **/
					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT \n\t\t[len:463]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT \n\t\t[len:463]') in /core/vb/db/mysql/querydefs.php(3946)
#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(277)
#6 vB_dB_Assertor->assertQuery('fetchUserinfo', array[len:4], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('fetchUserinfo', array[len:3]) in /core/vb/user.php(502)
#8 vB_User::fetchUserinfo(820928) in /core/vb5/route/profile.php(73)
#9 vB5_Route_Profile->initRoute(array[len:13], array[len:6], 'explain=1', '') in /core/vb5/route.php(108)
#10 vB5_Route->__construct(array[len:13], array[len:6], 'explain=1', '') in /core/vb5/route/profile.php(34)
#11 vB5_Route_Profile->__construct(array[len:13], array[len:6], 'explain=1', '') in /core/vb5/route.php(838)
#12 vB5_Route::selectBestRoute('member/820[len:24]', 'explain=1', '', array[len:3]) in /core/vb/api/route.php(180)
#13 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2])
#16 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#19 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#20 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) 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(84)

SQL Query #9

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vb_types.types') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:62]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(749)
#8 vB_Cache->read('vb_types.types', 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(39)
#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(805)
#15 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#16 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2])
#19 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#20 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#21 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#22 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#23 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#24 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#25 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#26 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #10

SELECT * FROM vb_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') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_channelALLguid   20Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:521]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:521]', 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(277)
#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]')
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetchChannelByGUID', array[len:1]) in /core/vb/library/node.php(2106)
#11 vB_Api_Logwrapper->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/library/node.php(2106)
#12 vB_Library_Node->fetchVMChannel() in /core/vb/usercontext.php(516)
#13 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 1, false, false) in /core/vb/usercontext.php(805)
#14 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#15 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#16 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2])
#18 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#20 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#21 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#23 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#24 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#25 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #11

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('node_1_lvl1data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:63]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#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(3380)
#9 vB_Library_Content::fetchFromCache(1, 1) in /core/vb/library/node.php(795)
#10 vB_Library_Node->getNodeBare(1) in /core/vb/library/node.php(870)
#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(805)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#14 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#15 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2])
#17 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#18 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#20 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#21 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#23 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#24 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #12

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('channelperms_1') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:62]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(749)
#8 vB_Cache->read('channelperms_1', true, false) in /core/vb/permissioncontext.php(793)
#9 vB_PermissionContext->loadChannelPermissions(1) in /core/vb/permissioncontext.php(681)
#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(805)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 1) in /core/vb/api/route.php(228)
#13 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2])
#16 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#19 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#20 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) 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(84)

SQL Query #13

SELECT * FROM vb_page
 WHERE `pageid` = 8 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_pageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:51]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('page', array[len:1]) in /core/vb5/route/profile.php(238)
#8 vB5_Route_Profile->getCanonicalRoute() in /core/vb5/route.php(475)
#9 vB5_Route->getCanonicalUrl() in /core/vb/api/route.php(260)
#10 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#11 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2])
#13 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#16 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#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(84)

SQL Query #14

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vB_NamedRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:62]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vB_NamedRoutes') in /core/vb5/route.php(971)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(862)
#10 vB5_Route::getRouteByIdent('17') in /core/vb5/route.php(996)
#11 vB5_Route::getClassName('17', array[len:13]) in /core/vb5/route.php(1011)
#12 vB5_Route::getRoute('17', array[len:4], array[len:1]) in /core/vb5/route/profile.php(241)
#13 vB5_Route_Profile->getCanonicalRoute() in /core/vb5/route.php(475)
#14 vB5_Route->getCanonicalUrl() in /core/vb/api/route.php(260)
#15 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#16 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2])
#18 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#20 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#21 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#23 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#24 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#25 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #15

SELECT  administrator.*, 
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpicnew.userid AS sigpic, sigpicnew.filedataid AS sigpicfiledataid, sigpicfiledata.dateline AS sigpicdateline, sigpicfiledata.width AS sigpicwidth, sigpicfiledata.height AS sigpicheight
				FROM vb_user AS user
				LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_administrator AS administrator ON (administrator.userid = user.userid) LEFT JOIN vb_sigpicnew AS sigpicnew ON (user.userid = sigpicnew.userid) LEFT JOIN vb_filedata AS sigpicfiledata ON (sigpicnew.filedataid = sigpicfiledata.filedataid) WHERE user.userid IN (820928)
					/** fetchUserinfo **/
					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEavatarconstPRIMARYPRIMARY2const0unique row not found
1SIMPLEcustomavatarconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEcustomprofilepicconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEadministratorconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEsigpicnewconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEsigpicfiledataconstPRIMARY   1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT  ad[len:1614]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT  ad[len:1614]') in /core/vb/db/mysql/querydefs.php(3946)
#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(277)
#6 vB_dB_Assertor->assertQuery('fetchUserinfo', array[len:4], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('fetchUserinfo', array[len:3]) in /core/vb/user.php(502)
#8 vB_User::fetchUserinfo(820928, array[len:4]) in /core/vb/api/user.php(94)
#9 vB_Api_User->fetchProfileInfo(820928)
#10 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#11 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#12 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#13 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#14 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#15 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#16 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2])
#18 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#20 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#21 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#23 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#24 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#25 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #16

SELECT * FROM vb_userfield
 WHERE `userid` = 820928 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_userfieldconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:61]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:userfield', array[len:2], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('vBForum:userfield', array[len:1]) in /core/vb/api/user.php(125)
#8 vB_Api_User->fetchProfileInfo(820928)
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#11 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#12 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#13 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#14 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#15 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2])
#17 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#18 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#20 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#21 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#23 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#24 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #17

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vB_UserPerms820928') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:66]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:66]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vB_UserPerms820928') in /core/vb/usercontext.php(140)
#9 vB_UserContext->reloadUserPerms() in /core/vb/usercontext.php(113)
#10 vB_UserContext->__construct(820928, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:8]) in /core/vb/vb.php(703)
#11 vB::getUserContext(820928) in /core/vb/api/user.php(164)
#12 vB_Api_User->fetchProfileInfo(820928)
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#15 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#16 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#17 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#18 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2])
#21 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#23 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#24 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#25 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#26 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#27 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#28 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #18

					### Channels ###
					SELECT follow.title AS title, follow.nodeid AS keyval, 'node' AS sourcetable, IF(follow.lastcontent = 0, follow.lastupdate, follow.lastcontent) AS lastactivity,
					follow.totalcount AS activity, type.class AS type,
					(follow.nodeoptions & 512) AS noUnsubscribe
					FROM vb_node AS follow
					INNER JOIN vb_contenttype AS type ON type.contenttypeid = follow.contenttypeid 

					INNER JOIN vb_subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 820928
 UNION  ALL 

					### Users ###
					SELECT follow.username AS title, follow.userid AS keyval, 'user' AS sourcetable, IFNULL(follow.lastpost, follow.joindate) AS lastactivity,
					follow.posts as activity, 'Member' AS type,
					0 AS noUnsubscribe
					FROM vb_user AS follow
					INNER JOIN vb_userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 820928
					WHERE ul.type = 'follow' AND ul.friend = 'yes' 
 ORDER BY title ASC LIMIT 100
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\t\t### [len:962]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\t\t### [len:962]') in /core/packages/vbforum/db/mysql/querydefs.php(6112)
#4 vBForum_dB_MYSQL_QueryDefs->getUserFollowing(array[len:6], 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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:ge[len:24]', array[len:6], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('vBForum:ge[len:24]', array[len:6]) in /core/vb/api/follow.php(374)
#8 vB_Api_Follow->getFollowing(820928)
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('getFollowing', array[len:1]) in /core/vb/api/user.php(174)
#11 vB_Api_Logwrapper->getFollowing(820928) in /core/vb/api/user.php(174)
#12 vB_Api_User->fetchProfileInfo(820928)
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#15 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#16 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#17 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#18 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2])
#21 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#23 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#24 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#25 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#26 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#27 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#28 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #19

SELECT COUNT(userfollowing.keyval) AS total
			FROM
			((### All Content ###
					SELECT follow.nodeid AS keyval
					FROM vb_node AS follow
					INNER JOIN vb_subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 820928) UNION ALL (
					### Users ###
					SELECT follow.userid AS keyval
					FROM vb_user AS follow
					INNER JOIN vb_userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 820928
					WHERE ul.type = 'follow' AND ul.friend = 'yes')
) AS userfollowing
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARY       Select tables optimized away
2DERIVEDsdrefuserdiscussion,discussioniduserdiscussion4 1Using index
2DERIVEDfolloweq_refPRIMARY,nodeidPRIMARY4vbulletin.sd.discussionid1Using index
3UNIONulrefPRIMARY,relationid,useridPRIMARY4 1Using where
3UNIONfolloweq_refPRIMARYPRIMARY4vbulletin.ul.relationid1Using index
 UNION RESULTALL      
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT COU[len:502]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT COU[len:502]') in /core/packages/vbforum/db/mysql/querydefs.php(6222)
#4 vBForum_dB_MYSQL_QueryDefs->getUserFollowingCount(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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:ge[len:29]', array[len:3], false) in /core/vb/db/assertor.php(578)
#7 vB_dB_Assertor->getField('vBForum:ge[len:29]', array[len:3]) in /core/vb/api/follow.php(378)
#8 vB_Api_Follow->getFollowing(820928)
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('getFollowing', array[len:1]) in /core/vb/api/user.php(174)
#11 vB_Api_Logwrapper->getFollowing(820928) in /core/vb/api/user.php(174)
#12 vB_Api_User->fetchProfileInfo(820928)
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#15 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#16 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#17 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#18 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2])
#21 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#23 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#24 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#25 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#26 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#27 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#28 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #20

SELECT u.userid, u.username AS username, u.usergroupid AS usergroupid, IFNULL(u.lastactivity, u.joindate) as lastactivity,
				IFNULL((SELECT userid FROM vb_userlist AS ul2 WHERE ul2.userid = 820928 AND ul2.relationid = u.userid AND ul2.type = 'follow' AND ul2.friend = 'yes'), 0) as isFollowing,
				IFNULL((SELECT userid FROM vb_userlist AS ul2 WHERE ul2.userid = 820928 AND ul2.relationid = u.userid AND ul2.type = 'follow' AND ul2.friend = 'pending'), 0) as isPending
FROM vb_user AS u
				INNER JOIN vb_userlist AS ul ON (u.userid = ul.userid AND ul.relationid = 820928)

			WHERE ul.type = 'follow' AND ul.friend = 'yes'
ORDER BY username ASC
LIMIT 0, 100
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYulrefPRIMARY,relationid,useridrelationid6const,const,const1Using where; Using index; Using temporary; Using filesort
1PRIMARYueq_refPRIMARYPRIMARY4vbulletin.ul.userid1 
3DEPENDENT SUBQUERYul2eq_refPRIMARY,relationid,useridPRIMARY9const,vbulletin.u.userid,const1Using where
2DEPENDENT SUBQUERYul2eq_refPRIMARY,relationid,useridPRIMARY9const,vbulletin.u.userid,const1Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT u.u[len:662]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT u.u[len:662]') in /core/packages/vbforum/db/mysql/querydefs.php(6294)
#4 vBForum_dB_MYSQL_QueryDefs->getUserFollowers(array[len:5], 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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:ge[len:24]', array[len:5], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('vBForum:ge[len:24]', array[len:5]) in /core/vb/api/follow.php(224)
#8 vB_Api_Follow->getFollowers(820928)
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('getFollowers', array[len:1]) in /core/vb/api/user.php(177)
#11 vB_Api_Logwrapper->getFollowers(820928) in /core/vb/api/user.php(177)
#12 vB_Api_User->fetchProfileInfo(820928)
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#15 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#16 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#17 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#18 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#19 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2])
#21 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#22 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#23 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#24 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#25 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#26 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#27 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#28 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #21

SELECT * FROM vb_userlist
 WHERE `friend` = 'yes' AND `relationid` = 820928 AND `type` = 'follow' 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_userlistrefrelationidrelationid6const,const,const1Using where; Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:98]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:98]', 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(277)
#6 vB_dB_Assertor->assertQuery('userlist', array[len:4], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('userlist', array[len:4]) in /core/vb/api/follow.php(136)
#8 vB_Api_Follow->getUserList(820928, 'followed', 'follow') in /core/vb/api/follow.php(233)
#9 vB_Api_Follow->getFollowers(820928)
#10 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#11 vB_Api_Logwrapper->__call('getFollowers', array[len:1]) in /core/vb/api/user.php(177)
#12 vB_Api_Logwrapper->getFollowers(820928) in /core/vb/api/user.php(177)
#13 vB_Api_User->fetchProfileInfo(820928)
#14 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#16 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#17 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#18 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#19 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#20 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#21 vB_Api_Wrapper->__call('getRoute', array[len:2])
#22 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#23 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#24 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#25 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#26 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#27 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#28 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#29 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #22

SELECT count(referrerid) AS referrals
						FROM vb_user
						WHERE referrerid = 820928
/**getReferralsCount**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_userrefreferreridreferrerid4const1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT cou[len:112]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT cou[len:112]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('vBForum:ge[len:25]', array[len:2], false) in /core/vb/db/assertor.php(605)
#6 vB_dB_Assertor->getRow('vBForum:ge[len:25]', array[len:1]) in /core/vb/api/user.php(188)
#7 vB_Api_User->fetchProfileInfo(820928)
#8 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#9 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#10 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#11 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#12 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#13 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2])
#16 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#17 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#19 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#20 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) 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(84)

SQL Query #23

SELECT * FROM vb_node
 WHERE `setfor` = 820928 
 ORDER BY `publishdate` DESC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_noderefnode_setfor_pubdt_idxnode_setfor_pubdt_idx4const1Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:76]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:76]', 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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:node', array[len:2], array[len:2]) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('vBForum:node', array[len:2], array[len:2]) in /core/vb/api/user.php(208)
#8 vB_Api_User->fetchProfileInfo(820928)
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetchProfileInfo', array[len:1]) in /core/vb5/route/profile.php(98)
#11 vB_Api_Logwrapper->fetchProfileInfo(820928) in /core/vb5/route/profile.php(98)
#12 vB5_Route_Profile->setBreadcrumbs() in /core/vb5/route.php(385)
#13 vB5_Route->getBreadcrumbs() in /core/vb/api/route.php(306)
#14 vB_Api_Route->getRoute('member/820[len:24]', 'explain=1')
#15 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2])
#17 vB_Api_Wrapper->getRoute('member/820[len:24]', 'explain=1')
#18 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('getRoute', array[len:2])
#20 vB_Api_Logwrapper->getRoute('member/820[len:24]', 'explain=1')
#21 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(95)
#23 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#24 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #24

SELECT * FROM vb_style
 WHERE `styleid` = 1 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_styleconstPRIMARYPRIMARY2const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:53]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('style', array[len:1]) in /core/vb/library/style.php(525)
#8 vB_Library_Style->fetchStyleByID('1') in /core/vb/api/style.php(47)
#9 vB_Api_Style->fetchStyleVars(array[len:1])
#10 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetchStyleVars', array[len:1])
#12 vB_Api_Wrapper->fetchStyleVars(array[len:1])
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchStyleVars', array[len:1])
#15 vB_Api_Logwrapper->fetchStyleVars(array[len:1])
#16 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('style', 'fetchStyleVars', array[len:1]) in /includes/vb5/template/stylevar.php(139)
#18 vB5_Template_Stylevar->fetchStyleVars() in /includes/vb5/template/stylevar.php(38)
#19 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#20 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#21 vB5_Frontend_Application::init('config.php') in /index.php(84)

SQL Query #25

SELECT * FROM vb_template
 WHERE `templateid` IN (478) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('preheader', 1) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('preheader', 1)
#10 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetch', array[len:2])
#12 vB_Api_Wrapper->fetch('preheader', 1)
#13 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetch', array[len:2])
#15 vB_Api_Logwrapper->fetch('preheader', 1)
#16 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#18 vB5_Template_Cache->fetchTemplate('preheader') in /includes/vb5/template/cache.php(184)
#19 vB5_Template_Cache->getTemplate('preheader') in /includes/vb5/template.php(282)
#20 vB5_Template->render() in /includes/vb5/applicationabstract.php(473)
#21 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(48)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #26

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vbPre_profile17.8.820928') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:72]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:72]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vbPre_prof[len:24]') in /core/vb/api/page.php(946)
#9 vB_Api_Page->preload('profile17.8.820928')
#10 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('preload', array[len:1])
#12 vB_Api_Wrapper->preload('profile17.8.820928')
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('preload', array[len:1])
#15 vB_Api_Logwrapper->preload('profile17.8.820928')
#16 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('page', 'preload', array[len:1]) in /includes/vb5/frontend/controller/page.php(62)
#18 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#19 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #27

UPDATE vb_session SET `wol`='a:3:{s:6:\"action\";s:20:\"viewing_user_profile\";s:6:\"params\";a:2:{i:0;s:10:\"LarryOrnaw\";i:1;s:71:\"http://vbulletin.premiumdownload.net/member/820928-larryornaw?explain=1\";}s:6:\"nodeid\";i:0;}',`pagekey`='profile17.8.820928',`location`='/member/820928-larryornaw?explain=1' 
 WHERE (`sessionhash` = '0388fe49d73d4695aec452eaa8cc53bc') 
/**session**/
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(504)
#1 vB_Database->query_write('UPDATE vb_[len:386]') 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(277)
#4 vB_dB_Assertor->assertQuery('session', array[len:5]) in /core/vb/api/wol.php(65)
#5 vB_Api_Wol->register('viewing_user_profile', array[len:2], 'profile17.8.820928', '/member/82[len:35]', 0)
#6 call_user_func_array(array[len:2], array[len:5]) in /core/vb/api/wrapper.php(121)
#7 vB_Api_Wrapper->__call('register', array[len:5])
#8 vB_Api_Wrapper->register('viewing_user_profile', array[len:2], 'profile17.8.820928', '/member/82[len:35]', 0)
#9 call_user_func_array(array[len:2], array[len:5]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('register', array[len:5])
#11 vB_Api_Logwrapper->register('viewing_user_profile', array[len:2], 'profile17.8.820928', '/member/82[len:35]', 0)
#12 call_user_func_array(array[len:2], array[len:5]) in /includes/api/interface/collapsed.php(189)
#13 Api_Interface_Collapsed->callApi('wol', 'register', array[len:5]) in /includes/vb5/frontend/controller/page.php(75)
#14 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#15 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #28

				SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title as templatetitle
				FROM vb_page AS page
				LEFT JOIN vb_pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
				LEFT JOIN vb_screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
				WHERE page.pageid = 8
			
/**fetch_page_pagetemplate_screenlayout**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\tSELEC[len:437]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:437]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('fetch_page[len:36]', array[len:1]) in /core/vb/api/page.php(77)
#6 vB_Api_Page->fetchPageById(8, array[len:4])
#7 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#8 vB_Api_Wrapper->__call('fetchPageById', array[len:2])
#9 vB_Api_Wrapper->fetchPageById(8, array[len:4])
#10 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#11 vB_Api_Logwrapper->__call('fetchPageById', array[len:2])
#12 vB_Api_Logwrapper->fetchPageById(8, array[len:4])
#13 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#14 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(90)
#15 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#16 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #29

SELECT * FROM vb_phrase
 WHERE `varname` IN ('page_4ecbdac82f0bb437025811_title','page_4ecbdac82f0bb437025811_metadesc') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 6Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:150]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:150]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:2])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb/api/page.php(84)
#11 vB_Api_Logwrapper->fetch(array[len:2]) in /core/vb/api/page.php(84)
#12 vB_Api_Page->fetchPageById(8, array[len:4])
#13 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#14 vB_Api_Wrapper->__call('fetchPageById', array[len:2])
#15 vB_Api_Wrapper->fetchPageById(8, array[len:4])
#16 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#17 vB_Api_Logwrapper->__call('fetchPageById', array[len:2])
#18 vB_Api_Logwrapper->fetchPageById(8, array[len:4])
#19 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#20 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(90)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #30

SELECT * FROM vb_template
 WHERE `templateid` IN (332) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('screenlayo[len:32]', 1) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('screenlayo[len:32]', 1)
#10 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetch', array[len:2])
#12 vB_Api_Wrapper->fetch('screenlayo[len:32]', 1)
#13 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetch', array[len:2])
#15 vB_Api_Logwrapper->fetch('screenlayo[len:32]', 1)
#16 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#18 vB5_Template_Cache->fetchTemplate('screenlayo[len:32]') in /includes/vb5/template/cache.php(184)
#19 vB5_Template_Cache->getTemplate('screenlayo[len:32]') in /includes/vb5/template.php(282)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #31

SELECT * FROM vb_widgetinstance
 WHERE `pagetemplateid` = 11 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_widgetinstancerefpagetemplateidpagetemplateid4const4Using where; Using filesort
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:125]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:125]', 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(277)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:1], array[len:3]) in /core/vb/api/widget.php(932)
#7 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('11', -1, '') in /core/vb/api/widget.php(1070)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2])
#11 vB_Api_Wrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchHiera[len:48]', array[len:2])
#14 vB_Api_Logwrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(501)
#17 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '11', '') in /includes/vb5/template.php(290) : eval()'d code(3)
#18 eval() in /includes/vb5/template.php(290)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#20 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#21 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #32

				SELECT widgetdefinition.*, widget.template
				FROM vb_widgetdefinition AS widgetdefinition
				JOIN vb_widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(21,19,29,52)
			
/**getWidgetdefinition**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetrangePRIMARYPRIMARY4 4Using where
1SIMPLEwidgetdefinitionrefwidgetidwidgetid4vbulletin.widget.widgetid2 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\tSELEC[len:256]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:256]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('getWidgetdefinition', array[len:1]) in /core/vb/api/widget.php(955)
#6 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('11', -1, '') in /core/vb/api/widget.php(1070)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#8 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#9 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2])
#10 vB_Api_Wrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#11 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#12 vB_Api_Logwrapper->__call('fetchHiera[len:48]', array[len:2])
#13 vB_Api_Logwrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#14 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#15 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(501)
#16 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '11', '') in /includes/vb5/template.php(290) : eval()'d code(3)
#17 eval() in /includes/vb5/template.php(290)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#19 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#20 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #33

SELECT * FROM vb_widgetinstance
 WHERE `widgetinstanceid` IN (40,41,38,39) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_widgetinstancerangePRIMARYPRIMARY4 4Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:75]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:75]', 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(277)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:2], false) in /core/vb/db/assertor.php(630)
#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:4]) in /core/vb/api/widget.php(984)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('11', -1, '') in /core/vb/api/widget.php(1070)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#11 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#12 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2])
#13 vB_Api_Wrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#14 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('fetchHiera[len:48]', array[len:2])
#16 vB_Api_Logwrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#17 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#18 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(501)
#19 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '11', '') in /includes/vb5/template.php(290) : eval()'d code(3)
#20 eval() in /includes/vb5/template.php(290)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #34

SELECT * FROM vb_widget
 WHERE `widgetid` IN (0,21,19,29,52) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_widgetrangePRIMARYPRIMARY4 5Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:61]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('widget', array[len:1], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('widget', array[len:1], false, 'widgetid') in /core/vb/api/widget.php(987)
#8 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('11', -1, '') in /core/vb/api/widget.php(1070)
#9 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#10 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2])
#12 vB_Api_Wrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#13 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchHiera[len:48]', array[len:2])
#15 vB_Api_Logwrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#16 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(501)
#18 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '11', '') in /includes/vb5/template.php(290) : eval()'d code(3)
#19 eval() in /includes/vb5/template.php(290)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #35

SELECT * FROM vb_phrase
 WHERE `varname` IN ('widget_profile_sidebar_widgettitle','system_widgetcat','widget_profile_widgettitle','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle','generic_widgetcat') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 21Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:265]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:265]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:7])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb/api/widget.php(828)
#11 vB_Api_Logwrapper->fetch(array[len:7]) in /core/vb/api/widget.php(828)
#12 vB_Api_Widget->addWidgetTitles(array[len:4]) in /core/vb/api/widget.php(1032)
#13 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('11', -1, '') in /core/vb/api/widget.php(1070)
#14 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#15 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('fetchHiera[len:48]', array[len:2])
#17 vB_Api_Wrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#18 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('fetchHiera[len:48]', array[len:2])
#20 vB_Api_Logwrapper->fetchHierarchicalWidgetInstancesByPageTemplateId('11', '')
#21 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('widget', 'fetchHiera[len:48]', array[len:2], false, true) in /includes/vb5/template/runtime.php(501)
#23 vB5_Template_Runtime::parseData('widget', 'fetchHiera[len:48]', '11', '') in /includes/vb5/template.php(290) : eval()'d code(3)
#24 eval() in /includes/vb5/template.php(290)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#26 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#27 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #36

SELECT * FROM vb_template
 WHERE `templateid` IN (477,342,476) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:63]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', 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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:3], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:3], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:3], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:3], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:3]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#20 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#21 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #37

SELECT * FROM vb_site
 WHERE `siteid` = 1  
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_siteconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:52]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:52]', 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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:site', array[len:3], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('vBForum:site', array[len:2]) in /core/vb/library/site.php(223)
#8 vB_Library_Site->getNavbar('header', '1', '/member/82[len:35]', '0', '0') in /core/vb/library/site.php(185)
#9 vB_Library_Site->loadHeaderNavbar('1', '/member/82[len:35]', '0', '0') in /core/vb/api/site.php(89)
#10 vB_Api_Site->loadHeaderNavbar('1', '/member/82[len:35]', '0', '0')
#11 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#12 vB_Api_Wrapper->__call('loadHeaderNavbar', array[len:4])
#13 vB_Api_Wrapper->loadHeaderNavbar('1', '/member/82[len:35]', '0', '0')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('loadHeaderNavbar', array[len:4])
#16 vB_Api_Logwrapper->loadHeaderNavbar('1', '/member/82[len:35]', '0', '0')
#17 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#18 Api_Interface_Collapsed->callApi('site', 'loadHeaderNavbar', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#19 vB5_Template_Runtime::parseData('site', 'loadHeaderNavbar', '1', '/member/82[len:35]', '0', '0') in /includes/vb5/template.php(290) : eval()'d code(483)
#20 eval() in /includes/vb5/template.php(290)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#24 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#25 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #38

SELECT * FROM vb_template
 WHERE `templateid` IN (466,345,460) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:63]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', 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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:5], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:5], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:5], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:5], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:5]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:9726]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #39

SELECT * FROM vb_template
 WHERE `templateid` IN (390,424) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 2Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:59]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:2], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:2], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:2], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:2], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1990]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #40

SELECT * FROM vb_phrase
 WHERE `varname` IN ('show_module_at_breakpoints','desktop_size','small_size','xsmall_size') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 12Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:146]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:146]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:4])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb/api/widget.php(2139)
#11 vB_Api_Logwrapper->fetch(array[len:4]) in /core/vb/api/widget.php(2139)
#12 vB_Api_Widget->_getWidgetDefinition('29') in /core/vb/api/widget.php(439)
#13 vB_Api_Widget->fetchDefaultConfig(38) in /core/vb/api/widget.php(162)
#14 vB_Api_Widget->fetchConfig('38')
#15 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('fetchConfig', array[len:1])
#17 vB_Api_Wrapper->fetchConfig('38')
#18 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('fetchConfig', array[len:1])
#20 vB_Api_Logwrapper->fetchConfig('38')
#21 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('widget', 'fetchConfig', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#23 vB5_Template_Runtime::parseData('widget', 'fetchConfig', '38') in /includes/vb5/template.php(290) : eval()'d code(3)
#24 eval() in /includes/vb5/template.php(290)
#25 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#26 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1990]') in /includes/vb5/template.php(312)
#27 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#28 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#29 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#30 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#31 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #41

SELECT * FROM vb_template
 WHERE `templateid` IN (468) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:1], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:1], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\t[len:835]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1990]') in /includes/vb5/template.php(312)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#24 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#25 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #42

SELECT * FROM vb_phrase
 WHERE `varname` IN ('hide_title') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:88]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:88]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:5])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb/api/widget.php(2139)
#11 vB_Api_Logwrapper->fetch(array[len:5]) in /core/vb/api/widget.php(2139)
#12 vB_Api_Widget->_getWidgetDefinition('52') in /core/vb/api/widget.php(439)
#13 vB_Api_Widget->fetchDefaultConfig(39) in /core/vb/api/widget.php(162)
#14 vB_Api_Widget->fetchConfig('39')
#15 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#16 vB_Api_Wrapper->__call('fetchConfig', array[len:1])
#17 vB_Api_Wrapper->fetchConfig('39')
#18 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#19 vB_Api_Logwrapper->__call('fetchConfig', array[len:1])
#20 vB_Api_Logwrapper->fetchConfig('39')
#21 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#22 Api_Interface_Collapsed->callApi('widget', 'fetchConfig', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#23 vB5_Template_Runtime::parseData('widget', 'fetchConfig', '39') in /includes/vb5/template.php(290) : eval()'d code(3)
#24 eval() in /includes/vb5/template.php(290)
#25 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#26 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1990]') in /includes/vb5/template.php(312)
#27 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#28 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#29 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#30 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#31 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #43

SELECT * FROM vb_template
 WHERE `templateid` IN (432) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:1], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:1], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #44

				SELECT pf.profilefieldcategoryid, pfc.location, pf.*
				FROM vb_profilefield AS pf
				LEFT JOIN vb_profilefieldcategory AS pfc ON(pfc.profilefieldcategoryid = pf.profilefieldcategoryid)
				WHERE pf.form = 0 AND hidden IN (0,1)
				ORDER BY pfc.displayorder, pf.displayorder
			
/**fetchCustomProfileFields**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpfALL    4Using where; Using temporary; Using filesort
1SIMPLEpfceq_refPRIMARYPRIMARY2vbulletin.pf.profilefieldcategoryid1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\tSELEC[len:316]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:316]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('vBForum:fe[len:32]', array[len:1], false) in /core/vb/db/assertor.php(630)
#6 vB_dB_Assertor->getRows('vBForum:fe[len:32]', array[len:1]) in /core/vb/api/user.php(446)
#7 vB_Api_User->fetchUserSettings(820928)
#8 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#9 vB_Api_Wrapper->__call('fetchUserSettings', array[len:1])
#10 vB_Api_Wrapper->fetchUserSettings(820928)
#11 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#12 vB_Api_Logwrapper->__call('fetchUserSettings', array[len:1])
#13 vB_Api_Logwrapper->fetchUserSettings(820928)
#14 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#15 Api_Interface_Collapsed->callApi('user', 'fetchUserSettings', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#16 vB5_Template_Runtime::parseData('user', 'fetchUserSettings', 820928) in /includes/vb5/template.php(290) : eval()'d code(41)
#17 eval() in /includes/vb5/template.php(290)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#23 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#24 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #45

SELECT * FROM vb_user
 WHERE `userid` IN ('') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:46]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:46]', 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(277)
#6 vB_dB_Assertor->assertQuery('user', array[len:2], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('user', array[len:2]) in /core/vb/api/user.php(5318)
#8 vB_Api_User->fetchUserIgnorelist(array[len:1]) in /core/vb/api/user.php(672)
#9 vB_Api_User->fetchUserSettings(820928)
#10 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetchUserSettings', array[len:1])
#12 vB_Api_Wrapper->fetchUserSettings(820928)
#13 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetchUserSettings', array[len:1])
#15 vB_Api_Logwrapper->fetchUserSettings(820928)
#16 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('user', 'fetchUserSettings', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#18 vB5_Template_Runtime::parseData('user', 'fetchUserSettings', 820928) in /includes/vb5/template.php(290) : eval()'d code(41)
#19 eval() in /includes/vb5/template.php(290)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#24 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#25 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#26 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #46

SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
					customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
			FROM vb_user as user
				LEFT JOIN vb_customavatar AS customavatar ON customavatar.userid = user.userid
				LEFT JOIN vb_avatar AS avatar ON avatar.avatarid = user.avatarid
			WHERE user.userid IN (820928)
/**fetchAvatarsForUsers**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEcustomavatarconstPRIMARYPRIMARY4const0unique row not found
1SIMPLEavatarconstPRIMARYPRIMARY2const0unique row not found
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT use[len:456]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT use[len:456]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('vbForum:fe[len:28]', array[len:1]) in /core/vb/api/user.php(1499)
#6 vB_Api_User->fetchAvatars(array[len:1], false, array[len:0]) in /core/vb/api/user.php(1391)
#7 vB_Api_User->fetchAvatar(820928)
#8 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#9 vB_Api_Logwrapper->__call('fetchAvatar', array[len:1]) in /core/vb/api/profile.php(88)
#10 vB_Api_Logwrapper->fetchAvatar(820928) in /core/vb/api/profile.php(88)
#11 vB_Api_Profile->getAvatarUrl(820928)
#12 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#13 vB_Api_Wrapper->__call('getAvatarUrl', array[len:1])
#14 vB_Api_Wrapper->getAvatarUrl(820928)
#15 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#16 vB_Api_Logwrapper->__call('getAvatarUrl', array[len:1])
#17 vB_Api_Logwrapper->getAvatarUrl(820928)
#18 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#19 Api_Interface_Collapsed->callApi('profile', 'getAvatarUrl', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#20 vB5_Template_Runtime::parseData('profile', 'getAvatarUrl', 820928) in /includes/vb5/template.php(290) : eval()'d code(42)
#21 eval() in /includes/vb5/template.php(290)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#27 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#28 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #47

SELECT * FROM vb_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 (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 51Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:451]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:451]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:17])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb/library/content/infraction.php(88)
#11 vB_Api_Logwrapper->fetch(array[len:17]) in /core/vb/library/content/infraction.php(88)
#12 vB_Library_Content_Infraction->__construct() in /core/vb/library.php(39)
#13 vB_Library::instance('Content_Infraction') in /core/vb/api/content/infraction.php(35)
#14 vB_Api_Content_Infraction->__construct() in /core/vb/api.php(156)
#15 vB_Api::instance('content_infraction') in /includes/api/interface/collapsed.php(176)
#16 Api_Interface_Collapsed->callApi('content_infraction', 'canViewUse[len:22]', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#17 vB5_Template_Runtime::parseData('content_infraction', 'canViewUse[len:22]', '820928') in /includes/vb5/template.php(290) : eval()'d code(83)
#18 eval() in /includes/vb5/template.php(290)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#24 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#25 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #48

				SELECT COUNT(*)
				FROM vb_userstylevar
				WHERE userid = 820928
			
/**userstylevarCount**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_userstylevarindex stylevarinstance256 1Using where; Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\tSELEC[len:99]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:99]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('userstylevarCount', array[len:1], false) in /core/vb/db/assertor.php(578)
#6 vB_dB_Assertor->getField('userstylevarCount', array[len:1]) in /core/vb/api/stylevar.php(416)
#7 vB_Api_Stylevar->isProfileCustomized(820928)
#8 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#9 vB_Api_Wrapper->__call('isProfileCustomized', array[len:1])
#10 vB_Api_Wrapper->isProfileCustomized(820928)
#11 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#12 vB_Api_Logwrapper->__call('isProfileCustomized', array[len:1])
#13 vB_Api_Logwrapper->isProfileCustomized(820928)
#14 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#15 Api_Interface_Collapsed->callApi('stylevar', 'isProfileCustomized', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#16 vB5_Template_Runtime::parseData('stylevar', 'isProfileCustomized', 820928) in /includes/vb5/template.php(290) : eval()'d code(228)
#17 eval() in /includes/vb5/template.php(290)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#23 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#24 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #49

SELECT * FROM vb_searchlog
 WHERE `searchhash` IN ('5a36d27d38fbf6da7cebfd68040c74ac') AND `userid` = 0  AND `dateline` >= 1579297158  AND `sortby` = 'created'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_searchlogrefsearch,userfloodchecksearch56const,const,const,const8Using where; Using filesort
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:212]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:212]', 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(277)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:1], array[len:2]) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('vBDbSearch:searchlog', array[len:1], array[len:2], 'searchhash') in /core/vb/search/core.php(342)
#8 vB_Search_Core->getFromCache(vB_Search_Criteria, array[len:5]) in /core/vb/api/search.php(115)
#9 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#10 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#11 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#13 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#15 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#16 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#17 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#18 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#19 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#20 eval() in /includes/vb5/template.php(290)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#26 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#27 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #50

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('vb_readperms') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:60]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('vb_readperms') in /core/vb/permissioncontext.php(548)
#9 vB_PermissionContext->getForumAccess(1) in /core/vb/usercontext.php(1045)
#10 vB_UserContext->getReadChannels() in /core/vb/api/search.php(140)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, 0) in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#13 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#16 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#17 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#19 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#20 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#22 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#23 eval() in /includes/vb5/template.php(290)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#26 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#27 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#28 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#29 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#30 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #51

SELECT COUNT(*) AS count FROM vb_moderator
 WHERE `userid` = 0 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_moderatorrefuserid_nodeiduserid_nodeid4const1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT COU[len:63]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT COU[len:63]', 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(277)
#6 vB_dB_Assertor->assertQuery('vBForum:moderator', array[len:2], false) in /core/vb/db/assertor.php(578)
#7 vB_dB_Assertor->getField('vBForum:moderator', array[len:2]) in /core/vb/usercontext.php(1244)
#8 vB_UserContext->isForumModerator() in /core/vb/usercontext.php(1257)
#9 vB_UserContext->isModerator() in /core/vb/usercontext.php(1107)
#10 vB_UserContext->getReadChannels() in /core/vb/api/search.php(140)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, 0) in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#13 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#16 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#17 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#19 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#20 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#22 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#23 eval() in /includes/vb5/template.php(290)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#26 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#27 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#28 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#29 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#30 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #52

SELECT * FROM vb_cache
 WHERE `cacheid` IN ('getSearchResults_6b335ffddd73ea2cbbdca015ce3116b1') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_cacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:97]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:97]', 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(277)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(156)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(749)
#8 vB_Cache->read('getSearchR[len:49]') 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(161)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, 0) in /core/vb/api/search.php(127)
#12 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#13 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#16 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#17 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#19 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#20 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#22 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#23 eval() in /includes/vb5/template.php(290)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#26 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#27 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#28 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#29 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#30 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #53

			(
				SELECT node.nodeid, node.created, node.nodeid AS nodeid2
				FROM vb_node as node
				 LEFT JOIN vb_node AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter)

				WHERE node.inlist = 1 AND 
				node.contenttypeid <> '27' AND 
				node.publishdate >= 1576618818
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,2,3,8,14,4,9,10,7,13,73,77,54539,54541,54543,102276) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0)))

				AND node.userid = 820928
			)
			UNION
			(
				SELECT node.nodeid, node.created, node.nodeid AS nodeid2
				FROM vb_node as node
				 LEFT JOIN vb_node AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter)

				WHERE node.inlist = 1 AND 
				node.contenttypeid <> '27' AND 
				node.publishdate >= 1576618818
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,2,3,8,14,4,9,10,7,13,73,77,54539,54541,54543,102276) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0)))

				AND node.setfor = 820928
			)
			ORDER BY created DESC,nodeid2 ASC
			LIMIT 500
			
/**getSearchResults**/
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t(\n\t\t\t\t[len:1246]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t(\n\t\t\t\t[len:1246]') in /core/packages/vbdbsearch/db/mysql/querydefs.php(493)
#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(277)
#6 vB_dB_Assertor->assertQuery('vBDBSearch[len:27]', array[len:3], false) in /core/vb/db/assertor.php(673)
#7 vB_dB_Assertor->getColumn('vBDBSearch[len:27]', 'nodeid', array[len:3]) in /core/packages/vbdbsearch/core.php(249)
#8 vBDBSearch_Core->getResults(vB_Search_Criteria) in /core/vb/api/search.php(161)
#9 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, 0) in /core/vb/api/search.php(127)
#10 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#11 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#12 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#13 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#14 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#15 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#16 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#17 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#18 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#19 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#20 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#21 eval() in /includes/vb5/template.php(290)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#27 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#28 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #54

			REPLACE INTO vb_searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,results,results_count)
			VALUES
				('0','0','3.95.139.100','5a36d27d38fbf6da7cebfd68040c74ac','created','desc','0.012983083724976','1579297218','0','{\"include_visitor_messages\":1,\"authorid\":820928,\"date\":{\"from\":\"lastMonth\"},\"view\":\"conversation_stream\",\"exclude_type\":\"vBForum_PrivateMessage\"}','','0')
		
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(504)
#1 vB_Database->query_write('\n\t\t\tREPLAC[len:446]') in /core/packages/vbdbsearch/db/mysql/querydefs.php(663)
#2 vBDBSearch_dB_MYSQL_QueryDefs->cacheResults(array[len:2], 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(277)
#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:0], vB_Search_Criteria, 0.012983083724976, 0) in /core/vb/api/search.php(165)
#6 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, 0) in /core/vb/api/search.php(127)
#7 vB_Api_Search->getSearchResult('{"authorid[len:147]', 0) in /core/vb/api/search.php(217)
#8 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#9 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#11 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#12 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#14 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#15 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#17 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#18 eval() in /includes/vb5/template.php(290)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#24 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#25 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #55

SELECT * FROM vb_searchlog
 WHERE `searchlogid` = 5911294 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_searchlogconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:67]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:67]', 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(277)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:3], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('vBDbSearch:searchlog', array[len:2]) in /core/vb/search/core.php(415)
#8 vB_Search_Core->getCache(5911294) in /core/vb/api/search.php(277)
#9 vB_Api_Search->getMoreNodes(array[len:15], '20', '1') in /core/vb/api/search.php(393)
#10 vB_Api_Search->getMoreResults(array[len:15], '20', '1', '1') in /core/vb/api/search.php(222)
#11 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#12 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#13 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#14 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#15 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#16 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#17 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#18 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#19 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#20 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#21 eval() in /includes/vb5/template.php(290)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#27 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#28 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #56

SELECT * FROM vb_page
 WHERE `pageid` = 12 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_pageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:52]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:52]', 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(277)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(605)
#7 vB_dB_Assertor->getRow('page', array[len:1]) 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], 'r=5911294', '') in /core/vb5/route.php(1122)
#10 vB5_Route::buildUrl('search', array[len:0], array[len:1]) in /core/vb/api/search.php(355)
#11 vB_Api_Search->getMoreNodes(array[len:15], '20', '1') in /core/vb/api/search.php(393)
#12 vB_Api_Search->getMoreResults(array[len:15], '20', '1', '1') in /core/vb/api/search.php(222)
#13 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#14 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#15 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#16 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#17 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#18 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#19 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#20 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#21 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#22 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#23 eval() in /includes/vb5/template.php(290)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#26 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#27 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#28 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#29 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#30 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #57

SELECT * FROM vb_phrase
 WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 6Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:150]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:150]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:2])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#10 vB_Api_Logwrapper->__call('fetch', array[len:1]) in /core/vb5/route/page.php(30)
#11 vB_Api_Logwrapper->fetch(array[len:2]) in /core/vb5/route/page.php(30)
#12 vB5_Route_Page->getPage() in /core/vb5/route/page.php(49)
#13 vB5_Route_Page->__construct(array[len:13], array[len:0], 'r=5911294', '') in /core/vb5/route.php(1122)
#14 vB5_Route::buildUrl('search', array[len:0], array[len:1]) in /core/vb/api/search.php(355)
#15 vB_Api_Search->getMoreNodes(array[len:15], '20', '1') in /core/vb/api/search.php(393)
#16 vB_Api_Search->getMoreResults(array[len:15], '20', '1', '1') in /core/vb/api/search.php(222)
#17 vB_Api_Search->getInitialResults(array[len:5], '20', '1', '1')
#18 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/wrapper.php(121)
#19 vB_Api_Wrapper->__call('getInitialResults', array[len:4])
#20 vB_Api_Wrapper->getInitialResults(array[len:5], '20', '1', '1')
#21 call_user_func_array(array[len:2], array[len:4]) in /core/vb/api/logwrapper.php(66)
#22 vB_Api_Logwrapper->__call('getInitialResults', array[len:4])
#23 vB_Api_Logwrapper->getInitialResults(array[len:5], '20', '1', '1')
#24 call_user_func_array(array[len:2], array[len:4]) in /includes/api/interface/collapsed.php(189)
#25 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:4], false, true) in /includes/vb5/template/runtime.php(501)
#26 vB5_Template_Runtime::parseData('search', 'getInitialResults', array[len:5], '20', '1', '1') in /includes/vb5/template.php(290) : eval()'d code(660)
#27 eval() in /includes/vb5/template.php(290)
#28 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#29 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#30 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#31 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#32 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#33 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#34 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #58

SELECT * FROM vb_template
 WHERE `templateid` IN (64,310) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templaterangePRIMARYPRIMARY4 2Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:58]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:2], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:2], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:2], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:2], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\t[len:8787]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:8970]') in /includes/vb5/template.php(312)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#24 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#25 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #59

SELECT * FROM vb_template
 WHERE `templateid` IN (433) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled') in /core/vb/api/template.php(64)
#8 vB_Api_Template->fetchBulk(array[len:1], 1)
#9 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2])
#11 vB_Api_Wrapper->fetchBulk(array[len:1], 1)
#12 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetchBulk', array[len:2])
#14 vB_Api_Logwrapper->fetchBulk(array[len:1], 1)
#15 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(221)
#17 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:3102]') in /includes/vb5/template.php(312)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #60

				SELECT COUNT(*)
				FROM vb_userstylevar
				WHERE userid = 820928
			
/**userstylevarCount**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_userstylevarindex stylevarinstance256 1Using where; Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('\n\t\t\t\tSELEC[len:99]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:99]', false) in /core/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(277)
#5 vB_dB_Assertor->assertQuery('userstylevarCount', array[len:1], false) in /core/vb/db/assertor.php(578)
#6 vB_dB_Assertor->getField('userstylevarCount', array[len:1]) in /core/vb/api/stylevar.php(416)
#7 vB_Api_Stylevar->isProfileCustomized(820928)
#8 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#9 vB_Api_Wrapper->__call('isProfileCustomized', array[len:1])
#10 vB_Api_Wrapper->isProfileCustomized(820928)
#11 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#12 vB_Api_Logwrapper->__call('isProfileCustomized', array[len:1])
#13 vB_Api_Logwrapper->isProfileCustomized(820928)
#14 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#15 Api_Interface_Collapsed->callApi('stylevar', 'isProfileCustomized', array[len:1], false, true) in /includes/vb5/template/runtime.php(501)
#16 vB5_Template_Runtime::parseData('stylevar', 'isProfileCustomized', 820928) in /includes/vb5/template.php(290) : eval()'d code(20)
#17 eval() in /includes/vb5/template.php(290)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:3102]') in /includes/vb5/template.php(312)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(312)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#23 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#24 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #61

SELECT * FROM vb_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_blogs','navbar_articles','navbar_social_groups','navbar_todays_posts','navbar_mark_channels_read','navbar_member_list','home','search_in_titles_only','search_in_posts_by_x_only','advanced_search','notice_1_html','announcement','no_announcement','collapse','expand','page_title','profile','activities','about','media','no_activity','show_more','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','source','x_only','visitor_messages_only','advanced','filtered_by','clear_all','conversation_new_posts','profile_sidebar','profile_picture_guser','x_is_offline','last_activity','joined','location','subscriptions','followers','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','cancel') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 204Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:1061]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:1061]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:68])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetch', array[len:1])
#11 vB_Api_Wrapper->fetch(array[len:68])
#12 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetch', array[len:1])
#14 vB_Api_Logwrapper->fetch(array[len:68])
#15 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(168)
#17 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(89)
#18 vB5_Template_Phrase->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(371)
#19 vB5_Template->renderDelayed('\r\n\t\r\n\t\r\n\t\r[len:34844]', false) in /includes/vb5/template.php(316)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #62

SELECT * FROM vb_routenew
 WHERE `routeid` IN ('search','subscription','register','help') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_routenewrangePRIMARYPRIMARY4 1Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:90]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:90]', 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(277)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(952)
#7 vB5_Route::preloadRoutes(array[len:4]) in /core/vb/api/route.php(467)
#8 vB_Api_Route->preloadRoutes(array[len:4])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('preloadRoutes', array[len:1])
#11 vB_Api_Wrapper->preloadRoutes(array[len:4])
#12 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('preloadRoutes', array[len:1])
#14 vB_Api_Logwrapper->preloadRoutes(array[len:4])
#15 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('route', 'preloadRoutes', array[len:1]) in /includes/vb5/template/url.php(210)
#17 vB5_Template_Url->finalBuildUrls(array[len:5]) in /includes/vb5/template/url.php(316)
#18 vB5_Template_Url->replacePlaceholders('\r\n\t\r\n\t\r\n\t\r[len:34844]') in /includes/vb5/template.php(375)
#19 vB5_Template->renderDelayed('\r\n\t\r\n\t\r\n\t\r[len:34844]', false) in /includes/vb5/template.php(316)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #63

SELECT * FROM vb_template
 WHERE `templateid` IN (506) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_templateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:55]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#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(277)
#6 vB_dB_Assertor->assertQuery('template', array[len:1]) in /core/vb/library/template.php(123)
#7 vB_Library_Template->fetchBulk(array[len:1], 1, 'compiled', false) in /core/vb/library/template.php(50)
#8 vB_Library_Template->fetch('debug_info', 1) in /core/vb/api/template.php(51)
#9 vB_Api_Template->fetch('debug_info', 1)
#10 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/wrapper.php(121)
#11 vB_Api_Wrapper->__call('fetch', array[len:2])
#12 vB_Api_Wrapper->fetch('debug_info', 1)
#13 call_user_func_array(array[len:2], array[len:2]) in /core/vb/api/logwrapper.php(66)
#14 vB_Api_Logwrapper->__call('fetch', array[len:2])
#15 vB_Api_Logwrapper->fetch('debug_info', 1)
#16 call_user_func_array(array[len:2], array[len:2]) in /includes/api/interface/collapsed.php(189)
#17 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(221)
#18 vB5_Template_Cache->fetchTemplate('debug_info') in /includes/vb5/template/cache.php(184)
#19 vB5_Template_Cache->getTemplate('debug_info') in /includes/vb5/template.php(415)
#20 vB5_Template->renderDelayed('\r\n\t\r\n\t\r\n\t\r[len:34844]', false) in /includes/vb5/template.php(316)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#22 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#23 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

SQL Query #64

SELECT * FROM vb_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','current_time') AND `languageid` IN (1,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEvb_phraserangename_lang_type,languageidname_lang_type254 63Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(519)
#1 vB_Database->query_read('SELECT * F[len:412]') in /core/vb/db/result.php(123)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(60)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:412]', 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(277)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:3], false) in /core/vb/db/assertor.php(630)
#7 vB_dB_Assertor->getRows('phrase', array[len:3]) in /core/vb/api/phrase.php(228)
#8 vB_Api_Phrase->fetch(array[len:21])
#9 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/wrapper.php(121)
#10 vB_Api_Wrapper->__call('fetch', array[len:1])
#11 vB_Api_Wrapper->fetch(array[len:21])
#12 call_user_func_array(array[len:2], array[len:1]) in /core/vb/api/logwrapper.php(66)
#13 vB_Api_Logwrapper->__call('fetch', array[len:1])
#14 vB_Api_Logwrapper->fetch(array[len:21])
#15 call_user_func_array(array[len:2], array[len:1]) in /includes/api/interface/collapsed.php(189)
#16 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(168)
#17 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(89)
#18 vB5_Template_Phrase->replacePlaceholders('<div id="d[len:6381]') in /includes/vb5/template.php(424)
#19 vB5_Template->renderDelayed('\r\n\t\r\n\t\r\n\t\r[len:34844]', false) in /includes/vb5/template.php(316)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(245)
#21 vB5_Frontend_Controller_Page->index(820928, '$pagenum', '8', 'LarryOrnaw')
#22 call_user_func_array(array[len:2], array[len:4]) in /index.php(112)

64 Queries Run : Total SQL time was 0.129057 seconds , Total PHP time was 0.124715 seconds , Overall time was 0.253772 seconds.