Fixing slow query

export async function getStatusChecks(urlId: string) {
  console.time("getStatusChecks");

  const millisInDay = 1000 * 60 * 60 * 24;
  const result = await prisma.statusChecks.findMany({
    where: {
      urlId: { equals: urlId },
      createdAt: { gte: new Date(Date.now() - 4 * millisInDay) },
    },
    orderBy: {
      createdAt: "asc",
    },
    take: 50,
  });

  console.timeEnd("getStatusChecks");
  return result;
}

export async function getStatusChecks(urlId: string) {
  console.time("getStatusChecks");

  const millisInDay = 1000 * 60 * 60 * 24;
  const result = await prisma.statusChecks.findMany({
    where: {
      urlId: { equals: urlId },
      createdAt: { gte: new Date(Date.now() - 4 * millisInDay) },
    },
    orderBy: {
      createdAt: "asc",
    },
    take: 50,
  });

  console.timeEnd("getStatusChecks");
  return result;
}

model statusChecks {
  id            String   @id @default(cuid())
  createdAt     DateTime @default(now()) @db.Timestamp(0)
  bodySize      Int?
  effectiveUrl  String   @db.VarChar(4096)
  errorCode     String?
  httpCode      Int?
  httpCodeLang  String?
  redirectCount Int?
  totalTime     Decimal
  status        Boolean
  urlId         String   @db.VarChar(25)
  urls          urls     @relation(fields: [urlId], references: [id], onDelete: Cascade)
}

model statusChecks {
  id            String   @id @default(cuid())
  createdAt     DateTime @default(now()) @db.Timestamp(0)
  bodySize      Int?
  effectiveUrl  String   @db.VarChar(4096)
  errorCode     String?
  httpCode      Int?
  httpCodeLang  String?
  redirectCount Int?
  totalTime     Decimal
  status        Boolean
  urlId         String   @db.VarChar(25)
  urls          urls     @relation(fields: [urlId], references: [id], onDelete: Cascade)
}