Query Metrics
1
Database Queries
1
Different statements
4.70 ms
Query time
0
Invalid entities
24
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4.70 ms |
SELECT s0_.id AS id_0, s0_.sort AS sort_1, s1_.id AS id_2, s1_.title AS title_3, s1_.description AS description_4, s1_.locale AS locale_5, s2_.id AS id_6, s2_.billing_type AS billing_type_7, s2_.price_excluding_vat AS price_excluding_vat_8, s2_.sort AS sort_9, s3_.id AS id_10, s3_.sort AS sort_11, s4_.id AS id_12, s4_.sort AS sort_13, s4_.title AS title_14, s4_.locale AS locale_15, s1_.translatable_id AS translatable_id_16, s2_.subscription_plan_id AS subscription_plan_id_17, s3_.subscription_plan_id AS subscription_plan_id_18, s4_.translatable_id AS translatable_id_19 FROM subscription_plan s0_ LEFT JOIN subscription_plan_translation s1_ ON s0_.id = s1_.translatable_id AND (s1_.locale = ?) LEFT JOIN subscription_plan_price s2_ ON s0_.id = s2_.subscription_plan_id LEFT JOIN subscription_plan_argument s3_ ON s0_.id = s3_.subscription_plan_id LEFT JOIN subscription_plan_argument_translation s4_ ON s3_.id = s4_.translatable_id AND (s4_.locale = ?) ORDER BY s2_.sort ASC, s3_.sort ASC
Parameters:
[ "fr" "fr" ]
|
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\SubscriptionPlanPrice | 6 |
| App\Entity\Subscription\SubscriptionPlanArgument | 6 |
| App\Entity\Subscription\SubscriptionPlanArgumentTranslation | 6 |
| App\Entity\Subscription\SubscriptionPlan | 3 |
| App\Entity\Subscription\SubscriptionPlanTranslation | 3 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Subscription\SubscriptionPlan | No errors. |
| App\Entity\Subscription\SubscriptionPlanTranslation | No errors. |
| App\Entity\Subscription\SubscriptionPlanPrice | No errors. |
| App\Entity\Subscription\SubscriptionPlanArgument | No errors. |
| App\Entity\Subscription\SubscriptionPlanArgumentTranslation | No errors. |