Here is an example XQuery to read both the values and the attributes.
😎

USE TEEST;
GO
SET NOCOUNT ON;

DECLARE @TXML XML...

Can you please post the XML rather than a picture of it!
😎

My suggestion is to add a covering no-clustered index and use Scott's query, that will reduce the effort to a single scan of the index without any sorting.
😎

We need lot more information here, no way of helping without is.
😎

Having no code, execution plan or anything substantial, my guess would be "Full Moon"😉