Statements which are traceable are listed here:

Tracing is supported for both INSERT and REPLACE statements using VALUES, VALUES ROW, or SELECT.

Traces of multi-table UPDATE and DELETE statements are supported.

Tracing of SET optimizer_trace is not supported.

For statements which are prepared and executed in separate steps, preparation and execution are traced separately.