A SQL statement is not explainable if there is a user defined variable used in the statement. It should be easy to convert user defined variables to constants if explain is needed.
Explain example to reproduce the issue
The reason for this is that EXPLAIN is executed in a separate connection to not affect queries like "SELECT 1; SELECT FOUND_ROWS();".
I'm not sure about the right fix, replacing variables by constants may give wrong results.
Log in to post a comment.