POST https://saadmonitor.com/api/tenants/resolve

Query Metrics

2 Database Queries
2 Different statements
2.39 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 1.26 ms
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.name AS name_2, t0_.api_base_url AS api_base_url_3, t0_.domain AS domain_4, t0_.is_active AS is_active_5, t0_.plan AS plan_6, t0_.trial_ends_at AS trial_ends_at_7, t0_.paid_until AS paid_until_8, t0_.max_mobile_users AS max_mobile_users_9, t0_.email AS email_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12 FROM tenant t0_ WHERE LOWER(TRIM(t0_.code)) = ?
Parameters:
[
  "ngrok0275"
]
2 1.13 ms
SELECT t0_.id AS id_0, t0_.status AS status_1, t0_.starts_at AS starts_at_2, t0_.current_period_start AS current_period_start_3, t0_.current_period_end AS current_period_end_4, t0_.trial_ends_at AS trial_ends_at_5, t0_.cancel_at_period_end AS cancel_at_period_end_6, t0_.canceled_at AS canceled_at_7, t0_.quantity AS quantity_8, t0_.external_provider AS external_provider_9, t0_.external_subscription_id AS external_subscription_id_10, t0_.created_at AS created_at_11, t0_.updated_at AS updated_at_12, t0_.tenant_id AS tenant_id_13, t0_.plan_id AS plan_id_14 FROM tenant_subscription t0_ WHERE t0_.tenant_id = ? AND t0_.status IN (?, ?) AND t0_.current_period_end >= ? AND (t0_.canceled_at IS NULL OR t0_.canceled_at > ?) ORDER BY t0_.created_at DESC LIMIT 1
Parameters:
[
  2
  "ACTIVE"
  "TRIALING"
  "2026-05-01 11:30:46"
  "2026-05-01 11:30:46"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Tenant 1
App\Entity\TenantSubscription 1
App\Entity\Plan 1

Entities Mapping

Class Mapping errors
App\Entity\Tenant No errors.
App\Entity\TenantSubscription No errors.
App\Entity\Invoice No errors.
App\Entity\Plan No errors.
App\Entity\TenantSubscriptionEvent No errors.