GET https://preprod-backapp.utech.care/api/users/53/badge-unlocks

Query Metrics

14 Database Queries
12 Different statements
41.21 ms Query time
0 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
20.45 ms
(49.62%)
1
SELECT t0.usr_id AS usr_id_8, t0.usr_mail AS usr_mail_9, t0.usr_pwd AS usr_pwd_10, t0.usr_title AS usr_title_11, t0.usr_first_name AS usr_first_name_12, t0.usr_last_name AS usr_last_name_13, t0.usr_maiden_name AS usr_maiden_name_14, t0.usr_date_of_birth AS usr_date_of_birth_15, t0.usr_last_connection AS usr_last_connection_16, t0.usr_register AS usr_register_17, t0.usr_rank AS usr_rank_18, t0.usr_slug AS usr_slug_19, t0.usr_active AS usr_active_20, t0.usr_update AS usr_update_21, t0.usr_inactive_date AS usr_inactive_date_22, t0.usr_token_reset_password AS usr_token_reset_password_23, t0.usr_avatar AS usr_avatar_24, t0.usr_is_blocked AS usr_is_blocked_25, t0.usr_date_is_blocked AS usr_date_is_blocked_26, t0.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_27, t0.usr_main_phone AS usr_main_phone_28, t0.usr_additional_phone AS usr_additional_phone_29, t0.usr_google_id AS usr_google_id_30, t0.usr_apple_id AS usr_apple_id_31, t0.usr_facebook_id AS usr_facebook_id_32, t0.usr_has_2fa AS usr_has_2fa_33, t0.usr_2fa_code AS usr_2fa_code_34, t0.usr_2fa_method AS usr_2fa_method_35, t0.usr_2fa_version AS usr_2fa_version_36, t0.usr_balance AS usr_balance_37, t0.usr_bank_id AS usr_bank_id_38, t0.usr_bank_is_completed AS usr_bank_is_completed_39, t0.usr_place_of_birth AS usr_place_of_birth_40, t0.usr_country_of_birth AS usr_country_of_birth_41, t0.usr_department_of_birth AS usr_department_of_birth_42, t0.usr_app_settings AS usr_app_settings_43, t0.usr_address_id AS usr_address_id_44, t0.usr_bank_account_id AS usr_bank_account_id_45, t0.type, t1.cus_id_customer AS cus_id_customer_46, t1.cus_code AS cus_code_47, t1.cus_door_code AS cus_door_code_48, t1.cus_intercom_code AS cus_intercom_code_49, t1.cus_valid AS cus_valid_50, t1.social_insurance_number AS social_insurance_number_51, t1.cus_prescriptor_id AS cus_prescriptor_id_52, t1.cus_prescriptor_type AS cus_prescriptor_type_53, t1.cus_gir_score AS cus_gir_score_54, t1.cus_closer_id AS cus_closer_id_55, t1.cus_closer_type AS cus_closer_type_56, t1.cus_suivi_id AS cus_suivi_id_57, t1.cus_suivi_administrative_id AS cus_suivi_administrative_id_58, t1.cus_sector_id AS cus_sector_id_59, t1.cus_suivi_pro_id AS cus_suivi_pro_id_60, t1.cus_suivi_health_id AS cus_suivi_health_id_61, t1.cus_origin_id AS cus_origin_id_62, t1.cus_couple_id AS cus_couple_id_63, t2.int_id_employee AS int_id_employee_64, t2.int_number AS int_number_65, t2.int_has_to_be_validate AS int_has_to_be_validate_66, t2.int_completness AS int_completness_67, t2.int_social_insurance_number AS int_social_insurance_number_68, t2.int_nationality AS int_nationality_69, t2.int_coach_level_type AS int_coach_level_type_70, t2.int_referral_code AS int_referral_code_71, t2.int_onboarding_completed_at AS int_onboarding_completed_at_72, t2.int_social_skills_score AS int_social_skills_score_73, t2.int_social_skills_computed_at AS int_social_skills_computed_at_74, t2.int_has_mlm_vdi_contract AS int_has_mlm_vdi_contract_75, t2.int_mlm_vdi_contract_validated_at AS int_mlm_vdi_contract_validated_at_76, t2.int_has_mlm_commercial_agent_contract AS int_has_mlm_commercial_agent_contract_77, t2.int_mlm_commercial_agent_contract_validated_at AS int_mlm_commercial_agent_contract_validated_at_78, t2.int_mlm_level AS int_mlm_level_79, t2.int_rtu_zone_granted_at AS int_rtu_zone_granted_at_80, t2.int_sector_id AS int_sector_id_81, t2.int_coordinator_discussion_id AS int_coordinator_discussion_id_82, t2.int_instigator_id AS int_instigator_id_83, t2.int_referrer_id AS int_referrer_id_84, t2.int_rtu_zone_granted_by_id AS int_rtu_zone_granted_by_id_85, t3.una_url_photo AS una_url_photo_86, t3.una_sector_id AS una_sector_id_87, t4.rel_valid AS rel_valid_88, t4.rel_customer_string AS rel_customer_string_89, t5.hepr_valid AS hepr_valid_90, t5.hepr_customer_string AS hepr_customer_string_91 FROM user_account t0 LEFT JOIN customer t1 ON t0.usr_id = t1.usr_id LEFT JOIN intervener t2 ON t0.usr_id = t2.usr_id LEFT JOIN unaide t3 ON t0.usr_id = t3.usr_id LEFT JOIN relative t4 ON t0.usr_id = t4.usr_id LEFT JOIN health_professional t5 ON t0.usr_id = t5.usr_id LEFT JOIN co_living_manager t6 ON t0.usr_id = t6.usr_id LEFT JOIN co_living t7 ON t0.usr_id = t7.usr_id WHERE t0.usr_mail = ? LIMIT 1
Parameters:
[
  "intervener1@utech.care"
]
12.99 ms
(31.53%)
1
SELECT bu.badu_id as id,bu.badu_unlocked_at as unlockedAt,bu.badu_is_viewed as isWiewed,
        bl.badl_id,bl.badl_description,bl.badl_level,bl.badl_reference,
        bl.badl_condition,bl.badl_image,b.bad_name,b.bad_id,b.bad_type as type
        FROM badge_unlock bu
        INNER JOIN badge_level bl ON bl.badl_id = bu.badu_badge_level_id
        INNER JOIN user_account usr ON usr.usr_id = bu.badu_user_id
        INNER JOIN badge b ON b.bad_id = bl.badl_badge_id
        WHERE bu.badu_user_id = ?
