MySQL managed one-shot prepared queries statement auto closing command should be sent before any pending commands in the queue

[BillyYccc]

Motivation:
Currently MySQL auto closing command is fired after the execution is completed, this works fine because in MySQL Client the pipeling limit is only 1 and it will be sent before other pending commands, however it might cause unexpected order issues in pipeling mode which we will support later.