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.001053
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.000162
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_liamw_accountdelete_account_deletions`.*, `xf_user_User_1`.*
FROM `xf_liamw_accountdelete_account_deletions`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_liamw_accountdelete_account_deletions`.`user_id`)
WHERE (`xf_liamw_accountdelete_account_deletions`.`user_id` = 0) AND (`xf_liamw_accountdelete_account_deletions`.`status` = 'pending')
LIMIT 1
Run Time: 0.000429
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_liamw_accountdelete_account_deletions | ref | user_id | user_id | 4 | const | 1 | Using where |
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 404
- 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/addons/LiamW/AccountDelete/Listener.php at line 72
- LiamW\AccountDelete\Listener::controllerPreDispatch() in src/XF/Extension.php at line 54
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Mvc/Controller.php at line 140
- 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_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*
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')
WHERE (`xf_thread`.`thread_id` = '5930')
LIMIT 1
Run Time: 0.000646
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 | 0 | Unique row not found |
SIMPLE | xf_forum_Forum_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | 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/ThreadController.php at line 1727
- XF\Pub\Controller\ThreadController->assertViewableThread() in src/XF/Pub/Controller/ThreadController.php at line 61
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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_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` = 5930) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 4320) AND (`xf_post`.`position` < 4340)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Run Time: 0.002167
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | range | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_position | 8 | | 20 | Using index condition; Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | teo_community.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/ThreadController.php at line 109
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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_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` = 5930) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`post_id` IN (83569))
Run Time: 0.000497
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | const | PRIMARY,thread_id_post_date,thread_id_position,thread_id_score_date | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
SIMPLE | xf_user_option_Option_2 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_user_profile_Profile_3 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_user_privacy_Privacy_4 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_permission_combination_PermissionCombination_5 | const | PRIMARY | | | | 1 | |
SIMPLE | xf_session_activity_Activity_6 | const | PRIMARY | | | | 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/Pub/Controller/ThreadController.php at line 154
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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_attachment`.*, `xf_attachment_data_Data_1`.*, `xf_mg_media_item_XfmgMirrorMedia_2`.*, `xf_mg_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
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`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_XfmgMirrorMedia_2` ON (`xf_mg_media_item_XfmgMirrorMedia_2`.`media_id` = `xf_attachment_data_Data_1`.`xfmg_mirror_media_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_media_item_XfmgMirrorMedia_2`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mg_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (207980, 208022, 208058, 208187, 208188, 208372))
ORDER BY `xf_attachment`.`attach_date` ASC
Run Time: 0.000667
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_attachment | range | content_type_id_date | content_type_id_date | 31 | | 11 | Using index condition; Using filesort |
SIMPLE | xf_attachment_data_Data_1 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_attachment.data_id | 1 | |
SIMPLE | xf_mg_media_item_XfmgMirrorMedia_2 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_attachment_data_Data_1.xfmg_mirror_media_id | 1 | Using where |
SIMPLE | xf_mg_category_Category_3 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_mg_media_item_XfmgMirrorMedia_2.category_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,teo_community.xf_mg_category_Category_3.category_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/AttachmentRepository.php at line 247
- XF\Repository\AttachmentRepository->addAttachmentsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 53
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 158
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`result_id` IN (2457, 2458, 2546))
Run Time: 0.000129
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_unfurl_result | range | PRIMARY | PRIMARY | 4 | | 3 | 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/UnfurlRepository.php at line 95
- XF\Repository\UnfurlRepository->addUnfurlsToContent() in src/XF/ControllerPlugin/ThreadPlugin.php at line 66
- XF\ControllerPlugin\ThreadPlugin->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/ThreadController.php at line 158
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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_post`.*, `xf_user_User_1`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
WHERE (`xf_post`.`thread_id` = 5930 AND `xf_post`.`message_state` = 'visible') AND (`xf_post`.`post_id` != 83569) AND (`xf_post`.`post_id` != 0)
ORDER BY `xf_post`.`vote_score` DESC, `xf_post`.`post_date` DESC
LIMIT 3
Run Time: 0.000497
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | PRIMARY,thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_score_date | 4 | const | 4631 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_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/ThreadType/QuestionHandler.php at line 62
- XF\ThreadType\QuestionHandler->adjustThreadViewParams() in src/XF/Pub/Controller/ThreadController.php at line 241
- XF\Pub\Controller\ThreadController->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/RMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\RMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 12
- XFMG\XF\Pub\Controller\Thread->actionIndex() 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.000180
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/XF/Pub/Controller/AbstractController.php at line 99
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 62
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 372
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 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_siropu_keyword_linking_keyword`.*, `xf_siropu_keyword_linking_category_Category_1`.*
FROM `xf_siropu_keyword_linking_keyword`
LEFT JOIN `xf_siropu_keyword_linking_category` AS `xf_siropu_keyword_linking_category_Category_1` ON (`xf_siropu_keyword_linking_category_Category_1`.`category_id` = `xf_siropu_keyword_linking_keyword`.`category_id`)
WHERE (`xf_siropu_keyword_linking_keyword`.`enabled` = 1)
ORDER BY `xf_siropu_keyword_linking_keyword`.`priority` DESC, `xf_siropu_keyword_linking_keyword`.`keyword_id` ASC
Run Time: 0.000395
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_keyword_linking_keyword | ALL | enabled_priority | | | | 58 | Using where; Using filesort |
SIMPLE | xf_siropu_keyword_linking_category_Category_1 | eq_ref | PRIMARY | PRIMARY | 4 | teo_community.xf_siropu_keyword_linking_keyword.category_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/Siropu/KeywordLinking/Keyword.php at line 206
- Siropu\KeywordLinking\Keyword->__construct() in src/addons/Siropu/KeywordLinking/Listener.php at line 54
- Siropu\KeywordLinking\Listener::templaterGlobalData() in src/XF/Extension.php at line 86
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/App.php at line 2500
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 2359
- XF\App->preRender() in src/XF/Pub/App.php at line 505
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 407
- 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 ('routesApi')
Run Time: 0.000112
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->{closure:XF\App::fromRegistry():2176}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 623
- XF\App->{closure:XF\App::initialize():618}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 2975
- XF\App->router() in src/XF/Entity/EmbedResolverTrait.php at line 67
- XF\Entity\Thread->getOembedEndpointUrl() in src/XF/Template/Templater.php at line 1282
- XF\Template\Templater->method() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 705
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:614}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1790
- 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 ('svContentRatingsRTC')
Run Time: 0.000103
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->{closure:XF\App::fromRegistry():2176}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 3884
- XF\App->container() in src/addons/SV/ContentRatings/Repository/ReactionCategory.php at line 77
- SV\ContentRatings\Repository\ReactionCategory->getContainerReactionsCategories() in src/addons/SV/ContentRatings/Repository/ReactionCategory.php at line 93
- SV\ContentRatings\Repository\ReactionCategory->getReactionCategoriesAsEntities() in src/addons/SV/ContentRatings/Listener.php at line 613
- SV\ContentRatings\Listener::templaterTemplatePreRender() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 1758
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1873
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l9/s31/public/message_macros.php at line 62
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/message_macros.php:11}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 25
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:20}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 148
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:143}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 192
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:161}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 427
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:423}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 801
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:614}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1790
- 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 ('svContentRatingsRT')
Run Time: 0.000104
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->{closure:XF\App::fromRegistry():2176}() in src/XF/Container.php at line 33
- XF\Container->offsetGet() in src/XF/App.php at line 3884
- XF\App->container() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 32
- SV\ContentRatings\XF\Repository\Reaction->getContainerReactions() in src/addons/SV/ContentRatings/XF/Repository/Reaction.php at line 430
- SV\ContentRatings\XF\Repository\Reaction->getReactionsAsEntities() in src/addons/SV/ContentRatings/Listener.php at line 395
- SV\ContentRatings\Listener::templaterMacroPreRender() in src/XF/Extension.php at line 69
- XF\Extension->fire() in src/XF/App.php at line 3368
- XF\App->fire() in src/XF/Template/Templater.php at line 855
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 582
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:556}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 108
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:104}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 127
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:115}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 138
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:133}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 150
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:143}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 192
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:161}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 427
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:423}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 801
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:614}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1790
- 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 title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('permanent_link')
Params: 9
Run Time: 0.000162
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 395
- XF\Language->loadPhrases() in src/XF/Language.php at line 287
- XF\Language->getPhraseText() in src/XF/Language.php at line 144
- XF\Language->renderPhrase() in src/XF/Phrase.php at line 89
- XF\Phrase->render() in src/XF/Phrase.php at line 99
- XF\Phrase->__toString()
- htmlspecialchars() in src/XF/BbCode/Renderer/Html.php at line 969
- XF\BbCode\Renderer\Html->renderTagHeading() in src/XF/BbCode/Renderer/Html.php at line 356
- 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 236
- XF\SubContainer\BbCode->render() in src/XF/Template/Templater.php at line 2607
- XF\Template\Templater->fnBbCode() in src/XF/Template/Templater.php at line 1219
- XF\Template\Templater->func() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 464
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:419}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 61
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:57}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 95
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:88}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 124
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:115}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 138
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:133}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1059
- XF\Template\Templater->renderExtensionParent() in internal_data/code_cache/templates/l9/s31/public/post_question_macros.php at line 14
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_question_macros.php:10}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 150
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:143}() in src/XF/Template/Templater.php at line 1092
- XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 1028
- XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l9/s31/public/post_macros.php at line 192
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/post_macros.php:161}() in src/XF/Template/Templater.php at line 921
- XF\Template\Templater->callMacro() in src/XF/Template/Templater.php at line 912
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l9/s31/public/thread_view.php at line 872
- XF\Template\Templater->{closure:/var/www/teonanacatl.org/internal_data/code_cache/templates/l9/s31/public/thread_view.php:614}() in src/XF/Template/Templater.php at line 1799
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1790
- 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_node`.*, `xf_permission_cache_content_Permissions_1`.*
FROM `xf_node`
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_1` ON (`xf_permission_cache_content_Permissions_1`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_1`.`content_id` = `xf_node`.`node_id` AND `xf_permission_cache_content_Permissions_1`.`permission_combination_id` = '1')
WHERE (`xf_node`.`node_id` IN (206))
Run Time: 0.000217
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_1 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/Navigation/NodeType.php at line 222
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 140
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 779
- XF\Pub\App->{closure:/var/www/teonanacatl.org/internal_data/code_cache/navigation_cache.php:3}() in src/XF/Template/Templater.php at line 8150
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 634
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 585
- 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
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 (206))
Run Time: 0.000608
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_user_LastPostUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_thread_LastThread_3 | 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 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/Navigation/NodeType.php at line 260
- XF\Navigation\NodeType::loadPendingNodeData() in src/XF/Navigation/NodeType.php at line 140
- XF\Navigation\NodeType::displayNodeExtended() in internal_data/code_cache/navigation_cache.php at line 779
- XF\Pub\App->{closure:/var/www/teonanacatl.org/internal_data/code_cache/navigation_cache.php:3}() in src/XF/Template/Templater.php at line 8150
- XF\Template\Templater->renderNavigationClosure() in src/XF/Pub/App.php at line 634
- XF\Pub\App->getNavigation() in src/XF/Pub/App.php at line 585
- 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 | 19347 |
bytes_received | 1838271 |
packets_sent | 208 |
packets_received | 2707 |
protocol_overhead_in | 10828 |
protocol_overhead_out | 832 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 666 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 192 |
bytes_received_prepare_response_packet | 201350 |
bytes_received_change_user_packet | 1635224 |
packets_sent_command | 103 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 74 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 36 |
packets_received_prepare_response | 2338 |
packets_received_change_user | 223 |
result_set_queries | 34 |
non_result_set_queries | 2 |
no_index_used | 1 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 34 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 33 |
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 | 33 |
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 | 786 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 668 |
proto_binary_fetched_int24 | 234 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2423 |
proto_binary_fetched_decimal | 55 |
proto_binary_fetched_float | 96 |
proto_binary_fetched_double | 22 |
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 | 1394 |
proto_binary_fetched_blob | 971 |
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 | 34 |
com_stmt_execute | 34 |
com_stmt_send_long_data | 0 |
com_stmt_close | 33 |
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 | 1630379 |