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 (182268, 181482, 180585, 180232, 179781, 179714, 178419, 177994, 177667, 177631, 176437, 175743, 175683, 175414, 175265, 175180, 174963, 174192, 174119, 174111, 173723, 173676, 173378, 173159, 173158, 173155, 173065, 173059, 171900, 171573, 171507, 171072, 170559, 169959, 169655, 167580, 167579, 167539, 166947, 166914, 166579, 166104, 166093, 165962, 165800, 164696, 164652, 164608, 164432, 163872, 163703, 163653, 163609, 163487, 163485, 163298, 162807, 162795, 162377, 161900, 161747, 161695, 161614, 161127, 160962, 160721, 160541, 159037, 156945, 156556, 156548, 155665, 154428, 154398, 154393, 153231, 151844, 147900, 129001, 124682, 123103, 122898, 120587, 118721, 114425, 108405, 107710, 101689, 101393, 92712, 89339, 88106, 80206, 75963, 64780, 62210, 61624, 56137, 54298, 53447, 53261, 53260, 53183, 45646, 45090, 42221, 25367, 12754, 11910))
Run Time: 0.056424
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 109 | 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: 1957, 0, 1714783068, {"thread-182268":["thread",182268],"thread-181482":["thread",181482],"thread-180585":["thread",180585],"thread-180232":["thread",180232],"thread-179781":["thread",179781],"thread-179714":["thread",179714],"thread-178419":["thread",178419],"thread-177994":["thread",177994],"thread-177667":["thread",177667],"thread-177631":["thread",177631],"thread-176437":["thread",176437],"thread-175743":["thread",175743],"thread-175683":["thread",175683],"thread-175414":["thread",175414],"thread-175265":["thread",175265],"thread-175180":["thread",175180],"thread-174963":["thread",174963],"thread-174192":["thread",174192],"thread-174119":["thread",174119],"thread-174111":["thread",174111],"thread-173723":["thread",173723],"thread-173676":["thread",173676],"thread-173378":["thread",173378],"thread-173159":["thread",173159],"thread-173158":["thread",173158],"thread-173155":["thread",173155],"thread-173065":["thread",173065],"thread-173059":["thread",173059],"thread-171900":["thread",171900],"thread-171573":["thread",171573],"thread-171507":["thread",171507],"thread-171072":["thread",171072],"thread-170559":["thread",170559],"thread-169959":["thread",169959],"thread-169655":["thread",169655],"thread-167580":["thread",167580],"thread-167579":["thread",167579],"thread-167539":["thread",167539],"thread-166947":["thread",166947],"thread-166914":["thread",166914],"thread-166579":["thread",166579],"thread-166104":["thread",166104],"thread-166093":["thread",166093],"thread-165962":["thread",165962],"thread-165800":["thread",165800],"thread-164696":["thread",164696],"thread-164652":["thread",164652],"thread-164608":["thread",164608],"thread-164432":["thread",164432],"thread-163872":["thread",163872],"thread-163703":["thread",163703],"thread-163653":["thread",163653],"thread-163609":["thread",163609],"thread-163487":["thread",163487],"thread-163485":["thread",163485],"thread-163298":["thread",163298],"thread-162807":["thread",162807],"thread-162795":["thread",162795],"thread-162377":["thread",162377],"thread-161900":["thread",161900],"thread-161747":["thread",161747],"thread-161695":["thread",161695],"thread-161614":["thread",161614],"thread-161127":["thread",161127],"thread-160962":["thread",160962],"thread-160721":["thread",160721],"thread-160541":["thread",160541],"ams_article-4408":["ams_article",4408],"thread-159037":["thread",159037],"thread-156945":["thread",156945],"thread-156556":["thread",156556],"thread-156548":["thread",156548],"thread-155665":["thread",155665],"thread-154428":["thread",154428],"thread-154398":["thread",154398],"thread-154393":["thread",154393],"thread-153231":["thread",153231],"thread-151844":["thread",151844],"ams_article-3867":["ams_article",3867],"thread-147900":["thread",147900],"ams_article-3312":["ams_article",3312],"ams_article-3147":["ams_article",3147],"thread-129001":["thread",129001],"thread-124682":["thread",124682],"thread-123103":["thread",123103],"thread-122898":["thread",122898],"thread-120587":["thread",120587],"thread-118721":["thread",118721],"thread-114425":["thread",114425],"thread-108405":["thread",108405],"thread-107710":["thread",107710],"thread-101689":["thread",101689],"thread-101393":["thread",101393],"thread-92712":["thread",92712],"thread-89339":["thread",89339],"thread-88106":["thread",88106],"thread-80206":["thread",80206],"thread-75963":["thread",75963],"thread-64780":["thread",64780],"thread-62210":["thread",62210],"thread-61624":["thread",61624],"thread-56137":["thread",56137],"thread-54298":["thread",54298],"thread-53447":["thread",53447],"thread-53261":["thread",53261],"thread-53260":["thread",53260],"thread-53183":["thread",53183],"thread-45646":["thread",45646],"thread-45090":["thread",45090],"thread-42221":["thread",42221],"thread-25367":["thread",25367],"thread-12754":["thread",12754],"thread-11910":["thread",11910]}, , 1714779468
Run Time: 0.000450
- 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