79429441

Date: 2025-02-11 09:22:28
Score: 3.5
Natty:
Report link

I found my problem. I was using SET @random_id = (SELECT id FROM logs ORDER BY RAND() LIMIT 1);

The ORDER BY RAND() caused the a full table scan to occur.

Reasons:
  • Low length (1):
  • No code block (0.5):
  • User mentioned (1): @random_id
  • Low reputation (1):
Posted by: Scrimpy