Issue:
fix(list): improve querying time for payments list

Quick Fix.
Currently payment list is giving intermittent 5xx. After analyzing logs we got to knwo that it is happening for the count query
That query need to be called always and we can skip this in most of the cases.

Also add the logs around count.

This can be a temporary help, till will move to more durable solution.

Resolution:
<think>
PR Context:
- Title: fix(payments_list): skip count query if no filters and add logging
- Merged: 2024-10-17T10:51:43Z
- Files changed: 9 files
- Commits: 7 commits

Implementation approach:
## Type of Change
<!-- Put an `x` in the boxes that apply -->

- [x] Bugfix
- [ ] New feature
- [x] Enhancement
- [ ] Refactoring
- [ ] Dependency updates
- [ ] Documentation
- [ ] CI/CD

## Description
- Skip count query if no filters are applied for attempts, in this we don't need to filter attempts as count of active attempt ids will be the total count.
- Profile id filter is already getting applied in intents, so removing it from last active attempts.
- Add logging around count
</think>

To implement this, you'll need to modify:


**Detailed Implementation:**


**Commit 1:** fix(payments_list): skip count query if no filters and add logging (#6331)
Files to modify:


**crates/api_models/src/payments.rs**
  Add:
    - function: pub::has_no_attempt_filters
    - impl: impl PaymentListFilterConstraints

**crates/diesel_models/src/query/payment_attempt.rs**
  Modify existing code

**crates/hyperswitch_domain_models/src/payments/payment_attempt.rs**
  Modify existing code

**crates/router/src/core/payments.rs**
  Modify existing code

**crates/router/src/db/kafka_store.rs**
  Modify existing code

**crates/router/src/routes/metrics.rs**
  Modify existing code

**crates/router/src/routes/payments.rs**
  Modify existing code

**crates/storage_impl/src/mock_db/payment_attempt.rs**
  Modify existing code

**crates/storage_impl/src/payments/payment_attempt.rs**
  Modify existing code