vBulletin - Explain SQL Queries (147)

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

SQL Query #1

SET @@sql_mode = ''
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(572)
#1 vB_Database->query_write('') in /core/vb/vb/database.php(540)
#2 vB_Database->force_sql_mode('') in /core/vb/vb/db/mysql/assertor.php(73)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:8]) in /core/vb/vb/db/assertor.php(140)
#4 vB_dB_Assertor::init(array[len:4], array[len:8]) in /core/vb/vb.php(805)
#5 vB::getDbAssertor() in /core/vb/vb.php(821)
#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(117)

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','locations')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY150 18Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:299]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in /core/vb/vb/datastore.php(606)
#7 vB_Datastore->do_db_fetch(array[len:18]) in /core/vb/vb/datastore.php(560)
#8 vB_Datastore->fetch(array[len:18]) in /core/vb/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(117)

SQL Query #3

SELECT * FROM session
 WHERE `sessionhash` = 'd6bae9b5b3c97546ca653d8e6a7d084c'  AND `lastactivity` > 1787552635  
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionconstPRIMARY,last_activity,idx_lastactivityPRIMARY96const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:123]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:3], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:3]) in /core/vb/vb/session.php(328)
#8 vB_Session->fetchStoredSession('d6bae9b5b3[len:32]', array[len:2]) in /core/vb/vb/session.php(131)
#9 vB_Session->loadExistingSession('d6bae9b5b3[len:32]', array[len:2], false) in /core/vb/vb/session.php(546)
#10 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], 'd6bae9b5b3[len:32]', array[len:2], 0, 0) in /core/vb/vb/session/web.php(31)
#11 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], 'd6bae9b5b3[len:32]', array[len:2], 0, 0, true) in /core/vb/vb/session/webapi.php(75)
#12 vB_Session_WebApi::createSessionNew('d6bae9b5b3[len:32]', array[len:2], true) in /core/vb/vb/request/webapi.php(55)
#13 vB_Request_WebApi->createSessionNew('d6bae9b5b3[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#14 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#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(117)

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('651f0d810ec99d7e96e640185e3b1fea')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:77]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/language.php(74)
#9 vB_Language::getPhraseCache('651f0d810e[len:32]') in /core/vb/vb/language.php(49)
#10 vB_Language::getPhraseInfo(2) in /core/vb/vb/session.php(877)
#11 vB_Session->loadLanguage() in /core/vb/vb/session.php(955)
#12 vB_Session->fetch_userinfo() in /core/vb/vb.php(960)
#13 vB::setCurrentSession(vB_Session_WebApi) in /core/vb/vb/request.php(173)
#14 vB_Request->setSession(vB_Session_WebApi) in /core/vb/vb/request/webapi.php(56)
#15 vB_Request_WebApi->createSessionNew('d6bae9b5b3[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#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(117)

SQL Query #5

SELECT phrasegroup_global,
		options AS lang_options,
		languagecode AS lang_code,
		charset AS lang_charset,
		locale AS lang_locale,
		dateoverride AS lang_dateoverride,
		timeoverride AS lang_timeoverride,
		registereddateoverride AS lang_registereddateoverride,
		calformat1override AS lang_calformat1override,
		calformat2override AS lang_calformat2override,
		eventdateformatoverride AS lang_eventdateformatoverride,
		pickerdateformatoverride AS lang_pickerdateformatoverride,
		logdateoverride AS lang_logdateoverride,
		decimalsep AS lang_decimalsep,
		thousandsep AS lang_thousandsep
 FROM language WHERE languageid = 2/* fetchLanguage */
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLElanguageconstPRIMARYPRIMARY2const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT phr[len:648]') in /core/vb/vb/db/mysql/querydefs.php(3386)
#4 vB_dB_MYSQL_QueryDefs->fetchLanguage(array[len:2], vB_Database_MySQLi, false, false) in /core/vb/vb/db/query/method.php(67)
#5 vB_dB_Query_Method->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('fetchLanguage', array[len:2]) in /core/vb/vb/language.php(52)
#7 vB_Language::getPhraseInfo(2) in /core/vb/vb/session.php(877)
#8 vB_Session->loadLanguage() in /core/vb/vb/session.php(955)
#9 vB_Session->fetch_userinfo() in /core/vb/vb.php(960)
#10 vB::setCurrentSession(vB_Session_WebApi) in /core/vb/vb/request.php(173)
#11 vB_Request->setSession(vB_Session_WebApi) in /core/vb/vb/request/webapi.php(56)
#12 vB_Request_WebApi->createSessionNew('d6bae9b5b3[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#13 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#14 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#15 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #6

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1696)
#9 vB5_Route::fetchCommonRoutes() in /core/vb/vb/api/route.php(87)
#10 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #7

				SELECT routenew.*
				FROM routenew AS routenew
				WHERE routenew.prefix IN ('forum/fórum-de-traders/forex/234796-eur-usd','forum/fórum-de-traders/forex','forum/fórum-de-traders','forum') OR ishomeroute = 1
			
