Sequelize中查询结果的双重计数

const { Sequelize, Model, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

// 定义模型
const User = sequelize.define('User', {
  name: DataTypes.STRING,
  age: DataTypes.INTEGER
});

// 查询数据并进行双重计数
async function getUsersWithCount() {
  const { count, rows } = await User.findAndCountAll({
    where: {
      age: { [Sequelize.Op.gt]: 18 } // 查询年龄大于18的用户
    },
    limit: 10, // 每页显示10条记录
    offset: 0 // 从第0条记录开始
  });

  console.log('总记录数:', count);
  console.log('查询结果:', rows);
}

getUsersWithCount();