Symfony Profiler

Query Metrics

47 Database Queries

33 Different statements

62.02 ms Query time

0 Invalid entities

39 Managed entities

Queries


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
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
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
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
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
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
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
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
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
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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.email = ? LIMIT 1
SELECT t0.id AS id_1, t0.position_for_parent AS position_for_parent_2, t0.depth AS depth_3, t0.left_index AS left_index_4, t0.right_index AS right_index_5, t0.nb_node_points AS nb_node_points_6, t0.nb_total_points AS nb_total_points_7, t0.parent_node_id AS parent_node_id_8, t0.member_id AS member_id_9, t0.tree_id AS tree_id_10 FROM mybiz_member_node t0 WHERE t0.member_id = ?
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 = ?
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 = ?
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 = ?
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, a5_.id AS id_93, a5_.type AS type_94, a5_.name AS name_95, a5_.sku AS sku_96, a5_.is_enabled AS is_enabled_97, a5_.is_subscibable AS is_subscibable_98, a5_.is_ikigai_pack AS is_ikigai_pack_99, a5_.is_printable AS is_printable_100, a5_.marketing_name AS marketing_name_101, a5_.image_path AS image_path_102, a5_.color AS color_103, a5_.context AS context_104, a0_.sponsor_id AS sponsor_id_105, a0_.parent_id AS parent_id_106, a0_.rank_id AS rank_id_107, a0_.pack_id AS pack_id_108, a0_.user_id AS user_id_109, a0_.market_id AS market_id_110, a0_.qualification_id AS qualification_id_111, a0_.subscription_gateway_id AS subscription_gateway_id_112, a0_.subscription_country_id AS subscription_country_id_113, a0_.currency_id AS currency_id_114, a0_.first_subscription_space_id AS first_subscription_space_id_115, m2_.parent_node_id AS parent_node_id_116, m2_.member_id AS member_id_117, m2_.tree_id AS tree_id_118, m3_.member_id AS member_id_119, m3_.company_country_id AS company_country_id_120, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_121, m3_.company_vigilance_file_id AS company_vigilance_file_id_122, m3_.contract_file_id AS contract_file_id_123, m3_.certification_file_id AS certification_file_id_124, m4_.member_id AS member_id_125, a5_.space_id AS space_id_126 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 LEFT JOIN app_product a5_ ON a0_.pack_id = a5_.id WHERE a0_.sponsor_id = ? AND (a0_.position IS NULL OR a0_.position = 0) AND (a0_.status = ? OR a0_.status = ?) AND a0_.is_deleted = ? ORDER BY a0_.member_date DESC LIMIT 10
SELECT a0_.id AS id_0, a0_.payment_stripe_id AS payment_stripe_id_1, a0_.customer_stripe_id AS customer_stripe_id_2, a0_.payment_at AS payment_at_3, a0_.amount_in_moneybag AS amount_in_moneybag_4, a0_.points_in_left AS points_in_left_5, a0_.points_in_right AS points_in_right_6, a0_.begin_validity_at AS begin_validity_at_7, a0_.consumed_at AS consumed_at_8, a0_.placement_at AS placement_at_9, a0_.refunded_at AS refunded_at_10, a0_.context AS context_11, a0_.sponsor_id AS sponsor_id_12, a0_.space_id AS space_id_13 FROM app_shop_purchase a0_ WHERE a0_.consumed_at IS NULL AND a0_.placement_at IS NULL AND a0_.refunded_at IS NULL AND a0_.sponsor_id = ?
SELECT a0_.id AS id_0, a0_.payment_session_id AS payment_session_id_1, a0_.subscription_id AS subscription_id_2, a0_.customer_id AS customer_id_3, a0_.mode AS mode_4, a0_.amount AS amount_5, a0_.currency AS currency_6, a0_.customer_email AS customer_email_7, a0_.date AS date_8, a0_.product AS product_9, a0_.payment_method AS payment_method_10, a0_.setup_intent AS setup_intent_11, a0_.invoice_id AS invoice_id_12, a0_.status AS status_13, a0_.type AS type_14, a0_.provider AS provider_15, a0_.points AS points_16, a0_.subscription_type AS subscription_type_17, a0_.space AS space_18, a0_.context AS context_19, a0_.is_installment AS is_installment_20, a0_.index_installment AS index_installment_21, a0_.is_decreasing AS is_decreasing_22, a0_.decreasing_config_price AS decreasing_config_price_23, a0_.duration AS duration_24, a0_.market AS market_25, a0_.member_id AS member_id_26 FROM app_payment_history a0_ WHERE a0_.type = ? AND a0_.member_id = ? AND a0_.status = ? ORDER BY a0_.date DESC
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
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
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.name = ? LIMIT 1
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.name = ? LIMIT 1
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
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
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 a0_.cancellation_at IS NULL ORDER BY a0_.begin_at DESC
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 = ?
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
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_ WHERE a0_.member_id = ? AND a0_.is_qualified = ? AND a0_.cancellation_at IS NULL
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 INNER JOIN mybiz_rank m5_ ON a0_.qualification_id = m5_.id WHERE a0_.qualification_id IS NOT NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC
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 INNER JOIN app_member a5_ ON a0_.sponsor_id = a5_.id INNER JOIN app_subscription a6_ ON a0_.id = a6_.member_id LEFT JOIN app_product a7_ ON a6_.product_id = a7_.id WHERE a6_.end_at > ? AND a6_.cancellation_at IS NULL AND a7_.type = ? AND a6_.is_freedom = 0 AND a6_.is_qualified = 0 AND a0_.is_deleted = ? AND a5_.id = ? ORDER BY a0_.id ASC
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 INNER JOIN app_shop_purchase a5_ ON a0_.id = a5_.sponsor_id INNER JOIN app_member a6_ ON a5_.sponsor_id = a6_.id WHERE a5_.consumed_at IS NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC
SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ?
SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ?
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.marketing_name AS marketing_name_2, m0_.image AS image_3, m0_.residual AS residual_4, m0_.saving_bonus_amount AS saving_bonus_amount_5, m0_.level AS level_6, m0_.min_direct_clients AS min_direct_clients_7, m0_.representative_client AS representative_client_8, m0_.min_direct_points AS min_direct_points_9, m0_.min_left_points AS min_left_points_10, m0_.min_right_points AS min_right_points_11, m0_.is_in_progression AS is_in_progression_12 FROM mybiz_rank m0_ WHERE m0_.min_left_points <= ? AND m0_.min_right_points <= ? AND m0_.min_direct_points <= ? AND m0_.level > ? ORDER BY m0_.level DESC LIMIT 1
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
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
SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.type AS type_4, t0.description AS description_5, t0.s3_path AS s3_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.member_id AS member_id_9 FROM app_member_document t0 WHERE t0.member_id = ? AND t0.type = ? LIMIT 1
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.customer_id AS customer_id_3, t0.card_id AS card_id_4, t0.payment_agreement_id AS payment_agreement_id_5, t0.begin_at AS begin_at_6, t0.end_at AS end_at_7, t0.cancellation_request_at AS cancellation_request_at_8, t0.cancellation_at AS cancellation_at_9, t0.refunded_at AS refunded_at_10, t0.quantity AS quantity_11, t0.created_at AS created_at_12, t0.futures_pack_name AS futures_pack_name_13, t0.luume_pack_name AS luume_pack_name_14, t0.sent_to_luume_at AS sent_to_luume_at_15, t0.context AS context_16, t0.is_freedom AS is_freedom_17, t0.is_qualified AS is_qualified_18, t0.duration_total AS duration_total_19, t0.has_full_points_distributed AS has_full_points_distributed_20, t0.current_subscription_month AS current_subscription_month_21, t0.freedom_duration AS freedom_duration_22, t0.freedom_total_duration AS freedom_total_duration_23, t0.total_prediction AS total_prediction_24, t0.consumed_prediction AS consumed_prediction_25, t0.decreasing_config_price AS decreasing_config_price_26, t0.is_decreasing AS is_decreasing_27, t0.member_id AS member_id_28, t0.gateway_id AS gateway_id_29, t0.country_id AS country_id_30, t0.product_id AS product_id_31, t0.payment_history_id AS payment_history_id_32, t0.previous_subscription_id AS previous_subscription_id_33, t0.initial_product_id AS initial_product_id_34 FROM app_subscription t0 WHERE t0.member_id = ?
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
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.type = ? AND t0.space_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.mandate AS mandate_4, t0.is_enabled AS is_enabled_5 FROM app_currency t0 WHERE t0.code = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_rate AS tax_rate_3, t0.type AS type_4, t0.is_default AS is_default_5, t0.marketing_name AS marketing_name_6, t0.marketing_description AS marketing_description_7, t0.enabled AS enabled_8, t0.is_debitable AS is_debitable_9 FROM app_gateway t0 WHERE t0.name = ? LIMIT 1
SELECT t0.id AS id_1, t0.nb_month AS nb_month_2, t0.first_price AS first_price_3, t0.subscription_price AS subscription_price_4, t0.first_commission AS first_commission_5, t0.subscription_commission AS subscription_commission_6, t0.commission_month1 AS commission_month1_7, t0.commission_month2 AS commission_month2_8, t0.commission_month3 AS commission_month3_9, t0.copecart_product_id_with_first_price AS copecart_product_id_with_first_price_10, t0.copecart_product_id_only_subscription AS copecart_product_id_only_subscription_11, t0.is_enabled AS is_enabled_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.market_id AS market_id_15 FROM app_product_price t0 WHERE t0.product_id = ? AND t0.market_id = ? AND t0.currency_id = ? AND t0.nb_month = ? LIMIT 1
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.suffix AS suffix_4, t0.is_promotional AS is_promotional_5 FROM app_market t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.addition AS addition_4, t0.zip AS zip_5, t0.city AS city_6, t0.state AS state_7, t0.country_code AS country_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.user_id AS user_id_11 FROM app_user_address t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.name_en AS name_en_5, t0.name_fr AS name_fr_6, t0.is_in_mybiz_onboarding AS is_in_mybiz_onboarding_7, t0.is_in_qualified_choice AS is_in_qualified_choice_8, t0.market_id AS market_id_9 FROM app_country t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.position AS position_2, t0.status AS status_3, t0.member_date AS member_date_4, t0.enabled AS enabled_5, t0.is_insider AS is_insider_6, t0.accept_offers AS accept_offers_7, t0.accept_terms_date AS accept_terms_date_8, t0.has_premium_deducted AS has_premium_deducted_9, t0.liberty_pack AS liberty_pack_10, t0.preferred_language AS preferred_language_11, t0.saving_bonus AS saving_bonus_12, t0.saving_bonus_reached_at AS saving_bonus_reached_at_13, t0.signup_ip_address AS signup_ip_address_14, t0.is_new AS is_new_15, t0.birthday AS birthday_16, t0.last_sponsor_attribution_at AS last_sponsor_attribution_at_17, t0.is_offered_sponsor AS is_offered_sponsor_18, t0.discord_id AS discord_id_19, t0.step_elite AS step_elite_20, t0.is_deleted AS is_deleted_21, t0.theme AS theme_22, t0.sponsor_id AS sponsor_id_23, t0.parent_id AS parent_id_24, t0.rank_id AS rank_id_25, t0.pack_id AS pack_id_26, t0.user_id AS user_id_27, t28.id AS id_29, t28.position_for_parent AS position_for_parent_30, t28.depth AS depth_31, t28.left_index AS left_index_32, t28.right_index AS right_index_33, t28.nb_node_points AS nb_node_points_34, t28.nb_total_points AS nb_total_points_35, t28.parent_node_id AS parent_node_id_36, t28.member_id AS member_id_37, t28.tree_id AS tree_id_38, t0.market_id AS market_id_39, t0.qualification_id AS qualification_id_40, t41.id AS id_42, t41.nb_predictions AS nb_predictions_43, t41.member_id AS member_id_44, t0.subscription_gateway_id AS subscription_gateway_id_45, t0.subscription_country_id AS subscription_country_id_46, t0.currency_id AS currency_id_47, t0.first_subscription_space_id AS first_subscription_space_id_48, t49.id AS id_50, t49.pack_name AS pack_name_51, t49.created_at AS created_at_52, t49.updated_at AS updated_at_53, t49.shipping_method_id AS shipping_method_id_54, t49.fees_in_cents AS fees_in_cents_55, t49.futures_product AS futures_product_56, t49.luume_product AS luume_product_57, t49.is_over AS is_over_58, t49.address_first_name AS address_first_name_59, t49.address_last_name AS address_last_name_60, t49.address_street AS address_street_61, t49.address_postcode AS address_postcode_62, t49.address_city AS address_city_63, t49.address_country_code AS address_country_code_64, t49.relay_name AS relay_name_65, t49.relay_ref AS relay_ref_66, t49.relay_street AS relay_street_67, t49.relay_city AS relay_city_68, t49.relay_postcode AS relay_postcode_69, t49.relay_country_code AS relay_country_code_70, t49.member_id AS member_id_71, t72.id AS id_73, t72.limit_date AS limit_date_74, t72.kyc_validated_at AS kyc_validated_at_75, t72.siret_validated_at AS siret_validated_at_76, t72.company_immatriculation_validated_at AS company_immatriculation_validated_at_77, t72.declaration_validated_at AS declaration_validated_at_78, t72.company_vigilance_validated_at AS company_vigilance_validated_at_79, t72.contract_validated_at AS contract_validated_at_80, t72.company_status AS company_status_81, t72.company_umbrella AS company_umbrella_82, t72.company_name AS company_name_83, t72.kyc_first_name AS kyc_first_name_84, t72.kyc_last_name AS kyc_last_name_85, t72.kyc_birthday AS kyc_birthday_86, t72.company_siren AS company_siren_87, t72.company_address_street AS company_address_street_88, t72.company_address_postcode AS company_address_postcode_89, t72.company_address_city AS company_address_city_90, t72.applicant_id AS applicant_id_91, t72.workflow_run_id AS workflow_run_id_92, t72.sdk_token AS sdk_token_93, t72.kyc_status AS kyc_status_94, t72.certified_at AS certified_at_95, t72.is_kyc_infos_extracted AS is_kyc_infos_extracted_96, t72.certified_popup_closed_at AS certified_popup_closed_at_97, t72.academy_popup_closed_at AS academy_popup_closed_at_98, t72.member_id AS member_id_99, t72.company_country_id AS company_country_id_100, t72.company_immatriculation_file_id AS company_immatriculation_file_id_101, t72.company_vigilance_file_id AS company_vigilance_file_id_102, t72.contract_file_id AS contract_file_id_103, t72.certification_file_id AS certification_file_id_104 FROM app_member t0 LEFT JOIN mybiz_member_node t28 ON t28.member_id = t0.id LEFT JOIN app_member_prediction t41 ON t41.member_id = t0.id LEFT JOIN mybiz_qualified_choice t49 ON t49.member_id = t0.id LEFT JOIN mybiz_on_boarding t72 ON t72.member_id = t0.id WHERE t0.id = ?
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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.id = ?

