Normally, sorting only affects the order of the result set, not the content of the result set.

If the data is not large, it is recommended to remove limit 1 and see if the total amount of data is correct.

I feel that there is a sort order that causes the results to be null for the first few, and the query tool does not show it.