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', '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.000380
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 38 | 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 1907
- XF\App->preLoadData() in src/XF/App.php at line 1895
- XF\App->setup() in src/XF/Pub/App.php at line 93
- 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_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_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_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (5693901, 5787242, 5785730, 5737632, 5736841, 5726172, 5726162, 5725012, 5723652, 5721242, 5721232, 5720021, 5718712, 5717431, 5709341, 5709331, 5707391, 5705562, 5703271, 5701981, 5699322, 5696772, 5694341, 5688792, 5685861, 5682652, 5656501, 5655852, 5647742, 5647732, 5647722, 5646542, 5646532, 5639182, 5638021, 5638011, 5638001, 5637991, 5636301, 5631892, 5631391, 5629241, 5628262, 5625491, 5623972, 5623962, 5623952, 5623131, 5623121, 5622022, 5615962, 5615952, 5615942, 5615932, 5615922, 5606762, 5606722, 5605922, 5584261, 5582102, 5572931, 5572201, 5571282, 5568132, 5568071, 5567181, 5566341, 5566311, 5566141, 5565462, 5564491, 5562111, 5561172, 5560111, 5559021, 5558941, 5558151, 5557231, 5556021, 5540761, 5539741, 5537311, 5536271, 5533862, 5532841, 5531822, 5530852, 5512722, 5512191))
Run Time: 0.001885
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | animesuperhero_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,animesuperhero_xenforo.xf_node_Node_2.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 1392
- 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 2731
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 137
- XF\Pub\Controller\Tag->actionTag() 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 951, 0, 1713506112, {"thread-5787242":["thread",5787242],"thread-5785730":["thread",5785730],"thread-5737632":["thread",5737632],"thread-5726172":["thread",5726172],"thread-5726162":["thread",5726162],"thread-5725012":["thread",5725012],"thread-5723652":["thread",5723652],"thread-5721242":["thread",5721242],"thread-5721232":["thread",5721232],"thread-5720021":["thread",5720021],"thread-5718712":["thread",5718712],"thread-5717431":["thread",5717431],"thread-5709341":["thread",5709341],"thread-5709331":["thread",5709331],"thread-5707391":["thread",5707391],"thread-5705562":["thread",5705562],"thread-5703271":["thread",5703271],"thread-5701981":["thread",5701981],"thread-5699322":["thread",5699322],"thread-5696772":["thread",5696772],"thread-5694341":["thread",5694341],"thread-5688792":["thread",5688792],"thread-5685861":["thread",5685861],"thread-5682652":["thread",5682652],"thread-5656501":["thread",5656501],"thread-5655852":["thread",5655852],"thread-5647742":["thread",5647742],"thread-5647732":["thread",5647732],"thread-5647722":["thread",5647722],"thread-5646542":["thread",5646542],"thread-5646532":["thread",5646532],"thread-5639182":["thread",5639182],"thread-5638021":["thread",5638021],"thread-5638011":["thread",5638011],"thread-5638001":["thread",5638001],"thread-5637991":["thread",5637991],"thread-5636301":["thread",5636301],"thread-5631892":["thread",5631892],"thread-5631391":["thread",5631391],"thread-5629241":["thread",5629241],"thread-5628262":["thread",5628262],"thread-5625491":["thread",5625491],"thread-5623972":["thread",5623972],"thread-5623962":["thread",5623962],"thread-5623952":["thread",5623952],"thread-5623131":["thread",5623131],"thread-5623121":["thread",5623121],"thread-5622022":["thread",5622022],"thread-5615962":["thread",5615962],"thread-5615952":["thread",5615952],"thread-5615942":["thread",5615942],"thread-5615932":["thread",5615932],"thread-5615922":["thread",5615922],"thread-5606762":["thread",5606762],"thread-5605922":["thread",5605922],"thread-5584261":["thread",5584261],"thread-5582102":["thread",5582102],"thread-5572931":["thread",5572931],"thread-5572201":["thread",5572201],"thread-5571282":["thread",5571282],"thread-5568071":["thread",5568071],"thread-5567181":["thread",5567181],"thread-5566341":["thread",5566341],"thread-5566311":["thread",5566311],"thread-5565462":["thread",5565462],"thread-5564491":["thread",5564491],"thread-5562111":["thread",5562111],"thread-5561172":["thread",5561172],"thread-5560111":["thread",5560111],"thread-5559021":["thread",5559021],"thread-5558941":["thread",5558941],"thread-5558151":["thread",5558151],"thread-5557231":["thread",5557231],"thread-5556021":["thread",5556021],"thread-5540761":["thread",5540761],"thread-5539741":["thread",5539741],"thread-5537311":["thread",5537311],"thread-5536271":["thread",5536271],"thread-5533862":["thread",5533862],"thread-5532841":["thread",5532841],"thread-5531822":["thread",5531822],"thread-5530852":["thread",5530852],"thread-5512722":["thread",5512722],"thread-5512191":["thread",5512191]}, NULL, 1713502512
Run Time: 0.001834
- 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 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- XF\Pub\Controller\Tag->actionTag() 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20