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 (7217260, 7216302, 7216300, 7213572, 7212350, 7212050, 7211760, 7210292, 7209646, 7202717, 7201734, 7201472, 7198088, 7195332, 7195146, 7193960, 7193592, 7187952, 7185730, 7185729, 7183244, 7182086, 7181954, 7180854, 7180851, 7179037, 7177668, 7172734, 7168536, 7166819, 7165927, 7165069, 7150009, 7144022, 7143300, 7142313, 7139903, 7139214, 7137761, 7133276, 7132069, 7129547, 7128239, 7125138, 7118148, 7116847, 7116391, 7115636, 7115545, 7110716, 7108685, 7106672, 7102553, 7098817, 7097991, 7096645, 7093547, 7088452, 7086357, 7083386, 7082715, 7081676, 7065534, 7065043, 7058173, 7037581, 7035620, 7034662, 7029849, 7027247, 7020288, 7019071, 7009623, 7009620, 7009618, 7007857, 7007855, 7006689, 7001253, 6998237, 6998030, 6991972, 6989759, 6986749, 6986129, 6983027, 6983025, 6982178, 6982059, 6972259, 6971011, 6962909, 6961143, 182197, 165330, 13208, 10501, 9326, 8489, 5123, 2572, 1277, 1240))
Run Time: 0.006040
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 103 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
UPDATE `xf_tag_result_cache` SET `expiry_date` = ?, `results` = ? WHERE `result_cache_id` = 292760
Params: 1714838692, {"thread-7217260":["thread",7217260],"thread-7216302":["thread",7216302],"thread-7216300":["thread",7216300],"thread-7213572":["thread",7213572],"thread-7212350":["thread",7212350],"thread-7212050":["thread",7212050],"thread-7211760":["thread",7211760],"thread-7210292":["thread",7210292],"thread-7209646":["thread",7209646],"thread-7202717":["thread",7202717],"thread-7201734":["thread",7201734],"thread-7201472":["thread",7201472],"thread-7198088":["thread",7198088],"thread-7195332":["thread",7195332],"thread-7195146":["thread",7195146],"thread-7193960":["thread",7193960],"thread-7193592":["thread",7193592],"thread-7187952":["thread",7187952],"thread-7185730":["thread",7185730],"thread-7185729":["thread",7185729],"thread-7183244":["thread",7183244],"thread-7182086":["thread",7182086],"thread-7181954":["thread",7181954],"thread-7180854":["thread",7180854],"thread-7180851":["thread",7180851],"thread-7179037":["thread",7179037],"thread-7177668":["thread",7177668],"thread-7172734":["thread",7172734],"thread-7168536":["thread",7168536],"thread-7166819":["thread",7166819],"thread-7165927":["thread",7165927],"thread-7165069":["thread",7165069],"thread-7150009":["thread",7150009],"thread-7144022":["thread",7144022],"thread-7143300":["thread",7143300],"thread-7142313":["thread",7142313],"thread-7139903":["thread",7139903],"thread-7139214":["thread",7139214],"thread-7137761":["thread",7137761],"thread-7133276":["thread",7133276],"thread-7132069":["thread",7132069],"thread-7129547":["thread",7129547],"thread-7128239":["thread",7128239],"thread-7125138":["thread",7125138],"thread-7118148":["thread",7118148],"thread-7116847":["thread",7116847],"thread-7116391":["thread",7116391],"thread-7115636":["thread",7115636],"thread-7115545":["thread",7115545],"thread-7110716":["thread",7110716],"thread-7108685":["thread",7108685],"thread-7106672":["thread",7106672],"thread-7102553":["thread",7102553],"thread-7098817":["thread",7098817],"thread-7097991":["thread",7097991],"thread-7096645":["thread",7096645],"thread-7093547":["thread",7093547],"thread-7088452":["thread",7088452],"thread-7086357":["thread",7086357],"thread-7083386":["thread",7083386],"thread-7082715":["thread",7082715],"thread-7081676":["thread",7081676],"thread-7065534":["thread",7065534],"thread-7065043":["thread",7065043],"thread-7058173":["thread",7058173],"thread-7037581":["thread",7037581],"thread-7035620":["thread",7035620],"thread-7034662":["thread",7034662],"thread-7029849":["thread",7029849],"thread-7027247":["thread",7027247],"thread-7020288":["thread",7020288],"thread-7019071":["thread",7019071],"thread-7009623":["thread",7009623],"thread-7009620":["thread",7009620],"thread-7009618":["thread",7009618],"thread-7007857":["thread",7007857],"thread-7007855":["thread",7007855],"thread-7006689":["thread",7006689],"thread-7001253":["thread",7001253],"thread-6998237":["thread",6998237],"thread-6998030":["thread",6998030],"thread-6991972":["thread",6991972],"thread-6989759":["thread",6989759],"thread-6986749":["thread",6986749],"thread-6986129":["thread",6986129],"thread-6983027":["thread",6983027],"thread-6983025":["thread",6983025],"thread-6982178":["thread",6982178],"thread-6982059":["thread",6982059],"thread-6972259":["thread",6972259],"thread-6971011":["thread",6971011],"thread-6962909":["thread",6962909],"thread-6961143":["thread",6961143],"thread-182197":["thread",182197],"thread-165330":["thread",165330],"thread-13208":["thread",13208],"thread-10501":["thread",10501],"thread-9326":["thread",9326],"thread-8489":["thread",8489],"thread-5123":["thread",5123],"thread-2572":["thread",2572],"thread-1277":["thread",1277],"thread-1240":["thread",1240]}
Run Time: 0.000419
- 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 324
- XF\Db\AbstractAdapter->update() in src/XF/Mvc/Entity/Entity.php at line 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20