Symfony Profiler

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;

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;

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.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;

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.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;

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;

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.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;

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.salt AS salt_6,
  t0.birthdate AS birthdate_7,
  t0.phone AS phone_8,
  t0.created_at AS created_at_9,
  t0.roles AS roles_10,
  t0.last_login_at AS last_login_at_11,
  t0.api_key AS api_key_12,
  t0.password_reset_token AS password_reset_token_13,
  t0.password_reset_token_expires_at AS password_reset_token_expires_at_14,
  t0.password_reset_token_emails_sent AS password_reset_token_emails_sent_15,
  t0.jwt_token AS jwt_token_16,
  t0.jwt_token_expiration AS jwt_token_expiration_17,
  t18.id AS id_19,
  t18.position AS position_20,
  t18.status AS status_21,
  t18.member_date AS member_date_22,
  t18.enabled AS enabled_23,
  t18.is_insider AS is_insider_24,
  t18.accept_offers AS accept_offers_25,
  t18.accept_terms_date AS accept_terms_date_26,
  t18.has_premium_deducted AS has_premium_deducted_27,
  t18.liberty_pack AS liberty_pack_28,
  t18.preferred_language AS preferred_language_29,
  t18.saving_bonus AS saving_bonus_30,
  t18.saving_bonus_reached_at AS saving_bonus_reached_at_31,
  t18.is_new AS is_new_32,
  t18.birthday AS birthday_33,
  t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_34,
  t18.is_offered_sponsor AS is_offered_sponsor_35,
  t18.discord_id AS discord_id_36,
  t18.step_elite AS step_elite_37,
  t18.is_deleted AS is_deleted_38,
  t18.sponsor_id AS sponsor_id_39,
  t18.parent_id AS parent_id_40,
  t18.rank_id AS rank_id_41,
  t18.pack_id AS pack_id_42,
  t18.user_id AS user_id_43,
  t18.member_node_id AS member_node_id_44,
  t18.market_id AS market_id_45,
  t18.qualification_id AS qualification_id_46,
  t18.subscription_gateway_id AS subscription_gateway_id_47,
  t18.subscription_country_id AS subscription_country_id_48,
  t18.currency_id AS currency_id_49,
  t18.first_subscription_space_id AS first_subscription_space_id_50
FROM
  app_user t0
  LEFT JOIN app_member t18 ON t18.user_id = t0.id
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.is_new AS is_new_32, t18.birthday AS birthday_33, t18.last_sponsor_attribution_at AS last_sponsor_attribution_at_34, t18.is_offered_sponsor AS is_offered_sponsor_35, t18.discord_id AS discord_id_36, t18.step_elite AS step_elite_37, t18.is_deleted AS is_deleted_38, t18.sponsor_id AS sponsor_id_39, t18.parent_id AS parent_id_40, t18.rank_id AS rank_id_41, t18.pack_id AS pack_id_42, t18.user_id AS user_id_43, t18.member_node_id AS member_node_id_44, t18.market_id AS market_id_45, t18.qualification_id AS qualification_id_46, t18.subscription_gateway_id AS subscription_gateway_id_47, t18.subscription_country_id AS subscription_country_id_48, t18.currency_id AS currency_id_49, t18.first_subscription_space_id AS first_subscription_space_id_50 FROM app_user t0 LEFT JOIN app_member t18 ON t18.user_id = t0.id WHERE t0.email = 'gandre.clement@gmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.pack_name AS pack_name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.shipping_method_id AS shipping_method_id_5,
  t0.fees_in_cents AS fees_in_cents_6,
  t0.futures_product AS futures_product_7,
  t0.luume_product AS luume_product_8,
  t0.is_over AS is_over_9,
  t0.address_first_name AS address_first_name_10,
  t0.address_last_name AS address_last_name_11,
  t0.address_street AS address_street_12,
  t0.address_postcode AS address_postcode_13,
  t0.address_city AS address_city_14,
  t0.address_country_code AS address_country_code_15,
  t0.relay_name AS relay_name_16,
  t0.relay_ref AS relay_ref_17,
  t0.relay_street AS relay_street_18,
  t0.relay_city AS relay_city_19,
  t0.relay_postcode AS relay_postcode_20,
  t0.relay_country_code AS relay_country_code_21,
  t0.member_id AS member_id_22
