Query Metrics
6
Database Queries
4
Different statements
7.34 ms
Query time
0
Invalid entities
24
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.19 ms (43.47%) |
3 |
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"
]
|
|
1.69 ms (22.95%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.status AS status_3, t0.member_date AS member_date_4, t0.enabled AS enabled_5, t0.is_insider AS is_insider_6, t0.accept_offers AS accept_offers_7, t0.accept_terms_date AS accept_terms_date_8, t0.has_premium_deducted AS has_premium_deducted_9, t0.liberty_pack AS liberty_pack_10, t0.preferred_language AS preferred_language_11, t0.saving_bonus AS saving_bonus_12, t0.saving_bonus_reached_at AS saving_bonus_reached_at_13, t0.is_new AS is_new_14, t0.birthday AS birthday_15, t0.last_sponsor_attribution_at AS last_sponsor_attribution_at_16, t0.is_offered_sponsor AS is_offered_sponsor_17, t0.discord_id AS discord_id_18, t0.step_elite AS step_elite_19, t0.is_deleted AS is_deleted_20, t0.sponsor_id AS sponsor_id_21, t0.parent_id AS parent_id_22, t0.rank_id AS rank_id_23, t0.pack_id AS pack_id_24, t0.user_id AS user_id_25, t0.member_node_id AS member_node_id_26, t0.market_id AS market_id_27, t0.qualification_id AS qualification_id_28, t29.id AS id_30, t29.nb_predictions AS nb_predictions_31, t29.member_id AS member_id_32, t0.subscription_gateway_id AS subscription_gateway_id_33, t0.subscription_country_id AS subscription_country_id_34, t0.currency_id AS currency_id_35, t0.first_subscription_space_id AS first_subscription_space_id_36, t37.id AS id_38, t37.pack_name AS pack_name_39, t37.created_at AS created_at_40, t37.updated_at AS updated_at_41, t37.shipping_method_id AS shipping_method_id_42, t37.fees_in_cents AS fees_in_cents_43, t37.futures_product AS futures_product_44, t37.luume_product AS luume_product_45, t37.is_over AS is_over_46, t37.address_first_name AS address_first_name_47, t37.address_last_name AS address_last_name_48, t37.address_street AS address_street_49, t37.address_postcode AS address_postcode_50, t37.address_city AS address_city_51, t37.address_country_code AS address_country_code_52, t37.relay_name AS relay_name_53, t37.relay_ref AS relay_ref_54, t37.relay_street AS relay_street_55, t37.relay_city AS relay_city_56, t37.relay_postcode AS relay_postcode_57, t37.relay_country_code AS relay_country_code_58, t37.member_id AS member_id_59, t60.id AS id_61, t60.limit_date AS limit_date_62, t60.kyc_validated_at AS kyc_validated_at_63, t60.siret_validated_at AS siret_validated_at_64, t60.company_immatriculation_validated_at AS company_immatriculation_validated_at_65, t60.declaration_validated_at AS declaration_validated_at_66, t60.company_vigilance_validated_at AS company_vigilance_validated_at_67, t60.contract_validated_at AS contract_validated_at_68, t60.company_status AS company_status_69, t60.company_umbrella AS company_umbrella_70, t60.company_name AS company_name_71, t60.kyc_first_name AS kyc_first_name_72, t60.kyc_last_name AS kyc_last_name_73, t60.kyc_birthday AS kyc_birthday_74, t60.company_siren AS company_siren_75, t60.company_address_street AS company_address_street_76, t60.company_address_postcode AS company_address_postcode_77, t60.company_address_city AS company_address_city_78, t60.applicant_id AS applicant_id_79, t60.workflow_run_id AS workflow_run_id_80, t60.sdk_token AS sdk_token_81, t60.kyc_status AS kyc_status_82, t60.certified_at AS certified_at_83, t60.is_kyc_infos_extracted AS is_kyc_infos_extracted_84, t60.certified_popup_closed_at AS certified_popup_closed_at_85, t60.academy_popup_closed_at AS academy_popup_closed_at_86, t60.member_id AS member_id_87, t60.company_country_id AS company_country_id_88, t60.company_immatriculation_file_id AS company_immatriculation_file_id_89, t60.company_vigilance_file_id AS company_vigilance_file_id_90, t60.contract_file_id AS contract_file_id_91, t60.certification_file_id AS certification_file_id_92 FROM app_member t0 LEFT JOIN app_member_prediction t29 ON t29.member_id = t0.id LEFT JOIN mybiz_qualified_choice t37 ON t37.member_id = t0.id LEFT JOIN mybiz_on_boarding t60 ON t60.member_id = t0.id WHERE t0.id = ?
Parameters:
[
"270690"
]
|
|
1.26 ms (17.15%) |
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
Parameters:
[] |
|
1.21 ms (16.43%) |
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
Parameters:
[
"app.maintenance.lock"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Mybiz\Rank | 11 |
| App\Entity\Space\Space | 3 |
| App\Entity\Member\Member | 2 |
| App\Entity\Parameter\Parameter | 1 |
| App\Entity\Member\User | 1 |
| App\Entity\Mybiz\MemberNode | 1 |
| App\Entity\Parameter\Market | 1 |
| App\Entity\Parameter\Country | 1 |
| App\Entity\Parameter\Currency | 1 |
| App\Entity\Mybiz\MybizOnBoarding | 1 |
| App\Entity\Member\MemberDocument | 1 |