/**get_best_routes**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewindex_mergeprefix,ishomerouteprefix,ishomeroute802,2 7Using sort_union(prefix,ishomeroute); Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:241]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in /core/vb/vb/api/route.php(127)
#6 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#7 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #8

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/usercontext.php(141)
#9 vB_UserContext->reloadUserPerms() in /core/vb/vb/usercontext.php(114)
#10 vB_UserContext->__construct(0, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:8]) in /core/vb/vb.php(910)
#11 vB::getUserContext(0) in /core/vb/vb/library/user.php(32)
#12 vB_Library_User->isBanned('0') in /core/vb/vb/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in /core/vb/vb/api/route.php(153)
#14 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #9

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/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1], true, true) in /core/vb/vb/types.php(190)
#9 vB_Types->loadTypes() in /core/vb/vb/types.php(158)
#10 vB_Types->__construct() in /core/vb/vb/types.php(174)
#11 vB_Types::instance() in /core/vb/vb/library/content.php(149)
#12 vB_Library_Content->__construct() in /core/vb/vb/library.php(46)
#13 vB_Library::instance('Content_Channel') in /core/vb5/route/conversation.php(29)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#17 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('node_234785_lvl3data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in /core/vb/vb/library/content.php(2605)
#10 vB_Library_Content->getRawContent(array[len:1]) in /core/vb/vb/library/content.php(2547)
#11 vB_Library_Content->getBareContent(array[len:1]) in /core/vb/vb/library/content/channel.php(428)
#12 vB_Library_Content_Channel->getBareContent(234785) in /core/vb5/route/conversation.php(29)
#13 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#16 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #11

SELECT * FROM cache
 WHERE `cacheid` IN ('node_234796_lvl1data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/vb/library/node.php(904)
#10 vB_Library_Node->getNodeBare('234796') in /core/vb5/route/conversation.php(85)
#11 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#14 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #12

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/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:518]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in /core/vb/vb/library/content/channel.php(963)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/vb/api/content/channel.php(156)
#8 vB_Api_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in /core/vb/vb/library/node.php(2442)
#9 vB_Library_Node->fetchAlbumChannel() in /core/vb/vb/api/node.php(2206)
#10 vB_Api_Node->fetchAlbumChannel('234796') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetchAlbumChannel', array[len:1]) in /core/vb5/route/conversation.php(103)
#12 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#15 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #13

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1309)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(1191)
#10 vB5_Route::getRouteByIdent('265') in /core/vb5/route.php(1336)
#11 vB5_Route::getClassName('265', array[len:14]) in /core/vb5/route.php(1408)
#12 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(214)
#13 vB5_Route_Conversation::getChannelURL(234785, array[len:6]) in /core/vb5/route/conversation.php(488)
#14 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#15 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(132)
#16 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#19 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #14

SELECT * FROM routenew
 WHERE `routeid` = 265 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent('265') in /core/vb5/route.php(1336)
#9 vB5_Route::getClassName('265', array[len:14]) in /core/vb5/route.php(1408)
#10 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(214)
#11 vB5_Route_Conversation::getChannelURL(234785, array[len:6]) in /core/vb5/route/conversation.php(488)
#12 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#13 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(132)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#17 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #15

				SELECT parent AS channelid FROM closure AS cl
				INNER JOIN channel AS ch ON ch.nodeid = cl.parent
				WHERE cl.child = 234785
				ORDER BY depth ASC LIMIT 1
				
/**getNearestChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childchild4const4Using where; Using index
1SIMPLEcheq_refPRIMARYPRIMARY4brazilforum_new.cl.parent1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:192]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getNearestChannel', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#6 vB_dB_Assertor->getRow('getNearestChannel', array[len:2]) in /core/vb/vb/permissioncontext.php(742)
#7 vB_PermissionContext->getChannelid(234785) in /core/vb/vb/usercontext.php(932)
#8 vB_UserContext->getChannelIdOfNode(234785) in /core/vb/vb/usercontext.php(851)
#9 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 234785) in /core/vb5/route/channel.php(21)
#10 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#11 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(214)
#12 vB5_Route_Conversation::getChannelURL(234785, array[len:6]) in /core/vb5/route/conversation.php(488)
#13 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#14 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(132)
#15 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#16 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#17 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#18 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #16

SELECT * FROM cache
 WHERE `cacheid` IN ('node_234785_lvl1data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/vb/library/node.php(904)
#10 vB_Library_Node->getNodeBare('234785') in /core/vb/vb/permissioncontext.php(777)
#11 vB_PermissionContext->getChannelPermissiongroupPermissives(array[len:1], 'forumpermissions', '234785') in /core/vb/vb/permissioncontext.php(835)
#12 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', 234785) in /core/vb/vb/permissioncontext.php(1017)
#13 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', 234785) in /core/vb/vb/usercontext.php(873)
#14 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 234785) in /core/vb5/route/channel.php(21)
#15 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#16 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(214)
#17 vB5_Route_Conversation::getChannelURL(234785, array[len:6]) in /core/vb5/route/conversation.php(488)
#18 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#19 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(132)
#20 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#21 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#22 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#23 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#24 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#25 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#26 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#27 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #17

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:59]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1], true, false) in /core/vb/vb/permissioncontext.php(1089)
#9 vB_PermissionContext->loadChannelPermissions(1) in /core/vb/vb/permissioncontext.php(795)
#10 vB_PermissionContext->getChannelPermissiongroupPermissives(array[len:1], 'forumpermissions', '234785') in /core/vb/vb/permissioncontext.php(835)
#11 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', 234785) in /core/vb/vb/permissioncontext.php(1017)
#12 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', 234785) in /core/vb/vb/usercontext.php(873)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 234785) in /core/vb5/route/channel.php(21)
#14 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#15 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(214)
#16 vB5_Route_Conversation::getChannelURL(234785, array[len:6]) in /core/vb5/route/conversation.php(488)
#17 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#18 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(132)
#19 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1', '') in /core/vb5/route.php(1168)
#20 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#21 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#22 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#23 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#24 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#25 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#26 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #18

				SELECT parent AS channelid FROM closure AS cl
				INNER JOIN channel AS ch ON ch.nodeid = cl.parent
				WHERE cl.child = 234796
				ORDER BY depth ASC LIMIT 1
				
/**getNearestChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childchild4const5Using where; Using index
1SIMPLEcheq_refPRIMARYPRIMARY4brazilforum_new.cl.parent1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:192]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getNearestChannel', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#6 vB_dB_Assertor->getRow('getNearestChannel', array[len:2]) in /core/vb/vb/permissioncontext.php(742)
#7 vB_PermissionContext->getChannelid('234796') in /core/vb/vb/usercontext.php(932)
#8 vB_UserContext->getChannelIdOfNode('234796') in /core/vb/vb/usercontext.php(851)
#9 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '234796', false, '234785') in /core/vb/vb/library/content.php(4564)
#10 vB_Library_Content->validate(array[len:59], 3, array[len:1], array[len:1]) in /core/vb5/route/conversation.php(195)
#11 vB5_Route_Conversation->checkRoutePermissions() in /core/vb5/route.php(1169)
#12 vB5_Route::checkRoute(array[len:14], 'forum/fór[len:179]', 'forum/fór[len:44]', 'explain=1', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/fór[len:44]', 'explain=1', '', array[len:6]) in /core/vb/vb/api/route.php(160)
#14 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #19

SELECT * FROM style
 WHERE `styleid` = 45 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:51]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in /core/vb/vb/library/style.php(700)
#8 vB_Library_Style->fetchStyleByID('45') in /core/vb/vb/api/style.php(59)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchStyleVars', array[len:1]) in /includes/api/interface/collapsed.php(105)
#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 /core/packages/ruforum/hooks.php(321)
#15 ruforum_Hooks::hookGetRouteMain(array[len:4]) in /core/vb/vb/utility/hook/live.php(57)
#16 vB_Utility_Hook_Live->invoke('hookGetRouteMain', array[len:4]) in /core/vb/vb/api/route.php(167)
#17 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #20

SELECT * FROM style
 WHERE `styleid` = 45 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:51]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in /core/packages/ruforum/hooks.php(323)
#8 ruforum_Hooks::hookGetRouteMain(array[len:4]) in /core/vb/vb/utility/hook/live.php(57)
#9 vB_Utility_Hook_Live->invoke('hookGetRouteMain', array[len:4]) in /core/vb/vb/api/route.php(167)
#10 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #21

				SELECT parent AS channelid FROM closure AS cl
				INNER JOIN channel AS ch ON ch.nodeid = cl.parent
				WHERE cl.child = 1
				ORDER BY depth ASC LIMIT 1
				
/**getNearestChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childchild4const1Using where; Using index
1SIMPLEcheq_refPRIMARYPRIMARY4brazilforum_new.cl.parent1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:187]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getNearestChannel', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#6 vB_dB_Assertor->getRow('getNearestChannel', array[len:2]) in /core/vb/vb/permissioncontext.php(742)
#7 vB_PermissionContext->getChannelid('1') in /core/vb/vb/usercontext.php(932)
#8 vB_UserContext->getChannelIdOfNode('1') in /core/vb/vb/usercontext.php(851)
#9 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/vb/api/route.php(216)
#10 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #22

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/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/vb/library/node.php(904)
#10 vB_Library_Node->getNodeBare('1') in /core/vb/vb/permissioncontext.php(777)
#11 vB_PermissionContext->getChannelPermissiongroupPermissives(array[len:1], 'forumpermissions', '1') in /core/vb/vb/permissioncontext.php(835)
#12 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', '1') in /core/vb/vb/permissioncontext.php(1017)
#13 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/vb/usercontext.php(873)
#14 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/vb/api/route.php(216)
#15 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #23

SELECT * FROM routenew
 WHERE `routeid` = 266 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewconstPRIMARYPRIMARY4const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent('266') in /core/vb5/route.php(1336)
#9 vB5_Route::getClassName('266', array[len:14]) in /core/vb5/route.php(1351)
#10 vB5_Route::getRoute('266', array[len:2], array[len:1], '') in /core/vb5/route/conversation.php(614)
#11 vB5_Route_Conversation->getCanonicalRoute() in /core/vb/vb/api/route.php(253)
#12 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #24

SELECT * FROM closure
 WHERE `child` IN (234785) 
 ORDER BY `child` ASC, `depth` ASC
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclosurerefchildchild4const4Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:84]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in /core/vb/vb/library/node.php(3807)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in /core/vb/vb/library/node.php(1018)
#8 vB_Library_Node->getNodeParents(234785) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#11 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#12 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #25

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl1data','node_234783_lvl1data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacherangePRIMARYPRIMARY66 2Using index condition
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:2], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:4]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:4], 1) in /core/vb/vb/library/node.php(1055)
#10 vB_Library_Node->getNodes(array[len:4]) in /core/vb5/route.php(362)
#11 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#12 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#13 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#14 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#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(117)

SQL Query #26

SELECT * FROM routenew
 WHERE `routeid` IN (54,261,265)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewrangePRIMARYPRIMARY4 3Using where
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:56]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(1289)
#7 vB5_Route::preloadRoutes(array[len:3]) in /core/vb5/route.php(376)
#8 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#10 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#11 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#14 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#15 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #27

				SELECT parent AS channelid FROM closure AS cl
				INNER JOIN channel AS ch ON ch.nodeid = cl.parent
				WHERE cl.child = 2
				ORDER BY depth ASC LIMIT 1
				
/**getNearestChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childchild4const2Using where; Using index
1SIMPLEcheq_refPRIMARYPRIMARY4brazilforum_new.cl.parent1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:187]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getNearestChannel', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#6 vB_dB_Assertor->getRow('getNearestChannel', array[len:2]) in /core/vb/vb/permissioncontext.php(742)
#7 vB_PermissionContext->getChannelid(2) in /core/vb/vb/usercontext.php(932)
#8 vB_UserContext->getChannelIdOfNode(2) in /core/vb/vb/usercontext.php(851)
#9 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb5/route/channel.php(21)
#10 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#11 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#12 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#13 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#14 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#15 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #28

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl3data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:60]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in /core/vb/vb/library/content.php(2605)
#10 vB_Library_Content->getRawContent(array[len:1]) in /core/vb/vb/library/content.php(2547)
#11 vB_Library_Content->getBareContent(array[len:1]) in /core/vb/vb/library/content/channel.php(428)
#12 vB_Library_Content_Channel->getBareContent(2) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#18 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #29

				SELECT parent AS channelid FROM closure AS cl
				INNER JOIN channel AS ch ON ch.nodeid = cl.parent
				WHERE cl.child = 234783
				ORDER BY depth ASC LIMIT 1
				
/**getNearestChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childchild4const3Using where; Using index
1SIMPLEcheq_refPRIMARYPRIMARY4brazilforum_new.cl.parent1Using index
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:192]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getNearestChannel', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#6 vB_dB_Assertor->getRow('getNearestChannel', array[len:2]) in /core/vb/vb/permissioncontext.php(742)
#7 vB_PermissionContext->getChannelid(234783) in /core/vb/vb/usercontext.php(932)
#8 vB_UserContext->getChannelIdOfNode(234783) in /core/vb/vb/usercontext.php(851)
#9 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 234783) in /core/vb5/route/channel.php(21)
#10 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#11 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#12 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#13 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#14 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#15 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #30

SELECT * FROM cache
 WHERE `cacheid` IN ('node_234783_lvl3data')
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in /core/vb/vb/library/content.php(2605)
#10 vB_Library_Content->getRawContent(array[len:1]) in /core/vb/vb/library/content.php(2547)
#11 vB_Library_Content->getBareContent(array[len:1]) in /core/vb/vb/library/content/channel.php(428)
#12 vB_Library_Content_Channel->getBareContent(234783) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(234785) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route.php(418)
#17 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#18 vB_Api_Route->getRoute('forum/fór[len:44]', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(117)

SQL Query #31

SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2346)
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

				

				
				

					
SQL Query #32

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #33

					
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_type577 6Using index condition

					
					

				

				
				

					
SQL Query #34

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #35

					
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_type577 6Using index condition

					
					

				

				
				

					
SQL Query #36

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #37

					
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_type577 6Using index condition

					
					

				

				
				

					
SQL Query #38

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #39

					
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_type577 6Using index condition

					
					

				

				
				

					
SQL Query #40

					
SELECT * FROM cache
 WHERE `cacheid` IN ('vbPre_conversation266.180.234785.234796') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #41

					
UPDATE session SET `wol`='a:3:{s:6:\"action\";s:15:\"viewing_topic_x\";s:6:\"params\";a:2:{i:0;s:7:\"Eur/usd\";i:1;s:82:\"https://investsocial.com/pt/forum/fórum-de-traders/forex/234796-eur-usd?explain=1\";}s:6:\"nodeid\";s:6:\"234796\";}',`pagekey`='conversation266.180.234785.234796',`location`='/forum/fórum-de-traders/forex/234796-eur-usd?explain=1' 
 WHERE (`sessionhash` = 'd6bae9b5b3c97546ca653d8e6a7d084c') 
/**session**/

					
					
					

				

				
				

					
SQL Query #42

					
				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 = 180
			
