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 (7216113, 7215803, 7214437, 7204548, 7199334, 7190222, 7190100, 7187482, 7187161, 7184097, 7182482, 7181556, 7180879, 7178066, 7176158, 7174317, 7172895, 7171783, 7171433, 7170297, 7165259, 7163936, 7159321, 7155412, 7154769, 7152311, 7151397, 7142479, 7140965, 7140804, 7137876, 7136948, 7133306, 7133305, 7132241, 7131920, 7129520, 7116422, 7115142, 7114569, 7106837, 7106338, 7106009, 7103449, 7102616, 7097847, 7096641, 7092223, 7084545, 7082457, 7082413, 7082288, 7081434, 7071887, 7066207, 7065054, 7064089, 7059689, 7049657, 7048297, 7047869, 7047578, 7046184, 7042943, 7037807, 7031820, 7015703, 7010275, 7008277, 7007593, 7006991, 6999333, 6998843, 6997696, 6991020, 6987385, 6981993, 6980452, 6979013, 6966991, 6965475, 6389243, 6266315, 226463, 200682, 199928, 182710, 182477, 173025, 168100, 161951, 160917, 160429, 13822, 13715, 13633, 13621, 13495, 13462, 13244, 13096, 13021, 12851, 12706, 12665, 12602, 12601, 12502, 12483, 12421, 12300, 12205, 12115, 12004, 11784, 11634, 11525, 11472, 11334, 11268, 11267, 11072, 11015, 10938, 10865, 10341, 10192, 10053, 10023, 9922, 9853, 9818, 9798, 9732, 9666, 9590, 9447, 9230, 9161, 9118, 8926, 8833, 8817, 8689, 8309, 8300, 8207, 7857, 7731, 7549, 7343, 7247, 7213, 7166, 7124, 6968, 6887, 6810, 6800, 6738, 6559, 6396, 6367, 6317, 6218, 6184, 6172, 6068, 6009, 5922, 5873, 5829, 5518, 5503, 5474, 5400, 5226, 5142, 5013, 5000, 4967, 4830, 4761, 4693, 4642, 4615, 4545, 4469, 4448, 4442, 4385, 4289, 4261, 4229, 4079, 4059, 3859, 3844, 3693))
Run Time: 0.008367
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 392, 0, 1714859990, {"thread-7216113":["thread",7216113],"thread-7215803":["thread",7215803],"thread-7214437":["thread",7214437],"thread-7204548":["thread",7204548],"thread-7199334":["thread",7199334],"thread-7190222":["thread",7190222],"thread-7190100":["thread",7190100],"thread-7187482":["thread",7187482],"thread-7187161":["thread",7187161],"thread-7184097":["thread",7184097],"thread-7182482":["thread",7182482],"thread-7181556":["thread",7181556],"thread-7180879":["thread",7180879],"thread-7178066":["thread",7178066],"thread-7176158":["thread",7176158],"thread-7174317":["thread",7174317],"thread-7172895":["thread",7172895],"thread-7171783":["thread",7171783],"thread-7171433":["thread",7171433],"thread-7170297":["thread",7170297],"thread-7165259":["thread",7165259],"thread-7163936":["thread",7163936],"thread-7159321":["thread",7159321],"thread-7155412":["thread",7155412],"thread-7154769":["thread",7154769],"thread-7152311":["thread",7152311],"thread-7151397":["thread",7151397],"thread-7142479":["thread",7142479],"thread-7140965":["thread",7140965],"thread-7140804":["thread",7140804],"thread-7137876":["thread",7137876],"thread-7136948":["thread",7136948],"thread-7133306":["thread",7133306],"thread-7133305":["thread",7133305],"thread-7132241":["thread",7132241],"thread-7131920":["thread",7131920],"thread-7129520":["thread",7129520],"thread-7116422":["thread",7116422],"thread-7115142":["thread",7115142],"thread-7114569":["thread",7114569],"thread-7106837":["thread",7106837],"thread-7106338":["thread",7106338],"thread-7106009":["thread",7106009],"thread-7103449":["thread",7103449],"thread-7102616":["thread",7102616],"thread-7097847":["thread",7097847],"thread-7096641":["thread",7096641],"thread-7092223":["thread",7092223],"thread-7084545":["thread",7084545],"thread-7082457":["thread",7082457],"thread-7082413":["thread",7082413],"thread-7082288":["thread",7082288],"thread-7081434":["thread",7081434],"thread-7071887":["thread",7071887],"thread-7066207":["thread",7066207],"thread-7065054":["thread",7065054],"thread-7064089":["thread",7064089],"thread-7059689":["thread",7059689],"thread-7049657":["thread",7049657],"thread-7048297":["thread",7048297],"thread-7047869":["thread",7047869],"thread-7047578":["thread",7047578],"thread-7046184":["thread",7046184],"thread-7042943":["thread",7042943],"thread-7037807":["thread",7037807],"thread-7031820":["thread",7031820],"xfmg_media-3286":["xfmg_media",3286],"thread-7015703":["thread",7015703],"thread-7010275":["thread",7010275],"thread-7008277":["thread",7008277],"thread-7007593":["thread",7007593],"thread-7006991":["thread",7006991],"thread-6999333":["thread",6999333],"thread-6998843":["thread",6998843],"thread-6997696":["thread",6997696],"thread-6991020":["thread",6991020],"thread-6987385":["thread",6987385],"thread-6981993":["thread",6981993],"thread-6980452":["thread",6980452],"thread-6979013":["thread",6979013],"thread-6966991":["thread",6966991],"thread-6965475":["thread",6965475],"thread-6389243":["thread",6389243],"thread-6266315":["thread",6266315],"thread-226463":["thread",226463],"thread-200682":["thread",200682],"thread-199928":["thread",199928],"thread-182710":["thread",182710],"thread-182477":["thread",182477],"thread-173025":["thread",173025],"thread-168100":["thread",168100],"thread-161951":["thread",161951],"thread-160429":["thread",160429],"thread-13822":["thread",13822],"thread-13715":["thread",13715],"thread-13633":["thread",13633],"thread-13621":["thread",13621],"thread-13495":["thread",13495],"thread-13462":["thread",13462],"thread-13244":["thread",13244],"thread-13096":["thread",13096],"thread-13021":["thread",13021],"thread-12851":["thread",12851],"thread-12706":["thread",12706],"thread-12665":["thread",12665],"thread-12602":["thread",12602],"thread-12601":["thread",12601],"thread-12502":["thread",12502],"thread-12483":["thread",12483],"thread-12421":["thread",12421],"thread-12300":["thread",12300],"thread-12205":["thread",12205],"thread-12115":["thread",12115],"thread-12004":["thread",12004],"thread-11784":["thread",11784],"thread-11634":["thread",11634],"thread-11525":["thread",11525],"thread-11472":["thread",11472],"thread-11334":["thread",11334],"thread-11268":["thread",11268],"thread-11267":["thread",11267],"thread-11072":["thread",11072],"thread-11015":["thread",11015],"thread-10938":["thread",10938],"thread-10865":["thread",10865],"thread-10341":["thread",10341],"thread-10192":["thread",10192],"thread-10053":["thread",10053],"thread-10023":["thread",10023],"thread-9922":["thread",9922],"thread-9853":["thread",9853],"thread-9818":["thread",9818],"thread-9798":["thread",9798],"thread-9732":["thread",9732],"thread-9666":["thread",9666],"thread-9590":["thread",9590],"thread-9447":["thread",9447],"thread-9230":["thread",9230],"thread-9161":["thread",9161],"thread-9118":["thread",9118],"thread-8926":["thread",8926],"thread-8833":["thread",8833],"thread-8817":["thread",8817],"thread-8689":["thread",8689],"thread-8309":["thread",8309],"thread-8300":["thread",8300],"thread-8207":["thread",8207],"thread-7857":["thread",7857],"thread-7731":["thread",7731],"thread-7549":["thread",7549],"thread-7343":["thread",7343],"thread-7247":["thread",7247],"thread-7213":["thread",7213],"thread-7166":["thread",7166],"thread-7124":["thread",7124],"thread-6968":["thread",6968],"thread-6887":["thread",6887],"thread-6810":["thread",6810],"thread-6800":["thread",6800],"thread-6738":["thread",6738],"thread-6559":["thread",6559],"thread-6396":["thread",6396],"thread-6367":["thread",6367],"thread-6317":["thread",6317],"thread-6218":["thread",6218],"thread-6184":["thread",6184],"thread-6172":["thread",6172],"thread-6068":["thread",6068],"thread-6009":["thread",6009],"thread-5922":["thread",5922],"thread-5873":["thread",5873],"thread-5829":["thread",5829],"thread-5518":["thread",5518],"thread-5503":["thread",5503],"thread-5474":["thread",5474],"thread-5400":["thread",5400],"thread-5226":["thread",5226],"thread-5142":["thread",5142],"thread-5013":["thread",5013],"thread-5000":["thread",5000],"thread-4967":["thread",4967],"thread-4830":["thread",4830],"thread-4761":["thread",4761],"thread-4693":["thread",4693],"thread-4642":["thread",4642],"thread-4615":["thread",4615],"thread-4545":["thread",4545],"thread-4469":["thread",4469],"thread-4448":["thread",4448],"thread-4442":["thread",4442],"thread-4385":["thread",4385],"thread-4289":["thread",4289],"thread-4261":["thread",4261],"thread-4229":["thread",4229],"thread-4079":["thread",4079],"thread-4059":["thread",4059],"thread-3859":["thread",3859],"thread-3844":["thread",3844],"thread-3693":["thread",3693]}, NULL, 1714856390
Run Time: 0.001848
- 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