Query Metrics
45
Database Queries
14
Different statements
95.40 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | 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 |
|---|
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. |