/**fetch_page_pagetemplate_screenlayout**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #43

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 6Using index condition

					
					

				

				
				

					
SQL Query #44

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

					
					

				

				
				

					
SQL Query #45

					
SELECT * FROM post_uses_gpt

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_uses_gptALL    1 

					
					

				

				
				

					
SQL Query #46

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2222) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #47

					
SELECT * FROM widgetinstance
 WHERE `pagetemplateid` IN (4,-1) 
 ORDER BY `containerinstanceid`,`displaysection`,`displayorder`

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetinstancerangepagetemplateidpagetemplateid4 4Using index condition; Using filesort

					
					

				

				
				

					
SQL Query #48

					
				SELECT widgetdefinition.*, widget.template
				FROM widgetdefinition AS widgetdefinition
				JOIN widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
				WHERE widgetdefinition.widgetid IN(8,36,56)
			
/**getWidgetdefinition**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetdefinitionrangewidgetidwidgetid4 17Using index condition
1SIMPLEwidgeteq_refPRIMARYPRIMARY4brazilforum_new.widgetdefinition.widgetid1 

					
					

				

				
				

					
SQL Query #49

					
SELECT * FROM widgetinstance
 WHERE `widgetinstanceid` IN (22,20,21) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetinstancerangePRIMARYPRIMARY4 3Using where

					
					

				

				
				

					
SQL Query #50

					
SELECT * FROM widget
 WHERE `widgetid` IN (0,8,36,56) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEwidgetrangePRIMARYPRIMARY4 4Using where

					
					

				

				
				

					
SQL Query #51

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorrefuserid_nodeiduserid_nodeid4const1Using index

					
					

				

				
				

					
SQL Query #52

					
SELECT * FROM datastore
 WHERE `title` IN ('vBUgChannelAccessG1','attachmentcache') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY150 2Using index condition

					
					

				

				
				

					
SQL Query #53

					
SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 22 AND `nodeid` = 234785 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #54

					
SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 20 AND `nodeid` = 234785 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #55

					
SELECT * FROM widgetchannelconfig
 WHERE `widgetinstanceid` = 21 AND `nodeid` = 234785 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #56

					
SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('widget_conversationdisplay_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_type577 15Using index condition

					
					

				

				
				

					
SQL Query #57

					
SELECT * FROM pagetemplate
 WHERE `pagetemplateid` = 4 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpagetemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #58

					
SELECT * FROM screenlayout
 WHERE `screenlayoutid` = 1 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEscreenlayoutconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #59

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2312,2225,2300) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #60

					
SELECT * FROM seotags WHERE nodeid = '234796'

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #61

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #62

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclosurerefchildchild4const5Using where

					
					

				

				
				

					
SQL Query #63

					
SELECT * FROM datastore
 WHERE `title` IN ('attachmentcache') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreconstPRIMARYPRIMARY150const1 

					
					

				

				
				

					
SQL Query #64

					
SELECT * FROM datastore
 WHERE `title` IN ('attachmentcache') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastoreconstPRIMARYPRIMARY150const1 

					
					

				

				
				

					
SQL Query #65

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 51Using index condition

					
					

				

				
				

					
SQL Query #66

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #67

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #68

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #69

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEcustomavatarconstPRIMARYPRIMARY4const1 
1SIMPLEavatarconstPRIMARYPRIMARY2const0Unique row not found

					
					

				

				
				

					
SQL Query #70

					
SELECT * FROM routenew
 WHERE `class` IN ('vB5_Route_Conversation','vB5_Route_Article') AND `contentid` = 234785 AND `redirect301` IS NULL  
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewrangeroute_class_cidroute_class_cid407 2Using index condition; Using where

					
					

				

				
				

					
SQL Query #71

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2029,2424,1907,2399,2238,2406,2338) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 7Using index condition

					
					

				

				
				

					
SQL Query #72

					
SELECT * FROM loginlibrary
 WHERE `productid` = 'twitterlogin' 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEloginlibraryconstproductidproductid102const1 

					
					

				

				
				

					
SQL Query #73

					
SELECT * FROM loginlibrary
 WHERE `productid` = 'googlelogin' 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEloginlibraryconstproductidproductid102const1 

					
					

				

				
				

					
SQL Query #74

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #75

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #76

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #77

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2184,2425,1471,1476,2275) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 5Using index condition

					
					

				

				
				

					
SQL Query #78

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #79

					
				SELECT *
				FROM profilefield
				WHERE editable > 0 AND required <> 0
				ORDER BY displayorder
/**user_fetchprofilefieldsforregistration**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEprofilefieldALLeditable   7Using where; Using filesort

					
					

				

				
				

					
SQL Query #80

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2286,1736) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #81

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #82

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2174) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #83

					
SELECT `noticeid` FROM noticedismissed
 WHERE `userid` = 0 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoticedismissedrefuseriduserid4const1 

					
					

				

				
				

					
SQL Query #84

					
SELECT * FROM phrase
 WHERE `varname` = 'notice_1_html' AND `languageid` IN (-1,2) 
 ORDER BY `languageid` DESC
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 2Using where

					
					

				

				
				

					
SQL Query #85

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2226) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #86

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2227) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #87

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1933,2267) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #88

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #89

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2329) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #90

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2258) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #91

					
SELECT * FROM searchlog
 WHERE `searchhash` IN ('9b67ab8fcf8f15a396ef2d759708324a') AND `userid` = 0  AND `dateline` >= 1787559775  AND `sortby` = 'isstarter'  AND `sortorder` = 'desc'  
 ORDER BY `dateline` DESC

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchlogrefsearch,userfloodcheck,datelinesearch195const,const,const,const2Using index condition; Using where; Using filesort

					
					

				

				
				

					
SQL Query #92

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #93

					
			SELECT node.nodeid, IF(node.nodeid = node.starter, 1, 0) as isstarter, node.nodeid AS nodeid2
			FROM node as node
			
			JOIN closure AS closure  ON node.nodeid = closure.child  
				 LEFT JOIN node AS starter ON starter.nodeid = node.starter

			WHERE closure.parent = '234796' AND 
				closure.depth <= 1 AND 
				node.inlist = 1 AND 
				node.protected <> '1'
AND (node.public_preview = 1 OR  ( ( (  (starter.parentid IN (1,2,3,6,13,234783,7,8,9,12,234785,234786,234787,234788,234789,234790,234791,234792,234793,234794) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
 OR starter.parentid = 9 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (1,2,3,6,13,234783,7,8,9,12,234785,234786,234787,234788,234789,234790,234791,234792,234793,234794))))

 
			ORDER BY isstarter DESC,node.created ASC,nodeid2 ASC
			
			
/**getSearchResults**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclosurerefclosure_uniq,parent_2,childclosure_uniq4const1Using where; Using temporary; Using filesort
1SIMPLEnodeeq_refPRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,ppreview,node_inlistPRIMARY4brazilforum_new.closure.child1Using where
1SIMPLEstartereq_refPRIMARY,nodeidPRIMARY4brazilforum_new.node.starter1Using where

					
					

				

				
				

					
SQL Query #94

					
			REPLACE INTO searchlog
				(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
			VALUES
				('0','0','65.21.153.82','9b67ab8fcf8f15a396ef2d759708324a','isstarter','desc','0.0026161670684814','1787559835','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"234796\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','234796','1')
		

					
					
					

				

				
				

					
SQL Query #95

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsearchlogconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #96

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #97

					
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_type577 6Using index condition

					
					

				

				
				

					
SQL Query #98

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #99

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childclosure_uniq4const1Using index
1SIMPLEaeq_refPRIMARYPRIMARY4brazilforum_new.cl.child1Using index

					
					

				

				
				

					
SQL Query #100

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrefclosure_uniq,parent_2,childclosure_uniq4const1Using index
1SIMPLEchildrefnode_ctypid_userid_dispo_idx,nodeidnodeid6brazilforum_new.cl.child,const1Using index

					
					

				

				
				

					
SQL Query #101

					
SELECT * FROM datastore
 WHERE `title` IN ('vBNodevoteMetadata','attachmentcache') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY150 2Using index condition

					
					

				

				
				

					
SQL Query #102

					
SELECT * FROM nodevoteaggregate
 WHERE `nodeid` IN (234796) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodevoteaggregaterefPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #103

					
SELECT * FROM thread
 WHERE `nodeid` = 234796 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #104

					
SELECT * FROM channel
 WHERE `nodeid` = 234785 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEchannelconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #105

					
        SELECT DISTINCT user.username,user.userid
FROM session AS session LEFT JOIN user AS user ON session.userid = user.userid
WHERE user.userid>0 AND session.lastactivity>1787555335 AND session.userid > 0 AND session.location LIKE '/0%'
        

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrangelast_activity,user_activity,idx_lastactivity,idx_userididx_userid4 1Using index condition; Using where; Using temporary
1SIMPLEusereq_refPRIMARYPRIMARY4brazilforum_new.session.userid1 

					
					

				

				
				

					
SQL Query #106

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2186,2098,2373,2160) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 4Using index condition

					
					

				

				
				

					
SQL Query #107

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2187,2179) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #108

					
SELECT nodeid FROM node WHERE showpublished = 1 AND starter=234796 AND starter=parentid AND publishdate>1787473435 AND contenttypeid IN(20,21) GROUP BY nodeid ORDER BY votes DESC LIMIT 6
/**topPostIds**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderef|filternode_pubdate,node_starter,node_ctypid_userid_dispo_idx,contenttypeid_parentid,node_parent_lastcontent,node_parent_inlist_lastcontent,node_parent_useridnode_starter|node_parent_userid4|4const1 (0%)Using where; Using filesort; Using rowid filter

					
					

				

				
				

					
SQL Query #109

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2164,2163) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #110

					
SELECT * FROM thread
 WHERE `nodeid` = 234796 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

					
					

				

				
				

					
SQL Query #111

					
SELECT nodeid FROM node WHERE userid=144679 AND parentid=234796 AND nodeid>234796 AND contenttypeid IN (20, 21, 22, 25, 26, 32) AND nodeid<>starter LIMIT 1
/**nextPost**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderefPRIMARY,node_user,node_ctypid_userid_dispo_idx,nodeid,contenttypeid_parentid,node_parent_lastcontent,node_parent_inlist_lastcontent,node_parent_useridnode_parent_lastcontent4const1Using index condition; Using where

					
					

				

				
				

					
SQL Query #112

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2169,2099,1682) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 3Using index condition

					
					

				

				
				

					
SQL Query #113

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #114

					
SELECT count(i.nodeid) as c
                FROM infraction AS i
                WHERE i.expires <> 0 AND i.action = 0 AND i.infracteduserid = 144679
/**getActionInfractionsCount**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEirefexpires,useriduserid6const,const1Using where

					
					

				

				
				

					
SQL Query #115

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2192,2097,2263,2381) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 4Using index condition

					
					

				

				
				

					
SQL Query #116

					
				SELECT avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.extension AS avatarextension, customavatar.filedata_thumb, sigpicnew.userid AS sigpic, sigpicnew.filedataid AS sigpicfiledataid, sigpicfiledata.dateline AS sigpicdateline, sigpicfiledata.width AS sigpicwidth, sigpicfiledata.height AS sigpicheight,
					userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
					IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
				FROM user AS user
				LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
				LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN sigpicnew AS sigpicnew ON (user.userid = sigpicnew.userid)
LEFT JOIN filedata AS sigpicfiledata ON (sigpicnew.filedataid = sigpicfiledata.filedataid)
					WHERE user.userid IN (144679)
			
/** fetchUserinfo**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserconstPRIMARYPRIMARY4const1 
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 
1SIMPLEusertextfieldconstPRIMARYPRIMARY4const1 
1SIMPLEavatarconstPRIMARYPRIMARY2const0Unique row not found
1SIMPLEcustomavatarconstPRIMARYPRIMARY4const1 
1SIMPLEsigpicnewconstPRIMARYPRIMARY4const0Unique row not found
1SIMPLEsigpicfiledataconstPRIMARY   1 

					
					

				

				
				

					
SQL Query #117

					
SELECT * FROM userfield
 WHERE `userid` = 144679 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserfieldconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #118

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

					INNER JOIN subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 144679
 UNION  ALL 

					### Users ###
					SELECT follow.displayname AS title, follow.userid AS keyval, 'user' AS sourcetable, IFNULL(follow.lastpost, follow.joindate) AS lastactivity,
					follow.posts as activity, 'Member' AS type,
					0 AS noUnsubscribe
					FROM user AS follow
					INNER JOIN userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 144679
					WHERE ul.type = 'follow' AND ul.friend = 'yes' 
 ORDER BY title ASC LIMIT 100

					
					
					

				

				
				

					
SQL Query #119

					
SELECT COUNT(userfollowing.keyval) AS total
			FROM
			((### All Content ###
					SELECT follow.nodeid AS keyval
					FROM node AS follow
					INNER JOIN subscribediscussion AS sd ON sd.discussionid = follow.nodeid AND sd.userid = 144679) UNION ALL (
					### Users ###
					SELECT follow.userid AS keyval
					FROM user AS follow
					INNER JOIN userlist AS ul ON ul.relationid = follow.userid AND ul.userid = 144679
					WHERE ul.type = 'follow' AND ul.friend = 'yes')
) AS userfollowing

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYALL    2 
2DERIVEDsdrefdiscussionid,userdiscussion_typeuserdiscussion_type4const1Using index
2DERIVEDfolloweq_refPRIMARY,nodeidPRIMARY4brazilforum_new.sd.discussionid1Using index
3UNIONulrefPRIMARY,relationid,useridPRIMARY4const1Using index condition; Using where
3UNIONfolloweq_refPRIMARYPRIMARY4brazilforum_new.ul.relationid1Using index

					
					

				

				
				

					
SQL Query #120

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

			WHERE ul.type = 'follow' AND ul.friend = 'yes'
ORDER BY username ASC
LIMIT 0, 100


					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARYulrefPRIMARY,relationid,useridrelationid6const,const,const1Using index condition; Using temporary; Using filesort
1PRIMARYueq_refPRIMARYPRIMARY4brazilforum_new.ul.userid1 
3DEPENDENT SUBQUERYul2eq_refPRIMARY,relationid,useridPRIMARY9const,brazilforum_new.u.userid,const1Using index condition; Using where
2DEPENDENT SUBQUERYul2eq_refPRIMARY,relationid,useridPRIMARY9const,brazilforum_new.u.userid,const1Using index condition; Using where

					
					

				

				
				

					
SQL Query #121

					
SELECT * FROM userlist
 WHERE `friend` = 'yes' AND `relationid` = 144679 AND `type` = 'follow' 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserlistrefrelationidrelationid6const,const,const1Using index condition

					
					

				

				
				

					
SQL Query #122

					
SELECT count(referrerid) AS referrals
						FROM user
						WHERE referrerid = 144679
/**getReferralsCount**/

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuserrefreferreridreferrerid4const1Using index

					
					

				

				
				

					
SQL Query #123

					
SELECT * FROM node
 WHERE `setfor` = 144679 
 ORDER BY `publishdate` DESC

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnoderefnode_setfor_pubdt_idxnode_setfor_pubdt_idx4const1Using where

					
					

				

				
				

					
SQL Query #124

					
SELECT ifnull(round(sum(summa),0),0) as bonus FROM koeft_bonus_for_post where userid=(144679) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEkoeft_bonus_for_postrefIndex_UserYear,userid_indexIndex_UserYear4const1 

					
					

				

				
				

					
SQL Query #125

					
SELECT ifnull(round(sum(summa),0),0) as bonus FROM koeft_bonus_for_like where userid=(144679) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEkoeft_bonus_for_likerefIndex_UserYear,userid_indexIndex_UserYear4const1 

					
					

				

				
				

					
SQL Query #126

					
SELECT ifnull(round(sum(summa),0),0) as bonus FROM koeft_referrers where userid=(144679)

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEkoeft_referrersrefIndex_UserMonth,userid_indexIndex_UserMonth4const1 

					
					

				

				
				

					
SQL Query #127

					
SELECT ifnull(round(sum(amount),0),0) as bonus FROM forum_bonus where userid=(144679)

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEforum_bonusALL    1Using where

					
					

				

				
				

					
SQL Query #128

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1552,2096) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #129

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (1902,2418,2408,2299) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 4Using index condition

					
					

				

				
				

					
SQL Query #130

					
SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('claim_ban','claim_status_off','claim_status_on','claim_correct','claim_edit_time_limit','cannot_edit_claim','claims_for_bonus','trusted_users_claim','claim_search_text','claim_search_field','claim_claim_post','claim_approved','claim_rejected','claim_preapprove','claim_thread','claim_untrust_user','claim_trust_user','claim_approve_post','claim_reject_post','claim_votes','claim_claims','claim_history','claim_trusted','claim_poor_format','claim_poor_eng','claim_poor_gramm','claim_mean_cont','claim_inac_msg','claim_short_post','claim_copy_post','claim_submit','claim_user_id','claim_username','claim_post_id','claim_post_text','claim_thread_id','claim_thread_title','claim_sort_field','claim_claim_date','claim_post_date','claim_sort_order','claim_go','claim_reset','claim_descending','claim_ascending','claim_time_limit','claim_many_rejects','claim_already','claim_less_words','claim_post_claimed','claim_reclaimed','claim_can_reclaim','claim_reclaim','claim_banned','claim_correct_info','claim_correct_it','claim_choose_reason','claim_not_exist','claim_clean_after_ban','claim_correct_post') AND `languageid` IN (2,0,-1) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 180Using index condition

					
					

				

				
				

					
SQL Query #131

					
SELECT id, status, created_at, try FROM user_claimed_posts WHERE nodeid = '234796' and user_id='144679'

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEuser_claimed_postsrefuser_id_index,nodeiduser_id_index4const1Using where

					
					

				

				
				

					
SQL Query #132

					
SELECT * FROM closure
 WHERE `child` = 234796 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclosurerefchildchild4const5 

					
					

				

				
				

					
