Optimize `/contracts/results` and `/contracts/results/logs` in v2 (0.113)

[xin-hedera]

Description:

This PR backports the changes to release/0.113

• Apply timestamp range limit to both /contracts/results and /contracts/results/logs
• Optimize get ethereum transactions by payer and timestamps to avoid all-shard query when pososible
• Return 200 instead of 404 when block not found

Related issue(s):

Related to #9244

Notes for reviewer:

Also cherry-picked the changes to fix 404 when block not found

Checklist

• [ ] Documented (Code comments, README, etc.)
• [x] Tested (unit, integration, etc.)

[sonarcloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud

[codecov[bot]]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 92.53%. Comparing base (4221fa8) to head (75dc19e). Report is 1 commits behind head on release/0.113.

Additional details and impacted files

```diff @@ Coverage Diff @@ ## release/0.113 #9377 +/- ## =================================================== + Coverage 92.52% 92.53% +0.01% Complexity 7012 7012 =================================================== Files 903 904 +1 Lines 29638 29660 +22 Branches 3738 3750 +12 =================================================== + Hits 27422 27447 +25 + Misses 1447 1444 -3 Partials 769 769 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.