#▲	Time	Info
1	1.43 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"`] View formatted query View runnable query Explain query 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 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 = 'app.maintenance.lock' LIMIT 1;
2	1.16 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"`] View formatted query View runnable query Explain query 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 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 = 'app.maintenance.lock' LIMIT 1;
3	1.32 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"`] View formatted query View runnable query Explain query 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 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 = 'luume' LIMIT 1;
4	1.50 ms	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: [] View formatted query View runnable query Explain query 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 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;
5	1.31 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"`] View formatted query View runnable query Explain query 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 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 = 'futures_infinity' LIMIT 1;
6	1.18 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"`] View formatted query View runnable query Explain query 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 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 = 'luume' LIMIT 1;
7	1.12 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"`] View formatted query View runnable query Explain query 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 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 = 'mybiz' LIMIT 1;
8	1.24 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"`] View formatted query View runnable query Explain query 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 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 = 'futures_infinity' LIMIT 1;
9	1.28 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"`] View formatted query View runnable query Explain query 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 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 = 'luume' LIMIT 1;
10	1.52 ms	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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.email = ? LIMIT 1 Parameters: [`"testgiftcard2@gmail.com"`] View formatted query View runnable query Explain query 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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.email = ? LIMIT 1 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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.email = 'testgiftcard2@gmail.com' LIMIT 1;
11	1.31 ms	SELECT t0.id AS id_1, t0.position_for_parent AS position_for_parent_2, t0.depth AS depth_3, t0.left_index AS left_index_4, t0.right_index AS right_index_5, t0.nb_node_points AS nb_node_points_6, t0.nb_total_points AS nb_total_points_7, t0.parent_node_id AS parent_node_id_8, t0.member_id AS member_id_9, t0.tree_id AS tree_id_10 FROM mybiz_member_node t0 WHERE t0.member_id = ? Parameters: [`271587`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position_for_parent AS position_for_parent_2, t0.depth AS depth_3, t0.left_index AS left_index_4, t0.right_index AS right_index_5, t0.nb_node_points AS nb_node_points_6, t0.nb_total_points AS nb_total_points_7, t0.parent_node_id AS parent_node_id_8, t0.member_id AS member_id_9, t0.tree_id AS tree_id_10 FROM mybiz_member_node t0 WHERE t0.member_id = ? SELECT t0.id AS id_1, t0.position_for_parent AS position_for_parent_2, t0.depth AS depth_3, t0.left_index AS left_index_4, t0.right_index AS right_index_5, t0.nb_node_points AS nb_node_points_6, t0.nb_total_points AS nb_total_points_7, t0.parent_node_id AS parent_node_id_8, t0.member_id AS member_id_9, t0.tree_id AS tree_id_10 FROM mybiz_member_node t0 WHERE t0.member_id = 271587;
12	1.14 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: [`271587`] View formatted query View runnable query Explain query 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 = ? 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 = 271587;
13	1.24 ms	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: [`271587`] View formatted query View runnable query Explain query 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 = ? 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 = 271587;
14	1.21 ms	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: [`271587`] View formatted query View runnable query Explain query 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 = ? 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 = 271587;
15	1.86 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, a5_.id AS id_93, a5_.type AS type_94, a5_.name AS name_95, a5_.sku AS sku_96, a5_.is_enabled AS is_enabled_97, a5_.is_subscibable AS is_subscibable_98, a5_.is_ikigai_pack AS is_ikigai_pack_99, a5_.is_printable AS is_printable_100, a5_.marketing_name AS marketing_name_101, a5_.image_path AS image_path_102, a5_.color AS color_103, a5_.context AS context_104, a0_.sponsor_id AS sponsor_id_105, a0_.parent_id AS parent_id_106, a0_.rank_id AS rank_id_107, a0_.pack_id AS pack_id_108, a0_.user_id AS user_id_109, a0_.market_id AS market_id_110, a0_.qualification_id AS qualification_id_111, a0_.subscription_gateway_id AS subscription_gateway_id_112, a0_.subscription_country_id AS subscription_country_id_113, a0_.currency_id AS currency_id_114, a0_.first_subscription_space_id AS first_subscription_space_id_115, m2_.parent_node_id AS parent_node_id_116, m2_.member_id AS member_id_117, m2_.tree_id AS tree_id_118, m3_.member_id AS member_id_119, m3_.company_country_id AS company_country_id_120, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_121, m3_.company_vigilance_file_id AS company_vigilance_file_id_122, m3_.contract_file_id AS contract_file_id_123, m3_.certification_file_id AS certification_file_id_124, m4_.member_id AS member_id_125, a5_.space_id AS space_id_126 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 LEFT JOIN app_product a5_ ON a0_.pack_id = a5_.id WHERE a0_.sponsor_id = ? AND (a0_.position IS NULL OR a0_.position = 0) AND (a0_.status = ? OR a0_.status = ?) AND a0_.is_deleted = ? ORDER BY a0_.member_date DESC LIMIT 10 Parameters: [`271587 "waiting" "inactive" 0`] View formatted query View runnable query Explain query 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, a5_.id AS id_93, a5_.type AS type_94, a5_.name AS name_95, a5_.sku AS sku_96, a5_.is_enabled AS is_enabled_97, a5_.is_subscibable AS is_subscibable_98, a5_.is_ikigai_pack AS is_ikigai_pack_99, a5_.is_printable AS is_printable_100, a5_.marketing_name AS marketing_name_101, a5_.image_path AS image_path_102, a5_.color AS color_103, a5_.context AS context_104, a0_.sponsor_id AS sponsor_id_105, a0_.parent_id AS parent_id_106, a0_.rank_id AS rank_id_107, a0_.pack_id AS pack_id_108, a0_.user_id AS user_id_109, a0_.market_id AS market_id_110, a0_.qualification_id AS qualification_id_111, a0_.subscription_gateway_id AS subscription_gateway_id_112, a0_.subscription_country_id AS subscription_country_id_113, a0_.currency_id AS currency_id_114, a0_.first_subscription_space_id AS first_subscription_space_id_115, m2_.parent_node_id AS parent_node_id_116, m2_.member_id AS member_id_117, m2_.tree_id AS tree_id_118, m3_.member_id AS member_id_119, m3_.company_country_id AS company_country_id_120, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_121, m3_.company_vigilance_file_id AS company_vigilance_file_id_122, m3_.contract_file_id AS contract_file_id_123, m3_.certification_file_id AS certification_file_id_124, m4_.member_id AS member_id_125, a5_.space_id AS space_id_126 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 LEFT JOIN app_product a5_ ON a0_.pack_id = a5_.id WHERE a0_.sponsor_id = ? AND ( a0_.position IS NULL OR a0_.position = 0 ) AND ( a0_.status = ? OR a0_.status = ? ) AND a0_.is_deleted = ? ORDER BY a0_.member_date DESC LIMIT 10 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, a5_.id AS id_93, a5_.type AS type_94, a5_.name AS name_95, a5_.sku AS sku_96, a5_.is_enabled AS is_enabled_97, a5_.is_subscibable AS is_subscibable_98, a5_.is_ikigai_pack AS is_ikigai_pack_99, a5_.is_printable AS is_printable_100, a5_.marketing_name AS marketing_name_101, a5_.image_path AS image_path_102, a5_.color AS color_103, a5_.context AS context_104, a0_.sponsor_id AS sponsor_id_105, a0_.parent_id AS parent_id_106, a0_.rank_id AS rank_id_107, a0_.pack_id AS pack_id_108, a0_.user_id AS user_id_109, a0_.market_id AS market_id_110, a0_.qualification_id AS qualification_id_111, a0_.subscription_gateway_id AS subscription_gateway_id_112, a0_.subscription_country_id AS subscription_country_id_113, a0_.currency_id AS currency_id_114, a0_.first_subscription_space_id AS first_subscription_space_id_115, m2_.parent_node_id AS parent_node_id_116, m2_.member_id AS member_id_117, m2_.tree_id AS tree_id_118, m3_.member_id AS member_id_119, m3_.company_country_id AS company_country_id_120, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_121, m3_.company_vigilance_file_id AS company_vigilance_file_id_122, m3_.contract_file_id AS contract_file_id_123, m3_.certification_file_id AS certification_file_id_124, m4_.member_id AS member_id_125, a5_.space_id AS space_id_126 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 LEFT JOIN app_product a5_ ON a0_.pack_id = a5_.id WHERE a0_.sponsor_id = 271587 AND (a0_.position IS NULL OR a0_.position = 0) AND (a0_.status = 'waiting' OR a0_.status = 'inactive') AND a0_.is_deleted = 0 ORDER BY a0_.member_date DESC LIMIT 10;
16	1.13 ms	SELECT a0_.id AS id_0, a0_.payment_stripe_id AS payment_stripe_id_1, a0_.customer_stripe_id AS customer_stripe_id_2, a0_.payment_at AS payment_at_3, a0_.amount_in_moneybag AS amount_in_moneybag_4, a0_.points_in_left AS points_in_left_5, a0_.points_in_right AS points_in_right_6, a0_.begin_validity_at AS begin_validity_at_7, a0_.consumed_at AS consumed_at_8, a0_.placement_at AS placement_at_9, a0_.refunded_at AS refunded_at_10, a0_.context AS context_11, a0_.sponsor_id AS sponsor_id_12, a0_.space_id AS space_id_13 FROM app_shop_purchase a0_ WHERE a0_.consumed_at IS NULL AND a0_.placement_at IS NULL AND a0_.refunded_at IS NULL AND a0_.sponsor_id = ? Parameters: [`271587`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.payment_stripe_id AS payment_stripe_id_1, a0_.customer_stripe_id AS customer_stripe_id_2, a0_.payment_at AS payment_at_3, a0_.amount_in_moneybag AS amount_in_moneybag_4, a0_.points_in_left AS points_in_left_5, a0_.points_in_right AS points_in_right_6, a0_.begin_validity_at AS begin_validity_at_7, a0_.consumed_at AS consumed_at_8, a0_.placement_at AS placement_at_9, a0_.refunded_at AS refunded_at_10, a0_.context AS context_11, a0_.sponsor_id AS sponsor_id_12, a0_.space_id AS space_id_13 FROM app_shop_purchase a0_ WHERE a0_.consumed_at IS NULL AND a0_.placement_at IS NULL AND a0_.refunded_at IS NULL AND a0_.sponsor_id = ? SELECT a0_.id AS id_0, a0_.payment_stripe_id AS payment_stripe_id_1, a0_.customer_stripe_id AS customer_stripe_id_2, a0_.payment_at AS payment_at_3, a0_.amount_in_moneybag AS amount_in_moneybag_4, a0_.points_in_left AS points_in_left_5, a0_.points_in_right AS points_in_right_6, a0_.begin_validity_at AS begin_validity_at_7, a0_.consumed_at AS consumed_at_8, a0_.placement_at AS placement_at_9, a0_.refunded_at AS refunded_at_10, a0_.context AS context_11, a0_.sponsor_id AS sponsor_id_12, a0_.space_id AS space_id_13 FROM app_shop_purchase a0_ WHERE a0_.consumed_at IS NULL AND a0_.placement_at IS NULL AND a0_.refunded_at IS NULL AND a0_.sponsor_id = 271587;
17	1.42 ms	SELECT a0_.id AS id_0, a0_.payment_session_id AS payment_session_id_1, a0_.subscription_id AS subscription_id_2, a0_.customer_id AS customer_id_3, a0_.mode AS mode_4, a0_.amount AS amount_5, a0_.currency AS currency_6, a0_.customer_email AS customer_email_7, a0_.date AS date_8, a0_.product AS product_9, a0_.payment_method AS payment_method_10, a0_.setup_intent AS setup_intent_11, a0_.invoice_id AS invoice_id_12, a0_.status AS status_13, a0_.type AS type_14, a0_.provider AS provider_15, a0_.points AS points_16, a0_.subscription_type AS subscription_type_17, a0_.space AS space_18, a0_.context AS context_19, a0_.is_installment AS is_installment_20, a0_.index_installment AS index_installment_21, a0_.is_decreasing AS is_decreasing_22, a0_.decreasing_config_price AS decreasing_config_price_23, a0_.duration AS duration_24, a0_.market AS market_25, a0_.member_id AS member_id_26 FROM app_payment_history a0_ WHERE a0_.type = ? AND a0_.member_id = ? AND a0_.status = ? ORDER BY a0_.date DESC Parameters: [`"formation" 271587 "success"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.payment_session_id AS payment_session_id_1, a0_.subscription_id AS subscription_id_2, a0_.customer_id AS customer_id_3, a0_.mode AS mode_4, a0_.amount AS amount_5, a0_.currency AS currency_6, a0_.customer_email AS customer_email_7, a0_.date AS date_8, a0_.product AS product_9, a0_.payment_method AS payment_method_10, a0_.setup_intent AS setup_intent_11, a0_.invoice_id AS invoice_id_12, a0_.status AS status_13, a0_.type AS type_14, a0_.provider AS provider_15, a0_.points AS points_16, a0_.subscription_type AS subscription_type_17, a0_.space AS space_18, a0_.context AS context_19, a0_.is_installment AS is_installment_20, a0_.index_installment AS index_installment_21, a0_.is_decreasing AS is_decreasing_22, a0_.decreasing_config_price AS decreasing_config_price_23, a0_.duration AS duration_24, a0_.market AS market_25, a0_.member_id AS member_id_26 FROM app_payment_history a0_ WHERE a0_.type = ? AND a0_.member_id = ? AND a0_.status = ? ORDER BY a0_.date DESC SELECT a0_.id AS id_0, a0_.payment_session_id AS payment_session_id_1, a0_.subscription_id AS subscription_id_2, a0_.customer_id AS customer_id_3, a0_.mode AS mode_4, a0_.amount AS amount_5, a0_.currency AS currency_6, a0_.customer_email AS customer_email_7, a0_.date AS date_8, a0_.product AS product_9, a0_.payment_method AS payment_method_10, a0_.setup_intent AS setup_intent_11, a0_.invoice_id AS invoice_id_12, a0_.status AS status_13, a0_.type AS type_14, a0_.provider AS provider_15, a0_.points AS points_16, a0_.subscription_type AS subscription_type_17, a0_.space AS space_18, a0_.context AS context_19, a0_.is_installment AS is_installment_20, a0_.index_installment AS index_installment_21, a0_.is_decreasing AS is_decreasing_22, a0_.decreasing_config_price AS decreasing_config_price_23, a0_.duration AS duration_24, a0_.market AS market_25, a0_.member_id AS member_id_26 FROM app_payment_history a0_ WHERE a0_.type = 'formation' AND a0_.member_id = 271587 AND a0_.status = 'success' ORDER BY a0_.date DESC;
18	1.27 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: [`271587 "pack" 1 "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND a1_.type = 'pack' AND a1_.space_id = 1 AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
19	1.24 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_.name = ? OR a1_.name = ?) AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL Parameters: [`271587 "ikigai" "ikigai-plus" "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND (a1_.name = 'ikigai' OR a1_.name = 'ikigai-plus') AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
20	1.38 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.name = ? LIMIT 1 Parameters: [`"digital"`] View formatted query View runnable query Explain query 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.name = ? LIMIT 1 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.name = 'digital' LIMIT 1;
21	1.15 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.name = ? LIMIT 1 Parameters: [`"ecom"`] View formatted query View runnable query Explain query 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.name = ? LIMIT 1 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.name = 'ecom' LIMIT 1;
22	1.46 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: [`271587 "pack" 1 "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND a1_.type = 'pack' AND a1_.space_id = 1 AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
23	1.24 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_.name = ? OR a1_.name = ?) AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL Parameters: [`271587 "ikigai" "ikigai-plus" "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND (a1_.name = 'ikigai' OR a1_.name = 'ikigai-plus') AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
24	1.46 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 a0_.cancellation_at IS NULL ORDER BY a0_.begin_at DESC Parameters: [`271587 "link"`] View formatted query View runnable query Explain query 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 a0_.cancellation_at IS NULL ORDER BY a0_.begin_at DESC 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 = 271587 AND a1_.type = 'link' AND a0_.cancellation_at IS NULL ORDER BY a0_.begin_at DESC;
25	1.28 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 = ? Parameters: [`271587 "pack" 1`] View formatted query View runnable query Explain query 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 = ? 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 = 271587 AND a1_.type = 'pack' AND a1_.space_id = 1;
26	1.27 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: [`271587 "pack" 1 "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND a1_.type = 'pack' AND a1_.space_id = 1 AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
27	1.25 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_ WHERE a0_.member_id = ? AND a0_.is_qualified = ? AND a0_.cancellation_at IS NULL Parameters: [`271587 1`] View formatted query View runnable query Explain query 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_ WHERE a0_.member_id = ? AND a0_.is_qualified = ? AND a0_.cancellation_at IS NULL 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_ WHERE a0_.member_id = 271587 AND a0_.is_qualified = 1 AND a0_.cancellation_at IS NULL;
28	1.59 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 INNER JOIN mybiz_rank m5_ ON a0_.qualification_id = m5_.id WHERE a0_.qualification_id IS NOT NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC Parameters: [`0 271587`] View formatted query View runnable query Explain query 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 INNER JOIN mybiz_rank m5_ ON a0_.qualification_id = m5_.id WHERE a0_.qualification_id IS NOT NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC 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 INNER JOIN mybiz_rank m5_ ON a0_.qualification_id = m5_.id WHERE a0_.qualification_id IS NOT NULL AND a0_.is_deleted = 0 AND a0_.sponsor_id = 271587 ORDER BY a0_.id ASC;
29	1.79 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 INNER JOIN app_member a5_ ON a0_.sponsor_id = a5_.id INNER JOIN app_subscription a6_ ON a0_.id = a6_.member_id LEFT JOIN app_product a7_ ON a6_.product_id = a7_.id WHERE a6_.end_at > ? AND a6_.cancellation_at IS NULL AND a7_.type = ? AND a6_.is_freedom = 0 AND a6_.is_qualified = 0 AND a0_.is_deleted = ? AND a5_.id = ? ORDER BY a0_.id ASC Parameters: [`"2026-03-04 14:35:19" "pack" 0 271587`] View formatted query View runnable query Explain query 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 INNER JOIN app_member a5_ ON a0_.sponsor_id = a5_.id INNER JOIN app_subscription a6_ ON a0_.id = a6_.member_id LEFT JOIN app_product a7_ ON a6_.product_id = a7_.id WHERE a6_.end_at > ? AND a6_.cancellation_at IS NULL AND a7_.type = ? AND a6_.is_freedom = 0 AND a6_.is_qualified = 0 AND a0_.is_deleted = ? AND a5_.id = ? ORDER BY a0_.id ASC 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 INNER JOIN app_member a5_ ON a0_.sponsor_id = a5_.id INNER JOIN app_subscription a6_ ON a0_.id = a6_.member_id LEFT JOIN app_product a7_ ON a6_.product_id = a7_.id WHERE a6_.end_at > '2026-03-04 14:35:19' AND a6_.cancellation_at IS NULL AND a7_.type = 'pack' AND a6_.is_freedom = 0 AND a6_.is_qualified = 0 AND a0_.is_deleted = 0 AND a5_.id = 271587 ORDER BY a0_.id ASC;
30	1.50 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 INNER JOIN app_shop_purchase a5_ ON a0_.id = a5_.sponsor_id INNER JOIN app_member a6_ ON a5_.sponsor_id = a6_.id WHERE a5_.consumed_at IS NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC Parameters: [`0 271587`] View formatted query View runnable query Explain query 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 INNER JOIN app_shop_purchase a5_ ON a0_.id = a5_.sponsor_id INNER JOIN app_member a6_ ON a5_.sponsor_id = a6_.id WHERE a5_.consumed_at IS NULL AND a0_.is_deleted = ? AND a0_.sponsor_id = ? ORDER BY a0_.id ASC 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 INNER JOIN app_shop_purchase a5_ ON a0_.id = a5_.sponsor_id INNER JOIN app_member a6_ ON a5_.sponsor_id = a6_.id WHERE a5_.consumed_at IS NULL AND a0_.is_deleted = 0 AND a0_.sponsor_id = 271587 ORDER BY a0_.id ASC;
31	1.21 ms	SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ? Parameters: [`6597919 "left" 475834`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ? SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = 6597919 AND m0_.position_for_parent = 'left' AND m0_.tree_id = 475834;
32	1.08 ms	SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ? Parameters: [`6597919 "right" 475834`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = ? AND m0_.position_for_parent = ? AND m0_.tree_id = ? SELECT m0_.id AS id_0, m0_.position_for_parent AS position_for_parent_1, m0_.depth AS depth_2, m0_.left_index AS left_index_3, m0_.right_index AS right_index_4, m0_.nb_node_points AS nb_node_points_5, m0_.nb_total_points AS nb_total_points_6, m0_.parent_node_id AS parent_node_id_7, m0_.member_id AS member_id_8, m0_.tree_id AS tree_id_9 FROM mybiz_member_node m0_ WHERE m0_.parent_node_id = 6597919 AND m0_.position_for_parent = 'right' AND m0_.tree_id = 475834;
33	1.13 ms	SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.marketing_name AS marketing_name_2, m0_.image AS image_3, m0_.residual AS residual_4, m0_.saving_bonus_amount AS saving_bonus_amount_5, m0_.level AS level_6, m0_.min_direct_clients AS min_direct_clients_7, m0_.representative_client AS representative_client_8, m0_.min_direct_points AS min_direct_points_9, m0_.min_left_points AS min_left_points_10, m0_.min_right_points AS min_right_points_11, m0_.is_in_progression AS is_in_progression_12 FROM mybiz_rank m0_ WHERE m0_.min_left_points <= ? AND m0_.min_right_points <= ? AND m0_.min_direct_points <= ? AND m0_.level > ? ORDER BY m0_.level DESC LIMIT 1 Parameters: [`0 0 0 1`] View formatted query View runnable query Explain query SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.marketing_name AS marketing_name_2, m0_.image AS image_3, m0_.residual AS residual_4, m0_.saving_bonus_amount AS saving_bonus_amount_5, m0_.level AS level_6, m0_.min_direct_clients AS min_direct_clients_7, m0_.representative_client AS representative_client_8, m0_.min_direct_points AS min_direct_points_9, m0_.min_left_points AS min_left_points_10, m0_.min_right_points AS min_right_points_11, m0_.is_in_progression AS is_in_progression_12 FROM mybiz_rank m0_ WHERE m0_.min_left_points <= ? AND m0_.min_right_points <= ? AND m0_.min_direct_points <= ? AND m0_.level > ? ORDER BY m0_.level DESC LIMIT 1 SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.marketing_name AS marketing_name_2, m0_.image AS image_3, m0_.residual AS residual_4, m0_.saving_bonus_amount AS saving_bonus_amount_5, m0_.level AS level_6, m0_.min_direct_clients AS min_direct_clients_7, m0_.representative_client AS representative_client_8, m0_.min_direct_points AS min_direct_points_9, m0_.min_left_points AS min_left_points_10, m0_.min_right_points AS min_right_points_11, m0_.is_in_progression AS is_in_progression_12 FROM mybiz_rank m0_ WHERE m0_.min_left_points <= 0 AND m0_.min_right_points <= 0 AND m0_.min_direct_points <= 0 AND m0_.level > 1 ORDER BY m0_.level DESC LIMIT 1;
34	1.28 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: [`271587 "pack" 1 "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND a1_.type = 'pack' AND a1_.space_id = 1 AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
35	1.27 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_.name = ? OR a1_.name = ?) AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL Parameters: [`271587 "ikigai" "ikigai-plus" "2026-03-04 14:35:19" "2026-03-04 14:35:19"`] View formatted query View runnable query Explain query 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 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 = 271587 AND (a1_.name = 'ikigai' OR a1_.name = 'ikigai-plus') AND a0_.begin_at <= '2026-03-04 14:35:19' AND a0_.end_at >= '2026-03-04 14:35:19' AND a0_.cancellation_at IS NULL;
36	1.24 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.type AS type_4, t0.description AS description_5, t0.s3_path AS s3_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.member_id AS member_id_9 FROM app_member_document t0 WHERE t0.member_id = ? AND t0.type = ? LIMIT 1 Parameters: [`271587 "avatar"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.type AS type_4, t0.description AS description_5, t0.s3_path AS s3_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.member_id AS member_id_9 FROM app_member_document t0 WHERE t0.member_id = ? AND t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.status AS status_3, t0.type AS type_4, t0.description AS description_5, t0.s3_path AS s3_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.member_id AS member_id_9 FROM app_member_document t0 WHERE t0.member_id = 271587 AND t0.type = 'avatar' LIMIT 1;
37	1.35 ms	SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.customer_id AS customer_id_3, t0.card_id AS card_id_4, t0.payment_agreement_id AS payment_agreement_id_5, t0.begin_at AS begin_at_6, t0.end_at AS end_at_7, t0.cancellation_request_at AS cancellation_request_at_8, t0.cancellation_at AS cancellation_at_9, t0.refunded_at AS refunded_at_10, t0.quantity AS quantity_11, t0.created_at AS created_at_12, t0.futures_pack_name AS futures_pack_name_13, t0.luume_pack_name AS luume_pack_name_14, t0.sent_to_luume_at AS sent_to_luume_at_15, t0.context AS context_16, t0.is_freedom AS is_freedom_17, t0.is_qualified AS is_qualified_18, t0.duration_total AS duration_total_19, t0.has_full_points_distributed AS has_full_points_distributed_20, t0.current_subscription_month AS current_subscription_month_21, t0.freedom_duration AS freedom_duration_22, t0.freedom_total_duration AS freedom_total_duration_23, t0.total_prediction AS total_prediction_24, t0.consumed_prediction AS consumed_prediction_25, t0.decreasing_config_price AS decreasing_config_price_26, t0.is_decreasing AS is_decreasing_27, t0.member_id AS member_id_28, t0.gateway_id AS gateway_id_29, t0.country_id AS country_id_30, t0.product_id AS product_id_31, t0.payment_history_id AS payment_history_id_32, t0.previous_subscription_id AS previous_subscription_id_33, t0.initial_product_id AS initial_product_id_34 FROM app_subscription t0 WHERE t0.member_id = ? Parameters: [`271587`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.customer_id AS customer_id_3, t0.card_id AS card_id_4, t0.payment_agreement_id AS payment_agreement_id_5, t0.begin_at AS begin_at_6, t0.end_at AS end_at_7, t0.cancellation_request_at AS cancellation_request_at_8, t0.cancellation_at AS cancellation_at_9, t0.refunded_at AS refunded_at_10, t0.quantity AS quantity_11, t0.created_at AS created_at_12, t0.futures_pack_name AS futures_pack_name_13, t0.luume_pack_name AS luume_pack_name_14, t0.sent_to_luume_at AS sent_to_luume_at_15, t0.context AS context_16, t0.is_freedom AS is_freedom_17, t0.is_qualified AS is_qualified_18, t0.duration_total AS duration_total_19, t0.has_full_points_distributed AS has_full_points_distributed_20, t0.current_subscription_month AS current_subscription_month_21, t0.freedom_duration AS freedom_duration_22, t0.freedom_total_duration AS freedom_total_duration_23, t0.total_prediction AS total_prediction_24, t0.consumed_prediction AS consumed_prediction_25, t0.decreasing_config_price AS decreasing_config_price_26, t0.is_decreasing AS is_decreasing_27, t0.member_id AS member_id_28, t0.gateway_id AS gateway_id_29, t0.country_id AS country_id_30, t0.product_id AS product_id_31, t0.payment_history_id AS payment_history_id_32, t0.previous_subscription_id AS previous_subscription_id_33, t0.initial_product_id AS initial_product_id_34 FROM app_subscription t0 WHERE t0.member_id = ? SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.customer_id AS customer_id_3, t0.card_id AS card_id_4, t0.payment_agreement_id AS payment_agreement_id_5, t0.begin_at AS begin_at_6, t0.end_at AS end_at_7, t0.cancellation_request_at AS cancellation_request_at_8, t0.cancellation_at AS cancellation_at_9, t0.refunded_at AS refunded_at_10, t0.quantity AS quantity_11, t0.created_at AS created_at_12, t0.futures_pack_name AS futures_pack_name_13, t0.luume_pack_name AS luume_pack_name_14, t0.sent_to_luume_at AS sent_to_luume_at_15, t0.context AS context_16, t0.is_freedom AS is_freedom_17, t0.is_qualified AS is_qualified_18, t0.duration_total AS duration_total_19, t0.has_full_points_distributed AS has_full_points_distributed_20, t0.current_subscription_month AS current_subscription_month_21, t0.freedom_duration AS freedom_duration_22, t0.freedom_total_duration AS freedom_total_duration_23, t0.total_prediction AS total_prediction_24, t0.consumed_prediction AS consumed_prediction_25, t0.decreasing_config_price AS decreasing_config_price_26, t0.is_decreasing AS is_decreasing_27, t0.member_id AS member_id_28, t0.gateway_id AS gateway_id_29, t0.country_id AS country_id_30, t0.product_id AS product_id_31, t0.payment_history_id AS payment_history_id_32, t0.previous_subscription_id AS previous_subscription_id_33, t0.initial_product_id AS initial_product_id_34 FROM app_subscription t0 WHERE t0.member_id = 271587;
38	1.31 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"`] View formatted query View runnable query Explain query 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 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 = 'mybiz' LIMIT 1;
39	1.36 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.type = ? AND t0.space_id = ? LIMIT 1 Parameters: [`"license" 3`] View formatted query View runnable query Explain query 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.type = ? AND t0.space_id = ? LIMIT 1 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.type = 'license' AND t0.space_id = 3 LIMIT 1;
40	1.33 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.mandate AS mandate_4, t0.is_enabled AS is_enabled_5 FROM app_currency t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"EUR"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.mandate AS mandate_4, t0.is_enabled AS is_enabled_5 FROM app_currency t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.code AS code_2, t0.symbol AS symbol_3, t0.mandate AS mandate_4, t0.is_enabled AS is_enabled_5 FROM app_currency t0 WHERE t0.code = 'EUR' LIMIT 1;
41	1.18 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_rate AS tax_rate_3, t0.type AS type_4, t0.is_default AS is_default_5, t0.marketing_name AS marketing_name_6, t0.marketing_description AS marketing_description_7, t0.enabled AS enabled_8, t0.is_debitable AS is_debitable_9 FROM app_gateway t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"copecart"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_rate AS tax_rate_3, t0.type AS type_4, t0.is_default AS is_default_5, t0.marketing_name AS marketing_name_6, t0.marketing_description AS marketing_description_7, t0.enabled AS enabled_8, t0.is_debitable AS is_debitable_9 FROM app_gateway t0 WHERE t0.name = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_rate AS tax_rate_3, t0.type AS type_4, t0.is_default AS is_default_5, t0.marketing_name AS marketing_name_6, t0.marketing_description AS marketing_description_7, t0.enabled AS enabled_8, t0.is_debitable AS is_debitable_9 FROM app_gateway t0 WHERE t0.name = 'copecart' LIMIT 1;
42	1.49 ms	SELECT t0.id AS id_1, t0.nb_month AS nb_month_2, t0.first_price AS first_price_3, t0.subscription_price AS subscription_price_4, t0.first_commission AS first_commission_5, t0.subscription_commission AS subscription_commission_6, t0.commission_month1 AS commission_month1_7, t0.commission_month2 AS commission_month2_8, t0.commission_month3 AS commission_month3_9, t0.copecart_product_id_with_first_price AS copecart_product_id_with_first_price_10, t0.copecart_product_id_only_subscription AS copecart_product_id_only_subscription_11, t0.is_enabled AS is_enabled_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.market_id AS market_id_15 FROM app_product_price t0 WHERE t0.product_id = ? AND t0.market_id = ? AND t0.currency_id = ? AND t0.nb_month = ? LIMIT 1 Parameters: [`10 1 4 12`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nb_month AS nb_month_2, t0.first_price AS first_price_3, t0.subscription_price AS subscription_price_4, t0.first_commission AS first_commission_5, t0.subscription_commission AS subscription_commission_6, t0.commission_month1 AS commission_month1_7, t0.commission_month2 AS commission_month2_8, t0.commission_month3 AS commission_month3_9, t0.copecart_product_id_with_first_price AS copecart_product_id_with_first_price_10, t0.copecart_product_id_only_subscription AS copecart_product_id_only_subscription_11, t0.is_enabled AS is_enabled_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.market_id AS market_id_15 FROM app_product_price t0 WHERE t0.product_id = ? AND t0.market_id = ? AND t0.currency_id = ? AND t0.nb_month = ? LIMIT 1 SELECT t0.id AS id_1, t0.nb_month AS nb_month_2, t0.first_price AS first_price_3, t0.subscription_price AS subscription_price_4, t0.first_commission AS first_commission_5, t0.subscription_commission AS subscription_commission_6, t0.commission_month1 AS commission_month1_7, t0.commission_month2 AS commission_month2_8, t0.commission_month3 AS commission_month3_9, t0.copecart_product_id_with_first_price AS copecart_product_id_with_first_price_10, t0.copecart_product_id_only_subscription AS copecart_product_id_only_subscription_11, t0.is_enabled AS is_enabled_12, t0.product_id AS product_id_13, t0.currency_id AS currency_id_14, t0.market_id AS market_id_15 FROM app_product_price t0 WHERE t0.product_id = 10 AND t0.market_id = 1 AND t0.currency_id = 4 AND t0.nb_month = 12 LIMIT 1;
43	1.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.suffix AS suffix_4, t0.is_promotional AS is_promotional_5 FROM app_market t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.suffix AS suffix_4, t0.is_promotional AS is_promotional_5 FROM app_market t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.suffix AS suffix_4, t0.is_promotional AS is_promotional_5 FROM app_market t0 WHERE t0.id = 1;
44	1.28 ms	SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.addition AS addition_4, t0.zip AS zip_5, t0.city AS city_6, t0.state AS state_7, t0.country_code AS country_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.user_id AS user_id_11 FROM app_user_address t0 WHERE t0.user_id = ? Parameters: [`187842`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.addition AS addition_4, t0.zip AS zip_5, t0.city AS city_6, t0.state AS state_7, t0.country_code AS country_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.user_id AS user_id_11 FROM app_user_address t0 WHERE t0.user_id = ? SELECT t0.id AS id_1, t0.street AS street_2, t0.number AS number_3, t0.addition AS addition_4, t0.zip AS zip_5, t0.city AS city_6, t0.state AS state_7, t0.country_code AS country_code_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.user_id AS user_id_11 FROM app_user_address t0 WHERE t0.user_id = 187842;
45	1.25 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.name_en AS name_en_5, t0.name_fr AS name_fr_6, t0.is_in_mybiz_onboarding AS is_in_mybiz_onboarding_7, t0.is_in_qualified_choice AS is_in_qualified_choice_8, t0.market_id AS market_id_9 FROM app_country t0 WHERE t0.id = ? Parameters: [`75`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.name_en AS name_en_5, t0.name_fr AS name_fr_6, t0.is_in_mybiz_onboarding AS is_in_mybiz_onboarding_7, t0.is_in_qualified_choice AS is_in_qualified_choice_8, t0.market_id AS market_id_9 FROM app_country t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.name_en AS name_en_5, t0.name_fr AS name_fr_6, t0.is_in_mybiz_onboarding AS is_in_mybiz_onboarding_7, t0.is_in_qualified_choice AS is_in_qualified_choice_8, t0.market_id AS market_id_9 FROM app_country t0 WHERE t0.id = 75;
46	1.50 ms	SELECT t0.id AS id_1, t0.position AS position_2, t0.status AS status_3, t0.member_date AS member_date_4, t0.enabled AS enabled_5, t0.is_insider AS is_insider_6, t0.accept_offers AS accept_offers_7, t0.accept_terms_date AS accept_terms_date_8, t0.has_premium_deducted AS has_premium_deducted_9, t0.liberty_pack AS liberty_pack_10, t0.preferred_language AS preferred_language_11, t0.saving_bonus AS saving_bonus_12, t0.saving_bonus_reached_at AS saving_bonus_reached_at_13, t0.signup_ip_address AS signup_ip_address_14, t0.is_new AS is_new_15, t0.birthday AS birthday_16, t0.last_sponsor_attribution_at AS last_sponsor_attribution_at_17, t0.is_offered_sponsor AS is_offered_sponsor_18, t0.discord_id AS discord_id_19, t0.step_elite AS step_elite_20, t0.is_deleted AS is_deleted_21, t0.theme AS theme_22, t0.sponsor_id AS sponsor_id_23, t0.parent_id AS parent_id_24, t0.rank_id AS rank_id_25, t0.pack_id AS pack_id_26, t0.user_id AS user_id_27, t28.id AS id_29, t28.position_for_parent AS position_for_parent_30, t28.depth AS depth_31, t28.left_index AS left_index_32, t28.right_index AS right_index_33, t28.nb_node_points AS nb_node_points_34, t28.nb_total_points AS nb_total_points_35, t28.parent_node_id AS parent_node_id_36, t28.member_id AS member_id_37, t28.tree_id AS tree_id_38, t0.market_id AS market_id_39, t0.qualification_id AS qualification_id_40, t41.id AS id_42, t41.nb_predictions AS nb_predictions_43, t41.member_id AS member_id_44, t0.subscription_gateway_id AS subscription_gateway_id_45, t0.subscription_country_id AS subscription_country_id_46, t0.currency_id AS currency_id_47, t0.first_subscription_space_id AS first_subscription_space_id_48, t49.id AS id_50, t49.pack_name AS pack_name_51, t49.created_at AS created_at_52, t49.updated_at AS updated_at_53, t49.shipping_method_id AS shipping_method_id_54, t49.fees_in_cents AS fees_in_cents_55, t49.futures_product AS futures_product_56, t49.luume_product AS luume_product_57, t49.is_over AS is_over_58, t49.address_first_name AS address_first_name_59, t49.address_last_name AS address_last_name_60, t49.address_street AS address_street_61, t49.address_postcode AS address_postcode_62, t49.address_city AS address_city_63, t49.address_country_code AS address_country_code_64, t49.relay_name AS relay_name_65, t49.relay_ref AS relay_ref_66, t49.relay_street AS relay_street_67, t49.relay_city AS relay_city_68, t49.relay_postcode AS relay_postcode_69, t49.relay_country_code AS relay_country_code_70, t49.member_id AS member_id_71, t72.id AS id_73, t72.limit_date AS limit_date_74, t72.kyc_validated_at AS kyc_validated_at_75, t72.siret_validated_at AS siret_validated_at_76, t72.company_immatriculation_validated_at AS company_immatriculation_validated_at_77, t72.declaration_validated_at AS declaration_validated_at_78, t72.company_vigilance_validated_at AS company_vigilance_validated_at_79, t72.contract_validated_at AS contract_validated_at_80, t72.company_status AS company_status_81, t72.company_umbrella AS company_umbrella_82, t72.company_name AS company_name_83, t72.kyc_first_name AS kyc_first_name_84, t72.kyc_last_name AS kyc_last_name_85, t72.kyc_birthday AS kyc_birthday_86, t72.company_siren AS company_siren_87, t72.company_address_street AS company_address_street_88, t72.company_address_postcode AS company_address_postcode_89, t72.company_address_city AS company_address_city_90, t72.applicant_id AS applicant_id_91, t72.workflow_run_id AS workflow_run_id_92, t72.sdk_token AS sdk_token_93, t72.kyc_status AS kyc_status_94, t72.certified_at AS certified_at_95, t72.is_kyc_infos_extracted AS is_kyc_infos_extracted_96, t72.certified_popup_closed_at AS certified_popup_closed_at_97, t72.academy_popup_closed_at AS academy_popup_closed_at_98, t72.member_id AS member_id_99, t72.company_country_id AS company_country_id_100, t72.company_immatriculation_file_id AS company_immatriculation_file_id_101, t72.company_vigilance_file_id AS company_vigilance_file_id_102, t72.contract_file_id AS contract_file_id_103, t72.certification_file_id AS certification_file_id_104 FROM app_member t0 LEFT JOIN mybiz_member_node t28 ON t28.member_id = t0.id LEFT JOIN app_member_prediction t41 ON t41.member_id = t0.id LEFT JOIN mybiz_qualified_choice t49 ON t49.member_id = t0.id LEFT JOIN mybiz_on_boarding t72 ON t72.member_id = t0.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.position AS position_2, t0.status AS status_3, t0.member_date AS member_date_4, t0.enabled AS enabled_5, t0.is_insider AS is_insider_6, t0.accept_offers AS accept_offers_7, t0.accept_terms_date AS accept_terms_date_8, t0.has_premium_deducted AS has_premium_deducted_9, t0.liberty_pack AS liberty_pack_10, t0.preferred_language AS preferred_language_11, t0.saving_bonus AS saving_bonus_12, t0.saving_bonus_reached_at AS saving_bonus_reached_at_13, t0.signup_ip_address AS signup_ip_address_14, t0.is_new AS is_new_15, t0.birthday AS birthday_16, t0.last_sponsor_attribution_at AS last_sponsor_attribution_at_17, t0.is_offered_sponsor AS is_offered_sponsor_18, t0.discord_id AS discord_id_19, t0.step_elite AS step_elite_20, t0.is_deleted AS is_deleted_21, t0.theme AS theme_22, t0.sponsor_id AS sponsor_id_23, t0.parent_id AS parent_id_24, t0.rank_id AS rank_id_25, t0.pack_id AS pack_id_26, t0.user_id AS user_id_27, t28.id AS id_29, t28.position_for_parent AS position_for_parent_30, t28.depth AS depth_31, t28.left_index AS left_index_32, t28.right_index AS right_index_33, t28.nb_node_points AS nb_node_points_34, t28.nb_total_points AS nb_total_points_35, t28.parent_node_id AS parent_node_id_36, t28.member_id AS member_id_37, t28.tree_id AS tree_id_38, t0.market_id AS market_id_39, t0.qualification_id AS qualification_id_40, t41.id AS id_42, t41.nb_predictions AS nb_predictions_43, t41.member_id AS member_id_44, t0.subscription_gateway_id AS subscription_gateway_id_45, t0.subscription_country_id AS subscription_country_id_46, t0.currency_id AS currency_id_47, t0.first_subscription_space_id AS first_subscription_space_id_48, t49.id AS id_50, t49.pack_name AS pack_name_51, t49.created_at AS created_at_52, t49.updated_at AS updated_at_53, t49.shipping_method_id AS shipping_method_id_54, t49.fees_in_cents AS fees_in_cents_55, t49.futures_product AS futures_product_56, t49.luume_product AS luume_product_57, t49.is_over AS is_over_58, t49.address_first_name AS address_first_name_59, t49.address_last_name AS address_last_name_60, t49.address_street AS address_street_61, t49.address_postcode AS address_postcode_62, t49.address_city AS address_city_63, t49.address_country_code AS address_country_code_64, t49.relay_name AS relay_name_65, t49.relay_ref AS relay_ref_66, t49.relay_street AS relay_street_67, t49.relay_city AS relay_city_68, t49.relay_postcode AS relay_postcode_69, t49.relay_country_code AS relay_country_code_70, t49.member_id AS member_id_71, t72.id AS id_73, t72.limit_date AS limit_date_74, t72.kyc_validated_at AS kyc_validated_at_75, t72.siret_validated_at AS siret_validated_at_76, t72.company_immatriculation_validated_at AS company_immatriculation_validated_at_77, t72.declaration_validated_at AS declaration_validated_at_78, t72.company_vigilance_validated_at AS company_vigilance_validated_at_79, t72.contract_validated_at AS contract_validated_at_80, t72.company_status AS company_status_81, t72.company_umbrella AS company_umbrella_82, t72.company_name AS company_name_83, t72.kyc_first_name AS kyc_first_name_84, t72.kyc_last_name AS kyc_last_name_85, t72.kyc_birthday AS kyc_birthday_86, t72.company_siren AS company_siren_87, t72.company_address_street AS company_address_street_88, t72.company_address_postcode AS company_address_postcode_89, t72.company_address_city AS company_address_city_90, t72.applicant_id AS applicant_id_91, t72.workflow_run_id AS workflow_run_id_92, t72.sdk_token AS sdk_token_93, t72.kyc_status AS kyc_status_94, t72.certified_at AS certified_at_95, t72.is_kyc_infos_extracted AS is_kyc_infos_extracted_96, t72.certified_popup_closed_at AS certified_popup_closed_at_97, t72.academy_popup_closed_at AS academy_popup_closed_at_98, t72.member_id AS member_id_99, t72.company_country_id AS company_country_id_100, t72.company_immatriculation_file_id AS company_immatriculation_file_id_101, t72.company_vigilance_file_id AS company_vigilance_file_id_102, t72.contract_file_id AS contract_file_id_103, t72.certification_file_id AS certification_file_id_104 FROM app_member t0 LEFT JOIN mybiz_member_node t28 ON t28.member_id = t0.id LEFT JOIN app_member_prediction t41 ON t41.member_id = t0.id LEFT JOIN mybiz_qualified_choice t49 ON t49.member_id = t0.id LEFT JOIN mybiz_on_boarding t72 ON t72.member_id = t0.id WHERE t0.id = ? SELECT t0.id AS id_1, t0.position AS position_2, t0.status AS status_3, t0.member_date AS member_date_4, t0.enabled AS enabled_5, t0.is_insider AS is_insider_6, t0.accept_offers AS accept_offers_7, t0.accept_terms_date AS accept_terms_date_8, t0.has_premium_deducted AS has_premium_deducted_9, t0.liberty_pack AS liberty_pack_10, t0.preferred_language AS preferred_language_11, t0.saving_bonus AS saving_bonus_12, t0.saving_bonus_reached_at AS saving_bonus_reached_at_13, t0.signup_ip_address AS signup_ip_address_14, t0.is_new AS is_new_15, t0.birthday AS birthday_16, t0.last_sponsor_attribution_at AS last_sponsor_attribution_at_17, t0.is_offered_sponsor AS is_offered_sponsor_18, t0.discord_id AS discord_id_19, t0.step_elite AS step_elite_20, t0.is_deleted AS is_deleted_21, t0.theme AS theme_22, t0.sponsor_id AS sponsor_id_23, t0.parent_id AS parent_id_24, t0.rank_id AS rank_id_25, t0.pack_id AS pack_id_26, t0.user_id AS user_id_27, t28.id AS id_29, t28.position_for_parent AS position_for_parent_30, t28.depth AS depth_31, t28.left_index AS left_index_32, t28.right_index AS right_index_33, t28.nb_node_points AS nb_node_points_34, t28.nb_total_points AS nb_total_points_35, t28.parent_node_id AS parent_node_id_36, t28.member_id AS member_id_37, t28.tree_id AS tree_id_38, t0.market_id AS market_id_39, t0.qualification_id AS qualification_id_40, t41.id AS id_42, t41.nb_predictions AS nb_predictions_43, t41.member_id AS member_id_44, t0.subscription_gateway_id AS subscription_gateway_id_45, t0.subscription_country_id AS subscription_country_id_46, t0.currency_id AS currency_id_47, t0.first_subscription_space_id AS first_subscription_space_id_48, t49.id AS id_50, t49.pack_name AS pack_name_51, t49.created_at AS created_at_52, t49.updated_at AS updated_at_53, t49.shipping_method_id AS shipping_method_id_54, t49.fees_in_cents AS fees_in_cents_55, t49.futures_product AS futures_product_56, t49.luume_product AS luume_product_57, t49.is_over AS is_over_58, t49.address_first_name AS address_first_name_59, t49.address_last_name AS address_last_name_60, t49.address_street AS address_street_61, t49.address_postcode AS address_postcode_62, t49.address_city AS address_city_63, t49.address_country_code AS address_country_code_64, t49.relay_name AS relay_name_65, t49.relay_ref AS relay_ref_66, t49.relay_street AS relay_street_67, t49.relay_city AS relay_city_68, t49.relay_postcode AS relay_postcode_69, t49.relay_country_code AS relay_country_code_70, t49.member_id AS member_id_71, t72.id AS id_73, t72.limit_date AS limit_date_74, t72.kyc_validated_at AS kyc_validated_at_75, t72.siret_validated_at AS siret_validated_at_76, t72.company_immatriculation_validated_at AS company_immatriculation_validated_at_77, t72.declaration_validated_at AS declaration_validated_at_78, t72.company_vigilance_validated_at AS company_vigilance_validated_at_79, t72.contract_validated_at AS contract_validated_at_80, t72.company_status AS company_status_81, t72.company_umbrella AS company_umbrella_82, t72.company_name AS company_name_83, t72.kyc_first_name AS kyc_first_name_84, t72.kyc_last_name AS kyc_last_name_85, t72.kyc_birthday AS kyc_birthday_86, t72.company_siren AS company_siren_87, t72.company_address_street AS company_address_street_88, t72.company_address_postcode AS company_address_postcode_89, t72.company_address_city AS company_address_city_90, t72.applicant_id AS applicant_id_91, t72.workflow_run_id AS workflow_run_id_92, t72.sdk_token AS sdk_token_93, t72.kyc_status AS kyc_status_94, t72.certified_at AS certified_at_95, t72.is_kyc_infos_extracted AS is_kyc_infos_extracted_96, t72.certified_popup_closed_at AS certified_popup_closed_at_97, t72.academy_popup_closed_at AS academy_popup_closed_at_98, t72.member_id AS member_id_99, t72.company_country_id AS company_country_id_100, t72.company_immatriculation_file_id AS company_immatriculation_file_id_101, t72.company_vigilance_file_id AS company_vigilance_file_id_102, t72.contract_file_id AS contract_file_id_103, t72.certification_file_id AS certification_file_id_104 FROM app_member t0 LEFT JOIN mybiz_member_node t28 ON t28.member_id = t0.id LEFT JOIN app_member_prediction t41 ON t41.member_id = t0.id LEFT JOIN mybiz_qualified_choice t49 ON t49.member_id = t0.id LEFT JOIN mybiz_on_boarding t72 ON t72.member_id = t0.id WHERE t0.id = 1;
47	1.35 ms	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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query 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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.id = ? 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.signup_ip_address AS signup_ip_address_32, t18.is_new AS is_new_33, t18.birthday AS birthday_34, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_35, t18.is_offered_sponsor AS is_offered_sponsor_36, t18.discord_id AS discord_id_37, t18.step_elite AS step_elite_38, t18.is_deleted AS is_deleted_39, t18.theme AS theme_40, t18.sponsor_id AS sponsor_id_41, t18.parent_id AS parent_id_42, t18.rank_id AS rank_id_43, t18.pack_id AS pack_id_44, t18.user_id AS user_id_45, t18.market_id AS market_id_46, t18.qualification_id AS qualification_id_47, t18.subscription_gateway_id AS subscription_gateway_id_48, t18.subscription_country_id AS subscription_country_id_49, t18.currency_id AS currency_id_50, t18.first_subscription_space_id AS first_subscription_space_id_51 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.id = 1;

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\Mybiz\Rank	11
App\Entity\Product\Product	4
App\Entity\Space\Space	3
App\Entity\Member\User	2
App\Entity\Member\Member	2
App\Entity\Mybiz\MemberNode	2
App\Entity\Mybiz\Tree	2
App\Entity\Parameter\Country	2
App\Entity\Parameter\Gateway	2
App\Entity\Member\MemberDocument	2
App\Entity\Parameter\Parameter	1
App\Entity\Parameter\Market	1
App\Entity\Parameter\Currency	1
App\Entity\Product\ProductPrice	1
App\Entity\Member\UserAddress	1
App\Entity\Mybiz\QualifiedChoice	1
App\Entity\Mybiz\MybizOnBoarding	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\Mybiz\Rank	No errors.
App\Entity\Member\User	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\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\Mybiz\MemberNode	No errors.
App\Entity\Mybiz\Tree	No errors.
App\Entity\Member\MemberPrediction	No errors.
App\Entity\Mybiz\MoneyBag	No errors.
App\Entity\Member\MemberDocument	No errors.
App\Entity\Member\MemberNotification	No errors.
App\Entity\Payment\Subscription	No errors.
App\Entity\Mybiz\MemberSocialNetwork	No errors.
App\Entity\Mybiz\QualifiedChoice	No errors.
App\Entity\Mybiz\MybizOnBoarding	No errors.
App\Entity\Payment\PaymentHistory	No errors.
App\Entity\Mybiz\AmbassadorInvoice	No errors.
App\Entity\Member\UserEvent	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.

Symfony Profiler

POST https://dev.my-biz.pro/v1/member/informations

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping