vBulletin - Explain SQL Queries (67)

SQL Query #1

SET @@sql_mode = ''
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(561)
#1 vB_Database->query_write('') in /core/vb/database.php(529)
#2 vB_Database->force_sql_mode('') in /core/vb/db/mysql/assertor.php(79)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:7]) in /core/vb/db/assertor.php(140)
#4 vB_dB_Assertor::init(array[len:4], array[len:7]) in /core/vb/vb.php(835)
#5 vB::getDbAssertor() in /core/vb/vb.php(851)
#6 vB::getDatastore() in /includes/api/interface/collapsed.php(48)
#7 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#8 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #2

SELECT * FROM datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 17Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:287]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in /core/vb/datastore.php(616)
#7 vB_Datastore->do_db_fetch(array[len:17]) in /core/vb/datastore.php(571)
#8 vB_Datastore->fetch(array[len:17]) in /core/vb/datastore.php(179)
#9 vB_Datastore->getValue('options') in /includes/api/interface/collapsed.php(48)
#10 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#11 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#12 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#13 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #3

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '18.207.254.88' AND `idhash` = '4ab9e77a4bfd302ea544fb496d8a64e2' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefuser_activity,guest_lookupguest_lookup83const,const,const1Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:130]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:4], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:4]) in /core/vb/session.php(217)
#8 vB_Session->loadExistingSession('', array[len:2]) in /core/vb/session.php(499)
#9 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2], 0, 0) in /core/vb/session/web.php(31)
#10 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2], 0, 0) in /core/vb/session/webapi.php(72)
#11 vB_Session_WebApi->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:6], '', array[len:2]) in /core/vb/session/webapi.php(66)
#12 vB_Session_WebApi::createSessionNew('', array[len:2]) in /core/vb/request/webapi.php(54)
#13 vB_Request_WebApi->createSessionNew('', array[len:2]) in /includes/api/interfaceabstract.php(180)
#14 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:430]) in /includes/api/interface/collapsed.php(59)
#15 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#16 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('d192b4e23e62be4d6d71b7005a67b3b9') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:77]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb/language.php(75)
#9 vB_Language::getPhraseCache('d192b4e23e[len:32]') in /core/vb/language.php(50)
#10 vB_Language::getPhraseInfo(2) in /core/vb/session.php(836)
#11 vB_Session->loadLanguage() in /core/vb/session.php(944)
#12 vB_Session->fetch_userinfo() in /core/vb/vb.php(990)
#13 vB::setCurrentSession(vB_Session_WebApi) in /core/vb/request.php(173)
#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/interfaceabstract.php(180)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:430]) in /includes/api/interface/collapsed.php(59)
#17 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#18 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #5

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1711)
#9 vB5_Route::fetchCommonRoutes() in /core/vb/api/route.php(87)
#10 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #6

				SELECT routenew.*
				FROM routenew AS routenew
				WHERE routenew.prefix IN ('search','') OR ishomeroute = 1
			
