vBulletin - Explain SQL Queries (126)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
- Times run: 2
SELECT * FROM hmq_routenew
WHERE `routeid` IN (64)
- Times run: 5
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
SET @@sql_mode = ''
- Time Before: 1783541088.5414
- Time After: 1783541088.5415
- Time Taken: 6.2942504882812E-5
- Memory Before: 4194304
- Memory After: 4194304
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(561)
#1 vB_Database->query_write('') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(529)
#2 vB_Database->force_sql_mode('') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/mysql/assertor.php(79)
#3 vB_dB_MYSQL_Assertor->load_database(array[len:4], array[len:8]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(140)
#4 vB_dB_Assertor::init(array[len:4], array[len:8]) in /core/vb/vb.php(835)
#5 vB::getDbAssertor() in /core/vb/vb.php(851)
#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(48)
SELECT * FROM hmq_datastore
WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','prefixcache','vBUgChannelPermissionsFrom','vBChannelTypes','locations')
- Time Before: 1783541088.5533
- Time After: 1783541088.5536
- Time Taken: 0.00024700164794922
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:303]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('datastore', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/datastore.php(602)
#7 vB_Datastore->do_db_fetch(array[len:18]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/datastore.php(556)
#8 vB_Datastore->fetch(array[len:18]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/datastore.php(180)
#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(48)
SELECT * FROM hmq_session
WHERE `sessionhash` = '769be152d06ecb3f53c0a2a6d8726b91' AND `lastactivity` > 1783441088
LIMIT 1
- Time Before: 1783541088.5572
- Time After: 1783541088.5579
- Time Taken: 0.0007021427154541
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:127]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('session', array[len:3], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('session', array[len:3]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(279)
#8 vB_Session->fetchStoredSession('769be152d0[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(132)
#9 vB_Session->loadExistingSession('769be152d0[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(498)
#10 vB_Session->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '769be152d0[len:32]', array[len:2], 0, 0) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/web.php(31)
#11 vB_Session_Web->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '769be152d0[len:32]', array[len:2], 0, 0) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/webapi.php(72)
#12 vB_Session_WebApi->__construct(vB_dB_MYSQL_Assertor, vB_Datastore, array[len:7], '769be152d0[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session/webapi.php(66)
#13 vB_Session_WebApi::createSessionNew('769be152d0[len:32]', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/request/webapi.php(54)
#14 vB_Request_WebApi->createSessionNew('769be152d0[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(180)
#15 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:402]) in /includes/api/interface/collapsed.php(60)
#16 Api_Interface_Collapsed->init() in /includes/api/interfaceabstract.php(71)
#17 Api_InterfaceAbstract::instance() in /includes/vb5/frontend/routing.php(120)
#18 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#19 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('13bd7d9a9062e9bc75fb938051d62b32')
- Time Before: 1783541088.5587
- Time After: 1783541088.5599
- Time Taken: 0.0011858940124512
- Memory Before: 6291456
- Memory After: 6291456
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:81]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/language.php(75)
#9 vB_Language::getPhraseCache('13bd7d9a90[len:32]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/language.php(50)
#10 vB_Language::getPhraseInfo(5) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(835)
#11 vB_Session->loadLanguage() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/session.php(943)
#12 vB_Session->fetch_userinfo() in /core/vb/vb.php(990)
#13 vB::setCurrentSession(vB_Session_WebApi) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/request.php(173)
#14 vB_Request->setSession(vB_Session_WebApi) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/request/webapi.php(55)
#15 vB_Request_WebApi->createSessionNew('769be152d0[len:32]', array[len:2]) in /includes/api/interfaceabstract.php(180)
#16 Api_InterfaceAbstract->createSession(vB_Request_WebApi, array[len:402]) 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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_CommonRoutes')
- Time Before: 1783541088.5685
- Time After: 1783541088.569
- Time Taken: 0.00048494338989258
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1695)
#9 vB5_Route::fetchCommonRoutes() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(87)
#10 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT routenew.*
FROM hmq_routenew AS routenew
WHERE routenew.prefix IN ('forum/c1/z2/page283','forum/c1/z2','forum/c1','forum') OR ishomeroute = 1
/**get_best_routes**/
- Time Before: 1783541088.5694
- Time After: 1783541088.57
- Time Taken: 0.00056290626525879
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, '\n\t\t\t\tSELEC[len:187]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/stored.php(104)
#4 vB_dB_Query_Stored->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#5 vB_dB_Assertor->assertQuery('get_best_routes', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(127)
#6 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms0')
- Time Before: 1783541088.5758
- Time After: 1783541088.5763
- Time Taken: 0.00047612190246582
- Memory Before: 10485760
- Memory After: 10485760
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:62]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(142)
#9 vB_UserContext->reloadUserPerms() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(115)
#10 vB_UserContext->__construct(0, vB_dB_MYSQL_Assertor, vB_Datastore, array[len:8]) in /core/vb/vb.php(940)
#11 vB::getUserContext(0) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/user.php(32)
#12 vB_Library_User->isBanned('0') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/user.php(61)
#13 vB_Library_User->fetchBannedInfo('0') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(152)
#14 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_types.types')
- Time Before: 1783541088.5902
- Time After: 1783541088.5906
- Time Taken: 0.00042009353637695
- Memory Before: 12582912
- Memory After: 12582912
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(183)
#9 vB_Types->loadTypes() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(151)
#10 vB_Types->__construct() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/types.php(167)
#11 vB_Types::instance() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(60)
#12 vB_Library_Node->__construct() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library.php(46)
#13 vB_Library::instance('node') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(534)
#14 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 17, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#15 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 17) in /core/vb5/route/channel.php(21)
#16 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z2/page283', 'explain=1', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/c1/z2/page283', 'explain=1', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#19 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_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')
- Time Before: 1783541088.6078
- Time After: 1783541088.6079
- Time Taken: 0.00015997886657715
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:522]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(957)
#7 vB_Library_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/content/channel.php(156)
#8 vB_Api_Content_Channel->fetchChannelByGUID('vbulletin-[len:33]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(2222)
#9 vB_Library_Node->fetchVMChannel() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(534)
#10 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 17, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#11 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 17) in /core/vb5/route/channel.php(21)
#12 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z2/page283', 'explain=1', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/c1/z2/page283', 'explain=1', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#15 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_17_lvl1data')
- Time Before: 1783541088.608
- Time After: 1783541088.6083
- Time Taken: 0.00026893615722656
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare(17) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(967)
#11 vB_Library_Node->getNode(17) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 17, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 17) in /core/vb5/route/channel.php(21)
#14 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z2/page283', 'explain=1', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z2/page283', 'explain=1', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#17 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('channelperms_1')
- Time Before: 1783541088.6084
- Time After: 1783541088.6085
- Time Taken: 0.00013494491577148
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1], true, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/permissioncontext.php(872)
#9 vB_PermissionContext->loadChannelPermissions(1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/permissioncontext.php(761)
#10 vB_PermissionContext->getChannelPerm(1, 'forumpermissions', 'canview', 17) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(609)
#11 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', 17, false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#12 vB_UserContext->getChannelPermission('forumpermissions', 'canview', 17) in /core/vb5/route/channel.php(21)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z2/page283', 'explain=1', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z2/page283', 'explain=1', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_17_lvl3data')
- Time Before: 1783541088.6086
- Time After: 1783541088.6087
- Time Taken: 9.2029571533203E-5
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#12 vB_Library_Content_Channel->getBareContent(17) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:3], 'explain=1', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:46]', 'forum/c1/z2/page283', 'explain=1', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z2/page283', 'explain=1', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#16 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#17 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#18 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#19 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#20 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl1data')
- Time Before: 1783541088.612
- Time After: 1783541088.6122
- Time Taken: 0.0002140998840332
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(883)
#10 vB_Library_Node->getNodeBare('1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(967)
#11 vB_Library_Node->getNode('1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(535)
#12 vB_UserContext->getChannelLimitPermission('forumpermissions', 'canview', '1', false, false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/usercontext.php(823)
#13 vB_UserContext->getChannelPermission('forumpermissions', 'canview', '1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(215)
#14 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_NamedRoutes')
- Time Before: 1783541088.6123
- Time After: 1783541088.613
- Time Taken: 0.00067305564880371
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:63]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in /core/vb5/route.php(1305)
#9 vB5_Route::loadNameRoutes() in /core/vb5/route.php(1191)
#10 vB5_Route::getRouteByIdent('64') in /core/vb5/route.php(1335)
#11 vB5_Route::getClassName('64', array[len:14]) in /core/vb5/route.php(1350)
#12 vB5_Route::getRoute('64', array[len:1], array[len:1]) in /core/vb5/route/channel.php(432)
#13 vB5_Route_Channel->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#14 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_routenew
WHERE `routeid` = 64
LIMIT 1
- Time Before: 1783541088.6131
- Time After: 1783541088.6132
- Time Taken: 5.5074691772461E-5
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('routenew', array[len:2]) in /core/vb5/route.php(1199)
#8 vB5_Route::getRouteByIdent('64') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('64', array[len:14]) in /core/vb5/route.php(1350)
#10 vB5_Route::getRoute('64', array[len:1], array[len:1]) in /core/vb5/route/channel.php(432)
#11 vB5_Route_Channel->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#12 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_closure
WHERE `child` IN (17)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1783541088.614
- Time After: 1783541088.6168
- Time Taken: 0.0027260780334473
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:84]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:closure', array[len:2], array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(3534)
#7 vB_Library_Node->fetchClosureParent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(997)
#8 vB_Library_Node->getNodeParents(17) in /core/vb5/route.php(360)
#9 vB5_Route->addParentNodeBreadcrumbs(17) in /core/vb5/route.php(342)
#10 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#11 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#12 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#13 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#14 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#15 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#16 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#17 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_2_lvl1data','node_14_lvl1data')
- Time Before: 1783541088.6169
- Time After: 1783541088.6196
- Time Taken: 0.002673864364624
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:83]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:4]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:4], 1) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/node.php(1034)
#10 vB_Library_Node->getNodes(array[len:4]) in /core/vb5/route.php(362)
#11 vB5_Route->addParentNodeBreadcrumbs(17) in /core/vb5/route.php(342)
#12 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#13 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#14 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#15 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_routenew
WHERE `routeid` IN (45,58,64)
- Time Before: 1783541088.6197
- Time After: 1783541088.6198
- Time Taken: 8.2015991210938E-5
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:58]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('routenew', array[len:1]) in /core/vb5/route.php(1285)
#7 vB5_Route::preloadRoutes(array[len:3]) in /core/vb5/route.php(376)
#8 vB5_Route->addParentNodeBreadcrumbs(17) in /core/vb5/route.php(342)
#9 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#10 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#11 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#12 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_2_lvl3data')
- Time Before: 1783541088.6199
- Time After: 1783541088.6217
- Time Taken: 0.0017609596252441
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:64]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#12 vB_Library_Content_Channel->getBareContent('2') in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(17) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#17 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#18 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#19 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_14_lvl3data')
- Time Before: 1783541088.6219
- Time After: 1783541088.622
- Time Taken: 6.6995620727539E-5
- Memory Before: 14680064
- Memory After: 14680064
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:65]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('cache', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache/db.php(154)
#7 vB_Cache_Db->readCacheArray(array[len:1], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/cache.php(761)
#8 vB_Cache->read(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(3855)
#9 vB_Library_Content::fetchFromCache(array[len:1], 3) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2598)
#10 vB_Library_Content->getRawContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content.php(2540)
#11 vB_Library_Content->getBareContent(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/content/channel.php(413)
#12 vB_Library_Content_Channel->getBareContent(14) in /core/vb5/route/channel.php(26)
#13 vB5_Route_Channel->__construct(array[len:14], array[len:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route.php(383)
#15 vB5_Route->addParentNodeBreadcrumbs(17) in /core/vb5/route.php(342)
#16 vB5_Route->setBreadcrumbs() in /core/vb5/route/channel.php(75)
#17 vB5_Route_Channel->setBreadCrumbs() in /core/vb5/route.php(418)
#18 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#19 vB_Api_Route->getRoute('forum/c1/z2/page283', 'explain=1') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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(48)
SELECT `styleid` FROM hmq_channel
WHERE `styleid` IN (2,35,39,40,4,36,6,37,8,38,12,41,14,42,16,43,18,44,20,45,22,46,24,25,26,47,28,48,30,49,32,50,34,51)
- Time Before: 1783541088.6392
- Time After: 1783541088.6424
- Time Taken: 0.0031359195709229
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT `st[len:154]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('vBForum:channel', array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(685)
#7 vB_dB_Assertor->getColumn('vBForum:channel', 'styleid', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(302)
#8 vB_Library_Style->loadForcedStyles() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(267)
#9 vB_Library_Style->getValidStyleFromPreference(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/style.php(45)
#10 vB_Api_Style->getValidStyleFromPreference(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('getValidSt[len:27]', array[len:1]) in /includes/api/interface/collapsed.php(105)
#12 Api_Interface_Collapsed->callApi('style', 'getValidSt[len:27]', array[len:1]) in /includes/vb5/template/stylevar.php(108)
#13 vB5_Template_Stylevar->getStylePreference() in /includes/vb5/template/stylevar.php(37)
#14 vB5_Template_Stylevar->__construct() in /includes/vb5/template/stylevar.php(29)
#15 vB5_Template_Stylevar::instance() in /includes/vb5/frontend/application.php(22)
#16 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_style
WHERE `styleid` = 14
LIMIT 1
- Time Before: 1783541088.6425
- Time After: 1783541088.6479
- Time Taken: 0.0054159164428711
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
#0 vB_Database_MySQLi->execute_query(true, mysqli) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/database.php(576)
#1 vB_Database->query_read('', true) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(144)
#2 vB_dB_Result->rewind() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/result.php(68)
#3 vB_dB_Result->__construct(vB_Database_MySQLi, 'SELECT * F[len:55]', false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(121)
#4 vB_dB_Query_Select->doSelect() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/query/select.php(98)
#5 vB_dB_Query_Select->execSQL() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(293)
#6 vB_dB_Assertor->assertQuery('style', array[len:2], false) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/db/assertor.php(617)
#7 vB_dB_Assertor->getRow('style', array[len:2]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library/style.php(700)
#8 vB_Library_Style->fetchStyleByID(14) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/style.php(59)
#9 vB_Api_Style->fetchStyleVars(array[len:1]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#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 /includes/vb5/frontend/application.php(22)
#15 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10763)
- Time Before: 1783541088.6575
- Time After: 1783541088.6624
- Time Taken: 0.0049030780792236
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 3
LIMIT 1
- Time Before: 1783541088.6662
- Time After: 1783541088.6846
- Time Taken: 0.018386125564575
- Memory Before: 16777216
- Memory After: 16777216
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291105_title','page_4ecbdac82f039695291105_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.6873
- Time After: 1783541088.6928
- Time Taken: 0.005479097366333
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 23
LIMIT 1
- Time Before: 1783541088.694
- Time After: 1783541088.7029
- Time Taken: 0.00888991355896
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f2c2760323374_title','page_4ecbdac82f2c2760323374_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.703
- Time After: 1783541088.7061
- Time Taken: 0.0030360221862793
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 6
LIMIT 1
- Time Before: 1783541088.7063
- Time After: 1783541088.7264
- Time Taken: 0.020034074783325
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291108_title','page_4ecbdac82f039695291108_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.7266
- Time After: 1783541088.7299
- Time Taken: 0.0033638477325439
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 5
LIMIT 1
- Time Before: 1783541088.7303
- Time After: 1783541088.7316
- Time Taken: 0.0013580322265625
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f039695291107_title','page_4ecbdac82f039695291107_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.7318
- Time After: 1783541088.7322
- Time Taken: 0.00037407875061035
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vbPre_channel64.48.17')
- Time Before: 1783541088.7425
- Time After: 1783541088.7464
- Time Taken: 0.0039298534393311
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_3156_lvl1data')
- Time Before: 1783541088.7466
- Time After: 1783541088.7479
- Time Taken: 0.0013048648834229
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_44_5')
- Time Before: 1783541088.7481
- Time After: 1783541088.7482
- Time Taken: 7.7009201049805E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM hmq_user AS user
LEFT JOIN hmq_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN hmq_usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE user.userid IN (44)
/** fetchUserinfo **/
- Time Before: 1783541088.7486
- Time After: 1783541088.7539
- Time Taken: 0.0052280426025391
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (64)
- Time Before: 1783541088.754
- Time After: 1783541088.7571
- Time Taken: 0.003140926361084
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_3156')
- Time Before: 1783541088.7578
- Time After: 1783541088.7637
- Time Taken: 0.0059280395507812
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM hmq_closure AS cl
INNER JOIN hmq_attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (3156)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Time Before: 1783541088.7639
- Time After: 1783541088.767
- Time Taken: 0.0031061172485352
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM hmq_closure AS cl
INNER JOIN hmq_node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (3156) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Time Before: 1783541088.7671
- Time After: 1783541088.7689
- Time Taken: 0.0017719268798828
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (3156)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1783541088.7691
- Time After: 1783541088.7806
- Time Taken: 0.011538982391357
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_3156_lvl3data')
- Time Before: 1783541088.7865
- Time After: 1783541088.7963
- Time Taken: 0.0097908973693848
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.8105
- Time After: 1783541088.8154
- Time Taken: 0.0048768520355225
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms44')
- Time Before: 1783541088.8157
- Time After: 1783541088.818
- Time Taken: 0.0023009777069092
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBUserRep_44')
- Time Before: 1783541088.8181
- Time After: 1783541088.8231
- Time Taken: 0.0049819946289062
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (44)
/**fetchAvatarsForUsers**/
- Time Before: 1783541088.8241
- Time After: 1783541088.8285
- Time Taken: 0.0044369697570801
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
- Time Before: 1783541088.8351
- Time After: 1783541088.8415
- Time Taken: 0.0064430236816406
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT page.*, pagetemplate.screenlayoutid, screenlayout.template AS screenlayouttemplate, pagetemplate.title AS templatetitle
FROM hmq_page AS page
LEFT JOIN hmq_pagetemplate AS pagetemplate ON(page.pagetemplateid = pagetemplate.pagetemplateid)
LEFT JOIN hmq_screenlayout AS screenlayout ON(pagetemplate.screenlayoutid = screenlayout.screenlayoutid)
WHERE page.pageid = 48
/**fetch_page_pagetemplate_screenlayout**/
- Time Before: 1783541088.8417
- Time After: 1783541088.8462
- Time Taken: 0.0045289993286133
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_54c8a2f21bbdf396716283_title','page_54c8a2f21bbdf396716283_metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.8463
- Time After: 1783541088.855
- Time Taken: 0.0086498260498047
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10582)
- Time Before: 1783541088.8556
- Time After: 1783541088.8595
- Time Taken: 0.003943920135498
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `pagetemplateid` IN (2,-1)
ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
- Time Before: 1783541088.8674
- Time After: 1783541088.8777
- Time Taken: 0.01030707359314
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT widgetdefinition.*, widget.template
FROM hmq_widgetdefinition AS widgetdefinition
JOIN hmq_widget AS widget ON (widgetdefinition.widgetid = widget.widgetid)
WHERE widgetdefinition.widgetid IN(191,189,213,236)
/**getWidgetdefinition**/
- Time Before: 1783541088.8779
- Time After: 1783541088.8781
- Time Taken: 0.00020003318786621
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `widgetinstanceid` IN (13,12,10,11)
- Time Before: 1783541088.8782
- Time After: 1783541088.8789
- Time Taken: 0.00075292587280273
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widget
WHERE `widgetid` IN (0,191,189,213,236)
- Time Before: 1783541088.879
- Time After: 1783541088.8847
- Time Taken: 0.0057079792022705
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT COUNT(*) AS count FROM hmq_moderator
WHERE `userid` = 0
- Time Before: 1783541088.8871
- Time After: 1783541088.8892
- Time Taken: 0.00211501121521
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_datastore
WHERE `title` IN ('vBUgChannelAccessG1')
- Time Before: 1783541088.8894
- Time After: 1783541088.8899
- Time Taken: 0.00050783157348633
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 13 AND `nodeid` = 17
- Time Before: 1783541088.8903
- Time After: 1783541088.9024
- Time Taken: 0.012057065963745
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 12 AND `nodeid` = 17
- Time Before: 1783541088.9026
- Time After: 1783541088.9083
- Time Taken: 0.0057039260864258
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 10 AND `nodeid` = 17
- Time Before: 1783541088.9085
- Time After: 1783541088.9094
- Time Taken: 0.00089478492736816
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 11 AND `nodeid` = 17
- Time Before: 1783541088.9095
- Time After: 1783541088.9148
- Time Taken: 0.0053098201751709
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('widget_subchannelsdisplay_widgettitle','system_widgetcat','widget_channeldisplay_widgettitle','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (5,0,-1)
- Time Before: 1783541088.915
- Time After: 1783541088.9216
- Time Taken: 0.0065610408782959
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_pagetemplate
WHERE `pagetemplateid` = 2
LIMIT 1
- Time Before: 1783541088.9219
- Time After: 1783541088.9239
- Time Taken: 0.0020620822906494
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_screenlayout
WHERE `screenlayoutid` = 1
LIMIT 1
- Time Before: 1783541088.924
- Time After: 1783541088.9285
- Time Taken: 0.0044569969177246
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10738,10592,10751)
- Time Before: 1783541088.9291
- Time After: 1783541088.9342
- Time Taken: 0.0051250457763672
- Memory Before: 20971520
- Memory After: 23068672
- Memory Used: 2097152
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_17')
- Time Before: 1783541088.9378
- Time After: 1783541088.9393
- Time Taken: 0.0015459060668945
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (1,990)
/**fetchAvatarsForUsers**/
- Time Before: 1783541088.9395
- Time After: 1783541088.942
- Time Taken: 0.0024991035461426
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `class` IN ('vB5_Route_Conversation','vB5_Route_Article') AND `contentid` = 17 AND `redirect301` IS NULL
LIMIT 1
- Time Before: 1783541088.9432
- Time After: 1783541088.945
- Time Taken: 0.0018038749694824
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_site
LIMIT 1
- Time Before: 1783541088.9562
- Time After: 1783541089.0066
- Time Taken: 0.050379037857056
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3341.44451100')
- Time Before: 1783541089.008
- Time After: 1783541089.012
- Time Taken: 0.0039808750152588
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl3data')
- Time Before: 1783541089.0126
- Time After: 1783541089.0128
- Time Taken: 0.00017404556274414
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10759,10634,10635,10597,10761)
- Time Before: 1783541089.016
- Time After: 1783541089.0161
- Time Taken: 0.00015401840209961
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10480)
- Time Before: 1783541089.0249
- Time After: 1783541089.0251
- Time Taken: 0.00021600723266602
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `noticeid` FROM hmq_noticedismissed
WHERE `userid` = 0
- Time Before: 1783541089.0296
- Time After: 1783541089.0298
- Time Taken: 0.00015592575073242
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10594)
- Time Before: 1783541089.0309
- Time After: 1783541089.0309
- Time Taken: 8.9883804321289E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10595)
- Time Before: 1783541089.0314
- Time After: 1783541089.0315
- Time Taken: 5.3882598876953E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10660,10698)
- Time Before: 1783541089.0322
- Time After: 1783541089.0323
- Time Taken: 7.4863433837891E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_Announcements_17')
- Time Before: 1783541089.033
- Time After: 1783541089.0331
- Time Taken: 6.0081481933594E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10739)
- Time Before: 1783541089.0332
- Time After: 1783541089.0333
- Time Taken: 5.6028366088867E-5
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10726,10673)
- Time Before: 1783541089.0352
- Time After: 1783541089.0355
- Time Taken: 0.00023102760314941
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_ChannelTreeRaw_0')
- Time Before: 1783541089.036
- Time After: 1783541089.0365
- Time Taken: 0.00049686431884766
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_ChTreeWithLast')
- Time Before: 1783541089.0368
- Time After: 1783541089.0369
- Time Taken: 0.0001070499420166
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10446)
- Time Before: 1783541089.038
- Time After: 1783541089.0381
- Time Taken: 6.7234039306641E-5
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10448)
- Time Before: 1783541089.0384
- Time After: 1783541089.0385
- Time Taken: 7.6055526733398E-5
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (2380)
/**fetchAvatarsForUsers**/
- Time Before: 1783541089.0391
- Time After: 1783541089.0392
- Time Taken: 6.1988830566406E-5
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (2644)
/**fetchAvatarsForUsers**/
- Time Before: 1783541089.0393
- Time After: 1783541089.0394
- Time Taken: 5.6028366088867E-5
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10447)
- Time Before: 1783541089.0395
- Time After: 1783541089.0396
- Time Taken: 9.2983245849609E-5
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10746)
- Time Before: 1783541089.0409
- Time After: 1783541089.0443
- Time Taken: 0.0033669471740723
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_readperms')
- Time Before: 1783541089.0589
- Time After: 1783541089.0608
- Time Taken: 0.0019168853759766
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
- Time Before: 1783541089.0674
- Time After: 1783541089.0677
- Time Taken: 0.00030899047851562
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky = '1' AND
node.contenttypeid <> 19 AND
node.parentid = 17 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 0, 999
/**getSearchResults**/
- Time Before: 1783541089.068
- Time After: 1783541089.068
- Time Taken: 6.1988830566406E-5
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
- Time Before: 1783541089.0685
- Time After: 1783541089.0686
- Time Taken: 6.4849853515625E-5
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 17 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 2820, 10
/**getSearchResults**/
- Time Before: 1783541089.0687
- Time After: 1783541089.1162
- Time Taken: 0.04750394821167
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_50038_lvl1data','node_49715_lvl1data','node_51168_lvl1data','node_50890_lvl1data','node_49722_lvl1data','node_51279_lvl1data','node_49699_lvl1data','node_51379_lvl1data','node_51401_lvl1data','node_51421_lvl1data')
- Time Before: 1783541089.1165
- Time After: 1783541089.1204
- Time Taken: 0.0038790702819824
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_1633_5','vb_UserWPerms_2467_5','vb_UserWPerms_2340_5','vb_UserWPerms_813_5','vb_UserWPerms_2135_5','vb_UserWPerms_1271_5','vb_UserWPerms_869_5','vb_UserWPerms_2540_5','vb_UserWPerms_1498_5','vb_UserWPerms_2513_5')
- Time Before: 1783541089.1209
- Time After: 1783541089.123
- Time Taken: 0.0021579265594482
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM hmq_user AS user
LEFT JOIN hmq_userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN hmq_usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
WHERE user.userid IN (1633,2467,2340,813,2135,1271,869,2540,1498,2513)
/** fetchUserinfo **/
- Time Before: 1783541089.1231
- Time After: 1783541089.1294
- Time Taken: 0.0062768459320068
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (64)
- Time Before: 1783541089.1302
- Time After: 1783541089.1304
- Time Taken: 0.00017595291137695
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_50038','vBAtchmnts_49715','vBAtchmnts_51168','vBAtchmnts_50890','vBAtchmnts_49722','vBAtchmnts_51279','vBAtchmnts_49699','vBAtchmnts_51379','vBAtchmnts_51401','vBAtchmnts_51421')
- Time Before: 1783541089.1306
- Time After: 1783541089.1312
- Time Taken: 0.0005950927734375
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM hmq_closure AS cl
INNER JOIN hmq_attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (50038,49715,51168,50890,49722,51279,49699,51379,51401,51421)
GROUP BY cl.parent
/**getDescendantAttachCount**/
- Time Before: 1783541089.1315
- Time After: 1783541089.1353
- Time Taken: 0.0037438869476318
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM hmq_closure AS cl
INNER JOIN hmq_node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (50038,49715,51168,50890,49722,51279,49699,51379,51401,51421) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
- Time Before: 1783541089.1355
- Time After: 1783541089.14
- Time Taken: 0.0045559406280518
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (50038,49715,51168,50890,49722,51279,49699,51379,51401,51421)
ORDER BY `child` ASC, `depth` ASC
- Time Before: 1783541089.1403
- Time After: 1783541089.1654
- Time Taken: 0.025096893310547
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_50038_lvl3data','node_49715_lvl3data','node_51168_lvl3data','node_50890_lvl3data','node_49722_lvl3data','node_51279_lvl3data','node_49699_lvl3data','node_51379_lvl3data','node_51401_lvl3data','node_51421_lvl3data')
- Time Before: 1783541089.1659
- Time After: 1783541089.1681
- Time Taken: 0.0022199153900146
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1633')
- Time Before: 1783541089.1723
- Time After: 1783541089.1728
- Time Taken: 0.00057601928710938
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms2467')
- Time Before: 1783541089.173
- Time After: 1783541089.1736
- Time Taken: 0.00052404403686523
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms2340')
- Time Before: 1783541089.1738
- Time After: 1783541089.174
- Time Taken: 0.00028204917907715
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms813')
- Time Before: 1783541089.1742
- Time After: 1783541089.1745
- Time Taken: 0.0002439022064209
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms2135')
- Time Before: 1783541089.1747
- Time After: 1783541089.177
- Time Taken: 0.0023069381713867
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1498')
- Time Before: 1783541089.1773
- Time After: 1783541089.1777
- Time Taken: 0.00034499168395996
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBUserRep_1633','vBUserRep_2467','vBUserRep_2340','vBUserRep_813','vBUserRep_2135','vBUserRep_1271','vBUserRep_869','vBUserRep_2540','vBUserRep_1498','vBUserRep_2513')
- Time Before: 1783541089.1779
- Time After: 1783541089.1784
- Time Taken: 0.00044894218444824
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT user.userid, avatar.avatarid, avatar.avatarpath, user.avatarrevision,
customavatar.dateline, customavatar.width, customavatar.height, customavatar.height_thumb, customavatar.width_thumb, customavatar.filename
FROM hmq_user as user
LEFT JOIN hmq_customavatar AS customavatar ON customavatar.userid = user.userid
LEFT JOIN hmq_avatar AS avatar ON avatar.avatarid = user.avatarid
WHERE user.userid IN (1633,1261,2467,2340,2225,813,2135,1271,869,2540,1498,2513)
/**fetchAvatarsForUsers**/
- Time Before: 1783541089.1811
- Time After: 1783541089.1868
- Time Taken: 0.0057001113891602
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
- Time Before: 1783541089.1879
- Time After: 1783541089.188
- Time Taken: 0.00011801719665527
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT COUNT(node.starter) AS count
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 17 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.showpublished = '0' AND
node.showapproved = '1' AND
node.protected <> '1'
/**getSearchResults**/
- Time Before: 1783541089.1882
- Time After: 1783541089.1883
- Time Taken: 6.7949295043945E-5
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
- Time Before: 1783541089.1885
- Time After: 1783541089.1892
- Time Taken: 0.00071001052856445
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT COUNT(node.starter) AS count
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 17 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.showpublished = '1' AND
node.showapproved = '0' AND
node.protected <> '1'
/**getSearchResults**/
- Time Before: 1783541089.1894
- Time After: 1783541089.1895
- Time Taken: 5.8889389038086E-5
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT channel.nodeid
FROM hmq_channel AS channel
INNER JOIN hmq_closure AS closure
ON channel.nodeid = closure.child
WHERE closure.parent IN (17)
/**getDescendantChannelsIn**/
- Time Before: 1783541089.1898
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10282,10485,10563)
- Time Before: 1783541089.1914
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10282)
- Time Before: 1783541089.1916
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10485)
- Time Before: 1783541089.1917
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10563)
- Time Before: 1783541089.1918
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('','logo','powered_by_vbulletin_title','search','navbar_home','navbar_blogs','navbar_articles','navbar_social_groups','navbar_todays_posts','navbar_mark_channels_read','navbar_member_list','navbar_calendar','home','login','you_can_also_login_as','logging_in','username','password','remember_me','log_in','forgot_password','search_in_titles_only','search_in_x_only','advanced_search','notice_1_html','announcement','no_announcement','collapse','expand','page_title','subforums','topics','posts','last_post','mark_channels_read','new_posts','by_x','topic','latest_activity','my_subscriptions','photos','no_conversations_in_channel','please_login_to_view_subscribed_posts','no_topics_found','mark_this_channel_read','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','today','footer_current_time','working_ellipsis','yes','no','ok','cancel','facebook_language') AND `languageid` IN (5,0,-1)
- Time Before: 1783541089.1941
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','108','109','profile','122','123')
- Time Before: 1783541089.1954
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 108
LIMIT 1
- Time Before: 1783541089.1955
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 109
LIMIT 1
- Time Before: 1783541089.1956
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 122
LIMIT 1
- Time Before: 1783541089.196
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_routenew
WHERE `routeid` = 123
LIMIT 1
- Time Before: 1783541089.1961
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT * FROM hmq_page
WHERE `pageid` = 120
LIMIT 1
- Time Before: 1783541089.1961
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page__title','page__metadesc') AND `languageid` IN (5,0,-1)
- Time Before: 1783541089.1962
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10757)
- Time Before: 1783541089.1976
- Time After:
- Time Taken:
- Memory Before: 29360128
- Memory After:
- Memory Used:
5 Slowest Queries
SELECT * FROM hmq_site
LIMIT 1
SELECT node.starter AS nodeid
FROM hmq_node as node
IGNORE INDEX (node_lastcontent)
WHERE node.starter = node.nodeid AND
node.sticky <> '1' AND
node.contenttypeid <> 19 AND
node.parentid = 17 AND
node.starter > 0 AND
node.showpublished = 1 AND
node.showapproved = 1 AND
node.viewperms = 2 AND
node.inlist = 1 AND
node.protected <> '1'
ORDER BY node.lastcontent DESC
LIMIT 2820, 10
/**getSearchResults**/
SELECT * FROM hmq_closure
WHERE `child` IN (50038,49715,51168,50890,49722,51279,49699,51379,51401,51421)
ORDER BY `child` ASC, `depth` ASC
SELECT * FROM hmq_page
WHERE `pageid` = 6
LIMIT 1
SELECT * FROM hmq_page
WHERE `pageid` = 3
LIMIT 1
126 Queries Run : Total SQL time was 0.410907 seconds , Total PHP time was 0.237111 seconds , Overall time was 0.648018 seconds.