vBulletin - Explain SQL Queries (69)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
SET @@sql_mode = ''
- Time Before: 1785028200.6133
- Time After: 1785028200.6135
- Time Taken: 0.00014901161193848
- 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: 1785028200.6144
- Time After: 1785028200.6161
- Time Taken: 0.0016911029815674
- 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` = '746d2c2e12532723401903d41921bd01'
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: 1785028200.6186
- Time After: 1785028200.6199
- Time Taken: 0.0013110637664795
- 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: 1785028200.6203
- Time After: 1785028200.6208
- Time Taken: 0.00052499771118164
- 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: 1785028200.6211
- Time After: 1785028200.6438
- Time Taken: 0.02278208732605
- 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: 1785028200.6519
- Time After: 1785028200.653
- Time Taken: 0.0011229515075684
- 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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(117)
SELECT routenew.*
FROM routenew AS routenew
WHERE routenew.prefix IN ('earn_money','') OR ishomeroute = 1
/**get_best_routes**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | index_merge | prefix,ishomeroute | prefix,ishomeroute | 802,2 | | 4 | Using sort_union(prefix,ishomeroute); Using where |
- Time Before: 1785028200.6534
- Time After: 1785028200.6542
- Time Taken: 0.0008399486541748
- 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:144]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in /core/vb/vb/api/route.php(127)
#6 vB_Api_Route->getRoute('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#7 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#8 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#9 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#10 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6545
- Time After: 1785028200.655
- Time Taken: 0.00046706199645996
- 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(0) in /core/vb/vb/library/user.php(32)
#12 vB_Library_User->isBanned('0') in /core/vb/vb/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in /core/vb/vb/api/route.php(153)
#14 vB_Api_Route->getRoute('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.657
- Time After: 1785028200.6586
- Time Taken: 0.0016248226165771
- 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: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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#18 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#19 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#20 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#21 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6611
- Time After: 1785028200.6735
- Time Taken: 0.012423038482666
- 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: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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6743
- Time After: 1785028200.6747
- Time Taken: 0.00045990943908691
- 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/api/node.php(124)
#14 vB_Api_Node->__construct() in /core/vb/vb/api.php(185)
#15 vB_Api::instanceInternal('node') in /core/vb/vb/api/content.php(71)
#16 vB_Api_Content->__construct() in /core/vb/vb/api/content/channel.php(40)
#17 vB_Api_Content_Channel->__construct() in /core/vb/vb/api.php(185)
#18 vB_Api::instanceInternal('content_channel') in /core/vb/vb/api/route.php(215)
#19 vB_Api_Route->getRoute('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#20 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#21 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#22 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#23 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.676
- Time After: 1785028200.677
- Time Taken: 0.00096988677978516
- 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: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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6772
- Time After: 1785028200.6778
- Time Taken: 0.00060105323791504
- 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, '\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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#11 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#13 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#14 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.678
- Time After: 1785028200.6784
- Time Taken: 0.00044107437133789
- 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], 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('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#16 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#17 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6786
- Time After: 1785028200.6789
- Time Taken: 0.00027585029602051
- 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: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', '1') in /core/vb/vb/permissioncontext.php(835)
#11 vB_PermissionContext->getChannelPermissionGroup('forumpermissions', '1') in /core/vb/vb/permissioncontext.php(1017)
#12 vB_PermissionContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/vb/usercontext.php(873)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in /core/vb/vb/api/route.php(216)
#14 vB_Api_Route->getRoute('earn_money', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#15 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#16 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785028200.6805
- Time After: 1785028200.6811
- Time Taken: 0.00060486793518066
- 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 `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(168, 'vbulletin-[len:33]') in /index.php(138)
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: 1785028200.6849
- Time After: 1785028200.6964
- Time Taken: 0.011476039886475
- 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: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('register') in /core/vb5/route.php(1336)
#11 vB5_Route::getClassName('register', array[len:14]) in /core/vb5/route.php(1408)
#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(168, 'vbulletin-[len:33]') 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: 1785028200.6976
- Time After: 1785028200.6985
- Time Taken: 0.00093603134155273
- 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: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(168, 'vbulletin-[len:33]') 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: 1785028200.6989
- Time After: 1785028200.7
- Time Taken: 0.0010831356048584
- 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 `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(168, 'vbulletin-[len:33]') 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: 1785028200.7004
- Time After: 1785028200.7009
- Time Taken: 0.00046110153198242
- 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: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(168, 'vbulletin-[len:33]') 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: 1785028200.701
- Time After: 1785028200.7019
- Time Taken: 0.00090813636779785
- 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 `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(168, 'vbulletin-[len:33]') 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: 1785028200.7021
- Time After: 1785028200.7025
- Time Taken: 0.00037598609924316
- 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: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(168, 'vbulletin-[len:33]') 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: 1785028200.7026
- Time After: 1785028200.7035
- Time Taken: 0.00084304809570312
- 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 `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(168, 'vbulletin-[len:33]') 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: 1785028200.7037
- Time After: 1785028200.704
- Time Taken: 0.00034713745117188
- 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: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(168, 'vbulletin-[len:33]') 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: 1785028200.7041
- Time After: 1785028200.7049
- Time Taken: 0.00076007843017578
- 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 `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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vbPre_')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1785028200.7079
- Time After: 1785028200.7085
- Time Taken: 0.00059390068054199
- 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('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(false) in /core/vb/vb/api/page.php(1442)
#10 vB_Api_Page->preload(false) 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM closure
WHERE `child` IN (234780)
ORDER BY `child` ASC, `depth` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | closure | ref | child | child | 4 | const | 4 | Using where |
- Time Before: 1785028200.7087
- Time After: 1785028200.7093
- Time Taken: 0.00060892105102539
- 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:84]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in /core/vb/vb/library/node.php(3807)
#7 vB_Library_Node->fetchClosureParent(array[len:1])
#8 ReflectionMethod->invokeArgs(vB_Library_Node, array[len:1]) in /core/vb/vb/library/page.php(62)
#9 vB_Library_Page->preload(false) in /core/vb/vb/api/page.php(1442)
#10 vB_Api_Page->preload(false) 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('node_234780_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: 1785028200.7095
- Time After: 1785028200.7098
- Time Taken: 0.00035786628723145
- 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:65]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/content.php(3893)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in /core/vb/vb/library/node.php(1055)
#10 vB_Library_Node->getNodes(array[len:1])
#11 ReflectionMethod->invokeArgs(vB_Library_Node, array[len:1]) in /core/vb/vb/library/page.php(62)
#12 vB_Library_Page->preload(false) in /core/vb/vb/api/page.php(1442)
#13 vB_Api_Page->preload(false) in /core/vb/vb/api/wrapper.php(205)
#14 vB_Api_Wrapper->__call('preload', array[len:1]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('page', 'preload', array[len:1]) in /includes/vb5/frontend/controller/page.php(82)
#16 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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 = 168
/**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: 1785028200.7104
- Time After: 1785028200.7131
- Time Taken: 0.0027749538421631
- 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, '\n\t\t\t\tSELEC[len:430]', 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(168, array[len:2]) 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_60d69e6f6e230382599762_title','page_60d69e6f6e230382599762_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: 1785028200.7134
- Time After: 1785028200.7288
- Time Taken: 0.015437841415405
- 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 `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(168, array[len:2]) 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(168, 'vbulletin-[len:33]') 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: 1785028200.7294
- Time After: 1785028200.7314
- Time Taken: 0.0019540786743164
- 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/api/page.php(40)
#8 ruforum_Api_Page->fetchPageById(array[len:24], 168, array[len:2]) 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(168, 'vbulletin-[len:33]') 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: 1785028200.732
- Time After: 1785028200.7327
- Time Taken: 0.00072693824768066
- 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('') 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:24], 168, array[len:2]) 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(168, 'vbulletin-[len:33]') 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: 1785028200.7332
- Time After: 1785028200.7337
- Time Taken: 0.00051093101501465
- 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 `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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `pagetemplateid` IN (61,-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 | | 2 | Using index condition; Using filesort |
- Time Before: 1785028200.7343
- Time After: 1785028200.7349
- Time Taken: 0.00057578086853027
- 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:128]', 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('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#9 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') 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(75)
/**getWidgetdefinition**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widget | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | widgetdefinition | ref | widgetid | widgetid | 4 | const | 7 | |
- Time Before: 1785028200.7351
- Time After: 1785028200.7358
- Time Taken: 0.00073909759521484
- Memory Before: 4194304
- Memory After: 6291456
- 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, '\n\t\t\t\tSELEC[len:241]', false) in /core/vb/vb/db/query/stored.php(103)
#4 vB_dB_Query_Stored->execSQL() in /core/vb/vb/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('getWidgetdefinition', array[len:1]) in /core/vb/vb/api/widget.php(1894)
#6 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#8 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `widgetinstanceid` IN (205)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetinstance | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785028200.7359
- Time After: 1785028200.7363
- Time Taken: 0.00036382675170898
- 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: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('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:1]) in /core/vb/vb/api/widget.php(1923)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widget
WHERE `widgetid` IN (0,75)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widget | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
- Time Before: 1785028200.7364
- Time After: 1785028200.7368
- Time Taken: 0.00041413307189941
- 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('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:2]) in /core/vb/vb/api/widget.php(1927)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') 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: 1785028200.7373
- Time After: 1785028200.7377
- Time Taken: 0.00039792060852051
- 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 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('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#18 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#19 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') 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: 1785028200.7379
- Time After: 1785028200.7384
- Time Taken: 0.00058698654174805
- 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: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('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#20 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#21 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_displaytemplate_widgettitle','generic_widgetcat') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 6 | Using index condition |
- Time Before: 1785028200.739
- Time After: 1785028200.7398
- Time Taken: 0.00078606605529785
- 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:157]', 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/vb/vb/api/widget.php(1503)
#10 vB_Api_Widget->addWidgetTitles(array[len:1]) in /core/vb/vb/api/widget.php(2053)
#11 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('61', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#12 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('61', '') in /core/vb/vb/api/widget.php(2129)
#13 vB_Api_Widget->fetchLayoutSectionInfo('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM pagetemplate
WHERE `pagetemplateid` = 61
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: 1785028200.74
- Time After: 1785028200.7404
- Time Taken: 0.00038790702819824
- 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('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('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') 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: 1785028200.7404
- Time After: 1785028200.7407
- Time Taken: 0.0002899169921875
- 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: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('61', '') 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]', '61', '') 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(168, 'vbulletin-[len:33]') 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: 1785028200.7413
- Time After: 1785028200.7428
- Time Taken: 0.001507043838501
- 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: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:198393]') in /includes/vb5/template.php(426)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7481
- Time After: 1785028200.7497
- Time Taken: 0.0015718936920166
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7522
- Time After: 1785028200.755
- Time Taken: 0.002795934677124
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7557
- Time After: 1785028200.7564
- Time Taken: 0.00069022178649902
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7571
- Time After: 1785028200.7587
- Time Taken: 0.0016319751739502
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7592
- Time After: 1785028200.7608
- Time Taken: 0.0016539096832275
- Memory Before: 6291456
- Memory After: 8388608
- 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(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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7613
- Time After: 1785028200.7626
- Time Taken: 0.0012691020965576
- 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('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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7634
- Time After: 1785028200.7642
- 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 `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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7656
- Time After: 1785028200.7724
- Time Taken: 0.0068111419677734
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7752
- Time After: 1785028200.7799
- Time Taken: 0.0047049522399902
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7804
- Time After: 1785028200.7821
- Time Taken: 0.0016820430755615
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7834
- Time After: 1785028200.7866
- Time Taken: 0.0032079219818115
- 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('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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7871
- Time After: 1785028200.7896
- Time Taken: 0.0024831295013428
- 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') 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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7917
- Time After: 1785028200.7979
- Time Taken: 0.0061819553375244
- 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 `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('', 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', '', 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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.7984
- Time After: 1785028200.8011
- Time Taken: 0.0026981830596924
- 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: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:74511]') 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:198393]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.8022
- Time After: 1785028200.8051
- Time Taken: 0.002924919128418
- 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') 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:198393]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.8062
- Time After: 1785028200.8089
- Time Taken: 0.0027260780334473
- 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') 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:198393]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2259)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785028200.8125
- Time After: 1785028200.8193
- Time Taken: 0.0068159103393555
- 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: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:1302]') 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:1660]') 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:1875]') 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:198393]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.8202
- Time After: 1785028200.8261
- Time Taken: 0.0058529376983643
- 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: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: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:1009]') 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:1302]') 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:1660]') 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:1875]') 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:198393]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.8305
- Time After: 1785028200.8424
- Time Taken: 0.011929035186768
- 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: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', '/earn_mone[len:21]', false) in /core/vb/vb/library/site.php(207)
#9 vB_Library_Site->loadFooterNavbar('1', '/earn_mone[len:21]', false) in /core/vb/vb/api/site.php(108)
#10 vB_Api_Site->loadFooterNavbar('1', '/earn_mone[len:21]') 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', '/earn_mone[len:21]') 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:198393]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') 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: 1785028200.8445
- Time After: 1785028200.8478
- Time Taken: 0.003223180770874
- 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: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:66299]') 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:198393]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(168, 'vbulletin-[len:33]') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('ogg_description','logo','powered_by_vbulletin_title','search','advanced_search','forum','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','popular_posts_per_day','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','collapse','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 | | 306 | Using index condition |
- Time Before: 1785028200.8518
- Time After: 1785028200.8612
- Time Taken: 0.0094189643859863
- 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 `va[len:2143]', 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:102], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:102]) 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:198393]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:198393]', 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(168, 'vbulletin-[len:33]') 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: 1785028200.8772
- Time After: 1785028200.8782
- Time Taken: 0.0009920597076416
- 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: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:198393]') in /includes/vb5/template.php(517)
#13 vB5_Template->renderDelayed('<!-- BEGIN[len:198393]', 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(168, 'vbulletin-[len:33]') 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: 1785028200.8786
- Time After: 1785028200.8793
- Time Taken: 0.00062012672424316
- 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: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:198393]') in /includes/vb5/template.php(517)
#17 vB5_Template->renderDelayed('<!-- BEGIN[len:198393]', 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(168, 'vbulletin-[len:33]') 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: 1785028200.8795
- Time After: 1785028200.8823
- Time Taken: 0.0028500556945801
- 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 `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:198393]') in /includes/vb5/template.php(517)
#19 vB5_Template->renderDelayed('<!-- BEGIN[len:198393]', 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(168, 'vbulletin-[len:33]') 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: 1785028200.8864
- Time After: 1785028200.8876
- Time Taken: 0.0012149810791016
- 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: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:198393]', 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(168, 'vbulletin-[len:33]') 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: 1785028200.8905
- Time After: 1785028200.8936
- Time Taken: 0.0031180381774902
- 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 `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:53323]') in /includes/vb5/template.php(577)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:198393]', 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(168, 'vbulletin-[len:33]') in /index.php(138)
5 Slowest Queries
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 `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_60d69e6f6e230382599762_title','page_60d69e6f6e230382599762_metadesc') AND `languageid` IN (2,0,-1)
SELECT * FROM style
WHERE `styleid` = 45
LIMIT 1
SELECT * FROM site
LIMIT 1
SELECT * FROM cache
WHERE `cacheid` IN ('vB_NamedRoutes')
69 Queries Run : Total SQL time was 0.182414 seconds , Total PHP time was 0.097915 seconds , Overall time was 0.280329 seconds.