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.000290
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 47 | 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_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 (111640, 111626, 111521, 110856, 110338, 110207, 109987, 109696, 109663, 109428, 109415, 109411, 109359, 109323, 109213, 109124, 109000, 108906, 108769, 108203, 103829, 103688, 103168, 96801, 95247, 93522, 92769, 91566, 91075, 90729, 89964, 88749, 87526, 87395, 87191, 87141, 86489, 86488, 86339, 85556, 84786, 84364, 84353, 83483, 81991, 81888, 78921, 77310, 76370, 71135, 71092, 70792, 68723, 67822, 66695, 66676, 65264, 62550, 62002, 61747, 60497, 60474, 59468, 59259, 59010, 58971, 58657, 58557, 55274, 54661, 53693, 52335, 50880, 48636, 48606, 48361, 47763, 47731, 46893, 46854, 46841, 46609, 44287, 42755, 29129, 28805, 23279, 21145, 6339))
Run Time: 0.030900
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 | s_forum_biz_db.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | s_forum_biz_db.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | s_forum_biz_db.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | s_forum_biz_db.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,s_forum_biz_db.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 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/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 138
- 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 2487
- 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: 30, 0, 1686292048, {"thread-111640":["thread",111640],"thread-111626":["thread",111626],"thread-111521":["thread",111521],"thread-110856":["thread",110856],"thread-110338":["thread",110338],"thread-110207":["thread",110207],"thread-109987":["thread",109987],"thread-109696":["thread",109696],"thread-109663":["thread",109663],"thread-109428":["thread",109428],"thread-109415":["thread",109415],"thread-109411":["thread",109411],"thread-109359":["thread",109359],"thread-109323":["thread",109323],"thread-109213":["thread",109213],"thread-109124":["thread",109124],"thread-109000":["thread",109000],"thread-108906":["thread",108906],"thread-108769":["thread",108769],"thread-108203":["thread",108203],"thread-103829":["thread",103829],"thread-103688":["thread",103688],"thread-103168":["thread",103168],"thread-96801":["thread",96801],"thread-95247":["thread",95247],"thread-93522":["thread",93522],"thread-92769":["thread",92769],"thread-91566":["thread",91566],"thread-91075":["thread",91075],"thread-90729":["thread",90729],"thread-89964":["thread",89964],"thread-88749":["thread",88749],"thread-87526":["thread",87526],"thread-87395":["thread",87395],"thread-87191":["thread",87191],"thread-87141":["thread",87141],"thread-86489":["thread",86489],"thread-86488":["thread",86488],"thread-86339":["thread",86339],"thread-85556":["thread",85556],"thread-84786":["thread",84786],"thread-84364":["thread",84364],"thread-84353":["thread",84353],"thread-83483":["thread",83483],"thread-81991":["thread",81991],"thread-81888":["thread",81888],"thread-78921":["thread",78921],"thread-77310":["thread",77310],"thread-76370":["thread",76370],"thread-71135":["thread",71135],"thread-71092":["thread",71092],"thread-70792":["thread",70792],"thread-68723":["thread",68723],"thread-67822":["thread",67822],"thread-66695":["thread",66695],"thread-66676":["thread",66676],"thread-65264":["thread",65264],"thread-62550":["thread",62550],"thread-62002":["thread",62002],"thread-61747":["thread",61747],"thread-60497":["thread",60497],"thread-60474":["thread",60474],"thread-59468":["thread",59468],"thread-59259":["thread",59259],"thread-59010":["thread",59010],"thread-58971":["thread",58971],"thread-58657":["thread",58657],"thread-58557":["thread",58557],"thread-55274":["thread",55274],"thread-54661":["thread",54661],"thread-53693":["thread",53693],"thread-52335":["thread",52335],"thread-50880":["thread",50880],"thread-48636":["thread",48636],"thread-48606":["thread",48606],"thread-48361":["thread",48361],"thread-47763":["thread",47763],"thread-47731":["thread",47731],"thread-46893":["thread",46893],"thread-46854":["thread",46854],"thread-46841":["thread",46841],"thread-46609":["thread",46609],"thread-44287":["thread",44287],"thread-42755":["thread",42755],"thread-29129":["thread",29129],"thread-28805":["thread",28805],"thread-23279":["thread",23279],"thread-21145":["thread",21145],"thread-6339":["thread",6339]}, NULL, 1686288448
Run Time: 0.000493
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20