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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.89 ms
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"
]
2 0.74 ms
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"
]
3 0.76 ms
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"
]
4 0.98 ms
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
]
5 0.90 ms
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
]
6 5.05 ms
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
]
7 4.58 ms
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 4.53 ms
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
]
9 4.48 ms
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
]
10 1.79 ms
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"
]
11 0.91 ms
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:
[
  "collagenbeauty"
  "world"
  "EUR"
  1
]
12 4.47 ms
UPDATE app_product_price SET first_price = 0, subscription_price = 0, subscription_commission = 20 WHERE product_id = ?;
Parameters:
[
  51
]
13 4.71 ms
UPDATE app_product_point SET first_points = 65, subscription_points = 65 WHERE product_id = ?;
Parameters:
[
  51
]
14 2.06 ms
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:
[
  "collagencare"
  "world"
  "EUR"
  1
]
15 0.97 ms
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:
[
  "detox"
  "world"
  "EUR"
  1
]
16 1.01 ms
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:
[
  "performance"
  "world"
  "EUR"
  1
]
17 1.02 ms
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:
[
  "slimfit"
  "world"
  "EUR"
  1
]
18 1.01 ms
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:
[
  "glass-glow"
  "world"
  "EUR"
  1
]
19 4.64 ms
UPDATE app_product_price SET subscription_commission = 12 WHERE product_id = ?;
Parameters:
[
  53
]
20 4.75 ms
UPDATE app_product_point SET first_points = 35, subscription_points = 35 WHERE product_id = ?;
Parameters:
[
  53
]
21 2.08 ms
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
]
22 1.10 ms
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:
[
  "collagenbeauty"
  "world"
  "EUR"
  1
]
23 0.91 ms
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:
[
  "glass-glow"
  "world"
  "EUR"
  1
]
24 1.00 ms
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:
[
  "hairfusion-program"
  "world"
  "EUR"
  1
]
25 1.08 ms
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
]
26 3.87 ms
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
]
27 3.72 ms
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
]
28 3.69 ms
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
]
29 3.90 ms
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
]
30 1.15 ms
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:
[
  "ikigai"
  "world"
  "EUR"
  1
]
31 1.09 ms
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:
[
  "detox"
  "world"
  "EUR"
  1
]
32 1.11 ms
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:
[
  "bioti-boost"
  "world"
  "EUR"
  1
]
33 1.00 ms
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:
[
  "konjaa-control"
  "world"
  "EUR"
  1
]
34 0.99 ms
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:
[
  "mind-focuus"
  "world"
  "EUR"
  1
]
35 0.96 ms
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:
[
  "neeo-slim"
  "world"
  "EUR"
  1
]
36 0.93 ms
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:
[
  "puure-burn"
  "world"
  "EUR"
  1
]
37 0.94 ms
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:
[
  "relaax-me"
  "world"
  "EUR"
  1
]
38 0.90 ms
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:
[
  "vita-boost"
  "world"
  "EUR"
  1
]
39 0.79 ms
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:
[
  "detox-program"
  "world"
  "EUR"
  1
]
40 0.78 ms
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:
[
  "hairfusion-program"
  "world"
  "EUR"
  1
]
41 4.67 ms
UPDATE app_product_price SET first_price = 32997, subscription_price = 32997, subscription_commission = 50 WHERE product_id = ?;
Parameters:
[
  34
]
42 4.66 ms
UPDATE app_product_point SET first_points = 135, subscription_points = 135 WHERE product_id = ?;
Parameters:
[
  34
]
43 2.07 ms
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:
[
  "performance-program"
  "world"
  "EUR"
  1
]
44 0.84 ms
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"
  "asian"
  "EUR"
  12
]
45 0.92 ms
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
]

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