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 (173959, 173676, 135799, 135798, 135796, 134910, 134640, 128444, 128443, 128442, 127635, 127634, 127633, 127632, 118721, 117972, 117704, 117476, 117439, 115959, 115958, 115661, 115638, 115637, 115399, 115397, 115112, 114910, 114600, 114401, 114393, 114387, 113058, 112859, 112599, 112598, 112239, 112105, 111794, 111674, 111673, 111652, 111651, 111212, 110966, 110756, 110755, 110751, 110614, 110542, 110492, 110441, 110436, 110435, 110290, 109888, 109783, 109782, 109677, 109675, 109667, 109666, 109665, 109500, 109496, 109449, 109318, 109268, 109222))
Run Time: 0.032962
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 69 | 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: 25974, 0, 1715949156, {"thread-173959":["thread",173959],"thread-173676":["thread",173676],"thread-135799":["thread",135799],"thread-135798":["thread",135798],"thread-135796":["thread",135796],"thread-134910":["thread",134910],"thread-134640":["thread",134640],"thread-128444":["thread",128444],"thread-128443":["thread",128443],"thread-128442":["thread",128442],"thread-127635":["thread",127635],"thread-127634":["thread",127634],"thread-127633":["thread",127633],"thread-127632":["thread",127632],"thread-118721":["thread",118721],"thread-117972":["thread",117972],"thread-117704":["thread",117704],"thread-117476":["thread",117476],"thread-117439":["thread",117439],"thread-115959":["thread",115959],"thread-115958":["thread",115958],"thread-115661":["thread",115661],"thread-115638":["thread",115638],"thread-115637":["thread",115637],"thread-115399":["thread",115399],"thread-115397":["thread",115397],"thread-115112":["thread",115112],"thread-114910":["thread",114910],"thread-114600":["thread",114600],"thread-114401":["thread",114401],"thread-114393":["thread",114393],"thread-114387":["thread",114387],"thread-113058":["thread",113058],"thread-112859":["thread",112859],"thread-112599":["thread",112599],"thread-112598":["thread",112598],"thread-112239":["thread",112239],"thread-112105":["thread",112105],"thread-111794":["thread",111794],"thread-111674":["thread",111674],"thread-111673":["thread",111673],"thread-111652":["thread",111652],"thread-111651":["thread",111651],"thread-111212":["thread",111212],"thread-110966":["thread",110966],"thread-110756":["thread",110756],"thread-110755":["thread",110755],"thread-110751":["thread",110751],"thread-110614":["thread",110614],"thread-110542":["thread",110542],"thread-110492":["thread",110492],"thread-110441":["thread",110441],"thread-110436":["thread",110436],"thread-110435":["thread",110435],"thread-110290":["thread",110290],"thread-109888":["thread",109888],"thread-109783":["thread",109783],"thread-109782":["thread",109782],"thread-109677":["thread",109677],"thread-109675":["thread",109675],"thread-109667":["thread",109667],"thread-109666":["thread",109666],"thread-109665":["thread",109665],"thread-109500":["thread",109500],"thread-109496":["thread",109496],"thread-109449":["thread",109449],"thread-109318":["thread",109318],"thread-109268":["thread",109268],"thread-109222":["thread",109222]}, , 1715945556
Run Time: 0.000213
- 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