GET https://dev.my-biz.pro/v1/tv/planning

Query Metrics

10 Database Queries
8 Different statements
6.31 ms Query time
0 Invalid entities
37 Managed entities

Queries

Group similar statements

# Time Info
1 0.45 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.47 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"
]
3 0.59 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.39 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"
]
5 1.00 ms
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_.signup_ip_address AS signup_ip_address_13, a0_.is_new AS is_new_14, a0_.birthday AS birthday_15, a0_.last_sponsor_attribution_at AS last_sponsor_attribution_at_16, a0_.is_offered_sponsor AS is_offered_sponsor_17, a0_.discord_id AS discord_id_18, a0_.step_elite AS step_elite_19, a0_.is_deleted AS is_deleted_20, a0_.theme AS theme_21, a1_.id AS id_22, a1_.firstname AS firstname_23, a1_.lastname AS lastname_24, a1_.email AS email_25, a1_.password AS password_26, a1_.salt AS salt_27, a1_.birthdate AS birthdate_28, a1_.phone AS phone_29, a1_.created_at AS created_at_30, a1_.roles AS roles_31, a1_.last_login_at AS last_login_at_32, a1_.api_key AS api_key_33, a1_.password_reset_token AS password_reset_token_34, a1_.password_reset_token_expires_at AS password_reset_token_expires_at_35, a1_.password_reset_token_emails_sent AS password_reset_token_emails_sent_36, a1_.jwt_token AS jwt_token_37, a1_.jwt_token_expiration AS jwt_token_expiration_38, m2_.id AS id_39, m2_.position_for_parent AS position_for_parent_40, m2_.depth AS depth_41, m2_.left_index AS left_index_42, m2_.right_index AS right_index_43, m2_.nb_node_points AS nb_node_points_44, m2_.nb_total_points AS nb_total_points_45, m3_.id AS id_46, m3_.limit_date AS limit_date_47, m3_.kyc_validated_at AS kyc_validated_at_48, m3_.siret_validated_at AS siret_validated_at_49, m3_.company_immatriculation_validated_at AS company_immatriculation_validated_at_50, m3_.declaration_validated_at AS declaration_validated_at_51, m3_.company_vigilance_validated_at AS company_vigilance_validated_at_52, m3_.contract_validated_at AS contract_validated_at_53, m3_.company_status AS company_status_54, m3_.company_umbrella AS company_umbrella_55, m3_.company_name AS company_name_56, m3_.kyc_first_name AS kyc_first_name_57, m3_.kyc_last_name AS kyc_last_name_58, m3_.kyc_birthday AS kyc_birthday_59, m3_.company_siren AS company_siren_60, m3_.company_address_street AS company_address_street_61, m3_.company_address_postcode AS company_address_postcode_62, m3_.company_address_city AS company_address_city_63, m3_.applicant_id AS applicant_id_64, m3_.workflow_run_id AS workflow_run_id_65, m3_.sdk_token AS sdk_token_66, m3_.kyc_status AS kyc_status_67, m3_.certified_at AS certified_at_68, m3_.is_kyc_infos_extracted AS is_kyc_infos_extracted_69, m3_.certified_popup_closed_at AS certified_popup_closed_at_70, m3_.academy_popup_closed_at AS academy_popup_closed_at_71, m4_.id AS id_72, m4_.pack_name AS pack_name_73, m4_.created_at AS created_at_74, m4_.updated_at AS updated_at_75, m4_.shipping_method_id AS shipping_method_id_76, m4_.fees_in_cents AS fees_in_cents_77, m4_.futures_product AS futures_product_78, m4_.luume_product AS luume_product_79, m4_.is_over AS is_over_80, m4_.address_first_name AS address_first_name_81, m4_.address_last_name AS address_last_name_82, m4_.address_street AS address_street_83, m4_.address_postcode AS address_postcode_84, m4_.address_city AS address_city_85, m4_.address_country_code AS address_country_code_86, m4_.relay_name AS relay_name_87, m4_.relay_ref AS relay_ref_88, m4_.relay_street AS relay_street_89, m4_.relay_city AS relay_city_90, m4_.relay_postcode AS relay_postcode_91, m4_.relay_country_code AS relay_country_code_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_.market_id AS market_id_98, a0_.qualification_id AS qualification_id_99, a0_.subscription_gateway_id AS subscription_gateway_id_100, a0_.subscription_country_id AS subscription_country_id_101, a0_.currency_id AS currency_id_102, a0_.first_subscription_space_id AS first_subscription_space_id_103, m2_.parent_node_id AS parent_node_id_104, m2_.member_id AS member_id_105, m2_.tree_id AS tree_id_106, m3_.member_id AS member_id_107, m3_.company_country_id AS company_country_id_108, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_109, m3_.company_vigilance_file_id AS company_vigilance_file_id_110, m3_.contract_file_id AS contract_file_id_111, m3_.certification_file_id AS certification_file_id_112, m4_.member_id AS member_id_113 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_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 WHERE a1_.jwt_token = ? AND a1_.jwt_token_expiration > ? AND a0_.is_deleted = ?
Parameters:
[
  "eK38jEdYiSpYa96VuvOmsbj6sk8KfgfFLyXbjBkZ57dJlehJZ9"
  "2026-03-03 09:34:53"
  0
]
6 0.38 ms
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:
[
  271572
]
7 0.74 ms
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:
[
  271572
  "pack"
  1
  "2026-03-03 09:34:53"
  "2026-03-03 09:34:53"
]
8 1.55 ms
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, a1_.id AS id_8, a1_.name AS name_9, a1_.is_enabled AS is_enabled_10, a1_.image AS image_11, a1_.type AS type_12, a1_.translation_key AS translation_key_13, a1_.is_bundle AS is_bundle_14, a2_.id AS id_15, a2_.name AS name_16, a2_.marketing_name AS marketing_name_17, a2_.color AS color_18, a2_.is_enabled AS is_enabled_19, a1_.feature_type_id AS feature_type_id_20, a2_.space_id AS space_id_21 FROM futures_event f0_ INNER JOIN futures_event_features f3_ ON f0_.id = f3_.futures_event_id INNER JOIN app_feature a1_ ON a1_.id = f3_.feature_id INNER JOIN app_feature_type a2_ ON a1_.feature_type_id = a2_.id WHERE f0_.start_at >= ? AND f0_.end_at <= ?
Parameters:
[
  "2026-03-02 00:00:00"
  "2026-03-08 23:59:59"
]
9 0.35 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.sku AS sku_4, t0.is_enabled AS is_enabled_5, t0.is_subscibable AS is_subscibable_6, t0.is_ikigai_pack AS is_ikigai_pack_7, t0.is_printable AS is_printable_8, t0.marketing_name AS marketing_name_9, t0.image_path AS image_path_10, t0.color AS color_11, t0.context AS context_12, t0.space_id AS space_id_13 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
  9
]
10 0.39 ms
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 app_product_features ON t0.id = app_product_features.feature_id WHERE app_product_features.product_id = ?
Parameters:
[
  9
]

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
App\Entity\Service\Feature 15
App\Entity\Service\FeatureType 4
App\Entity\Space\Space 3
App\Entity\Member\Member 3
App\Entity\Mybiz\MemberNode 2
App\Entity\Parameter\Parameter 1
App\Entity\Parameter\Market 1
App\Entity\Parameter\Gateway 1
App\Entity\Parameter\Country 1
App\Entity\Parameter\Currency 1
App\Entity\Member\User 1
App\Entity\Mybiz\Tree 1
App\Entity\Payment\Subscription 1
App\Entity\Product\Product 1
App\Entity\Payment\PaymentHistory 1

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\Member\User No errors.
App\Entity\Mybiz\MemberNode No errors.
App\Entity\Mybiz\MybizOnBoarding No errors.
App\Entity\Mybiz\QualifiedChoice No errors.
App\Entity\Mybiz\Rank No errors.
App\Entity\Parameter\Market No errors.
App\Entity\Parameter\Gateway No errors.
App\Entity\Parameter\Country No errors.
App\Entity\Parameter\Currency No errors.
App\Entity\Mybiz\Tree No errors.
App\Entity\Member\MemberDocument No errors.
App\Entity\Member\MemberPrediction No errors.
App\Entity\Mybiz\MoneyBag No errors.
App\Entity\Member\MemberNotification No errors.
App\Entity\Payment\Subscription No errors.
App\Entity\Mybiz\MemberSocialNetwork No errors.
App\Entity\Payment\PaymentHistory No errors.
App\Entity\Mybiz\AmbassadorInvoice No errors.
App\Entity\Member\UserEvent No errors.
App\Entity\Member\UserAddress No errors.
App\Entity\Service\Tv\FuturesEvent No errors.
App\Entity\Service\Tv\Replay No errors.
App\Entity\Service\University\Academy No errors.
App\Entity\Service\Feature No errors.
App\Entity\Product\ProductPrice No errors.
App\Entity\Product\ProductPoint No errors.
App\Entity\Product\ProductPrediction No errors.
App\Entity\Service\Tv\ReplayCategory No errors.
App\Entity\Service\Book\Book No errors.
App\Entity\Service\FeatureTutorial No errors.