https://dev.futures-infinityaws.com/v1/promo/current-promotions

Method
GET
HTTP Status
200
IP
130.176.185.137
Profiled on
Token
0c534e

Query Metrics

30 Database Queries
5 Different statements
187.30 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 53.05 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"
]
View formatted query    View runnable query    Explain query
2 0.86 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"
]
View formatted query    View runnable query    Explain query
3 4.29 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"
]
View formatted query    View runnable query    Explain query
4 9.39 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: 
[
  "digital"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
5 12.22 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: 
[
  "gold_full"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
6 1.44 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
]
View formatted query    View runnable query    Explain query
7 12.04 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: 
[
  "premium"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
8 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: 
[
  "premium"
  "world"
  "EUR"
  6
]
View formatted query    View runnable query    Explain query
9 8.24 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: 
[
  "premium"
  "world"
  "EUR"
  12
]
View formatted query    View runnable query    Explain query
10 8.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: 
[
  "silver_full"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
11 10.76 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-plus"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
12 2.61 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
]
View formatted query    View runnable query    Explain query
13 4.33 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
]
View formatted query    View runnable query    Explain query
14 5.67 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
]
View formatted query    View runnable query    Explain query
15 7.13 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
]
View formatted query    View runnable query    Explain query
16 5.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-program"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
17 7.05 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-program"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
18 1.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: 
[
  "ikigai-plus"
  "world"
  "EUR"
  1
]
View formatted query    View runnable query    Explain query
19 7.56 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
]
View formatted query    View runnable query    Explain query
20 1.17 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
]
View formatted query    View runnable query    Explain query
21 0.83 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
]
View formatted query    View runnable query    Explain query
22 0.77 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
]
View formatted query    View runnable query    Explain query
23 0.75 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
]
View formatted query    View runnable query    Explain query
24 0.65 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: 
[
  "ambassador"
  "asian"
  "EUR"
  12
]
View formatted query    View runnable query    Explain query
25 7.51 ms 
UPDATE app_product_price SET first_price = 6000, subscription_price = 6000 WHERE product_id = :productId AND currency_id = 4 AND nb_month = :nbMonth AND market_id IN (2,3) ;
Parameters: 
[
  "productId" => 10
  "nbMonth" => 12
]
View formatted query    View runnable query    Explain query
26 4.62 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: 
[
  "ambassador"
  "world"
  "EUR"
  12
]
View formatted query    View runnable query    Explain query
27 3.78 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.image AS image_4, t0.residual AS residual_5, t0.saving_bonus_amount AS saving_bonus_amount_6, t0.level AS level_7, t0.min_direct_clients AS min_direct_clients_8, t0.representative_client AS representative_client_9, t0.min_direct_points AS min_direct_points_10, t0.min_left_points AS min_left_points_11, t0.min_right_points AS min_right_points_12, t0.is_in_progression AS is_in_progression_13 FROM mybiz_rank t0 ORDER BY t0.level ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
28 0.56 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: 
[
  "futures_infinity"
]
View formatted query    View runnable query    Explain query
29 2.83 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"
]
View formatted query    View runnable query    Explain query
30 0.44 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: 
[
  "mybiz"
]
View formatted query    View runnable query    Explain query

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.

Entities Mapping

Class Mapping errors
App\Entity\Parameter No errors.
App\Entity\Space No errors.
App\Entity\User No errors.
App\Entity\Application No errors.
App\Entity\ApplicationVersion No errors.
App\Entity\Futures\FeatureType No errors.
App\Entity\ShopPurchase No errors.
App\Entity\Product No errors.
App\Entity\Member No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\ProductPrice No errors.
App\Entity\Market No errors.
App\Entity\Currency No errors.
App\Entity\Mybiz\MemberNode No errors.
App\Entity\Mybiz\Rank No errors.
App\Entity\Subscription No errors.
App\Entity\Academy No errors.
App\Entity\Mybiz\AmbassadorInvoice No errors.
App\Entity\MemberDocument No errors.