Query Metrics
14
Database Queries
12
Different statements
41.21 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 20.45 ms |
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"
]
|
| 2 | 1.16 ms |
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
]
|
| 3 | 0.27 ms |
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:
[
2
]
|
| 4 | 0.34 ms |
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:
[
1
]
|
| 5 | 0.54 ms |
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
]
|
| 6 | 0.99 ms |
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
]
|
| 7 | 0.93 ms |
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
]
|
| 8 | 0.30 ms |
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
]
|
| 9 | 0.48 ms |
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
]
|
| 10 | 0.35 ms |
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
]
|
| 11 | 0.29 ms |
"START TRANSACTION"
Parameters:
[] |
| 12 | 1.07 ms |
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[ "2026-09-01 14:12:44+0200" 53 ] |
| 13 | 1.06 ms |
"COMMIT"
Parameters:
[] |
| 14 | 12.99 ms |
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
]
|
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 |