GET https://preprod-backapp.utech.care/api/discussions/164

Query Metrics

30 Database Queries
15 Different statements
68.18 ms Query time
0 Invalid entities
22 Managed entities

Grouped Statements

Show all queries

Time Count Info
11.81 ms
(17.32%)
5
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_user AS dis_user_15, t1.dis_assigned_to AS dis_assigned_to_16, t1.dis_task AS dis_task_17, t1.dis_closed_by AS dis_closed_by_18 FROM discussion t0 LEFT JOIN discussion_support t1 ON t0.dis_id = t1.dis_id WHERE t0.dis_id = ?
Parameters:
[
  66
]
11.63 ms
(17.06%)
6
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, t1.usr_address_id AS usr_address_id_49, t1.usr_bank_account_id AS usr_bank_account_id_50, t0.int_sector_id AS int_sector_id_51, t0.int_coordinator_discussion_id AS int_coordinator_discussion_id_52, t0.int_instigator_id AS int_instigator_id_53, t0.int_referrer_id AS int_referrer_id_54, t1.type FROM intervener t0 INNER JOIN user_account t1 ON t0.usr_id = t1.usr_id WHERE t0.int_coordinator_discussion_id = ?
Parameters:
[
  66
]
10.57 ms
(15.50%)
1
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[
  "2026-07-01 10:49:18+0200"
  23
]
8.65 ms
(12.69%)
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_suivi_id AS cus_suivi_id_55, t1.cus_suivi_administrative_id AS cus_suivi_administrative_id_56, t1.cus_sector_id AS cus_sector_id_57, t1.cus_suivi_pro_id AS cus_suivi_pro_id_58, t1.cus_suivi_health_id AS cus_suivi_health_id_59, t1.cus_origin_id AS cus_origin_id_60, t1.cus_couple_id AS cus_couple_id_61, t2.int_id_employee AS int_id_employee_62, t2.int_number AS int_number_63, t2.int_has_to_be_validate AS int_has_to_be_validate_64, t2.int_completness AS int_completness_65, t2.int_social_insurance_number AS int_social_insurance_number_66, t2.int_nationality AS int_nationality_67, t2.int_coach_level_type AS int_coach_level_type_68, t2.int_referral_code AS int_referral_code_69, t2.int_onboarding_completed_at AS int_onboarding_completed_at_70, t2.int_social_skills_score AS int_social_skills_score_71, t2.int_social_skills_computed_at AS int_social_skills_computed_at_72, t2.int_sector_id AS int_sector_id_73, t2.int_coordinator_discussion_id AS int_coordinator_discussion_id_74, t2.int_instigator_id AS int_instigator_id_75, t2.int_referrer_id AS int_referrer_id_76, t3.una_url_photo AS una_url_photo_77, t3.una_sector_id AS una_sector_id_78, t4.rel_valid AS rel_valid_79, t4.rel_customer_string AS rel_customer_string_80, t5.hepr_valid AS hepr_valid_81, t5.hepr_customer_string AS hepr_customer_string_82 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:
[
  "customer1@utech.care"
]
8.14 ms
(11.95%)
2
SELECT t0.gat_notification_state AS gat_notification_state_1, t0.gat_is_favorite AS gat_is_favorite_2, t0.gat_nb_unread AS gat_nb_unread_3, t0.gat_discussion_id AS gat_discussion_id_4, t0.gat_user_id AS gat_user_id_5, t0.gat_last_message_read_id AS gat_last_message_read_id_6 FROM gather t0 WHERE t0.gat_user_id = ? AND t0.gat_discussion_id = ? LIMIT 1
Parameters:
[
  23
  164
]
6.41 ms
(9.40%)
1
SELECT d0_.dis_id AS dis_id_0, d0_.dis_title AS dis_title_1, d0_.dis_create_date AS dis_create_date_2, d0_.dis_type AS dis_type_3, d0_.dis_image AS dis_image_4, u1_.usr_id AS usr_id_5, u1_.usr_mail AS usr_mail_6, u1_.usr_pwd AS usr_pwd_7, u1_.usr_title AS usr_title_8, u1_.usr_first_name AS usr_first_name_9, u1_.usr_last_name AS usr_last_name_10, u1_.usr_maiden_name AS usr_maiden_name_11, u1_.usr_date_of_birth AS usr_date_of_birth_12, u1_.usr_last_connection AS usr_last_connection_13, u1_.usr_register AS usr_register_14, u1_.usr_rank AS usr_rank_15, u1_.usr_slug AS usr_slug_16, u1_.usr_active AS usr_active_17, u1_.usr_update AS usr_update_18, u1_.usr_inactive_date AS usr_inactive_date_19, u1_.usr_token_reset_password AS usr_token_reset_password_20, u1_.usr_avatar AS usr_avatar_21, u1_.usr_is_blocked AS usr_is_blocked_22, u1_.usr_date_is_blocked AS usr_date_is_blocked_23, u1_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_24, u1_.usr_main_phone AS usr_main_phone_25, u1_.usr_additional_phone AS usr_additional_phone_26, u1_.usr_google_id AS usr_google_id_27, u1_.usr_apple_id AS usr_apple_id_28, u1_.usr_facebook_id AS usr_facebook_id_29, u1_.usr_has_2fa AS usr_has_2fa_30, u1_.usr_2fa_code AS usr_2fa_code_31, u1_.usr_2fa_method AS usr_2fa_method_32, u1_.usr_2fa_version AS usr_2fa_version_33, u1_.usr_balance AS usr_balance_34, u1_.usr_bank_id AS usr_bank_id_35, u1_.usr_bank_is_completed AS usr_bank_is_completed_36, u1_.usr_place_of_birth AS usr_place_of_birth_37, u1_.usr_country_of_birth AS usr_country_of_birth_38, u1_.usr_department_of_birth AS usr_department_of_birth_39, u1_.usr_app_settings AS usr_app_settings_40, c2_.cus_id_customer AS cus_id_customer_41, c2_.cus_code AS cus_code_42, c2_.cus_door_code AS cus_door_code_43, c2_.cus_intercom_code AS cus_intercom_code_44, c2_.cus_valid AS cus_valid_45, c2_.social_insurance_number AS social_insurance_number_46, c2_.cus_prescriptor_id AS cus_prescriptor_id_47, c2_.cus_prescriptor_type AS cus_prescriptor_type_48, c2_.cus_gir_score AS cus_gir_score_49, u3_.usr_id AS usr_id_50, u3_.usr_mail AS usr_mail_51, u3_.usr_pwd AS usr_pwd_52, u3_.usr_title AS usr_title_53, u3_.usr_first_name AS usr_first_name_54, u3_.usr_last_name AS usr_last_name_55, u3_.usr_maiden_name AS usr_maiden_name_56, u3_.usr_date_of_birth AS usr_date_of_birth_57, u3_.usr_last_connection AS usr_last_connection_58, u3_.usr_register AS usr_register_59, u3_.usr_rank AS usr_rank_60, u3_.usr_slug AS usr_slug_61, u3_.usr_active AS usr_active_62, u3_.usr_update AS usr_update_63, u3_.usr_inactive_date AS usr_inactive_date_64, u3_.usr_token_reset_password AS usr_token_reset_password_65, u3_.usr_avatar AS usr_avatar_66, u3_.usr_is_blocked AS usr_is_blocked_67, u3_.usr_date_is_blocked AS usr_date_is_blocked_68, u3_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_69, u3_.usr_main_phone AS usr_main_phone_70, u3_.usr_additional_phone AS usr_additional_phone_71, u3_.usr_google_id AS usr_google_id_72, u3_.usr_apple_id AS usr_apple_id_73, u3_.usr_facebook_id AS usr_facebook_id_74, u3_.usr_has_2fa AS usr_has_2fa_75, u3_.usr_2fa_code AS usr_2fa_code_76, u3_.usr_2fa_method AS usr_2fa_method_77, u3_.usr_2fa_version AS usr_2fa_version_78, u3_.usr_balance AS usr_balance_79, u3_.usr_bank_id AS usr_bank_id_80, u3_.usr_bank_is_completed AS usr_bank_is_completed_81, u3_.usr_place_of_birth AS usr_place_of_birth_82, u3_.usr_country_of_birth AS usr_country_of_birth_83, u3_.usr_department_of_birth AS usr_department_of_birth_84, u3_.usr_app_settings AS usr_app_settings_85, c4_.cus_id_customer AS cus_id_customer_86, c4_.cus_code AS cus_code_87, c4_.cus_door_code AS cus_door_code_88, c4_.cus_intercom_code AS cus_intercom_code_89, c4_.cus_valid AS cus_valid_90, c4_.social_insurance_number AS social_insurance_number_91, c4_.cus_prescriptor_id AS cus_prescriptor_id_92, c4_.cus_prescriptor_type AS cus_prescriptor_type_93, c4_.cus_gir_score AS cus_gir_score_94, u5_.usr_id AS usr_id_95, u5_.usr_mail AS usr_mail_96, u5_.usr_pwd AS usr_pwd_97, u5_.usr_title AS usr_title_98, u5_.usr_first_name AS usr_first_name_99, u5_.usr_last_name AS usr_last_name_100, u5_.usr_maiden_name AS usr_maiden_name_101, u5_.usr_date_of_birth AS usr_date_of_birth_102, u5_.usr_last_connection AS usr_last_connection_103, u5_.usr_register AS usr_register_104, u5_.usr_rank AS usr_rank_105, u5_.usr_slug AS usr_slug_106, u5_.usr_active AS usr_active_107, u5_.usr_update AS usr_update_108, u5_.usr_inactive_date AS usr_inactive_date_109, u5_.usr_token_reset_password AS usr_token_reset_password_110, u5_.usr_avatar AS usr_avatar_111, u5_.usr_is_blocked AS usr_is_blocked_112, u5_.usr_date_is_blocked AS usr_date_is_blocked_113, u5_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_114, u5_.usr_main_phone AS usr_main_phone_115, u5_.usr_additional_phone AS usr_additional_phone_116, u5_.usr_google_id AS usr_google_id_117, u5_.usr_apple_id AS usr_apple_id_118, u5_.usr_facebook_id AS usr_facebook_id_119, u5_.usr_has_2fa AS usr_has_2fa_120, u5_.usr_2fa_code AS usr_2fa_code_121, u5_.usr_2fa_method AS usr_2fa_method_122, u5_.usr_2fa_version AS usr_2fa_version_123, u5_.usr_balance AS usr_balance_124, u5_.usr_bank_id AS usr_bank_id_125, u5_.usr_bank_is_completed AS usr_bank_is_completed_126, u5_.usr_place_of_birth AS usr_place_of_birth_127, u5_.usr_country_of_birth AS usr_country_of_birth_128, u5_.usr_department_of_birth AS usr_department_of_birth_129, u5_.usr_app_settings AS usr_app_settings_130, c6_.cus_id_customer AS cus_id_customer_131, c6_.cus_code AS cus_code_132, c6_.cus_door_code AS cus_door_code_133, c6_.cus_intercom_code AS cus_intercom_code_134, c6_.cus_valid AS cus_valid_135, c6_.social_insurance_number AS social_insurance_number_136, c6_.cus_prescriptor_id AS cus_prescriptor_id_137, c6_.cus_prescriptor_type AS cus_prescriptor_type_138, c6_.cus_gir_score AS cus_gir_score_139, u7_.usr_id AS usr_id_140, u7_.usr_mail AS usr_mail_141, u7_.usr_pwd AS usr_pwd_142, u7_.usr_title AS usr_title_143, u7_.usr_first_name AS usr_first_name_144, u7_.usr_last_name AS usr_last_name_145, u7_.usr_maiden_name AS usr_maiden_name_146, u7_.usr_date_of_birth AS usr_date_of_birth_147, u7_.usr_last_connection AS usr_last_connection_148, u7_.usr_register AS usr_register_149, u7_.usr_rank AS usr_rank_150, u7_.usr_slug AS usr_slug_151, u7_.usr_active AS usr_active_152, u7_.usr_update AS usr_update_153, u7_.usr_inactive_date AS usr_inactive_date_154, u7_.usr_token_reset_password AS usr_token_reset_password_155, u7_.usr_avatar AS usr_avatar_156, u7_.usr_is_blocked AS usr_is_blocked_157, u7_.usr_date_is_blocked AS usr_date_is_blocked_158, u7_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_159, u7_.usr_main_phone AS usr_main_phone_160, u7_.usr_additional_phone AS usr_additional_phone_161, u7_.usr_google_id AS usr_google_id_162, u7_.usr_apple_id AS usr_apple_id_163, u7_.usr_facebook_id AS usr_facebook_id_164, u7_.usr_has_2fa AS usr_has_2fa_165, u7_.usr_2fa_code AS usr_2fa_code_166, u7_.usr_2fa_method AS usr_2fa_method_167, u7_.usr_2fa_version AS usr_2fa_version_168, u7_.usr_balance AS usr_balance_169, u7_.usr_bank_id AS usr_bank_id_170, u7_.usr_bank_is_completed AS usr_bank_is_completed_171, u7_.usr_place_of_birth AS usr_place_of_birth_172, u7_.usr_country_of_birth AS usr_country_of_birth_173, u7_.usr_department_of_birth AS usr_department_of_birth_174, u7_.usr_app_settings AS usr_app_settings_175, c8_.cus_id_customer AS cus_id_customer_176, c8_.cus_code AS cus_code_177, c8_.cus_door_code AS cus_door_code_178, c8_.cus_intercom_code AS cus_intercom_code_179, c8_.cus_valid AS cus_valid_180, c8_.social_insurance_number AS social_insurance_number_181, c8_.cus_prescriptor_id AS cus_prescriptor_id_182, c8_.cus_prescriptor_type AS cus_prescriptor_type_183, c8_.cus_gir_score AS cus_gir_score_184, d0_.dis_entity AS dis_entity_185, u1_.type AS type_186, u3_.type AS type_187, u5_.type AS type_188, u7_.type AS type_189 FROM discussion d0_ LEFT JOIN customer c2_ ON d0_.dis_id = c2_.cus_suivi_id LEFT JOIN user_account u1_ ON c2_.usr_id = u1_.usr_id LEFT JOIN customer c4_ ON d0_.dis_id = c4_.cus_suivi_pro_id LEFT JOIN user_account u3_ ON c4_.usr_id = u3_.usr_id LEFT JOIN customer c6_ ON d0_.dis_id = c6_.cus_suivi_administrative_id LEFT JOIN user_account u5_ ON c6_.usr_id = u5_.usr_id LEFT JOIN customer c8_ ON d0_.dis_id = c8_.cus_suivi_health_id LEFT JOIN user_account u7_ ON c8_.usr_id = u7_.usr_id WHERE d0_.dis_id = ?
Parameters:
[
  164
]
3.80 ms
(5.57%)
1
"START TRANSACTION"
Parameters:
[]
2.89 ms
(4.24%)
6
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:
[
  66
]
1.05 ms
(1.54%)
1
"COMMIT"
Parameters:
[]
0.92 ms
(1.35%)
1
SELECT g0_.gat_notification_state AS gat_notification_state_0, g0_.gat_is_favorite AS gat_is_favorite_1, g0_.gat_nb_unread AS gat_nb_unread_2, u1_.usr_id AS usr_id_3, u1_.usr_mail AS usr_mail_4, u1_.usr_pwd AS usr_pwd_5, u1_.usr_title AS usr_title_6, u1_.usr_first_name AS usr_first_name_7, u1_.usr_last_name AS usr_last_name_8, u1_.usr_maiden_name AS usr_maiden_name_9, u1_.usr_date_of_birth AS usr_date_of_birth_10, u1_.usr_last_connection AS usr_last_connection_11, u1_.usr_register AS usr_register_12, u1_.usr_rank AS usr_rank_13, u1_.usr_slug AS usr_slug_14, u1_.usr_active AS usr_active_15, u1_.usr_update AS usr_update_16, u1_.usr_inactive_date AS usr_inactive_date_17, u1_.usr_token_reset_password AS usr_token_reset_password_18, u1_.usr_avatar AS usr_avatar_19, u1_.usr_is_blocked AS usr_is_blocked_20, u1_.usr_date_is_blocked AS usr_date_is_blocked_21, u1_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_22, u1_.usr_main_phone AS usr_main_phone_23, u1_.usr_additional_phone AS usr_additional_phone_24, u1_.usr_google_id AS usr_google_id_25, u1_.usr_apple_id AS usr_apple_id_26, u1_.usr_facebook_id AS usr_facebook_id_27, u1_.usr_has_2fa AS usr_has_2fa_28, u1_.usr_2fa_code AS usr_2fa_code_29, u1_.usr_2fa_method AS usr_2fa_method_30, u1_.usr_2fa_version AS usr_2fa_version_31, u1_.usr_balance AS usr_balance_32, u1_.usr_bank_id AS usr_bank_id_33, u1_.usr_bank_is_completed AS usr_bank_is_completed_34, u1_.usr_place_of_birth AS usr_place_of_birth_35, u1_.usr_country_of_birth AS usr_country_of_birth_36, u1_.usr_department_of_birth AS usr_department_of_birth_37, u1_.usr_app_settings AS usr_app_settings_38, g0_.gat_discussion_id AS gat_discussion_id_39, g0_.gat_user_id AS gat_user_id_40, u1_.type AS type_41 FROM gather g0_ LEFT JOIN user_account u1_ ON g0_.gat_user_id = u1_.usr_id WHERE g0_.gat_discussion_id = ?
Parameters:
[
  164
]
0.79 ms
(1.17%)
1
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:
[
  8
]
0.50 ms
(0.73%)
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:
[
  74
]
0.38 ms
(0.56%)
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:
[
  74
]
0.34 ms
(0.50%)
1
SELECT t0.gat_notification_state AS gat_notification_state_1, t0.gat_is_favorite AS gat_is_favorite_2, t0.gat_nb_unread AS gat_nb_unread_3, t0.gat_discussion_id AS gat_discussion_id_4, t0.gat_user_id AS gat_user_id_5, t0.gat_last_message_read_id AS gat_last_message_read_id_6 FROM gather t0 WHERE t0.gat_discussion_id = ? AND t0.gat_user_id = ?
Parameters:
[
  "164"
  "23"
]
0.30 ms
(0.44%)
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:
[
  74
]

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\Discussion\Discussion 6
App\Entity\Discussion\Message 5
App\Entity\User\User 4
App\Entity\Discussion\Gather 3
App\Entity\Address 1
App\Entity\Sector 1
App\Entity\Origin 1
App\Entity\Autonomous\AutonomousTeam 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\Discussion\DiscussionSupport No errors.
App\Entity\Discussion\Message No errors.
App\Entity\Autonomous\AutonomousTeam No errors.
App\Entity\Rtu\RtuSector No errors.
App\Entity\Rtu\RtuCities No errors.
App\Entity\Contract No errors.
App\Entity\Employment No errors.
App\Entity\CustomerNeed No errors.
App\Entity\HistoryEntry No errors.
App\Entity\Autonomous\AutonomousTeamRequest No errors.
App\Entity\Autonomous\AutonomousTeamMembers No errors.
App\Entity\SolicitationIntervenerKnowHowScore No errors.