FROM
  mybiz_qualified_choice t0
WHERE
  t0.member_id = ?

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

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

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

SELECT
  a0_.id AS id_0,
  a0_.position AS position_1,
  a0_.status AS status_2,
  a0_.member_date AS member_date_3,
  a0_.enabled AS enabled_4,
  a0_.is_insider AS is_insider_5,
  a0_.accept_offers AS accept_offers_6,
  a0_.accept_terms_date AS accept_terms_date_7,
  a0_.has_premium_deducted AS has_premium_deducted_8,
  a0_.liberty_pack AS liberty_pack_9,
  a0_.preferred_language AS preferred_language_10,
  a0_.saving_bonus AS saving_bonus_11,
  a0_.saving_bonus_reached_at AS saving_bonus_reached_at_12,
  a0_.is_new AS is_new_13,
  a0_.birthday AS birthday_14,
  a0_.last_sponsor_attribution_at AS last_sponsor_attribution_at_15,
  a0_.is_offered_sponsor AS is_offered_sponsor_16,
  a0_.discord_id AS discord_id_17,
  a0_.step_elite AS step_elite_18,
  a0_.is_deleted AS is_deleted_19,
  a1_.id AS id_20,
  a1_.firstname AS firstname_21,
  a1_.lastname AS lastname_22,
  a1_.email AS email_23,
  a1_.password AS password_24,
  a1_.salt AS salt_25,
  a1_.birthdate AS birthdate_26,
  a1_.phone AS phone_27,
  a1_.created_at AS created_at_28,
  a1_.roles AS roles_29,
  a1_.last_login_at AS last_login_at_30,
  a1_.api_key AS api_key_31,
  a1_.password_reset_token AS password_reset_token_32,
  a1_.password_reset_token_expires_at AS password_reset_token_expires_at_33,
  a1_.password_reset_token_emails_sent AS password_reset_token_emails_sent_34,
  a1_.jwt_token AS jwt_token_35,
  a1_.jwt_token_expiration AS jwt_token_expiration_36,
  m2_.id AS id_37,
  m2_.position_for_parent AS position_for_parent_38,
  m2_.depth AS depth_39,
  m2_.left_index AS left_index_40,
  m2_.right_index AS right_index_41,
  m2_.nb_node_points AS nb_node_points_42,
  m2_.nb_total_points AS nb_total_points_43,
  m3_.id AS id_44,
  m3_.limit_date AS limit_date_45,
  m3_.kyc_validated_at AS kyc_validated_at_46,
  m3_.siret_validated_at AS siret_validated_at_47,
  m3_.company_immatriculation_validated_at AS company_immatriculation_validated_at_48,
  m3_.declaration_validated_at AS declaration_validated_at_49,
  m3_.company_vigilance_validated_at AS company_vigilance_validated_at_50,
  m3_.contract_validated_at AS contract_validated_at_51,
  m3_.company_status AS company_status_52,
  m3_.company_umbrella AS company_umbrella_53,
  m3_.company_name AS company_name_54,
  m3_.kyc_first_name AS kyc_first_name_55,
  m3_.kyc_last_name AS kyc_last_name_56,
  m3_.kyc_birthday AS kyc_birthday_57,
  m3_.company_siren AS company_siren_58,
  m3_.company_address_street AS company_address_street_59,
  m3_.company_address_postcode AS company_address_postcode_60,
  m3_.company_address_city AS company_address_city_61,
  m3_.applicant_id AS applicant_id_62,
  m3_.workflow_run_id AS workflow_run_id_63,
  m3_.sdk_token AS sdk_token_64,
  m3_.kyc_status AS kyc_status_65,
  m3_.certified_at AS certified_at_66,
  m3_.is_kyc_infos_extracted AS is_kyc_infos_extracted_67,
  m3_.certified_popup_closed_at AS certified_popup_closed_at_68,
  m3_.academy_popup_closed_at AS academy_popup_closed_at_69,
  m4_.id AS id_70,
  m4_.pack_name AS pack_name_71,
  m4_.created_at AS created_at_72,
  m4_.updated_at AS updated_at_73,
  m4_.shipping_method_id AS shipping_method_id_74,
  m4_.fees_in_cents AS fees_in_cents_75,
  m4_.futures_product AS futures_product_76,
  m4_.luume_product AS luume_product_77,
  m4_.is_over AS is_over_78,
  m4_.address_first_name AS address_first_name_79,
  m4_.address_last_name AS address_last_name_80,
  m4_.address_street AS address_street_81,
  m4_.address_postcode AS address_postcode_82,
  m4_.address_city AS address_city_83,
  m4_.address_country_code AS address_country_code_84,
  m4_.relay_name AS relay_name_85,
  m4_.relay_ref AS relay_ref_86,
  m4_.relay_street AS relay_street_87,
  m4_.relay_city AS relay_city_88,
  m4_.relay_postcode AS relay_postcode_89,
  m4_.relay_country_code AS relay_country_code_90,
  a5_.id AS id_91,
  a5_.nb_predictions AS nb_predictions_92,
  a6_.id AS id_93,
  a6_.type AS type_94,
  a6_.name AS name_95,
  a6_.sku AS sku_96,
  a6_.is_enabled AS is_enabled_97,
  a6_.is_subscibable AS is_subscibable_98,
  a6_.is_ikigai_pack AS is_ikigai_pack_99,
  a6_.is_printable AS is_printable_100,
  a6_.marketing_name AS marketing_name_101,
  a6_.image_path AS image_path_102,
  a6_.color AS color_103,
  a6_.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_.member_node_id AS member_node_id_110,
  a0_.market_id AS market_id_111,
  a0_.qualification_id AS qualification_id_112,
  a0_.subscription_gateway_id AS subscription_gateway_id_113,
  a0_.subscription_country_id AS subscription_country_id_114,
  a0_.currency_id AS currency_id_115,
  a0_.first_subscription_space_id AS first_subscription_space_id_116,
  m2_.parent_node_id AS parent_node_id_117,
  m2_.member_id AS member_id_118,
  m2_.tree_id AS tree_id_119,
  m3_.member_id AS member_id_120,
  m3_.company_country_id AS company_country_id_121,
  m3_.company_immatriculation_file_id AS company_immatriculation_file_id_122,
  m3_.company_vigilance_file_id AS company_vigilance_file_id_123,
  m3_.contract_file_id AS contract_file_id_124,
  m3_.certification_file_id AS certification_file_id_125,
  m4_.member_id AS member_id_126,
  a5_.member_id AS member_id_127,
  a6_.space_id AS space_id_128
