如何使用ActiveRecord按多个类别过滤产品？

class Product < ApplicationRecord
  # 假设 Product 模型已经定义好了
end

# 假设我们要找 category1 为 'Electronics', category2 为 'Gadgets', category3 为 'Smartphones' 的产品
products = Product.where(category1: 'Electronics', category2: 'Gadgets', category3: 'Smartphones')

products = Product.where("category1 = ? AND category2 = ? AND category3 = ?", 'Electronics', 'Gadgets', 'Smartphones')

# 假设有 Category 模型，并且 Product 与 Category 有多对多的关系
products = Product.joins(:categories).where(categories: { name: ['Electronics', 'Gadgets', 'Smartphones'] })

products = Product.where(category1: 'Electronics', category2: 'Gadgets', category3: 'Smartphones')
Rails.logger.debug(products.to_sql) # 输出查询语句到日志

# 添加索引
add_index :products, [:category1, :category2, :category3]

# 分页查询
products = Product.where(category1: 'Electronics', category2: 'Gadgets', category3: 'Smartphones').page(1).per(10)