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.001759
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 (139745, 137188, 137087, 131050, 127868, 127208, 126086, 121467, 113670, 106167, 99306, 99062, 97949, 96632, 96234, 95930, 94453, 94426, 92467, 92342, 92319, 95487, 91340, 91069, 90383, 90217, 90139, 89841, 89840, 89839, 89822, 89816, 89514, 89335, 89097, 89095, 89094, 89093, 89092, 89091, 89090, 89089, 89085, 89084, 89079, 89029, 88463, 88346, 88345, 88336, 88200, 88166, 87889, 78421, 76992, 73307, 71443, 70374, 62911, 59473, 59291, 58835, 55785, 55017, 52032, 33502, 10751, 10339, 9849, 6894, 3840, 580, 536, 449, 395, 390, 338, 335, 334, 332))
Run Time: 0.154399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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: 117, 0, 1716232862, {"thread-139745":["thread",139745],"thread-137188":["thread",137188],"thread-137087":["thread",137087],"thread-131050":["thread",131050],"thread-127868":["thread",127868],"thread-127208":["thread",127208],"thread-126086":["thread",126086],"thread-121467":["thread",121467],"thread-113670":["thread",113670],"thread-106167":["thread",106167],"thread-99306":["thread",99306],"thread-99062":["thread",99062],"thread-97949":["thread",97949],"thread-96632":["thread",96632],"thread-96234":["thread",96234],"thread-95930":["thread",95930],"thread-94453":["thread",94453],"thread-94426":["thread",94426],"thread-92467":["thread",92467],"resource-72":["resource",72],"resource-71":["resource",71],"xfmg_media-103":["xfmg_media",103],"thread-92342":["thread",92342],"thread-92319":["thread",92319],"thread-95487":["thread",95487],"thread-91340":["thread",91340],"thread-91069":["thread",91069],"thread-90383":["thread",90383],"thread-90217":["thread",90217],"thread-90139":["thread",90139],"thread-89841":["thread",89841],"thread-89840":["thread",89840],"thread-89839":["thread",89839],"thread-89822":["thread",89822],"thread-89816":["thread",89816],"thread-89514":["thread",89514],"thread-89335":["thread",89335],"thread-89097":["thread",89097],"thread-89095":["thread",89095],"thread-89094":["thread",89094],"thread-89093":["thread",89093],"thread-89092":["thread",89092],"thread-89091":["thread",89091],"thread-89090":["thread",89090],"thread-89089":["thread",89089],"thread-89085":["thread",89085],"thread-89084":["thread",89084],"thread-89079":["thread",89079],"thread-89029":["thread",89029],"thread-88463":["thread",88463],"thread-88346":["thread",88346],"thread-88345":["thread",88345],"thread-88336":["thread",88336],"thread-88200":["thread",88200],"thread-88166":["thread",88166],"thread-87889":["thread",87889],"thread-78421":["thread",78421],"thread-76992":["thread",76992],"thread-73307":["thread",73307],"thread-71443":["thread",71443],"thread-70374":["thread",70374],"thread-62911":["thread",62911],"thread-59473":["thread",59473],"thread-59291":["thread",59291],"thread-58835":["thread",58835],"thread-55785":["thread",55785],"thread-55017":["thread",55017],"thread-52032":["thread",52032],"thread-33502":["thread",33502],"thread-10751":["thread",10751],"thread-10339":["thread",10339],"thread-9849":["thread",9849],"thread-6894":["thread",6894],"thread-3840":["thread",3840],"thread-580":["thread",580],"thread-536":["thread",536],"thread-449":["thread",449],"thread-395":["thread",395],"thread-390":["thread",390],"thread-338":["thread",338],"thread-335":["thread",335],"thread-334":["thread",334],"thread-332":["thread",332]}, NULL, 1716229262
Run Time: 0.001112
- 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