vBulletin - Explain SQL Queries (70)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
SET @@sql_mode = ''
- Time Before: 1785031275.0793
- Time After: 1785031275.0903
- Time Taken: 0.010969161987305
- 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: 1785031275.0912
- Time After: 1785031275.1024
- Time Taken: 0.011185169219971
- 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` > 1785024075
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: 1785031275.1047
- Time After: 1785031275.1153
- Time Taken: 0.010605096817017
- 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: 1785031275.1156
- Time After: 1785031275.1263
- Time Taken: 0.010682106018066
- 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: 1785031275.1265
- Time After: 1785031275.1478
- Time Taken: 0.021310091018677
- 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: 1785031275.1543
- Time After: 1785031275.1653
- Time Taken: 0.011033058166504
- 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('lostpw', '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 ('lostpw','') 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: 1785031275.1657
- Time After: 1785031275.1804
- Time Taken: 0.01468300819397
- 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:140]', 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('lostpw', '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: 1785031275.1811
- Time After: 1785031275.1837
- Time Taken: 0.002554178237915
- 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('lostpw', '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 page
WHERE `pageid` = 4
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: 1785031275.1841
- Time After: 1785031275.1965
- Time Taken: 0.012413024902344
- Memory Before: 2097152
- Memory After: 2097152
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:48]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('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:1], 'explain=1', '') in /core/vb5/route.php(1168)
#10 vB5_Route::checkRoute(array[len:14], 'lostpw', 'lostpw', 'explain=1', '') in /core/vb5/route.php(1104)
#11 vB5_Route::selectBestRoute('lostpw', 'explain=1', '', array[len:3]) in /core/vb/vb/api/route.php(160)
#12 vB_Api_Route->getRoute('lostpw', 'explain=1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#15 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#16 vB5_Frontend_Application::init('config.php') in /index.php(117)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('page_4ecbdac82f039695291106_title','page_4ecbdac82f039695291106_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: 1785031275.1968
- Time After: 1785031275.198
- Time Taken: 0.0011391639709473
- 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 `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:1], 'explain=1', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'lostpw', 'lostpw', 'explain=1', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('lostpw', 'explain=1', '', array[len:3]) in /core/vb/vb/api/route.php(160)
#14 vB_Api_Route->getRoute('lostpw', '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: 1785031275.1999
- Time After: 1785031275.2023
- Time Taken: 0.0024678707122803
- 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('lostpw', '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: 1785031275.2043
- Time After: 1785031275.2055
- Time Taken: 0.0011758804321289
- 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('lostpw', '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: 1785031275.2061
- Time After: 1785031275.2066
- Time Taken: 0.00051593780517578
- 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('lostpw', '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: 1785031275.2077
- Time After: 1785031275.2085
- Time Taken: 0.00083184242248535
- Memory Before: 2097152
- Memory After: 4194304
- Memory Used: 2097152
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len: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('lostpw', '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: 1785031275.2088
- Time After: 1785031275.2099
- Time Taken: 0.0011801719665527
- 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: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('lostpw', '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: 1785031275.2101
- Time After: 1785031275.2106
- Time Taken: 0.00049185752868652
- 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('lostpw', '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: 1785031275.2107
- Time After: 1785031275.2111
- Time Taken: 0.00039196014404297
- 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('lostpw', '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 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: 1785031275.2113
- Time After: 1785031275.2122
- Time Taken: 0.00083017349243164
- 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('12') in /core/vb5/route.php(1336)
#11 vB5_Route::getClassName('12', array[len:14]) in /core/vb5/route.php(1351)
#12 vB5_Route::getRoute('12', array[len:0], array[len:1]) in /core/vb5/route/page.php(184)
#13 vB5_Route_Page->getCanonicalRoute() in /core/vb/vb/api/route.php(253)
#14 vB_Api_Route->getRoute('lostpw', '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: 1785031275.2145
- Time After: 1785031275.215
- Time Taken: 0.00046491622924805
- 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(4, '4') 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: 1785031275.2176
- Time After: 1785031275.218
- Time Taken: 0.00037789344787598
- 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(4, '4') 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: 1785031275.218
- Time After: 1785031275.2188
- Time Taken: 0.0007169246673584
- 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(4, '4') 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: 1785031275.2189
- Time After: 1785031275.2198
- Time Taken: 0.00085210800170898
- 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(4, '4') 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: 1785031275.2199
- Time After: 1785031275.2215
- Time Taken: 0.0015840530395508
- 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(4, '4') 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: 1785031275.2217
- Time After: 1785031275.2221
- Time Taken: 0.00038790702819824
- 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(4, '4') 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: 1785031275.2221
- Time After: 1785031275.2229
- Time Taken: 0.00077414512634277
- 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(4, '4') 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: 1785031275.2231
- Time After: 1785031275.2234
- 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(4, '4') 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: 1785031275.2235
- Time After: 1785031275.2241
- Time Taken: 0.00067281723022461
- 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(4, '4') in /index.php(138)
SELECT * FROM cache
WHERE `cacheid` IN ('vbPre_page12.4')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1785031275.2266
- Time After: 1785031275.227
- Time Taken: 0.00039386749267578
- 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/vb/vb/library/page.php(40)
#9 vB_Library_Page->preload('page12.4') in /core/vb/vb/api/page.php(1442)
#10 vB_Api_Page->preload('page12.4') 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(4, '4') in /index.php(138)
UPDATE session SET `wol`='a:3:{s:6:\"action\";s:9:\"viewing_x\";s:6:\"params\";a:2:{i:0;s:15:\"Forgot Password\";i:1;s:44:\"https://investsocial.com/pt/lostpw?explain=1\";}s:6:\"nodeid\";i:0;}',`pagekey`='page12.4',`location`='/lostpw?explain=1'
WHERE (`sessionhash` = '2a9f434bdcf6f05f3d918c71fb48defa')
/**session**/
- Time Before: 1785031275.2275
- Time After: 1785031275.2281
- Time Taken: 0.00055909156799316
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(572)
#1 vB_Database->query_write('') in /core/vb/vb/db/query/update.php(103)
#2 vB_dB_Query_Update->doUpdates() in /core/vb/vb/db/query/update.php(88)
#3 vB_dB_Query_Update->execSQL() in /core/vb/vb/db/assertor.php(293)
#4 vB_dB_Assertor->assertQuery('session', array[len:5]) in /core/vb/vb/api/wol.php(60)
#5 vB_Api_Wol->register('viewing_x', array[len:2], 'page12.4', '/lostpw?explain=1', 0) in /core/vb/vb/api/wrapper.php(205)
#6 vB_Api_Wrapper->__call('register', array[len:5]) in /includes/api/interface/collapsed.php(105)
#7 Api_Interface_Collapsed->callApi('wol', 'register', array[len:5]) in /includes/vb5/frontend/controller/page.php(94)
#8 vB5_Frontend_Controller_Page->index(4, '4') 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 = 4
/**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: 1785031275.2283
- Time After: 1785031275.2288
- Time Taken: 0.00049400329589844
- 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:428]', 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(4, 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(4, '4') 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: 1785031275.2291
- Time After: 1785031275.2303
- Time Taken: 0.0011749267578125
- 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], 4, 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(4, '4') 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: 1785031275.2307
- Time After: 1785031275.231
- Time Taken: 0.00026988983154297
- 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], 4, 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(4, '4') 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: 1785031275.2313
- Time After: 1785031275.2316
- Time Taken: 0.00029993057250977
- 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(4, '4') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `pagetemplateid` IN (7,-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: 1785031275.2319
- Time After: 1785031275.2324
- Time Taken: 0.00043201446533203
- 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:127]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('widgetinstance', array[len:1], array[len:3]) in /core/vb/vb/api/widget.php(1871)
#7 vB_Api_Widget->fetchWidgetInstancesByPageTemplateId('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#8 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#9 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') 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(38,36,56)
/**getWidgetdefinition**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetdefinition | range | widgetid | widgetid | 4 | | 8 | Using index condition |
| 1 | SIMPLE | widget | eq_ref | PRIMARY | PRIMARY | 4 | brazilforum_new.widgetdefinition.widgetid | 1 | |
- Time Before: 1785031275.2325
- Time After: 1785031275.2332
- Time Taken: 0.00075912475585938
- 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: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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#7 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#8 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') in /index.php(138)
SELECT * FROM widgetinstance
WHERE `widgetinstanceid` IN (31,29,30)
| 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: 1785031275.2334
- Time After: 1785031275.2337
- Time Taken: 0.00030708312988281
- 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:69]', 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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') in /index.php(138)
SELECT * FROM widget
WHERE `widgetid` IN (0,38,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: 1785031275.2338
- Time After: 1785031275.2341
- Time Taken: 0.00030207633972168
- 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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#10 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#11 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') 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: 1785031275.2345
- Time After: 1785031275.2348
- Time Taken: 0.00030517578125
- 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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#18 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#19 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') 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: 1785031275.2349
- Time After: 1785031275.2353
- Time Taken: 0.00037288665771484
- 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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#20 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#21 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('widget_forgot_password_widgettitle','system_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: 1785031275.2357
- Time After: 1785031275.2365
- Time Taken: 0.00086688995361328
- 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:241]', 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('7', -1, '', false) in /core/vb/vb/api/widget.php(2093)
#12 vB_Api_Widget->fetchHierarchicalWidgetInstancesByPageTemplateId('7', '') in /core/vb/vb/api/widget.php(2129)
#13 vB_Api_Widget->fetchLayoutSectionInfo('7', '') 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]', '7', '') 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(4, '4') in /index.php(138)
SELECT * FROM pagetemplate
WHERE `pagetemplateid` = 7
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: 1785031275.2366
- Time After: 1785031275.2369
- Time Taken: 0.0002748966217041
- 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('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('7', '') 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]', '7', '') 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(4, '4') 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: 1785031275.2369
- Time After: 1785031275.2372
- Time Taken: 0.00024318695068359
- 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('7', '') 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]', '7', '') 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(4, '4') 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: 1785031275.2375
- Time After: 1785031275.2389
- Time Taken: 0.0013961791992188
- 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:205527]') in /includes/vb5/template.php(426)
#14 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#15 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.243
- Time After: 1785031275.2456
- Time Taken: 0.0025389194488525
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2475
- Time After: 1785031275.2482
- Time Taken: 0.0006859302520752
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2487
- Time After: 1785031275.2495
- Time Taken: 0.00081205368041992
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#25 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#26 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.25
- Time After: 1785031275.251
- Time Taken: 0.00098204612731934
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2512
- Time After: 1785031275.2522
- Time Taken: 0.00091004371643066
- Memory Before: 6291456
- Memory After: 8388608
- Memory Used: 2097152
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in /core/vb/vb/db/query/select.php(120)
#4 vB_dB_Query_Select->doSelect() in /core/vb/vb/db/query/select.php(97)
#5 vB_dB_Query_Select->execSQL() in /core/vb/vb/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:1]) in /core/vb/vb/cache/db.php(140)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in /core/vb/vb/cache.php(753)
#8 vB_Cache->read(array[len:1]) in /core/vb/vb/library/style.php(190)
#9 vB_Library_Style->getStylevars(45) in /core/vb/vb/library/style.php(98)
#10 vB_Library_Style->addStylevars(array[len:3]) in /core/vb/vb/library/style.php(1159)
#11 vB_Library_Style->fetchStyles(false, true, array[len:0]) in /core/vb/vb/api/style.php(84)
#12 vB_Api_Style->fetchStyles('0', '1') in /core/vb/vb/api/wrapper.php(205)
#13 vB_Api_Wrapper->__call('fetchStyles', array[len:2]) in /includes/api/interface/collapsed.php(105)
#14 Api_Interface_Collapsed->callApi('style', 'fetchStyles', array[len:2], false, true) in /includes/vb5/template/runtime.php(1034)
#15 vB5_Template_Runtime::parseData('style', 'fetchStyles', '0', '1') in /includes/vb5/template.php(404) : eval()'d code(161)
#16 eval() in /includes/vb5/template.php(404)
#17 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#18 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:74415]') 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:205527]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2524
- Time After: 1785031275.2532
- Time Taken: 0.00075912475585938
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#21 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#22 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2537
- Time After: 1785031275.2543
- Time Taken: 0.00058412551879883
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2553
- Time After: 1785031275.2556
- Time Taken: 0.00033307075500488
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#26 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#27 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2569
- Time After: 1785031275.2574
- Time Taken: 0.00045394897460938
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2576
- Time After: 1785031275.258
- Time Taken: 0.00038313865661621
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2589
- Time After: 1785031275.2592
- Time Taken: 0.00032520294189453
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#23 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#24 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2594
- Time After: 1785031275.2597
- Time Taken: 0.00030398368835449
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2611
- Time After: 1785031275.2615
- Time Taken: 0.00043106079101562
- 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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2618
- Time After: 1785031275.2623
- Time Taken: 0.00055408477783203
- Memory Before: 8388608
- Memory After: 8388608
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in /core/vb/vb/database.php(587)
#1 vB_Database->query_read('', true) in /core/vb/vb/db/result.php(148)
#2 vB_dB_Result->rewind() in /core/vb/vb/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len: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:74415]') 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:205527]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2629
- Time After: 1785031275.2632
- Time Taken: 0.00030183792114258
- 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:205527]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2638
- Time After: 1785031275.264
- Time Taken: 0.00027084350585938
- 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:205527]') in /includes/vb5/template.php(426)
#18 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#19 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2654
- Time After: 1785031275.2659
- Time Taken: 0.00043797492980957
- 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:3854]') 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:4178]') 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:4393]') 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:205527]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2666
- Time After: 1785031275.2671
- Time Taken: 0.00049090385437012
- 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:1935]') in /includes/vb5/template.php(426)
#14 vB5_Template->render(false) in /includes/vb5/template/cache.php(134)
#15 vB5_Template_Cache->replacePlaceholders('<!-- BEGIN[len:3854]') 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:4178]') 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:4393]') 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:205527]') in /includes/vb5/template.php(426)
#22 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#23 vB5_Frontend_Controller_Page->index(4, '4') in /index.php(138)
SELECT `title`,`textonly`,`template_un`,`template` FROM template
WHERE `templateid` IN (2260)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1785031275.2698
- Time After: 1785031275.2704
- Time Taken: 0.00061202049255371
- 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:3147]') 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:3505]') 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:3720]') 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:205527]') in /includes/vb5/template.php(426)
#20 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#21 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.274
- Time After: 1785031275.2752
- Time Taken: 0.0011959075927734
- 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', '/lostpw?explain=1', false) in /core/vb/vb/library/site.php(207)
#9 vB_Library_Site->loadFooterNavbar('1', '/lostpw?explain=1', false) in /core/vb/vb/api/site.php(108)
#10 vB_Api_Site->loadFooterNavbar('1', '/lostpw?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', '/lostpw?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:205527]') in /includes/vb5/template.php(426)
#17 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#18 vB5_Frontend_Controller_Page->index(4, '4') 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: 1785031275.2765
- Time After: 1785031275.2794
- Time Taken: 0.0028538703918457
- 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:205527]') in /includes/vb5/template.php(426)
#16 vB5_Template->render() in /includes/vb5/frontend/controller/page.php(276)
#17 vB5_Frontend_Controller_Page->index(4, '4') in /index.php(138)
SELECT `varname`,`languageid`,`text` FROM phrase
WHERE `varname` IN ('logo','powered_by_vbulletin_title','search','advanced_search','home','logging','you_can_also_login_as','login','register','sb_style','article_switch_mode','article_switch_light_mode','logging_in','username','password','remember_me','forgot_password','log_in','Registration','user_name','confirm_password','email','confirm_email','receive_email_from_bulletin_board_staff','privacyconsent_terms','complete_signup','referrer','timezone_gmt_minus_1200','timezone_gmt_minus_1100','timezone_gmt_minus_1000','timezone_gmt_minus_0930','timezone_gmt_minus_0900','timezone_gmt_minus_0800','timezone_gmt_minus_0700','timezone_gmt_minus_0600','timezone_gmt_minus_0500','timezone_gmt_minus_0430','timezone_gmt_minus_0400','timezone_gmt_minus_0330','timezone_gmt_minus_0300','timezone_gmt_minus_0200','timezone_gmt_minus_0100','timezone_gmt_plus_0000','timezone_gmt_plus_0100','timezone_gmt_plus_0200','timezone_gmt_plus_0300','timezone_gmt_plus_0330','timezone_gmt_plus_0400','timezone_gmt_plus_0430','timezone_gmt_plus_0500','timezone_gmt_plus_0530','timezone_gmt_plus_0545','timezone_gmt_plus_0600','timezone_gmt_plus_0630','timezone_gmt_plus_0700','timezone_gmt_plus_0800','timezone_gmt_plus_0830','timezone_gmt_plus_0845','timezone_gmt_plus_0900','timezone_gmt_plus_0930','timezone_gmt_plus_1000','timezone_gmt_plus_1030','timezone_gmt_plus_1100','timezone_gmt_plus_1200','automatically_detect_dst_settings','dst_corrections_always_on','dst_corrections_always_off','new_posts_nav','forumrules','navbar_privacy','navbar_help','calendar','groups','memeber_list','forum_leaders','monitoring','insta_contests','announcement','no_announcement','popular_posts_per_day','expand','collapse','page_title','forgot_password_title','forgotten_password_request_email','email_address','send_email','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 | | 327 | Using index condition |
- Time Before: 1785031275.2825
- Time After: 1785031275.2913
- Time Taken: 0.0088298320770264
- 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:2267]', 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:109], 2) in /core/vb/vb/api/phrase.php(176)
#9 vB_Api_Phrase->fetch(array[len:109]) 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:205527]') in /includes/vb5/template.php(513)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:205527]', 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(4, '4') 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: 1785031275.3007
- Time After: 1785031275.3016
- Time Taken: 0.00085806846618652
- 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:205527]') in /includes/vb5/template.php(517)
#13 vB5_Template->renderDelayed('<!-- BEGIN[len:205527]', 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(4, '4') 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: 1785031275.3019
- Time After: 1785031275.3022
- Time Taken: 0.00031590461730957
- 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:205527]') in /includes/vb5/template.php(517)
#17 vB5_Template->renderDelayed('<!-- BEGIN[len:205527]', 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(4, '4') 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: 1785031275.3023
- Time After: 1785031275.303
- Time Taken: 0.00068807601928711
- 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:205527]') in /includes/vb5/template.php(517)
#19 vB5_Template->renderDelayed('<!-- BEGIN[len:205527]', 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(4, '4') 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: 1785031275.3063
- Time After: 1785031275.307
- Time Taken: 0.00068211555480957
- 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:205527]', 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(4, '4') 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: 1785031275.3094
- Time After: 1785031275.3117
- Time Taken: 0.002295970916748
- 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:54925]') in /includes/vb5/template.php(577)
#14 vB5_Template->renderDelayed('<!-- BEGIN[len:205527]', 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(4, '4') in /index.php(138)
5 Slowest Queries
SELECT phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
eventdateformatoverride AS lang_eventdateformatoverride,
pickerdateformatoverride AS lang_pickerdateformatoverride,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language WHERE languageid = 2/* fetchLanguage */
SELECT routenew.*
FROM routenew AS routenew
WHERE routenew.prefix IN ('lostpw','') OR ishomeroute = 1
/**get_best_routes**/
SELECT * FROM page
WHERE `pageid` = 4
LIMIT 1
SELECT * FROM datastore
WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes','locations')
SELECT * FROM cache
WHERE `cacheid` IN ('vB_CommonRoutes')
70 Queries Run : Total SQL time was 0.158944 seconds , Total PHP time was 0.073427 seconds , Overall time was 0.232371 seconds.