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 (7216884, 7215975, 7215850, 7214596, 7207929, 7206256, 7202714, 7202606, 7201715, 7200597, 7200111, 7196579, 7194191, 7193961, 7193801, 7193300, 7192535, 7192447, 7191089, 7190298, 7189637, 7189451, 7188938, 7187921, 7184565, 7183714, 7183444, 7180956, 7180077, 7179604, 7179407, 7177021, 7176628, 7175076, 7174845, 7174454, 7174453, 7174117, 7167769, 7165607, 7164410, 7155783, 7154370, 7151762, 7149777, 7146286, 7145863, 7139863, 7134014, 7133257, 7130651, 7126269, 7119528, 7116539, 7112762, 7112561, 7110570, 7103568, 7102821, 7102393, 7102339, 7102167, 7101203, 7100275, 7094887, 7093240, 7091804, 7091387, 7090002, 7087094, 7085978, 7085596, 7083990, 7080466, 7080127, 7078065, 7077200, 7077187, 7065018, 7063427, 7062156, 7062053, 7059359, 7057610, 7050207, 7048818, 7009451, 7008558, 7008235, 7006975, 6999592, 6996778, 6992081, 6991455, 6986688, 6983150, 6981734, 6978816, 6969653, 6960439, 6842009, 234077, 217894, 199223, 195636, 176752, 13671, 13007, 12499, 12256, 11820, 9261, 9236, 9135, 8979, 8887, 8534, 8508, 7597, 7464, 6961, 6492, 5906, 5747, 5584, 5293, 4772, 3399, 3174, 2446, 1815, 1431, 409))
Run Time: 0.007652
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 133 | 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: 456, 0, 1714659285, {"thread-7216884":["thread",7216884],"thread-7215975":["thread",7215975],"thread-7215850":["thread",7215850],"thread-7214596":["thread",7214596],"thread-7207929":["thread",7207929],"thread-7206256":["thread",7206256],"thread-7202714":["thread",7202714],"thread-7202606":["thread",7202606],"thread-7201715":["thread",7201715],"thread-7200597":["thread",7200597],"thread-7200111":["thread",7200111],"thread-7196579":["thread",7196579],"thread-7194191":["thread",7194191],"thread-7193961":["thread",7193961],"thread-7193801":["thread",7193801],"thread-7193300":["thread",7193300],"thread-7192535":["thread",7192535],"thread-7192447":["thread",7192447],"thread-7191089":["thread",7191089],"thread-7190298":["thread",7190298],"thread-7189637":["thread",7189637],"thread-7189451":["thread",7189451],"thread-7188938":["thread",7188938],"thread-7187921":["thread",7187921],"thread-7184565":["thread",7184565],"thread-7183714":["thread",7183714],"thread-7183444":["thread",7183444],"thread-7180956":["thread",7180956],"thread-7180077":["thread",7180077],"thread-7179604":["thread",7179604],"thread-7179407":["thread",7179407],"thread-7177021":["thread",7177021],"thread-7176628":["thread",7176628],"thread-7175076":["thread",7175076],"thread-7174845":["thread",7174845],"thread-7174454":["thread",7174454],"thread-7174453":["thread",7174453],"thread-7174117":["thread",7174117],"thread-7167769":["thread",7167769],"thread-7165607":["thread",7165607],"thread-7164410":["thread",7164410],"thread-7155783":["thread",7155783],"thread-7154370":["thread",7154370],"thread-7151762":["thread",7151762],"thread-7149777":["thread",7149777],"thread-7146286":["thread",7146286],"thread-7145863":["thread",7145863],"thread-7139863":["thread",7139863],"thread-7134014":["thread",7134014],"thread-7133257":["thread",7133257],"thread-7130651":["thread",7130651],"thread-7126269":["thread",7126269],"thread-7119528":["thread",7119528],"thread-7116539":["thread",7116539],"thread-7112762":["thread",7112762],"thread-7112561":["thread",7112561],"thread-7110570":["thread",7110570],"thread-7103568":["thread",7103568],"thread-7102821":["thread",7102821],"thread-7102393":["thread",7102393],"thread-7102339":["thread",7102339],"thread-7102167":["thread",7102167],"thread-7101203":["thread",7101203],"thread-7100275":["thread",7100275],"thread-7094887":["thread",7094887],"thread-7093240":["thread",7093240],"thread-7091804":["thread",7091804],"thread-7091387":["thread",7091387],"thread-7090002":["thread",7090002],"thread-7087094":["thread",7087094],"thread-7085978":["thread",7085978],"thread-7085596":["thread",7085596],"thread-7083990":["thread",7083990],"thread-7080466":["thread",7080466],"thread-7080127":["thread",7080127],"thread-7078065":["thread",7078065],"thread-7077200":["thread",7077200],"thread-7077187":["thread",7077187],"thread-7065018":["thread",7065018],"thread-7063427":["thread",7063427],"thread-7062156":["thread",7062156],"thread-7062053":["thread",7062053],"thread-7059359":["thread",7059359],"thread-7057610":["thread",7057610],"thread-7050207":["thread",7050207],"thread-7048818":["thread",7048818],"thread-7009451":["thread",7009451],"thread-7008558":["thread",7008558],"thread-7008235":["thread",7008235],"thread-7006975":["thread",7006975],"thread-6999592":["thread",6999592],"thread-6996778":["thread",6996778],"thread-6992081":["thread",6992081],"thread-6991455":["thread",6991455],"thread-6986688":["thread",6986688],"thread-6983150":["thread",6983150],"thread-6981734":["thread",6981734],"thread-6978816":["thread",6978816],"thread-6969653":["thread",6969653],"thread-6960439":["thread",6960439],"thread-6842009":["thread",6842009],"thread-234077":["thread",234077],"thread-217894":["thread",217894],"thread-199223":["thread",199223],"thread-195636":["thread",195636],"thread-176752":["thread",176752],"thread-13671":["thread",13671],"thread-13007":["thread",13007],"thread-12499":["thread",12499],"thread-12256":["thread",12256],"thread-11820":["thread",11820],"thread-9261":["thread",9261],"thread-9236":["thread",9236],"thread-9135":["thread",9135],"thread-8979":["thread",8979],"thread-8887":["thread",8887],"thread-8534":["thread",8534],"thread-8508":["thread",8508],"thread-7597":["thread",7597],"thread-7464":["thread",7464],"thread-6961":["thread",6961],"thread-6492":["thread",6492],"thread-5906":["thread",5906],"thread-5747":["thread",5747],"thread-5584":["thread",5584],"thread-5293":["thread",5293],"thread-4772":["thread",4772],"thread-3399":["thread",3399],"thread-3174":["thread",3174],"thread-2446":["thread",2446],"thread-1815":["thread",1815],"thread-1431":["thread",1431],"thread-409":["thread",409]}, NULL, 1714655685
Run Time: 0.000602
- 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