MySQL explain Analysis problem

Extra returned when analyzing explain of MySQL: Impossible WHERE noticed after reading const tables

because I used the primary key id query, but this primary key does not exist. But I don"t know if this will slow down the query. If it slows down the query, do any bosses know how to solve it?

Jun.17,2021

the line you queried does not exist, how can it slow down the query? Const should be fast


figure this situation will not slow down the query, if it is where name='xxx' and name does not have an index, type as ALL, causes a full table scan to slow down the query.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e50542-45082.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e50542-45082.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?