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.004636
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.000108
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 2592
- 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_es_thread_similar_XFES_SimilarThreads_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.*
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_es_thread_similar` AS `xf_es_thread_similar_XFES_SimilarThreads_2` ON (`xf_es_thread_similar_XFES_SimilarThreads_2`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '46822')
LIMIT 1
Run Time: 0.006326
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_es_thread_similar_XFES_SimilarThreads_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | 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 1417
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 157
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1671
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 18
- XF\Pub\Controller\Thread->actionIndex() 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 46822) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.016507
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | thxforg_thxf.xf_user_User_1.user_id,func | 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/Pub/Controller/Thread.php at line 66
- XF\Pub\Controller\Thread->actionIndex() 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 2592
- 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.000246
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 2592
- 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\Thread, Index, valid, thread_id=46822, 1714373029, anthropic, 0, �]�
Run Time: 0.000837
- 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 2592
- 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.000226
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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('routesApi')
Run Time: 0.000101
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 99
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 268
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1980
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 519
- XF\App->XF\{closure}() in src/XF/Container.php at line 31
- XF\Container->offsetGet() in src/XF/App.php at line 2741
- XF\App->router() in src/XF/Entity/EmbedResolverTrait.php at line 64
- XF\Entity\Thread->getOembedEndpointUrl() in src/XF/Template/Templater.php at line 1258
- XF\Template\Templater->method() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 674
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1750
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`url_hash` = 'ad446ac9a4fa2ff5a99d84f5a4d6d380')
LIMIT 1
Run Time: 0.003821
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- 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/Unfurl.php at line 67
- XF\Repository\Unfurl->getUnfurlResultByUrl() in src/XF/BbCode/Renderer/Html.php at line 1611
- XF\BbCode\Renderer\Html->getUnfurlResultFromUrl() in src/XF/BbCode/Renderer/Html.php at line 1588
- XF\BbCode\Renderer\Html->getRenderedUnfurl() in src/XF/BbCode/Renderer/Html.php at line 1512
- XF\BbCode\Renderer\Html->renderTagUrl() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 39
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTagUrl() in src/XF/BbCode/Renderer/Html.php at line 328
- XF\BbCode\Renderer\Html->renderTag() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 17
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 63
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 39
- 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 223
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2538
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 476
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_article_macros.php at line 106
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 395
- 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/thread_view.php at line 770
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1750
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`url_hash` = 'e5d844cb4d69909a1eabf1892ab02e26')
LIMIT 1
Run Time: 0.000205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- 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/Unfurl.php at line 67
- XF\Repository\Unfurl->getUnfurlResultByUrl() in src/XF/BbCode/Renderer/Html.php at line 1611
- XF\BbCode\Renderer\Html->getUnfurlResultFromUrl() in src/XF/BbCode/Renderer/Html.php at line 1588
- XF\BbCode\Renderer\Html->getRenderedUnfurl() in src/XF/BbCode/Renderer/Html.php at line 1512
- XF\BbCode\Renderer\Html->renderTagUrl() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 39
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTagUrl() in src/XF/BbCode/Renderer/Html.php at line 328
- XF\BbCode\Renderer\Html->renderTag() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 17
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 63
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 39
- 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 223
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2538
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 476
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_article_macros.php at line 106
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 395
- 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/thread_view.php at line 770
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1750
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
SELECT `xf_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`url_hash` = '5f8d380f1733125fd9db4b321a5074cf')
LIMIT 1
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- 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/Unfurl.php at line 67
- XF\Repository\Unfurl->getUnfurlResultByUrl() in src/XF/BbCode/Renderer/Html.php at line 1611
- XF\BbCode\Renderer\Html->getUnfurlResultFromUrl() in src/XF/BbCode/Renderer/Html.php at line 1588
- XF\BbCode\Renderer\Html->getRenderedUnfurl() in src/XF/BbCode/Renderer/Html.php at line 1512
- XF\BbCode\Renderer\Html->renderTagUrl() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 39
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTagUrl() in src/XF/BbCode/Renderer/Html.php at line 328
- XF\BbCode\Renderer\Html->renderTag() in src/addons/s9e/MediaSites/XF/BbCode/Renderer/Html.php at line 17
- s9e\MediaSites\XF\BbCode\Renderer\Html->renderTag() in src/XF/BbCode/Traverser.php at line 63
- XF\BbCode\Traverser->renderSubTree() in src/XF/BbCode/Traverser.php at line 39
- 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 223
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2538
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1195
- XF\Template\Templater->func() in internal_data/code_cache/templates/l2/s1/public/post_macros.php at line 476
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/post_article_macros.php at line 106
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 896
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l2/s1/public/thread_view.php at line 395
- 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/thread_view.php at line 770
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1750
- 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 2592
- 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_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
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_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_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_3`.`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_thread`.`thread_id` IN (53391, 52929, 53298, 53180, 53018, 52106, 52084, 52085, 50024, 48058, 47235, 47233, 47234, 47216, 47215, 47217, 50526, 47194, 49633, 48041)) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect')
ORDER BY `xf_thread`.`thread_id` ASC
Run Time: 0.015930
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 20 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.user_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_node_Node_3.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.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/addons/XFES/Widget/SimilarThreads.php at line 107
- XFES\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_80_xfes_thread_view_below_quick_reply_similar_threads.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/thread_view.php at line 996
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1759
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1750
- 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
bytes_sent | 12529 |
bytes_received | 1823079 |
packets_sent | 142 |
packets_received | 1471 |
protocol_overhead_in | 5884 |
protocol_overhead_out | 568 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 459 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 143 |
bytes_received_prepare_response_packet | 100757 |
bytes_received_change_user_packet | 1721138 |
packets_sent_command | 70 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 51 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 25 |
packets_received_prepare_response | 1257 |
packets_received_change_user | 113 |
result_set_queries | 22 |
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 | 22 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 22 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 91 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 91 |
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 | 21 |
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 | 133 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 667 |
proto_binary_fetched_int24 | 254 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 1854 |
proto_binary_fetched_decimal | 27 |
proto_binary_fetched_float | 0 |
proto_binary_fetched_double | 126 |
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 | 1058 |
proto_binary_fetched_blob | 372 |
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 | 23 |
com_stmt_execute | 23 |
com_stmt_send_long_data | 0 |
com_stmt_close | 22 |
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 | 1718428 |