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 (183186, 182215, 182185, 180849, 180748, 179575, 177517, 177366, 177348, 177282, 175712, 174884, 174152, 170257, 170224, 166329, 165799, 165401, 165376, 165095, 164377, 162658, 162513, 161850, 161766, 160664, 160649, 160274, 159685, 159126, 158579, 158136, 157902, 156582, 155864, 155730, 155265, 155263, 153677, 151847, 141498, 139544, 138346, 134801, 132306, 128808, 127538, 123395, 123345, 122773, 121953, 120332, 119439, 118837, 116172, 115380, 112412, 109121, 107664, 106953, 106209, 103001, 102019, 101948, 100930, 100539, 100349, 98566, 97974, 97199, 96952, 96722, 95339, 95224, 94650, 94575, 94513, 92491, 90306, 88093, 87071, 86988, 86749, 86192, 86101, 83639, 82924, 81767, 81396, 81126, 79558, 79187, 79044, 78463, 77713, 71615, 71480, 58134, 53100, 52358, 51904, 42788, 39726, 39678, 34644, 32972, 32868, 24649, 24648, 9234, 1450, 814))
Run Time: 0.073148
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 112 | 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: 214, 0, 1715986853, {"thread-183186":["thread",183186],"thread-182215":["thread",182215],"thread-182185":["thread",182185],"thread-180849":["thread",180849],"thread-180748":["thread",180748],"thread-179575":["thread",179575],"thread-177517":["thread",177517],"thread-177366":["thread",177366],"thread-177348":["thread",177348],"thread-177282":["thread",177282],"thread-175712":["thread",175712],"thread-174884":["thread",174884],"thread-174152":["thread",174152],"thread-170257":["thread",170257],"thread-170224":["thread",170224],"thread-166329":["thread",166329],"ams_article-4697":["ams_article",4697],"thread-165799":["thread",165799],"ams_article-4688":["ams_article",4688],"thread-165401":["thread",165401],"thread-165376":["thread",165376],"thread-165095":["thread",165095],"thread-164377":["thread",164377],"thread-162658":["thread",162658],"thread-162513":["thread",162513],"thread-161850":["thread",161850],"thread-161766":["thread",161766],"thread-160664":["thread",160664],"thread-160649":["thread",160649],"thread-160274":["thread",160274],"thread-159685":["thread",159685],"thread-159126":["thread",159126],"thread-158579":["thread",158579],"thread-158136":["thread",158136],"thread-157902":["thread",157902],"thread-156582":["thread",156582],"thread-155864":["thread",155864],"thread-155730":["thread",155730],"thread-155265":["thread",155265],"thread-155263":["thread",155263],"thread-153677":["thread",153677],"thread-151847":["thread",151847],"thread-141498":["thread",141498],"thread-139544":["thread",139544],"thread-138346":["thread",138346],"thread-134801":["thread",134801],"thread-132306":["thread",132306],"thread-128808":["thread",128808],"thread-127538":["thread",127538],"thread-123395":["thread",123395],"thread-123345":["thread",123345],"thread-122773":["thread",122773],"thread-121953":["thread",121953],"thread-120332":["thread",120332],"thread-119439":["thread",119439],"thread-118837":["thread",118837],"thread-116172":["thread",116172],"thread-115380":["thread",115380],"thread-112412":["thread",112412],"thread-109121":["thread",109121],"thread-107664":["thread",107664],"thread-106953":["thread",106953],"thread-106209":["thread",106209],"thread-103001":["thread",103001],"thread-102019":["thread",102019],"thread-101948":["thread",101948],"thread-100930":["thread",100930],"thread-100539":["thread",100539],"thread-100349":["thread",100349],"thread-98566":["thread",98566],"thread-97974":["thread",97974],"thread-97199":["thread",97199],"thread-96952":["thread",96952],"thread-96722":["thread",96722],"thread-95339":["thread",95339],"thread-95224":["thread",95224],"thread-94650":["thread",94650],"thread-94575":["thread",94575],"thread-94513":["thread",94513],"thread-92491":["thread",92491],"thread-90306":["thread",90306],"thread-88093":["thread",88093],"thread-87071":["thread",87071],"thread-86988":["thread",86988],"thread-86749":["thread",86749],"thread-86192":["thread",86192],"thread-86101":["thread",86101],"thread-83639":["thread",83639],"thread-82924":["thread",82924],"thread-81767":["thread",81767],"thread-81396":["thread",81396],"thread-81126":["thread",81126],"thread-79558":["thread",79558],"thread-79187":["thread",79187],"thread-79044":["thread",79044],"thread-78463":["thread",78463],"thread-77713":["thread",77713],"thread-71615":["thread",71615],"thread-71480":["thread",71480],"thread-58134":["thread",58134],"thread-53100":["thread",53100],"thread-52358":["thread",52358],"thread-51904":["thread",51904],"thread-42788":["thread",42788],"thread-39726":["thread",39726],"thread-39678":["thread",39678],"thread-34644":["thread",34644],"thread-32972":["thread",32972],"thread-32868":["thread",32868],"thread-24649":["thread",24649],"thread-24648":["thread",24648],"thread-9234":["thread",9234],"thread-1450":["thread",1450],"thread-814":["thread",814]}, , 1715983253
Run Time: 0.001660
- 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