"A mature man of mid-40s, a police officer of some 26 years, commits these two offences — one would immediately question how that could be so," Mr Zillman said.

He said the answer was in the psychological report, because otherwise the behaviour was "quite bizarre".

Prosecutor Jodie Wooldridge said while police officers did confront some challenging situations, they had a responsibility to uphold the law.

"It remains highly relevant that the defendant committed the offences whilst on duty as a police officer, and in committing the offences has acted contrary to his sworn duty as a police officer to uphold the law," she said.

"To have acted as he did, and to have utilised his firearm and his handcuffs as he did, was an abuse of trust that had been placed in him by the Queensland Police Service and the community at large."

She said if an ordinary member of the community had acted like this, a fine would not be adequate.

No conviction was recorded.

Appeal already filed

Queensland Police Union solicitor Calvin Gnech said an appeal against the conviction had already been filed.

"He is relieved this part of the process is over but his main priority at the moment is his welfare," he said.

Mr Gnech said once the appeal process was finalised, Flanagan would face police disciplinary proceedings.