Symfony Profiler

SELECT
  DISTINCT a0_.id AS id_0
FROM
  app_member a0_
  INNER JOIN app_user a1_ ON a0_.user_id = a1_.id
  INNER JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_id
  LEFT JOIN app_subscription a3_ ON a0_.id = a3_.member_id
  LEFT JOIN app_product a4_ ON a3_.product_id = a4_.id
WHERE
  m2_.left_index > ?
  AND m2_.right_index < ?
  AND m2_.tree_id = ?
  AND a0_.id <> ?
  AND a0_.is_deleted = ?
ORDER BY
  a0_.id DESC
LIMIT
  30

SELECT DISTINCT a0_.id AS id_0 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id INNER JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_id LEFT JOIN app_subscription a3_ ON a0_.id = a3_.member_id LEFT JOIN app_product a4_ ON a3_.product_id = a4_.id WHERE m2_.left_index > 5 AND m2_.right_index < 209882 AND m2_.tree_id = 495963 AND a0_.id <> 8 AND a0_.is_deleted = 0 ORDER BY a0_.id DESC LIMIT 30;

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 = 274138;

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.new_qualified_choice_popup_closed_at AS new_qualified_choice_popup_closed_at_10,
  t0.address_first_name AS address_first_name_11,
  t0.address_last_name AS address_last_name_12,
  t0.address_street AS address_street_13,
  t0.address_postcode AS address_postcode_14,
  t0.address_city AS address_city_15,
  t0.address_country_code AS address_country_code_16,
  t0.relay_name AS relay_name_17,
  t0.relay_ref AS relay_ref_18,
  t0.relay_street AS relay_street_19,
  t0.relay_city AS relay_city_20,
  t0.relay_postcode AS relay_postcode_21,
  t0.relay_country_code AS relay_country_code_22,
  t0.member_id AS member_id_23
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.new_qualified_choice_popup_closed_at AS new_qualified_choice_popup_closed_at_10, t0.address_first_name AS address_first_name_11, t0.address_last_name AS address_last_name_12, t0.address_street AS address_street_13, t0.address_postcode AS address_postcode_14, t0.address_city AS address_city_15, t0.address_country_code AS address_country_code_16, t0.relay_name AS relay_name_17, t0.relay_ref AS relay_ref_18, t0.relay_street AS relay_street_19, t0.relay_city AS relay_city_20, t0.relay_postcode AS relay_postcode_21, t0.relay_country_code AS relay_country_code_22, t0.member_id AS member_id_23 FROM mybiz_qualified_choice t0 WHERE t0.member_id = 274138;

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;

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 = 8;

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 = 7065491 AND m0_.position_for_parent = 'left' AND m0_.tree_id = 495963;

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 = 26691;

