Query Metrics
9
Database Queries
3
Different statements
5.89 ms
Query time
0
Invalid entities
12
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.37 ms (57.14%) |
6 |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t1.category FROM commerce_subscription_constant_area t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF24_PREMIUM"
]
|
|
1.42 ms (24.02%) |
2 |
SELECT t1.code AS code_2, t1.created_at AS created_at_3, t1.description AS description_4, t1.enable AS enable_5, t1.image AS image_6, t1.name AS name_7, t1.updated_at AS updated_at_8, t1.id AS id_9, t1.duration AS duration_10, t1.max_area AS max_area_11, t1.max_users AS max_users_12, t1.max_shares AS max_shares_13, t1.max_properties AS max_properties_14, t1.price_amount AS price_amount_15, t1.price_amount_including_tax AS price_amount_including_tax_16, t1.price_vat_rate AS price_vat_rate_17, t1.price_currency AS price_currency_18, t0.duration_extension AS duration_extension_19, t0.max_area_extension AS max_area_extension_20, t0.min_area AS min_area_21, t1.category FROM commerce_subscription_product t0 INNER JOIN commerce_product t1 ON t0.id = t1.id WHERE t1.code = ? LIMIT 1
Parameters:
[
"MF24_PREMIUM"
]
|
|
1.11 ms (18.84%) |
1 |
SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.description AS description_3, t0.enable AS enable_4, t0.image AS image_5, t0.name AS name_6, t0.updated_at AS updated_at_7, t0.id AS id_8, t0.min_area AS min_area_9, t0.max_area AS max_area_10, t0.price_amount AS price_amount_11, t0.price_amount_including_tax AS price_amount_including_tax_12, t0.price_vat_rate AS price_vat_rate_13, t0.price_currency AS price_currency_14 FROM commerce_subscription_area_range t0 INNER JOIN commerce_subscription_product_area_ranges ON t0.id = commerce_subscription_product_area_ranges.area_range_id WHERE commerce_subscription_product_area_ranges.product_id = ?
Parameters:
[
234
]
|
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\Commerce\AbstractMaForetProduct | 6 |
| App\Entity\Commerce\SubscriptionAreaRange | 6 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| Actiforest\CommerceBundle\Entity\AbstractProduct | No errors. |
| Actiforest\CommerceBundle\Entity\Embeddable\Price | No errors. |
| App\Entity\Commerce\AbstractMaForetProduct | No errors. |
| App\Entity\Commerce\ConstantAreaSubscription | No errors. |
| App\Entity\Commerce\VariableAreaSubscription | No errors. |
| App\Entity\Commerce\SubscriptionFeature | No errors. |
| App\Entity\Commerce\SubscriptionAreaRange | No errors. |
| Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken | No errors. |
| App\Entity\RefreshToken | No errors. |