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 (7210394, 7174311, 7170774, 7165934, 7159498, 7159046, 7151012, 7118144, 7117077, 7117067, 7113761, 7113284, 7111005, 7110021, 7097539, 7083229, 7071229, 7051667, 7050356, 7041803, 7022319, 7003819, 6996719, 6962288, 6956655, 6849152, 6841382, 6763846, 6761793, 6656267, 6517092, 6322458, 6279873, 6266664, 6266315, 230087, 218908, 217894, 213546, 206054, 205591, 194007, 192278, 191576, 190296, 188983, 188982, 186685, 181341, 177034, 175680, 170455, 166384, 161854, 161853, 160877, 160295, 159410, 13812, 13739, 13711, 13670, 13666, 13573, 13451, 13379, 13350, 13316, 13240, 13126, 13027, 12960, 12796, 12704, 12679, 12678, 12584, 12538, 12504, 12478, 12469, 12462, 12430, 12268, 12072, 12064, 12044, 11700, 11694, 11636, 11633, 11626, 11300, 11234, 11176, 11127, 11091, 11056, 11009, 10915, 10869, 10814, 10804, 10727, 10654, 10570, 10509, 10489, 10436, 10434, 10417, 10217, 10182, 10002, 9910, 9907, 9811, 9759, 9651, 9620, 9565, 9519, 9495, 9414, 9369, 9356, 9059, 9040, 9015, 8793, 8606, 8551, 8528, 8422, 8356, 8300, 8284, 8126, 8097, 7952, 7923, 7867, 7843, 7813, 7735, 7701, 7423, 7414, 7358, 7220, 7214, 7076, 7040, 7006, 6992, 6939, 6768, 6674, 6508, 6369, 6365, 6349, 6327, 6204, 6046, 5984, 5978, 5972, 5934, 5922, 5849, 5806, 5790, 5787, 5785, 5723, 5717, 5633, 5535, 5434, 5400, 5126, 5115, 5045, 4922, 4839, 4770, 4696, 4541, 4535, 4517, 4494, 4490, 4456, 4405, 4369, 4329, 4300, 4291, 4202))
Run Time: 0.011091
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: 116, 0, 1715089047, {"thread-7210394":["thread",7210394],"thread-7174311":["thread",7174311],"thread-7170774":["thread",7170774],"thread-7165934":["thread",7165934],"thread-7159498":["thread",7159498],"thread-7159046":["thread",7159046],"thread-7151012":["thread",7151012],"thread-7118144":["thread",7118144],"thread-7117077":["thread",7117077],"thread-7117067":["thread",7117067],"thread-7113761":["thread",7113761],"thread-7113284":["thread",7113284],"thread-7111005":["thread",7111005],"thread-7110021":["thread",7110021],"thread-7097539":["thread",7097539],"thread-7083229":["thread",7083229],"thread-7071229":["thread",7071229],"thread-7051667":["thread",7051667],"thread-7050356":["thread",7050356],"thread-7041803":["thread",7041803],"thread-7022319":["thread",7022319],"thread-7003819":["thread",7003819],"thread-6996719":["thread",6996719],"thread-6962288":["thread",6962288],"thread-6956655":["thread",6956655],"thread-6849152":["thread",6849152],"thread-6841382":["thread",6841382],"thread-6761793":["thread",6761793],"thread-6656267":["thread",6656267],"thread-6517092":["thread",6517092],"thread-6322458":["thread",6322458],"thread-6279873":["thread",6279873],"thread-6266664":["thread",6266664],"thread-6266315":["thread",6266315],"thread-230087":["thread",230087],"thread-218908":["thread",218908],"thread-217894":["thread",217894],"thread-213546":["thread",213546],"thread-206054":["thread",206054],"thread-205591":["thread",205591],"thread-194007":["thread",194007],"thread-192278":["thread",192278],"thread-191576":["thread",191576],"thread-190296":["thread",190296],"thread-188983":["thread",188983],"thread-188982":["thread",188982],"thread-186685":["thread",186685],"thread-181341":["thread",181341],"thread-177034":["thread",177034],"thread-175680":["thread",175680],"thread-170455":["thread",170455],"thread-166384":["thread",166384],"thread-161854":["thread",161854],"thread-161853":["thread",161853],"thread-160877":["thread",160877],"thread-160295":["thread",160295],"thread-13812":["thread",13812],"thread-13739":["thread",13739],"thread-13711":["thread",13711],"thread-13670":["thread",13670],"thread-13666":["thread",13666],"thread-13573":["thread",13573],"thread-13451":["thread",13451],"thread-13379":["thread",13379],"thread-13350":["thread",13350],"thread-13316":["thread",13316],"thread-13240":["thread",13240],"thread-13126":["thread",13126],"thread-13027":["thread",13027],"thread-12960":["thread",12960],"thread-12796":["thread",12796],"thread-12704":["thread",12704],"thread-12679":["thread",12679],"thread-12678":["thread",12678],"thread-12584":["thread",12584],"thread-12538":["thread",12538],"thread-12504":["thread",12504],"thread-12478":["thread",12478],"thread-12469":["thread",12469],"thread-12462":["thread",12462],"thread-12430":["thread",12430],"thread-12268":["thread",12268],"thread-12072":["thread",12072],"thread-12064":["thread",12064],"thread-12044":["thread",12044],"thread-11700":["thread",11700],"thread-11694":["thread",11694],"thread-11636":["thread",11636],"thread-11633":["thread",11633],"thread-11626":["thread",11626],"thread-11300":["thread",11300],"thread-11234":["thread",11234],"thread-11176":["thread",11176],"thread-11127":["thread",11127],"thread-11091":["thread",11091],"thread-11056":["thread",11056],"thread-11009":["thread",11009],"thread-10915":["thread",10915],"thread-10869":["thread",10869],"thread-10814":["thread",10814],"thread-10804":["thread",10804],"thread-10727":["thread",10727],"thread-10654":["thread",10654],"thread-10570":["thread",10570],"thread-10509":["thread",10509],"thread-10489":["thread",10489],"thread-10436":["thread",10436],"thread-10434":["thread",10434],"thread-10417":["thread",10417],"thread-10217":["thread",10217],"thread-10182":["thread",10182],"thread-10002":["thread",10002],"thread-9910":["thread",9910],"thread-9907":["thread",9907],"thread-9811":["thread",9811],"thread-9759":["thread",9759],"thread-9651":["thread",9651],"thread-9620":["thread",9620],"thread-9565":["thread",9565],"thread-9519":["thread",9519],"thread-9495":["thread",9495],"thread-9414":["thread",9414],"thread-9369":["thread",9369],"thread-9356":["thread",9356],"thread-9059":["thread",9059],"thread-9040":["thread",9040],"thread-9015":["thread",9015],"thread-8793":["thread",8793],"thread-8606":["thread",8606],"thread-8551":["thread",8551],"thread-8528":["thread",8528],"thread-8422":["thread",8422],"thread-8356":["thread",8356],"thread-8300":["thread",8300],"thread-8284":["thread",8284],"thread-8126":["thread",8126],"thread-8097":["thread",8097],"thread-7952":["thread",7952],"thread-7923":["thread",7923],"thread-7867":["thread",7867],"thread-7843":["thread",7843],"thread-7813":["thread",7813],"thread-7735":["thread",7735],"thread-7701":["thread",7701],"thread-7423":["thread",7423],"thread-7414":["thread",7414],"thread-7358":["thread",7358],"thread-7220":["thread",7220],"thread-7214":["thread",7214],"thread-7076":["thread",7076],"thread-7040":["thread",7040],"thread-7006":["thread",7006],"thread-6992":["thread",6992],"thread-6939":["thread",6939],"thread-6768":["thread",6768],"thread-6674":["thread",6674],"thread-6508":["thread",6508],"thread-6369":["thread",6369],"thread-6365":["thread",6365],"thread-6349":["thread",6349],"thread-6327":["thread",6327],"thread-6204":["thread",6204],"thread-6046":["thread",6046],"thread-5984":["thread",5984],"thread-5978":["thread",5978],"thread-5972":["thread",5972],"thread-5934":["thread",5934],"thread-5922":["thread",5922],"thread-5849":["thread",5849],"thread-5806":["thread",5806],"thread-5790":["thread",5790],"thread-5787":["thread",5787],"thread-5785":["thread",5785],"thread-5723":["thread",5723],"thread-5717":["thread",5717],"thread-5633":["thread",5633],"thread-5535":["thread",5535],"thread-5434":["thread",5434],"thread-5400":["thread",5400],"thread-5126":["thread",5126],"thread-5115":["thread",5115],"thread-5045":["thread",5045],"thread-4922":["thread",4922],"thread-4839":["thread",4839],"thread-4770":["thread",4770],"thread-4696":["thread",4696],"thread-4541":["thread",4541],"thread-4535":["thread",4535],"thread-4517":["thread",4517],"thread-4494":["thread",4494],"thread-4490":["thread",4490],"thread-4456":["thread",4456],"thread-4405":["thread",4405],"thread-4369":["thread",4369],"thread-4329":["thread",4329],"thread-4300":["thread",4300],"thread-4291":["thread",4291],"thread-4202":["thread",4202]}, NULL, 1715085447
Run Time: 0.000526
- 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