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 (136220, 135906, 130883, 130831, 130678, 130436, 130336, 130201, 130123, 130000, 129960, 129817, 129801, 129572, 129189, 129161, 128933, 128798, 128723, 128320, 128284, 127746, 127699, 127683, 127485, 127473, 127444, 127003, 126491, 126234, 125937, 125803, 125706, 125517, 124187, 123962, 123847, 123349, 123331, 123225, 123152, 123021, 122951, 122897, 122893, 122882, 122792, 122751, 122734, 122702, 122698, 122689, 122688, 122677, 122087, 121775, 121471, 121463, 121453, 121452, 121451, 121449, 121396, 121394, 121337, 121036, 120931, 120889, 120886, 120885, 120882, 120866, 120023, 119516, 119393, 119318, 119278, 119275, 119273, 119163, 118652, 118467, 118433, 118414, 118264, 118063, 117937, 117853, 117818, 117692, 117685, 117538, 117392, 117265, 117026, 116357, 116339, 116312, 116127, 115774, 115371, 114603, 114119, 114065, 112977, 112903, 112721, 112184, 112065, 112024, 110741, 110685, 110457, 109930, 121695, 109805, 109477, 108358, 108241, 107989, 107979, 107541, 107501, 107500, 106432, 105993, 104803, 104754, 104160, 101708, 101688, 101553, 101115, 100482, 99959, 99309, 99110))
Run Time: 0.103556
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 137 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 23072, 0, 1715935677, {"thread-136220":["thread",136220],"thread-135906":["thread",135906],"thread-130883":["thread",130883],"thread-130831":["thread",130831],"thread-130678":["thread",130678],"thread-130436":["thread",130436],"thread-130336":["thread",130336],"thread-130201":["thread",130201],"thread-130123":["thread",130123],"thread-130000":["thread",130000],"thread-129960":["thread",129960],"thread-129817":["thread",129817],"thread-129801":["thread",129801],"thread-129572":["thread",129572],"thread-129189":["thread",129189],"thread-129161":["thread",129161],"thread-128933":["thread",128933],"thread-128798":["thread",128798],"thread-128723":["thread",128723],"thread-128320":["thread",128320],"thread-128284":["thread",128284],"thread-127746":["thread",127746],"thread-127699":["thread",127699],"thread-127683":["thread",127683],"thread-127485":["thread",127485],"thread-127473":["thread",127473],"thread-127444":["thread",127444],"thread-127003":["thread",127003],"thread-126491":["thread",126491],"thread-126234":["thread",126234],"thread-125937":["thread",125937],"thread-125803":["thread",125803],"thread-125706":["thread",125706],"thread-125517":["thread",125517],"thread-124187":["thread",124187],"thread-123962":["thread",123962],"thread-123847":["thread",123847],"thread-123349":["thread",123349],"thread-123331":["thread",123331],"thread-123225":["thread",123225],"thread-123152":["thread",123152],"thread-123021":["thread",123021],"thread-122951":["thread",122951],"thread-122897":["thread",122897],"thread-122893":["thread",122893],"thread-122882":["thread",122882],"thread-122792":["thread",122792],"thread-122751":["thread",122751],"thread-122734":["thread",122734],"thread-122702":["thread",122702],"thread-122698":["thread",122698],"thread-122689":["thread",122689],"thread-122688":["thread",122688],"thread-122677":["thread",122677],"thread-122087":["thread",122087],"thread-121775":["thread",121775],"thread-121471":["thread",121471],"thread-121463":["thread",121463],"thread-121453":["thread",121453],"thread-121452":["thread",121452],"thread-121451":["thread",121451],"thread-121449":["thread",121449],"thread-121396":["thread",121396],"thread-121394":["thread",121394],"thread-121337":["thread",121337],"thread-121036":["thread",121036],"thread-120931":["thread",120931],"thread-120889":["thread",120889],"thread-120886":["thread",120886],"thread-120885":["thread",120885],"thread-120882":["thread",120882],"thread-120866":["thread",120866],"thread-120023":["thread",120023],"thread-119516":["thread",119516],"thread-119393":["thread",119393],"thread-119318":["thread",119318],"thread-119278":["thread",119278],"thread-119275":["thread",119275],"thread-119273":["thread",119273],"thread-119163":["thread",119163],"thread-118652":["thread",118652],"thread-118467":["thread",118467],"thread-118433":["thread",118433],"thread-118414":["thread",118414],"thread-118264":["thread",118264],"thread-118063":["thread",118063],"thread-117937":["thread",117937],"thread-117853":["thread",117853],"thread-117818":["thread",117818],"thread-117692":["thread",117692],"thread-117685":["thread",117685],"thread-117538":["thread",117538],"thread-117392":["thread",117392],"thread-117265":["thread",117265],"thread-117026":["thread",117026],"thread-116357":["thread",116357],"thread-116339":["thread",116339],"thread-116312":["thread",116312],"thread-116127":["thread",116127],"thread-115774":["thread",115774],"thread-115371":["thread",115371],"thread-114603":["thread",114603],"thread-114119":["thread",114119],"thread-114065":["thread",114065],"thread-112977":["thread",112977],"thread-112903":["thread",112903],"thread-112721":["thread",112721],"thread-112184":["thread",112184],"thread-112065":["thread",112065],"thread-112024":["thread",112024],"thread-110741":["thread",110741],"thread-110685":["thread",110685],"thread-110457":["thread",110457],"thread-109930":["thread",109930],"thread-121695":["thread",121695],"thread-109805":["thread",109805],"thread-109477":["thread",109477],"thread-108358":["thread",108358],"thread-108241":["thread",108241],"thread-107989":["thread",107989],"thread-107979":["thread",107979],"thread-107541":["thread",107541],"thread-107501":["thread",107501],"thread-107500":["thread",107500],"thread-106432":["thread",106432],"thread-105993":["thread",105993],"thread-104803":["thread",104803],"thread-104754":["thread",104754],"thread-104160":["thread",104160],"thread-101708":["thread",101708],"thread-101688":["thread",101688],"thread-101553":["thread",101553],"thread-101115":["thread",101115],"thread-100482":["thread",100482],"thread-99959":["thread",99959],"thread-99309":["thread",99309],"thread-99110":["thread",99110]}, , 1715932077
Run Time: 0.003504
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20