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 (7216477, 7215005, 7213042, 7212131, 7212129, 7206236, 7204040, 7198397, 7197833, 7196225, 7194546, 7192914, 7192908, 7186814, 7183903, 7183596, 7183432, 7183325, 7183025, 7182311, 7181139, 7177499, 7176054, 7174148, 7172947, 7172257, 7171855, 7171783, 7171435, 7170066, 7166551, 7165271, 7163027, 7160641, 7160344, 7160343, 7160003, 7159498, 7155701, 7155171, 7151224, 7149458, 7147091, 7144229, 7137028, 7133728, 7133567, 7133379, 7129987, 7128922, 7126116, 7124438, 7123958, 7121666, 7118412, 7117009, 7114280, 7111377, 7110062, 7110021, 7109947, 7104657, 7103854, 7102616, 7100594, 7097793, 7096641, 7094570, 7093240, 7093127, 7087105, 7078411, 7075822, 7074130, 7073455, 7073372, 7072145, 7071360, 7069279, 7066188, 7064270, 7062394, 7060982, 7059689, 7058195, 7054499, 7053915, 7052749, 7052315, 7051560, 7050625, 7050207, 7050172, 7046669, 7038869, 7033256, 7032285, 7032097, 7030920, 7016754, 7010336, 7006975, 7003713, 7003456, 6997284, 6996369, 6993797, 6993273, 6991173, 6990387, 6986631, 6985962, 6984012, 6980008, 6979354, 6970444, 6966382, 6964515, 6856644, 6810464, 6773901, 6373818, 221334, 212680, 207587, 198487, 191592, 176293, 160397, 13812, 12989, 12686, 12434, 11700, 11488, 11363, 10814, 10644, 10545, 10209, 10072, 9426, 8102, 7944, 7434, 7220, 6674, 6174, 6078, 5972, 5934, 5825, 5177, 4515, 4269, 4233, 4151, 4114, 4039, 4012, 3973, 3512, 3373, 3251, 3250, 3133, 1757, 1171, 822, 741))
Run Time: 0.008309
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 170 | 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` = 291308
Params: 1714255243, {"thread-7216477":["thread",7216477],"thread-7215005":["thread",7215005],"thread-7213042":["thread",7213042],"thread-7212131":["thread",7212131],"thread-7212129":["thread",7212129],"thread-7206236":["thread",7206236],"thread-7204040":["thread",7204040],"thread-7198397":["thread",7198397],"thread-7197833":["thread",7197833],"thread-7196225":["thread",7196225],"thread-7194546":["thread",7194546],"thread-7192914":["thread",7192914],"thread-7192908":["thread",7192908],"thread-7186814":["thread",7186814],"thread-7183903":["thread",7183903],"thread-7183596":["thread",7183596],"thread-7183432":["thread",7183432],"thread-7183325":["thread",7183325],"thread-7183025":["thread",7183025],"thread-7182311":["thread",7182311],"thread-7181139":["thread",7181139],"thread-7177499":["thread",7177499],"thread-7176054":["thread",7176054],"thread-7174148":["thread",7174148],"thread-7172947":["thread",7172947],"thread-7172257":["thread",7172257],"thread-7171855":["thread",7171855],"thread-7171783":["thread",7171783],"thread-7171435":["thread",7171435],"thread-7170066":["thread",7170066],"thread-7166551":["thread",7166551],"thread-7165271":["thread",7165271],"thread-7163027":["thread",7163027],"thread-7160641":["thread",7160641],"thread-7160344":["thread",7160344],"thread-7160343":["thread",7160343],"thread-7160003":["thread",7160003],"thread-7159498":["thread",7159498],"thread-7155701":["thread",7155701],"thread-7155171":["thread",7155171],"thread-7151224":["thread",7151224],"thread-7149458":["thread",7149458],"thread-7147091":["thread",7147091],"thread-7144229":["thread",7144229],"thread-7137028":["thread",7137028],"thread-7133728":["thread",7133728],"thread-7133567":["thread",7133567],"thread-7133379":["thread",7133379],"thread-7129987":["thread",7129987],"thread-7128922":["thread",7128922],"thread-7126116":["thread",7126116],"thread-7124438":["thread",7124438],"thread-7123958":["thread",7123958],"thread-7121666":["thread",7121666],"thread-7118412":["thread",7118412],"thread-7117009":["thread",7117009],"thread-7114280":["thread",7114280],"thread-7111377":["thread",7111377],"thread-7110062":["thread",7110062],"thread-7110021":["thread",7110021],"thread-7109947":["thread",7109947],"thread-7104657":["thread",7104657],"thread-7103854":["thread",7103854],"thread-7102616":["thread",7102616],"thread-7100594":["thread",7100594],"thread-7097793":["thread",7097793],"thread-7096641":["thread",7096641],"thread-7094570":["thread",7094570],"thread-7093240":["thread",7093240],"thread-7093127":["thread",7093127],"thread-7087105":["thread",7087105],"thread-7078411":["thread",7078411],"thread-7075822":["thread",7075822],"thread-7074130":["thread",7074130],"thread-7073455":["thread",7073455],"thread-7073372":["thread",7073372],"thread-7072145":["thread",7072145],"thread-7071360":["thread",7071360],"thread-7069279":["thread",7069279],"thread-7066188":["thread",7066188],"thread-7064270":["thread",7064270],"thread-7062394":["thread",7062394],"thread-7060982":["thread",7060982],"thread-7059689":["thread",7059689],"thread-7058195":["thread",7058195],"thread-7054499":["thread",7054499],"thread-7053915":["thread",7053915],"thread-7052749":["thread",7052749],"thread-7052315":["thread",7052315],"thread-7051560":["thread",7051560],"thread-7050625":["thread",7050625],"thread-7050207":["thread",7050207],"thread-7050172":["thread",7050172],"thread-7046669":["thread",7046669],"thread-7038869":["thread",7038869],"thread-7033256":["thread",7033256],"thread-7032285":["thread",7032285],"thread-7032097":["thread",7032097],"thread-7030920":["thread",7030920],"thread-7016754":["thread",7016754],"thread-7010336":["thread",7010336],"thread-7006975":["thread",7006975],"thread-7003713":["thread",7003713],"thread-7003456":["thread",7003456],"thread-6997284":["thread",6997284],"thread-6996369":["thread",6996369],"thread-6993797":["thread",6993797],"thread-6993273":["thread",6993273],"thread-6991173":["thread",6991173],"thread-6990387":["thread",6990387],"thread-6986631":["thread",6986631],"thread-6985962":["thread",6985962],"thread-6984012":["thread",6984012],"thread-6980008":["thread",6980008],"thread-6979354":["thread",6979354],"thread-6970444":["thread",6970444],"thread-6966382":["thread",6966382],"thread-6964515":["thread",6964515],"thread-6856644":["thread",6856644],"thread-6810464":["thread",6810464],"thread-6773901":["thread",6773901],"thread-221334":["thread",221334],"thread-212680":["thread",212680],"thread-207587":["thread",207587],"thread-198487":["thread",198487],"thread-191592":["thread",191592],"thread-176293":["thread",176293],"thread-160397":["thread",160397],"thread-13812":["thread",13812],"thread-12989":["thread",12989],"thread-12686":["thread",12686],"thread-12434":["thread",12434],"thread-11700":["thread",11700],"thread-11488":["thread",11488],"thread-11363":["thread",11363],"thread-10814":["thread",10814],"thread-10644":["thread",10644],"thread-10545":["thread",10545],"thread-10209":["thread",10209],"thread-10072":["thread",10072],"thread-9426":["thread",9426],"thread-8102":["thread",8102],"thread-7944":["thread",7944],"thread-7434":["thread",7434],"thread-7220":["thread",7220],"thread-6674":["thread",6674],"thread-6174":["thread",6174],"thread-6078":["thread",6078],"thread-5972":["thread",5972],"thread-5934":["thread",5934],"thread-5825":["thread",5825],"thread-5177":["thread",5177],"thread-4515":["thread",4515],"thread-4269":["thread",4269],"thread-4233":["thread",4233],"thread-4151":["thread",4151],"thread-4114":["thread",4114],"thread-4039":["thread",4039],"thread-4012":["thread",4012],"thread-3973":["thread",3973],"thread-3512":["thread",3512],"thread-3373":["thread",3373],"thread-3251":["thread",3251],"thread-3250":["thread",3250],"thread-3133":["thread",3133],"thread-1757":["thread",1757],"thread-1171":["thread",1171],"thread-822":["thread",822],"thread-741":["thread",741]}
Run Time: 0.000643
- 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