Django查询优化–prefetch_related
prefetch_related使用案例
class A(BaseModel):
bu = models.ForeignKey(Bu, on_delete=models.PROTECT, related_name='bu_tpmbase', db_constraint=False, verbose_name='BU', help_text='BU')
....
class B(models.Model):
tpm_base=models.ForeignKey(TpmBaseInfo,on_delete=models.PROTECT,related_name='B_A ase',db_constraint=False, verbose_name='xxx',help_text='xxxx')
a = A.objects.prefetch_related('B_A').filter()
print(a[0].tpmwip_tpmbase.all()[0].cur_station) # 维修
代码段中A,B表关联,在反向查询时使用prefetch_related,prefetch_related中的参数为related_name或者字段名+_set
eg:
从A表中反向查询,查询到某一条数据a后使用关联的名字(_set/related_name)在查询另一表中的内容