FROM
  app_member a0_
  INNER JOIN app_user a1_ ON a0_.user_id = a1_.id
  LEFT JOIN mybiz_member_node m2_ ON a0_.member_node_id = m2_.id
  LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id
  LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id
  LEFT JOIN app_member_prediction a5_ ON a0_.id = a5_.member_id
  LEFT JOIN app_product a6_ ON a0_.pack_id = a6_.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_.is_new AS is_new_13, a0_.birthday AS birthday_14, a0_.last_sponsor_attribution_at AS last_sponsor_attribution_at_15, a0_.is_offered_sponsor AS is_offered_sponsor_16, a0_.discord_id AS discord_id_17, a0_.step_elite AS step_elite_18, a0_.is_deleted AS is_deleted_19, a1_.id AS id_20, a1_.firstname AS firstname_21, a1_.lastname AS lastname_22, a1_.email AS email_23, a1_.password AS password_24, a1_.salt AS salt_25, a1_.birthdate AS birthdate_26, a1_.phone AS phone_27, a1_.created_at AS created_at_28, a1_.roles AS roles_29, a1_.last_login_at AS last_login_at_30, a1_.api_key AS api_key_31, a1_.password_reset_token AS password_reset_token_32, a1_.password_reset_token_expires_at AS password_reset_token_expires_at_33, a1_.password_reset_token_emails_sent AS password_reset_token_emails_sent_34, a1_.jwt_token AS jwt_token_35, a1_.jwt_token_expiration AS jwt_token_expiration_36, m2_.id AS id_37, m2_.position_for_parent AS position_for_parent_38, m2_.depth AS depth_39, m2_.left_index AS left_index_40, m2_.right_index AS right_index_41, m2_.nb_node_points AS nb_node_points_42, m2_.nb_total_points AS nb_total_points_43, m3_.id AS id_44, m3_.limit_date AS limit_date_45, m3_.kyc_validated_at AS kyc_validated_at_46, m3_.siret_validated_at AS siret_validated_at_47, m3_.company_immatriculation_validated_at AS company_immatriculation_validated_at_48, m3_.declaration_validated_at AS declaration_validated_at_49, m3_.company_vigilance_validated_at AS company_vigilance_validated_at_50, m3_.contract_validated_at AS contract_validated_at_51, m3_.company_status AS company_status_52, m3_.company_umbrella AS company_umbrella_53, m3_.company_name AS company_name_54, m3_.kyc_first_name AS kyc_first_name_55, m3_.kyc_last_name AS kyc_last_name_56, m3_.kyc_birthday AS kyc_birthday_57, m3_.company_siren AS company_siren_58, m3_.company_address_street AS company_address_street_59, m3_.company_address_postcode AS company_address_postcode_60, m3_.company_address_city AS company_address_city_61, m3_.applicant_id AS applicant_id_62, m3_.workflow_run_id AS workflow_run_id_63, m3_.sdk_token AS sdk_token_64, m3_.kyc_status AS kyc_status_65, m3_.certified_at AS certified_at_66, m3_.is_kyc_infos_extracted AS is_kyc_infos_extracted_67, m3_.certified_popup_closed_at AS certified_popup_closed_at_68, m3_.academy_popup_closed_at AS academy_popup_closed_at_69, m4_.id AS id_70, m4_.pack_name AS pack_name_71, m4_.created_at AS created_at_72, m4_.updated_at AS updated_at_73, m4_.shipping_method_id AS shipping_method_id_74, m4_.fees_in_cents AS fees_in_cents_75, m4_.futures_product AS futures_product_76, m4_.luume_product AS luume_product_77, m4_.is_over AS is_over_78, m4_.address_first_name AS address_first_name_79, m4_.address_last_name AS address_last_name_80, m4_.address_street AS address_street_81, m4_.address_postcode AS address_postcode_82, m4_.address_city AS address_city_83, m4_.address_country_code AS address_country_code_84, m4_.relay_name AS relay_name_85, m4_.relay_ref AS relay_ref_86, m4_.relay_street AS relay_street_87, m4_.relay_city AS relay_city_88, m4_.relay_postcode AS relay_postcode_89, m4_.relay_country_code AS relay_country_code_90, a5_.id AS id_91, a5_.nb_predictions AS nb_predictions_92, a6_.id AS id_93, a6_.type AS type_94, a6_.name AS name_95, a6_.sku AS sku_96, a6_.is_enabled AS is_enabled_97, a6_.is_subscibable AS is_subscibable_98, a6_.is_ikigai_pack AS is_ikigai_pack_99, a6_.is_printable AS is_printable_100, a6_.marketing_name AS marketing_name_101, a6_.image_path AS image_path_102, a6_.color AS color_103, a6_.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_.member_node_id AS member_node_id_110, a0_.market_id AS market_id_111, a0_.qualification_id AS qualification_id_112, a0_.subscription_gateway_id AS subscription_gateway_id_113, a0_.subscription_country_id AS subscription_country_id_114, a0_.currency_id AS currency_id_115, a0_.first_subscription_space_id AS first_subscription_space_id_116, m2_.parent_node_id AS parent_node_id_117, m2_.member_id AS member_id_118, m2_.tree_id AS tree_id_119, m3_.member_id AS member_id_120, m3_.company_country_id AS company_country_id_121, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_122, m3_.company_vigilance_file_id AS company_vigilance_file_id_123, m3_.contract_file_id AS contract_file_id_124, m3_.certification_file_id AS certification_file_id_125, m4_.member_id AS member_id_126, a5_.member_id AS member_id_127, a6_.space_id AS space_id_128 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN mybiz_member_node m2_ ON a0_.member_node_id = m2_.id LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id LEFT JOIN app_member_prediction a5_ ON a0_.id = a5_.member_id LEFT JOIN app_product a6_ ON a0_.pack_id = a6_.id WHERE a0_.sponsor_id = 267473 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;

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

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_.member_id AS member_id_24
FROM
  app_payment_history a0_
WHERE
  a0_.type = ?
  AND a0_.member_id = ?
  AND a0_.status = ?
ORDER BY
  a0_.date DESC