Hi, it appears to be due to the pain at the site while doing some prohibited movement, that is why you had such syncope
feeling, and when you stand up, the pressure is released and the feeling has gone.
Other possibility is the tramadol
, which in some people show vomiting
sensation, and giddy ness. Any how you are relieved of it. Thank you.