SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 41 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/App.php at line 1509
- XF\App->preLoadData() in src/XF/App.php at line 1499
- XF\App->setup() in src/XF/Pub/App.php at line 45
- XF\Pub\App->setup() in src/XF.php at line 312
- XF::setupApp() in src/XF.php at line 324
- XF::runApp() in index.php at line 13
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('mjcCurrencies')
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 137
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 82
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 225
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1402
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2716
- XF\App->container() in src/addons/MJ/Credits/Listener.php at line 67
- MJ\Credits\Listener::userEntityStructure()
- call_user_func_array() in src/XF/Extension.php at line 50
- XF\Extension->fire() in src/XF/Mvc/Entity/Manager.php at line 76
- XF\Mvc\Entity\Manager->getEntityStructure() in src/XF/Repository/User.php at line 57
- XF\Repository\User->getGuestUser() in src/XF/Repository/User.php at line 31
- XF\Repository\User->getVisitor() in src/XF/App.php at line 1523
- XF\App->getVisitorFromSession() in src/XF/Pub/App.php at line 97
- XF\Pub\App->start() in src/XF/App.php at line 1885
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000093
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 36
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 915
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 224
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 20
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 117
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 248
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT COUNT(*)
FROM `xf_session_activity`
WHERE (`xf_session_activity`.`view_date` >= 1711617669) AND (`xf_session_activity`.`user_id` = 0) AND (`xf_session_activity`.`robot_key` <> '')
Run Time: 0.000363
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 270 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 91
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1104
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Online.php at line 38
- XF\Pub\Controller\Online->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_session_activity`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*
FROM `xf_session_activity`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
WHERE (`xf_session_activity`.`view_date` >= 1711617669) AND (`xf_session_activity`.`user_id` = 0) AND (`xf_session_activity`.`robot_key` <> '')
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 1000
Run Time: 0.000784
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 270 | Using where |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | intmokwrhosting_thaoluanxoso.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | intmokwrhosting_thaoluanxoso.xf_user_User_1.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1149
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Online.php at line 42
- XF\Pub\Controller\Online->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permissions_3`.*
FROM `xf_thread`
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN ('3253', '2872', '3675', '4798', '5124', '5116', '4240', '1195'))
Run Time: 0.000670
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 8 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | intmokwrhosting_thaoluanxoso.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | intmokwrhosting_thaoluanxoso.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,intmokwrhosting_thaoluanxoso.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1149
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Pub/Controller/Thread.php at line 1316
- XF\Pub\Controller\Thread::XF\Pub\Controller\{closure}() in src/XF/Pub/Controller/AbstractController.php at line 436
- XF\Pub\Controller\AbstractController::getActivityDetailsForContent() in src/XF/Pub/Controller/Thread.php at line 1331
- XF\Pub\Controller\Thread::getActivityDetails()
- call_user_func() in src/XF/Repository/SessionActivity.php at line 224
- XF\Repository\SessionActivity->applyActivityDetails() in src/XF/Pub/Controller/Online.php at line 43
- XF\Pub\Controller\Online->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT `xf_user`.*, `xf_user_privacy_Privacy_1`.*
FROM `xf_user`
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_1` ON (`xf_user_privacy_Privacy_1`.`user_id` = `xf_user`.`user_id`)
WHERE (`xf_user`.`user_id` IN ('1091'))
Run Time: 0.000391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1149
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Pub/Controller/Member.php at line 1089
- XF\Pub\Controller\Member::getActivityDetails()
- call_user_func() in src/XF/Repository/SessionActivity.php at line 224
- XF\Repository\SessionActivity->applyActivityDetails() in src/XF/Pub/Controller/Online.php at line 43
- XF\Pub\Controller\Online->actionIndex() in src/XF/Mvc/Dispatcher.php at line 249
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, 4Z(T, 4Z(T, XF\Pub\Controller\Online, Index, valid, , 1711621269,
Run Time: 0.000249
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 65
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 270
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 271
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 88
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 41
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('viewing_thread', 'searching', 'viewing_members', 'viewing_member_profile')
Params: 2
Run Time: 0.000283
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 4 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 116
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 351
- XF\Language->loadPhrases() in src/XF/Language.php at line 249
- XF\Language->getPhraseText() in src/XF/Language.php at line 167
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 52
- XF\Phrase->render() in src/XF/Phrase.php at line 59
- XF\Phrase->__toString() in src/XF.php at line 771
- XF::escapeString() in src/XF/Template/Templater.php at line 945
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l2/s1/public/online_list.php at line 88
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1246
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
SELECT
SUM(IF(user_id >= 0 AND robot_key = '', 1, 0)) AS total,
SUM(IF(user_id > 0, 1, 0)) AS members,
SUM(IF(user_id = 0 AND robot_key = '', 1, 0)) AS guests
FROM xf_session_activity
WHERE view_date >= ?
Params: 1711617669
Run Time: 0.000549
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 270 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 86
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivity.php at line 25
- XF\Repository\SessionActivity->getOnlineCounts() in src/XF/Widget/OnlineStatistics.php at line 13
- XF\Widget\OnlineStatistics->render() in src/XF/Template/Templater.php at line 1522
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/online_list.php at line 152
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1246
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 332
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 303
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 44
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 1889
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13
-- XFDB=noForceAllWrite
INSERT INTO xf_session
(session_id, session_data, expiry_date)
VALUES
(?, ?, ?)
ON DUPLICATE KEY UPDATE
session_data = VALUES(session_data),
expiry_date = VALUES(expiry_date)
Params: dGyxpOlmwh6NSBRm4wtucOO4-7Wnhs0f, a:3:{s:3:"_ip";s:4:"4Z(T";s:5:"robot";s:0:"";s:10:"fromSearch";b:0;}, 1711635669
Run Time: 0.000179
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
- XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
- XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
- XF\Session\Session->save() in src/XF/Pub/App.php at line 360
- XF\Pub\App->complete() in src/XF/App.php at line 1892
- XF\App->run() in src/XF.php at line 328
- XF::runApp() in index.php at line 13