SQL Query #133

					
select * from post_currency_data where postid=234796

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_currency_datarefPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #134

					
select * from post_ex_rates where postid=234796

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpost_ex_ratesconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #135

					
/** existingReputation() **/
			SELECT reputationid FROM reputation
				WHERE whoadded = 0 
					AND nodeid = 234796 
					AND reputationid IN (
						SELECT reputationid FROM thanks_ip 
							WHERE ip >= 1091934464 AND ip <= 1091934719
						)
		

					
					
					

				

				
				

					
SQL Query #136

					
SELECT * FROM node
 WHERE `nodeid` = 234796 
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeconstPRIMARY,nodeidPRIMARY4const1 

					
					

				

				
				

					
SQL Query #137

					
SELECT ((SELECT COUNT(DISTINCT whoadded)
			FROM reputation
			WHERE nodeid = 234796 AND whoadded != 0) + (SELECT COUNT(*) FROM reputation WHERE nodeid = 234796 AND whoadded = 0)) AS votecount

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1PRIMARY       No tables used
3SUBQUERY       no matching row in const table
2SUBQUERYreputationrangewhoadded_nodeid,multiwhoadded_nodeid8 3Using where; Using index for group-by (scanning)

					
					

				

				
				

					
SQL Query #138

					
                SELECT COUNT(q.nodeid) as c
                FROM nodequotes AS nq
                INNER JOIN node AS q ON q.nodeid=nq.nodeid
                WHERE q.open=1 and q.showpublished=1 and nq.quoteid = 234796
                LIMIT 100
            

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnqindexPRIMARYPRIMARY8 1Using where; Using index
1SIMPLEqeq_refPRIMARY,nodeidPRIMARY4brazilforum_new.nq.nodeid1Using where

					
					

				

				
				

					
SQL Query #139

					
SELECT * FROM site
 LIMIT 1

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsiteALL    1 

					
					

				

				
				

					
SQL Query #140

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2423,2428) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplaterangePRIMARYPRIMARY4 2Using index condition

					
					

				

				
				

					
SQL Query #141

					
SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('logo','powered_by_vbulletin_title','search','advanced_search','home','Forum','Fórum de Traders','Forex','logging','you_can_also_login_as','login','register','sb_style','article_switch_mode','article_switch_light_mode','logging_in','username','password','remember_me','forgot_password','log_in','Registration','user_name','confirm_password','email','confirm_email','receive_email_from_bulletin_board_staff','privacyconsent_terms','complete_signup','referrer','timezone_gmt_minus_1200','timezone_gmt_minus_1100','timezone_gmt_minus_1000','timezone_gmt_minus_0930','timezone_gmt_minus_0900','timezone_gmt_minus_0800','timezone_gmt_minus_0700','timezone_gmt_minus_0600','timezone_gmt_minus_0500','timezone_gmt_minus_0430','timezone_gmt_minus_0400','timezone_gmt_minus_0330','timezone_gmt_minus_0300','timezone_gmt_minus_0200','timezone_gmt_minus_0100','timezone_gmt_plus_0000','timezone_gmt_plus_0100','timezone_gmt_plus_0200','timezone_gmt_plus_0300','timezone_gmt_plus_0330','timezone_gmt_plus_0400','timezone_gmt_plus_0430','timezone_gmt_plus_0500','timezone_gmt_plus_0530','timezone_gmt_plus_0545','timezone_gmt_plus_0600','timezone_gmt_plus_0630','timezone_gmt_plus_0700','timezone_gmt_plus_0800','timezone_gmt_plus_0830','timezone_gmt_plus_0845','timezone_gmt_plus_0900','timezone_gmt_plus_0930','timezone_gmt_plus_1000','timezone_gmt_plus_1030','timezone_gmt_plus_1100','timezone_gmt_plus_1200','automatically_detect_dst_settings','dst_corrections_always_on','dst_corrections_always_off','new_posts_nav','forumrules','navbar_privacy','navbar_help','calendar','groups','memeber_list','forum_leaders','monitoring','insta_contests','announcement','no_announcement','popular_posts_per_day','expand','collapse','page_title','posts_1','latest_activity','now_online','previous','next','excellent','good','average','bad','terrible','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','threads_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','twitter_tweet','x_is_offline','reputation5','field5_title','join_date','posts','view_profile','find_all_messages','find_all_themes','tags','none','mentions','vote_cap','like_lower','go_to_top','go_to_bottom','navbar_contact_us','forexdengi_thanks','all_times_are_gmt_x_time_now_is_y','working_ellipsis','yes','no','ok','cancel','facebook_language','see_more','select_currencies','hide','display_in_full','comment_login','no_last_post_in_thread','successfully_added_user_to_subscribe_list','successfully_added_user_to_unsubscribe_list','no_quotes_found') AND `languageid` IN (2,0,-1) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 453Using index condition

					
					

				

				
				

					
SQL Query #142

					
SELECT * FROM routenew
 WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','266','profile') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewrangePRIMARYPRIMARY4 2Using where

					
					

				

				
				

					