SELECT
  DISTINCT 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,
  a2_.id AS id_39,
  a2_.name AS name_40,
  a2_.enabled AS enabled_41,
  a2_.suffix AS suffix_42,
  a2_.is_promotional AS is_promotional_43,
  m3_.id AS id_44,
  m3_.position_for_parent AS position_for_parent_45,
  m3_.depth AS depth_46,
  m3_.left_index AS left_index_47,
  m3_.right_index AS right_index_48,
  m3_.nb_node_points AS nb_node_points_49,
  m3_.nb_total_points AS nb_total_points_50,
  a4_.id AS id_51,
  a4_.position AS position_52,
  a4_.status AS status_53,
  a4_.member_date AS member_date_54,
  a4_.enabled AS enabled_55,
  a4_.is_insider AS is_insider_56,
  a4_.accept_offers AS accept_offers_57,
  a4_.accept_terms_date AS accept_terms_date_58,
  a4_.has_premium_deducted AS has_premium_deducted_59,
  a4_.liberty_pack AS liberty_pack_60,
  a4_.preferred_language AS preferred_language_61,
  a4_.saving_bonus AS saving_bonus_62,
  a4_.saving_bonus_reached_at AS saving_bonus_reached_at_63,
  a4_.signup_ip_address AS signup_ip_address_64,
  a4_.is_new AS is_new_65,
  a4_.birthday AS birthday_66,
  a4_.last_sponsor_attribution_at AS last_sponsor_attribution_at_67,
  a4_.is_offered_sponsor AS is_offered_sponsor_68,
  a4_.discord_id AS discord_id_69,
  a4_.step_elite AS step_elite_70,
  a4_.is_deleted AS is_deleted_71,
  a4_.theme AS theme_72,
  m5_.id AS id_73,
  m5_.name AS name_74,
  m5_.marketing_name AS marketing_name_75,
  m5_.image AS image_76,
  m5_.residual AS residual_77,
  m5_.saving_bonus_amount AS saving_bonus_amount_78,
  m5_.level AS level_79,
  m5_.min_direct_clients AS min_direct_clients_80,
  m5_.representative_client AS representative_client_81,
  m5_.min_direct_points AS min_direct_points_82,
  m5_.min_left_points AS min_left_points_83,
  m5_.min_right_points AS min_right_points_84,
  m5_.is_in_progression AS is_in_progression_85,
  m6_.id AS id_86,
  m6_.name AS name_87,
  m6_.marketing_name AS marketing_name_88,
  m6_.image AS image_89,
  m6_.residual AS residual_90,
  m6_.saving_bonus_amount AS saving_bonus_amount_91,
  m6_.level AS level_92,
  m6_.min_direct_clients AS min_direct_clients_93,
  m6_.representative_client AS representative_client_94,
  m6_.min_direct_points AS min_direct_points_95,
  m6_.min_left_points AS min_left_points_96,
  m6_.min_right_points AS min_right_points_97,
  m6_.is_in_progression AS is_in_progression_98,
  a0_.sponsor_id AS sponsor_id_99,
  a0_.parent_id AS parent_id_100,
  a0_.rank_id AS rank_id_101,
  a0_.pack_id AS pack_id_102,
  a0_.user_id AS user_id_103,
  a0_.market_id AS market_id_104,
  a0_.qualification_id AS qualification_id_105,
  a0_.subscription_gateway_id AS subscription_gateway_id_106,
  a0_.subscription_country_id AS subscription_country_id_107,
  a0_.currency_id AS currency_id_108,
  a0_.first_subscription_space_id AS first_subscription_space_id_109,
  m3_.parent_node_id AS parent_node_id_110,
  m3_.member_id AS member_id_111,
  m3_.tree_id AS tree_id_112,
  a4_.sponsor_id AS sponsor_id_113,
  a4_.parent_id AS parent_id_114,
  a4_.rank_id AS rank_id_115,
  a4_.pack_id AS pack_id_116,
  a4_.user_id AS user_id_117,
  a4_.market_id AS market_id_118,
  a4_.qualification_id AS qualification_id_119,
  a4_.subscription_gateway_id AS subscription_gateway_id_120,
  a4_.subscription_country_id AS subscription_country_id_121,
  a4_.currency_id AS currency_id_122,
  a4_.first_subscription_space_id AS first_subscription_space_id_123
FROM
  app_member a0_
  INNER JOIN app_user a1_ ON a0_.user_id = a1_.id
  INNER JOIN app_member a7_ ON a0_.sponsor_id = a7_.id
  INNER JOIN app_market a2_ ON a0_.market_id = a2_.id
  INNER JOIN mybiz_member_node m3_ ON a0_.id = m3_.member_id
  LEFT JOIN app_member a4_ ON a0_.parent_id = a4_.id
  LEFT JOIN mybiz_rank m5_ ON a0_.rank_id = m5_.id
  LEFT JOIN mybiz_rank m6_ ON a0_.qualification_id = m6_.id
WHERE
  a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.id DESC

