sql性能优化

const res = await knex(SRC20_VALID_TABLE).whereIn('tx_hash', [params.tx_hash])
    const resArr = []
    for (let each of res) {
      const tickInfoArr = await knex(SRC20_TICK_TABLE).whereIn("id", [each.tick]);
      if (!tickInfoArr.length) {
        throw new Error("tick not found")
      }
      const dec = tickInfoArr[0].dec || 18
      resArr.push({
        op: each.op,
        tick: each.tick,
        max: toNonExponential(new Decimal(tickInfoArr[0].max).mul(new Decimal(10**dec))) || "18446744073709551615", // uint64_max
        lim: toNonExponential(new Decimal(tickInfoArr[0].lim).mul(new Decimal(10**dec))) || "18446744073709551615", // uint64_max
        amt: (each.op === 'deploy' ? 0 : toNonExponential(new Decimal(each.amt).mul(new Decimal(10**dec)))) || new Decimal(0), // 0
        dec: dec,
        from: each.sender || "",
        to: each.creator || "",
        valid: true,
        msg: "ok"
      })
    }