Query Metrics
2
Database Queries
2
Different statements
0.97 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.65 ms |
SELECT s0_.id AS id_0, s0_.plan_type AS plan_type_1, s0_.billing_cycle AS billing_cycle_2, s0_.name AS name_3, s0_.price AS price_4, s0_.original_price AS original_price_5, s0_.is_popular AS is_popular_6, s0_.is_public AS is_public_7, s0_.is_promotion AS is_promotion_8, s0_.promotion_ends_at AS promotion_ends_at_9, s0_.is_active AS is_active_10, s0_.description AS description_11, s0_.sort_order AS sort_order_12, s0_.sms_limit AS sms_limit_13, s0_.email_limit AS email_limit_14, s0_.contacts_limit AS contacts_limit_15, s0_.projects_limit AS projects_limit_16, s0_.mailboxes_limit AS mailboxes_limit_17, s0_.contact_groups_limit AS contact_groups_limit_18, s0_.has_contacts_api AS has_contacts_api_19, s0_.has_sms_api AS has_sms_api_20, s0_.additional_sms_price AS additional_sms_price_21, s0_.additional_sms_discount AS additional_sms_discount_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24 FROM subscription_plan s0_ WHERE s0_.is_active = 1 AND s0_.plan_type IN (?, ?, ?, ?, ?) ORDER BY s0_.sort_order ASC, s0_.price ASC
Parameters:
[ "free" "lite" "starter" "marketing" "business" ] |
| 2 | 0.32 ms |
SELECT s0_.id AS id_0, s0_.plan_type AS plan_type_1, s0_.billing_cycle AS billing_cycle_2, s0_.name AS name_3, s0_.price AS price_4, s0_.original_price AS original_price_5, s0_.is_popular AS is_popular_6, s0_.is_public AS is_public_7, s0_.is_promotion AS is_promotion_8, s0_.promotion_ends_at AS promotion_ends_at_9, s0_.is_active AS is_active_10, s0_.description AS description_11, s0_.sort_order AS sort_order_12, s0_.sms_limit AS sms_limit_13, s0_.email_limit AS email_limit_14, s0_.contacts_limit AS contacts_limit_15, s0_.projects_limit AS projects_limit_16, s0_.mailboxes_limit AS mailboxes_limit_17, s0_.contact_groups_limit AS contact_groups_limit_18, s0_.has_contacts_api AS has_contacts_api_19, s0_.has_sms_api AS has_sms_api_20, s0_.additional_sms_price AS additional_sms_price_21, s0_.additional_sms_discount AS additional_sms_discount_22, s0_.created_at AS created_at_23, s0_.updated_at AS updated_at_24 FROM subscription_plan s0_ WHERE s0_.is_active = 1 AND s0_.plan_type IN (?) ORDER BY s0_.sort_order ASC, s0_.price ASC
Parameters:
[
"calendar"
]
|
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\Subscription\SubscriptionPlan | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Subscription\SubscriptionPlan | No errors. |
| App\Entity\Subscription\Subscription | No errors. |