云函数优化：查询所有数据并返回结果

exports.main = async (event, context) => {\n const db = cloud.database();\n const yddata = db.collection('yddata');\n const pageSize = 1000; // 定义每页显示的数据数量\n const startIndex = 0; // 定义起始索引值\n let query = yddata.where({});\n\n const startDate = event.startDate.split('-').join('.') + ' 0:0:0';\n const endDate = event.startDate.split('-').join('.') + ' 0:0:0';\n \n if (event.mailNumber) {\n query = query.where({ mailNumber: event.mailNumber });\n const searchData = await query.orderBy('date', 'desc').skip(startIndex).limit(pageSize).get().then(res => {\n if (res.data.length > 0) {\n const data = res.data[0];\n return {\n searchData: data\n // mailNumber:data.mailNumber,\n // images: data.images,\n // describe: data.describe,\n // date: data.date\n };\n } else {\n return {\n error: '未找到相关数据'\n };\n }\n }).catch(err => {\n console.error(err);\n return {\n error: err\n };\n });\n return searchData;\n }else {\n query = query.where({\n date: db.command.gte(startDate).and(db.command.lte(endDate))\n });\n const searchData = await query.orderBy('date', 'desc').skip(startIndex).limit(pageSize).get().then(res => {\n if (res.data.length > 0) {\n const data = res.data;\n return {\n searchData: data\n // mailNumber:data.mailNumber,\n // images: data.images,\n // describe: data.describe,\n // date: data.date\n };\n } else {\n return {\n error: '未找到相关数据'\n };\n }\n }).catch(err => {\n console.error(err);\n return {\n error: err\n };\n });\n return searchData;\n }\n }