GET https://dev.my-biz.pro/v1/promo/current-promotions

Query Metrics

45 Database Queries
14 Different statements
97.67 ms Query time
0 Invalid entities
0 Managed entities

Grouped Statements

Show all queries

Time Count Info
30.60 ms
(31.32%)
27
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:
[
  "license"
  "world"
  "EUR"
  12
]
9.88 ms
(10.11%)
2
UPDATE app_product_price SET first_price = 48700, subscription_price = 48700, subscription_commission = 167, commission_month1 = 100, commission_month2 = 33, commission_month3 = 33 WHERE product_id IN (?) and market_id IN (1);
Parameters:
[
  44
]
8.75 ms
(8.95%)
2
UPDATE app_product_price SET first_price = 24300, subscription_price = 24300, subscription_commission = 83, commission_month1 = 49, commission_month2 = 17, commission_month3 = 17 WHERE product_id IN (?) and market_id IN (2,3);
Parameters:
[
  44
]
8.37 ms
(8.57%)
2
UPDATE app_product_point SET first_points = 160, subscription_points = 160, points_month1 = 96, points_month2 = 32, points_month3 = 32 WHERE product_id IN (?) and market_id IN (2,3);
Parameters:
[
  44
]
8.02 ms
(8.21%)
2
UPDATE app_product_point SET first_points = 320, subscription_points = 320, points_month1 = 192, points_month2 = 64, points_month3 = 64 WHERE product_id IN (?) and market_id IN (1);
Parameters:
[
  44
]
5.14 ms
(5.26%)
1
UPDATE app_product_point SET first_points = 65, subscription_points = 65 WHERE product_id = ?;
Parameters:
[
  51
]
4.95 ms
(5.07%)
1
UPDATE app_product_price SET subscription_commission = 12 WHERE product_id = ?;
Parameters:
[
  53
]
4.62 ms
(4.73%)
1
UPDATE app_product_price SET first_price = 0, subscription_price = 0, subscription_commission = 20 WHERE product_id = ?;
Parameters:
[
  51
]
4.45 ms
(4.55%)
1
UPDATE app_product_point SET first_points = 35, subscription_points = 35 WHERE product_id = ?;
Parameters:
[
  53
]
4.41 ms
(4.52%)
1
UPDATE app_product_point SET first_points = 135, subscription_points = 135 WHERE product_id = ?;
Parameters:
[
  34
]
4.27 ms
(4.37%)
1
UPDATE app_product_price SET first_price = 32997, subscription_price = 32997, subscription_commission = 50 WHERE product_id = ?;
Parameters:
[
  34
]
1.99 ms
(2.03%)
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"
]
1.62 ms
(1.65%)
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.62 ms
(0.63%)
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