SELECT DISTINCT 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, a2_.id AS id_39, a2_.name AS name_40, a2_.enabled AS enabled_41, a2_.suffix AS suffix_42, a2_.is_promotional AS is_promotional_43, m3_.id AS id_44, m3_.position_for_parent AS position_for_parent_45, m3_.depth AS depth_46, m3_.left_index AS left_index_47, m3_.right_index AS right_index_48, m3_.nb_node_points AS nb_node_points_49, m3_.nb_total_points AS nb_total_points_50, a4_.id AS id_51, a4_.position AS position_52, a4_.status AS status_53, a4_.member_date AS member_date_54, a4_.enabled AS enabled_55, a4_.is_insider AS is_insider_56, a4_.accept_offers AS accept_offers_57, a4_.accept_terms_date AS accept_terms_date_58, a4_.has_premium_deducted AS has_premium_deducted_59, a4_.liberty_pack AS liberty_pack_60, a4_.preferred_language AS preferred_language_61, a4_.saving_bonus AS saving_bonus_62, a4_.saving_bonus_reached_at AS saving_bonus_reached_at_63, a4_.signup_ip_address AS signup_ip_address_64, a4_.is_new AS is_new_65, a4_.birthday AS birthday_66, a4_.last_sponsor_attribution_at AS last_sponsor_attribution_at_67, a4_.is_offered_sponsor AS is_offered_sponsor_68, a4_.discord_id AS discord_id_69, a4_.step_elite AS step_elite_70, a4_.is_deleted AS is_deleted_71, a4_.theme AS theme_72, m5_.id AS id_73, m5_.name AS name_74, m5_.marketing_name AS marketing_name_75, m5_.image AS image_76, m5_.residual AS residual_77, m5_.saving_bonus_amount AS saving_bonus_amount_78, m5_.level AS level_79, m5_.min_direct_clients AS min_direct_clients_80, m5_.representative_client AS representative_client_81, m5_.min_direct_points AS min_direct_points_82, m5_.min_left_points AS min_left_points_83, m5_.min_right_points AS min_right_points_84, m5_.is_in_progression AS is_in_progression_85, m6_.id AS id_86, m6_.name AS name_87, m6_.marketing_name AS marketing_name_88, m6_.image AS image_89, m6_.residual AS residual_90, m6_.saving_bonus_amount AS saving_bonus_amount_91, m6_.level AS level_92, m6_.min_direct_clients AS min_direct_clients_93, m6_.representative_client AS representative_client_94, m6_.min_direct_points AS min_direct_points_95, m6_.min_left_points AS min_left_points_96, m6_.min_right_points AS min_right_points_97, m6_.is_in_progression AS is_in_progression_98, a0_.sponsor_id AS sponsor_id_99, a0_.parent_id AS parent_id_100, a0_.rank_id AS rank_id_101, a0_.pack_id AS pack_id_102, a0_.user_id AS user_id_103, a0_.market_id AS market_id_104, a0_.qualification_id AS qualification_id_105, a0_.subscription_gateway_id AS subscription_gateway_id_106, a0_.subscription_country_id AS subscription_country_id_107, a0_.currency_id AS currency_id_108, a0_.first_subscription_space_id AS first_subscription_space_id_109, m3_.parent_node_id AS parent_node_id_110, m3_.member_id AS member_id_111, m3_.tree_id AS tree_id_112, a4_.sponsor_id AS sponsor_id_113, a4_.parent_id AS parent_id_114, a4_.rank_id AS rank_id_115, a4_.pack_id AS pack_id_116, a4_.user_id AS user_id_117, a4_.market_id AS market_id_118, a4_.qualification_id AS qualification_id_119, a4_.subscription_gateway_id AS subscription_gateway_id_120, a4_.subscription_country_id AS subscription_country_id_121, a4_.currency_id AS currency_id_122, a4_.first_subscription_space_id AS first_subscription_space_id_123 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id INNER JOIN app_member a7_ ON a0_.sponsor_id = a7_.id INNER JOIN app_market a2_ ON a0_.market_id = a2_.id INNER JOIN mybiz_member_node m3_ ON a0_.id = m3_.member_id LEFT JOIN app_member a4_ ON a0_.parent_id = a4_.id LEFT JOIN mybiz_rank m5_ ON a0_.rank_id = m5_.id LEFT JOIN mybiz_rank m6_ ON a0_.qualification_id = m6_.id WHERE a0_.id IN (274138, 274111, 274110, 274108, 274107, 274105, 274101, 274100, 274099, 274098, 274097, 274096, 274091, 274090, 274089, 274088, 274087, 274086, 274085, 274084, 274083, 274081, 274080, 274079, 274078, 274077, 274076, 274075, 274074, 274072) ORDER BY a0_.id DESC;

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_.new_qualified_choice_popup_closed_at AS new_qualified_choice_popup_closed_at_81,
  m4_.address_first_name AS address_first_name_82,
  m4_.address_last_name AS address_last_name_83,
  m4_.address_street AS address_street_84,
  m4_.address_postcode AS address_postcode_85,
  m4_.address_city AS address_city_86,
  m4_.address_country_code AS address_country_code_87,
  m4_.relay_name AS relay_name_88,
  m4_.relay_ref AS relay_ref_89,
  m4_.relay_street AS relay_street_90,
  m4_.relay_city AS relay_city_91,
  m4_.relay_postcode AS relay_postcode_92,
  m4_.relay_country_code AS relay_country_code_93,
  a0_.sponsor_id AS sponsor_id_94,
  a0_.parent_id AS parent_id_95,
  a0_.rank_id AS rank_id_96,
  a0_.pack_id AS pack_id_97,
  a0_.user_id AS user_id_98,
  a0_.market_id AS market_id_99,
  a0_.qualification_id AS qualification_id_100,
  a0_.subscription_gateway_id AS subscription_gateway_id_101,
  a0_.subscription_country_id AS subscription_country_id_102,
  a0_.currency_id AS currency_id_103,
  a0_.first_subscription_space_id AS first_subscription_space_id_104,
  m2_.parent_node_id AS parent_node_id_105,
  m2_.member_id AS member_id_106,
  m2_.tree_id AS tree_id_107,
  m3_.member_id AS member_id_108,
  m3_.company_country_id AS company_country_id_109,
  m3_.company_immatriculation_file_id AS company_immatriculation_file_id_110,
  m3_.company_vigilance_file_id AS company_vigilance_file_id_111,
  m3_.contract_file_id AS contract_file_id_112,
  m3_.certification_file_id AS certification_file_id_113,
  m4_.member_id AS member_id_114