Parameters:
[
  53
]
1.77 ms
(4.29%)
3
SELECT t0.sec_id AS sec_id_2, t0.sec_code AS sec_code_3, t0.sec_name AS sec_name_4, t0.number AS number_5, t0.sec_active AS sec_active_6, t0.sec_upper_sector_id AS sec_upper_sector_id_7, t0.sec_type, t1.rtu_sector_created_at AS rtu_sector_created_at_8, t1.rtu_sector_updated_at AS rtu_sector_updated_at_9, t1.rtu_user_id AS rtu_user_id_10 FROM sector t0 LEFT JOIN rtu_sector t1 ON t0.sec_id = t1.sec_id WHERE t0.sec_id = ?
Parameters:
[
  3
]
1.07 ms
(2.59%)
1
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[
  "2026-09-01 14:12:44+0200"
  53
]
1.06 ms
(2.58%)
1
"COMMIT"
Parameters:
[]
0.99 ms
(2.39%)
1
SELECT t0.dis_id AS dis_id_2, t0.dis_title AS dis_title_3, t0.dis_create_date AS dis_create_date_4, t0.dis_type AS dis_type_5, t0.dis_image AS dis_image_6, t0.dis_last_message_id AS dis_last_message_id_7, t0.dis_entity, t1.dis_number AS dis_number_8, t1.dis_status AS dis_status_9, t1.dis_category AS dis_category_10, t1.dis_description AS dis_description_11, t1.dis_updated_at AS dis_updated_at_12, t1.dis_closed_at AS dis_closed_at_13, t1.dis_has_unread AS dis_has_unread_14, t1.dis_pre_closed_at AS dis_pre_closed_at_15, t1.dis_satisfaction AS dis_satisfaction_16, t1.dis_is_urgent AS dis_is_urgent_17, t1.dis_user AS dis_user_18, t1.dis_assigned_to AS dis_assigned_to_19, t1.dis_task AS dis_task_20, t1.dis_closed_by AS dis_closed_by_21 FROM discussion t0 LEFT JOIN discussion_support t1 ON t0.dis_id = t1.dis_id WHERE t0.dis_id = ?
Parameters:
[
  132
]
0.93 ms
(2.25%)
1
SELECT t1.usr_id AS usr_id_2, t1.usr_mail AS usr_mail_3, t1.usr_pwd AS usr_pwd_4, t1.usr_title AS usr_title_5, t1.usr_first_name AS usr_first_name_6, t1.usr_last_name AS usr_last_name_7, t1.usr_maiden_name AS usr_maiden_name_8, t1.usr_date_of_birth AS usr_date_of_birth_9, t1.usr_last_connection AS usr_last_connection_10, t1.usr_register AS usr_register_11, t1.usr_rank AS usr_rank_12, t1.usr_slug AS usr_slug_13, t1.usr_active AS usr_active_14, t1.usr_update AS usr_update_15, t1.usr_inactive_date AS usr_inactive_date_16, t1.usr_token_reset_password AS usr_token_reset_password_17, t1.usr_avatar AS usr_avatar_18, t1.usr_is_blocked AS usr_is_blocked_19, t1.usr_date_is_blocked AS usr_date_is_blocked_20, t1.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_21, t1.usr_main_phone AS usr_main_phone_22, t1.usr_additional_phone AS usr_additional_phone_23, t1.usr_google_id AS usr_google_id_24, t1.usr_apple_id AS usr_apple_id_25, t1.usr_facebook_id AS usr_facebook_id_26, t1.usr_has_2fa AS usr_has_2fa_27, t1.usr_2fa_code AS usr_2fa_code_28, t1.usr_2fa_method AS usr_2fa_method_29, t1.usr_2fa_version AS usr_2fa_version_30, t1.usr_balance AS usr_balance_31, t1.usr_bank_id AS usr_bank_id_32, t1.usr_bank_is_completed AS usr_bank_is_completed_33, t1.usr_place_of_birth AS usr_place_of_birth_34, t1.usr_country_of_birth AS usr_country_of_birth_35, t1.usr_department_of_birth AS usr_department_of_birth_36, t1.usr_app_settings AS usr_app_settings_37, t0.int_id_employee AS int_id_employee_38, t0.int_number AS int_number_39, t0.int_has_to_be_validate AS int_has_to_be_validate_40, t0.int_completness AS int_completness_41, t0.int_social_insurance_number AS int_social_insurance_number_42, t0.int_nationality AS int_nationality_43, t0.int_coach_level_type AS int_coach_level_type_44, t0.int_referral_code AS int_referral_code_45, t0.int_onboarding_completed_at AS int_onboarding_completed_at_46, t0.int_social_skills_score AS int_social_skills_score_47, t0.int_social_skills_computed_at AS int_social_skills_computed_at_48, t0.int_has_mlm_vdi_contract AS int_has_mlm_vdi_contract_49, t0.int_mlm_vdi_contract_validated_at AS int_mlm_vdi_contract_validated_at_50, t0.int_has_mlm_commercial_agent_contract AS int_has_mlm_commercial_agent_contract_51, t0.int_mlm_commercial_agent_contract_validated_at AS int_mlm_commercial_agent_contract_validated_at_52, t0.int_mlm_level AS int_mlm_level_53, t0.int_rtu_zone_granted_at AS int_rtu_zone_granted_at_54, t1.usr_address_id AS usr_address_id_55, t1.usr_bank_account_id AS usr_bank_account_id_56, t0.int_sector_id AS int_sector_id_57, t0.int_coordinator_discussion_id AS int_coordinator_discussion_id_58, t0.int_instigator_id AS int_instigator_id_59, t0.int_referrer_id AS int_referrer_id_60, t0.int_rtu_zone_granted_by_id AS int_rtu_zone_granted_by_id_61, t1.type FROM intervener t0 INNER JOIN user_account t1 ON t0.usr_id = t1.usr_id WHERE t0.int_coordinator_discussion_id = ?
Parameters:
[
  132
]
0.54 ms
(1.30%)
1
SELECT t0.aut_id AS aut_id_1, t0.aut_title AS aut_title_2, t0.aut_description AS aut_description_3, t0.aut_avatar AS aut_avatar_4, t0.aut_created_at AS aut_created_at_5, t0.aut_updated_at AS aut_updated_at_6, t0.aut_coach_id AS aut_coach_id_7, t0.aut_discussion_id AS aut_discussion_id_8 FROM autonomous_team t0 WHERE t0.aut_coach_id = ?
Parameters:
[
  53
]
0.48 ms
(1.17%)
1
SELECT t0.atm_joined_at AS atm_joined_at_1, t0.atm_autonomous_team_id AS atm_autonomous_team_id_2, t0.atm_member_id AS atm_member_id_3 FROM autonomous_team_members t0 WHERE t0.atm_member_id = ?
Parameters:
[
  53
]
0.35 ms
(0.85%)
1
SELECT t1.sec_id AS sec_id_2, t1.sec_code AS sec_code_3, t1.sec_name AS sec_name_4, t1.number AS number_5, t1.sec_active AS sec_active_6, t0.rtu_sector_created_at AS rtu_sector_created_at_7, t0.rtu_sector_updated_at AS rtu_sector_updated_at_8, t1.sec_upper_sector_id AS sec_upper_sector_id_9, t0.rtu_user_id AS rtu_user_id_10, t1.sec_type FROM rtu_sector t0 INNER JOIN sector t1 ON t0.sec_id = t1.sec_id WHERE t0.rtu_user_id = ?
Parameters:
[
  53
]
0.30 ms
(0.72%)
1
SELECT t0.aut_id AS aut_id_1, t0.aut_title AS aut_title_2, t0.aut_description AS aut_description_3, t0.aut_avatar AS aut_avatar_4, t0.aut_created_at AS aut_created_at_5, t0.aut_updated_at AS aut_updated_at_6, t0.aut_coach_id AS aut_coach_id_7, t0.aut_discussion_id AS aut_discussion_id_8 FROM autonomous_team t0 WHERE t0.aut_discussion_id = ?
Parameters:
[
  132
]
0.29 ms
(0.70%)
1
"START TRANSACTION"
Parameters:
[]

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\Sector 3
App\Entity\User\User 1
App\Entity\Address 1
App\Entity\Autonomous\AutonomousTeam 1
App\Entity\Discussion\Discussion 1
App\Entity\Discussion\Message 1

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\User\User No errors.
App\Entity\User\Customer No errors.
App\Entity\User\Intervener No errors.
App\Entity\User\Unaide No errors.
App\Entity\User\Relative No errors.
App\Entity\User\HealthProfessional No errors.
App\Entity\User\CoLivingManager No errors.
App\Entity\User\CoLiving No errors.
App\Entity\Address No errors.
App\Entity\BankAccount No errors.
App\Entity\Discussion\Discussion No errors.
App\Entity\Sector No errors.
App\Entity\Origin No errors.
App\Entity\Couple No errors.
App\Entity\Firebase\NotificationDevice No errors.
App\Entity\Discussion\Gather No errors.
App\Entity\ExtractionsSynthesis No errors.
App\Entity\CircleNode No errors.
App\Entity\ReplacementPropose No errors.
App\Entity\Task No errors.
App\Entity\TaskNote No errors.
App\Entity\Document\Document No errors.
App\Entity\Gamification\BadgeUnlock No errors.
App\Entity\Gamification\CounterBadgeType No errors.
App\Entity\ServiceWeeklyReport No errors.
App\Entity\ServiceManageRequest No errors.
App\Entity\Rtu\RtuSector No errors.
App\Entity\Employment No errors.
App\Entity\Autonomous\AutonomousTeam No errors.
App\Entity\Autonomous\AutonomousTeamRequest No errors.
App\Entity\Autonomous\AutonomousTeamMembers No errors.
App\Entity\Discussion\DiscussionSupport No errors.
App\Entity\Discussion\Message No errors.
App\Entity\SolicitationIntervenerKnowHowScore No errors.
App\Entity\IntervenerMlmQualification No errors.
App\Entity\HistoryEntry No errors.