Query Metrics
2
Database Queries
2
Different statements
2.39 ms
Query time
0
Invalid entities
3
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.26 ms (52.80%) |
1 |
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"
]
|
||||||||||||||||||||||||||||||
|
1.13 ms (47.20%) |
1 |
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. |