SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', '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.003711
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 39 | 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 99
- XF\DataRegistry->get() in src/XF/App.php at line 2092
- XF\App->preLoadData() in src/XF/App.php at line 2077
- XF\App->setup() in src/XF/Pub/App.php at line 95
- XF\Pub\App->setup() in src/XF.php at line 505
- XF::setupApp() in src/XF.php at line 528
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000109
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 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1244
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 129
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.*
FROM `xf_forum`
INNER 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` = '104')
LIMIT 1
Run Time: 0.000657
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 1406
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Pub/Controller/Forum.php at line 1301
- XF\Pub\Controller\Forum->assertViewableForum() in src/XF/Pub/Controller/Forum.php at line 198
- XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 104) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (1=0) AND (`xf_thread`.`sticky` = 1)
ORDER BY `xf_thread`.`last_post_date` DESC
Run Time: 0.000858
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible 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 1439
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 236
- XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`node_id` = 104) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (1=0) AND (`xf_thread`.`sticky` = 0)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 15
Run Time: 0.000864
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible 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 1439
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Forum.php at line 249
- XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT COUNT(*)
FROM `xf_thread`
WHERE (`xf_thread`.`node_id` = 104) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (1=0) AND (`xf_thread`.`sticky` = 0)
Run Time: 0.000184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible 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 1394
- XF\Mvc\Entity\Finder->total() in src/XF/Pub/Controller/Forum.php at line 250
- XF\Pub\Controller\Forum->actionForum() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000229
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/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 14
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT IGNORE INTO xf_session_activity (
ip,
controller_name,
controller_action,
view_state,
params,
view_date,
robot_key,
user_id,
unique_key
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: , XF\Pub\Controller\Forum, Forum, valid, node_id=104, 1713525587, anthropic, 0,
Run Time: 0.000856
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 14
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0,
Run Time: 0.000218
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/SessionActivity.php at line 134
- XF\Repository\SessionActivity->updateSessionActivity() in src/addons/xenMade/LAU/XF/Repository/SessionActivity.php at line 28
- xenMade\LAU\XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 363
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
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.011783
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_featured_content | range | content_visible_feature_date | content_visible_feature_date | 1 | | 11 | Using where |
SIMPLE | xf_user_ContentUser_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.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 1439
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/FeaturedContent.php at line 76
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_79_forum_overview_featured_content.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8091
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permissions_3`.*, `xf_user_User_4`.*, `xf_post_FirstPost_5`.*
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`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_5` ON (`xf_post_FirstPost_5`.`post_id` = `xf_thread`.`first_post_id`)
WHERE (`xf_thread`.`thread_id` IN (46668))
Run Time: 0.008795
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SIMPLE | xf_user_User_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_5 | 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 1439
- 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 3002
- XF\App->findByContentType() in src/XF/FeaturedContent/AbstractHandler.php at line 338
- XF\FeaturedContent\AbstractHandler->getContent() in src/XF/Repository/FeaturedContent.php at line 49
- XF\Repository\FeaturedContent->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 77
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_79_forum_overview_featured_content.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8091
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (51350))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_attachment.data_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 1439
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 241
- XF\Repository\Attachment->addAttachmentsToContent() in src/XF/FeaturedContent/Thread.php at line 58
- XF\FeaturedContent\Thread->addAttachmentsToContent() in src/XF/FeaturedContent/AbstractHandler.php at line 361
- XF\FeaturedContent\AbstractHandler->getContent() in src/XF/Repository/FeaturedContent.php at line 49
- XF\Repository\FeaturedContent->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 77
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_79_forum_overview_featured_content.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8091
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_rm_resource`.*, `xf_rm_category_Category_1`.*, `xf_permission_cache_content_Permissions_2`.*, `xf_user_User_3`.*, `xf_rm_resource_update_Description_4`.*
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')
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_rm_resource`.`user_id`)
LEFT JOIN `xf_rm_resource_update` AS `xf_rm_resource_update_Description_4` ON (`xf_rm_resource_update_Description_4`.`resource_update_id` = `xf_rm_resource`.`description_update_id`)
WHERE (`xf_rm_resource`.`resource_id` IN (66, 61, 59, 50, 58, 55, 35, 31, 39))
Run Time: 0.020416
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_rm_resource | range | PRIMARY | PRIMARY | 4 | | 9 | Using where |
SIMPLE | xf_rm_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.resource_category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_rm_category_Category_1.resource_category_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.user_id | 1 | |
SIMPLE | xf_rm_resource_update_Description_4 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_rm_resource.description_update_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 1439
- 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 3002
- XF\App->findByContentType() in src/XF/FeaturedContent/AbstractHandler.php at line 338
- XF\FeaturedContent\AbstractHandler->getContent() in src/XF/Repository/FeaturedContent.php at line 49
- XF\Repository\FeaturedContent->addContentToFeatures() in src/XF/Widget/FeaturedContent.php at line 77
- XF\Widget\FeaturedContent->render() in internal_data/code_cache/widgets/_79_forum_overview_featured_content.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 8091
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('thread_x')
Params: 2
Run Time: 0.000086
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 391
- XF\Language->loadPhrases() in src/XF/Language.php at line 278
- XF\Language->getPhraseText() in src/XF/Language.php at line 135
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/FeaturedContent/AbstractHandler.php at line 149
- XF\FeaturedContent\AbstractHandler->getContentTitle() in src/XF/Entity/FeaturedContent.php at line 119
- XF\Entity\FeaturedContent->getTitle() in src/XF/Mvc/Entity/Entity.php at line 178
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 136
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/featured_content_item.php at line 145
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1068
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1004
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/content_display_macros.php at line 223
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 887
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 887
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 942
- XF\Template\Templater->renderMacro() in src/XF/FeaturedContent/AbstractHandler.php at line 285
- XF\FeaturedContent\AbstractHandler->render() in src/XF/Entity/FeaturedContent.php at line 84
- XF\Entity\FeaturedContent->render() in src/XF/Template/Templater.php at line 1258
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/widget_featured_content.php at line 24
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('xfrm_resource_x')
Params: 2
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | 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 177
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/Language.php at line 391
- XF\Language->loadPhrases() in src/XF/Language.php at line 278
- XF\Language->getPhraseText() in src/XF/Language.php at line 135
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 54
- XF\Phrase->render() in src/XF/FeaturedContent/AbstractHandler.php at line 149
- XF\FeaturedContent\AbstractHandler->getContentTitle() in src/XF/Entity/FeaturedContent.php at line 119
- XF\Entity\FeaturedContent->getTitle() in src/XF/Mvc/Entity/Entity.php at line 178
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 136
- XF\Mvc\Entity\Entity->offsetGet() in internal_data/code_cache/templates/l2/s1/public/featured_content_item.php at line 145
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1068
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1004
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l2/s1/public/content_display_macros.php at line 223
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 887
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 887
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 942
- XF\Template\Templater->renderMacro() in src/XF/FeaturedContent/AbstractHandler.php at line 285
- XF\FeaturedContent\AbstractHandler->render() in src/XF/Entity/FeaturedContent.php at line 84
- XF\Entity\FeaturedContent->render() in src/XF/Template/Templater.php at line 1258
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/widget_featured_content.php at line 24
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 2075
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l2/s1/public/forum_view.php at line 624
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- 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 461
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 443
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2588
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
bytes_sent | 13988 |
bytes_received | 1849719 |
packets_sent | 178 |
packets_received | 2026 |
protocol_overhead_in | 8104 |
protocol_overhead_out | 712 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 603 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 173 |
bytes_received_prepare_response_packet | 144809 |
bytes_received_change_user_packet | 1703426 |
packets_sent_command | 88 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 67 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 31 |
packets_received_prepare_response | 1777 |
packets_received_change_user | 120 |
result_set_queries | 28 |
non_result_set_queries | 3 |
no_index_used | 0 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 28 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 28 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 92 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 92 |
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 | 92 |
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 | 50 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 339 |
proto_binary_fetched_int24 | 132 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1011 |
proto_binary_fetched_decimal | 28 |
proto_binary_fetched_float | 9 |
proto_binary_fetched_double | 78 |
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 | 675 |
proto_binary_fetched_blob | 224 |
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 | 29 |
com_stmt_execute | 29 |
com_stmt_send_long_data | 0 |
com_stmt_close | 28 |
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 | 1701443 |