SQL Query #143

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEpageconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #144

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

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEphraserangename_lang_type,languageidname_lang_type577 6Using index condition

					
					

				

				
				

					
SQL Query #145

					
SELECT * FROM cache
 WHERE `cacheid` IN ('vbnodetext234796_45_2:963474f4a512e7c80c23b609c6e6cefc') 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

					
					

				

				
				

					
SQL Query #146

					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2027) 

					
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEtemplateconstPRIMARYPRIMARY4const1 

					
					

				

				
				

					
SQL Query #147

					
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_type577 75Using index condition

					
					

				

				
5 Slowest Queries

					

						SQL Query #141
						Time Taken: 0.015428066253662
						Memory Used: 0
					


					
SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('logo','powered_by_vbulletin_title','search','advanced_search','home','Forum','Fórum de Traders','Forex','logging','you_can_also_login_as','login','register','sb_style','article_switch_mode','article_switch_light_mode','logging_in','username','password','remember_me','forgot_password','log_in','Registration','user_name','confirm_password','email','confirm_email','receive_email_from_bulletin_board_staff','privacyconsent_terms','complete_signup','referrer','timezone_gmt_minus_1200','timezone_gmt_minus_1100','timezone_gmt_minus_1000','timezone_gmt_minus_0930','timezone_gmt_minus_0900','timezone_gmt_minus_0800','timezone_gmt_minus_0700','timezone_gmt_minus_0600','timezone_gmt_minus_0500','timezone_gmt_minus_0430','timezone_gmt_minus_0400','timezone_gmt_minus_0330','timezone_gmt_minus_0300','timezone_gmt_minus_0200','timezone_gmt_minus_0100','timezone_gmt_plus_0000','timezone_gmt_plus_0100','timezone_gmt_plus_0200','timezone_gmt_plus_0300','timezone_gmt_plus_0330','timezone_gmt_plus_0400','timezone_gmt_plus_0430','timezone_gmt_plus_0500','timezone_gmt_plus_0530','timezone_gmt_plus_0545','timezone_gmt_plus_0600','timezone_gmt_plus_0630','timezone_gmt_plus_0700','timezone_gmt_plus_0800','timezone_gmt_plus_0830','timezone_gmt_plus_0845','timezone_gmt_plus_0900','timezone_gmt_plus_0930','timezone_gmt_plus_1000','timezone_gmt_plus_1030','timezone_gmt_plus_1100','timezone_gmt_plus_1200','automatically_detect_dst_settings','dst_corrections_always_on','dst_corrections_always_off','new_posts_nav','forumrules','navbar_privacy','navbar_help','calendar','groups','memeber_list','forum_leaders','monitoring','insta_contests','announcement','no_announcement','popular_posts_per_day','expand','collapse','page_title','posts_1','latest_activity','now_online','previous','next','excellent','good','average','bad','terrible','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','threads_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','twitter_tweet','x_is_offline','reputation5','field5_title','join_date','posts','view_profile','find_all_messages','find_all_themes','tags','none','mentions','vote_cap','like_lower','go_to_top','go_to_bottom','navbar_contact_us','forexdengi_thanks','all_times_are_gmt_x_time_now_is_y','working_ellipsis','yes','no','ok','cancel','facebook_language','see_more','select_currencies','hide','display_in_full','comment_login','no_last_post_in_thread','successfully_added_user_to_subscribe_list','successfully_added_user_to_unsubscribe_list','no_quotes_found') AND `languageid` IN (2,0,-1) 

				
					

						SQL Query #5
						Time Taken: 0.0089190006256104
						Memory Used: 0
					


					
