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 (183550, 183454, 183220, 182823, 182796, 179441, 179122, 175532, 174803, 172919, 167976, 167158, 166286, 164857, 163178, 158195, 157113, 154233, 154224, 152134, 146768, 144851, 143555, 136598, 130764, 129569, 129391, 128844, 128435, 128042, 127460, 126478, 125741, 125677, 125601, 125600, 125596, 125583, 125514, 124623, 124169, 124168, 124016, 123905, 123741, 123144, 122960, 118526, 113711, 113681, 113588, 109250, 109247, 109246, 109245, 109244, 109243, 109242, 109240, 109032, 107972, 106941, 105962, 105478, 104605, 104201, 103961, 103896, 103804, 103697, 103420, 103188, 101907, 100650, 100610, 100457, 100283, 99987, 99796, 92311, 85581, 74877, 71044, 70686, 66286, 41578, 38670, 36405, 36403, 15387))
Run Time: 0.071295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 90 | 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: 2222, 0, 1716047611, {"thread-183550":["thread",183550],"thread-183454":["thread",183454],"thread-183220":["thread",183220],"thread-182823":["thread",182823],"thread-182796":["thread",182796],"thread-179441":["thread",179441],"thread-179122":["thread",179122],"thread-175532":["thread",175532],"thread-174803":["thread",174803],"thread-172919":["thread",172919],"thread-167976":["thread",167976],"thread-167158":["thread",167158],"thread-166286":["thread",166286],"thread-164857":["thread",164857],"thread-163178":["thread",163178],"thread-158195":["thread",158195],"thread-157113":["thread",157113],"thread-154233":["thread",154233],"thread-154224":["thread",154224],"thread-152134":["thread",152134],"thread-146768":["thread",146768],"thread-144851":["thread",144851],"thread-143555":["thread",143555],"thread-136598":["thread",136598],"thread-130764":["thread",130764],"thread-129569":["thread",129569],"thread-129391":["thread",129391],"thread-128844":["thread",128844],"thread-128435":["thread",128435],"thread-128042":["thread",128042],"thread-127460":["thread",127460],"thread-126478":["thread",126478],"thread-125741":["thread",125741],"thread-125677":["thread",125677],"thread-125601":["thread",125601],"thread-125600":["thread",125600],"thread-125596":["thread",125596],"thread-125583":["thread",125583],"thread-125514":["thread",125514],"thread-124623":["thread",124623],"thread-124169":["thread",124169],"thread-124168":["thread",124168],"thread-124016":["thread",124016],"thread-123905":["thread",123905],"thread-123741":["thread",123741],"thread-123144":["thread",123144],"thread-122960":["thread",122960],"thread-118526":["thread",118526],"thread-113711":["thread",113711],"thread-113681":["thread",113681],"thread-113588":["thread",113588],"thread-109250":["thread",109250],"thread-109247":["thread",109247],"thread-109246":["thread",109246],"thread-109245":["thread",109245],"thread-109244":["thread",109244],"thread-109243":["thread",109243],"thread-109242":["thread",109242],"thread-109240":["thread",109240],"thread-109032":["thread",109032],"thread-107972":["thread",107972],"thread-106941":["thread",106941],"thread-105962":["thread",105962],"thread-105478":["thread",105478],"thread-104605":["thread",104605],"thread-104201":["thread",104201],"thread-103961":["thread",103961],"thread-103896":["thread",103896],"thread-103804":["thread",103804],"thread-103697":["thread",103697],"thread-103420":["thread",103420],"thread-103188":["thread",103188],"thread-101907":["thread",101907],"thread-100650":["thread",100650],"thread-100610":["thread",100610],"thread-100457":["thread",100457],"thread-100283":["thread",100283],"thread-99987":["thread",99987],"thread-99796":["thread",99796],"thread-92311":["thread",92311],"thread-85581":["thread",85581],"thread-74877":["thread",74877],"thread-71044":["thread",71044],"thread-70686":["thread",70686],"thread-66286":["thread",66286],"thread-41578":["thread",41578],"thread-38670":["thread",38670],"thread-36405":["thread",36405],"thread-36403":["thread",36403],"thread-15387":["thread",15387]}, , 1716044011
Run Time: 0.010678
- 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