Where can I see my most played songs on Spotify?

There's no full play count list in the app, which surprises a lot of people. What you do get: tap your profile picture and go to your profile, and it shows your top artists and top tracks for the last month (only you can see those). Then there's Wrapped at the end of the year. If you want your whole history, go to your account's privacy settings on the Spotify website and request your data, ticking the extended streaming history option. It comes as files you can open in a spreadsheet and sort by track. It isn't instant though, it can take a couple of weeks to arrive by email.