MySQL Inner Join with IN clause

Question

Is this sentence optimized?

select d.id, d.wfid, d.docid , k.keyword, k.value from keywords k
inner join documents d 
where k.document_id in (23,24) AND k.document_id = d.id;

I have some ID's via POST (23,24) and I need to get the info for only them, so for that I do the IN. Here are hardcoded for testing purposes.

I know MySQL parses the sentences and generates a more optimized one. Is there a way to get that sentence so I avoid having mysql optimizing it all the time?

Thanks!

Answer 1

If you run these you n see how MySQL rewrite handle them. Note the SQL in the show warnings is not always valid SQL syntax

explain extended select d.id, d.wfid, d.docid , k.keyword, k.value from keywords k
inner join documents d 
where k.document_id in (23,24) AND k.document_id = d.id;
show warnings;