SELECT phrasegroup_global,
		options AS lang_options,
		languagecode AS lang_code,
		charset AS lang_charset,
		locale AS lang_locale,
		dateoverride AS lang_dateoverride,
		timeoverride AS lang_timeoverride,
		registereddateoverride AS lang_registereddateoverride,
		calformat1override AS lang_calformat1override,
		calformat2override AS lang_calformat2override,
		eventdateformatoverride AS lang_eventdateformatoverride,
		pickerdateformatoverride AS lang_pickerdateformatoverride,
		logdateoverride AS lang_logdateoverride,
		decimalsep AS lang_decimalsep,
		thousandsep AS lang_thousandsep
 FROM language WHERE languageid = 2/* fetchLanguage */

				
					

						SQL Query #140
						Time Taken: 0.00394606590271
						Memory Used: 0
					


					
SELECT `title`,`textonly`,`template_un`,`template` FROM template
 WHERE `templateid` IN (2423,2428) 

				
					

						SQL Query #147
						Time Taken: 0.0036640167236328
						Memory Used: 0
					


					
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) 

				
					

						SQL Query #130
						Time Taken: 0.0028119087219238
						Memory Used: 0
					


					
SELECT `varname`,`languageid`,`text` FROM phrase
 WHERE `varname` IN ('claim_ban','claim_status_off','claim_status_on','claim_correct','claim_edit_time_limit','cannot_edit_claim','claims_for_bonus','trusted_users_claim','claim_search_text','claim_search_field','claim_claim_post','claim_approved','claim_rejected','claim_preapprove','claim_thread','claim_untrust_user','claim_trust_user','claim_approve_post','claim_reject_post','claim_votes','claim_claims','claim_history','claim_trusted','claim_poor_format','claim_poor_eng','claim_poor_gramm','claim_mean_cont','claim_inac_msg','claim_short_post','claim_copy_post','claim_submit','claim_user_id','claim_username','claim_post_id','claim_post_text','claim_thread_id','claim_thread_title','claim_sort_field','claim_claim_date','claim_post_date','claim_sort_order','claim_go','claim_reset','claim_descending','claim_ascending','claim_time_limit','claim_many_rejects','claim_already','claim_less_words','claim_post_claimed','claim_reclaimed','claim_can_reclaim','claim_reclaim','claim_banned','claim_correct_info','claim_correct_it','claim_choose_reason','claim_not_exist','claim_clean_after_ban','claim_correct_post') AND `languageid` IN (2,0,-1) 

				
147 Queries Run : Total SQL time was 0.100786 seconds , Total PHP time was 0.116038 seconds , Overall time was 0.216824 seconds.