GET https://dev.futureslearn.com/api/homepage/finance/blocks?formationName=trading

Query Metrics

9 Database Queries
8 Different statements
21.19 ms Query time
0 Invalid entities
18 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
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"
]
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
Parameters:
[
  1
  1
  "fr"
]
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 = ?
Parameters:
[
  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"
]
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 = ?
Parameters:
[
  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"
]
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"
]
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"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
import doctrine.dbal.import_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
App\Entity\Formation\Service\Area\Area 3
App\Entity\User\User 2
App\Entity\Formation\FormationService 2
App\Entity\Formation\Service\Area\Analyze\Analyze 2
App\Entity\Formation\Service\PredictAi\TradeCurrency 2
App\Entity\Parameter 1
App\Entity\User\OnBoarding 1
App\Entity\User\UserLink 1
App\Entity\Formation\FormationTheme 1
App\Entity\Formation\Formation 1
App\Entity\Formation\Service\University\UniversityAcademy 1
App\Entity\Formation\Service\PredictAi\TradeMarket 1