Sunan an-Nasa'i, Book 12, Hadith 109 (Nasa'i 1139)

It was narrated from Abu Hurairah that:

The Messenger of Allah (ﷺ) said: "The closest that a person can be to his Lord, the Mighty and Sublime, is when he is prostrating, so increase in supplication then."