/**get_best_routes**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewindex_mergeprefix,ishomerouteprefix,ishomeroute202,2 3Using sort_union(prefix,ishomeroute); Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:140]', false) in /core/vb/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in /core/vb/api/route.php(127)
#6 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#7 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#8 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #7

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb/usercontext.php(142)
#9 vB_UserContext->reloadUserPerms() in /core/vb/usercontext.php(115)
#10 vB_UserContext->__construct(0, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7]) in /core/vb/vb.php(940)
#11 vB::getUserContext(0) in /core/vb/library/user.php(32)
#12 vB_Library_User->isBanned('0') in /core/vb/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in /core/vb/api/route.php(152)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #8

SELECT * FROM page
 WHERE `pageid` = 12 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:49]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:1], 'searchJSON[len:63]', '') in /core/vb5/route.php(1184)
#10 vB5_Route::checkRoute(array[len:14], 'search', 'search', 'searchJSON[len:63]', '') in /core/vb5/route.php(1120)
#11 vB5_Route::selectBestRoute('search', 'searchJSON[len:63]', '', array[len:2]) in /core/vb/api/route.php(159)
#12 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #9

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:1], 'searchJSON[len:63]', '') in /core/vb5/route.php(1184)
#12 vB5_Route::checkRoute(array[len:14], 'search', 'search', 'searchJSON[len:63]', '') in /core/vb5/route.php(1120)
#13 vB5_Route::selectBestRoute('search', 'searchJSON[len:63]', '', array[len:2]) in /core/vb/api/route.php(159)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_types.types') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1], true, true) in /core/vb/types.php(183)
#9 vB_Types->loadTypes() in /core/vb/types.php(151)
#10 vB_Types->__construct() in /core/vb/types.php(167)
#11 vB_Types::instance() in /core/vb/library/node.php(60)
#12 vB_Library_Node->__construct() in /core/vb/library.php(46)
#13 vB_Library::instance('node') in /core/vb/api/node.php(124)
#14 vB_Api_Node->__construct() in /core/vb/api.php(185)
#15 vB_Api::instanceInternal('node') in /core/vb/api/content.php(71)
#16 vB_Api_Content->__construct() in /core/vb/api/content/channel.php(40)
#17 vB_Api_Content_Channel->__construct() in /core/vb/api.php(185)
#18 vB_Api::instanceInternal('content_channel') in /core/vb/api/route.php(214)
#19 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #11

SELECT * FROM channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEchannelALLguid   73Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:518]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in /core/vb/library/content/channel.php(958)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/library/content/channel.php(981)
#8 vB_Library_Content_Channel->fetchChannelIdByGUID('vbulletin-[len:33]') in /core/vb/api/content/channel.php(168)
#9 vB_Api_Content_Channel->fetchChannelIdByGUID('vbulletin-[len:33]') in /core/vb/api/route.php(214)
#10 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #12

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl1data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb/library/content.php(3872)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/library/node.php(839)
#10 vB_Library_Node->getNodeBare('1') in /core/vb/library/node.php(914)
#11 vB_Library_Node->getNode('1') in /core/vb/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', '1', false, false) in /core/vb/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/api/route.php(215)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #13

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1], true, false) in /core/vb/permissioncontext.php(872)
#9 vB_PermissionContext->loadChannelPermissions(1) in /core/vb/permissioncontext.php(761)
#10 vB_PermissionContext->getChannelPerm(1, 'forumpermissions', 'canview', 1) in /core/vb/usercontext.php(609)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', '1', false, false) in /core/vb/usercontext.php(823)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/api/route.php(215)
#13 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #14

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1321)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(1207)
#10 vB5_Route::getRouteByIdent('24') in /core/vb5/route.php(1351)
#11 vB5_Route::getClassName('24', array[len:14]) in /core/vb5/route.php(1366)
#12 vB5_Route::getRoute('24', array[len:0], array[len:2]) in /core/vb5/route/page.php(184)
#13 vB5_Route_Page->getCanonicalRoute() in /core/vb/api/route.php(252)
#14 vB_Api_Route->getRoute('search', 'searchJSON[len:63]') in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(101)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #15

SELECT * FROM style
 WHERE `styleid` = 42 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:51]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in /core/vb/library/style.php(700)
#8 vB_Library_Style->fetchStyleByID('42') in /core/vb/api/style.php(59)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchStyleVars', array[len:1]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('style', 'fetchStyleVars', array[len:1]) in /includes/vb5/template/stylevar.php(155)
#12 vB5_Template_Stylevar->fetchStyleVars() in /includes/vb5/template/stylevar.php(38)
#13 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#14 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#15 vB5_Frontend_Application::init('config.php') in /index.php(48)

SQL Query #16

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3503) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#9 vB_Library_Template->fetch('preheader', 42) in /core/vb/api/template.php(51)
#10 vB_Api_Template->fetch('preheader', 42) in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('preheader') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('preheader') in /includes/vb5/template.php(384)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #17

SELECT * FROM page
 WHERE `pageid` = 3 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(108)
#11 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#12 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #18

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(108)
#13 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#14 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #19

SELECT * FROM page
 WHERE `pageid` = 23 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:49]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(109)
#11 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#12 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #20

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(109)
#13 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#14 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #21

SELECT * FROM page
 WHERE `pageid` = 6 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(110)
#11 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#12 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #22

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(110)
#13 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#14 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #23

SELECT * FROM page
 WHERE `pageid` = 5 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(111)
#11 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#12 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #24

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1433)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(111)
#13 vB5_Template_Phrase->replacePlaceholders('<!DOCTYPE [len:1271]') in /includes/vb5/template.php(517)
#14 vB5_Template->renderDelayed('<!DOCTYPE [len:1271]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/search.php(160)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #25

UPDATE session SET `wol`='a:3:{s:6:\"action\";s:16:\"searching_forums\";s:6:\"params\";a:0:{}s:6:\"nodeid\";i:0;}',`pagekey`='',`location`='' 
 WHERE (`sessionhash` = '3afcf09f00126e4b8d3192eed378bb38') 
/**session**/
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(561)
#1 vB_Database->query_write('') in /core/vb/db/query/update.php(104)
#2 vB_dB_Query_Update->doUpdates() in /core/vb/db/query/update.php(89)
#3 vB_dB_Query_Update->execSQL() in /core/vb/db/assertor.php(293)
#4 vB_dB_Assertor->assertQuery('session', array[len:5]) in /core/vb/api/wol.php(60)
#5 vB_Api_Wol->register('searching_forums', array[len:0]) in /core/vb/api/wrapper.php(201)
#6 vB_Api_Wrapper->__call('register', array[len:2]) in /includes/api/interface/collapsed.php(101)
#7 Api_Interface_Collapsed->callApi('wol', 'register', array[len:2]) in /includes/vb5/frontend/controller/search.php(185)
#8 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#9 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #26

				SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title as templatetitle
				FROM page AS page
				LEFT JOIN pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
				LEFT JOIN screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
				WHERE page.pageid = 12
			
