11.79 ms (55.66%)
|
1 |
SELECT a0_.id AS id_0, a0_.uid AS uid_1, a0_.description AS description_2, a0_.action AS action_3, a0_.entry AS entry_4, a0_.tp AS tp_5, a0_.tp2 AS tp2_6, a0_.tp3 AS tp3_7, a0_.sl AS sl_8, a0_.trading_view_link AS trading_view_link_9, a0_.trading_view_screenshot AS trading_view_screenshot_10, a0_.status AS status_11, a0_.created_at AS created_at_12, a0_.reached_at AS reached_at_13, a0_.telegram_message_id AS telegram_message_id_14, a0_.trade_currency_id AS trade_currency_id_15, a0_.creator_id AS creator_id_16, a0_.area_id AS area_id_17 FROM area_analyze a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id INNER JOIN formation_service f2_ ON a1_.formation_service_id = f2_.id INNER JOIN formation f3_ ON f2_.formation_id = f3_.id WHERE a0_.area_id IN (?, ?, ?) AND f3_.name = ? ORDER BY a0_.created_at DESC LIMIT 2
Parameters: [
1
5
10
"trading"
]
SELECT a0_.id AS id_0, a0_.uid AS uid_1, a0_.description AS description_2, a0_.action AS action_3, a0_.entry AS entry_4, a0_.tp AS tp_5, a0_.tp2 AS tp2_6, a0_.tp3 AS tp3_7, a0_.sl AS sl_8, a0_.trading_view_link AS trading_view_link_9, a0_.trading_view_screenshot AS trading_view_screenshot_10, a0_.status AS status_11, a0_.created_at AS created_at_12, a0_.reached_at AS reached_at_13, a0_.telegram_message_id AS telegram_message_id_14, a0_.trade_currency_id AS trade_currency_id_15, a0_.creator_id AS creator_id_16, a0_.area_id AS area_id_17 FROM area_analyze a0_ INNER JOIN area a1_ ON a0_.area_id = a1_.id INNER JOIN formation_service f2_ ON a1_.formation_service_id = f2_.id INNER JOIN formation f3_ ON f2_.formation_id = f3_.id WHERE a0_.area_id IN (1, 5, 10) AND f3_.name = 'trading' ORDER BY a0_.created_at DESC LIMIT 2;
|
1.80 ms (8.47%)
|
1 |
SELECT u0_.id AS id_0, u0_.uid AS uid_1, u0_.name AS name_2, u0_.marketing_name AS marketing_name_3, u0_.locale AS locale_4, u0_.is_enabled AS is_enabled_5, u0_.formation_service_id AS formation_service_id_6 FROM university_academy u0_ INNER JOIN formation_service f1_ ON u0_.formation_service_id = f1_.id INNER JOIN formation f2_ ON f1_.formation_id = f2_.id WHERE f2_.id = ? AND u0_.is_enabled = ? AND u0_.locale = ? LIMIT 1
SELECT u0_.id AS id_0, u0_.uid AS uid_1, u0_.name AS name_2, u0_.marketing_name AS marketing_name_3, u0_.locale AS locale_4, u0_.is_enabled AS is_enabled_5, u0_.formation_service_id AS formation_service_id_6 FROM university_academy u0_ INNER JOIN formation_service f1_ ON u0_.formation_service_id = f1_.id INNER JOIN formation f2_ ON f1_.formation_id = f2_.id WHERE f2_.id = 1 AND u0_.is_enabled = 1 AND u0_.locale = 'fr' LIMIT 1;
|
1.70 ms (8.00%)
|
2 |
SELECT t0.id AS id_1, t0.label AS label_2, t0.is_enabled AS is_enabled_3, t0.`precision` AS precision_4, t0.is_predictable AS is_predictable_5, t0.currency_from AS currency_from_6, t0.currency_to AS currency_to_7, t0.threshold AS threshold_8, t0.is_only_for_long_subscriptions AS is_only_for_long_subscriptions_9, t0.risk_ratio AS risk_ratio_10, t0.area_id AS area_id_11, t0.trade_market_id AS trade_market_id_12 FROM trade_currency t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.label AS label_2, t0.is_enabled AS is_enabled_3, t0.`precision` AS precision_4, t0.is_predictable AS is_predictable_5, t0.currency_from AS currency_from_6, t0.currency_to AS currency_to_7, t0.threshold AS threshold_8, t0.is_only_for_long_subscriptions AS is_only_for_long_subscriptions_9, t0.risk_ratio AS risk_ratio_10, t0.area_id AS area_id_11, t0.trade_market_id AS trade_market_id_12 FROM trade_currency t0 WHERE t0.id = 40;
|
1.39 ms (6.54%)
|
1 |
SELECT a0_.id AS id_0, a0_.uid AS uid_1, a0_.name AS name_2, a0_.marketing_name AS marketing_name_3, a0_.image AS image_4, a0_.description AS description_5, a0_.color AS color_6, a0_.is_enabled AS is_enabled_7, a0_.is_on_futures_app AS is_on_futures_app_8, a0_.trader_email AS trader_email_9, a0_.master_account_id AS master_account_id_10, a0_.telegram_chat_id AS telegram_chat_id_11, a0_.telegram_bot_token AS telegram_bot_token_12, a0_.formation_service_id AS formation_service_id_13 FROM area a0_ WHERE a0_.name IN (?, ?, ?, ?, ?, ?, ?, ?, ?) AND a0_.is_enabled = 1 AND a0_.is_on_futures_app = 1 AND a0_.master_account_id IS NOT NULL
Parameters: [
"fx-one"
"fx-two"
"x-area"
"mp-indices"
"360-area"
"delta-area"
"pulse-area"
"infinity-area"
"equity"
]
SELECT a0_.id AS id_0, a0_.uid AS uid_1, a0_.name AS name_2, a0_.marketing_name AS marketing_name_3, a0_.image AS image_4, a0_.description AS description_5, a0_.color AS color_6, a0_.is_enabled AS is_enabled_7, a0_.is_on_futures_app AS is_on_futures_app_8, a0_.trader_email AS trader_email_9, a0_.master_account_id AS master_account_id_10, a0_.telegram_chat_id AS telegram_chat_id_11, a0_.telegram_bot_token AS telegram_bot_token_12, a0_.formation_service_id AS formation_service_id_13 FROM area a0_ WHERE a0_.name IN ('fx-one', 'fx-two', 'x-area', 'mp-indices', '360-area', 'delta-area', 'pulse-area', 'infinity-area', 'equity') AND a0_.is_enabled = 1 AND a0_.is_on_futures_app = 1 AND a0_.master_account_id IS NOT NULL;
|
1.30 ms (6.15%)
|
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.mybiz_id AS mybiz_id_6, t0.roles AS roles_7, t0.formations AS formations_8, t0.is_biz_partner AS is_biz_partner_9, t0.futures_pack AS futures_pack_10, t0.market AS market_11, t0.discord_id AS discord_id_12, t0.password AS password_13, t0.jwt_token AS jwt_token_14, t0.preferred_language AS preferred_language_15, t0.step_elite AS step_elite_16, t17.id AS id_18, t17.has_university_interest AS has_university_interest_19, t17.has_tv_interest AS has_tv_interest_20, t17.has_area_interest AS has_area_interest_21, t17.has_book_interest AS has_book_interest_22, t17.level AS level_23, t17.is_over AS is_over_24, t17.skipped_until AS skipped_until_25, t17.has_already_skipped AS has_already_skipped_26, t17.user_id AS user_id_27, t28.id AS id_29, t28.option_status AS option_status_30, t28.reject_reason_key AS reject_reason_key_31, t28.meta_trader_status AS meta_trader_status_32, t28.option AS option_33, t28.broker_name AS broker_name_34, t28.is_meta_trader_id_validated AS is_meta_trader_id_validated_35, t28.user_fullname AS user_fullname_36, t28.meta_trader_id AS meta_trader_id_37, t28.meta_trader_password AS meta_trader_password_38, t28.meta_trader_server AS meta_trader_server_39, t28.meta_trader_bat AS meta_trader_bat_40, t28.linked_areas AS linked_areas_41, t28.user_id AS user_id_42 FROM user t0 LEFT JOIN on_boarding t17 ON t17.user_id = t0.id LEFT JOIN user_link t28 ON t28.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.mybiz_id AS mybiz_id_6, t0.roles AS roles_7, t0.formations AS formations_8, t0.is_biz_partner AS is_biz_partner_9, t0.futures_pack AS futures_pack_10, t0.market AS market_11, t0.discord_id AS discord_id_12, t0.password AS password_13, t0.jwt_token AS jwt_token_14, t0.preferred_language AS preferred_language_15, t0.step_elite AS step_elite_16, t17.id AS id_18, t17.has_university_interest AS has_university_interest_19, t17.has_tv_interest AS has_tv_interest_20, t17.has_area_interest AS has_area_interest_21, t17.has_book_interest AS has_book_interest_22, t17.level AS level_23, t17.is_over AS is_over_24, t17.skipped_until AS skipped_until_25, t17.has_already_skipped AS has_already_skipped_26, t17.user_id AS user_id_27, t28.id AS id_29, t28.option_status AS option_status_30, t28.reject_reason_key AS reject_reason_key_31, t28.meta_trader_status AS meta_trader_status_32, t28.option AS option_33, t28.broker_name AS broker_name_34, t28.is_meta_trader_id_validated AS is_meta_trader_id_validated_35, t28.user_fullname AS user_fullname_36, t28.meta_trader_id AS meta_trader_id_37, t28.meta_trader_password AS meta_trader_password_38, t28.meta_trader_server AS meta_trader_server_39, t28.meta_trader_bat AS meta_trader_bat_40, t28.linked_areas AS linked_areas_41, t28.user_id AS user_id_42 FROM user t0 LEFT JOIN on_boarding t17 ON t17.user_id = t0.id LEFT JOIN user_link t28 ON t28.user_id = t0.id WHERE t0.id = 1;
|
1.21 ms (5.73%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.is_enabled AS is_enabled_4, t0.color_code AS color_code_5, t0.formation_theme_id AS formation_theme_id_6 FROM formation t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"trading"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.is_enabled AS is_enabled_4, t0.color_code AS color_code_5, t0.formation_theme_id AS formation_theme_id_6 FROM formation t0 WHERE t0.name = 'trading' LIMIT 1;
|
1.15 ms (5.45%)
|
1 |
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 FROM parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters: [
"maintenance"
]
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 FROM parameter t0 WHERE t0.parameter_key = 'maintenance' LIMIT 1;
|
0.85 ms (3.99%)
|
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.is_enabled AS is_enabled_4, t0.color_code AS color_code_5 FROM formation_theme t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"finance"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.is_enabled AS is_enabled_4, t0.color_code AS color_code_5 FROM formation_theme t0 WHERE t0.name = 'finance' LIMIT 1;
|