Remove code hotspots tables

What does this MR do?

This MR removes unused Code Hotspot database tables and foreign keys. The tables are empty and the application code was already removed in the previous release.

Note: This is the first time we're using the with_lock_retries helper method.

I also fixed a few Duration casting bugs.

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content

Closes #198313 (closed)