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.001254
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 45 | 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 139
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 84
- XF\DataRegistry->get() in src/XF/App.php at line 2040
- XF\App->preLoadData() in src/XF/App.php at line 2028
- XF\App->setup() in src/XF/Pub/App.php at line 94
- XF\Pub\App->setup() in src/XF.php at line 497
- XF::setupApp() in src/XF.php at line 520
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_post_FirstPost_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_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread`.`first_post_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` IN (37535, 37534, 37533, 37532, 37531, 37530, 37529, 37528, 37527, 37526, 37525, 37524, 37523, 37522, 37521, 37520, 37519, 37518, 37517, 37516, 37515, 37514, 37513, 37512, 37511, 37510, 37509, 37508, 37507, 37506, 37505, 37504, 37503, 37502, 37501, 37500, 37499, 37498, 37497, 37496, 37495, 37494, 37493, 37492, 37491, 37490, 37489, 37488, 37487, 37486, 37485, 37484, 37483, 37482, 37481, 37480, 37479, 37478, 37477, 37476, 37475, 37474, 37473, 37472, 37471, 37470, 37469, 37468, 37467, 37466, 37465, 37464, 37463, 37462, 37461, 37460, 37459, 37458, 37457, 37456, 37455, 37454, 37453, 37452, 37451, 37450, 37449, 37448, 37447, 37446, 37445, 37444, 37443, 37442, 37441, 37440, 37439, 37438, 37437, 37436))
Run Time: 0.006985
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 100 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | mavifrfq_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_2 | eq_ref | PRIMARY | PRIMARY | 4 | mavifrfq_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY,node_id_stmlt_language_id | PRIMARY | 4 | mavifrfq_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_4 | eq_ref | PRIMARY,node_id_stmlt_language_id | PRIMARY | 4 | mavifrfq_forum.xf_forum_Forum_3.node_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,mavifrfq_forum.xf_node_Node_4.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2870
- XF\App->findByContentType() in src/XF/NewsFeed/AbstractHandler.php at line 125
- XF\NewsFeed\AbstractHandler->getContent() in src/XF/Repository/NewsFeed.php at line 145
- XF\Repository\NewsFeed->addContentToNewsFeedItems() in src/XF/Pub/Controller/WhatsNew.php at line 39
- XF\Pub\Controller\WhatsNew->actionLatestActivity() 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20