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 (174812, 137392, 136635, 135593, 135353, 130322, 130085, 129744, 129168, 128207, 127854, 126485, 126316, 126280, 125928, 125841, 125729, 125702, 125600, 125596, 125527, 125343, 124698, 123892, 123878, 123838, 122374, 121872, 121217, 117702, 117234, 117142, 114996, 113758, 113736, 113685, 106012, 105827, 105402, 104237, 100445, 100386, 100039, 99784, 98645, 97979, 97161, 96901, 96734, 96153, 94748, 94720, 94719, 94709, 88119, 86660, 81166, 81108, 81061, 80422, 80404, 80183, 49107, 44750, 44324, 43053, 43038, 42703, 39044, 32971, 17272))
Run Time: 0.049155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 71 | 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: 2391, 0, 1716013143, {"thread-174812":["thread",174812],"ams_article-3209":["ams_article",3209],"ams_article-3167":["ams_article",3167],"ams_article-3067":["ams_article",3067],"thread-137392":["thread",137392],"thread-136635":["thread",136635],"thread-135593":["thread",135593],"thread-135353":["thread",135353],"thread-130322":["thread",130322],"thread-130085":["thread",130085],"thread-129744":["thread",129744],"thread-129168":["thread",129168],"thread-128207":["thread",128207],"thread-127854":["thread",127854],"thread-126485":["thread",126485],"thread-126316":["thread",126316],"thread-126280":["thread",126280],"thread-125928":["thread",125928],"thread-125841":["thread",125841],"thread-125729":["thread",125729],"thread-125702":["thread",125702],"thread-125600":["thread",125600],"thread-125596":["thread",125596],"thread-125527":["thread",125527],"thread-125343":["thread",125343],"thread-124698":["thread",124698],"thread-123892":["thread",123892],"thread-123878":["thread",123878],"thread-123838":["thread",123838],"thread-122374":["thread",122374],"thread-121872":["thread",121872],"thread-121217":["thread",121217],"thread-117702":["thread",117702],"thread-117234":["thread",117234],"thread-117142":["thread",117142],"thread-114996":["thread",114996],"thread-113758":["thread",113758],"thread-113736":["thread",113736],"thread-113685":["thread",113685],"thread-106012":["thread",106012],"thread-105827":["thread",105827],"thread-105402":["thread",105402],"thread-104237":["thread",104237],"thread-100445":["thread",100445],"thread-100386":["thread",100386],"thread-100039":["thread",100039],"thread-99784":["thread",99784],"thread-98645":["thread",98645],"thread-97979":["thread",97979],"thread-97161":["thread",97161],"thread-96901":["thread",96901],"thread-96734":["thread",96734],"thread-96153":["thread",96153],"thread-94748":["thread",94748],"thread-94720":["thread",94720],"thread-94719":["thread",94719],"thread-94709":["thread",94709],"thread-88119":["thread",88119],"thread-86660":["thread",86660],"thread-81166":["thread",81166],"thread-81108":["thread",81108],"thread-81061":["thread",81061],"thread-80422":["thread",80422],"thread-80404":["thread",80404],"thread-80183":["thread",80183],"thread-49107":["thread",49107],"thread-44750":["thread",44750],"thread-44324":["thread",44324],"thread-43053":["thread",43053],"thread-43038":["thread",43038],"thread-42703":["thread",42703],"thread-39044":["thread",39044],"thread-32971":["thread",32971],"thread-17272":["thread",17272]}, , 1716009543
Run Time: 0.000180
- 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