vBulletin - Explain SQL Queries (125)
Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)
- Times run: 4
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 (0)
/** fetchUserinfo **/
SET @@sql_mode = ''
- Time Before: 1783478234.0902
- Time After: 1783478234.0903
- Time Taken: 0.00013899803161621
- 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_datastore | range | PRIMARY | PRIMARY | 52 | | 18 | Using index condition |
- Time Before: 1783478234.1169
- Time After: 1783478234.1178
- Time Taken: 0.00091910362243652
- 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` > 1783378234
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_session | const | PRIMARY,last_activity | PRIMARY | 34 | const | 1 | |
- Time Before: 1783478234.1347
- Time After: 1783478234.1369
- Time Taken: 0.0021860599517822
- 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.1408
- Time After: 1783478234.1428
- Time Taken: 0.0019829273223877
- 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.1679
- Time After: 1783478234.1818
- Time Taken: 0.013868093490601
- 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/z[len:35]', 'explain=1&[len:21]') 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/646-مساء-الخير','forum/c1/z2','forum/c1','forum') 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 | 202,2 | | 7 | Using sort_union(prefix,ishomeroute); Using where |
- Time Before: 1783478234.1828
- Time After: 1783478234.2105
- Time Taken: 0.027730941772461
- 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:203]', 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/z[len:35]', 'explain=1&[len:21]') 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.2221
- Time After: 1783478234.2283
- Time Taken: 0.0061600208282471
- 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/z[len:35]', 'explain=1&[len:21]') 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.2647
- Time After: 1783478234.2725
- Time Taken: 0.0078270435333252
- 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/content.php(149)
#12 vB_Library_Content->__construct() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/library.php(46)
#13 vB_Library::instance('Content_Channel') in /core/vb5/route/conversation.php(29)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', 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/z[len:35]', 'explain=1&[len:21]') 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 ('node_17_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.3367
- Time After: 1783478234.3372
- Time Taken: 0.00057816505432129
- 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/conversation.php(29)
#13 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#14 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#15 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', 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/z[len:35]', 'explain=1&[len:21]') 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_646_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.339
- Time After: 1783478234.342
- Time Taken: 0.0030291080474854
- 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:66]', 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('646') in /core/vb5/route/conversation.php(83)
#11 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#12 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#13 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#14 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') 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_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 | hmq_channel | ALL | guid | | | | 52 | Using where |
- Time Before: 1783478234.3476
- Time After: 1783478234.3479
- Time Taken: 0.00020790100097656
- 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(2188)
#9 vB_Library_Node->fetchAlbumChannel() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/node.php(1968)
#10 vB_Api_Node->fetchAlbumChannel('646') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#11 vB_Api_Wrapper->__call('fetchAlbumChannel', array[len:1]) in /core/vb5/route/conversation.php(101)
#12 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#13 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#14 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', 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/z[len:35]', 'explain=1&[len:21]') 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 ('vB_NamedRoutes')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.3505
- Time After: 1783478234.3571
- Time Taken: 0.0065820217132568
- 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(1407)
#12 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#13 vB5_Route_Conversation::getChannelURL(17, array[len:6]) in /core/vb5/route/conversation.php(484)
#14 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#15 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#16 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#17 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#18 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', 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/z[len:35]', 'explain=1&[len:21]') 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_routenew
WHERE `routeid` = 64
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_routenew | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.3576
- Time After: 1783478234.3653
- Time Taken: 0.0076899528503418
- 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(1407)
#10 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#11 vB5_Route_Conversation::getChannelURL(17, array[len:6]) in /core/vb5/route/conversation.php(484)
#12 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#13 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#14 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#15 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#16 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', 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/z[len:35]', 'explain=1&[len:21]') 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 ('node_17_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.3667
- Time After: 1783478234.3885
- Time Taken: 0.021857023239136
- 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:0], '', '') in /core/vb5/route.php(1417)
#15 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#16 vB5_Route_Conversation::getChannelURL(17, array[len:6]) in /core/vb5/route/conversation.php(484)
#17 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#18 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#19 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#20 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#21 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#22 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#23 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#24 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#25 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#26 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('channelperms_1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.3889
- Time After: 1783478234.389
- Time Taken: 0.00014281272888184
- 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:0], '', '') in /core/vb5/route.php(1417)
#14 vB5_Route::buildUrl(array[len:1]) in /core/vb5/route/conversation.php(212)
#15 vB5_Route_Conversation::getChannelURL(17, array[len:6]) in /core/vb5/route/conversation.php(484)
#16 vB5_Route_Conversation->getUrl() in /core/vb5/route.php(466)
#17 vB5_Route->getFullUrl(array[len:1]) in /core/vb5/route/conversation.php(130)
#18 vB5_Route_Conversation->__construct(array[len:14], array[len:6], 'explain=1&[len:21]', '') in /core/vb5/route.php(1168)
#19 vB5_Route::checkRoute(array[len:14], 'forum/c1/z[len:159]', 'forum/c1/z[len:35]', 'explain=1&[len:21]', '') in /core/vb5/route.php(1104)
#20 vB5_Route::selectBestRoute('forum/c1/z[len:35]', 'explain=1&[len:21]', '', array[len:6]) in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(159)
#21 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#22 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#23 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#24 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#25 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.3963
- Time After: 1783478234.411
- Time Taken: 0.014723062515259
- 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/z[len:35]', 'explain=1&[len:21]') 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` = 65
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_routenew | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.4113
- Time After: 1783478234.4138
- Time Taken: 0.0025482177734375
- 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('65') in /core/vb5/route.php(1335)
#9 vB5_Route::getClassName('65', array[len:14]) in /core/vb5/route.php(1350)
#10 vB5_Route::getRoute('65', array[len:2], array[len:2], '') in /core/vb5/route/conversation.php(610)
#11 vB5_Route_Conversation->getCanonicalRoute() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(252)
#12 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') 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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_closure | ref | child | child | 4 | const | 4 | Using where |
- Time Before: 1783478234.4156
- Time After: 1783478234.4178
- Time Taken: 0.0021970272064209
- 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.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/z[len:35]', 'explain=1&[len:21]') 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_lvl1data','node_14_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 2 | Using where |
- Time Before: 1783478234.418
- Time After: 1783478234.4218
- Time Taken: 0.0038280487060547
- 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.php(418)
#13 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#14 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') 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` IN (45,58,64)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_routenew | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
- Time Before: 1783478234.4221
- Time After: 1783478234.4258
- Time Taken: 0.0037751197814941
- 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.php(418)
#10 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#11 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#12 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#13 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#14 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#15 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_2_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.4262
- Time After: 1783478234.4542
- Time Taken: 0.028050899505615
- 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.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 vB5_Frontend_Application::init('config.php') in /index.php(48)
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_14_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.4547
- Time After: 1783478234.4548
- Time Taken: 0.00011897087097168
- 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.php(418)
#17 vB5_Route->getBreadcrumbs() in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/route.php(315)
#18 vB_Api_Route->getRoute('forum/c1/z[len:35]', 'explain=1&[len:21]') in phar:///home/alnadawi/public_html/vb/core/vb/vb.phar/api/wrapper.php(201)
#19 vB_Api_Wrapper->__call('getRoute', array[len:2]) in /includes/api/interface/collapsed.php(105)
#20 Api_Interface_Collapsed->callApi('route', 'getRoute', array[len:2]) in /includes/vb5/frontend/routing.php(121)
#21 vB5_Frontend_Routing->setRoutes() in /includes/vb5/frontend/application.php(21)
#22 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_channel | ALL | | | | | 52 | Using where |
- Time Before: 1783478234.4958
- Time After: 1783478234.5143
- Time Taken: 0.018522977828979
- 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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_style | const | PRIMARY | PRIMARY | 2 | const | 1 | |
- Time Before: 1783478234.5147
- Time After: 1783478234.5305
- Time Taken: 0.015836000442505
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.5469
- Time After: 1783478234.5538
- Time Taken: 0.006850004196167
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 3
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.5611
- Time After: 1783478234.5699
- Time Taken: 0.0087871551513672
- Memory Before: 18874368
- Memory After: 18874368
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478234.5734
- Time After: 1783478234.5764
- Time Taken: 0.00307297706604
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 23
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.5778
- Time After: 1783478234.5779
- Time Taken: 0.00013399124145508
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478234.578
- Time After: 1783478234.5781
- Time Taken: 8.082389831543E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 6
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.5783
- Time After: 1783478234.5783
- Time Taken: 6.8902969360352E-5
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478234.5784
- Time After: 1783478234.5785
- Time Taken: 6.8902969360352E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 5
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.5786
- Time After: 1783478234.5787
- Time Taken: 7.2002410888672E-5
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478234.5787
- Time After: 1783478234.5788
- Time Taken: 5.1021575927734E-5
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vbPre_conversation65.49.17.646')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.5869
- Time After: 1783478234.6153
- Time Taken: 0.028417110443115
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
- Time Before: 1783478234.6177
- Time After: 1783478234.6303
- Time Taken: 0.012646913528442
- Memory Before: 18874368
- Memory After: 18874368
- 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 = 49
/**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: 1783478234.6307
- Time After: 1783478234.6355
- Time Taken: 0.0047729015350342
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_54c8a2f27c155125082869_title','page_54c8a2f27c155125082869_metadesc') AND `languageid` IN (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478234.6357
- Time After: 1783478234.6367
- Time Taken: 0.00098896026611328
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10582)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.6375
- Time After: 1783478234.6619
- Time Taken: 0.02433705329895
- Memory Before: 18874368
- Memory After: 18874368
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `pagetemplateid` IN (4,-1)
ORDER BY `containerinstanceid`,`displaysection`,`displayorder`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_widgetinstance | range | pagetemplateid | pagetemplateid | 4 | | 4 | Using index condition; Using filesort |
- Time Before: 1783478234.6709
- Time After: 1783478234.6775
- Time Taken: 0.0066158771514893
- 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(190,213,236)
/**getWidgetdefinition**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | widgetdefinition | range | widgetid | widgetid | 4 | | 17 | Using index condition |
| 1 | SIMPLE | widget | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.widgetdefinition.widgetid | 1 | |
- Time Before: 1783478234.6777
- Time After: 1783478234.7043
- Time Taken: 0.026591062545776
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetinstance
WHERE `widgetinstanceid` IN (20,18,19)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_widgetinstance | range | PRIMARY | PRIMARY | 4 | | 3 | Using where |
- Time Before: 1783478234.7046
- Time After: 1783478234.7139
- Time Taken: 0.0093429088592529
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widget
WHERE `widgetid` IN (0,190,213,236)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_widget | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
- Time Before: 1783478234.7141
- Time After: 1783478234.7379
- Time Taken: 0.023761034011841
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT COUNT(*) AS count FROM hmq_moderator
WHERE `userid` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_moderator | ref | userid_nodeid | userid_nodeid | 4 | const | 1 | Using index |
- Time Before: 1783478234.7412
- Time After: 1783478234.7418
- Time Taken: 0.00057482719421387
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_datastore
WHERE `title` IN ('vBUgChannelAccessG1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_datastore | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- Time Before: 1783478234.742
- Time After: 1783478234.7938
- Time Taken: 0.051867961883545
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 20 AND `nodeid` = 17
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478234.7942
- Time After: 1783478234.8039
- Time Taken: 0.0096848011016846
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 18 AND `nodeid` = 17
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478234.8041
- Time After: 1783478234.8179
- Time Taken: 0.013810157775879
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_widgetchannelconfig
WHERE `widgetinstanceid` = 19 AND `nodeid` = 17
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478234.8181
- Time After: 1783478234.8419
- Time Taken: 0.023777961730957
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('widget_conversationdisplay_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle') AND `languageid` IN (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 15 | Using index condition |
- Time Before: 1783478234.8422
- Time After: 1783478234.8438
- Time Taken: 0.0016841888427734
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_pagetemplate
WHERE `pagetemplateid` = 4
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_pagetemplate | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.8441
- Time After: 1783478234.8442
- Time Taken: 0.00010180473327637
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_screenlayout
WHERE `screenlayoutid` = 1
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_screenlayout | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.8442
- Time After: 1783478234.8443
- Time Taken: 0.00010490417480469
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10738,10592,10751)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 3 | Using index condition |
- Time Before: 1783478234.8448
- Time After: 1783478234.8619
- Time Taken: 0.017117023468018
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_646_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.8639
- Time After: 1783478234.8885
- Time Taken: 0.024569988250732
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (646)
ORDER BY `child` ASC, `depth` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_closure | ref | child | child | 4 | const | 5 | Using where |
- Time Before: 1783478234.8889
- Time After: 1783478234.8919
- Time Taken: 0.0030150413513184
- Memory Before: 20971520
- Memory After: 20971520
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 51 | Using index condition |
- Time Before: 1783478234.9043
- Time After: 1783478234.9069
- Time Taken: 0.0026628971099854
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_0_5')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478234.9074
- Time After: 1783478234.9156
- Time Taken: 0.0081808567047119
- Memory Before: 20971520
- Memory After: 20971520
- 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 (0)
/** fetchUserinfo **/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478234.9163
- Time After: 1783478234.919
- Time Taken: 0.0026957988739014
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_646')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.9204
- Time After: 1783478234.9217
- Time Taken: 0.001305103302002
- 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 (405)
/**fetchAvatarsForUsers**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | avatar | system | PRIMARY | | | | 0 | Const row not found |
| 1 | SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | customavatar | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478234.9219
- Time After: 1783478234.9483
- Time Taken: 0.026334047317505
- Memory Before: 20971520
- Memory After: 20971520
- Memory Used: 0
SELECT * FROM hmq_site
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_site | ALL | | | | | 1 | |
- Time Before: 1783478234.9639
- Time After: 1783478234.9683
- Time Taken: 0.0044000148773193
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_17')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478234.9691
- Time After: 1783478234.9866
- Time Taken: 0.017417907714844
- 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**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | avatar | system | PRIMARY | | | | 0 | Const row not found |
| 1 | SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.user.userid | 1 | |
- Time Before: 1783478234.9868
- Time After: 1783478234.987
- Time Taken: 0.00019216537475586
- 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')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_channel | range | guid | guid | 151 | | 5 | Using index condition |
- Time Before: 1783478234.9873
- Time After: 1783478235.0492
- Time Taken: 0.061920166015625
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_1_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.0496
- Time After: 1783478235.0618
- Time Taken: 0.012220859527588
- 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)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 5 | Using index condition |
- Time Before: 1783478235.0638
- Time After: 1783478235.0659
- Time Taken: 0.0021028518676758
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10480)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.0698
- Time After: 1783478235.1499
- Time Taken: 0.080092906951904
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `noticeid` FROM hmq_noticedismissed
WHERE `userid` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478235.1548
- Time After: 1783478235.1768
- Time Taken: 0.022042036056519
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10594)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.1781
- Time After: 1783478235.179
- Time Taken: 0.00095510482788086
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10595)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.1797
- Time After: 1783478235.1869
- Time Taken: 0.007166862487793
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10660,10698)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1783478235.188
- Time After: 1783478235.2658
- Time Taken: 0.077799081802368
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_Announcements_17')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.2669
- Time After: 1783478235.2769
- Time Taken: 0.009998083114624
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10739)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.2773
- Time After: 1783478235.2784
- Time Taken: 0.0010578632354736
- Memory Before: 23068672
- Memory After: 23068672
- 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 (0)
/** fetchUserinfo **/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478235.2797
- Time After: 1783478235.2903
- Time Taken: 0.010613918304443
- Memory Before: 23068672
- Memory After: 23068672
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10683)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.2941
- Time After: 1783478235.3293
- Time Taken: 0.035156011581421
- Memory Before: 23068672
- Memory After: 23068672
- 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 (0)
/** fetchUserinfo **/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478235.3325
- Time After: 1783478235.3339
- Time Taken: 0.0014429092407227
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_searchlog
WHERE `searchhash` IN ('c0717825aaf856f8292e145f97fe3c9e') AND `userid` = 0 AND `dateline` >= 1783478174 AND `sortby` = 'isstarter' AND `sortorder` = 'desc'
ORDER BY `dateline` DESC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_searchlog | ref|filter | search,userfloodcheck,dateline | search|dateline | 56|4 | const,const,const,const | 22 (0%) | Using index condition; Using where; Using filesort; Using rowid filter |
- Time Before: 1783478235.3496
- Time After: 1783478235.3807
- Time Taken: 0.031116962432861
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_readperms')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.3809
- Time After: 1783478235.3959
- Time Taken: 0.015071868896484
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('getSearchResults_b68c0732ebb0d23b0233a9f775f95df9')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.397
- Time After: 1783478235.426
- Time Taken: 0.029052972793579
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT node.nodeid, IF(node.nodeid = node.starter, 1, 0) as isstarter, node.nodeid AS nodeid2
FROM hmq_node as node
JOIN hmq_closure AS closure ON node.nodeid = closure.child
LEFT JOIN hmq_node AS starter ON starter.nodeid = node.starter
WHERE closure.parent = '646' AND
closure.depth <= 1 AND
node.inlist = 1 AND
node.protected <> '1'
AND (node.public_preview = 1 OR ( ( ( (starter.parentid IN (26,35,1,2,13,14,27,29,33,37,39,40,43,45,46,48,49,1441914,3,17,18,19,30,36,42,9,15,23,24,6,22,28,47,25,12,31) ) AND node.showapproved > 0 AND node.viewperms > 1 AND node.showpublished > 0 ))
OR starter.parentid = 9 AND node.userid IN (0) OR (node.starter = 0 AND node.nodeid IN (26,35,1,2,13,14,27,29,33,37,39,40,43,45,46,48,49,1441914,3,17,18,19,30,36,42,9,15,23,24,6,22,28,47,25,12,31))))
ORDER BY isstarter DESC,node.created ASC,nodeid2 ASC
/**getSearchResults**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | closure | ref | closure_uniq,parent_2,child | closure_uniq | 4 | const | 17 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | node | eq_ref | PRIMARY,node_user,node_starter,node_ppreview,node_showapproved,nodeid,ppreview,node_inlist,showpublished | PRIMARY | 4 | alnadawi_vb.closure.child | 1 | Using where |
| 1 | SIMPLE | starter | eq_ref | PRIMARY,nodeid | PRIMARY | 4 | alnadawi_vb.node.starter | 1 | Using where |
- Time Before: 1783478235.4281
- Time After: 1783478235.4505
- Time Taken: 0.022410869598389
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
REPLACE INTO hmq_searchlog
(type,userid,ipaddress,searchhash,sortby,sortorder,searchtime,dateline,json,results,results_count)
VALUES
('0','0','216.73.216.227','c0717825aaf856f8292e145f97fe3c9e','isstarter','desc','0.054172992706299','1783478234','{\"sort\":{\"created\":\"ASC\"},\"channel\":\"646\",\"depth\":1,\"include_starter\":1,\"ignore_protected\":1,\"nolimit\":1}','646,57688,57689,57690,57691,57693,57704,57707,57708,57718,57724,57801,57809,57832,58667,58730,65118','17')
- Time Before: 1783478235.451
- Time After: 1783478235.4514
- Time Taken: 0.00046300888061523
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_searchlog
WHERE `searchlogid` = 112486850
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_searchlog | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.4516
- Time After: 1783478235.4533
- Time Taken: 0.0016951560974121
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 12
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.4537
- Time After: 1783478235.4631
- Time Taken: 0.0094690322875977
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_4ecbdac82f281504471586_title','page_4ecbdac82f281504471586_metadesc') AND `languageid` IN (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478235.4633
- Time After: 1783478235.4635
- Time Taken: 0.00018596649169922
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_57688_lvl1data','node_57689_lvl1data','node_57690_lvl1data','node_57691_lvl1data','node_57693_lvl1data','node_57704_lvl1data','node_57707_lvl1data','node_57708_lvl1data','node_57718_lvl1data','node_57724_lvl1data','node_57801_lvl1data','node_57809_lvl1data','node_57832_lvl1data','node_58667_lvl1data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 14 | Using where |
- Time Before: 1783478235.4638
- Time After: 1783478235.5056
- Time Taken: 0.041760206222534
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vb_UserWPerms_60_5','vb_UserWPerms_73_5','vb_UserWPerms_87_5','vb_UserWPerms_162_5','vb_UserWPerms_76_5','vb_UserWPerms_176_5','vb_UserWPerms_1_5','vb_UserWPerms_226_5','vb_UserWPerms_139_5','vb_UserWPerms_42_5','vb_UserWPerms_141_5','vb_UserWPerms_44_5','vb_UserWPerms_2_5')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 13 | Using where |
- Time Before: 1783478235.5063
- Time After: 1783478235.5403
- Time Taken: 0.034057140350342
- Memory Before: 25165824
- Memory After: 25165824
- 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 (0,60,73,87,162,76,176,1,226,139,42,141,44,2)
/** fetchUserinfo **/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 14 | Using index condition |
| 1 | SIMPLE | userfield | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.user.userid | 1 | |
| 1 | SIMPLE | usertextfield | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.user.userid | 1 | |
- Time Before: 1783478235.5405
- Time After: 1783478235.5952
- Time Taken: 0.054753065109253
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN (64,65)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_routenew | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
- Time Before: 1783478235.5959
- Time After: 1783478235.61
- Time Taken: 0.014055967330933
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBAtchmnts_57688','vBAtchmnts_57689','vBAtchmnts_57690','vBAtchmnts_57691','vBAtchmnts_57693','vBAtchmnts_57704','vBAtchmnts_57707','vBAtchmnts_57708','vBAtchmnts_57718','vBAtchmnts_57724','vBAtchmnts_57801','vBAtchmnts_57809','vBAtchmnts_57832','vBAtchmnts_58667')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 14 | Using where |
- Time Before: 1783478235.611
- Time After: 1783478235.6179
- Time Taken: 0.0068860054016113
- Memory Before: 25165824
- Memory After: 25165824
- 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 (646,57688,57689,57690,57691,57693,57704,57707,57708,57718,57724,57801,57809,57832,58667)
GROUP BY cl.parent
/**getDescendantAttachCount**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cl | range | closure_uniq,parent_2,child | parent_2 | 4 | | 31 | Using where; Using index |
| 1 | SIMPLE | a | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.cl.child | 1 | Using index |
- Time Before: 1783478235.6181
- Time After: 1783478235.6448
- Time Taken: 0.026688098907471
- Memory Before: 25165824
- Memory After: 25165824
- 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 (646,57688,57689,57690,57691,57693,57704,57707,57708,57718,57724,57801,57809,57832,58667) AND child.contenttypeid = 23
GROUP BY cl.parent
/**getDescendantPhotoCount**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | cl | range | closure_uniq,parent_2,child | parent_2 | 4 | | 31 | Using where; Using index |
| 1 | SIMPLE | child | ref | node_ctypid_userid_dispo_idx,nodeid | nodeid | 6 | alnadawi_vb.cl.child,const | 1 | Using index |
- Time Before: 1783478235.645
- Time After: 1783478235.6548
- Time Taken: 0.0098550319671631
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_closure
WHERE `child` IN (57688,57689,57690,57691,57693,57704,57707,57708,57718,57724,57801,57809,57832,58667)
ORDER BY `child` ASC, `depth` ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_closure | range | child | child | 4 | | 84 | Using index condition |
- Time Before: 1783478235.6551
- Time After: 1783478235.6677
- Time Taken: 0.012633085250854
- Memory Before: 25165824
- Memory After: 25165824
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('node_57688_lvl3data','node_57689_lvl3data','node_57690_lvl3data','node_57691_lvl3data','node_57693_lvl3data','node_57704_lvl3data','node_57707_lvl3data','node_57708_lvl3data','node_57718_lvl3data','node_57724_lvl3data','node_57801_lvl3data','node_57809_lvl3data','node_57832_lvl3data','node_58667_lvl3data')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 14 | Using where |
- Time Before: 1783478235.6682
- Time After: 1783478235.7159
- Time Taken: 0.047654867172241
- Memory Before: 25165824
- Memory After: 25165824
- 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 (0)
/** fetchUserinfo **/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- Time Before: 1783478235.7189
- Time After: 1783478235.7191
- Time Taken: 0.00027608871459961
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms60')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7193
- Time After: 1783478235.7213
- Time Taken: 0.0020420551300049
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms73')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7216
- Time After: 1783478235.7354
- Time Taken: 0.013736963272095
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms162')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7357
- Time After: 1783478235.7404
- Time Taken: 0.0046558380126953
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms76')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7407
- Time After: 1783478235.7461
- Time Taken: 0.0054631233215332
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms176')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7464
- Time After: 1783478235.7476
- Time Taken: 0.0011739730834961
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7478
- Time After: 1783478235.7582
- Time Taken: 0.010360956192017
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms226')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7588
- Time After: 1783478235.7647
- Time Taken: 0.0059311389923096
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms139')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.765
- Time After: 1783478235.7722
- Time Taken: 0.0072648525238037
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms42')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7725
- Time After: 1783478235.784
- Time Taken: 0.011504888534546
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms141')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7843
- Time After: 1783478235.794
- Time Taken: 0.0097529888153076
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vB_UserPerms44')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.7943
- Time After: 1783478235.8066
- Time Taken: 0.012264966964722
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vBUserRep_60','vBUserRep_73','vBUserRep_87','vBUserRep_162','vBUserRep_76','vBUserRep_176','vBUserRep_1','vBUserRep_226','vBUserRep_139','vBUserRep_42','vBUserRep_141','vBUserRep_44','vBUserRep_2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 13 | Using where |
- Time Before: 1783478235.807
- Time After: 1783478235.8385
- Time Taken: 0.03151798248291
- 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 (60,73,87,162,76,176,226,139,42,141,44,2)
/**fetchAvatarsForUsers**/
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | avatar | system | PRIMARY | | | | 0 | Const row not found |
| 1 | SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 12 | Using index condition |
| 1 | SIMPLE | customavatar | eq_ref | PRIMARY | PRIMARY | 4 | alnadawi_vb.user.userid | 1 | |
- Time Before: 1783478235.8425
- Time After: 1783478235.8496
- Time Taken: 0.0071179866790771
- Memory Before: 27262976
- Memory After: 27262976
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vbSig_1','vbSig_42')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 2 | Using where |
- Time Before: 1783478235.8542
- Time After: 1783478235.8691
- Time Taken: 0.014930963516235
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT * FROM hmq_datastore
WHERE `title` IN ('smiliecache')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_datastore | const | PRIMARY | PRIMARY | 52 | const | 1 | |
- Time Before: 1783478235.8815
- Time After: 1783478235.8852
- Time Taken: 0.0037009716033936
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT * FROM hmq_bbcode
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_bbcode | system | | | | | 0 | Const row not found |
- Time Before: 1783478235.8854
- Time After: 1783478235.8891
- Time Taken: 0.0037038326263428
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT * FROM hmq_channel
WHERE `nodeid` = 17
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_channel | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.8904
- Time After: 1783478235.894
- Time Taken: 0.0035989284515381
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10282,10429,10420,10485)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 4 | Using index condition |
- Time Before: 1783478235.8953
- Time After: 1783478235.8988
- Time Taken: 0.0034830570220947
- Memory Before: 29360128
- Memory After: 29360128
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10486,10472)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1783478235.9043
- Time After: 1783478235.9081
- Time Taken: 0.0038430690765381
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('pageNav_1_2')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | const | PRIMARY | PRIMARY | 66 | const | 1 | |
- Time Before: 1783478235.9092
- Time After: 1783478235.912
- Time Taken: 0.0027718544006348
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10444,10443)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1783478235.9125
- Time After: 1783478235.9222
- Time Taken: 0.0096180438995361
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10283,10450,10409)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 3 | Using index condition |
- Time Before: 1783478235.9237
- Time After: 1783478235.9268
- Time Taken: 0.0031180381774902
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10497,10281)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1783478235.9278
- Time After: 1783478235.9299
- Time Taken: 0.0020310878753662
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10280,10279)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | range | PRIMARY | PRIMARY | 4 | | 2 | Using index condition |
- Time Before: 1783478235.9312
- Time After: 1783478235.9343
- Time Taken: 0.0030391216278076
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10629)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.9354
- Time After: 1783478235.9382
- Time Taken: 0.0028159618377686
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10402)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478235.9419
- Time After: 1783478235.9433
- Time Taken: 0.0013599395751953
- Memory Before: 31457280
- Memory After: 31457280
- Memory Used: 0
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','posts','latest_activity','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','events_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','previous','next','guest_avatar','x_is_offline','facebook_share','twitter_tweet','edit','tags','none','reputation5','join_date','comment','type_your_comment_here','post','cancel','see_previous_comments','see_next_comments','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok','facebook_language') AND `languageid` IN (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 240 | Using index condition |
- Time Before: 1783478236.001
- Time After: 1783478236.0019
- Time Taken: 0.0008549690246582
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT * FROM hmq_routenew
WHERE `routeid` IN ('pmchat','register','activateuser','help','contact-us','search','lostpw','65','profile')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_routenew | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
- Time Before: 1783478236.0133
- Time After: 1783478236.0166
- Time Taken: 0.0033059120178223
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT * FROM hmq_page
WHERE `pageid` = 120
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_page | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478236.0184
- Time After: 1783478236.02
- Time Taken: 0.0015912055969238
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_phrase
WHERE `varname` IN ('page_pmchat_page_chat_573cba8f1d228390944371_title','page_pmchat_page_chat_573cba8f1d228390944371_metadesc') AND `languageid` IN (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 6 | Using index condition |
- Time Before: 1783478236.0202
- Time After: 1783478236.0205
- Time Taken: 0.0003209114074707
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT * FROM hmq_cache
WHERE `cacheid` IN ('vbnodetext646_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57688_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57689_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57690_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57691_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57693_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57704_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57707_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57708_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57718_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57724_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57801_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57809_14_5:09f14d73cd828b8c283774e754116338','vbnodetext57832_14_5:09f14d73cd828b8c283774e754116338','vbnodetext58667_14_5:09f14d73cd828b8c283774e754116338')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_cache | range | PRIMARY | PRIMARY | 66 | | 15 | Using where |
- Time Before: 1783478236.0305
- Time After: 1783478236.0336
- Time Taken: 0.0031180381774902
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10757)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_template | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- Time Before: 1783478236.0397
- Time After: 1783478236.0399
- Time Taken: 0.00027179718017578
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
SELECT `varname`,`languageid`,`text` FROM hmq_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 (5,0,-1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | hmq_phrase | range | name_lang_type,languageid | name_lang_type | 195 | | 75 | Using index condition |
- Time Before: 1783478236.0428
- Time After: 1783478236.0429
- Time Taken: 0.00011920928955078
- Memory Before: 33554432
- Memory After: 33554432
- Memory Used: 0
5 Slowest Queries
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10480)
SELECT `title`,`textonly`,`template_un`,`template` FROM hmq_template
WHERE `templateid` IN (10660,10698)
SELECT * FROM hmq_channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3341.44451100')
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 (0,60,73,87,162,76,176,1,226,139,42,141,44,2)
/** fetchUserinfo **/
SELECT * FROM hmq_datastore
WHERE `title` IN ('vBUgChannelAccessG1')
125 Queries Run : Total SQL time was 1.427696 seconds , Total PHP time was 0.525048 seconds , Overall time was 1.952744 seconds.