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.000218
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 169
- 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.000273
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 264
- 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.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 23 | 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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/NodeRepository.php at line 23
- XF\Repository\NodeRepository->getNodeList() in src/XF/Pub/Controller/ForumController.php at line 81
- XF\Pub\Controller\ForumController->actionList() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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 (1, 2, 3, 4, 5))
Run Time: 0.000065
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_category | index | PRIMARY | PRIMARY | 4 | | 5 | Using where; Using index |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.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 1445
- 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/Pub/Controller/ForumController.php at line 81
- XF\Pub\Controller\ForumController->actionList() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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`.*
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`)
WHERE (`xf_forum`.`node_id` IN (6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23))
Run Time: 0.000214
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_forum | ALL | PRIMARY | | | | 19 | Using where |
SIMPLE | xf_node_Node_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_forum.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_forum.last_post_user_id | 1 | |
SIMPLE | xf_thread_LastThread_3 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_forum.last_thread_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 1445
- 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/Pub/Controller/ForumController.php at line 81
- XF\Pub\Controller\ForumController->actionList() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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.000064
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 23 | 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 109
- 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/Pub/Controller/ForumController.php at line 81
- XF\Pub\Controller\ForumController->actionList() in src/XF/Mvc/Dispatcher.php at line 362
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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, �Iؤ
Run Time: 0.000190
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 133
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 38
- SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 163
- SV\UserActivity\XF\Pub\Controller\Forum->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 28
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 73
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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: �Iؤ, XF\Pub\Controller\ForumController, List, valid, , 1751843399, anthropic, 0, �Iؤ
Run Time: 0.000199
- 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 221
- XF\Repository\SessionActivityRepository->updateSessionActivity() in src/addons/SV/UserActivity/XF/Repository/SessionActivity.php at line 38
- SV\UserActivity\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/addons/SV/UserActivity/XF/Pub/Controller/Forum.php at line 163
- SV\UserActivity\XF\Pub\Controller\Forum->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 28
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 73
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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_type, content_id, count(*) as count
FROM xf_sv_user_activity
WHERE `timestamp` >= ? AND (
(content_type = 'node' AND content_id in (6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22)))
group by content_type, content_id
Params: 1751842470
Run Time: 0.000368
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_sv_user_activity | ref | content,timestamp | content | 27 | const | 125 | Using index condition; Using where; Using temporary; Using filesort |
- 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 157
- XF\Db\AbstractAdapter->fetchAll() in src/addons/SV/UserActivity/Repository/UserActivity.php at line 676
- SV\UserActivity\Repository\UserActivity->_getUsersViewingCountFallback() in src/addons/SV/UserActivity/Repository/UserActivity.php at line 708
- SV\UserActivity\Repository\UserActivity->getUsersViewingCount() in src/addons/SV/UserActivity/Repository/UserActivity.php at line 189
- SV\UserActivity\Repository\UserActivity->insertBulkUserActivityIntoViewResponse() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 91
- SV\UserActivity\XF\Pub\Controller\Forum->_injectUserCountIntoResponse() in src/addons/SV/UserActivity/UserCountActivityInjector.php at line 39
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/addons/SV/UserActivity/UserActivityInjector.php at line 73
- SV\UserActivity\XF\Pub\Controller\Forum->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 264
- 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
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: 1751842499
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | view_date | view_date | 4 | | 56 | Using index condition |
- 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/Repository/SessionActivityRepository.php at line 65
- XF\Repository\SessionActivityRepository->getOnlineStatsBlockData() in src/addons/SV/RedisCache/XF/Repository/SessionActivity.php at line 76
- SV\RedisCache\XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 28
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_session_activity`.*, `xf_user_User_1`.*
FROM `xf_session_activity`
INNER JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_session_activity`.`user_id`)
WHERE (`xf_session_activity`.`user_id` > 0) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND ((`xf_session_activity`.`user_id` = 0) OR (`xf_user_User_1`.`visible` = 1 AND `xf_user_User_1`.`user_state` = 'valid')) AND (`xf_session_activity`.`view_date` >= 1751842499)
ORDER BY `xf_session_activity`.`view_date` DESC
LIMIT 50
Run Time: 0.000482
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session_activity | range | PRIMARY,view_date | PRIMARY | 4 | | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY,user_state | PRIMARY | 4 | isoft_biz_c63c.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/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/SessionActivityRepository.php at line 46
- XF\Repository\SessionActivityRepository->getOnlineUsersList() in src/XF/Repository/SessionActivityRepository.php at line 66
- XF\Repository\SessionActivityRepository->getOnlineStatsBlockData() in src/addons/SV/RedisCache/XF/Repository/SessionActivity.php at line 76
- SV\RedisCache\XF\Repository\SessionActivity->getOnlineStatsBlockData() in src/XF/Widget/MembersOnline.php at line 28
- XF\Widget\MembersOnline->render() in internal_data/code_cache/widgets/_6_forum_overview_members_online.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_featured_content`.*, `xf_user_ContentUser_1`.*
FROM `xf_featured_content`
LEFT JOIN `xf_user` AS `xf_user_ContentUser_1` ON (`xf_user_ContentUser_1`.`user_id` = `xf_featured_content`.`content_user_id`)
WHERE (`xf_featured_content`.`content_visible` = 1)
ORDER BY `xf_featured_content`.`feature_date` DESC
LIMIT 10
Run Time: 0.000128
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_featured_content | ref | content_visible_feature_date | content_visible_feature_date | 1 | const | 1 | Using where |
SIMPLE | xf_user_ContentUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_featured_content.content_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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/FeaturedContent.php at line 75
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_11_forum_overview_featured_content.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1749251399)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 10
Run Time: 0.000636
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 1 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,isoft_biz_c63c.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 94
- XF\Widget\NewPosts->render() in src/addons/SV/UserActivity/WidgetUserCountActivityInjector.php at line 59
- SV\UserActivity\XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_9_forum_overview_new_posts.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_trending_result`.*
FROM `xf_trending_result`
WHERE (`xf_trending_result`.`order` = 'hot') AND (`xf_trending_result`.`duration` = 7) AND (`xf_trending_result`.`content_type` = '') AND (`xf_trending_result`.`content_container_id` = 0)
ORDER BY `xf_trending_result`.`result_date` DESC
LIMIT 1
Run Time: 0.000080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_trending_result | ref | order_duration_content_type_content_container_id_result_date | order_duration_content_type_content_container_id_result_date | 86 | const,const,const,const | 32 | 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 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/TrendingContentRepository.php at line 42
- XF\Repository\TrendingContentRepository->getResult() in src/XF/Widget/TrendingContent.php at line 66
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_12_forum_overview_trending_content.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/l2/s3/public/forum_list.php at line 216
- 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
INSERT INTO `xf_job` (`execute_class`, `execute_data`, `unique_key`, `manual_execute`, `trigger_date`, `priority`) VALUES (?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE
execute_class = VALUES(execute_class),
execute_data = VALUES(execute_data),
manual_execute = VALUES(manual_execute),
trigger_date = VALUES(trigger_date),
last_run_date = NULL,
priority = VALUES(priority)
Params: XF\Job\TrendingResult, a:4:{s:5:"order";s:3:"hot";s:8:"duration";i:7;s:12:"content_type";s:0:"";s:20:"content_container_id";i:0;}, trendingContent_66da1e01f1c91b1e2823560fae7dbc74, 0, 1751843399, 100
Run Time: 0.000246
- 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 219
- XF\Db\AbstractAdapter->insert() in src/XF/Job/Manager.php at line 584
- XF\Job\Manager->_enqueue() in src/XF/Job/Manager.php at line 521
- XF\Job\Manager->enqueueUnique() in src/XF/Repository/TrendingContentRepository.php at line 79
- XF\Repository\TrendingContentRepository->enqueueResultJob() in src/XF/Repository/TrendingContentRepository.php at line 46
- XF\Repository\TrendingContentRepository->getResult() in src/XF/Widget/TrendingContent.php at line 66
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_12_forum_overview_trending_content.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/l2/s3/public/forum_list.php at line 216
- 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 job_id
FROM xf_job
WHERE unique_key = ?
Params: trendingContent_66da1e01f1c91b1e2823560fae7dbc74
Run Time: 0.000113
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_job | const | unique_key | unique_key | 53 | const | 1 | Using index |
- 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/Job/Manager.php at line 607
- XF\Job\Manager->_enqueue() in src/XF/Job/Manager.php at line 521
- XF\Job\Manager->enqueueUnique() in src/XF/Repository/TrendingContentRepository.php at line 79
- XF\Repository\TrendingContentRepository->enqueueResultJob() in src/XF/Repository/TrendingContentRepository.php at line 46
- XF\Repository\TrendingContentRepository->getResult() in src/XF/Widget/TrendingContent.php at line 66
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_12_forum_overview_trending_content.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permissions_3`.*, `xf_user_User_4`.*
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')
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
WHERE (`xf_thread`.`thread_id` IN (4975, 2, 5536, 4, 5386, 99, 5322, 5095, 5353, 2785))
Run Time: 0.000244
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 10 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,isoft_biz_c63c.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_thread.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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3240
- XF\App->findByContentType() in src/XF/TrendingContent/AbstractHandler.php at line 96
- XF\TrendingContent\AbstractHandler->getContent() in src/XF/Repository/TrendingContentRepository.php at line 355
- XF\Repository\TrendingContentRepository->getResultContent() in src/XF/Entity/TrendingResult.php at line 54
- XF\Entity\TrendingResult->getContent() in src/XF/Widget/TrendingContent.php at line 80
- XF\Widget\TrendingContent->render() in internal_data/code_cache/widgets/_12_forum_overview_trending_content.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/l2/s3/public/forum_list.php at line 216
- 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 data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('forumStatistics')
Run Time: 0.000059
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 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 169
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 102
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 271
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 2178
- XF\App->XF\{closure}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 2900
- XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
- XF\Widget\ForumStatistics->render() in internal_data/code_cache/widgets/_7_forum_overview_forum_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/l2/s3/public/forum_list.php at line 216
- 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 `xf_profile_post`.*, `xf_user_ProfileUser_1`.*, `xf_user_privacy_Privacy_2`.*, `xf_user_User_3`.*
FROM `xf_profile_post` USE INDEX (`post_date`)
LEFT JOIN `xf_user` AS `xf_user_ProfileUser_1` ON (`xf_user_ProfileUser_1`.`user_id` = `xf_profile_post`.`profile_user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_2` ON (`xf_user_privacy_Privacy_2`.`user_id` = `xf_user_ProfileUser_1`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_profile_post`.`user_id`)
WHERE (`xf_profile_post`.`message_state` = 'visible')
ORDER BY `xf_profile_post`.`post_date` DESC
LIMIT 10
Run Time: 0.000207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_profile_post | ALL | | | | | 99 | Using where; Using filesort |
SIMPLE | xf_user_ProfileUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_profile_post.profile_user_id | 1 | |
SIMPLE | xf_user_privacy_Privacy_2 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_user_ProfileUser_1.user_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_profile_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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewProfilePosts.php at line 82
- XF\Widget\NewProfilePosts->render() in internal_data/code_cache/widgets/_10_forum_overview_new_profile_posts.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/l2/s3/public/forum_list.php at line 216
- 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 `xf_user_ban`.*, `xf_user_User_1`.*
FROM `xf_user_ban`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_user_ban`.`user_id`)
WHERE (`xf_user_ban`.`user_id` = 3912)
LIMIT 1
Run Time: 0.000142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_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 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 397
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 419
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 211
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 134
- XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 751
- XF\Entity\User->canViewFullProfile() in src/XF/Entity/User.php at line 774
- XF\Entity\User->canViewPostsOnProfile() in src/XF/Entity/ProfilePost.php at line 71
- XF\Entity\ProfilePost->canView() in src/XF/Widget/NewProfilePosts.php at line 84
- XF\Widget\NewProfilePosts->render() in internal_data/code_cache/widgets/_10_forum_overview_new_profile_posts.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/l2/s3/public/forum_list.php at line 216
- 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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 2
Run Time: 0.000077
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/Entity/User.php at line 287
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 268
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2607
- XF\Template\Templater->fnBbCode() in src/addons/xenMade/KWM/XF/Template/Templater.php at line 39
- xenMade\KWM\XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1219
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s3/public/profile_post_macros.php at line 541
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/widget_new_profile_posts.php at line 66
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2144
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s3/public/forum_list.php at line 216
- 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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 14
Run Time: 0.000097
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/Entity/User.php at line 287
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 268
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2607
- XF\Template\Templater->fnBbCode() in src/addons/xenMade/KWM/XF/Template/Templater.php at line 39
- xenMade\KWM\XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1219
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s3/public/profile_post_macros.php at line 541
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/widget_new_profile_posts.php at line 66
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2144
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s3/public/forum_list.php at line 216
- 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 cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 6
Run Time: 0.000049
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/Entity/User.php at line 287
- XF\Entity\User->isLinkTrusted() in src/XF/BbCode/Renderer/Html.php at line 268
- XF\BbCode\Renderer\Html->setupRenderOptions() in src/XF/BbCode/Traverser.php at line 36
- XF\BbCode\Traverser->renderAst() in src/XF/BbCode/Traverser.php at line 22
- XF\BbCode\Traverser->render() in src/XF/SubContainer/BbCode.php at line 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2607
- XF\Template\Templater->fnBbCode() in src/addons/xenMade/KWM/XF/Template/Templater.php at line 39
- xenMade\KWM\XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1219
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s3/public/profile_post_macros.php at line 541
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s3/public/widget_new_profile_posts.php at line 66
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Widget/WidgetRenderer.php at line 62
- XF\Widget\WidgetRenderer->render() in src/XF/Widget/WidgetRenderer.php at line 67
- XF\Widget\WidgetRenderer->__toString() in src/XF/Template/Templater.php at line 2144
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s3/public/forum_list.php at line 216
- 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 `xf_featured_content`.*, `xf_user_ContentUser_1`.*
FROM `xf_featured_content`
LEFT JOIN `xf_user` AS `xf_user_ContentUser_1` ON (`xf_user_ContentUser_1`.`user_id` = `xf_featured_content`.`content_user_id`)
WHERE (`xf_featured_content`.`content_visible` = 1)
ORDER BY `xf_featured_content`.`feature_date` DESC
LIMIT 10
Run Time: 0.000133
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_featured_content | ref | content_visible_feature_date | content_visible_feature_date | 1 | const | 1 | Using where |
SIMPLE | xf_user_ContentUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | isoft_biz_c63c.xf_featured_content.content_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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/FeaturedContent.php at line 75
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_11_forum_overview_featured_content.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 src/XF/Pub/App.php at line 610
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2573
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
- 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 | 19170 |
bytes_received | 467633 |
packets_sent | 280 |
packets_received | 2530 |
protocol_overhead_in | 10120 |
protocol_overhead_out | 1120 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 972 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 308 |
bytes_received_prepare_response_packet | 161627 |
bytes_received_change_user_packet | 303666 |
packets_sent_command | 139 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 108 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 48 |
packets_received_prepare_response | 2093 |
packets_received_change_user | 233 |
result_set_queries | 44 |
non_result_set_queries | 4 |
no_index_used | 4 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 44 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 45 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 189 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 189 |
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 | 0 |
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 | 43 |
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 | 190 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 718 |
proto_binary_fetched_int24 | 306 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2337 |
proto_binary_fetched_decimal | 50 |
proto_binary_fetched_float | 3 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
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 | 1566 |
proto_binary_fetched_blob | 444 |
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 | 46 |
com_stmt_execute | 46 |
com_stmt_send_long_data | 0 |
com_stmt_close | 45 |
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 | 299563 |