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 (7218956, 7216926, 7212982, 7204795, 7186956, 7183094, 7180945, 7175455, 7174615, 7174313, 7169005, 7165763, 7165250, 7163042, 7157323, 7156923, 7156010, 7155306, 7155305, 7154548, 7154529, 7151305, 7131249, 7130604, 7123736, 7117398, 7116123, 7112933, 7109191, 7107618, 7100964, 7100919, 7098484, 7096518, 7094504, 7093289, 7085405, 7084507, 7068764, 7066085, 7057221, 7055898, 7052163, 7051810, 7051660, 7047063, 7040111, 7040010, 7023315, 7017061, 7011199, 6989134, 202882, 201060, 199577, 191235, 181165, 165993, 13730, 13703, 13648, 13570, 13527, 13318, 12778, 12764, 12624, 12580, 12428, 12402, 12370, 12328, 12033, 12005, 11856, 11658, 11624, 11336, 11163, 11119, 11092, 10976, 10971, 10899, 10888, 10858, 10625, 9993, 9739, 9612, 9604, 9410, 9298, 9252, 9160, 8937, 8916, 8830, 8757, 8623, 8615, 8472, 8458, 8275, 8272, 8083, 8069, 7999, 7966, 7873, 7822, 7717, 7689, 7359, 7350, 7304, 7269, 7210, 7144, 7094, 6731, 6654, 6388, 6354, 6056, 6013, 5925, 5891, 5817, 5811, 5515, 5470, 5295, 4976, 4845, 4798, 4755, 4682, 4649, 4497, 4464, 4422, 4400, 4368, 4306, 4246, 4193, 3927, 3846, 3765, 3671, 3624, 3618, 3610, 3446, 3132, 2859, 2785, 2735, 2724, 2641, 2569, 2567, 2469, 2434, 2321, 2316, 2264, 2058, 1634, 1570, 1499, 1407, 1396, 977, 780, 698, 653, 453, 340, 227))
Run Time: 0.007998
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 181 | 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: 170, 0, 1716111048, {"thread-7218956":["thread",7218956],"thread-7216926":["thread",7216926],"thread-7212982":["thread",7212982],"thread-7204795":["thread",7204795],"thread-7186956":["thread",7186956],"thread-7183094":["thread",7183094],"thread-7180945":["thread",7180945],"thread-7175455":["thread",7175455],"thread-7174615":["thread",7174615],"thread-7174313":["thread",7174313],"thread-7169005":["thread",7169005],"thread-7165763":["thread",7165763],"thread-7165250":["thread",7165250],"thread-7163042":["thread",7163042],"thread-7157323":["thread",7157323],"thread-7156923":["thread",7156923],"thread-7156010":["thread",7156010],"thread-7155306":["thread",7155306],"thread-7155305":["thread",7155305],"thread-7154548":["thread",7154548],"thread-7154529":["thread",7154529],"thread-7151305":["thread",7151305],"thread-7131249":["thread",7131249],"thread-7130604":["thread",7130604],"thread-7123736":["thread",7123736],"thread-7117398":["thread",7117398],"thread-7116123":["thread",7116123],"thread-7112933":["thread",7112933],"thread-7109191":["thread",7109191],"thread-7107618":["thread",7107618],"thread-7100964":["thread",7100964],"thread-7100919":["thread",7100919],"thread-7098484":["thread",7098484],"thread-7096518":["thread",7096518],"thread-7094504":["thread",7094504],"thread-7093289":["thread",7093289],"thread-7085405":["thread",7085405],"thread-7084507":["thread",7084507],"thread-7068764":["thread",7068764],"thread-7066085":["thread",7066085],"thread-7057221":["thread",7057221],"thread-7055898":["thread",7055898],"thread-7052163":["thread",7052163],"thread-7051810":["thread",7051810],"thread-7051660":["thread",7051660],"thread-7047063":["thread",7047063],"thread-7040111":["thread",7040111],"thread-7040010":["thread",7040010],"thread-7023315":["thread",7023315],"thread-7017061":["thread",7017061],"thread-7011199":["thread",7011199],"thread-6989134":["thread",6989134],"thread-202882":["thread",202882],"thread-201060":["thread",201060],"thread-199577":["thread",199577],"thread-191235":["thread",191235],"thread-181165":["thread",181165],"thread-165993":["thread",165993],"thread-13730":["thread",13730],"thread-13703":["thread",13703],"thread-13648":["thread",13648],"thread-13570":["thread",13570],"thread-13527":["thread",13527],"thread-13318":["thread",13318],"thread-12778":["thread",12778],"thread-12764":["thread",12764],"thread-12624":["thread",12624],"thread-12580":["thread",12580],"thread-12428":["thread",12428],"thread-12402":["thread",12402],"thread-12370":["thread",12370],"thread-12328":["thread",12328],"thread-12033":["thread",12033],"thread-12005":["thread",12005],"thread-11856":["thread",11856],"thread-11658":["thread",11658],"thread-11624":["thread",11624],"thread-11336":["thread",11336],"thread-11163":["thread",11163],"thread-11119":["thread",11119],"thread-11092":["thread",11092],"thread-10976":["thread",10976],"thread-10971":["thread",10971],"thread-10899":["thread",10899],"thread-10888":["thread",10888],"thread-10858":["thread",10858],"thread-10625":["thread",10625],"thread-9993":["thread",9993],"thread-9739":["thread",9739],"thread-9612":["thread",9612],"thread-9604":["thread",9604],"thread-9410":["thread",9410],"thread-9298":["thread",9298],"thread-9252":["thread",9252],"thread-9160":["thread",9160],"thread-8937":["thread",8937],"thread-8916":["thread",8916],"thread-8830":["thread",8830],"thread-8757":["thread",8757],"thread-8623":["thread",8623],"thread-8615":["thread",8615],"thread-8472":["thread",8472],"thread-8458":["thread",8458],"thread-8275":["thread",8275],"thread-8272":["thread",8272],"thread-8083":["thread",8083],"thread-8069":["thread",8069],"thread-7999":["thread",7999],"thread-7966":["thread",7966],"thread-7873":["thread",7873],"thread-7822":["thread",7822],"thread-7717":["thread",7717],"thread-7689":["thread",7689],"thread-7359":["thread",7359],"thread-7350":["thread",7350],"thread-7304":["thread",7304],"thread-7269":["thread",7269],"thread-7210":["thread",7210],"thread-7144":["thread",7144],"thread-7094":["thread",7094],"thread-6731":["thread",6731],"thread-6654":["thread",6654],"thread-6388":["thread",6388],"thread-6354":["thread",6354],"thread-6056":["thread",6056],"thread-6013":["thread",6013],"thread-5925":["thread",5925],"thread-5891":["thread",5891],"thread-5817":["thread",5817],"thread-5811":["thread",5811],"thread-5515":["thread",5515],"thread-5470":["thread",5470],"thread-5295":["thread",5295],"thread-4976":["thread",4976],"thread-4845":["thread",4845],"thread-4798":["thread",4798],"thread-4755":["thread",4755],"thread-4682":["thread",4682],"thread-4649":["thread",4649],"thread-4497":["thread",4497],"thread-4464":["thread",4464],"thread-4422":["thread",4422],"thread-4400":["thread",4400],"thread-4368":["thread",4368],"thread-4306":["thread",4306],"thread-4246":["thread",4246],"thread-4193":["thread",4193],"thread-3927":["thread",3927],"thread-3846":["thread",3846],"thread-3765":["thread",3765],"thread-3671":["thread",3671],"thread-3624":["thread",3624],"thread-3618":["thread",3618],"thread-3610":["thread",3610],"thread-3446":["thread",3446],"thread-3132":["thread",3132],"thread-2859":["thread",2859],"thread-2785":["thread",2785],"thread-2735":["thread",2735],"thread-2724":["thread",2724],"thread-2641":["thread",2641],"thread-2569":["thread",2569],"thread-2567":["thread",2567],"thread-2469":["thread",2469],"thread-2434":["thread",2434],"thread-2321":["thread",2321],"thread-2316":["thread",2316],"thread-2264":["thread",2264],"thread-2058":["thread",2058],"thread-1634":["thread",1634],"thread-1570":["thread",1570],"thread-1499":["thread",1499],"thread-1407":["thread",1407],"thread-1396":["thread",1396],"thread-977":["thread",977],"thread-780":["thread",780],"thread-698":["thread",698],"thread-653":["thread",653],"thread-453":["thread",453],"thread-340":["thread",340],"thread-227":["thread",227]}, NULL, 1716107448
Run Time: 0.000627
- 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