/**fetch_page_pagetemplate_screenlayout**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:429]', false) in /core/vb/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('fetch_page[len:36]', array[len:1]) in /core/vb/api/page.php(61)
#6 vB_Api_Page->fetchPageById(12, array[len:2]) in /core/vb/api/wrapper.php(201)
#7 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(101)
#8 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/search.php(215)
#9 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#10 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #27

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('advanced_search','search_results') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:135]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/frontend/controller/search.php(222)
#12 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#13 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #28

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3323) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#9 vB_Library_Template->fetch('screenlayo[len:25]', 42) in /core/vb/api/template.php(51)
#10 vB_Api_Template->fetch('screenlayo[len:25]', 42) in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('screenlayo[len:25]') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('screenlayo[len:25]') in /includes/vb5/template.php(384)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #29

SELECT * FROM widgetinstance
 WHERE `pagetemplateid` = 15 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetinstancerefpagetemplateidpagetemplateid4const3Using where; Using filesort
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:122]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:1], array[len:3]) in /core/vb/api/widget.php(1719)
#7 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#9 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#12 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#13 eval() in /includes/vb5/template.php(392)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #30

				SELECT widgetdefinition.*, widget.template
				FROM widgetdefinition AS widgetdefinition
				JOIN widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(14,29,52)
			
/**getWidgetdefinition**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetrangePRIMARYPRIMARY4 3Using where
1SIMPLEwidgetdefinitionrefwidgetidwidgetid4db00099133.widget.widgetid3 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:247]', false) in /core/vb/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getWidgetdefinition', array[len:1]) in /core/vb/api/widget.php(1742)
#6 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#8 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#14 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#15 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #31

SELECT * FROM widgetinstance
 WHERE `widgetinstanceid` IN (53,51,52) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetinstancerangePRIMARYPRIMARY4 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:69]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:2], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('widgetinstance', array[len:2], false, 'widgetinstanceid') in /core/vb/api/widget.php(1422)
#8 vB_Api_Widget->fetchWidgetInstances(array[len:3]) in /core/vb/api/widget.php(1771)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#11 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(392)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #32

SELECT * FROM widget
 WHERE `widgetid` IN (0,14,29,52) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetrangePRIMARYPRIMARY4 4Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('widget', array[len:1], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('widget', array[len:1], false, 'widgetid') in /core/vb/api/widget.php(1774)
#8 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#9 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#10 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#13 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#14 eval() in /includes/vb5/template.php(392)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #33

SELECT COUNT(*) AS count FROM moderator
 WHERE `userid` = 0 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorrefuserid_nodeiduserid_nodeid4const1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT COU[len:60]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:moderator', array[len:2], false) in /core/vb/db/assertor.php(590)
#7 vB_dB_Assertor->getField('vBForum:moderator', array[len:2]) in /core/vb/usercontext.php(1351)
#8 vB_UserContext->isForumModerator() in /core/vb/usercontext.php(1364)
#9 vB_UserContext->isModerator() in /core/vb/session.php(1141)
#10 vB_Session->validateCpsession() in /core/vb/api.php(769)
#11 vB_Api->hasAdminPermissionInternal('canadminusers') in /core/vb/api.php(755)
#12 vB_Api->hasAdminPermission('canadminusers') in /core/vb/api/usergroup.php(175)
#13 vB_Api_UserGroup->sanitizeUserGroup(array[len:47]) in /core/vb/api/usergroup.php(268)
#14 vB_Api_UserGroup->fetchUsergroupBySystemID(1) in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('fetchUserg[len:24]', array[len:1]) in /core/vb/api/widget.php(1511)
#16 vB_Api_Widget->fetchUsergroupsForModuleViewPerms(0) in /core/vb/api/widget.php(1783)
#17 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#18 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#19 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#20 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#21 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#22 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#23 eval() in /includes/vb5/template.php(392)
#24 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#25 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#26 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #34

SELECT * FROM datastore
 WHERE `title` IN ('vBUgChannelAccessG1') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreconstPRIMARYPRIMARY50const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:66]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in /core/vb/datastore.php(616)
#7 vB_Datastore->do_db_fetch(array[len:1]) in /core/vb/datastore.php(571)
#8 vB_Datastore->fetch(array[len:1]) in /core/vb/datastore.php(179)
#9 vB_Datastore->getValue('vBUgChannelAccessG1') in /core/vb/permissioncontext.php(90)
#10 vB_PermissionContext->getAllChannelAccess(array[len:1]) in /core/vb/usercontext.php(1369)
#11 vB_UserContext->isModerator() in /core/vb/session.php(1141)
#12 vB_Session->validateCpsession() in /core/vb/api.php(769)
#13 vB_Api->hasAdminPermissionInternal('canadminusers') in /core/vb/api.php(755)
#14 vB_Api->hasAdminPermission('canadminusers') in /core/vb/api/usergroup.php(175)
#15 vB_Api_UserGroup->sanitizeUserGroup(array[len:47]) in /core/vb/api/usergroup.php(268)
#16 vB_Api_UserGroup->fetchUsergroupBySystemID(1) in /core/vb/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('fetchUserg[len:24]', array[len:1]) in /core/vb/api/widget.php(1511)
#18 vB_Api_Widget->fetchUsergroupsForModuleViewPerms(0) in /core/vb/api/widget.php(1783)
#19 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#20 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#21 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#22 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#23 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#24 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#25 eval() in /includes/vb5/template.php(392)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#27 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#28 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #35

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('widget_search_results_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 15Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:240]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:5], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:5]) in /core/vb/api/widget.php(1350)
#10 vB_Api_Widget->addWidgetTitles(array[len:3]) in /core/vb/api/widget.php(1901)
#11 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('15', -1, '', false) in /core/vb/api/widget.php(1941)
#12 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('15', '') in /core/vb/api/widget.php(1976)
#13 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#15 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#16 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#17 eval() in /includes/vb5/template.php(392)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#19 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#20 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #36

SELECT * FROM pagetemplate
 WHERE `pagetemplateid` = 15 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('pagetemplate', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('pagetemplate', array[len:2]) in /core/vb/api/widget.php(1979)
#8 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#14 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#15 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #37

SELECT * FROM screenlayout
 WHERE `screenlayoutid` = 1 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('screenlayout', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('screenlayout', array[len:2]) in /core/vb/api/widget.php(1980)
#8 vB_Api_Widget->fetchLayoutSectionInfo('15', '') in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1040)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '15', '') in /includes/vb5/template.php(392) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#14 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#15 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #38

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3541,3333,3491) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:105]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:3], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:3], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:3]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #39

SELECT * FROM site
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsiteALL    1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:27]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:site', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:site', array[len:2]) in /core/vb/library/site.php(225)
#8 vB_Library_Site->getNavbar('header', '1', '/search?se[len:71]', '0', '0') in /core/vb/library/site.php(193)
#9 vB_Library_Site->loadHeaderNavbar('1', '/search?se[len:71]', '0', '0') in /core/vb/api/site.php(89)
#10 vB_Api_Site->loadHeaderNavbar('1', '/search?se[len:71]', '0', '0') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('loadHeaderNavbar', array[len:4]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('site', 'loadHeaderNavbar', array[len:4], false, true) in /includes/vb5/template/runtime.php(1040)
#13 vB5_Template_Runtime::parseData('site', 'loadHeaderNavbar', '1', '/search?se[len:71]', '0', '0') in /includes/vb5/template.php(392) : eval()'d code(432)
#14 eval() in /includes/vb5/template.php(392)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #40

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3499,3374,3375,3338,1784,1786) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 6Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:120]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:8], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:8], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:8]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #41

SELECT * FROM loginlibrary
 WHERE `productid` = 'googlelogin' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEloginlibraryconstproductidproductid27const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:71]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:loginlibrary', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:loginlibrary', array[len:2]) in /core/vb/library/externallogin.php(73)
#8 vB_Library_ExternalLogin->getLoginLibraryId() in /core/vb/library/externallogin.php(34)
#9 vB_Library_ExternalLogin->__construct() in /core/packages/googlelogin/library/externallogin.php(29)
#10 GoogleLogin_Library_ExternalLogin->__construct() in /core/vb/library.php(46)
#11 vB_Library::instance('googlelogi[len:25]') in /core/packages/googlelogin/api/externallogin.php(28)
#12 GoogleLogin_Api_ExternalLogin->__construct() in /core/vb/api.php(213)
#13 vB_Api::instance('googlelogi[len:25]') in /core/packages/googlelogin/hooks.php(6)
#14 googlelogin_Hooks::hookShowExternalLoginButton(array[len:1]) in /core/vb/utility/hook/live.php(57)
#15 vB_Utility_Hook_Live->invoke('hookShowEx[len:27]', array[len:1]) in /core/vb/api/externallogin.php(83)
#16 vB_Api_ExternalLogin->showExternalLoginButton() in /core/vb/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('showExtern[len:23]', array[len:0]) in /includes/api/interface/collapsed.php(101)
#18 Api_Interface_Collapsed->callApi('externallogin', 'showExtern[len:23]', array[len:0], false, true) in /includes/vb5/template/runtime.php(1040)
#19 vB5_Template_Runtime::parseData('externallogin', 'showExtern[len:23]') in /includes/vb5/template.php(392) : eval()'d code(163)
#20 eval() in /includes/vb5/template.php(392)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#26 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#27 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #42

SELECT * FROM loginlibrary
 WHERE `productid` = 'twitterlogin' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEloginlibraryconstproductidproductid27const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:72]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:loginlibrary', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:loginlibrary', array[len:2]) in /core/vb/library/externallogin.php(73)
#8 vB_Library_ExternalLogin->getLoginLibraryId() in /core/vb/library/externallogin.php(34)
#9 vB_Library_ExternalLogin->__construct() in /core/vb/library/externallogin/oauth.php(97)
#10 vB_Library_ExternalLogin_OAuth->__construct() in /core/packages/twitterlogin/library/externallogin.php(22)
#11 TwitterLogin_Library_ExternalLogin->__construct() in /core/vb/library.php(46)
#12 vB_Library::instance('TwitterLog[len:26]') in /core/packages/twitterlogin/api/externallogin.php(28)
#13 TwitterLogin_Api_ExternalLogin->__construct() in /core/vb/api.php(213)
#14 vB_Api::instance('TwitterLog[len:26]') in /core/packages/twitterlogin/hooks.php(6)
#15 twitterlogin_Hooks::hookShowExternalLoginButton(array[len:1]) in /core/vb/utility/hook/live.php(57)
#16 vB_Utility_Hook_Live->invoke('hookShowEx[len:27]', array[len:1]) in /core/vb/api/externallogin.php(83)
#17 vB_Api_ExternalLogin->showExternalLoginButton() in /core/vb/api/wrapper.php(201)
#18 vB_Api_Wrapper->__call('showExtern[len:23]', array[len:0]) in /includes/api/interface/collapsed.php(101)
#19 Api_Interface_Collapsed->callApi('externallogin', 'showExtern[len:23]', array[len:0], false, true) in /includes/vb5/template/runtime.php(1040)
#20 vB5_Template_Runtime::parseData('externallogin', 'showExtern[len:23]') in /includes/vb5/template.php(392) : eval()'d code(163)
#21 eval() in /includes/vb5/template.php(392)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#27 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#28 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #43

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1765,1789,1767,3221,2946,2951) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 6Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:120]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:6], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:6], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:6]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\r\n\r\n\r\n\r\n[len:2910]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#19 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#20 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #44

SELECT `noticeid` FROM noticedismissed
 WHERE `userid` = 0 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoticedismissedrefuseriduserid4const1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `no[len:59]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:no[len:23]', array[len:2], false) in /core/vb/db/assertor.php(685)
#7 vB_dB_Assertor->getColumn('vBForum:no[len:23]', 'noticeid', array[len:2]) in /core/vb/api/notice.php(87)
#8 vB_Api_Notice->fetch('', array[len:0]) in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('notice', 'fetch', array[len:2]) in /includes/vb5/template/runtime.php(1057)
#11 vB5_Template_Runtime::parseDataWithErrors('notice', 'fetch', '', array[len:0]) in /includes/vb5/template.php(392) : eval()'d code(1)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#18 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#19 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #45

SELECT * FROM termine WHERE userid="0" AND rememberFrom <= "1590711238" AND end >= rememberFrom AND rememberFrom > 0
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtermineALL    4Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('') in /core/vb/api/termine.php(53)
#2 vB_Api_Termine->getTermineForRemember(0) in /core/vb/api/wrapper.php(201)
#3 vB_Api_Wrapper->__call('getTermine[len:21]', array[len:1]) in /includes/api/interface/collapsed.php(101)
#4 Api_Interface_Collapsed->callApi('termine', 'getTermine[len:21]', array[len:1], false, true) in /includes/vb5/template/runtime.php(1040)
#5 vB5_Template_Runtime::parseData('termine', 'getTermine[len:21]', 0) in /includes/vb5/template.php(392) : eval()'d code(1)
#6 eval() in /includes/vb5/template.php(392)
#7 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#8 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:14013]') in /includes/vb5/template.php(414)
#9 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#10 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#11 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#12 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#13 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #46

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3335) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2351]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #47

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3336) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2210]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2351]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#19 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#20 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #48

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1785,3438) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:100]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:2], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:2], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1971]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2210]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2351]') in /includes/vb5/template.php(414)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #49

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3479) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\n\t\n\n\n\t\n\t\n\n[len:816]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:1971]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2210]') in /includes/vb5/template.php(414)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:2351]') in /includes/vb5/template.php(414)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #50

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3458) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #51

SELECT * FROM tag
 WHERE `tagtext` IN ('kompassgeschichten') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagconsttagtexttagtext102const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:61]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:tag', array[len:2]) in /core/vb/search/criteria.php(316)
#7 vB_Search_Criteria->add_tag_filter(array[len:1]) in /core/vb/api/search.php(1791)
#8 vB_Api_Search->json2criteria(array[len:2]) in /core/vb/api/search.php(103)
#9 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#10 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(392)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #52

SELECT * FROM tag
 WHERE `tagid` = '' 
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(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:38]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:tag', array[len:1], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('vBForum:tag', array[len:1], false, 'tagid') in /core/vb/api/tags.php(891)
#8 vB_Api_Tags->getTags(array[len:0]) in /core/vb/search/criteria.php(336)
#9 vB_Search_Criteria->add_tag_filter(array[len:1]) in /core/vb/api/search.php(1791)
#10 vB_Api_Search->json2criteria(array[len:2]) in /core/vb/api/search.php(103)
#11 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#12 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#14 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#15 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#16 eval() in /includes/vb5/template.php(392)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#26 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#27 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #53

			INSERT INTO tagsearch (`tagid`,`dateline`)
			VALUES (39,1590711238)
/**tagsearch**/
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(561)
#1 vB_Database->query_write('') in /core/vb/db/query/multipleinsert.php(105)
#2 vB_dB_Query_MultipleInsert->doMultipleInserts() in /core/vb/db/query/multipleinsert.php(88)
#3 vB_dB_Query_MultipleInsert->execSQL() in /core/vb/db/assertor.php(293)
#4 vB_dB_Assertor->assertQuery('vBDBSearch:tagsearch', array[len:3]) in /core/vb/api/tags.php(913)
#5 vB_Api_Tags->logSearchTags(array[len:1]) in /core/vb/api/search.php(1793)
#6 vB_Api_Search->json2criteria(array[len:2]) in /core/vb/api/search.php(103)
#7 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#8 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#11 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#22 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#23 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #54

