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

Query Metrics

29 Database Queries
21 Different statements
91.81 ms Query time
0 Invalid entities
63 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.section AS section_2, t0.parameter_key AS parameter_key_3, t0.string_value AS string_value_4, t0.int_value AS int_value_5, t0.float_value AS float_value_6, t0.bool_value AS bool_value_7, t0.array_value AS array_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM app_parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
  "app.maintenance.lock"
]
2 0.65 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "futures_infinity"
]
3 0.62 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "luume"
]
4 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "mybiz"
]
5 15.18 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:
[
  "leone.elodie@hotmail.fr"
]
6 0.63 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:
[
  8
]
7 0.55 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:
[
  8
]
8 0.71 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.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 = ?
Parameters:
[
  8
]
9 0.64 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:
[
  8
]
10 2.61 ms
"START TRANSACTION"
Parameters:
[]
11 21.63 ms
UPDATE app_user SET jwt_token = ?, jwt_token_expiration = ? WHERE id = ?
Parameters:
[
  "ckCExqyizeMRScFxcoGU2xNG2dnqjeshTrxx2EEzHASNIwgaVd"
  "2026-04-16 15:46:58"
  6
]
12 7.70 ms
"COMMIT"
Parameters:
[]
13 0.37 ms
"START TRANSACTION"
Parameters:
[]
14 0.50 ms
UPDATE app_user SET last_login_at = ? WHERE id = ?
Parameters:
[
  "2026-04-09 15:46:58"
  6
]
15 4.69 ms
"COMMIT"
Parameters:
[]
16 8.65 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.speciality AS speciality_11, t0.quantity AS quantity_12, t0.created_at AS created_at_13, t0.futures_pack_name AS futures_pack_name_14, t0.luume_pack_name AS luume_pack_name_15, t0.sent_to_luume_at AS sent_to_luume_at_16, t0.context AS context_17, t0.is_freedom AS is_freedom_18, t0.is_qualified AS is_qualified_19, t0.duration_total AS duration_total_20, t0.has_full_points_distributed AS has_full_points_distributed_21, t0.current_subscription_month AS current_subscription_month_22, t0.freedom_duration AS freedom_duration_23, t0.freedom_total_duration AS freedom_total_duration_24, t0.total_prediction AS total_prediction_25, t0.consumed_prediction AS consumed_prediction_26, t0.decreasing_config_price AS decreasing_config_price_27, t0.is_decreasing AS is_decreasing_28, t0.member_id AS member_id_29, t0.gateway_id AS gateway_id_30, t0.country_id AS country_id_31, t0.product_id AS product_id_32, t0.payment_history_id AS payment_history_id_33, t0.previous_subscription_id AS previous_subscription_id_34, t0.initial_product_id AS initial_product_id_35 FROM app_subscription t0 WHERE t0.member_id = ?
Parameters:
[
  8
]
17 0.58 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.sku AS sku_4, t0.is_enabled AS is_enabled_5, t0.is_subscibable AS is_subscibable_6, t0.is_ikigai_pack AS is_ikigai_pack_7, t0.is_printable AS is_printable_8, t0.marketing_name AS marketing_name_9, t0.image_path AS image_path_10, t0.color AS color_11, t0.context AS context_12, t0.space_id AS space_id_13 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
  9
]
18 0.56 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.sku AS sku_4, t0.is_enabled AS is_enabled_5, t0.is_subscibable AS is_subscibable_6, t0.is_ikigai_pack AS is_ikigai_pack_7, t0.is_printable AS is_printable_8, t0.marketing_name AS marketing_name_9, t0.image_path AS image_path_10, t0.color AS color_11, t0.context AS context_12, t0.space_id AS space_id_13 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
  10
]
19 0.40 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.sku AS sku_4, t0.is_enabled AS is_enabled_5, t0.is_subscibable AS is_subscibable_6, t0.is_ikigai_pack AS is_ikigai_pack_7, t0.is_printable AS is_printable_8, t0.marketing_name AS marketing_name_9, t0.image_path AS image_path_10, t0.color AS color_11, t0.context AS context_12, t0.space_id AS space_id_13 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
  22
]
20 8.42 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:
[
  6
]
21 5.26 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
]
22 1.11 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 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:
[
  8
  "pack"
  1
  "2026-04-09 15:46:58"
  "2026-04-09 15:46:58"
]
23 3.92 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 FROM app_subscription a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id WHERE a0_.member_id = ? AND a1_.name IN (?, ?, ?, ?) AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL
Parameters:
[
  8
  "ikigai"
  "ikigai-plus"
  "ikigai-pro"
  "ikigai-premium"
  "2026-04-09 15:46:58"
  "2026-04-09 15:46:58"
]
24 1.91 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 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:
[
  8
  "link"
]
25 0.97 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 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:
[
  8
  "pack"
  1
]
26 0.97 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 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:
[
  8
  "pack"
  1
  "2026-04-09 15:46:58"
  "2026-04-09 15:46:58"
]
27 0.75 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_.speciality AS speciality_10, a0_.quantity AS quantity_11, a0_.created_at AS created_at_12, a0_.futures_pack_name AS futures_pack_name_13, a0_.luume_pack_name AS luume_pack_name_14, a0_.sent_to_luume_at AS sent_to_luume_at_15, a0_.context AS context_16, a0_.is_freedom AS is_freedom_17, a0_.is_qualified AS is_qualified_18, a0_.duration_total AS duration_total_19, a0_.has_full_points_distributed AS has_full_points_distributed_20, a0_.current_subscription_month AS current_subscription_month_21, a0_.freedom_duration AS freedom_duration_22, a0_.freedom_total_duration AS freedom_total_duration_23, a0_.total_prediction AS total_prediction_24, a0_.consumed_prediction AS consumed_prediction_25, a0_.decreasing_config_price AS decreasing_config_price_26, a0_.is_decreasing AS is_decreasing_27, a0_.member_id AS member_id_28, a0_.gateway_id AS gateway_id_29, a0_.country_id AS country_id_30, a0_.product_id AS product_id_31, a0_.payment_history_id AS payment_history_id_32, a0_.previous_subscription_id AS previous_subscription_id_33, a0_.initial_product_id AS initial_product_id_34 FROM app_subscription a0_ WHERE a0_.member_id = ? AND a0_.is_qualified = ? AND a0_.cancellation_at IS NULL
Parameters:
[
  8
  1
]
28 0.48 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:
[
  "premium"
]
29 0.40 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:
[
  "hairfusion"
]

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\Payment\Subscription 31
App\Entity\Product\Product 4
App\Entity\Space\Space 3
App\Entity\Member\Member 3
App\Entity\Parameter\Gateway 3
App\Entity\Payment\PaymentHistory 3
App\Entity\Mybiz\Rank 2
App\Entity\Mybiz\MemberNode 2
App\Entity\Parameter\Country 2
App\Entity\Member\MemberDocument 2
App\Entity\Parameter\Parameter 1
App\Entity\Member\User 1
App\Entity\Mybiz\Tree 1
App\Entity\Parameter\Market 1
App\Entity\Parameter\Currency 1
App\Entity\Mybiz\QualifiedChoice 1
App\Entity\Mybiz\MybizOnBoarding 1
App\Entity\Member\UserAddress 1

Entities Mapping

Class Mapping errors
App\Entity\Parameter\Parameter No errors.
App\Entity\Space\Space No errors.
App\Entity\Space\Application No errors.
App\Entity\Service\FeatureType No errors.
App\Entity\Payment\ShopPurchase No errors.
App\Entity\Product\Product No errors.
App\Entity\Member\Member No errors.
App\Entity\Parameter\Notification No errors.
App\Entity\Parameter\Document No errors.
App\Entity\Member\User No errors.
App\Entity\Mybiz\Rank No errors.
App\Entity\Parameter\Market No errors.
App\Entity\Parameter\Gateway No errors.
App\Entity\Parameter\Country No errors.
App\Entity\Parameter\Currency No errors.
App\Entity\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.