Huh, you're right. I thought it only kept record of the last visit to any URL, because that's what it shows in the GUI, but the DB does have prior records... It's weird how they went through the trouble of hiding entries in the GUI.
What do you mean with hiding? There is a whole submenu for history, with multiple different interfaces for navigating the history. For me it's right under bookmarks in the app-menu/burger-menu, or in the sidebar.
If you're on site foo, then go to bar, then baz, then bar again. The history GUI, whether the sidebar or the history manager (Ctrl-Shift-h), is not going to show foo, bar, baz, bar. It's going to show foo, baz, bar. The first time you went to bar is hidden. It's present in the DB, but no part of the GUI AFAICT is going to mention a visit to bar between visits to foo and baz.