SELECT * FROM searchlog
 WHERE `searchhash` IN ('7487d8394f464f693aebb100a63af090') AND `userid` = 0  AND `dateline` >= 1590711178  AND `sortby` = 'created'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchlograngesearch,userfloodcheck,datelineuserfloodcheck8 1Using index condition; Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:209]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:1], array[len:2]) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('vBDbSearch:searchlog', array[len:1], array[len:2], 'searchhash') in /core/vb/search/core.php(477)
#8 vB_Search_Core->getFromCache(vB_Search_Criteria, array[len:2]) in /core/vb/api/search.php(116)
#9 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#10 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(392)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #55

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_readperms') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:57]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb/permissioncontext.php(621)
#9 vB_PermissionContext->getForumAccess(1) in /core/vb/usercontext.php(1104)
#10 vB_UserContext->getReadChannels() in /core/vb/api/search.php(141)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(130)
#12 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#13 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(392)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#27 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#28 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #56

SELECT * FROM cache
 WHERE `cacheid` IN ('getSearchResults_c8a550b19ecf6e4938d8f5bd1836d6c4') 
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(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:94]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in /core/vb/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb/search/core.php(74)
#9 vB_Search_Core->getTwoPassResults(vB_Search_Criteria) in /core/packages/vbdbsearch/core.php(449)
#10 vBDBSearch_Core->getResults(vB_Search_Criteria) in /core/vb/api/search.php(163)
#11 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(130)
#12 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#13 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#15 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#16 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#17 eval() in /includes/vb5/template.php(392)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#27 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#28 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #57

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

			WHERE tagnode39.tagid = 39 AND 
				node.inlist = 1 AND 
				node.contenttypeid <> 27 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,152652,161826,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0)))

 
			ORDER BY node.created DESC,nodeid2 DESC
			LIMIT 1000
			
