如下代码，我其中使用了多次读取数据库，并且获取到的数据在进行循环，循环后在进行数据库查询，最终resolve后，我得到的结果仅仅只是一小部分数据，还剩余一部分数据并未resolve，但是通过console.log可以打印出所有数据，resolv执行的时候，其实for循环还未执行完

getProducts(params) {
  return new Promise((resolve, reject) => {
    if (params) {
      this.getDb().then((db: SQLiteObject) => {
        db.transaction((run) => {
          var sql = 'SELECT * FROM product_content';
          run.executeSql(sql, [],
            (run, res) => {
              if (res.rows.length != 0) {
                let result = {
                   product_ids: {}
                };
                let retTmp = []
                let exTmp = [1,2,100,600,500,800,900,700,701,300]
                let categoryIds = []
                for (var i = 0; i < res.rows.length; i++) {
                  var product = res.rows.item(i);
                  categoryIds.push(product.categoryIds)
                  for (var k = 0; k < categoryIds.length; k++) {
                    var _cid = categoryIds[k]
                    sql = 'select id FROM product where category like "%,' + _cid + ',%"';
                    run.executeSql(sql, [],
                      (run, res_id) => {
                        if (res_id.rows.length != 0) {
                          for (var i = 0; i < res_id.rows.length; i++) {
                            var productId = res_id.rows.item(i).ID
                            retTmp.push(productId)
                          }
                        }
                      })
                  }
                }
                // setTimeout(() => {
                  let newRetTmp = Array.from(new Set(retTmp))
                  let newExTmp = Array.from(new Set())

                  if (newExTmp.length > 0) {
                    newRetTmp.map((rettmp, index) => {
                      exTmp.map(extmp => {
                        if (rettmp != extmp) {
                          result.product_ids[newRet] = true
                        }
                      })
                    })
                  }

                  resolve(result);
                // }, 500)
              } else {
                let result = {
                  data: {
                    product_ids: {}
                  }
                };
                resolve(result);
              }
            })
        })
      })
    }
  })
}

之前在网上看到使用Promise.all()的方法，我将其修改成如下代码,代码看上去没有什么问题，但是一到Promise.all的地方就一直没有resolve了：

getProducts(params) {
  return new Promise((resolve, reject) => {
    if (params) {
      this.getDb().then((db: SQLiteObject) => {
        db.transaction((run) => {
          var sql = 'SELECT * FROM product_content';
          run.executeSql(sql, [],
            (run, res) => {
              if (res.rows.length != 0) {
                let result = {
                    product_ids: {}
                };
                let retTmp = []
                let exTmp = [1,2,100,600,500,800,900,700,701,300]
                let categoryIds = []
                let promise = []
                for (var i = 0; i < res.rows.length; i++) {
promise.push(new Promise((resolve,reject)=>{
                  var product = res.rows.item(i);
                  categoryIds.push(product.categoryIds)
                  for (var k = 0; k < categoryIds.length; k++) {
                    var _cid = categoryIds[k]
                    sql = 'select id FROM product where category like "%,' + _cid + ',%"';
                    run.executeSql(sql, [],
                      (run, res_id) => {
                        if (res_id.rows.length != 0) {
                          for (var i = 0; i < res_id.rows.length; i++) {
                            var productId = res_id.rows.item(i).ID
                            retTmp.push(productId)
                            // this.helperService.console('c0', productId)
                          }
                        }
                      })
                  }
}))
                }
Promise.all(promise).then(res => {
              // setTimeout(() => {
                let ATmp = Array.from(new Set(retTmp))

                if (newExTmp.length > 0) {
                  exTmp.map((rettmp, index) => {
                    newExTmp.map(extmp => {
                      if (rettmp != extmp) {
                        result.product_ids[newRet] = true
                      }
                    })
                  })
                }
                resolve(result);
              // }, 500)
})
                
              } else {
                let result = {
                  data: {
                    product_ids: {}
                  }
                };
                resolve(result);
              }
            })
        })
      })
    }
  })
}

根据以上代码，都无法得到想要的结果，第二种方法更是一直处于pendding状态，真不知道该如何进行解决，望各位大神支招