Query Metrics
6
Database Queries
6
Different statements
12.83 ms
Query time
0
Invalid entities
47
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 5.32 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.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.id = ?
Parameters:
[
103488
]
|
| 2 | 0.37 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:
[
181918
]
|
| 3 | 1.38 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.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 = ?
Parameters:
[
181918
]
|
| 4 | 3.50 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:
[
181918
]
|
| 5 | 0.75 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"
]
|
| 6 | 1.51 ms |
SELECT a0_.id AS id_0, a0_.is_readed AS is_readed_1, a1_.id AS id_2, a1_.title_fr AS title_fr_3, a1_.title_en AS title_en_4, a1_.title_es AS title_es_5, a1_.title_ar AS title_ar_6, a1_.description_fr AS description_fr_7, a1_.description_en AS description_en_8, a1_.description_es AS description_es_9, a1_.description_ar AS description_ar_10, a1_.publication_date AS publication_date_11, a1_.color AS color_12, a1_.icon AS icon_13, a1_.link AS link_14, a1_.link_label AS link_label_15, a1_.has_license AS has_license_16, a1_.is_enabled AS is_enabled_17, a1_.is_in_modal AS is_in_modal_18, a1_.has_to_sent_by_notification AS has_to_sent_by_notification_19, a1_.has_to_sent_by_mail AS has_to_sent_by_mail_20, a0_.member_id AS member_id_21, a0_.notification_id AS notification_id_22, a1_.product_id AS product_id_23, a1_.market_id AS market_id_24, a1_.qualification_id AS qualification_id_25, a1_.member_id AS member_id_26, a1_.space_id AS space_id_27 FROM app_member_notification a0_ LEFT JOIN app_notification a1_ ON a0_.notification_id = a1_.id WHERE a0_.member_id = ? AND a1_.publication_date <= ? ORDER BY a1_.publication_date DESC LIMIT 20
Parameters:
[ 181918 "2026-02-04 09:53:10" ] |
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\Member\MemberNotification | 15 |
| App\Entity\Parameter\Notification | 15 |
| App\Entity\Space\Space | 3 |
| App\Entity\Member\Member | 2 |
| App\Entity\Member\User | 1 |
| App\Entity\Mybiz\Rank | 1 |
| App\Entity\Product\Product | 1 |
| App\Entity\Mybiz\MemberNode | 1 |
| App\Entity\Parameter\Market | 1 |
| App\Entity\Parameter\Gateway | 1 |
| App\Entity\Parameter\Country | 1 |
| App\Entity\Parameter\Currency | 1 |
| App\Entity\Mybiz\QualifiedChoice | 1 |
| App\Entity\Mybiz\MybizOnBoarding | 1 |
| App\Entity\Member\MemberDocument | 1 |
| App\Entity\Parameter\Parameter | 1 |