I beg your pardon vs here you are

I beg your pardon

phrase
  • A phrase used to express an apology for an action. 

  • A phrase used to ask for clarification of something said if it is unexpected, odd or seen as rude without context. 

  • A phrase used to request something, for example if a statement was not heard. 

here you are

phrase
  • Said when handing something over to someone or doing a favour to them, usually to draw the recipient's attention to the exchange; equivalent to “thank you” when receiving something. 

How often have the words I beg your pardon and here you are occurred in a corpus of books? (source: Google Ngram Viewer )