https://dev.futures-infinityaws.com/v1/tv/planning

Query Metrics

68 Database Queries
13 Different statements
48.07 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
10.98 ms
(0.00%)
14
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.password AS password_5, t0.salt AS salt_6, t0.birthdate AS birthdate_7, t0.phone AS phone_8, t0.created_at AS created_at_9, t0.roles AS roles_10, t0.last_login_at AS last_login_at_11, t0.api_key AS api_key_12, t0.password_reset_token AS password_reset_token_13, t0.password_reset_token_expires_at AS password_reset_token_expires_at_14, t0.password_reset_token_emails_sent AS password_reset_token_emails_sent_15, t0.jwt_token AS jwt_token_16, t0.jwt_token_expiration AS jwt_token_expiration_17, t18.id AS id_19, t18.position AS position_20, t18.status AS status_21, t18.member_date AS member_date_22, t18.enabled AS enabled_23, t18.is_insider AS is_insider_24, t18.accept_offers AS accept_offers_25, t18.accept_terms_date AS accept_terms_date_26, t18.has_premium_deducted AS has_premium_deducted_27, t18.liberty_pack AS liberty_pack_28, t18.preferred_language AS preferred_language_29, t18.saving_bonus AS saving_bonus_30, t18.saving_bonus_reached_at AS saving_bonus_reached_at_31, t18.is_new AS is_new_32, t18.birthday AS birthday_33, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_34, t18.is_offered_sponsor AS is_offered_sponsor_35, t18.discord_id AS discord_id_36, t18.step_elite AS step_elite_37, t18.is_deleted AS is_deleted_38, t18.sponsor_id AS sponsor_id_39, t18.parent_id AS parent_id_40, t18.rank_id AS rank_id_41, t18.pack_id AS pack_id_42, t18.user_id AS user_id_43, t18.member_node_id AS member_node_id_44, t18.market_id AS market_id_45, t18.qualification_id AS qualification_id_46, t18.subscription_gateway_id AS subscription_gateway_id_47, t18.subscription_country_id AS subscription_country_id_48, t18.currency_id AS currency_id_49, t18.first_subscription_space_id AS first_subscription_space_id_50 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id INNER JOIN futures_event_educators ON t0.id = futures_event_educators.user_id WHERE futures_event_educators.futures_event_id = ?
Parameters:
[
  866
]
10.51 ms
(0.00%)
14
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.customer_id AS customer_id_2, a0_.card_id AS card_id_3, a0_.payment_agreement_id AS payment_agreement_id_4, a0_.begin_at AS begin_at_5, a0_.end_at AS end_at_6, a0_.cancellation_request_at AS cancellation_request_at_7, a0_.cancellation_at AS cancellation_at_8, a0_.refunded_at AS refunded_at_9, a0_.quantity AS quantity_10, a0_.created_at AS created_at_11, a0_.futures_pack_name AS futures_pack_name_12, a0_.luume_pack_name AS luume_pack_name_13, a0_.sent_to_luume_at AS sent_to_luume_at_14, a0_.context AS context_15, a0_.is_freedom AS is_freedom_16, a0_.is_qualified AS is_qualified_17, a0_.duration_total AS duration_total_18, a0_.has_full_points_distributed AS has_full_points_distributed_19, a0_.current_subscription_month AS current_subscription_month_20, a0_.freedom_duration AS freedom_duration_21, a0_.freedom_total_duration AS freedom_total_duration_22, a0_.total_prediction AS total_prediction_23, a0_.consumed_prediction AS consumed_prediction_24, a0_.decreasing_config_price AS decreasing_config_price_25, a0_.is_decreasing AS is_decreasing_26, a0_.member_id AS member_id_27, a0_.gateway_id AS gateway_id_28, a0_.country_id AS country_id_29, a0_.product_id AS product_id_30, a0_.payment_history_id AS payment_history_id_31, a0_.previous_subscription_id AS previous_subscription_id_32, a0_.initial_product_id AS initial_product_id_33 FROM app_subscription a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id WHERE a0_.member_id = ? AND a1_.type = ? AND a1_.space_id = ? AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL
Parameters:
[
  267473
  "pack"
  1
  "2025-12-18 23:33:18"
  "2025-12-18 23:33:18"
]
9.94 ms
(0.00%)
14
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.customer_id AS customer_id_2, a0_.card_id AS card_id_3, a0_.payment_agreement_id AS payment_agreement_id_4, a0_.begin_at AS begin_at_5, a0_.end_at AS end_at_6, a0_.cancellation_request_at AS cancellation_request_at_7, a0_.cancellation_at AS cancellation_at_8, a0_.refunded_at AS refunded_at_9, a0_.quantity AS quantity_10, a0_.created_at AS created_at_11, a0_.futures_pack_name AS futures_pack_name_12, a0_.luume_pack_name AS luume_pack_name_13, a0_.sent_to_luume_at AS sent_to_luume_at_14, a0_.context AS context_15, a0_.is_freedom AS is_freedom_16, a0_.is_qualified AS is_qualified_17, a0_.duration_total AS duration_total_18, a0_.has_full_points_distributed AS has_full_points_distributed_19, a0_.current_subscription_month AS current_subscription_month_20, a0_.freedom_duration AS freedom_duration_21, a0_.freedom_total_duration AS freedom_total_duration_22, a0_.total_prediction AS total_prediction_23, a0_.consumed_prediction AS consumed_prediction_24, a0_.decreasing_config_price AS decreasing_config_price_25, a0_.is_decreasing AS is_decreasing_26, a0_.member_id AS member_id_27, a0_.gateway_id AS gateway_id_28, a0_.country_id AS country_id_29, a0_.product_id AS product_id_30, a0_.payment_history_id AS payment_history_id_31, a0_.previous_subscription_id AS previous_subscription_id_32, a0_.initial_product_id AS initial_product_id_33 FROM app_subscription a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id WHERE a0_.member_id = ? AND (a1_.name = ? OR a1_.name = ?) AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL
Parameters:
[
  267473
  "ikigai"
  "ikigai-plus"
  "2025-12-18 23:33:18"
  "2025-12-18 23:33:18"
]
7.91 ms
(0.00%)
14
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_enabled AS is_enabled_3, t0.image AS image_4, t0.type AS type_5, t0.translation_key AS translation_key_6, t0.is_bundle AS is_bundle_7, t0.feature_type_id AS feature_type_id_8 FROM app_feature t0 INNER JOIN futures_event_features ON t0.id = futures_event_features.feature_id WHERE futures_event_features.futures_event_id = ?
Parameters:
[
  866
]
2.07 ms
(0.00%)
3
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"
]
1.89 ms
(0.00%)
1
SELECT a0_.id AS id_0, a0_.position AS position_1, a0_.status AS status_2, a0_.member_date AS member_date_3, a0_.enabled AS enabled_4, a0_.is_insider AS is_insider_5, a0_.accept_offers AS accept_offers_6, a0_.accept_terms_date AS accept_terms_date_7, a0_.has_premium_deducted AS has_premium_deducted_8, a0_.liberty_pack AS liberty_pack_9, a0_.preferred_language AS preferred_language_10, a0_.saving_bonus AS saving_bonus_11, a0_.saving_bonus_reached_at AS saving_bonus_reached_at_12, a0_.is_new AS is_new_13, a0_.birthday AS birthday_14, a0_.last_sponsor_attribution_at AS last_sponsor_attribution_at_15, a0_.is_offered_sponsor AS is_offered_sponsor_16, a0_.discord_id AS discord_id_17, a0_.step_elite AS step_elite_18, a0_.is_deleted AS is_deleted_19, a1_.id AS id_20, a1_.firstname AS firstname_21, a1_.lastname AS lastname_22, a1_.email AS email_23, a1_.password AS password_24, a1_.salt AS salt_25, a1_.birthdate AS birthdate_26, a1_.phone AS phone_27, a1_.created_at AS created_at_28, a1_.roles AS roles_29, a1_.last_login_at AS last_login_at_30, a1_.api_key AS api_key_31, a1_.password_reset_token AS password_reset_token_32, a1_.password_reset_token_expires_at AS password_reset_token_expires_at_33, a1_.password_reset_token_emails_sent AS password_reset_token_emails_sent_34, a1_.jwt_token AS jwt_token_35, a1_.jwt_token_expiration AS jwt_token_expiration_36, m2_.id AS id_37, m2_.position_for_parent AS position_for_parent_38, m2_.depth AS depth_39, m2_.left_index AS left_index_40, m2_.right_index AS right_index_41, m2_.nb_node_points AS nb_node_points_42, m2_.nb_total_points AS nb_total_points_43, m3_.id AS id_44, m3_.limit_date AS limit_date_45, m3_.kyc_validated_at AS kyc_validated_at_46, m3_.siret_validated_at AS siret_validated_at_47, m3_.company_immatriculation_validated_at AS company_immatriculation_validated_at_48, m3_.declaration_validated_at AS declaration_validated_at_49, m3_.company_vigilance_validated_at AS company_vigilance_validated_at_50, m3_.contract_validated_at AS contract_validated_at_51, m3_.company_status AS company_status_52, m3_.company_umbrella AS company_umbrella_53, m3_.company_name AS company_name_54, m3_.kyc_first_name AS kyc_first_name_55, m3_.kyc_last_name AS kyc_last_name_56, m3_.kyc_birthday AS kyc_birthday_57, m3_.company_siren AS company_siren_58, m3_.company_address_street AS company_address_street_59, m3_.company_address_postcode AS company_address_postcode_60, m3_.company_address_city AS company_address_city_61, m3_.applicant_id AS applicant_id_62, m3_.workflow_run_id AS workflow_run_id_63, m3_.sdk_token AS sdk_token_64, m3_.kyc_status AS kyc_status_65, m3_.certified_at AS certified_at_66, m3_.is_kyc_infos_extracted AS is_kyc_infos_extracted_67, m3_.certified_popup_closed_at AS certified_popup_closed_at_68, m3_.academy_popup_closed_at AS academy_popup_closed_at_69, m4_.id AS id_70, m4_.pack_name AS pack_name_71, m4_.created_at AS created_at_72, m4_.updated_at AS updated_at_73, m4_.shipping_method_id AS shipping_method_id_74, m4_.fees_in_cents AS fees_in_cents_75, m4_.futures_product AS futures_product_76, m4_.luume_product AS luume_product_77, m4_.is_over AS is_over_78, m4_.address_first_name AS address_first_name_79, m4_.address_last_name AS address_last_name_80, m4_.address_street AS address_street_81, m4_.address_postcode AS address_postcode_82, m4_.address_city AS address_city_83, m4_.address_country_code AS address_country_code_84, m4_.relay_name AS relay_name_85, m4_.relay_ref AS relay_ref_86, m4_.relay_street AS relay_street_87, m4_.relay_city AS relay_city_88, m4_.relay_postcode AS relay_postcode_89, m4_.relay_country_code AS relay_country_code_90, a5_.id AS id_91, a5_.nb_predictions AS nb_predictions_92, a0_.sponsor_id AS sponsor_id_93, a0_.parent_id AS parent_id_94, a0_.rank_id AS rank_id_95, a0_.pack_id AS pack_id_96, a0_.user_id AS user_id_97, a0_.member_node_id AS member_node_id_98, a0_.market_id AS market_id_99, a0_.qualification_id AS qualification_id_100, a0_.subscription_gateway_id AS subscription_gateway_id_101, a0_.subscription_country_id AS subscription_country_id_102, a0_.currency_id AS currency_id_103, a0_.first_subscription_space_id AS first_subscription_space_id_104, m2_.parent_node_id AS parent_node_id_105, m2_.member_id AS member_id_106, m2_.tree_id AS tree_id_107, m3_.member_id AS member_id_108, m3_.company_country_id AS company_country_id_109, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_110, m3_.company_vigilance_file_id AS company_vigilance_file_id_111, m3_.contract_file_id AS contract_file_id_112, m3_.certification_file_id AS certification_file_id_113, m4_.member_id AS member_id_114, a5_.member_id AS member_id_115 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN mybiz_member_node m2_ ON a0_.member_node_id = m2_.id LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id LEFT JOIN app_member_prediction a5_ ON a0_.id = a5_.member_id WHERE a1_.jwt_token = ? AND a1_.jwt_token_expiration > ? AND a0_.is_deleted = ?
Parameters:
[
  "YuOoa8ezTJCN5X9b0RHf4LDThO8kU9epkSY50hGXsAaY4KsRsu"
  "2025-12-18 23:33:18"
  0
]
1.06 ms
(0.00%)
1
SELECT f0_.id AS id_0, f0_.language AS language_1, f0_.title AS title_2, f0_.description AS description_3, f0_.start_at AS start_at_4, f0_.end_at AS end_at_5, f0_.streaming_meeting_id AS streaming_meeting_id_6, f0_.streaming_meeting_password AS streaming_meeting_password_7 FROM futures_event f0_ WHERE f0_.start_at >= ? AND f0_.end_at <= ?
Parameters:
[
  "2025-12-15 00:00:00"
  "2025-12-21 23:59:59"
]
0.96 ms
(0.00%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.marketing_name AS marketing_name_3, t0.color AS color_4, t0.is_enabled AS is_enabled_5, t0.space_id AS space_id_6 FROM app_feature_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.78 ms
(0.00%)
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, 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"
]
0.60 ms
(0.00%)
1
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:
[]
0.50 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.limit_date AS limit_date_2, t0.kyc_validated_at AS kyc_validated_at_3, t0.siret_validated_at AS siret_validated_at_4, t0.company_immatriculation_validated_at AS company_immatriculation_validated_at_5, t0.declaration_validated_at AS declaration_validated_at_6, t0.company_vigilance_validated_at AS company_vigilance_validated_at_7, t0.contract_validated_at AS contract_validated_at_8, t0.company_status AS company_status_9, t0.company_umbrella AS company_umbrella_10, t0.company_name AS company_name_11, t0.kyc_first_name AS kyc_first_name_12, t0.kyc_last_name AS kyc_last_name_13, t0.kyc_birthday AS kyc_birthday_14, t0.company_siren AS company_siren_15, t0.company_address_street AS company_address_street_16, t0.company_address_postcode AS company_address_postcode_17, t0.company_address_city AS company_address_city_18, t0.applicant_id AS applicant_id_19, t0.workflow_run_id AS workflow_run_id_20, t0.sdk_token AS sdk_token_21, t0.kyc_status AS kyc_status_22, t0.certified_at AS certified_at_23, t0.is_kyc_infos_extracted AS is_kyc_infos_extracted_24, t0.certified_popup_closed_at AS certified_popup_closed_at_25, t0.academy_popup_closed_at AS academy_popup_closed_at_26, t0.member_id AS member_id_27, t0.company_country_id AS company_country_id_28, t0.company_immatriculation_file_id AS company_immatriculation_file_id_29, t0.company_vigilance_file_id AS company_vigilance_file_id_30, t0.contract_file_id AS contract_file_id_31, t0.certification_file_id AS certification_file_id_32 FROM mybiz_on_boarding t0 WHERE t0.member_id = ?
Parameters:
[
  262001
]
0.49 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.pack_name AS pack_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.shipping_method_id AS shipping_method_id_5, t0.fees_in_cents AS fees_in_cents_6, t0.futures_product AS futures_product_7, t0.luume_product AS luume_product_8, t0.is_over AS is_over_9, t0.address_first_name AS address_first_name_10, t0.address_last_name AS address_last_name_11, t0.address_street AS address_street_12, t0.address_postcode AS address_postcode_13, t0.address_city AS address_city_14, t0.address_country_code AS address_country_code_15, t0.relay_name AS relay_name_16, t0.relay_ref AS relay_ref_17, t0.relay_street AS relay_street_18, t0.relay_city AS relay_city_19, t0.relay_postcode AS relay_postcode_20, t0.relay_country_code AS relay_country_code_21, t0.member_id AS member_id_22 FROM mybiz_qualified_choice t0 WHERE t0.member_id = ?
Parameters:
[
  262001
]
0.38 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.nb_predictions AS nb_predictions_2, t0.member_id AS member_id_3 FROM app_member_prediction t0 WHERE t0.member_id = ?
Parameters:
[
  262001
]

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\Member No errors.
App\Entity\Product No errors.
App\Entity\Subscription No errors.
App\Entity\Futures\FeatureType No errors.
App\Entity\ShopPurchase No errors.
App\Entity\Notification No errors.
App\Entity\Document No errors.
App\Entity\Academy No errors.
App\Entity\Mybiz\AmbassadorInvoice No errors.
App\Entity\MemberDocument No errors.
App\Entity\Futures\FuturesEvent No errors.
App\Entity\Mybiz\MemberNode No errors.
App\Entity\Mybiz\MybizOnBoarding No errors.
App\Entity\Mybiz\QualifiedChoice No errors.
App\Entity\MemberPrediction No errors.
App\Entity\Mybiz\Rank No errors.
App\Entity\Market No errors.
App\Entity\Gateway No errors.
App\Entity\Country No errors.
App\Entity\Currency No errors.
App\Entity\Mybiz\Tree No errors.
App\Entity\Futures\Prediction No errors.
App\Entity\Mybiz\MoneyBag No errors.
App\Entity\MemberCard No errors.
App\Entity\MemberNotification No errors.
App\Entity\Mybiz\MemberSocialNetwork No errors.
App\Entity\PaymentHistory No errors.
App\Entity\UserAddress No errors.
App\Entity\Futures\Replay No errors.
App\Entity\Futures\TradeStrategy No errors.
App\Entity\Futures\Feature No errors.
App\Entity\Futures\ReplayCategory No errors.
App\Entity\Futures\Book No errors.
App\Entity\Futures\FeatureTutorial No errors.