Query Metrics
43
Database Queries
4
Different statements
24.97 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
23.07 ms (92.39%) |
39 |
SELECT a0_.id AS id_0, a0_.nb_month AS nb_month_1, a0_.first_price AS first_price_2, a0_.subscription_price AS subscription_price_3, a0_.first_commission AS first_commission_4, a0_.subscription_commission AS subscription_commission_5, a0_.commission_month1 AS commission_month1_6, a0_.commission_month2 AS commission_month2_7, a0_.commission_month3 AS commission_month3_8, a0_.copecart_product_id_with_first_price AS copecart_product_id_with_first_price_9, a0_.copecart_product_id_only_subscription AS copecart_product_id_only_subscription_10, a0_.is_enabled AS is_enabled_11, a0_.product_id AS product_id_12, a0_.currency_id AS currency_id_13, a0_.market_id AS market_id_14 FROM app_product_price a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id INNER JOIN app_market a2_ ON a0_.market_id = a2_.id INNER JOIN app_currency a3_ ON a0_.currency_id = a3_.id WHERE a1_.name = ? AND a2_.name = ? AND a3_.code = ? AND a0_.nb_month = ?
Parameters:
[ "package-digital-ecom" "world" "EUR" 1 ] |
|
0.90 ms (3.58%) |
2 |
SELECT t0.id AS id_1, t0.section AS section_2, t0.parameter_key AS parameter_key_3, t0.string_value AS string_value_4, t0.int_value AS int_value_5, t0.float_value AS float_value_6, t0.bool_value AS bool_value_7, t0.array_value AS array_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM app_parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
"app.maintenance.lock"
]
|
|
0.59 ms (2.37%) |
1 |
SELECT a0_.id AS id_0, a0_.point_config AS point_config_1, a0_.price_config AS price_config_2, a0_.commission_config AS commission_config_3, a0_.is_enabled AS is_enabled_4, a0_.copecart_product_id AS copecart_product_id_5, a0_.product_id AS product_id_6, a0_.market_id AS market_id_7 FROM app_product_decreasing a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id INNER JOIN app_market a2_ ON a0_.market_id = a2_.id WHERE a1_.name = ? AND a2_.name = ? LIMIT 1
Parameters:
[ "premium" "world" ] |
|
0.41 ms (1.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"luume"
]
|
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 |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Parameter\Parameter | No errors. |
| App\Entity\Space\Space | No errors. |
| App\Entity\Space\Application | No errors. |
| App\Entity\Service\FeatureType | No errors. |
| App\Entity\Payment\ShopPurchase | No errors. |
| App\Entity\Product\Product | No errors. |
| App\Entity\Member\Member | No errors. |
| App\Entity\Parameter\Notification | No errors. |
| App\Entity\Parameter\Document | No errors. |
| App\Entity\Product\ProductPrice | No errors. |
| App\Entity\Parameter\Market | No errors. |
| App\Entity\Parameter\Currency | No errors. |
| App\Entity\Product\ProductDecreasing | No errors. |