vBulletin - Explain SQL Queries (99)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
SET @@sql_mode = ''
- Time Before: 1785148047.3307
- Time After: 1785148047.3312
- Time Taken: 0.0005180835723877
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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)
SELECT * FROM datastore
WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes','locations')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | | 18 | Using index condition |
- Time Before: 1785148047.3335
- Time After: 1785148047.3352
- Time Taken: 0.0016319751739502
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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)
SELECT * FROM session
WHERE `userid` = 0 AND `host` = '65.21.153.82' AND `idhash` = 'ea5a359a73a8141a16de516480d33c34'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | session | ref | user_activity,guest_lookup,idx_userid | guest_lookup | 237 | const,const,const | 1 | Using index condition |
- Time Before: 1785148047.3377
- Time After: 1785148047.3388
- Time Taken: 0.0010559558868408
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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:129]', 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:4], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:4]) in /core/vb/vb/session.php(226)
#8 vB_Session->doRememberMe(array[len:2], false) in /core/vb/vb/session.php(167)
#9 vB_Session->loadExistingSession('', array[len:2], false) in /core/vb/vb/session.php(546)
#10 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '', 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], '', array[len:2], 0, 0, true) in /core/vb/vb/session/webapi.php(75)
#12 vB_Session_WebApi::createSessionNew('', array[len:2], true) in /core/vb/vb/request/webapi.php(55)
#13 vB_Request_WebApi->createSessionNew('', 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)
SELECT * FROM cache
WHERE `cacheid` IN ('651f0d810ec99d7e96e640185e3b1fea')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.3391
- Time After: 1785148047.3394
- Time Taken: 0.0003361701965332
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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('', 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)
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 */
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | language | const | PRIMARY | PRIMARY | 2 | const | 1 | |
- Time Before: 1785148047.3396
- Time After: 1785148047.3505
- Time Taken: 0.010951995849609
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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('', 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)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_CommonRoutes')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3591
- Time After: 1785148047.3599
- Time Taken: 0.00084185600280762
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_UserPerms0')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3604
- Time After: 1785148047.3608
- Time Taken: 0.00044488906860352
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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() in /core/vb5/route/channel.php(21)
#12 vB5_Route_Channel->__construct(array[len:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#13 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') in /core/vb/vb/api/wrapper.php(205)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(117)
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**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cl | ref | closure_uniq,parent_2,child | child | 4 | const | 2 | Using where; Using index |
| 1 | SIMPLE | ch | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.cl.parent | 1 | Using index |
- Time Before: 1785148047.3611
- Time After: 1785148047.3618
- Time Taken: 0.00062394142150879
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#11 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('vb_types.types')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3622
- Time After: 1785148047.3626
- Time Taken: 0.00042295455932617
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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/node.php(60)
#12 vB_Library_Node->__construct() in /core/vb/vb/library.php(46)
#13 vB_Library::instance('node') in /core/vb/vb/permissioncontext.php(777)
#14 vB_PermissionContext->getChannelPermissiongroupPermissives(array[len:1], 'forumpermissions', '2') in /core/vb/vb/permissioncontext.php(835)
#15 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', 2) in /core/vb/vb/permissioncontext.php(1017)
#16 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb/vb/usercontext.php(873)
#17 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb5/route/channel.php(21)
#18 vB5_Route_Channel->__construct(array[len:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#19 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM node
WHERE `nodeid` = 2
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | node | const | PRIMARY,nodeid | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3634
- Time After: 1785148047.364
- Time Taken: 0.00056791305541992
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#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:48]', 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:node', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:node', array[len:2]) in /core/vb/vb/library/node.php(912)
#8 vB_Library_Node->getNodeBare('2') in /core/vb/vb/permissioncontext.php(777)
#9 vB_PermissionContext->getChannelPermissiongroupPermissives(array[len:1], 'forumpermissions', '2') in /core/vb/vb/permissioncontext.php(835)
#10 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', 2) in /core/vb/vb/permissioncontext.php(1017)
#11 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb/vb/usercontext.php(873)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb5/route/channel.php(21)
#13 vB5_Route_Channel->__construct(array[len:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#14 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('channelperms_1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3645
- Time After: 1785148047.365
- Time Taken: 0.00048613548278809
- Memory Before: 2097152
- Memory After: 4194304
- Memory Used: 2097152
#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', '2') in /core/vb/vb/permissioncontext.php(835)
#11 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', 2) in /core/vb/vb/permissioncontext.php(1017)
#12 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb/vb/usercontext.php(873)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 2) in /core/vb5/route/channel.php(21)
#14 vB5_Route_Channel->__construct(array[len:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#15 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('node_2_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3654
- Time After: 1785148047.3658
- Time Taken: 0.00034594535827637
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#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:15], array[len:1], 'do=gridmen[len:33]', '') in /core/vb/vb/api/route.php(110)
#14 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM style
WHERE `styleid` = 45
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | |
- Time Before: 1785148047.3676
- Time After: 1785148047.3689
- Time Taken: 0.0013329982757568
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#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', 'do=gridmen[len:33]') 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)
SELECT * FROM style
WHERE `styleid` = 45
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | |
- Time Before: 1785148047.3714
- Time After: 1785148047.3736
- Time Taken: 0.0021860599517822
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#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', 'do=gridmen[len:33]') 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)
SELECT * FROM channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | channel | ALL | guid | | | | 67 | Using where |
- Time Before: 1785148047.3744
- Time After: 1785148047.3753
- Time Taken: 0.0008690357208252
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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/library/content/channel.php(986)
#8 vB_Library_Content_Channel->fetchChannelIdByGUID('vbulletin-[len:33]') in /core/vb/vb/api/content/channel.php(168)
#9 vB_Api_Content_Channel->fetchChannelIdByGUID('vbulletin-[len:33]') in /core/vb/vb/api/route.php(215)
#10 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
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**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cl | ref | closure_uniq,parent_2,child | child | 4 | const | 1 | Using where; Using index |
| 1 | SIMPLE | ch | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.cl.parent | 1 | Using index |
- Time Before: 1785148047.3755
- Time After: 1785148047.3762
- Time Taken: 0.00074315071105957
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('node_1_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3764
- Time After: 1785148047.3768
- Time Taken: 0.00041794776916504
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('node_2_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3769
- Time After: 1785148047.3773
- Time Taken: 0.00035905838012695
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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(2) in /core/vb5/route/channel.php(424)
#11 vB5_Route_Channel->getCanonicalRoute() in /core/vb/vb/api/route.php(253)
#12 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_NamedRoutes')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3774
- Time After: 1785148047.3782
- Time Taken: 0.00079798698425293
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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('54') in /core/vb5/route.php(1336)
#11 vB5_Route::getClassName('54', array[len:14]) in /core/vb5/route.php(1351)
#12 vB5_Route::getRoute('54', array[len:0], array[len:3]) in /core/vb5/route/channel.php(432)
#13 vB5_Route_Channel->getCanonicalRoute() in /core/vb/vb/api/route.php(253)
#14 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM routenew
WHERE `routeid` = 54
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3792
- Time After: 1785148047.3797
- Time Taken: 0.00054097175598145
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:54]', 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('54') in /core/vb5/route.php(1336)
#9 vB5_Route::getClassName('54', array[len:14]) in /core/vb5/route.php(1351)
#10 vB5_Route::getRoute('54', array[len:0], array[len:3]) in /core/vb5/route/channel.php(432)
#11 vB5_Route_Channel->getCanonicalRoute() in /core/vb/vb/api/route.php(253)
#12 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') 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)
SELECT * FROM closure
WHERE `child` IN (2)
ORDER BY `child` ASC, `depth` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | closure | ref | child | child | 4 | const | 2 | Using where |
- Time Before: 1785148047.3803
- Time After: 1785148047.3808
- Time Taken: 0.00049114227294922
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:79]', 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(2) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(2) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#11 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#12 vB5_Route->getBreadcrumbs() in /core/vb/vb/api/route.php(316)
#13 vB_Api_Route->getRoute('forum', 'do=gridmen[len:33]') in /core/vb/vb/api/wrapper.php(205)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(117)
SELECT * FROM routenew
WHERE `routeid` IN (54)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.381
- Time After: 1785148047.3814
- Time Taken: 0.00046515464782715
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:48]', 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:1]) in /core/vb5/route.php(376)
#8 vB5_Route->addParentNodeBreadcrumbs(2) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#10 vB5_Route_Channel->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', 'do=gridmen[len:33]') 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)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2346)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3828
- Time After: 1785148047.3832
- Time Taken: 0.00037407875061035
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled', false) in /core/vb/vb/library/template.php(50)
#9 vB_Library_Template->fetch('preheader', 45) in /core/vb/vb/api/template.php(57)
#10 vB_Api_Template->fetch('preheader', 45) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('preheader') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('preheader') in /includes/vb5/template.php(396)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#17 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM page
WHERE `pageid` = 3
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3861
- Time After: 1785148047.3867
- Time Taken: 0.0005640983581543
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:48]', 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('page', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(113)
#11 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#12 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#15 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.3869
- Time After: 1785148047.3879
- Time Taken: 0.00099492073059082
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `va[len:175]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(113)
#13 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#17 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM page
WHERE `pageid` = 23
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3882
- Time After: 1785148047.3886
- Time Taken: 0.00039815902709961
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:49]', 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('page', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(114)
#11 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#12 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#15 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.3887
- Time After: 1785148047.3897
- Time Taken: 0.00093507766723633
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `va[len:175]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(114)
#13 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#17 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM page
WHERE `pageid` = 6
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3898
- Time After: 1785148047.3901
- Time Taken: 0.00029802322387695
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:48]', 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('page', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(115)
#11 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#12 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#15 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.3902
- Time After: 1785148047.391
- Time Taken: 0.0007939338684082
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `va[len:175]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(115)
#13 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#17 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM page
WHERE `pageid` = 5
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3912
- Time After: 1785148047.3915
- Time Taken: 0.00034618377685547
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:48]', 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('page', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#10 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(116)
#11 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#12 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#13 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#14 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#15 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.3916
- Time After: 1785148047.3925
- Time Taken: 0.00092411041259766
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `va[len:175]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1418)
#12 vB5_Route::buildUrl(array[len:2]) in /includes/vb5/template/phrase.php(116)
#13 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:1423]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:1423]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/applicationabstract.php(796)
#16 vB5_ApplicationAbstract::getPreheader() in /includes/vb5/frontend/controller/page.php(60)
#17 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vbPre_channel54.39.2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.3952
- Time After: 1785148047.3957
- Time Taken: 0.00055718421936035
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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/page.php(40)
#9 vB_Library_Page->preload('channel54.39.2') in /core/vb/vb/api/page.php(1442)
#10 vB_Api_Page->preload('channel54.39.2') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('preload', array[len:1]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('page', 'preload', array[len:1]) in /includes/vb5/frontend/controller/page.php(82)
#13 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
UPDATE session SET `wol`='a:3:{s:6:\"action\";s:15:\"viewing_forum_x\";s:6:\"params\";a:2:{i:0;s:5:\"Forum\";i:1;s:67:\"https://investsocial.com/pt/forum?do=gridmenu&explain=1&querylist=1\";}s:6:\"nodeid\";i:2;}',`pagekey`='channel54.39.2',`location`='/forum?do=gridmenu&explain=1&querylist=1'
WHERE (`sessionhash` = '2ee82cde52cbec889ae4c14f37ada264')
/**session**/
- Time Before: 1785148047.3965
- Time After: 1785148047.3972
- Time Taken: 0.00071287155151367
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(572)
#1 vB_Database->query_write('') in /core/vb/vb/db/query/update.php(103)
#2 vB_dB_Query_Update->doUpdates() in /core/vb/vb/db/query/update.php(88)
#3 vB_dB_Query_Update->execSQL() in /core/vb/vb/db/assertor.php(293)
#4 vB_dB_Assertor->assertQuery('session', array[len:5]) in /core/vb/vb/api/wol.php(60)
#5 vB_Api_Wol->register('viewing_forum_x', array[len:2], 'channel54.39.2', '/forum?do=[len:48]', 2) in /core/vb/vb/api/wrapper.php(205)
#6 vB_Api_Wrapper->__call('register', array[len:5]) in /includes/api/interface/collapsed.php(105)
#7 Api_Interface_Collapsed->callApi('wol', 'register', array[len:5]) in /includes/vb5/frontend/controller/page.php(94)
#8 vB5_Frontend_Controller_Page->index(2, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
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 = 39
/**fetch_page_pagetemplate_screenlayout**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | pagetemplate | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | screenlayout | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.3974
- Time After: 1785148047.3981
- Time Taken: 0.00071907043457031
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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:429]', 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('fetch_page[len:36]', array[len:1]) in /core/vb/vb/api/page.php(61)
#6 vB_Api_Page->fetchPageById(39, array[len:11]) in /core/vb/vb/api/wrapper.php(205)
#7 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#8 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#9 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_69f8957e8f373479173060_title','page_69f8957e8f373479173060_metadesc') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.3983
- Time After: 1785148047.3992
- Time Taken: 0.00084900856018066
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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 `va[len:175]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(919)
#9 vB_Api_Phrase->renderPhrasesInternal(array[len:2], NULL, true) in /core/vb/vb/api/phrase.php(873)
#10 vB_Api_Phrase->renderPhrases(array[len:2]) in /core/vb/vb/api/page.php(73)
#11 vB_Api_Page->fetchPageById(39, array[len:11]) in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM style
WHERE `styleid` = 45
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | style | const | PRIMARY | PRIMARY | 2 | const | 1 | |
- Time Before: 1785148047.3997
- Time After: 1785148047.4015
- Time Taken: 0.0017910003662109
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#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/api/page.php(40)
#8 ruforum_Api_Page->fetchPageById(array[len:24], 39, array[len:11]) in /core/vb/vb/api/wrapper.php(223)
#9 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#11 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('pposts5')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4022
- Time After: 1785148047.4027
- Time Taken: 0.00050711631774902
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:52]', 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/packages/ruforum/api/popular.php(189)
#9 ruforum_Api_Popular->getCachedOrFetchPposts(array[len:24], array[len:11]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('getCachedO[len:22]', array[len:2]) in /core/packages/ruforum/api/page.php(112)
#11 ruforum_Api_Page->fetchPageById(array[len:24], 39, array[len:11]) in /core/vb/vb/api/wrapper.php(223)
#12 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('popular22channel_2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4028
- Time After: 1785148047.4031
- Time Taken: 0.00031089782714844
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:63]', 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/packages/ruforum/api/popular.php(196)
#9 ruforum_Api_Popular->getCachedOrFetchPposts(array[len:24], array[len:11]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('getCachedO[len:22]', array[len:2]) in /core/packages/ruforum/api/page.php(112)
#11 ruforum_Api_Page->fetchPageById(array[len:24], 39, array[len:11]) in /core/vb/vb/api/wrapper.php(223)
#12 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT
n.nodeid
FROM node as n
LEFT JOIN closure as c ON c.child=n.nodeid
WHERE (n.starter=n.nodeid or n.starter=n.parentid)
AND n.open=1
AND n.protected=0
AND n.showpublished=1
AND n.publishdate>=1785133647
AND n.publishdate<=1785148047
AND NOT EXISTS(select c2.parent from closure as c2 where c2.child=n.nodeid and c2.parent in(15,24))
AND n.nodeid NOT IN(15,24)
AND c.parent in(2)
AND n.userid NOT IN('')
GROUP by n.nodeid
ORDER BY RAND()
LIMIT 0, 5
/**getPopularPostsForSidebar**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | n | range | PRIMARY,node_pubdate,node_user,nodeid | node_pubdate | 5 | | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | PRIMARY | c | eq_ref | closure_uniq,parent_2,child | closure_uniq | 8 | const,brazilforum_new.n.nodeid | 1 | Using index |
| 2 | DEPENDENT SUBQUERY | c2 | index_subquery | closure_uniq,parent_2,child | child | 4 | func | 2 | Using index; Using where |
- Time Before: 1785148047.4036
- Time After: 1785148047.405
- Time Taken: 0.0014350414276123
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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\n [len:728]', 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('ruforum:ge[len:33]', array[len:9], false) in /core/vb/vb/db/assertor.php(641)
#6 vB_dB_Assertor->getRows('ruforum:ge[len:33]', array[len:9], false, 'nodeid') in /core/packages/ruforum/api/popular.php(101)
#7 ruforum_Api_Popular->querySidebarPopular(2) in /core/packages/ruforum/api/popular.php(127)
#8 ruforum_Api_Popular->getSidebarPopular(2) in /core/packages/ruforum/api/popular.php(203)
#9 ruforum_Api_Popular->getCachedOrFetchPposts(array[len:24], array[len:11]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('getCachedO[len:22]', array[len:2]) in /core/packages/ruforum/api/page.php(112)
#11 ruforum_Api_Page->fetchPageById(array[len:24], 39, array[len:11]) in /core/vb/vb/api/wrapper.php(223)
#12 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM post_uses_gpt
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | post_uses_gpt | ALL | | | | | 1 | |
- Time Before: 1785148047.4054
- Time After: 1785148047.4057
- Time Taken: 0.00029301643371582
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('') in /core/packages/ruforum/api/postusegpt.php(19)
#2 ruforum_Api_PostUseGpt->readPostsUseGpt() in /core/vb/vb/api/wrapper.php(205)
#3 vB_Api_Wrapper->__call('readPostsUseGpt', array[len:0]) in /core/packages/ruforum/api/page.php(117)
#4 ruforum_Api_Page->fetchPageById(array[len:25], 39, array[len:11]) in /core/vb/vb/api/wrapper.php(223)
#5 vB_Api_Wrapper->__call('fetchPageById', array[len:2]) in /includes/api/interface/collapsed.php(105)
#6 Api_Interface_Collapsed->callApi('page', 'fetchPageById', array[len:2]) in /includes/vb5/frontend/controller/page.php(111)
#7 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2222)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4061
- Time After: 1785148047.4065
- Time Taken: 0.00038504600524902
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled', false) in /core/vb/vb/library/template.php(50)
#9 vB_Library_Template->fetch('screenlayo[len:25]', 45) in /core/vb/vb/api/template.php(57)
#10 vB_Api_Template->fetch('screenlayo[len:25]', 45) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('screenlayo[len:25]') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('screenlayo[len:25]') in /includes/vb5/template.php(396)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#16 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetinstance
WHERE `pagetemplateid` IN (2,-1)
ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetinstance | range | pagetemplateid | pagetemplateid | 4 | | 6 | Using index condition; Using filesort |
- Time Before: 1785148047.4069
- Time After: 1785148047.4075
- Time Taken: 0.00058698654174805
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:127]', 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('widgetinstance', array[len:1], array[len:3]) in /core/vb/vb/api/widget.php(1871)
#7 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#9 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#12 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#13 eval() in /includes/vb5/template.php(404)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT widgetdefinition.*, widget.template
FROM widgetdefinition AS widgetdefinition
JOIN widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
WHERE widgetdefinition.widgetid IN(9,7,36,56,71)
/**getWidgetdefinition**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetdefinition | range | widgetid | widgetid | 4 | | 35 | Using index condition |
| 1 | SIMPLE | widget | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.widgetdefinition.widgetid | 1 | |
- Time Before: 1785148047.4077
- Time After: 1785148047.4091
- Time Taken: 0.0014259815216064
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:251]', 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('getWidgetdefinition', array[len:1]) in /core/vb/vb/api/widget.php(1894)
#6 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#8 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(404)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetinstance
WHERE `widgetinstanceid` IN (15,14,11,12,13)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetinstance | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
- Time Before: 1785148047.4095
- Time After: 1785148047.4099
- Time Taken: 0.00039505958557129
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:75]', 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('widgetinstance', array[len:1], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('widgetinstance', array[len:1], false, 'widgetinstanceid') in /core/vb/vb/api/widget.php(1567)
#8 vB_Api_Widget->fetchWidgetInstances(array[len:5]) in /core/vb/vb/api/widget.php(1923)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widget
WHERE `widgetid` IN (0,9,7,36,56,71)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widget | range | PRIMARY | PRIMARY | 4 | | 6 | Using where |
- Time Before: 1785148047.4101
- Time After: 1785148047.4106
- Time Taken: 0.00044488906860352
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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('widget', array[len:1], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('widget', array[len:1], false, 'widgetid') in /core/vb/vb/api/widget.php(230)
#8 vB_Api_Widget->_fetchAndCacheWidgetsForRender(array[len:6]) in /core/vb/vb/api/widget.php(1927)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT COUNT(*) AS count FROM moderator
WHERE `userid` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | moderator | ref | userid_nodeid | userid_nodeid | 4 | const | 1 | Using index |
- Time Before: 1785148047.4111
- Time After: 1785148047.4115
- Time Taken: 0.00039577484130859
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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 COU[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('vBForum:moderator', array[len:2], false) in /core/vb/vb/db/assertor.php(590)
#7 vB_dB_Assertor->getField('vBForum:moderator', array[len:2]) in /core/vb/vb/usercontext.php(1280)
#8 vB_UserContext->isForumModerator() in /core/vb/vb/usercontext.php(1293)
#9 vB_UserContext->isModerator() in /core/vb/vb/session.php(1204)
#10 vB_Session->validateCpsession() in /core/vb/vb/api.php(771)
#11 vB_Api->hasAdminPermissionInternal('canadminusers') in /core/vb/vb/api.php(757)
#12 vB_Api->hasAdminPermission('canadminusers') in /core/vb/vb/api/usergroup.php(159)
#13 vB_Api_UserGroup->sanitizeUserGroup(array[len:47]) in /core/vb/vb/api/usergroup.php(251)
#14 vB_Api_UserGroup->fetchUsergroupBySystemID(1) in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('fetchUserg[len:24]', array[len:1]) in /core/vb/vb/api/widget.php(1661)
#16 vB_Api_Widget->fetchUsergroupsForModuleViewPerms(0) in /core/vb/vb/api/widget.php(1936)
#17 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#18 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#19 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#20 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#22 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#23 eval() in /includes/vb5/template.php(404)
#24 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#25 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM datastore
WHERE `title` IN ('vBUgChannelAccessG1','attachmentcache')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | datastore | range | PRIMARY | PRIMARY | 150 | | 2 | Using index condition |
- Time Before: 1785148047.4117
- Time After: 1785148047.4121
- Time Taken: 0.00041794776916504
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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('datastore', array[len:1]) in /core/vb/vb/datastore.php(606)
#7 vB_Datastore->do_db_fetch(array[len:2]) in /core/vb/vb/datastore.php(560)
#8 vB_Datastore->fetch(array[len:2]) in /core/vb/vb/datastore.php(179)
#9 vB_Datastore->getValue('vBUgChannelAccessG1') in /core/vb/vb/permissioncontext.php(94)
#10 vB_PermissionContext->getAllChannelAccess(array[len:1]) in /core/vb/vb/usercontext.php(1303)
#11 vB_UserContext->isModerator() in /core/vb/vb/session.php(1204)
#12 vB_Session->validateCpsession() in /core/vb/vb/api.php(771)
#13 vB_Api->hasAdminPermissionInternal('canadminusers') in /core/vb/vb/api.php(757)
#14 vB_Api->hasAdminPermission('canadminusers') in /core/vb/vb/api/usergroup.php(159)
#15 vB_Api_UserGroup->sanitizeUserGroup(array[len:47]) in /core/vb/vb/api/usergroup.php(251)
#16 vB_Api_UserGroup->fetchUsergroupBySystemID(1) in /core/vb/vb/api/wrapper.php(205)
#17 vB_Api_Wrapper->__call('fetchUserg[len:24]', array[len:1]) in /core/vb/vb/api/widget.php(1661)
#18 vB_Api_Widget->fetchUsergroupsForModuleViewPerms(0) in /core/vb/vb/api/widget.php(1936)
#19 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#20 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#21 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#22 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#23 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#24 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#25 eval() in /includes/vb5/template.php(404)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetchannelconfig
WHERE `widgetinstanceid` = 15 AND `nodeid` = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4127
- Time After: 1785148047.4132
- Time Taken: 0.00051593780517578
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:82]', 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('widgetchannelconfig', array[len:3]) in /core/vb/vb/api/widget.php(610)
#7 vB_Api_Widget->fetchChannelConfig(15, 2) in /core/vb/vb/api/widget.php(436)
#8 vB_Api_Widget->fetchConfig(15, 0, '2') in /core/vb/vb/api/widget.php(1944)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetchannelconfig
WHERE `widgetinstanceid` = 14 AND `nodeid` = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4134
- Time After: 1785148047.4139
- Time Taken: 0.0004429817199707
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:82]', 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('widgetchannelconfig', array[len:3]) in /core/vb/vb/api/widget.php(610)
#7 vB_Api_Widget->fetchChannelConfig(14, 2) in /core/vb/vb/api/widget.php(436)
#8 vB_Api_Widget->fetchConfig(14, 0, '2') in /core/vb/vb/api/widget.php(1944)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetchannelconfig
WHERE `widgetinstanceid` = 11 AND `nodeid` = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4141
- Time After: 1785148047.4147
- Time Taken: 0.00055408477783203
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:82]', 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('widgetchannelconfig', array[len:3]) in /core/vb/vb/api/widget.php(610)
#7 vB_Api_Widget->fetchChannelConfig(11, 2) in /core/vb/vb/api/widget.php(436)
#8 vB_Api_Widget->fetchConfig(11, 0, '2') in /core/vb/vb/api/widget.php(1944)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetchannelconfig
WHERE `widgetinstanceid` = 12 AND `nodeid` = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4148
- Time After: 1785148047.4153
- Time Taken: 0.00051283836364746
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:82]', 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('widgetchannelconfig', array[len:3]) in /core/vb/vb/api/widget.php(610)
#7 vB_Api_Widget->fetchChannelConfig(12, 2) in /core/vb/vb/api/widget.php(436)
#8 vB_Api_Widget->fetchConfig(12, 0, '2') in /core/vb/vb/api/widget.php(1944)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM widgetchannelconfig
WHERE `widgetinstanceid` = 13 AND `nodeid` = 2
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.4155
- Time After: 1785148047.416
- Time Taken: 0.00048089027404785
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:82]', 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('widgetchannelconfig', array[len:3]) in /core/vb/vb/api/widget.php(610)
#7 vB_Api_Widget->fetchChannelConfig(13, 2) in /core/vb/vb/api/widget.php(436)
#8 vB_Api_Widget->fetchConfig(13, 0, '2') in /core/vb/vb/api/widget.php(1944)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#12 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#14 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#15 eval() in /includes/vb5/template.php(404)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_subchannelsdisplay_widgettitle','system_widgetcat','widget_channeldisplay_widgettitle','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle','widget_channeldescription_widgettitle') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 21 | Using index condition |
- Time Before: 1785148047.4164
- Time After: 1785148047.4187
- Time Taken: 0.002331018447876
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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 `va[len:320]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:7], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:7]) in /core/vb/vb/api/widget.php(1503)
#10 vB_Api_Widget->addWidgetTitles(array[len:5]) in /core/vb/vb/api/widget.php(2053)
#11 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('2', -1, '2', false) in /core/vb/vb/api/widget.php(2093)
#12 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('2', '2') in /core/vb/vb/api/widget.php(2129)
#13 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#14 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#16 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#17 eval() in /includes/vb5/template.php(404)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM pagetemplate
WHERE `pagetemplateid` = 2
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | pagetemplate | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.419
- Time After: 1785148047.4199
- Time Taken: 0.0008549690246582
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:64]', 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('pagetemplate', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('pagetemplate', array[len:2]) in /core/vb/vb/api/widget.php(2132)
#8 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(404)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM screenlayout
WHERE `screenlayoutid` = 1
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | screenlayout | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.42
- Time After: 1785148047.4208
- Time Taken: 0.0008089542388916
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:64]', 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('screenlayout', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('screenlayout', array[len:2]) in /core/vb/vb/api/widget.php(2133)
#8 vB_Api_Widget->fetchLayoutSectionInfo('2', '2') in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('fetchLayou[len:22]', array[len:2]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('widget', 'fetchLayou[len:22]', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#11 vB5_Template_Runtime::parseData('widget', 'fetchLayou[len:22]', '2', '2') in /includes/vb5/template.php(404) : eval()'d code(5)
#12 eval() in /includes/vb5/template.php(404)
#13 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#14 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2312,2225,2300)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 3 | Using index condition |
- Time Before: 1785148047.4218
- Time After: 1785148047.4243
- Time Taken: 0.0025420188903809
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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 `ti[len:105]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:3], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:3], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:3]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM seotags WHERE nodeid = '2'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785148047.428
- Time After: 1785148047.429
- Time Taken: 0.00097799301147461
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(631)
#1 vB_Database->query_first('') in /core/packages/ruforum/api/article.php(437)
#2 ruforum_Api_Article->getCanonical(2) in /core/vb/vb/api/wrapper.php(205)
#3 vB_Api_Wrapper->__call('getCanonical', array[len:1]) in /includes/api/interface/collapsed.php(105)
#4 Api_Interface_Collapsed->callApi('ruforum:article', 'getCanonical', array[len:1], false, true) in /includes/vb5/template/runtime.php(1034)
#5 vB5_Template_Runtime::parseData('ruforum:article', 'getCanonical', 2) in /includes/vb5/template.php(404) : eval()'d code(101)
#6 eval() in /includes/vb5/template.php(404)
#7 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#8 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#9 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#10 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM datastore
WHERE `title` IN ('attachmentcache')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | datastore | const | PRIMARY | PRIMARY | 150 | const | 1 | |
- Time Before: 1785148047.4298
- Time After: 1785148047.4304
- Time Taken: 0.00062012672424316
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:62]', 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:1]) in /core/vb/vb/datastore.php(560)
#8 vB_Datastore->fetch(array[len:1]) in /core/vb/vb/datastore.php(179)
#9 vB_Datastore->getValue('bf_ugp_mod[len:27]') in /core/vb/vb/permissioncontext.php(565)
#10 vB_PermissionContext->hasPermission('moderatorpermissions', 'caneditposts') in /core/vb/vb/usercontext.php(407)
#11 vB_UserContext->hasPermission('moderatorpermissions', 'caneditposts') in /core/vb/vb/usercontext.php(2372)
#12 vB_UserContext->fetchPermsForChannels(array[len:1]) in /core/vb/vb/library/content.php(3086)
#13 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/vb/library/content/channel.php(1027)
#14 vB_Library_Content_Channel->assembleContent(array[len:1]) in /core/vb/vb/library/content.php(2576)
#15 vB_Library_Content->getFullContent(array[len:1]) in /core/vb/vb/library/content/channel.php(401)
#16 vB_Library_Content_Channel->getFullContent(2) in /core/vb/vb/library/node.php(2607)
#17 vB_Library_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1852)
#18 vB_Api_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1827)
#19 vB_Api_Node->getNodeContent('2') in /core/vb/vb/api/wrapper.php(205)
#20 vB_Api_Wrapper->__call('getNodeContent', array[len:1]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('node', 'getNodeContent', array[len:1]) in /includes/vb5/template/runtime.php(1051)
#22 vB5_Template_Runtime::parseDataWithErrors('node', 'getNodeContent', '2') in /includes/vb5/template.php(404) : eval()'d code(139)
#23 eval() in /includes/vb5/template.php(404)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM datastore
WHERE `title` IN ('attachmentcache')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | datastore | const | PRIMARY | PRIMARY | 150 | const | 1 | |
- Time Before: 1785148047.4306
- Time After: 1785148047.4309
- Time Taken: 0.00034594535827637
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:62]', 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:1]) in /core/vb/vb/datastore.php(560)
#8 vB_Datastore->fetch(array[len:1]) in /core/vb/vb/datastore.php(179)
#9 vB_Datastore->getValue('bf_ugp_mod[len:27]') in /core/vb/vb/permissioncontext.php(565)
#10 vB_PermissionContext->hasPermission('moderatorpermissions', 'canviewips') in /core/vb/vb/usercontext.php(407)
#11 vB_UserContext->hasPermission('moderatorpermissions', 'canviewips') in /core/vb/vb/usercontext.php(2373)
#12 vB_UserContext->fetchPermsForChannels(array[len:1]) in /core/vb/vb/library/content.php(3086)
#13 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/vb/library/content/channel.php(1027)
#14 vB_Library_Content_Channel->assembleContent(array[len:1]) in /core/vb/vb/library/content.php(2576)
#15 vB_Library_Content->getFullContent(array[len:1]) in /core/vb/vb/library/content/channel.php(401)
#16 vB_Library_Content_Channel->getFullContent(2) in /core/vb/vb/library/node.php(2607)
#17 vB_Library_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1852)
#18 vB_Api_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1827)
#19 vB_Api_Node->getNodeContent('2') in /core/vb/vb/api/wrapper.php(205)
#20 vB_Api_Wrapper->__call('getNodeContent', array[len:1]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('node', 'getNodeContent', array[len:1]) in /includes/vb5/template/runtime.php(1051)
#22 vB5_Template_Runtime::parseDataWithErrors('node', 'getNodeContent', '2') in /includes/vb5/template.php(404) : eval()'d code(139)
#23 eval() in /includes/vb5/template.php(404)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 51 | Using index condition |
- Time Before: 1785148047.4325
- Time After: 1785148047.4343
- Time Taken: 0.0018391609191895
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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 `va[len:476]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:17], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:17]) in /core/vb/vb/library/content/infraction.php(68)
#10 vB_Library_Content_Infraction->__construct() in /core/vb/vb/library.php(46)
#11 vB_Library::instance('content_infraction') in /core/vb/vb/library/content.php(3328)
#12 vB_Library_Content->assembleContent(array[len:1], false) in /core/vb/vb/library/content/channel.php(1027)
#13 vB_Library_Content_Channel->assembleContent(array[len:1]) in /core/vb/vb/library/content.php(2576)
#14 vB_Library_Content->getFullContent(array[len:1]) in /core/vb/vb/library/content/channel.php(401)
#15 vB_Library_Content_Channel->getFullContent(2) in /core/vb/vb/library/node.php(2607)
#16 vB_Library_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1852)
#17 vB_Api_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1827)
#18 vB_Api_Node->getNodeContent('2') in /core/vb/vb/api/wrapper.php(205)
#19 vB_Api_Wrapper->__call('getNodeContent', array[len:1]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('node', 'getNodeContent', array[len:1]) in /includes/vb5/template/runtime.php(1051)
#21 vB5_Template_Runtime::parseDataWithErrors('node', 'getNodeContent', '2') in /includes/vb5/template.php(404) : eval()'d code(139)
#22 eval() in /includes/vb5/template.php(404)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vBAtchmnts_2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4349
- Time After: 1785148047.4355
- Time Taken: 0.00059700012207031
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:57]', 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/node.php(1992)
#9 vB_Library_Node->fetchNodeAttachments(array[len:1]) in /core/vb/vb/library/node.php(2626)
#10 vB_Library_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1852)
#11 vB_Api_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1827)
#12 vB_Api_Node->getNodeContent('2') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('getNodeContent', array[len:1]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('node', 'getNodeContent', array[len:1]) in /includes/vb5/template/runtime.php(1051)
#15 vB5_Template_Runtime::parseDataWithErrors('node', 'getNodeContent', '2') in /includes/vb5/template.php(404) : eval()'d code(139)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#19 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#20 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
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 (1)
/**fetchAvatarsForUsers**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | customavatar | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| 1 | SIMPLE | avatar | const | PRIMARY | PRIMARY | 2 | const | 0 | Unique row not found |
- Time Before: 1785148047.4359
- Time After: 1785148047.4368
- Time Taken: 0.00089192390441895
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:460]', 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('vbForum:fe[len:28]', array[len:1]) in /core/vb/vb/api/user.php(1452)
#6 vB_Api_User->fetchAvatars(array[len:1], true) in /core/vb/vb/library/node.php(1857)
#7 vB_Library_Node->addOptionalNodeContentInfo(array[len:141], array[len:0]) in /core/vb/vb/library/node.php(2656)
#8 vB_Library_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1852)
#9 vB_Api_Node->getNodeFullContent(2, false, array[len:0]) in /core/vb/vb/api/node.php(1827)
#10 vB_Api_Node->getNodeContent('2') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getNodeContent', array[len:1]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('node', 'getNodeContent', array[len:1]) in /includes/vb5/template/runtime.php(1051)
#13 vB5_Template_Runtime::parseDataWithErrors('node', 'getNodeContent', '2') in /includes/vb5/template.php(404) : eval()'d code(139)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM routenew
WHERE `class` IN ('vB5_Route_Conversation','vB5_Route_Article') AND `contentid` = 2 AND `redirect301` IS NULL
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | range | route_class_cid | route_class_cid | 407 | | 2 | Using index condition; Using where |
- Time Before: 1785148047.4379
- Time After: 1785148047.4387
- Time Taken: 0.00085186958312988
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#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:144]', 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(1260)
#8 vB5_Route::getChannelConversationRouteInfo(2) in /core/vb/vb/api/route.php(403)
#9 vB_Api_Route->getChannelConversationRoute('2') in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('getChannel[len:27]', array[len:1]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('route', 'getChannel[len:27]', array[len:1], false, true) in /includes/vb5/template/runtime.php(1034)
#12 vB5_Template_Runtime::parseData('route', 'getChannel[len:27]', '2') in /includes/vb5/template.php(404) : eval()'d code(154)
#13 eval() in /includes/vb5/template.php(404)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2029,2424,1907,2399,2238,2406,2338)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 7 | Using index condition |
- Time Before: 1785148047.4408
- Time After: 1785148047.4419
- Time Taken: 0.0011589527130127
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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 `ti[len:125]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:9], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:9], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:9]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM loginlibrary
WHERE `productid` = 'twitterlogin'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | loginlibrary | const | productid | productid | 102 | const | 1 | |
- Time Before: 1785148047.4439
- Time After: 1785148047.4445
- Time Taken: 0.00057411193847656
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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:72]', 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:loginlibrary', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:loginlibrary', array[len:2]) in /core/vb/vb/library/externallogin.php(79)
#8 vB_Library_ExternalLogin->getLoginLibraryId() in /core/vb/vb/library/externallogin.php(34)
#9 vB_Library_ExternalLogin->__construct() in /core/vb/vb/library/externallogin/oauth.php(97)
#10 vB_Library_ExternalLogin_OAuth->__construct() in /core/packages/twitterlogin/library/externallogin.php(22)
#11 TwitterLogin_Library_ExternalLogin->__construct() in /core/vb/vb/library.php(46)
#12 vB_Library::instance('TwitterLog[len:26]') in /core/packages/twitterlogin/api/externallogin.php(28)
#13 TwitterLogin_Api_ExternalLogin->__construct() in /core/vb/vb/api.php(213)
#14 vB_Api::instance('TwitterLog[len:26]') in /core/packages/twitterlogin/hooks.php(6)
#15 twitterlogin_Hooks::hookShowExternalLoginButton(array[len:1]) in /core/vb/vb/utility/hook/live.php(57)
#16 vB_Utility_Hook_Live->invoke('hookShowEx[len:27]', array[len:1]) in /core/vb/vb/api/externallogin.php(83)
#17 vB_Api_ExternalLogin->showExternalLoginButton() in /core/vb/vb/api/wrapper.php(205)
#18 vB_Api_Wrapper->__call('showExtern[len:23]', array[len:0]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('externallogin', 'showExtern[len:23]', array[len:0], false, true) in /includes/vb5/template/runtime.php(1034)
#20 vB5_Template_Runtime::parseData('externallogin', 'showExtern[len:23]') in /includes/vb5/template.php(404) : eval()'d code(100)
#21 eval() in /includes/vb5/template.php(404)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM loginlibrary
WHERE `productid` = 'googlelogin'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | loginlibrary | const | productid | productid | 102 | const | 1 | |
- Time Before: 1785148047.4448
- Time After: 1785148047.4451
- Time Taken: 0.00037312507629395
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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:71]', 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:loginlibrary', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:loginlibrary', array[len:2]) in /core/vb/vb/library/externallogin.php(79)
#8 vB_Library_ExternalLogin->getLoginLibraryId() in /core/vb/vb/library/externallogin.php(34)
#9 vB_Library_ExternalLogin->__construct() in /core/packages/googlelogin/library/externallogin.php(29)
#10 GoogleLogin_Library_ExternalLogin->__construct() in /core/vb/vb/library.php(46)
#11 vB_Library::instance('googlelogi[len:25]') in /core/packages/googlelogin/api/externallogin.php(28)
#12 GoogleLogin_Api_ExternalLogin->__construct() in /core/vb/vb/api.php(213)
#13 vB_Api::instance('googlelogi[len:25]') in /core/packages/googlelogin/hooks.php(6)
#14 googlelogin_Hooks::hookShowExternalLoginButton(array[len:1]) in /core/vb/vb/utility/hook/live.php(57)
#15 vB_Utility_Hook_Live->invoke('hookShowEx[len:27]', array[len:1]) in /core/vb/vb/api/externallogin.php(83)
#16 vB_Api_ExternalLogin->showExternalLoginButton() in /core/vb/vb/api/wrapper.php(205)
#17 vB_Api_Wrapper->__call('showExtern[len:23]', array[len:0]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('externallogin', 'showExtern[len:23]', array[len:0], false, true) in /includes/vb5/template/runtime.php(1034)
#19 vB5_Template_Runtime::parseData('externallogin', 'showExtern[len:23]') in /includes/vb5/template.php(404) : eval()'d code(100)
#20 eval() in /includes/vb5/template.php(404)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('stylevar_cache_10')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4456
- Time After: 1785148047.4468
- Time Taken: 0.0011968612670898
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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:62]', 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/style.php(190)
#9 vB_Library_Style->getStylevars(10) in /core/vb/vb/library/style.php(98)
#10 vB_Library_Style->addStylevars(array[len:3]) in /core/vb/vb/library/style.php(1159)
#11 vB_Library_Style->fetchStyles(false, true, array[len:0]) in /core/vb/vb/api/style.php(84)
#12 vB_Api_Style->fetchStyles('0', '1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchStyles', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('style', 'fetchStyles', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#15 vB5_Template_Runtime::parseData('style', 'fetchStyles', '0', '1') in /includes/vb5/template.php(404) : eval()'d code(161)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('stylevar_cache_45')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4473
- Time After: 1785148047.4482
- Time Taken: 0.00086712837219238
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#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:62]', 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/style.php(190)
#9 vB_Library_Style->getStylevars(45) in /core/vb/vb/library/style.php(98)
#10 vB_Library_Style->addStylevars(array[len:3]) in /core/vb/vb/library/style.php(1159)
#11 vB_Library_Style->fetchStyles(false, true, array[len:0]) in /core/vb/vb/api/style.php(84)
#12 vB_Api_Style->fetchStyles('0', '1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchStyles', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('style', 'fetchStyles', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#15 vB5_Template_Runtime::parseData('style', 'fetchStyles', '0', '1') in /includes/vb5/template.php(404) : eval()'d code(161)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('stylevar_cache_46')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4486
- Time After: 1785148047.4497
- Time Taken: 0.001007080078125
- Memory Before: 10485760
- Memory After: 12582912
- Memory Used: 2097152
#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:62]', 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/style.php(190)
#9 vB_Library_Style->getStylevars(46) in /core/vb/vb/library/style.php(98)
#10 vB_Library_Style->addStylevars(array[len:3]) in /core/vb/vb/library/style.php(1159)
#11 vB_Library_Style->fetchStyles(false, true, array[len:0]) in /core/vb/vb/api/style.php(84)
#12 vB_Api_Style->fetchStyles('0', '1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchStyles', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('style', 'fetchStyles', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#15 vB5_Template_Runtime::parseData('style', 'fetchStyles', '0', '1') in /includes/vb5/template.php(404) : eval()'d code(161)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2184,2425,1471,1476,2275)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 5 | Using index condition |
- Time Before: 1785148047.4502
- Time After: 1785148047.4509
- Time Taken: 0.00066804885864258
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:115]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:5], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:5], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:5]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('node_1_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4519
- Time After: 1785148047.4523
- Time Taken: 0.00049185752868652
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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('1') 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:2]) in /core/packages/ruforum/api/common.php(390)
#15 ruforum_Api_Common->getOAuthData() in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getOAuthData', array[len:0]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('ruforum:common', 'getOAuthData', array[len:0], false, true) in /includes/vb5/template/runtime.php(1034)
#18 vB5_Template_Runtime::parseData('ruforum:common', 'getOAuthData') in /includes/vb5/template.php(404) : eval()'d code(1)
#19 eval() in /includes/vb5/template.php(404)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#22 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#23 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#24 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#25 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT *
FROM profilefield
WHERE editable > 0 AND required <> 0
ORDER BY displayorder
/**user_fetchprofilefieldsforregistration**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | profilefield | ALL | editable | | | | 7 | Using where; Using filesort |
- Time Before: 1785148047.4536
- Time After: 1785148047.4544
- Time Taken: 0.00072312355041504
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:147]', 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('user_fetch[len:38]', array[len:0], false) in /core/vb/vb/db/assertor.php(641)
#6 vB_dB_Assertor->getRows('user_fetch[len:38]') in /core/vb/vb/api/user.php(1607)
#7 vB_Api_User->fetchProfileFieldsForRegistration(NULL) in /core/vb/vb/api/wrapper.php(205)
#8 vB_Api_Wrapper->__call('fetchProfi[len:33]', array[len:1]) in /includes/api/interface/collapsed.php(105)
#9 Api_Interface_Collapsed->callApi('user', 'fetchProfi[len:33]', array[len:1], false, true) in /includes/vb5/template/runtime.php(1034)
#10 vB5_Template_Runtime::parseData('user', 'fetchProfi[len:33]', NULL) in /includes/vb5/template.php(404) : eval()'d code(62)
#11 eval() in /includes/vb5/template.php(404)
#12 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2286,1736)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1785148047.4546
- Time After: 1785148047.4552
- Time Taken: 0.00052690505981445
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:100]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:2], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:2], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:11543]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_ChannelStructure')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4561
- Time After: 1785148047.4567
- Time Taken: 0.00052285194396973
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:64]', 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/includes/functions.php(2319)
#9 cache_permissions(array[len:4]) in /core/vb/vb/api/hv.php(286)
#10 vB_Api_Hv->fetchRequireHvcheck('register') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetchRequireHvcheck', array[len:1]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('hv', 'fetchRequireHvcheck', array[len:1], false, true) in /includes/vb5/template/runtime.php(1034)
#13 vB5_Template_Runtime::parseData('hv', 'fetchRequireHvcheck', 'register') in /includes/vb5/template.php(404) : eval()'d code(1)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:11543]') in /includes/vb5/template.php(426)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2174)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4569
- Time After: 1785148047.4573
- Time Taken: 0.00037002563476562
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:1], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:165]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:11543]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:24535]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `noticeid` FROM noticedismissed
WHERE `userid` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | noticedismissed | ref | userid | userid | 4 | const | 1 | |
- Time Before: 1785148047.4592
- Time After: 1785148047.4597
- Time Taken: 0.00055909156799316
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `no[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('vBForum:no[len:23]', array[len:2], false) in /core/vb/vb/db/assertor.php(685)
#7 vB_dB_Assertor->getColumn('vBForum:no[len:23]', 'noticeid', array[len:2]) in /core/vb/vb/api/notice.php(95)
#8 vB_Api_Notice->fetch('2', array[len:0]) in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('notice', 'fetch', array[len:2]) in /includes/vb5/template/runtime.php(1051)
#11 vB5_Template_Runtime::parseDataWithErrors('notice', 'fetch', '2', array[len:0]) in /includes/vb5/template.php(404) : eval()'d code(4)
#12 eval() in /includes/vb5/template.php(404)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM phrase
WHERE `varname` = 'notice_1_html' AND `languageid` IN (-1,2)
ORDER BY `languageid` DESC
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 2 | Using where |
- Time Before: 1785148047.4601
- Time After: 1785148047.4608
- Time Taken: 0.00066399574279785
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:120]', 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('phrase', array[len:3], array[len:2]) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('phrase', array[len:3], array[len:2]) in /core/vb/vb/phrase.php(363)
#8 vB_Phrase::fetchSinglePhrase('notice_1_html') in /core/packages/ruforum/api/common.php(531)
#9 ruforum_Api_Common->decodePHRASE('notice_1_html') in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('decodePHRASE', array[len:1]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('ruforum:common', 'decodePHRASE', array[len:1], false, true) in /includes/vb5/template/runtime.php(1034)
#12 vB5_Template_Runtime::parseData('ruforum:common', 'decodePHRASE', 'notice_1_html') in /includes/vb5/template.php(404) : eval()'d code(19)
#13 eval() in /includes/vb5/template.php(404)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74461]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2226)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4617
- Time After: 1785148047.4622
- Time Taken: 0.00043702125549316
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:1], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:636]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2227)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4629
- Time After: 1785148047.4633
- Time Taken: 0.00038599967956543
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:1], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:421]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:636]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (1933,2267,2253)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 3 | Using index condition |
- Time Before: 1785148047.465
- Time After: 1785148047.4656
- Time Taken: 0.00055789947509766
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:105]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:3], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:3], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:3]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4586]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4910]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:5125]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_Announcements_2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4665
- Time After: 1785148047.4669
- Time Taken: 0.00036406517028809
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:63]', 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 /includes/vb5/frontend/controller/announcement.php(32)
#9 vB5_Frontend_Controller_Announcement::getText('2') in /includes/vb5/template/runtime.php(1066)
#10 vB5_Template_Runtime::parseAction('announcement', 'getText', '2') in /includes/vb5/template.php(404) : eval()'d code(17)
#11 eval() in /includes/vb5/template.php(404)
#12 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4586]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4910]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:5125]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2329)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4671
- Time After: 1785148047.4679
- Time Taken: 0.00075888633728027
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:1], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:1935]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4586]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4910]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:5125]') in /includes/vb5/template.php(426)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (1998,2254)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1785148047.472
- Time After: 1785148047.4747
- Time Taken: 0.0027210712432861
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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 `ti[len:100]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:2], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:2], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_ChannelTreeRaw_0')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4759
- Time After: 1785148047.4766
- Time Taken: 0.00063300132751465
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:64]', 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/api/node.php(3844)
#9 vB_Api_Node->getUserChannels('0') in /core/vb/vb/api/node.php(3779)
#10 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#13 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_ChTreeWithLast')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4767
- Time After: 1785148047.4774
- Time Taken: 0.00067400932312012
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#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:62]', 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/api/node.php(3899)
#9 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#10 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#13 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vB_ChannelTree_Total')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785148047.4777
- Time After: 1785148047.479
- Time Taken: 0.00130295753479
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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/api/node.php(3905)
#9 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#10 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#13 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('node_13_lvl1data','node_3_lvl1data','node_4_lvl1data','node_6_lvl1data','node_5_lvl1data','node_234780_lvl1data','node_7_lvl1data','node_11_lvl1data','node_8_lvl1data','node_9_lvl1data','node_10_lvl1data','node_12_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | range | PRIMARY | PRIMARY | 66 | | 12 | Using index condition |
- Time Before: 1785148047.4794
- Time After: 1785148047.4803
- Time Taken: 0.00096702575683594
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:267]', 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:12], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:14]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:14], 1) in /core/vb/vb/library/node.php(1055)
#10 vB_Library_Node->getNodes(array[len:14]) in /core/vb/vb/api/node.php(3911)
#11 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#12 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#15 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
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 (144391,0,144581)
/**fetchAvatarsForUsers**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 3 | Using index condition |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.user.userid | 1 | |
| 1 | SIMPLE | avatar | eq_ref | PRIMARY | PRIMARY | 2 | brazilforum_new.user.avatarid | 1 | Using where |
- Time Before: 1785148047.4811
- Time After: 1785148047.4819
- Time Taken: 0.00079512596130371
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:474]', 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('vbForum:fe[len:28]', array[len:1]) in /core/vb/vb/api/user.php(1452)
#6 vB_Api_User->fetchAvatars(array[len:3], true) in /core/vb/vb/api/node.php(3948)
#7 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#8 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#11 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#12 eval() in /includes/vb5/template.php(404)
#13 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#14 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('node_234782_lvl1data','node_61520_lvl1data','node_234782_lvl1data','node_234779_lvl1data','node_234782_lvl1data','node_234782_lvl1data','node_234779_lvl1data','node_234778_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | range | PRIMARY | PRIMARY | 66 | | 4 | Using index condition |
- Time Before: 1785148047.4822
- Time After: 1785148047.4827
- Time Taken: 0.00055408477783203
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:225]', 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:8], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:8]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:14], 1) in /core/vb/vb/library/node.php(1055)
#10 vB_Library_Node->getNodes(array[len:14]) in /core/vb/vb/api/node.php(3951)
#11 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#12 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#15 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('node_234781_lvl1data','node_1381_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | range | PRIMARY | PRIMARY | 66 | | 2 | Using index condition |
- Time Before: 1785148047.483
- Time After: 1785148047.4835
- Time Taken: 0.00043702125549316
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:86]', 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:2]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:2], 1) in /core/vb/vb/library/node.php(1055)
#10 vB_Library_Node->getNodes(array[len:2]) in /core/vb/vb/api/node.php(3964)
#11 vB_Api_Node->addChannelLastData() in /core/vb/vb/api/node.php(3789)
#12 vB_Api_Node->fetchChannelNodeTree(2, 2, 1, 100) in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchChannelNodeTree', array[len:4]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('node', 'fetchChannelNodeTree', array[len:4]) in /includes/vb5/template/runtime.php(1051)
#15 vB5_Template_Runtime::parseDataWithErrors('node', 'fetchChannelNodeTree', '2', '2', '1', '100') in /includes/vb5/template.php(404) : eval()'d code(19)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#19 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#20 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#21 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#22 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#23 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#24 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2165)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.4841
- Time After: 1785148047.4844
- Time Taken: 0.00031304359436035
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:1], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:1]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:834]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4167]') in /includes/vb5/template.php(426)
#16 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#17 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4525]') in /includes/vb5/template.php(426)
#18 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#19 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:4740]') in /includes/vb5/template.php(426)
#20 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#21 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM site
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | site | ALL | | | | | 1 | |
- Time Before: 1785148047.4963
- Time After: 1785148047.4971
- Time Taken: 0.00075602531433105
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:27]', 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:site', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('vBForum:site', array[len:2]) in /core/vb/vb/library/site.php(225)
#8 vB_Library_Site->getNavbar('footer', '1', '/forum?do=[len:40]', false) in /core/vb/vb/library/site.php(207)
#9 vB_Library_Site->loadFooterNavbar('1', '/forum?do=[len:40]', false) in /core/vb/vb/api/site.php(108)
#10 vB_Api_Site->loadFooterNavbar('1', '/forum?do=[len:40]') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('loadFooterNavbar', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('site', 'loadFooterNavbar', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#13 vB5_Template_Runtime::parseData('site', 'loadFooterNavbar', '1', '/forum?do=[len:40]') in /includes/vb5/template.php(404) : eval()'d code(20)
#14 eval() in /includes/vb5/template.php(404)
#15 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#16 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2423,2428)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1785148047.4988
- Time After: 1785148047.5035
- Time Taken: 0.0047008991241455
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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 `ti[len:100]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:2], 45, 'compiled') in /core/vb/vb/api/template.php(70)
#9 vB_Api_Template->fetchBulk(array[len:2], 45) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetchBulk', array[len:2]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('template', 'fetchBulk', array[len:2]) in /includes/vb5/template/cache.php(224)
#12 vB5_Template_Cache->fetchTemplate(array[len:2]) in /includes/vb5/template/cache.php(110)
#13 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:67006]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('logo','powered_by_vbulletin_title','search','advanced_search','home','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','subforums','no_forums_found','go_to_top','go_to_bottom','navbar_contact_us','forexdengi_thanks','today','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','mentions') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 321 | Using index condition |
- Time Before: 1785148047.5067
- Time After: 1785148047.5177
- Time Taken: 0.011018991470337
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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 `va[len:2209]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:107], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:107]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(246)
#12 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(101)
#13 vB5_Template_Phrase->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#16 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM routenew
WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | range | PRIMARY | PRIMARY | 4 | | 1 | Using where |
- Time Before: 1785148047.5309
- Time After: 1785148047.5318
- Time Taken: 0.00084805488586426
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:118]', 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:7]) in /core/vb/vb/api/route.php(490)
#8 vB_Api_Route->preloadRoutes(array[len:7]) in /core/vb/vb/api/wrapper.php(205)
#9 vB_Api_Wrapper->__call('preloadRoutes', array[len:1]) in /includes/api/interface/collapsed.php(105)
#10 Api_Interface_Collapsed->callApi('route', 'preloadRoutes', array[len:1]) in /includes/vb5/template/url.php(210)
#11 vB5_Template_Url->finalBuildUrls(array[len:7]) in /includes/vb5/template/url.php(359)
#12 vB5_Template_Url->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(517)
#13 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT * FROM page
WHERE `pageid` = 33
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.5322
- Time After: 1785148047.5327
- Time Taken: 0.00054407119750977
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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:49]', 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('page', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('page', array[len:2]) in /core/vb5/route/page.php(27)
#8 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#9 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1565)
#10 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:7]) in /core/vb5/route.php(1530)
#11 vB5_Route::buildUrls(array[len:7]) in /core/vb/vb/api/route.php(469)
#12 vB_Api_Route->getUrls(array[len:7]) in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(271)
#15 vB5_Template_Url->finalBuildUrls(array[len:7]) in /includes/vb5/template/url.php(359)
#16 vB5_Template_Url->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(517)
#17 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785148047.5329
- Time After: 1785148047.5338
- Time Taken: 0.00091791152954102
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#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 `va[len:209]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:2], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:2]) in /core/vb5/route/page.php(34)
#10 vB5_Route_Page->getPage() in /core/vb5/route/page.php(63)
#11 vB5_Route_Page->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1565)
#12 vB5_Route::bulkFetchUrls('vB5_Route_Page', array[len:7]) in /core/vb5/route.php(1530)
#13 vB5_Route::buildUrls(array[len:7]) in /core/vb/vb/api/route.php(469)
#14 vB_Api_Route->getUrls(array[len:7]) in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getUrls', array[len:1]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getUrls', array[len:1]) in /includes/vb5/template/url.php(271)
#17 vB5_Template_Url->finalBuildUrls(array[len:7]) in /includes/vb5/template/url.php(359)
#18 vB5_Template_Url->replacePlaceholders('<!-- BEGIN[len:226221]') in /includes/vb5/template.php(517)
#19 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2027)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785148047.5368
- Time After: 1785148047.5373
- Time Taken: 0.00057506561279297
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#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 `ti[len:95]', 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('template', array[len:3], false) in /core/vb/vb/db/assertor.php(576)
#7 vB_dB_Assertor->select('template', array[len:1], false, array[len:4]) in /core/vb/vb/library/template.php(124)
#8 vB_Library_Template->fetchBulk(array[len:1], 45, 'compiled', false) in /core/vb/vb/library/template.php(50)
#9 vB_Library_Template->fetch('debug_info', 45) in /core/vb/vb/api/template.php(57)
#10 vB_Api_Template->fetch('debug_info', 45) in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('fetch', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('template', 'fetch', array[len:2]) in /includes/vb5/template/cache.php(224)
#13 vB5_Template_Cache->fetchTemplate('debug_info') in /includes/vb5/template/cache.php(187)
#14 vB5_Template_Cache->getTemplate('debug_info') in /includes/vb5/template.php(567)
#15 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 75 | Using index condition |
- Time Before: 1785148047.5395
- Time After: 1785148047.5421
- Time Taken: 0.0025210380554199
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#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 `va[len:500]', 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('phrase', array[len:4], false) in /core/vb/vb/db/assertor.php(641)
#7 vB_dB_Assertor->getRows('phrase', array[len:4]) in /core/vb/vb/api/phrase.php(267)
#8 vB_Api_Phrase->getPhrases(array[len:25], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:25]) in /core/vb/vb/api/wrapper.php(205)
#10 vB_Api_Wrapper->__call('fetch', array[len:1]) in /includes/api/interface/collapsed.php(105)
#11 Api_Interface_Collapsed->callApi('phrase', 'fetch', array[len:1]) in /includes/vb5/template/phrase.php(246)
#12 vB5_Template_Phrase->fetchPhrases() in /includes/vb5/template/phrase.php(101)
#13 vB5_Template_Phrase->replacePlaceholders('<div id="d[len:73444]') in /includes/vb5/template.php(577)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:226221]', false) in /includes/vb5/template.php(430)
#15 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#16 vB5_Frontend_Controller_Page->index(39, 2, 2, '$pagenum', 39, 1, 'Forum Description', 0, '', 'Forum', 0) in /index.php(138)
5 Slowest Queries
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('logo','powered_by_vbulletin_title','search','advanced_search','home','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','subforums','no_forums_found','go_to_top','go_to_bottom','navbar_contact_us','forexdengi_thanks','today','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','mentions') AND `languageid` IN (2,0,-1)
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 */
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2423,2428)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (1998,2254)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2312,2225,2300)
99 Queries Run : Total SQL time was 0.100941 seconds , Total PHP time was 0.110447 seconds , Overall time was 0.211388 seconds.