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.010828
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.000236
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 `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')
Run Time: 0.001547
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | | | | | 49 | |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum.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/Repository/ThreadPrefixRepository.php at line 27
- XF\Repository\ThreadPrefixRepository->getVisiblePrefixListData() in src/XF/Search/Data/Post.php at line 168
- XF\Search\Data\Post->getPrefixListData() in src/XF/Search/Data/Post.php at line 136
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_prefix`.*
FROM `xf_forum_prefix`
Run Time: 0.002524
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum_prefix | index | | prefix_id | 4 | | 316 | Using index |
- 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/Repository/ThreadPrefixRepository.php at line 30
- XF\Repository\ThreadPrefixRepository->getVisiblePrefixListData() in src/XF/Search/Data/Post.php at line 168
- XF\Search\Data\Post->getPrefixListData() in src/XF/Search/Data/Post.php at line 136
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_prefix`.*
FROM `xf_thread_prefix`
ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Run Time: 0.002237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread_prefix | ALL | | | | | 26 | Using filesort |
- 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/Repository/AbstractPrefix.php at line 70
- XF\Repository\AbstractPrefix->_getVisiblePrefixListData() in src/XF/Repository/ThreadPrefixRepository.php at line 60
- XF\Repository\ThreadPrefixRepository->getVisiblePrefixListData() in src/XF/Search/Data/Post.php at line 168
- XF\Search\Data\Post->getPrefixListData() in src/XF/Search/Data/Post.php at line 136
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_prefix_group`.*
FROM `xf_thread_prefix_group`
ORDER BY `xf_thread_prefix_group`.`display_order` ASC
Run Time: 0.002026
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread_prefix_group | ALL | | | | | 1 | Using filesort |
- 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/Repository/AbstractPrefix.php at line 40
- XF\Repository\AbstractPrefix->findPrefixGroups() in src/XF/Repository/AbstractPrefix.php at line 92
- XF\Repository\AbstractPrefix->_getVisiblePrefixListData() in src/XF/Repository/ThreadPrefixRepository.php at line 60
- XF\Repository\ThreadPrefixRepository->getVisiblePrefixListData() in src/XF/Search/Data/Post.php at line 168
- XF\Search\Data\Post->getPrefixListData() in src/XF/Search/Data/Post.php at line 136
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_node`.*
FROM `xf_node`
WHERE (`xf_node`.`display_in_list` = 1)
ORDER BY `xf_node`.`lft` ASC
Run Time: 0.001019
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 62 | Using where; Using filesort |
- 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/Repository/NodeRepository.php at line 23
- XF\Repository\NodeRepository->getNodeList() in src/XF/Search/Data/Post.php at line 153
- XF\Search\Data\Post->getSearchableNodeTree() in src/XF/Search/Data/Post.php at line 142
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_user_LastPostUser_2`.*, `xf_thread_LastThread_3`.*, `xf_user_LastPoster_4`.*
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_user` AS `xf_user_LastPostUser_2` ON (`xf_user_LastPostUser_2`.`user_id` = `xf_forum`.`last_post_user_id`)
LEFT JOIN `xf_thread` AS `xf_thread_LastThread_3` ON (`xf_thread_LastThread_3`.`thread_id` = `xf_forum`.`last_thread_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_4` ON (`xf_user_LastPoster_4`.`user_id` = `xf_forum`.`last_post_user_id`)
WHERE (`xf_forum`.`node_id` IN (140, 85, 166, 128, 96, 143, 97, 100, 108, 144, 110, 122, 118, 120, 121, 111, 112, 113, 114, 115, 116, 117, 125, 124, 119, 126, 149, 2, 3, 17, 4, 5, 151, 155, 158, 159, 154, 160, 89, 90, 157, 129, 141, 131, 132, 134))
Run Time: 0.008719
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 49 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum.last_thread_id | 1 | |
SIMPLE | xf_user_LastPoster_4 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_forum.last_post_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/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/NodeRepository.php at line 150
- XF\Repository\NodeRepository->loadNodeTypeDataForNodes() in src/XF/Repository/NodeRepository.php at line 24
- XF\Repository\NodeRepository->getNodeList() in src/XF/Search/Data/Post.php at line 153
- XF\Search\Data\Post->getSearchableNodeTree() in src/XF/Search/Data/Post.php at line 142
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_category`.*, `xf_node_Node_1`.*
FROM `xf_category`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_category`.`node_id`)
WHERE (`xf_category`.`node_id` IN (82, 84, 1, 164, 133))
Run Time: 0.000625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 8 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | blackspigot_secretdb1.xf_category.node_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/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Repository/NodeRepository.php at line 150
- XF\Repository\NodeRepository->loadNodeTypeDataForNodes() in src/XF/Repository/NodeRepository.php at line 24
- XF\Repository\NodeRepository->getNodeList() in src/XF/Search/Data/Post.php at line 153
- XF\Search\Data\Post->getSearchableNodeTree() in src/XF/Search/Data/Post.php at line 142
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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_link_forum`.*, `xf_node_Node_1`.*
FROM `xf_link_forum`
LEFT JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_link_forum`.`node_id`)
WHERE (`xf_link_forum`.`node_id` IN (86))
Run Time: 0.000553
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_link_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_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/Repository/NodeRepository.php at line 150
- XF\Repository\NodeRepository->loadNodeTypeDataForNodes() in src/XF/Repository/NodeRepository.php at line 24
- XF\Repository\NodeRepository->getNodeList() in src/XF/Search/Data/Post.php at line 153
- XF\Search\Data\Post->getSearchableNodeTree() in src/XF/Search/Data/Post.php at line 142
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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 content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
Params: 1, node
Run Time: 0.000400
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 62 | 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/PermissionCache.php at line 114
- XF\PermissionCache->cacheAllContentPerms() in src/XF/Entity/User.php at line 1292
- XF\Entity\User->cacheNodePermissions() in src/XF/Repository/NodeRepository.php at line 164
- XF\Repository\NodeRepository->filterViewable() in src/XF/Repository/NodeRepository.php at line 26
- XF\Repository\NodeRepository->getNodeList() in src/XF/Search/Data/Post.php at line 153
- XF\Search\Data\Post->getSearchableNodeTree() in src/XF/Search/Data/Post.php at line 142
- XF\Search\Data\Post->getSearchFormData() in src/XF/Pub/Controller/SearchController.php at line 69
- XF\Pub\Controller\SearchController->actionIndex() in src/addons/OzzModz/GoogleSearch/XF/Pub/Controller/Search.php at line 27
- OzzModz\GoogleSearch\XF\Pub\Controller\Search->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.000151
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\SearchController, Index, valid, , 1752043803, anthropic, 0,
Run Time: 0.002375
- 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 ('ld_search_links', 'ld_search_link_comments', 'search_threads', 'xfrm_search_resources')
Params: 1
Run Time: 0.000661
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 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/search_form.php at line 39
- 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 | 9347 |
bytes_received | 4179432 |
packets_sent | 166 |
packets_received | 1778 |
protocol_overhead_in | 7112 |
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 | 206 |
bytes_received_prepare_response_packet | 90484 |
bytes_received_change_user_packet | 4087659 |
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 | 1021 |
packets_received_change_user | 651 |
result_set_queries | 26 |
non_result_set_queries | 3 |
no_index_used | 10 |
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 | 625 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 625 |
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 | 625 |
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 | 3275 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 2781 |
proto_binary_fetched_int24 | 570 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 6720 |
proto_binary_fetched_decimal | 42 |
proto_binary_fetched_float | 76 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 21 |
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 | 2901 |
proto_binary_fetched_blob | 1643 |
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 | 4076749 |