#計算7天內銷量，并把每件商品的不同尺碼庫存分別顯示day7=today-datetime.timedelta(days=7)logs7=db.session.execute("SELECTproduct_name,goods_id,sum(number)assellsumFROMsdb_sell_logswherecreatetime>:createtimegroupbygoods_idorderbysum(number)desclimit0,20",{"createtime":datetime_timestamp(day7.strftime("%Y-%m-%d00:00:00"))}).fetchall()goods_store7={}foriteminlogs7:store=db.session.execute("SELECTpdt_desc,storefromsdb_productswheregoods_id=:goods_id",{"goods_id":item.goods_id}).fetchall()item_store=[]forstore_iteminstore:item_store.append([store_item.pdt_desc,store_item.store])goods_store7[item.goods_id]=item_store這段代碼要怎么優化請問？感覺這個foriteminlogs7:的循環里要處理N次的select效率好低下。