/**getSearchResults**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtagnode39refPRIMARY,id_type_user,id_type_node,id_type_tagid_type_tag4const10Using index; Using temporary; Using filesort
1SIMPLEnodeeq_refPRIMARY,node_user,node_ppreview,node_showapproved,node_ctypid_userid_dispo_idx,nodeid,contenttypeid_parentid,node_inlist,showpublishedPRIMARY4db00099133.tagnode39.nodeid1Using where
1SIMPLEstartereq_refPRIMARY,nodeidPRIMARY4func1Using where
#0 vB_Database_MySQLi->execute_query(false, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', false) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\tSELECT[len:800]', false, false) in /core/packages/vbdbsearch/db/mysql/querydefs.php(592)
#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(293)
#6 vB_dB_Assertor->assertQuery('vBDBSearch[len:27]', array[len:3]) in /core/packages/vbdbsearch/core.php(471)
#7 vBDBSearch_Core->getResults(vB_Search_Criteria) in /core/vb/api/search.php(163)
#8 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(130)
#9 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#10 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#13 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#14 eval() in /includes/vb5/template.php(392)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#24 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#25 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #58

			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,results,results_count)
			VALUES
				('1','0','18.207.254.88','7487d8394f464f693aebb100a63af090','created','desc','0.0039410591125488','1590711238','0','{\"tag\":[\"kompassgeschichten\"],\"ignore_protected\":1}','','0')
		
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(561)
#1 vB_Database->query_write('') in /core/packages/vbdbsearch/db/mysql/querydefs.php(713)
#2 vBDBSearch_dB_MYSQL_QueryDefs->cacheResults(array[len:1], vB_Database_MySQLi, false, false) in /core/vb/db/query/method.php(175)
#3 vB_dB_Query_Method->execSQL() in /core/vb/db/assertor.php(293)
#4 vB_dB_Assertor->assertQuery('vBDBSearch[len:23]', array[len:1]) in /core/vb/search/core.php(419)
#5 vB_Search_Core->cacheResults(array[len:0], vB_Search_Criteria, 0.0039410591125488, '1') in /core/vb/api/search.php(167)
#6 vB_Api_Search->getSearchResultsCriteria(vB_Search_Criteria, '1') in /core/vb/api/search.php(130)
#7 vB_Api_Search->getSearchResult(array[len:2], '1') in /core/vb/api/search.php(226)
#8 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#11 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#12 eval() in /includes/vb5/template.php(392)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#22 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#23 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #59

SELECT * FROM searchlog
 WHERE `searchlogid` = 29653348 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchlogconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBDbSearch:searchlog', array[len:3], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBDbSearch:searchlog', array[len:3]) in /core/vb/search/core.php(553)
#8 vB_Search_Core->getCache(29653348) in /core/vb/api/search.php(681)
#9 vB_Api_Search->getMoreNodes(29653348, '15', NULL) in /core/vb/api/search.php(797)
#10 vB_Api_Search->getMoreResults(array[len:15], '15', NULL, '1') in /core/vb/api/search.php(231)
#11 vB_Api_Search->getInitialResults('{"tag":"ko[len:51]', '15', NULL, '1', '1') in /core/vb/api/wrapper.php(201)
#12 vB_Api_Wrapper->__call('getInitialResults', array[len:5]) in /includes/api/interface/collapsed.php(101)
#13 Api_Interface_Collapsed->callApi('search', 'getInitialResults', array[len:5]) in /includes/vb5/template/runtime.php(1057)
#14 vB5_Template_Runtime::parseDataWithErrors('search', 'getInitialResults', array[len:2], '15', NULL, '1', '1') in /includes/vb5/template.php(392) : eval()'d code(51)
#15 eval() in /includes/vb5/template.php(392)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#24 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#25 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#26 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #60

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3373) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:1], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('\r\n\r\n\r\n\r\n\r\n[len:5077]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t<!-- **[len:5274]') in /includes/vb5/template.php(414)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5547]') in /includes/vb5/template.php(414)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('\r\n\t\r\n\r\n\r\n\r[len:5688]') in /includes/vb5/template.php(414)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#23 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#24 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #61

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1739,1764,1779,616,1787,1790) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 6Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:119]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:6], 42, 'compiled') in /core/vb/api/template.php(64)
#9 vB_Api_Template->fetchBulk(array[len:6], 42) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:6]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('</div>\r\n\t<[len:14639]') in /includes/vb5/template.php(414)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(414)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #62

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('','logo','powered_by_vbulletin_title','search','navbar_home','navbar_articles','navbar_absprachenmediation','navbar_themenfilter','navbar_aktive_themen','navbar_regeln','navbar_faq','navbar_todays_posts','navbar_calendar','home','login_or_sign_up','you_can_also_login_as','logging_in','username','password','remember_me','log_in','forgot_password','or_sign_up','search_in_titles_only','notice_1_html','announcement','no_announcement','collapse','expand','page_title','x_result_in_y_seconds','keywords','members','started_posts_only','tags','there_are_no_results_that_meet_criteria','navbar_contact_us','navbar_impressum','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','cancel','facebook_language') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 141Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:843]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:49], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:49]) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(241)
#12 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(96)
#13 vB5_Template_Phrase->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(517)
#14 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #63

SELECT * FROM routenew
 WHERE `routeid` IN ('advanced_search','pmchat','register','activateuser','help','contact-us','search','lostpw') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewrangePRIMARYPRIMARY4 1Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:136]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(1301)
#7 vB5_Route::preloadRoutes(array[len:8]) in /core/vb/api/route.php(503)
#8 vB_Api_Route->preloadRoutes(array[len:8]) in /core/vb/api/wrapper.php(201)
#9 vB_Api_Wrapper->__call('preloadRoutes', array[len:1]) in /includes/api/interface/collapsed.php(101)
#10 Api_Interface_Collapsed->callApi('route', 'preloadRoutes', array[len:1]) in /includes/vb5/template/url.php(210)
#11 vB5_Template_Url->finalBuildUrls(array[len:10]) in /includes/vb5/template/url.php(333)
#12 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(521)
#13 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#15 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#16 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #64

SELECT * FROM page
 WHERE `pageid` = 2 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('page', array[len:2], false) in /core/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1580)
#10 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:10]) in /core/vb5/route.php(1545)
#11 vB5_Route::buildUrls(array[len:10]) in /core/vb/api/route.php(468)
#12 vB_Api_Route->getUrls(array[len:10]) in /core/vb/api/wrapper.php(201)
#13 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(101)
#14 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(268)
#15 vB5_Template_Url->finalBuildUrls(array[len:10]) in /includes/vb5/template/url.php(333)
#16 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(521)
#17 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#19 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#20 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #65

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('page_4ecbdac82efb6117736147_title','page_4ecbdac82efb6117736147_metadesc') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 6Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:175]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1580)
#12 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:10]) in /core/vb5/route.php(1545)
#13 vB5_Route::buildUrls(array[len:10]) in /core/vb/api/route.php(468)
#14 vB_Api_Route->getUrls(array[len:10]) in /core/vb/api/wrapper.php(201)
#15 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(101)
#16 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(268)
#17 vB5_Template_Url->finalBuildUrls(array[len:10]) in /includes/vb5/template/url.php(333)
#18 vB5_Template_Url->replacePlaceholders('\r\n\t\t<meta [len:91101]') in /includes/vb5/template.php(521)
#19 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#21 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#22 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #66

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (3497) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `ti[len:95]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('template', array[len:3], false) in /core/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 42, 'compiled', false) in /core/vb/library/template.php(50)
#9 vB_Library_Template->fetch('debug_info', 42) in /core/vb/api/template.php(51)
#10 vB_Api_Template->fetch('debug_info', 42) in /core/vb/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(101)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('debug_info') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('debug_info') in /includes/vb5/template.php(571)
#15 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#17 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#18 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

SQL Query #67

SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (2,0,-1) 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type195 75Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/database.php(576)
#1 vB_Database->query_read('', true) in /core/vb/db/result.php(144)
#2 vB_dB_Result->rewind() in /core/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `va[len:500]', false) in /core/vb/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in /core/vb/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in /core/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('phrase', array[len:4], false) in /core/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:25], 2) in /core/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:25]) in /core/vb/api/wrapper.php(201)
#10 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(101)
#11 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(241)
#12 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(96)
#13 vB5_Template_Phrase->replacePlaceholders('<div id="d[len:53573]') in /includes/vb5/template.php(581)
#14 vB5_Template->renderDelayed('\r\n\t\t<meta [len:91101]', false) in /includes/vb5/template.php(418)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/search.php(323)
#16 vB5_Frontend_Controller_Search->actionResult() in /includes/vb5/frontend/controller/search.php(343)
#17 vB5_Frontend_Controller_Search->results(12, '12') in /index.php(74)

5 Slowest Queries

SQL Query #25 Time Taken: 0.059539079666138 Memory Used: 0
UPDATE session SET `wol`='a:3:{s:6:\"action\";s:16:\"searching_forums\";s:6:\"params\";a:0:{}s:6:\"nodeid\";i:0;}',`pagekey`='',`location`='' 
 WHERE (`sessionhash` = '3afcf09f00126e4b8d3192eed378bb38') 
/**session**/
SQL Query #53 Time Taken: 0.0095698833465576 Memory Used: 0
			INSERT INTO tagsearch (`tagid`,`dateline`)
			VALUES (39,1590711238)
