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 (182646, 182399, 181611, 180739, 180530, 177313, 177104, 171210, 163181, 149223, 142413, 139476, 137761, 133686, 133341, 132920, 132542, 132541, 132171, 132112, 131911, 128912, 123596, 118936, 118250, 116767, 116201, 115330, 112671, 105378, 104709, 103315, 100521, 95680, 95410, 94553, 90426, 90375, 88674, 84766, 83403, 83031, 82058, 75416, 72951, 72803, 72748, 69865, 68883, 63357, 61195, 60577, 59388, 54447, 53851, 49732, 46125, 39678, 39658, 39482, 14396, 11124, 4011))
Run Time: 0.030773
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 63 | 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: 936, 0, 1716117927, {"thread-182646":["thread",182646],"thread-182399":["thread",182399],"thread-181611":["thread",181611],"tl_group-369":["tl_group",369],"thread-180739":["thread",180739],"thread-180530":["thread",180530],"thread-177313":["thread",177313],"thread-177104":["thread",177104],"tl_group-305":["tl_group",305],"tl_group-299":["tl_group",299],"thread-171210":["thread",171210],"thread-163181":["thread",163181],"thread-149223":["thread",149223],"thread-142413":["thread",142413],"thread-139476":["thread",139476],"thread-137761":["thread",137761],"thread-133686":["thread",133686],"thread-133341":["thread",133341],"thread-132920":["thread",132920],"thread-132542":["thread",132542],"thread-132541":["thread",132541],"thread-132171":["thread",132171],"thread-132112":["thread",132112],"thread-131911":["thread",131911],"thread-128912":["thread",128912],"thread-123596":["thread",123596],"thread-118936":["thread",118936],"thread-118250":["thread",118250],"thread-116767":["thread",116767],"thread-116201":["thread",116201],"thread-115330":["thread",115330],"thread-112671":["thread",112671],"thread-105378":["thread",105378],"thread-104709":["thread",104709],"thread-103315":["thread",103315],"thread-100521":["thread",100521],"thread-95680":["thread",95680],"thread-95410":["thread",95410],"thread-94553":["thread",94553],"thread-90426":["thread",90426],"thread-90375":["thread",90375],"thread-88674":["thread",88674],"thread-84766":["thread",84766],"thread-83403":["thread",83403],"thread-83031":["thread",83031],"thread-82058":["thread",82058],"thread-75416":["thread",75416],"thread-72951":["thread",72951],"thread-72803":["thread",72803],"thread-72748":["thread",72748],"thread-69865":["thread",69865],"thread-68883":["thread",68883],"thread-63357":["thread",63357],"thread-61195":["thread",61195],"thread-60577":["thread",60577],"thread-59388":["thread",59388],"thread-54447":["thread",54447],"thread-53851":["thread",53851],"thread-49732":["thread",49732],"thread-46125":["thread",46125],"thread-39678":["thread",39678],"thread-39658":["thread",39658],"thread-39482":["thread",39482],"thread-14396":["thread",14396],"thread-11124":["thread",11124],"thread-4011":["thread",4011]}, , 1716114327
Run Time: 0.000151
- 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