vBulletin - Explain SQL Queries (72)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
SET @@sql_mode = ''
- Time Before: 1785027125.919
- Time After: 1785027125.9192
- Time Taken: 0.00019598007202148
- 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: 1785027125.9202
- Time After: 1785027125.9233
- Time Taken: 0.0031468868255615
- 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 `sessionhash` = '2a9f434bdcf6f05f3d918c71fb48defa' AND `lastactivity` > 1785019925
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | session | const | PRIMARY,last_activity,idx_lastactivity | PRIMARY | 96 | const | 1 | |
- Time Before: 1785027125.9252
- Time After: 1785027125.9264
- Time Taken: 0.0011570453643799
- 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:123]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:3], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:3]) in /core/vb/vb/session.php(328)
#8 vB_Session->fetchStoredSession('2a9f434bdc[len:32]', array[len:2]) in /core/vb/vb/session.php(131)
#9 vB_Session->loadExistingSession('2a9f434bdc[len:32]', array[len:2], false) in /core/vb/vb/session.php(546)
#10 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '2a9f434bdc[len:32]', array[len:2], 0, 0) in /core/vb/vb/session/web.php(31)
#11 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '2a9f434bdc[len:32]', array[len:2], 0, 0, true) in /core/vb/vb/session/webapi.php(75)
#12 vB_Session_WebApi::createSessionNew('2a9f434bdc[len:32]', array[len:2], true) in /core/vb/vb/request/webapi.php(55)
#13 vB_Request_WebApi->createSessionNew('2a9f434bdc[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#14 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#15 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#16 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#17 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#18 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785027125.9266
- Time After: 1785027125.927
- Time Taken: 0.00040483474731445
- 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('2a9f434bdc[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#17 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#18 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785027125.9271
- Time After: 1785027125.937
- Time Taken: 0.0098750591278076
- 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('2a9f434bdc[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(198)
#13 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:439]) in /includes/api/interface/collapsed.php(60)
#14 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#15 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(117)
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: 1785027125.9438
- Time After: 1785027125.9877
- Time Taken: 0.043942928314209
- 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('partners', '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 ('partners','') 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: 1785027125.9879
- Time After: 1785027125.9901
- Time Taken: 0.0022010803222656
- 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:142]', 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('partners', '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: 1785027125.9905
- Time After: 1785027125.9931
- Time Taken: 0.0026018619537354
- 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('partners', '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: 1785027125.9946
- Time After: 1785027126.0111
- Time Taken: 0.016489028930664
- 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('partners', '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: 1785027126.0131
- Time After: 1785027126.0202
- Time Taken: 0.0070111751556396
- 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('partners', '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: 1785027126.0211
- Time After: 1785027126.0405
- Time Taken: 0.019397020339966
- 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('partners', '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: 1785027126.0413
- Time After: 1785027126.0556
- Time Taken: 0.014286994934082
- 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('partners', '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: 1785027126.0558
- Time After: 1785027126.0604
- Time Taken: 0.0046379566192627
- 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('partners', '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: 1785027126.0606
- Time After: 1785027126.061
- Time Taken: 0.00040411949157715
- 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('partners', '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: 1785027126.0611
- Time After: 1785027126.0621
- Time Taken: 0.00098013877868652
- 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('partners', '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: 1785027126.0631
- Time After: 1785027126.066
- Time Taken: 0.0029001235961914
- 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(158, '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: 1785027126.0691
- Time After: 1785027126.0817
- Time Taken: 0.012556076049805
- 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(158, '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: 1785027126.083
- Time After: 1785027126.0841
- Time Taken: 0.0010480880737305
- 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(158, '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: 1785027126.0844
- Time After: 1785027126.0854
- Time Taken: 0.00096392631530762
- 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(158, '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: 1785027126.0858
- Time After: 1785027126.0861
- Time Taken: 0.00037717819213867
- 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(158, '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: 1785027126.0863
- Time After: 1785027126.0874
- Time Taken: 0.0010988712310791
- 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(158, '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: 1785027126.0876
- Time After: 1785027126.0879
- Time Taken: 0.00032901763916016
- 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(158, '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: 1785027126.088
- Time After: 1785027126.0887
- Time Taken: 0.00073719024658203
- 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(158, '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: 1785027126.0889
- Time After: 1785027126.0892
- Time Taken: 0.00031185150146484
- 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(158, '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: 1785027126.0894
- Time After: 1785027126.09
- Time Taken: 0.00066399574279785
- 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(158, '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: 1785027126.0928
- Time After: 1785027126.1132
- Time Taken: 0.020341873168945
- 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(158, '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: 1785027126.1135
- Time After: 1785027126.1141
- Time Taken: 0.00059103965759277
- 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(158, '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: 1785027126.1143
- Time After: 1785027126.1147
- Time Taken: 0.00039887428283691
- 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(158, '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 = 158
/**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: 1785027126.1153
- Time After: 1785027126.1349
- Time Taken: 0.019640207290649
- 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(158, 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_6087a7614ad7e978597755_title','page_6087a7614ad7e978597755_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: 1785027126.1352
- Time After: 1785027126.136
- Time Taken: 0.00083494186401367
- 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(158, 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM routenew
WHERE `routeid` = 235
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | routenew | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785027126.1363
- Time After: 1785027126.1367
- Time Taken: 0.0004119873046875
- 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:55]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in /core/vb/vb/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent(235) in /core/vb5/route.php(1336)
#9 vB5_Route::getClassName(235, array[len:14]) in /core/vb5/route.php(1351)
#10 vB5_Route::getRoute(235, array[len:2]) in /core/vb/vb/api/page.php(102)
#11 vB_Api_Page->fetchPageById(158, 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(158, '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: 1785027126.1369
- Time After: 1785027126.1384
- Time Taken: 0.0015380382537842
- 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], 158, 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(158, '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: 1785027126.139
- Time After: 1785027126.1434
- Time Taken: 0.0044190883636475
- 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], 158, 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(158, '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: 1785027126.1438
- Time After: 1785027126.1442
- Time Taken: 0.00033903121948242
- 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `pagetemplateid` IN (47,-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 | | 4 | Using index condition; Using filesort |
- Time Before: 1785027126.1447
- Time After: 1785027126.1452
- Time Taken: 0.00052809715270996
- 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, '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('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#9 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, '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,36,56)
/**getWidgetdefinition**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetdefinition | range | widgetid | widgetid | 4 | | 12 | Using index condition |
| 1 | SIMPLE | widget | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.widgetdefinition.widgetid | 1 | |
- Time Before: 1785027126.1453
- Time After: 1785027126.1459
- Time Taken: 0.00056600570678711
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:247]', 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('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#8 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `widgetinstanceid` IN (190,188,189)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetinstance | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
- Time Before: 1785027126.1461
- Time After: 1785027126.1464
- Time Taken: 0.00032401084899902
- 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('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:3]) in /core/vb/vb/api/widget.php(1923)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM widget
WHERE `widgetid` IN (0,75,36,56)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widget | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
- Time Before: 1785027126.1465
- Time After: 1785027126.1469
- Time Taken: 0.00034809112548828
- 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:55]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('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:4]) in /core/vb/vb/api/widget.php(1927)
#9 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, '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: 1785027126.1473
- Time After: 1785027126.1496
- Time Taken: 0.0022938251495361
- 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('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#18 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#19 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, '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: 1785027126.1497
- Time After: 1785027126.1503
- Time Taken: 0.00052499771118164
- 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('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#20 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#21 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_displaytemplate_widgettitle','generic_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 15 | Using index condition |
- Time Before: 1785027126.1507
- Time After: 1785027126.1852
- Time Taken: 0.034530162811279
- 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:242]', 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:5], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:5]) in /core/vb/vb/api/widget.php(1503)
#10 vB_Api_Widget->addWidgetTitles(array[len:3]) in /core/vb/vb/api/widget.php(2053)
#11 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('47', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#12 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('47', '') in /core/vb/vb/api/widget.php(2129)
#13 vB_Api_Widget->fetchLayoutSectionInfo('47', '') 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]', '47', '') 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(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT * FROM pagetemplate
WHERE `pagetemplateid` = 47
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: 1785027126.1854
- Time After: 1785027126.186
- Time Taken: 0.0005347728729248
- 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('47', '') 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]', '47', '') 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(158, '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: 1785027126.186
- Time After: 1785027126.1863
- Time Taken: 0.00027704238891602
- 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('47', '') 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]', '47', '') 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(158, '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: 1785027126.1867
- Time After: 1785027126.1896
- Time Taken: 0.0028970241546631
- 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:221324]') in /includes/vb5/template.php(426)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.1945
- Time After: 1785027126.2174
- Time Taken: 0.022909879684448
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2197
- Time After: 1785027126.2233
- Time Taken: 0.0035989284515381
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2238
- Time After: 1785027126.2253
- Time Taken: 0.0015108585357666
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2258
- Time After: 1785027126.2329
- Time Taken: 0.0070290565490723
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2333
- Time After: 1785027126.2417
- Time Taken: 0.0083620548248291
- 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(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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2421
- Time After: 1785027126.2457
- Time Taken: 0.0036139488220215
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2462
- Time After: 1785027126.2473
- Time Taken: 0.0011160373687744
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2485
- Time After: 1785027126.254
- Time Taken: 0.0054728984832764
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2554
- Time After: 1785027126.2702
- Time Taken: 0.014799118041992
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2709
- Time After: 1785027126.2766
- Time Taken: 0.0057790279388428
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2778
- Time After: 1785027126.2813
- Time Taken: 0.0035040378570557
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2817
- Time After: 1785027126.2853
- Time Taken: 0.0036718845367432
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2871
- Time After: 1785027126.2893
- Time Taken: 0.002173900604248
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2896
- Time After: 1785027126.2904
- Time Taken: 0.00082516670227051
- 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:74508]') 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:221324]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2912
- Time After: 1785027126.2963
- Time Taken: 0.0051529407501221
- 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:221324]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.2969
- Time After: 1785027126.2993
- Time Taken: 0.0024220943450928
- 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:221324]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (1933,2267)
| 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: 1785027126.3011
- Time After: 1785027126.305
- Time Taken: 0.0038900375366211
- 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:3844]') 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:4168]') 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:4383]') 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:221324]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.3059
- Time After: 1785027126.3076
- Time Taken: 0.0016911029815674
- 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:1940]') 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:3844]') 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:4168]') 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:4383]') 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:221324]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.3107
- Time After: 1785027126.3114
- Time Taken: 0.00070714950561523
- 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:20241]') 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:20599]') 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:20814]') 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:221324]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(158, 'vbulletin-[len:33]') in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2309)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785027126.3121
- Time After: 1785027126.3124
- Time Taken: 0.00036716461181641
- 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:19948]') 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:20241]') 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:20599]') 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:20814]') 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:221324]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.5481
- Time After: 1785027126.5615
- Time Taken: 0.013370990753174
- 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', '/partners?explain=1', false) in /core/vb/vb/library/site.php(207)
#9 vB_Library_Site->loadFooterNavbar('1', '/partners?explain=1', false) in /core/vb/vb/api/site.php(108)
#10 vB_Api_Site->loadFooterNavbar('1', '/partners?explain=1') 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', '/partners?explain=1') 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:221324]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(158, '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: 1785027126.5635
- Time After: 1785027126.5675
- Time Taken: 0.0039868354797363
- 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:221324]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(158, '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','announcement','no_announcement','popular_posts_per_day','expand','collapse','page_title','read_details','go_to_site','new','not_verify_accuracy','go_to_top','go_to_bottom','navbar_contact_us','forexdengi_thanks','today','all_times_are_gmt_x_time_now_is_y','working_ellipsis','yes','no','ok','cancel','facebook_language','see_more','select_currencies','hide','display_in_full','comment_login','no_last_post_in_thread','successfully_added_user_to_subscribe_list','successfully_added_user_to_unsubscribe_list','no_quotes_found','mentions') AND `languageid` IN (2,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | phrase | range | name_lang_type,languageid | name_lang_type | 577 | | 330 | Using index condition |
- Time Before: 1785027126.5749
- Time After: 1785027126.5857
- Time Taken: 0.010801076889038
- 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:2254]', 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:110], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:110]) 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:221324]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:221324]', 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(158, '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: 1785027126.597
- Time After: 1785027126.6169
- Time Taken: 0.019912958145142
- 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:221324]') in /includes/vb5/template.php(517)
#13 vB5_Template->renderDelayed('<!-- BEGIN[len:221324]', 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(158, '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: 1785027126.6172
- Time After: 1785027126.6179
- Time Taken: 0.00069093704223633
- 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:221324]') in /includes/vb5/template.php(517)
#17 vB5_Template->renderDelayed('<!-- BEGIN[len:221324]', 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(158, '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: 1785027126.618
- Time After: 1785027126.6188
- Time Taken: 0.00079703330993652
- 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:221324]') in /includes/vb5/template.php(517)
#19 vB5_Template->renderDelayed('<!-- BEGIN[len:221324]', 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(158, '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: 1785027126.6222
- Time After: 1785027126.6228
- Time Taken: 0.0006110668182373
- 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:221324]', 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(158, '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: 1785027126.6248
- Time After: 1785027126.6274
- Time Taken: 0.0025990009307861
- 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:53904]') in /includes/vb5/template.php(577)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:221324]', 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(158, 'vbulletin-[len:33]') in /index.php(138)
5 Slowest Queries
SELECT * FROM cache
WHERE `cacheid` IN ('vB_CommonRoutes')
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_displaytemplate_widgettitle','generic_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (2,0,-1)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2029,2424,1907,2399,2238,2406,2338)
SELECT * FROM cache
WHERE `cacheid` IN ('vbPre_')
SELECT * FROM routenew
WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw')
72 Queries Run : Total SQL time was 0.390425 seconds , Total PHP time was 0.317934 seconds , Overall time was 0.708359 seconds.