/**tagsearch**/
SQL Query #58 Time Taken: 0.0086660385131836 Memory Used: 0
			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,completed,json,results,results_count)
			VALUES
				('1','0','18.207.254.88','7487d8394f464f693aebb100a63af090','created','desc','0.0039410591125488','1590711238','0','{\"tag\":[\"kompassgeschichten\"],\"ignore_protected\":1}','','0')
		
SQL Query #4 Time Taken: 0.0025031566619873 Memory Used: 0
SELECT * FROM cache
 WHERE `cacheid` IN ('d192b4e23e62be4d6d71b7005a67b3b9') 
SQL Query #57 Time Taken: 0.002269983291626 Memory Used: 0
			SELECT node.nodeid, starter.parentid, starter.userid, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN tagnode AS tagnode39 ON
					(node.nodeid = tagnode39.nodeid)  
				 LEFT JOIN node AS starter ON starter.nodeid = IF(node.starter = 0, node.nodeid, node.starter)

			WHERE tagnode39.tagid = 39 AND 
				node.inlist = 1 AND 
				node.contenttypeid <> 27 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,100,104,114,119,124,485,16428,152652,161826,102,115,120,125,486,33796,161827,105,116,121,488,113,487,118,489,122,17827) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 10 AND node.userid IN (0)))

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

67 Queries Run : Total SQL time was 0.117588 seconds , Total PHP time was 0.089503 seconds , Overall time was 0.207091 seconds.