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 (175370, 167215, 156222, 114246, 113004, 110721, 109800, 109753, 109701, 109390, 109376, 109035, 108350, 107849, 107815, 107808, 107114, 105924, 105463, 104797, 103767, 103766, 103030, 103028, 98613, 98432, 98365, 98341, 98267, 97937, 97932, 97921, 97910, 97353, 96948, 96856, 91207, 89068, 88561, 88526, 88480, 87679, 87489, 87339, 87153, 86599, 86597, 82456, 77092, 76350, 67057, 64191, 64185, 59794, 53447, 53261, 53260, 53183))
Run Time: 0.031916
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 58 | 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: 8672, 0, 1716154271, {"thread-175370":["thread",175370],"thread-167215":["thread",167215],"thread-156222":["thread",156222],"thread-114246":["thread",114246],"thread-113004":["thread",113004],"thread-110721":["thread",110721],"thread-109800":["thread",109800],"thread-109753":["thread",109753],"thread-109701":["thread",109701],"thread-109390":["thread",109390],"thread-109376":["thread",109376],"thread-109035":["thread",109035],"thread-108350":["thread",108350],"thread-107849":["thread",107849],"thread-107815":["thread",107815],"thread-107808":["thread",107808],"thread-107114":["thread",107114],"thread-105924":["thread",105924],"thread-105463":["thread",105463],"thread-104797":["thread",104797],"thread-103767":["thread",103767],"thread-103766":["thread",103766],"thread-103030":["thread",103030],"thread-103028":["thread",103028],"thread-98613":["thread",98613],"thread-98432":["thread",98432],"thread-98365":["thread",98365],"thread-98341":["thread",98341],"thread-98267":["thread",98267],"thread-97937":["thread",97937],"thread-97932":["thread",97932],"thread-97921":["thread",97921],"thread-97910":["thread",97910],"thread-97353":["thread",97353],"thread-96948":["thread",96948],"thread-96856":["thread",96856],"thread-91207":["thread",91207],"thread-89068":["thread",89068],"thread-88561":["thread",88561],"thread-88526":["thread",88526],"thread-88480":["thread",88480],"thread-87679":["thread",87679],"thread-87489":["thread",87489],"thread-87339":["thread",87339],"thread-87153":["thread",87153],"thread-86599":["thread",86599],"thread-86597":["thread",86597],"thread-82456":["thread",82456],"thread-77092":["thread",77092],"thread-76350":["thread",76350],"thread-67057":["thread",67057],"thread-64191":["thread",64191],"thread-64185":["thread",64185],"thread-59794":["thread",59794],"thread-53447":["thread",53447],"thread-53261":["thread",53261],"thread-53260":["thread",53260],"thread-53183":["thread",53183]}, , 1716150671
Run Time: 0.000227
- 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