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 (7215269, 7215236, 7206596, 7205507, 7201572, 7196168, 7192122, 7191434, 7185615, 7184520, 7180356, 7177761, 7177554, 7175455, 7167540, 7166519, 7161883, 7151814, 7149348, 7139773, 7134641, 7134466, 7131418, 7122333, 7120666, 7118429, 7114736, 7110875, 7110227, 7109944, 7109726, 7107016, 7104014, 7101121, 7099077, 7093659, 7090030, 7089023, 7086900, 7086794, 7085123, 7082596, 7080331, 7079582, 7079260, 7078823, 7078232, 7075610, 7075505, 7072466, 7070719, 7070287, 7066208, 7066082, 7063240, 7061727, 7061090, 7060986, 7060182, 7058864, 7058381, 7058209, 7058173, 7057638, 7056449, 7055980, 7055277, 7053458, 7053159, 7053149, 7051799, 7051798, 7050904, 7050411, 7049437, 7033654, 7033459, 7029929, 6994373, 6981701, 233100, 201533, 197000, 167219, 167147, 160773, 13831, 13803, 13683, 13466, 13243, 13234, 12936, 12672, 12091, 12059, 12054, 12053, 11878, 11582, 11441, 11339, 11274, 11053, 10835, 10591, 10256, 10250, 10160, 10085, 10067, 9849, 9703, 9676, 9571, 9511, 9434, 9365, 9073, 8972, 8859, 8771, 8450, 8446, 8445, 8430, 8239, 8237, 8181, 8143, 8123, 7683, 7659, 7584, 7388, 7107, 6938, 6933, 6919, 6794, 6702, 6609, 6162, 6090, 5767, 5632, 5525, 5374, 5113, 4923, 4875, 4779, 4358, 4312, 4285, 4246, 4082, 4019, 4010, 3855, 3586, 3264, 3030, 2919, 2905, 2838, 2810, 2760, 2363, 2324, 2273, 2136, 2124, 2102, 2093, 2090, 2089, 1963, 1955, 1900, 1861, 1811, 1674, 1550, 1386, 1373, 1305, 1267, 607, 595, 579, 552, 444))
Run Time: 0.010157
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 193 | 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: 504, 0, 1714889533, {"thread-7215269":["thread",7215269],"thread-7215236":["thread",7215236],"thread-7206596":["thread",7206596],"thread-7205507":["thread",7205507],"thread-7201572":["thread",7201572],"thread-7196168":["thread",7196168],"thread-7192122":["thread",7192122],"thread-7191434":["thread",7191434],"thread-7185615":["thread",7185615],"thread-7184520":["thread",7184520],"thread-7180356":["thread",7180356],"thread-7177761":["thread",7177761],"thread-7177554":["thread",7177554],"thread-7175455":["thread",7175455],"thread-7167540":["thread",7167540],"thread-7166519":["thread",7166519],"thread-7161883":["thread",7161883],"thread-7151814":["thread",7151814],"thread-7149348":["thread",7149348],"thread-7139773":["thread",7139773],"thread-7134641":["thread",7134641],"thread-7134466":["thread",7134466],"thread-7131418":["thread",7131418],"thread-7122333":["thread",7122333],"thread-7120666":["thread",7120666],"thread-7118429":["thread",7118429],"thread-7114736":["thread",7114736],"thread-7110875":["thread",7110875],"thread-7110227":["thread",7110227],"thread-7109944":["thread",7109944],"thread-7109726":["thread",7109726],"thread-7107016":["thread",7107016],"thread-7104014":["thread",7104014],"thread-7101121":["thread",7101121],"thread-7099077":["thread",7099077],"thread-7093659":["thread",7093659],"thread-7090030":["thread",7090030],"thread-7089023":["thread",7089023],"thread-7086900":["thread",7086900],"thread-7086794":["thread",7086794],"thread-7085123":["thread",7085123],"thread-7082596":["thread",7082596],"thread-7080331":["thread",7080331],"thread-7079582":["thread",7079582],"thread-7079260":["thread",7079260],"thread-7078823":["thread",7078823],"thread-7078232":["thread",7078232],"thread-7075610":["thread",7075610],"thread-7075505":["thread",7075505],"thread-7072466":["thread",7072466],"thread-7070719":["thread",7070719],"thread-7070287":["thread",7070287],"thread-7066208":["thread",7066208],"thread-7066082":["thread",7066082],"thread-7063240":["thread",7063240],"thread-7061727":["thread",7061727],"thread-7061090":["thread",7061090],"thread-7060986":["thread",7060986],"thread-7060182":["thread",7060182],"thread-7058864":["thread",7058864],"thread-7058381":["thread",7058381],"thread-7058209":["thread",7058209],"thread-7058173":["thread",7058173],"thread-7057638":["thread",7057638],"thread-7056449":["thread",7056449],"thread-7055980":["thread",7055980],"thread-7055277":["thread",7055277],"thread-7053458":["thread",7053458],"thread-7053159":["thread",7053159],"thread-7053149":["thread",7053149],"thread-7051799":["thread",7051799],"thread-7051798":["thread",7051798],"thread-7050904":["thread",7050904],"thread-7050411":["thread",7050411],"thread-7049437":["thread",7049437],"thread-7033654":["thread",7033654],"thread-7033459":["thread",7033459],"thread-7029929":["thread",7029929],"thread-6994373":["thread",6994373],"thread-6981701":["thread",6981701],"thread-233100":["thread",233100],"thread-201533":["thread",201533],"thread-197000":["thread",197000],"thread-167219":["thread",167219],"thread-167147":["thread",167147],"thread-160773":["thread",160773],"thread-13831":["thread",13831],"thread-13803":["thread",13803],"thread-13683":["thread",13683],"thread-13466":["thread",13466],"thread-13243":["thread",13243],"thread-13234":["thread",13234],"thread-12936":["thread",12936],"thread-12672":["thread",12672],"thread-12091":["thread",12091],"thread-12059":["thread",12059],"thread-12054":["thread",12054],"thread-12053":["thread",12053],"thread-11878":["thread",11878],"thread-11582":["thread",11582],"thread-11441":["thread",11441],"thread-11339":["thread",11339],"thread-11274":["thread",11274],"thread-11053":["thread",11053],"thread-10835":["thread",10835],"thread-10591":["thread",10591],"thread-10256":["thread",10256],"thread-10250":["thread",10250],"thread-10160":["thread",10160],"thread-10085":["thread",10085],"thread-10067":["thread",10067],"thread-9849":["thread",9849],"thread-9703":["thread",9703],"thread-9676":["thread",9676],"thread-9571":["thread",9571],"thread-9511":["thread",9511],"thread-9434":["thread",9434],"thread-9365":["thread",9365],"thread-9073":["thread",9073],"thread-8972":["thread",8972],"thread-8859":["thread",8859],"thread-8771":["thread",8771],"thread-8450":["thread",8450],"thread-8446":["thread",8446],"thread-8445":["thread",8445],"thread-8430":["thread",8430],"thread-8239":["thread",8239],"thread-8237":["thread",8237],"thread-8181":["thread",8181],"thread-8143":["thread",8143],"thread-8123":["thread",8123],"thread-7683":["thread",7683],"thread-7659":["thread",7659],"thread-7584":["thread",7584],"thread-7388":["thread",7388],"thread-7107":["thread",7107],"thread-6938":["thread",6938],"thread-6933":["thread",6933],"thread-6919":["thread",6919],"thread-6794":["thread",6794],"thread-6702":["thread",6702],"thread-6609":["thread",6609],"thread-6162":["thread",6162],"thread-6090":["thread",6090],"thread-5767":["thread",5767],"thread-5632":["thread",5632],"thread-5525":["thread",5525],"thread-5374":["thread",5374],"thread-5113":["thread",5113],"thread-4923":["thread",4923],"thread-4875":["thread",4875],"thread-4779":["thread",4779],"thread-4358":["thread",4358],"thread-4312":["thread",4312],"thread-4285":["thread",4285],"thread-4246":["thread",4246],"thread-4082":["thread",4082],"thread-4019":["thread",4019],"thread-4010":["thread",4010],"thread-3855":["thread",3855],"thread-3586":["thread",3586],"thread-3264":["thread",3264],"thread-3030":["thread",3030],"thread-2919":["thread",2919],"thread-2905":["thread",2905],"thread-2838":["thread",2838],"thread-2810":["thread",2810],"thread-2760":["thread",2760],"thread-2363":["thread",2363],"thread-2324":["thread",2324],"thread-2273":["thread",2273],"thread-2136":["thread",2136],"thread-2124":["thread",2124],"thread-2102":["thread",2102],"thread-2093":["thread",2093],"thread-2090":["thread",2090],"thread-2089":["thread",2089],"thread-1963":["thread",1963],"thread-1955":["thread",1955],"thread-1900":["thread",1900],"thread-1861":["thread",1861],"thread-1811":["thread",1811],"thread-1674":["thread",1674],"thread-1550":["thread",1550],"thread-1386":["thread",1386],"thread-1373":["thread",1373],"thread-1305":["thread",1305],"thread-1267":["thread",1267],"thread-607":["thread",607],"thread-595":["thread",595],"thread-579":["thread",579],"thread-552":["thread",552],"thread-444":["thread",444]}, NULL, 1714885933
Run Time: 0.001867
- 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