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 (7215368, 7214548, 7212344, 7211793, 7211432, 7210865, 7210612, 7209918, 7207314, 7206916, 7198317, 7197882, 7197041, 7195159, 7193249, 7193039, 7188993, 7187786, 7187561, 7184098, 7182509, 7182086, 7180632, 7177707, 7177648, 7177400, 7176687, 7176511, 7174538, 7170727, 7170053, 7163227, 7161169, 7158486, 7158108, 7155660, 7155593, 7154712, 7154171, 7153588, 7153227, 7152240, 7148526, 7146437, 7146171, 7145255, 7141559, 7140937, 7139728, 7139396, 7137848, 7137477, 7136552, 7132565, 7131923, 7130090, 7130089, 7129308, 7126251, 7125599, 7123728, 7120477, 7115272, 7112450, 7112305, 7111278, 7109839, 7098233, 7098195, 7095372, 7093240, 7092432, 7091964, 7091228, 7089896, 7088632, 7087022, 7081167, 7068776, 7068561, 7068532, 7068464, 7067316, 7065819, 7060447, 7059285, 7057383, 7055429, 7050563, 7050382, 7047317, 7037383, 7036529, 7036151, 7034809, 7033463, 7021479, 7014509, 7013886, 7002830, 6995892, 6993960, 6992964, 6984824, 6980399, 6977667, 6977282, 6972439, 6959567, 6673625, 222857, 217793, 209003, 13360, 11854, 5074))
Run Time: 0.007435
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 116 | 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: 4392, 0, 1714817431, {"thread-7215368":["thread",7215368],"thread-7214548":["thread",7214548],"thread-7212344":["thread",7212344],"thread-7211793":["thread",7211793],"thread-7211432":["thread",7211432],"thread-7210865":["thread",7210865],"thread-7210612":["thread",7210612],"thread-7209918":["thread",7209918],"thread-7207314":["thread",7207314],"thread-7206916":["thread",7206916],"thread-7198317":["thread",7198317],"thread-7197882":["thread",7197882],"thread-7197041":["thread",7197041],"thread-7195159":["thread",7195159],"thread-7193249":["thread",7193249],"thread-7193039":["thread",7193039],"thread-7188993":["thread",7188993],"thread-7187786":["thread",7187786],"thread-7187561":["thread",7187561],"thread-7184098":["thread",7184098],"thread-7182509":["thread",7182509],"thread-7182086":["thread",7182086],"thread-7180632":["thread",7180632],"thread-7177707":["thread",7177707],"thread-7177648":["thread",7177648],"thread-7177400":["thread",7177400],"thread-7176687":["thread",7176687],"thread-7176511":["thread",7176511],"thread-7174538":["thread",7174538],"thread-7170727":["thread",7170727],"thread-7170053":["thread",7170053],"thread-7163227":["thread",7163227],"thread-7161169":["thread",7161169],"thread-7158486":["thread",7158486],"thread-7158108":["thread",7158108],"thread-7155660":["thread",7155660],"thread-7155593":["thread",7155593],"thread-7154712":["thread",7154712],"thread-7154171":["thread",7154171],"thread-7153588":["thread",7153588],"thread-7153227":["thread",7153227],"thread-7152240":["thread",7152240],"thread-7148526":["thread",7148526],"thread-7146437":["thread",7146437],"thread-7146171":["thread",7146171],"thread-7145255":["thread",7145255],"thread-7141559":["thread",7141559],"thread-7140937":["thread",7140937],"thread-7139728":["thread",7139728],"thread-7139396":["thread",7139396],"thread-7137848":["thread",7137848],"thread-7137477":["thread",7137477],"thread-7136552":["thread",7136552],"thread-7132565":["thread",7132565],"thread-7131923":["thread",7131923],"thread-7130090":["thread",7130090],"thread-7130089":["thread",7130089],"thread-7129308":["thread",7129308],"thread-7126251":["thread",7126251],"thread-7125599":["thread",7125599],"thread-7123728":["thread",7123728],"thread-7120477":["thread",7120477],"thread-7115272":["thread",7115272],"thread-7112450":["thread",7112450],"thread-7112305":["thread",7112305],"thread-7111278":["thread",7111278],"thread-7109839":["thread",7109839],"thread-7098233":["thread",7098233],"thread-7098195":["thread",7098195],"thread-7095372":["thread",7095372],"thread-7093240":["thread",7093240],"thread-7092432":["thread",7092432],"thread-7091964":["thread",7091964],"thread-7091228":["thread",7091228],"thread-7089896":["thread",7089896],"thread-7088632":["thread",7088632],"thread-7087022":["thread",7087022],"thread-7081167":["thread",7081167],"thread-7068776":["thread",7068776],"thread-7068561":["thread",7068561],"thread-7068532":["thread",7068532],"thread-7068464":["thread",7068464],"thread-7067316":["thread",7067316],"thread-7065819":["thread",7065819],"thread-7060447":["thread",7060447],"thread-7059285":["thread",7059285],"thread-7057383":["thread",7057383],"thread-7055429":["thread",7055429],"thread-7050563":["thread",7050563],"thread-7050382":["thread",7050382],"thread-7047317":["thread",7047317],"thread-7037383":["thread",7037383],"thread-7036529":["thread",7036529],"thread-7036151":["thread",7036151],"thread-7034809":["thread",7034809],"thread-7033463":["thread",7033463],"thread-7021479":["thread",7021479],"thread-7014509":["thread",7014509],"thread-7013886":["thread",7013886],"thread-7002830":["thread",7002830],"thread-6995892":["thread",6995892],"thread-6993960":["thread",6993960],"thread-6992964":["thread",6992964],"thread-6984824":["thread",6984824],"thread-6980399":["thread",6980399],"thread-6977667":["thread",6977667],"thread-6977282":["thread",6977282],"thread-6972439":["thread",6972439],"thread-6959567":["thread",6959567],"thread-6673625":["thread",6673625],"thread-222857":["thread",222857],"thread-217793":["thread",217793],"thread-13360":["thread",13360],"thread-11854":["thread",11854],"thread-5074":["thread",5074]}, NULL, 1714813831
Run Time: 0.000399
- 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