Query Metrics
10
Database Queries
8
Different statements
6.31 ms
Query time
0
Invalid entities
37
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 ms |
SELECT t0.id AS id_1, t0.section AS section_2, t0.parameter_key AS parameter_key_3, t0.string_value AS string_value_4, t0.int_value AS int_value_5, t0.float_value AS float_value_6, t0.bool_value AS bool_value_7, t0.array_value AS array_value_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM app_parameter t0 WHERE t0.parameter_key = ? LIMIT 1
Parameters:
[
"app.maintenance.lock"
]
|
| 2 | 0.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"futures_infinity"
]
|
| 3 | 0.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"luume"
]
|
| 4 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.token AS token_3, t0.marketing_name AS marketing_name_4, t0.description AS description_5, t0.domain_name AS domain_name_6, t0.primary_color AS primary_color_7, t0.second_color AS second_color_8, t0.one_signal_token AS one_signal_token_9, t0.is_enabled AS is_enabled_10, t0.helpdesk_team_id AS helpdesk_team_id_11 FROM app_space t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"mybiz"
]
|
| 5 | 1.00 ms |
SELECT a0_.id AS id_0, a0_.position AS position_1, a0_.status AS status_2, a0_.member_date AS member_date_3, a0_.enabled AS enabled_4, a0_.is_insider AS is_insider_5, a0_.accept_offers AS accept_offers_6, a0_.accept_terms_date AS accept_terms_date_7, a0_.has_premium_deducted AS has_premium_deducted_8, a0_.liberty_pack AS liberty_pack_9, a0_.preferred_language AS preferred_language_10, a0_.saving_bonus AS saving_bonus_11, a0_.saving_bonus_reached_at AS saving_bonus_reached_at_12, a0_.signup_ip_address AS signup_ip_address_13, a0_.is_new AS is_new_14, a0_.birthday AS birthday_15, a0_.last_sponsor_attribution_at AS last_sponsor_attribution_at_16, a0_.is_offered_sponsor AS is_offered_sponsor_17, a0_.discord_id AS discord_id_18, a0_.step_elite AS step_elite_19, a0_.is_deleted AS is_deleted_20, a0_.theme AS theme_21, a1_.id AS id_22, a1_.firstname AS firstname_23, a1_.lastname AS lastname_24, a1_.email AS email_25, a1_.password AS password_26, a1_.salt AS salt_27, a1_.birthdate AS birthdate_28, a1_.phone AS phone_29, a1_.created_at AS created_at_30, a1_.roles AS roles_31, a1_.last_login_at AS last_login_at_32, a1_.api_key AS api_key_33, a1_.password_reset_token AS password_reset_token_34, a1_.password_reset_token_expires_at AS password_reset_token_expires_at_35, a1_.password_reset_token_emails_sent AS password_reset_token_emails_sent_36, a1_.jwt_token AS jwt_token_37, a1_.jwt_token_expiration AS jwt_token_expiration_38, m2_.id AS id_39, m2_.position_for_parent AS position_for_parent_40, m2_.depth AS depth_41, m2_.left_index AS left_index_42, m2_.right_index AS right_index_43, m2_.nb_node_points AS nb_node_points_44, m2_.nb_total_points AS nb_total_points_45, m3_.id AS id_46, m3_.limit_date AS limit_date_47, m3_.kyc_validated_at AS kyc_validated_at_48, m3_.siret_validated_at AS siret_validated_at_49, m3_.company_immatriculation_validated_at AS company_immatriculation_validated_at_50, m3_.declaration_validated_at AS declaration_validated_at_51, m3_.company_vigilance_validated_at AS company_vigilance_validated_at_52, m3_.contract_validated_at AS contract_validated_at_53, m3_.company_status AS company_status_54, m3_.company_umbrella AS company_umbrella_55, m3_.company_name AS company_name_56, m3_.kyc_first_name AS kyc_first_name_57, m3_.kyc_last_name AS kyc_last_name_58, m3_.kyc_birthday AS kyc_birthday_59, m3_.company_siren AS company_siren_60, m3_.company_address_street AS company_address_street_61, m3_.company_address_postcode AS company_address_postcode_62, m3_.company_address_city AS company_address_city_63, m3_.applicant_id AS applicant_id_64, m3_.workflow_run_id AS workflow_run_id_65, m3_.sdk_token AS sdk_token_66, m3_.kyc_status AS kyc_status_67, m3_.certified_at AS certified_at_68, m3_.is_kyc_infos_extracted AS is_kyc_infos_extracted_69, m3_.certified_popup_closed_at AS certified_popup_closed_at_70, m3_.academy_popup_closed_at AS academy_popup_closed_at_71, m4_.id AS id_72, m4_.pack_name AS pack_name_73, m4_.created_at AS created_at_74, m4_.updated_at AS updated_at_75, m4_.shipping_method_id AS shipping_method_id_76, m4_.fees_in_cents AS fees_in_cents_77, m4_.futures_product AS futures_product_78, m4_.luume_product AS luume_product_79, m4_.is_over AS is_over_80, m4_.address_first_name AS address_first_name_81, m4_.address_last_name AS address_last_name_82, m4_.address_street AS address_street_83, m4_.address_postcode AS address_postcode_84, m4_.address_city AS address_city_85, m4_.address_country_code AS address_country_code_86, m4_.relay_name AS relay_name_87, m4_.relay_ref AS relay_ref_88, m4_.relay_street AS relay_street_89, m4_.relay_city AS relay_city_90, m4_.relay_postcode AS relay_postcode_91, m4_.relay_country_code AS relay_country_code_92, a0_.sponsor_id AS sponsor_id_93, a0_.parent_id AS parent_id_94, a0_.rank_id AS rank_id_95, a0_.pack_id AS pack_id_96, a0_.user_id AS user_id_97, a0_.market_id AS market_id_98, a0_.qualification_id AS qualification_id_99, a0_.subscription_gateway_id AS subscription_gateway_id_100, a0_.subscription_country_id AS subscription_country_id_101, a0_.currency_id AS currency_id_102, a0_.first_subscription_space_id AS first_subscription_space_id_103, m2_.parent_node_id AS parent_node_id_104, m2_.member_id AS member_id_105, m2_.tree_id AS tree_id_106, m3_.member_id AS member_id_107, m3_.company_country_id AS company_country_id_108, m3_.company_immatriculation_file_id AS company_immatriculation_file_id_109, m3_.company_vigilance_file_id AS company_vigilance_file_id_110, m3_.contract_file_id AS contract_file_id_111, m3_.certification_file_id AS certification_file_id_112, m4_.member_id AS member_id_113 FROM app_member a0_ INNER JOIN app_user a1_ ON a0_.user_id = a1_.id LEFT JOIN mybiz_member_node m2_ ON a0_.id = m2_.member_id LEFT JOIN mybiz_on_boarding m3_ ON a0_.id = m3_.member_id LEFT JOIN mybiz_qualified_choice m4_ ON a0_.id = m4_.member_id WHERE a1_.jwt_token = ? AND a1_.jwt_token_expiration > ? AND a0_.is_deleted = ?
Parameters:
[ "eK38jEdYiSpYa96VuvOmsbj6sk8KfgfFLyXbjBkZ57dJlehJZ9" "2026-03-03 09:34:53" 0 ] |
| 6 | 0.38 ms |
SELECT t0.id AS id_1, t0.nb_predictions AS nb_predictions_2, t0.member_id AS member_id_3 FROM app_member_prediction t0 WHERE t0.member_id = ?
Parameters:
[
271572
]
|
| 7 | 0.74 ms |
SELECT a0_.id AS id_0, a0_.identifier AS identifier_1, a0_.customer_id AS customer_id_2, a0_.card_id AS card_id_3, a0_.payment_agreement_id AS payment_agreement_id_4, a0_.begin_at AS begin_at_5, a0_.end_at AS end_at_6, a0_.cancellation_request_at AS cancellation_request_at_7, a0_.cancellation_at AS cancellation_at_8, a0_.refunded_at AS refunded_at_9, a0_.quantity AS quantity_10, a0_.created_at AS created_at_11, a0_.futures_pack_name AS futures_pack_name_12, a0_.luume_pack_name AS luume_pack_name_13, a0_.sent_to_luume_at AS sent_to_luume_at_14, a0_.context AS context_15, a0_.is_freedom AS is_freedom_16, a0_.is_qualified AS is_qualified_17, a0_.duration_total AS duration_total_18, a0_.has_full_points_distributed AS has_full_points_distributed_19, a0_.current_subscription_month AS current_subscription_month_20, a0_.freedom_duration AS freedom_duration_21, a0_.freedom_total_duration AS freedom_total_duration_22, a0_.total_prediction AS total_prediction_23, a0_.consumed_prediction AS consumed_prediction_24, a0_.decreasing_config_price AS decreasing_config_price_25, a0_.is_decreasing AS is_decreasing_26, a0_.member_id AS member_id_27, a0_.gateway_id AS gateway_id_28, a0_.country_id AS country_id_29, a0_.product_id AS product_id_30, a0_.payment_history_id AS payment_history_id_31, a0_.previous_subscription_id AS previous_subscription_id_32, a0_.initial_product_id AS initial_product_id_33 FROM app_subscription a0_ INNER JOIN app_product a1_ ON a0_.product_id = a1_.id WHERE a0_.member_id = ? AND a1_.type = ? AND a1_.space_id = ? AND a0_.begin_at <= ? AND a0_.end_at >= ? AND a0_.cancellation_at IS NULL
Parameters:
[ 271572 "pack" 1 "2026-03-03 09:34:53" "2026-03-03 09:34:53" ] |
| 8 | 1.55 ms |
SELECT f0_.id AS id_0, f0_.language AS language_1, f0_.title AS title_2, f0_.description AS description_3, f0_.start_at AS start_at_4, f0_.end_at AS end_at_5, f0_.streaming_meeting_id AS streaming_meeting_id_6, f0_.streaming_meeting_password AS streaming_meeting_password_7, a1_.id AS id_8, a1_.name AS name_9, a1_.is_enabled AS is_enabled_10, a1_.image AS image_11, a1_.type AS type_12, a1_.translation_key AS translation_key_13, a1_.is_bundle AS is_bundle_14, a2_.id AS id_15, a2_.name AS name_16, a2_.marketing_name AS marketing_name_17, a2_.color AS color_18, a2_.is_enabled AS is_enabled_19, a1_.feature_type_id AS feature_type_id_20, a2_.space_id AS space_id_21 FROM futures_event f0_ INNER JOIN futures_event_features f3_ ON f0_.id = f3_.futures_event_id INNER JOIN app_feature a1_ ON a1_.id = f3_.feature_id INNER JOIN app_feature_type a2_ ON a1_.feature_type_id = a2_.id WHERE f0_.start_at >= ? AND f0_.end_at <= ?
Parameters:
[ "2026-03-02 00:00:00" "2026-03-08 23:59:59" ] |
| 9 | 0.35 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.sku AS sku_4, t0.is_enabled AS is_enabled_5, t0.is_subscibable AS is_subscibable_6, t0.is_ikigai_pack AS is_ikigai_pack_7, t0.is_printable AS is_printable_8, t0.marketing_name AS marketing_name_9, t0.image_path AS image_path_10, t0.color AS color_11, t0.context AS context_12, t0.space_id AS space_id_13 FROM app_product t0 WHERE t0.id = ?
Parameters:
[
9
]
|
| 10 | 0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_enabled AS is_enabled_3, t0.image AS image_4, t0.type AS type_5, t0.translation_key AS translation_key_6, t0.is_bundle AS is_bundle_7, t0.feature_type_id AS feature_type_id_8 FROM app_feature t0 INNER JOIN app_product_features ON t0.id = app_product_features.feature_id WHERE app_product_features.product_id = ?
Parameters:
[
9
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Service\Feature | 15 |
| App\Entity\Service\FeatureType | 4 |
| App\Entity\Space\Space | 3 |
| App\Entity\Member\Member | 3 |
| App\Entity\Mybiz\MemberNode | 2 |
| App\Entity\Parameter\Parameter | 1 |
| App\Entity\Parameter\Market | 1 |
| App\Entity\Parameter\Gateway | 1 |
| App\Entity\Parameter\Country | 1 |
| App\Entity\Parameter\Currency | 1 |
| App\Entity\Member\User | 1 |
| App\Entity\Mybiz\Tree | 1 |
| App\Entity\Payment\Subscription | 1 |
| App\Entity\Product\Product | 1 |
| App\Entity\Payment\PaymentHistory | 1 |