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 (7216982, 7216454, 7216452, 7216227, 7216029, 7215984, 7215720, 7214883, 7214227, 7213501, 7213068, 7212881, 7212350, 7212291, 7212077, 7212050, 7211600, 7210381, 7209660, 7209503, 7208233, 7206819, 7206580, 7206473, 7206360, 7206083, 7205741, 7205730, 7204507, 7203709, 7201737, 7201472, 7200820, 7200456, 7200373, 7200002, 7199560, 7198340, 7198088, 7197882, 7197547, 7196996, 7196638, 7196283, 7195920, 7195864, 7195159, 7195158, 7194586, 7194166, 7193002, 7192793, 7192769, 7192275, 7191423, 7189849, 7188589, 7188557, 7188083, 7187952, 7187740, 7187636, 7187557, 7187337, 7186394, 7185673, 7185360, 7185267, 7184516, 7184350, 7184135, 7183337, 7182513, 7182509, 7181954, 7180851, 7180357, 7180355, 7179751, 7179690, 7179366, 7179037, 7178529, 7178381, 7178047, 7177648, 7176760, 7175891, 7175470, 7172273, 7170727, 7170486, 7170190, 7170001, 7168536, 7168422, 7167410, 7166819, 7166450, 7163324, 7160354, 7159684, 7159633, 7157897, 7156986, 7156473, 7155135, 7154328, 7154217, 7152010, 7150419, 7148476, 7147814, 7147324, 7146588, 7143524, 7140937, 7139887, 7139615, 7139396, 7138558, 7138345, 7138085, 7137829, 7137761, 7137675, 7136905, 7134489, 7129963, 7129547, 7126993, 7126683, 7125138, 7122752, 7122609, 7122141, 7121861, 7118412, 7116391, 7115545, 7112711, 7112417, 7112123, 7111443, 7110183, 7109623, 7109436, 7108884, 7108717, 7108685, 7106772, 7105850, 7105127, 7104279, 7102986, 7100709, 7099920, 7098754, 7097993, 7097991, 7097607, 7097533, 7093226, 7092613, 7092491, 7092222, 7091714, 7089578, 7089232, 7089113, 7088715, 7087680, 7087022, 7086683, 7086014, 7085322, 7085166, 7084906, 7083541, 7083413, 7081141, 7079872, 7079594, 7076441, 7069476, 7068678, 7067072, 7066960, 7061925, 7053764, 7053755, 7053648, 7052757, 7050357, 7049942, 7047798, 7047559, 7045426, 7045320, 7041665))
Run Time: 0.010990
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 486, 0, 1714813698, {"thread-7216982":["thread",7216982],"thread-7216454":["thread",7216454],"thread-7216452":["thread",7216452],"thread-7216227":["thread",7216227],"thread-7216029":["thread",7216029],"thread-7215984":["thread",7215984],"thread-7215720":["thread",7215720],"thread-7214883":["thread",7214883],"thread-7214227":["thread",7214227],"thread-7213501":["thread",7213501],"thread-7213068":["thread",7213068],"thread-7212881":["thread",7212881],"thread-7212350":["thread",7212350],"thread-7212291":["thread",7212291],"thread-7212077":["thread",7212077],"thread-7212050":["thread",7212050],"thread-7211600":["thread",7211600],"thread-7210381":["thread",7210381],"thread-7209660":["thread",7209660],"thread-7209503":["thread",7209503],"thread-7208233":["thread",7208233],"thread-7206819":["thread",7206819],"thread-7206580":["thread",7206580],"thread-7206473":["thread",7206473],"thread-7206360":["thread",7206360],"thread-7206083":["thread",7206083],"thread-7205741":["thread",7205741],"thread-7205730":["thread",7205730],"thread-7204507":["thread",7204507],"thread-7203709":["thread",7203709],"thread-7201737":["thread",7201737],"thread-7201472":["thread",7201472],"thread-7200820":["thread",7200820],"thread-7200456":["thread",7200456],"thread-7200373":["thread",7200373],"thread-7200002":["thread",7200002],"thread-7199560":["thread",7199560],"thread-7198340":["thread",7198340],"thread-7198088":["thread",7198088],"thread-7197882":["thread",7197882],"thread-7197547":["thread",7197547],"thread-7196996":["thread",7196996],"thread-7196638":["thread",7196638],"thread-7196283":["thread",7196283],"thread-7195920":["thread",7195920],"thread-7195864":["thread",7195864],"thread-7195159":["thread",7195159],"thread-7195158":["thread",7195158],"thread-7194586":["thread",7194586],"thread-7194166":["thread",7194166],"thread-7193002":["thread",7193002],"thread-7192793":["thread",7192793],"thread-7192769":["thread",7192769],"thread-7192275":["thread",7192275],"thread-7191423":["thread",7191423],"thread-7189849":["thread",7189849],"thread-7188589":["thread",7188589],"thread-7188557":["thread",7188557],"thread-7188083":["thread",7188083],"thread-7187952":["thread",7187952],"thread-7187740":["thread",7187740],"thread-7187636":["thread",7187636],"thread-7187557":["thread",7187557],"thread-7187337":["thread",7187337],"thread-7186394":["thread",7186394],"thread-7185673":["thread",7185673],"thread-7185360":["thread",7185360],"thread-7185267":["thread",7185267],"thread-7184516":["thread",7184516],"thread-7184350":["thread",7184350],"thread-7184135":["thread",7184135],"thread-7183337":["thread",7183337],"thread-7182513":["thread",7182513],"thread-7182509":["thread",7182509],"thread-7181954":["thread",7181954],"thread-7180851":["thread",7180851],"thread-7180357":["thread",7180357],"thread-7180355":["thread",7180355],"thread-7179751":["thread",7179751],"thread-7179690":["thread",7179690],"thread-7179366":["thread",7179366],"thread-7179037":["thread",7179037],"thread-7178529":["thread",7178529],"thread-7178381":["thread",7178381],"thread-7178047":["thread",7178047],"thread-7177648":["thread",7177648],"thread-7176760":["thread",7176760],"thread-7175891":["thread",7175891],"thread-7175470":["thread",7175470],"thread-7172273":["thread",7172273],"thread-7170727":["thread",7170727],"thread-7170486":["thread",7170486],"thread-7170190":["thread",7170190],"thread-7170001":["thread",7170001],"thread-7168536":["thread",7168536],"thread-7168422":["thread",7168422],"thread-7167410":["thread",7167410],"thread-7166819":["thread",7166819],"thread-7166450":["thread",7166450],"thread-7163324":["thread",7163324],"thread-7160354":["thread",7160354],"thread-7159684":["thread",7159684],"thread-7159633":["thread",7159633],"thread-7157897":["thread",7157897],"thread-7156986":["thread",7156986],"thread-7156473":["thread",7156473],"thread-7155135":["thread",7155135],"thread-7154328":["thread",7154328],"thread-7154217":["thread",7154217],"thread-7152010":["thread",7152010],"thread-7150419":["thread",7150419],"thread-7148476":["thread",7148476],"thread-7147814":["thread",7147814],"thread-7147324":["thread",7147324],"thread-7146588":["thread",7146588],"thread-7143524":["thread",7143524],"thread-7140937":["thread",7140937],"thread-7139887":["thread",7139887],"thread-7139615":["thread",7139615],"thread-7139396":["thread",7139396],"thread-7138558":["thread",7138558],"thread-7138345":["thread",7138345],"thread-7138085":["thread",7138085],"thread-7137829":["thread",7137829],"thread-7137761":["thread",7137761],"thread-7137675":["thread",7137675],"thread-7136905":["thread",7136905],"thread-7134489":["thread",7134489],"thread-7129963":["thread",7129963],"thread-7129547":["thread",7129547],"thread-7126993":["thread",7126993],"thread-7126683":["thread",7126683],"thread-7125138":["thread",7125138],"thread-7122752":["thread",7122752],"thread-7122609":["thread",7122609],"thread-7122141":["thread",7122141],"thread-7121861":["thread",7121861],"thread-7118412":["thread",7118412],"thread-7116391":["thread",7116391],"thread-7115545":["thread",7115545],"thread-7112711":["thread",7112711],"thread-7112417":["thread",7112417],"thread-7112123":["thread",7112123],"thread-7111443":["thread",7111443],"thread-7110183":["thread",7110183],"thread-7109623":["thread",7109623],"thread-7109436":["thread",7109436],"thread-7108884":["thread",7108884],"thread-7108717":["thread",7108717],"thread-7108685":["thread",7108685],"thread-7106772":["thread",7106772],"thread-7105850":["thread",7105850],"thread-7105127":["thread",7105127],"thread-7104279":["thread",7104279],"thread-7102986":["thread",7102986],"thread-7100709":["thread",7100709],"thread-7099920":["thread",7099920],"thread-7098754":["thread",7098754],"thread-7097993":["thread",7097993],"thread-7097991":["thread",7097991],"thread-7097607":["thread",7097607],"thread-7097533":["thread",7097533],"thread-7093226":["thread",7093226],"thread-7092613":["thread",7092613],"thread-7092491":["thread",7092491],"thread-7092222":["thread",7092222],"thread-7091714":["thread",7091714],"thread-7089578":["thread",7089578],"thread-7089232":["thread",7089232],"thread-7089113":["thread",7089113],"thread-7088715":["thread",7088715],"thread-7087680":["thread",7087680],"thread-7087022":["thread",7087022],"thread-7086683":["thread",7086683],"thread-7086014":["thread",7086014],"thread-7085322":["thread",7085322],"thread-7085166":["thread",7085166],"thread-7084906":["thread",7084906],"thread-7083541":["thread",7083541],"thread-7083413":["thread",7083413],"thread-7081141":["thread",7081141],"thread-7079872":["thread",7079872],"thread-7079594":["thread",7079594],"thread-7076441":["thread",7076441],"thread-7069476":["thread",7069476],"thread-7068678":["thread",7068678],"thread-7067072":["thread",7067072],"thread-7066960":["thread",7066960],"thread-7061925":["thread",7061925],"thread-7053764":["thread",7053764],"thread-7053755":["thread",7053755],"thread-7053648":["thread",7053648],"thread-7052757":["thread",7052757],"thread-7050357":["thread",7050357],"thread-7049942":["thread",7049942],"thread-7047798":["thread",7047798],"thread-7047559":["thread",7047559],"thread-7045426":["thread",7045426],"thread-7045320":["thread",7045320],"thread-7041665":["thread",7041665]}, NULL, 1714810098
Run Time: 0.000689
- 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 1521
- 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