SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'iconSprite', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'paymentProvider', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'forumTypes', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes', 'threadTypes')
Run Time: 0.039813
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 40 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 172
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/App.php at line 2289
- XF\App->preLoadData() in src/XF/App.php at line 2274
- XF\App->setup() in src/XF/Pub/App.php at line 116
- XF\Pub\App->setup() in src/XF.php at line 779
- XF::setupApp() in src/XF.php at line 802
- XF::runApp() in index.php at line 23
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000159
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- 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 1271
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 266
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 40
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 138
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 361
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT COUNT(*)
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`)
WHERE (`xf_session_activity`.`view_date` >= 1751751990) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid'))
Run Time: 0.143120
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 21934 | Using where; Using index |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_session_activity.user_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Mvc/Entity/Finder.php at line 1407
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/OnlineController.php at line 40
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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` >= 1751751990) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid'))
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 20
Run Time: 0.001392
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | view_date | 4 | | 21934 | Using index condition |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_session_activity.user_id | 1 | Using where |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_user_User_1.user_id | 1 | |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_user_User_1.user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/OnlineController.php at line 44
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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 ('517608'))
Run Time: 0.000423
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Pub/Controller/MemberController.php at line 1331
- XF\Pub\Controller\MemberController::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
WHERE (`xf_node_Node_1`.`node_name` IN ('requests'))
Run Time: 0.001216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node_Node_1 | ref | PRIMARY,node_name_unique | node_name_unique | 203 | const | 1 | |
SIMPLE | xf_forum | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_node_Node_1.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blackspigot_secretdb1.xf_node_Node_1.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/ControllerPlugin/NodePlugin.php at line 67
- XF\ControllerPlugin\NodePlugin::getNodeActivityDetails() in src/XF/Pub/Controller/ForumController.php at line 1416
- XF\Pub\Controller\ForumController::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
WHERE (`xf_forum`.`node_id` IN ('158'))
Run Time: 0.000749
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/ControllerPlugin/NodePlugin.php at line 82
- XF\ControllerPlugin\NodePlugin::getNodeActivityDetails() in src/XF/Pub/Controller/ForumController.php at line 1416
- XF\Pub\Controller\ForumController::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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 ('281140', '13528'))
Run Time: 0.008624
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blackspigot_secretdb1.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Pub/Controller/ThreadController.php at line 1791
- XF\Pub\Controller\ThreadController::XF\Pub\Controller\{closure}() in src/XF/Pub/Controller/AbstractController.php at line 619
- XF\Pub\Controller\AbstractController::getActivityDetailsForContent() in src/XF/Pub/Controller/ThreadController.php at line 1806
- XF\Pub\Controller\ThreadController::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_rm_category`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_rm_category`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_rm_category`.`resource_category_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_rm_category`.`resource_category_id` IN ('18'))
Run Time: 0.000511
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/addons/XFRM/Pub/Controller/Category.php at line 490
- XFRM\Pub\Controller\Category::XFRM\Pub\Controller\{closure}() in src/XF/Pub/Controller/AbstractController.php at line 619
- XF\Pub\Controller\AbstractController::getActivityDetailsForContent() in src/addons/XFRM/Pub/Controller/Category.php at line 505
- XFRM\Pub\Controller\Category::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT `xf_rm_resource`.*, `xf_rm_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_rm_resource`
LEFT JOIN `xf_rm_category` AS `xf_rm_category_Category_1` ON (`xf_rm_category_Category_1`.`resource_category_id` = `xf_rm_resource`.`resource_category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'resource_category' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_rm_category_Category_1`.`resource_category_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1')
WHERE (`xf_rm_resource`.`resource_id` IN ('16554', '21552'))
Run Time: 0.000633
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blackspigot_secretdb1.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1447
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 1893
- XFRM\Pub\Controller\ResourceItem::XFRM\Pub\Controller\{closure}() in src/XF/Pub/Controller/AbstractController.php at line 619
- XF\Pub\Controller\AbstractController::getActivityDetailsForContent() in src/addons/XFRM/Pub/Controller/ResourceItem.php at line 1909
- XFRM\Pub\Controller\ResourceItem::getActivityDetails() in src/XF/Repository/SessionActivityRepository.php at line 309
- XF\Repository\SessionActivityRepository->applyActivityDetails() in src/XF/Pub/Controller/OnlineController.php at line 45
- XF\Pub\Controller\OnlineController->actionIndex() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivityRepository.php at line 137
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 106
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
-- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
ip = ?,
controller_name = ?,
controller_action = ?,
view_state = ?,
params = ?,
view_date = ?,
robot_key = ?
WHERE user_id = ? AND unique_key = ?
Params: , XF\Pub\Controller\OnlineController, Index, valid, , 1751753790, anthropic, 0,
Run Time: 0.040372
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivityRepository.php at line 230
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 106
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 265
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 121
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 63
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('searching', 'viewing_members', 'viewing_member_profile', 'viewing_forum', 'viewing_thread', 'xfrm_viewing_resource_category', 'xfrm_viewing_resource', 'xfrm_viewing_resources')
Params: 1
Run Time: 0.009640
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 8 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 400
- XF\Language->loadPhrases() in src/XF/Language.php at line 287
- XF\Language->getPhraseText() in src/XF/Language.php at line 144
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 89
- XF\Phrase->render() in src/XF/Phrase.php at line 99
- XF\Phrase->__toString() in src/XF.php at line 1556
- XF::escapeString() in src/XF/Template/Templater.php at line 1292
- XF\Template\Templater->escape() in internal_data/code_cache/templates/l1/s111/public/online_list.php at line 89
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
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: 1751751990
Run Time: 0.137537
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | ALL | view_date | | | | 43868 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 147
- XF\Db\AbstractAdapter->fetchRow() in src/XF/Repository/SessionActivityRepository.php at line 21
- XF\Repository\SessionActivityRepository->getOnlineCounts() in src/XF/Widget/OnlineStatistics.php at line 15
- XF\Widget\OnlineStatistics->render() in internal_data/code_cache/widgets/_3_online_list_online_statistics.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8177
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 176
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2144
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s111/public/online_list.php at line 155
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
- 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 50
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 471
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 453
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 412
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2826
- XF\App->run() in src/XF.php at line 806
- XF::runApp() in index.php at line 23
bytes_sent | 14137 |
bytes_received | 3912180 |
packets_sent | 166 |
packets_received | 1575 |
protocol_overhead_in | 6300 |
protocol_overhead_out | 664 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 432 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 204 |
bytes_received_prepare_response_packet | 123040 |
bytes_received_change_user_packet | 3787853 |
packets_sent_command | 82 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 48 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 29 |
packets_received_prepare_response | 1335 |
packets_received_change_user | 134 |
result_set_queries | 26 |
non_result_set_queries | 3 |
no_index_used | 2 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 26 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 26 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 108 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 108 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 108 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 2440 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 143 |
proto_binary_fetched_int24 | 28 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 317 |
proto_binary_fetched_decimal | 57 |
proto_binary_fetched_float | 7 |
proto_binary_fetched_double | 4 |
proto_binary_fetched_date | 28 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 518 |
proto_binary_fetched_blob | 148 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 27 |
com_stmt_execute | 27 |
com_stmt_send_long_data | 0 |
com_stmt_close | 26 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 3785930 |