FROM
  app_member a0_
  INNER JOIN app_user a1_ ON a0_.user_id = a1_.id
  LEFT JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_id
  LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id
  LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id
WHERE
  a1_.jwt_token = ?
  AND a1_.jwt_token_expiration > ?
  AND a0_.is_deleted = ?

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_.new_qualified_choice_popup_closed_at AS new_qualified_choice_popup_closed_at_81, m4_.address_first_name AS address_first_name_82, m4_.address_last_name AS address_last_name_83, m4_.address_street AS address_street_84, m4_.address_postcode AS address_postcode_85, m4_.address_city AS address_city_86, m4_.address_country_code AS address_country_code_87, m4_.relay_name AS relay_name_88, m4_.relay_ref AS relay_ref_89, m4_.relay_street AS relay_street_90, m4_.relay_city AS relay_city_91, m4_.relay_postcode AS relay_postcode_92, m4_.relay_country_code AS relay_country_code_93, a0_.sponsor_id AS sponsor_id_94, a0_.parent_id AS parent_id_95, a0_.rank_id AS rank_id_96, a0_.pack_id AS pack_id_97, a0_.user_id AS user_id_98, a0_.market_id AS market_id_99, a0_.qualification_id AS qualification_id_100, a0_.subscription_gateway_id AS subscription_gateway_id_101, a0_.subscription_country_id AS subscription_country_id_102, a0_.currency_id AS currency_id_103, a0_.first_subscription_space_id AS first_subscription_space_id_104, m2_.parent_node_id AS parent_node_id_105, m2_.member_id AS member_id_106, m2_.tree_id AS tree_id_107, m3_.member_id AS member_id_108, m3_.company_country_id AS company_country_id_109, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_110, m3_.company_vigilance_file_id AS company_vigilance_file_id_111, m3_.contract_file_id AS contract_file_id_112, m3_.certification_file_id AS certification_file_id_113, m4_.member_id AS member_id_114 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_id LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id WHERE a1_.jwt_token = 'ckCExqyizeMRScFxcoGU2xNG2dnqjeshTrxx2EEzHASNIwgaVd' AND a1_.jwt_token_expiration > '2026-04-13 15:36:19' AND a0_.is_deleted = 0;

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;