Query Metrics

79 Database Queries
25 Different statements
298.59 ms Query time
0 Invalid entities
52 Managed entities

Queries

Group similar statements

# Time Info
1 9.40 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_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"
]
2 9.83 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_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
]
3 0.79 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, 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
]
4 5.06 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:
[
  66
]
5 0.45 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_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:
[
  68
]
6 0.61 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, 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:
[
  68
]
7 0.25 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:
[
  68
]
8 10.46 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:
[
  8
]
9 2.32 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_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:
[
  67
]
10 3.69 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, 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:
[
  67
]
11 0.20 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:
[
  67
]
12 0.36 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_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:
[
  69
]
13 6.64 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, 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:
[
  69
]
14 0.23 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:
[
  69
]
15 12.85 ms
"START TRANSACTION"
Parameters:
[]
16 10.85 ms
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[
  "2026-07-01 10:49:10+0200"
  23
]
17 0.74 ms
"COMMIT"
Parameters:
[]
18 1.26 ms
SELECT t1.usr_id AS usr_id_3, t1.usr_mail AS usr_mail_4, t1.usr_pwd AS usr_pwd_5, t1.usr_title AS usr_title_6, t1.usr_first_name AS usr_first_name_7, t1.usr_last_name AS usr_last_name_8, t1.usr_maiden_name AS usr_maiden_name_9, t1.usr_date_of_birth AS usr_date_of_birth_10, t1.usr_last_connection AS usr_last_connection_11, t1.usr_register AS usr_register_12, t1.usr_rank AS usr_rank_13, t1.usr_slug AS usr_slug_14, t1.usr_active AS usr_active_15, t1.usr_update AS usr_update_16, t1.usr_inactive_date AS usr_inactive_date_17, t1.usr_token_reset_password AS usr_token_reset_password_18, t1.usr_avatar AS usr_avatar_19, t1.usr_is_blocked AS usr_is_blocked_20, t1.usr_date_is_blocked AS usr_date_is_blocked_21, t1.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_22, t1.usr_main_phone AS usr_main_phone_23, t1.usr_additional_phone AS usr_additional_phone_24, t1.usr_google_id AS usr_google_id_25, t1.usr_apple_id AS usr_apple_id_26, t1.usr_facebook_id AS usr_facebook_id_27, t1.usr_has_2fa AS usr_has_2fa_28, t1.usr_2fa_code AS usr_2fa_code_29, t1.usr_2fa_method AS usr_2fa_method_30, t1.usr_2fa_version AS usr_2fa_version_31, t1.usr_balance AS usr_balance_32, t1.usr_bank_id AS usr_bank_id_33, t1.usr_bank_is_completed AS usr_bank_is_completed_34, t1.usr_place_of_birth AS usr_place_of_birth_35, t1.usr_country_of_birth AS usr_country_of_birth_36, t1.usr_department_of_birth AS usr_department_of_birth_37, t1.usr_app_settings AS usr_app_settings_38, t0.cus_id_customer AS cus_id_customer_39, t0.cus_code AS cus_code_40, t0.cus_door_code AS cus_door_code_41, t0.cus_intercom_code AS cus_intercom_code_42, t0.cus_valid AS cus_valid_43, t0.social_insurance_number AS social_insurance_number_44, t0.cus_prescriptor_id AS cus_prescriptor_id_45, t0.cus_prescriptor_type AS cus_prescriptor_type_46, t0.cus_gir_score AS cus_gir_score_47, t1.usr_address_id AS usr_address_id_48, t1.usr_bank_account_id AS usr_bank_account_id_49, t0.cus_suivi_id AS cus_suivi_id_50, t0.cus_suivi_administrative_id AS cus_suivi_administrative_id_51, t0.cus_sector_id AS cus_sector_id_52, t0.cus_suivi_pro_id AS cus_suivi_pro_id_53, t0.cus_suivi_health_id AS cus_suivi_health_id_54, t0.cus_origin_id AS cus_origin_id_55, t0.cus_couple_id AS cus_couple_id_56, t1.type FROM customer t0 INNER JOIN user_account t1 ON t0.usr_id = t1.usr_id LEFT JOIN co_living t2 ON t0.usr_id = t2.usr_id WHERE t1.usr_slug = ? LIMIT 1
Parameters:
[
  "dorothee-dupont"
]
19 8.29 ms
SELECT t0.cin_id AS cin_id_1, t0.cin_role AS cin_role_2, t0.cin_user_id AS cin_user_id_3, t0.cin_customer_id AS cin_customer_id_4 FROM circle_node t0 WHERE t0.cin_user_id = ?
Parameters:
[
  23
]
20 22.60 ms
SELECT e0_.eve_id AS eve_id_0, e0_.eve_start_date AS eve_start_date_1, e0_.eve_end_date AS eve_end_date_2, e0_.eve_rrule AS eve_rrule_3, e0_.eve_rrule_end_date AS eve_rrule_end_date_4, e0_.eve_state AS eve_state_5, e0_.eve_initial_date AS eve_initial_date_6, e0_.eve_timezone AS eve_timezone_7, s1_.ser_ogust_id AS ser_ogust_id_8, s1_.ser_commentary AS ser_commentary_9, s1_.ser_status AS ser_status_10, s1_.ser_is_dirty_to_ogust AS ser_is_dirty_to_ogust_11, s1_.ser_ogust_repetition_id AS ser_ogust_repetition_id_12, s1_.ser_updated_at AS ser_updated_at_13, s1_.title AS title_14, u2_.usr_id AS usr_id_15, u2_.usr_mail AS usr_mail_16, u2_.usr_pwd AS usr_pwd_17, u2_.usr_title AS usr_title_18, u2_.usr_first_name AS usr_first_name_19, u2_.usr_last_name AS usr_last_name_20, u2_.usr_maiden_name AS usr_maiden_name_21, u2_.usr_date_of_birth AS usr_date_of_birth_22, u2_.usr_last_connection AS usr_last_connection_23, u2_.usr_register AS usr_register_24, u2_.usr_rank AS usr_rank_25, u2_.usr_slug AS usr_slug_26, u2_.usr_active AS usr_active_27, u2_.usr_update AS usr_update_28, u2_.usr_inactive_date AS usr_inactive_date_29, u2_.usr_token_reset_password AS usr_token_reset_password_30, u2_.usr_avatar AS usr_avatar_31, u2_.usr_is_blocked AS usr_is_blocked_32, u2_.usr_date_is_blocked AS usr_date_is_blocked_33, u2_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_34, u2_.usr_main_phone AS usr_main_phone_35, u2_.usr_additional_phone AS usr_additional_phone_36, u2_.usr_google_id AS usr_google_id_37, u2_.usr_apple_id AS usr_apple_id_38, u2_.usr_facebook_id AS usr_facebook_id_39, u2_.usr_has_2fa AS usr_has_2fa_40, u2_.usr_2fa_code AS usr_2fa_code_41, u2_.usr_2fa_method AS usr_2fa_method_42, u2_.usr_2fa_version AS usr_2fa_version_43, u2_.usr_balance AS usr_balance_44, u2_.usr_bank_id AS usr_bank_id_45, u2_.usr_bank_is_completed AS usr_bank_is_completed_46, u2_.usr_place_of_birth AS usr_place_of_birth_47, u2_.usr_country_of_birth AS usr_country_of_birth_48, u2_.usr_department_of_birth AS usr_department_of_birth_49, u2_.usr_app_settings AS usr_app_settings_50, c3_.cus_id_customer AS cus_id_customer_51, c3_.cus_code AS cus_code_52, c3_.cus_door_code AS cus_door_code_53, c3_.cus_intercom_code AS cus_intercom_code_54, c3_.cus_valid AS cus_valid_55, c3_.social_insurance_number AS social_insurance_number_56, c3_.cus_prescriptor_id AS cus_prescriptor_id_57, c3_.cus_prescriptor_type AS cus_prescriptor_type_58, c3_.cus_gir_score AS cus_gir_score_59, a5_.addr_id AS addr_id_60, a5_.addr_line AS addr_line_61, a5_.addr_supplement AS addr_supplement_62, a5_.addr_zip AS addr_zip_63, a5_.addr_city AS addr_city_64, a5_.addr_country AS addr_country_65, a5_.addr_id_address AS addr_id_address_66, a5_.addr_late AS addr_late_67, a5_.addr_long AS addr_long_68, a5_.addr_update AS addr_update_69, p6_.prl_id AS prl_id_70, p6_.prl_short_title AS prl_short_title_71, p6_.prl_long_title AS prl_long_title_72, p6_.prl_status AS prl_status_73, p6_.prl_effective_hours AS prl_effective_hours_74, p6_.prl_responsible_hours AS prl_responsible_hours_75, p6_.prl_night_hours AS prl_night_hours_76, r7_.rer_id AS rer_id_77, r7_.rer_start_date AS rer_start_date_78, r7_.rer_end_date AS rer_end_date_79, r7_.rer_is_open AS rer_is_open_80, r7_.rer_notification_step AS rer_notification_step_81, r7_.rer_created_at AS rer_created_at_82, r7_.rer_timezone AS rer_timezone_83, r7_.rer_open_to_extended_circle AS rer_open_to_extended_circle_84, r8_.rem_id AS rem_id_85, r8_.rem_start_date AS rem_start_date_86, r8_.rem_end_date AS rem_end_date_87, r8_.rem_distance AS rem_distance_88, r8_.rem_is_notified AS rem_is_notified_89, r8_.rem_is_dirty_to_ogust AS rem_is_dirty_to_ogust_90, r8_.rem_ogust_id AS rem_ogust_id_91, r8_.rem_start_latitude AS rem_start_latitude_92, r8_.rem_start_longitude AS rem_start_longitude_93, r8_.rem_end_latitude AS rem_end_latitude_94, r8_.rem_end_longitude AS rem_end_longitude_95, r8_.rem_timezone AS rem_timezone_96, r8_.start_type AS start_type_97, r8_.end_type AS end_type_98, u9_.usr_id AS usr_id_99, u9_.usr_mail AS usr_mail_100, u9_.usr_pwd AS usr_pwd_101, u9_.usr_title AS usr_title_102, u9_.usr_first_name AS usr_first_name_103, u9_.usr_last_name AS usr_last_name_104, u9_.usr_maiden_name AS usr_maiden_name_105, u9_.usr_date_of_birth AS usr_date_of_birth_106, u9_.usr_last_connection AS usr_last_connection_107, u9_.usr_register AS usr_register_108, u9_.usr_rank AS usr_rank_109, u9_.usr_slug AS usr_slug_110, u9_.usr_active AS usr_active_111, u9_.usr_update AS usr_update_112, u9_.usr_inactive_date AS usr_inactive_date_113, u9_.usr_token_reset_password AS usr_token_reset_password_114, u9_.usr_avatar AS usr_avatar_115, u9_.usr_is_blocked AS usr_is_blocked_116, u9_.usr_date_is_blocked AS usr_date_is_blocked_117, u9_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_118, u9_.usr_main_phone AS usr_main_phone_119, u9_.usr_additional_phone AS usr_additional_phone_120, u9_.usr_google_id AS usr_google_id_121, u9_.usr_apple_id AS usr_apple_id_122, u9_.usr_facebook_id AS usr_facebook_id_123, u9_.usr_has_2fa AS usr_has_2fa_124, u9_.usr_2fa_code AS usr_2fa_code_125, u9_.usr_2fa_method AS usr_2fa_method_126, u9_.usr_2fa_version AS usr_2fa_version_127, u9_.usr_balance AS usr_balance_128, u9_.usr_bank_id AS usr_bank_id_129, u9_.usr_bank_is_completed AS usr_bank_is_completed_130, u9_.usr_place_of_birth AS usr_place_of_birth_131, u9_.usr_country_of_birth AS usr_country_of_birth_132, u9_.usr_department_of_birth AS usr_department_of_birth_133, u9_.usr_app_settings AS usr_app_settings_134, c10_.cus_id_customer AS cus_id_customer_135, c10_.cus_code AS cus_code_136, c10_.cus_door_code AS cus_door_code_137, c10_.cus_intercom_code AS cus_intercom_code_138, c10_.cus_valid AS cus_valid_139, c10_.social_insurance_number AS social_insurance_number_140, c10_.cus_prescriptor_id AS cus_prescriptor_id_141, c10_.cus_prescriptor_type AS cus_prescriptor_type_142, c10_.cus_gir_score AS cus_gir_score_143, i11_.int_id_employee AS int_id_employee_144, i11_.int_number AS int_number_145, i11_.int_has_to_be_validate AS int_has_to_be_validate_146, i11_.int_completness AS int_completness_147, i11_.int_social_insurance_number AS int_social_insurance_number_148, i11_.int_nationality AS int_nationality_149, i11_.int_coach_level_type AS int_coach_level_type_150, i11_.int_referral_code AS int_referral_code_151, i11_.int_onboarding_completed_at AS int_onboarding_completed_at_152, i11_.int_social_skills_score AS int_social_skills_score_153, i11_.int_social_skills_computed_at AS int_social_skills_computed_at_154, u12_.una_url_photo AS una_url_photo_155, r13_.rel_valid AS rel_valid_156, r13_.rel_customer_string AS rel_customer_string_157, h14_.hepr_valid AS hepr_valid_158, h14_.hepr_customer_string AS hepr_customer_string_159, e17_.eve_id AS eve_id_160, e17_.eve_start_date AS eve_start_date_161, e17_.eve_end_date AS eve_end_date_162, e17_.eve_rrule AS eve_rrule_163, e17_.eve_rrule_end_date AS eve_rrule_end_date_164, e17_.eve_state AS eve_state_165, e17_.eve_initial_date AS eve_initial_date_166, e17_.eve_timezone AS eve_timezone_167, r18_.rme_short_title AS rme_short_title_168, r18_.rme_long_title AS rme_long_title_169, r18_.rme_updated_at AS rme_updated_at_170, s19_.ser_ogust_id AS ser_ogust_id_171, s19_.ser_commentary AS ser_commentary_172, s19_.ser_status AS ser_status_173, s19_.ser_is_dirty_to_ogust AS ser_is_dirty_to_ogust_174, s19_.ser_ogust_repetition_id AS ser_ogust_repetition_id_175, s19_.ser_updated_at AS ser_updated_at_176, s19_.title AS title_177, s20_.see_short_title AS see_short_title_178, s20_.see_long_title AS see_long_title_179, e0_.eve_type AS eve_type_180, e0_.eve_recurring_event_id AS eve_recurring_event_id_181, s1_.ser_customer_id AS ser_customer_id_182, s1_.ser_intervener_id AS ser_intervener_id_183, s1_.ser_product_level_id AS ser_product_level_id_184, u2_.type AS type_185, u2_.usr_address_id AS usr_address_id_186, u2_.usr_bank_account_id AS usr_bank_account_id_187, c3_.cus_suivi_id AS cus_suivi_id_188, c3_.cus_suivi_administrative_id AS cus_suivi_administrative_id_189, c3_.cus_sector_id AS cus_sector_id_190, c3_.cus_suivi_pro_id AS cus_suivi_pro_id_191, c3_.cus_suivi_health_id AS cus_suivi_health_id_192, c3_.cus_origin_id AS cus_origin_id_193, c3_.cus_couple_id AS cus_couple_id_194, r7_.rer_service_id AS rer_service_id_195, r8_.rem_service_id AS rem_service_id_196, u9_.type AS type_197, u9_.usr_address_id AS usr_address_id_198, u9_.usr_bank_account_id AS usr_bank_account_id_199, c10_.cus_suivi_id AS cus_suivi_id_200, c10_.cus_suivi_administrative_id AS cus_suivi_administrative_id_201, c10_.cus_sector_id AS cus_sector_id_202, c10_.cus_suivi_pro_id AS cus_suivi_pro_id_203, c10_.cus_suivi_health_id AS cus_suivi_health_id_204, c10_.cus_origin_id AS cus_origin_id_205, c10_.cus_couple_id AS cus_couple_id_206, i11_.int_sector_id AS int_sector_id_207, i11_.int_coordinator_discussion_id AS int_coordinator_discussion_id_208, i11_.int_instigator_id AS int_instigator_id_209, i11_.int_referrer_id AS int_referrer_id_210, u12_.una_sector_id AS una_sector_id_211, e17_.eve_type AS eve_type_212, e17_.eve_recurring_event_id AS eve_recurring_event_id_213, r18_.rme_user_id AS rme_user_id_214, r18_.rme_co_living_manager AS rme_co_living_manager_215, s19_.ser_customer_id AS ser_customer_id_216, s19_.ser_intervener_id AS ser_intervener_id_217, s19_.ser_product_level_id AS ser_product_level_id_218, s20_.see_sector_id AS see_sector_id_219 FROM service s1_ INNER JOIN event e0_ ON s1_.eve_id = e0_.eve_id INNER JOIN customer c3_ ON s1_.ser_customer_id = c3_.usr_id LEFT JOIN user_account u2_ ON c3_.usr_id = u2_.usr_id LEFT JOIN co_living c4_ ON c3_.usr_id = c4_.usr_id LEFT JOIN address a5_ ON u2_.usr_address_id = a5_.addr_id LEFT JOIN product_level p6_ ON s1_.ser_product_level_id = p6_.prl_id LEFT JOIN replacement_request r7_ ON s1_.eve_id = r7_.rer_service_id LEFT JOIN remote_management r8_ ON s1_.eve_id = r8_.rem_service_id LEFT JOIN user_account u9_ ON s1_.ser_intervener_id = u9_.usr_id LEFT JOIN customer c10_ ON u9_.usr_id = c10_.usr_id LEFT JOIN intervener i11_ ON u9_.usr_id = i11_.usr_id LEFT JOIN unaide u12_ ON u9_.usr_id = u12_.usr_id LEFT JOIN relative r13_ ON u9_.usr_id = r13_.usr_id LEFT JOIN health_professional h14_ ON u9_.usr_id = h14_.usr_id LEFT JOIN co_living_manager c15_ ON u9_.usr_id = c15_.usr_id LEFT JOIN co_living c16_ ON u9_.usr_id = c16_.usr_id LEFT JOIN event e17_ ON e0_.eve_recurring_event_id = e17_.eve_id LEFT JOIN reminder_event r18_ ON e17_.eve_id = r18_.eve_id LEFT JOIN service s19_ ON e17_.eve_id = s19_.eve_id LEFT JOIN sector_event s20_ ON e17_.eve_id = s20_.eve_id WHERE s1_.ser_customer_id IN (?) AND ((e0_.eve_start_date <= ? AND e0_.eve_end_date >= ?) OR (e0_.eve_initial_date >= ? AND e0_.eve_initial_date <= ?)) AND e0_.eve_rrule IS NULL ORDER BY e0_.eve_start_date ASC
Parameters:
[
  23
  "2026-07-01 21:59:59"
  "2026-06-30 22:00:00"
  "2026-07-01"
  "2026-07-01"
]
21 2.03 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  465
]
22 12.99 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  465
]
23 6.04 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
]
24 3.57 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_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:
[
  143
]
25 0.90 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, 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:
[
  143
]
26 3.08 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:
[
  143
]
27 3.80 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:
[
  74
]
28 2.97 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_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:
[
  167
]
29 6.91 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, 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:
[
  167
]
30 3.50 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:
[
  167
]
31 3.41 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:
[
  74
]
32 0.43 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:
[
  74
]
33 3.90 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  466
]
34 3.85 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  466
]
35 2.93 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_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:
[
  174
]
36 0.75 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, 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:
[
  174
]
37 5.53 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:
[
  174
]
38 2.21 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:
[
  157
]
39 0.85 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:
[
  157
]
40 0.84 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:
[
  157
]
41 4.61 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  506
]
42 3.70 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  506
]
43 0.42 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_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:
[
  142
]
44 0.64 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, 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:
[
  142
]
45 4.93 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:
[
  142
]
46 3.71 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
]
47 3.52 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_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:
[
  166
]
48 0.70 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, 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:
[
  166
]
49 0.27 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:
[
  166
]
50 0.34 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
]
51 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
]
52 9.50 ms
SELECT e0_.eve_id AS eve_id_0, e0_.eve_start_date AS eve_start_date_1, e0_.eve_end_date AS eve_end_date_2, e0_.eve_rrule AS eve_rrule_3, e0_.eve_rrule_end_date AS eve_rrule_end_date_4, e0_.eve_state AS eve_state_5, e0_.eve_initial_date AS eve_initial_date_6, e0_.eve_timezone AS eve_timezone_7, s1_.ser_ogust_id AS ser_ogust_id_8, s1_.ser_commentary AS ser_commentary_9, s1_.ser_status AS ser_status_10, s1_.ser_is_dirty_to_ogust AS ser_is_dirty_to_ogust_11, s1_.ser_ogust_repetition_id AS ser_ogust_repetition_id_12, s1_.ser_updated_at AS ser_updated_at_13, s1_.title AS title_14, u2_.usr_id AS usr_id_15, u2_.usr_mail AS usr_mail_16, u2_.usr_pwd AS usr_pwd_17, u2_.usr_title AS usr_title_18, u2_.usr_first_name AS usr_first_name_19, u2_.usr_last_name AS usr_last_name_20, u2_.usr_maiden_name AS usr_maiden_name_21, u2_.usr_date_of_birth AS usr_date_of_birth_22, u2_.usr_last_connection AS usr_last_connection_23, u2_.usr_register AS usr_register_24, u2_.usr_rank AS usr_rank_25, u2_.usr_slug AS usr_slug_26, u2_.usr_active AS usr_active_27, u2_.usr_update AS usr_update_28, u2_.usr_inactive_date AS usr_inactive_date_29, u2_.usr_token_reset_password AS usr_token_reset_password_30, u2_.usr_avatar AS usr_avatar_31, u2_.usr_is_blocked AS usr_is_blocked_32, u2_.usr_date_is_blocked AS usr_date_is_blocked_33, u2_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_34, u2_.usr_main_phone AS usr_main_phone_35, u2_.usr_additional_phone AS usr_additional_phone_36, u2_.usr_google_id AS usr_google_id_37, u2_.usr_apple_id AS usr_apple_id_38, u2_.usr_facebook_id AS usr_facebook_id_39, u2_.usr_has_2fa AS usr_has_2fa_40, u2_.usr_2fa_code AS usr_2fa_code_41, u2_.usr_2fa_method AS usr_2fa_method_42, u2_.usr_2fa_version AS usr_2fa_version_43, u2_.usr_balance AS usr_balance_44, u2_.usr_bank_id AS usr_bank_id_45, u2_.usr_bank_is_completed AS usr_bank_is_completed_46, u2_.usr_place_of_birth AS usr_place_of_birth_47, u2_.usr_country_of_birth AS usr_country_of_birth_48, u2_.usr_department_of_birth AS usr_department_of_birth_49, u2_.usr_app_settings AS usr_app_settings_50, c3_.cus_id_customer AS cus_id_customer_51, c3_.cus_code AS cus_code_52, c3_.cus_door_code AS cus_door_code_53, c3_.cus_intercom_code AS cus_intercom_code_54, c3_.cus_valid AS cus_valid_55, c3_.social_insurance_number AS social_insurance_number_56, c3_.cus_prescriptor_id AS cus_prescriptor_id_57, c3_.cus_prescriptor_type AS cus_prescriptor_type_58, c3_.cus_gir_score AS cus_gir_score_59, a5_.addr_id AS addr_id_60, a5_.addr_line AS addr_line_61, a5_.addr_supplement AS addr_supplement_62, a5_.addr_zip AS addr_zip_63, a5_.addr_city AS addr_city_64, a5_.addr_country AS addr_country_65, a5_.addr_id_address AS addr_id_address_66, a5_.addr_late AS addr_late_67, a5_.addr_long AS addr_long_68, a5_.addr_update AS addr_update_69, u6_.usr_id AS usr_id_70, u6_.usr_mail AS usr_mail_71, u6_.usr_pwd AS usr_pwd_72, u6_.usr_title AS usr_title_73, u6_.usr_first_name AS usr_first_name_74, u6_.usr_last_name AS usr_last_name_75, u6_.usr_maiden_name AS usr_maiden_name_76, u6_.usr_date_of_birth AS usr_date_of_birth_77, u6_.usr_last_connection AS usr_last_connection_78, u6_.usr_register AS usr_register_79, u6_.usr_rank AS usr_rank_80, u6_.usr_slug AS usr_slug_81, u6_.usr_active AS usr_active_82, u6_.usr_update AS usr_update_83, u6_.usr_inactive_date AS usr_inactive_date_84, u6_.usr_token_reset_password AS usr_token_reset_password_85, u6_.usr_avatar AS usr_avatar_86, u6_.usr_is_blocked AS usr_is_blocked_87, u6_.usr_date_is_blocked AS usr_date_is_blocked_88, u6_.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_89, u6_.usr_main_phone AS usr_main_phone_90, u6_.usr_additional_phone AS usr_additional_phone_91, u6_.usr_google_id AS usr_google_id_92, u6_.usr_apple_id AS usr_apple_id_93, u6_.usr_facebook_id AS usr_facebook_id_94, u6_.usr_has_2fa AS usr_has_2fa_95, u6_.usr_2fa_code AS usr_2fa_code_96, u6_.usr_2fa_method AS usr_2fa_method_97, u6_.usr_2fa_version AS usr_2fa_version_98, u6_.usr_balance AS usr_balance_99, u6_.usr_bank_id AS usr_bank_id_100, u6_.usr_bank_is_completed AS usr_bank_is_completed_101, u6_.usr_place_of_birth AS usr_place_of_birth_102, u6_.usr_country_of_birth AS usr_country_of_birth_103, u6_.usr_department_of_birth AS usr_department_of_birth_104, u6_.usr_app_settings AS usr_app_settings_105, c7_.cus_id_customer AS cus_id_customer_106, c7_.cus_code AS cus_code_107, c7_.cus_door_code AS cus_door_code_108, c7_.cus_intercom_code AS cus_intercom_code_109, c7_.cus_valid AS cus_valid_110, c7_.social_insurance_number AS social_insurance_number_111, c7_.cus_prescriptor_id AS cus_prescriptor_id_112, c7_.cus_prescriptor_type AS cus_prescriptor_type_113, c7_.cus_gir_score AS cus_gir_score_114, i8_.int_id_employee AS int_id_employee_115, i8_.int_number AS int_number_116, i8_.int_has_to_be_validate AS int_has_to_be_validate_117, i8_.int_completness AS int_completness_118, i8_.int_social_insurance_number AS int_social_insurance_number_119, i8_.int_nationality AS int_nationality_120, i8_.int_coach_level_type AS int_coach_level_type_121, i8_.int_referral_code AS int_referral_code_122, i8_.int_onboarding_completed_at AS int_onboarding_completed_at_123, i8_.int_social_skills_score AS int_social_skills_score_124, i8_.int_social_skills_computed_at AS int_social_skills_computed_at_125, u9_.una_url_photo AS una_url_photo_126, r10_.rel_valid AS rel_valid_127, r10_.rel_customer_string AS rel_customer_string_128, h11_.hepr_valid AS hepr_valid_129, h11_.hepr_customer_string AS hepr_customer_string_130, p14_.prl_id AS prl_id_131, p14_.prl_short_title AS prl_short_title_132, p14_.prl_long_title AS prl_long_title_133, p14_.prl_status AS prl_status_134, p14_.prl_effective_hours AS prl_effective_hours_135, p14_.prl_responsible_hours AS prl_responsible_hours_136, p14_.prl_night_hours AS prl_night_hours_137, e0_.eve_type AS eve_type_138, e0_.eve_recurring_event_id AS eve_recurring_event_id_139, s1_.ser_customer_id AS ser_customer_id_140, s1_.ser_intervener_id AS ser_intervener_id_141, s1_.ser_product_level_id AS ser_product_level_id_142, u2_.type AS type_143, u2_.usr_address_id AS usr_address_id_144, u2_.usr_bank_account_id AS usr_bank_account_id_145, c3_.cus_suivi_id AS cus_suivi_id_146, c3_.cus_suivi_administrative_id AS cus_suivi_administrative_id_147, c3_.cus_sector_id AS cus_sector_id_148, c3_.cus_suivi_pro_id AS cus_suivi_pro_id_149, c3_.cus_suivi_health_id AS cus_suivi_health_id_150, c3_.cus_origin_id AS cus_origin_id_151, c3_.cus_couple_id AS cus_couple_id_152, u6_.type AS type_153, u6_.usr_address_id AS usr_address_id_154, u6_.usr_bank_account_id AS usr_bank_account_id_155, c7_.cus_suivi_id AS cus_suivi_id_156, c7_.cus_suivi_administrative_id AS cus_suivi_administrative_id_157, c7_.cus_sector_id AS cus_sector_id_158, c7_.cus_suivi_pro_id AS cus_suivi_pro_id_159, c7_.cus_suivi_health_id AS cus_suivi_health_id_160, c7_.cus_origin_id AS cus_origin_id_161, c7_.cus_couple_id AS cus_couple_id_162, i8_.int_sector_id AS int_sector_id_163, i8_.int_coordinator_discussion_id AS int_coordinator_discussion_id_164, i8_.int_instigator_id AS int_instigator_id_165, i8_.int_referrer_id AS int_referrer_id_166, u9_.una_sector_id AS una_sector_id_167 FROM service s1_ INNER JOIN event e0_ ON s1_.eve_id = e0_.eve_id INNER JOIN customer c3_ ON s1_.ser_customer_id = c3_.usr_id LEFT JOIN user_account u2_ ON c3_.usr_id = u2_.usr_id LEFT JOIN co_living c4_ ON c3_.usr_id = c4_.usr_id LEFT JOIN address a5_ ON u2_.usr_address_id = a5_.addr_id LEFT JOIN user_account u6_ ON s1_.ser_intervener_id = u6_.usr_id LEFT JOIN customer c7_ ON u6_.usr_id = c7_.usr_id LEFT JOIN intervener i8_ ON u6_.usr_id = i8_.usr_id LEFT JOIN unaide u9_ ON u6_.usr_id = u9_.usr_id LEFT JOIN relative r10_ ON u6_.usr_id = r10_.usr_id LEFT JOIN health_professional h11_ ON u6_.usr_id = h11_.usr_id LEFT JOIN co_living_manager c12_ ON u6_.usr_id = c12_.usr_id LEFT JOIN co_living c13_ ON u6_.usr_id = c13_.usr_id LEFT JOIN product_level p14_ ON s1_.ser_product_level_id = p14_.prl_id WHERE s1_.ser_customer_id IN (?) AND (e0_.eve_rrule IS NOT NULL AND e0_.eve_rrule <> '') AND ((e0_.eve_state IS NULL OR e0_.eve_state <> ?)) AND e0_.eve_start_date <= ? AND ((e0_.eve_rrule_end_date IS NULL OR e0_.eve_rrule_end_date >= ?)) AND ((e0_.eve_rrule_end_date IS NULL OR e0_.eve_start_date < e0_.eve_rrule_end_date + 1)) ORDER BY e0_.eve_start_date ASC
Parameters:
[
  23
  "cancelled"
  "2026-07-01 21:59:59"
  "2026-06-30 22:00:00"
]
53 9.64 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  442
]
54 1.60 ms
SELECT t0.rer_id AS rer_id_1, t0.rer_start_date AS rer_start_date_2, t0.rer_end_date AS rer_end_date_3, t0.rer_is_open AS rer_is_open_4, t0.rer_notification_step AS rer_notification_step_5, t0.rer_created_at AS rer_created_at_6, t0.rer_timezone AS rer_timezone_7, t0.rer_open_to_extended_circle AS rer_open_to_extended_circle_8, t0.rer_service_id AS rer_service_id_9, t10.rera_id AS rera_id_11, t10.rera_action AS rera_action_12, t10.rera_date AS rera_date_13, t10.rera_replacement_request_id AS rera_replacement_request_id_14, t10.rera_user_id AS rera_user_id_15 FROM replacement_request t0 LEFT JOIN replacement_request_action t10 ON t10.rera_replacement_request_id = t0.rer_id WHERE t0.rer_service_id = ?
Parameters:
[
  442
]
55 0.42 ms
SELECT t0.rem_id AS rem_id_1, t0.rem_start_date AS rem_start_date_2, t0.rem_end_date AS rem_end_date_3, t0.rem_distance AS rem_distance_4, t0.rem_is_notified AS rem_is_notified_5, t0.rem_is_dirty_to_ogust AS rem_is_dirty_to_ogust_6, t0.rem_ogust_id AS rem_ogust_id_7, t0.rem_start_latitude AS rem_start_latitude_8, t0.rem_start_longitude AS rem_start_longitude_9, t0.rem_end_latitude AS rem_end_latitude_10, t0.rem_end_longitude AS rem_end_longitude_11, t0.rem_timezone AS rem_timezone_12, t0.start_type AS start_type_13, t0.end_type AS end_type_14, t0.rem_service_id AS rem_service_id_15 FROM remote_management t0 WHERE t0.rem_service_id = ?
Parameters:
[
  442
]
56 9.88 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  442
]
57 5.35 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  444
]
58 4.60 ms
SELECT t0.rer_id AS rer_id_1, t0.rer_start_date AS rer_start_date_2, t0.rer_end_date AS rer_end_date_3, t0.rer_is_open AS rer_is_open_4, t0.rer_notification_step AS rer_notification_step_5, t0.rer_created_at AS rer_created_at_6, t0.rer_timezone AS rer_timezone_7, t0.rer_open_to_extended_circle AS rer_open_to_extended_circle_8, t0.rer_service_id AS rer_service_id_9, t10.rera_id AS rera_id_11, t10.rera_action AS rera_action_12, t10.rera_date AS rera_date_13, t10.rera_replacement_request_id AS rera_replacement_request_id_14, t10.rera_user_id AS rera_user_id_15 FROM replacement_request t0 LEFT JOIN replacement_request_action t10 ON t10.rera_replacement_request_id = t0.rer_id WHERE t0.rer_service_id = ?
Parameters:
[
  444
]
59 0.25 ms
SELECT t0.rem_id AS rem_id_1, t0.rem_start_date AS rem_start_date_2, t0.rem_end_date AS rem_end_date_3, t0.rem_distance AS rem_distance_4, t0.rem_is_notified AS rem_is_notified_5, t0.rem_is_dirty_to_ogust AS rem_is_dirty_to_ogust_6, t0.rem_ogust_id AS rem_ogust_id_7, t0.rem_start_latitude AS rem_start_latitude_8, t0.rem_start_longitude AS rem_start_longitude_9, t0.rem_end_latitude AS rem_end_latitude_10, t0.rem_end_longitude AS rem_end_longitude_11, t0.rem_timezone AS rem_timezone_12, t0.start_type AS start_type_13, t0.end_type AS end_type_14, t0.rem_service_id AS rem_service_id_15 FROM remote_management t0 WHERE t0.rem_service_id = ?
Parameters:
[
  444
]
60 0.24 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  444
]
61 5.97 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  445
]
62 3.81 ms
SELECT t0.rer_id AS rer_id_1, t0.rer_start_date AS rer_start_date_2, t0.rer_end_date AS rer_end_date_3, t0.rer_is_open AS rer_is_open_4, t0.rer_notification_step AS rer_notification_step_5, t0.rer_created_at AS rer_created_at_6, t0.rer_timezone AS rer_timezone_7, t0.rer_open_to_extended_circle AS rer_open_to_extended_circle_8, t0.rer_service_id AS rer_service_id_9, t10.rera_id AS rera_id_11, t10.rera_action AS rera_action_12, t10.rera_date AS rera_date_13, t10.rera_replacement_request_id AS rera_replacement_request_id_14, t10.rera_user_id AS rera_user_id_15 FROM replacement_request t0 LEFT JOIN replacement_request_action t10 ON t10.rera_replacement_request_id = t0.rer_id WHERE t0.rer_service_id = ?
Parameters:
[
  445
]
63 0.33 ms
SELECT t0.rem_id AS rem_id_1, t0.rem_start_date AS rem_start_date_2, t0.rem_end_date AS rem_end_date_3, t0.rem_distance AS rem_distance_4, t0.rem_is_notified AS rem_is_notified_5, t0.rem_is_dirty_to_ogust AS rem_is_dirty_to_ogust_6, t0.rem_ogust_id AS rem_ogust_id_7, t0.rem_start_latitude AS rem_start_latitude_8, t0.rem_start_longitude AS rem_start_longitude_9, t0.rem_end_latitude AS rem_end_latitude_10, t0.rem_end_longitude AS rem_end_longitude_11, t0.rem_timezone AS rem_timezone_12, t0.start_type AS start_type_13, t0.end_type AS end_type_14, t0.rem_service_id AS rem_service_id_15 FROM remote_management t0 WHERE t0.rem_service_id = ?
Parameters:
[
  445
]
64 3.26 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  445
]
65 0.28 ms
SELECT t0.rep_id AS rep_id_1, t0.rep_is_accepted AS rep_is_accepted_2, t0.rep_created_at AS rep_created_at_3, t0.rep_service_id AS rep_service_id_4, t0.rep_replacement_request_id AS rep_replacement_request_id_5, t0.rep_intervener_id AS rep_intervener_id_6 FROM replacement_propose t0 WHERE t0.rep_service_id = ?
Parameters:
[
  446
]
66 0.45 ms
SELECT t0.rer_id AS rer_id_1, t0.rer_start_date AS rer_start_date_2, t0.rer_end_date AS rer_end_date_3, t0.rer_is_open AS rer_is_open_4, t0.rer_notification_step AS rer_notification_step_5, t0.rer_created_at AS rer_created_at_6, t0.rer_timezone AS rer_timezone_7, t0.rer_open_to_extended_circle AS rer_open_to_extended_circle_8, t0.rer_service_id AS rer_service_id_9, t10.rera_id AS rera_id_11, t10.rera_action AS rera_action_12, t10.rera_date AS rera_date_13, t10.rera_replacement_request_id AS rera_replacement_request_id_14, t10.rera_user_id AS rera_user_id_15 FROM replacement_request t0 LEFT JOIN replacement_request_action t10 ON t10.rera_replacement_request_id = t0.rer_id WHERE t0.rer_service_id = ?
Parameters:
[
  446
]
67 0.32 ms
SELECT t0.rem_id AS rem_id_1, t0.rem_start_date AS rem_start_date_2, t0.rem_end_date AS rem_end_date_3, t0.rem_distance AS rem_distance_4, t0.rem_is_notified AS rem_is_notified_5, t0.rem_is_dirty_to_ogust AS rem_is_dirty_to_ogust_6, t0.rem_ogust_id AS rem_ogust_id_7, t0.rem_start_latitude AS rem_start_latitude_8, t0.rem_start_longitude AS rem_start_longitude_9, t0.rem_end_latitude AS rem_end_latitude_10, t0.rem_end_longitude AS rem_end_longitude_11, t0.rem_timezone AS rem_timezone_12, t0.start_type AS start_type_13, t0.end_type AS end_type_14, t0.rem_service_id AS rem_service_id_15 FROM remote_management t0 WHERE t0.rem_service_id = ?
Parameters:
[
  446
]
68 0.26 ms
SELECT t0.canj_id AS canj_id_1, t0.canj_urls AS canj_urls_2, t0.canj_service_id AS canj_service_id_3, t0.canj_reason_id AS canj_reason_id_4, t0.canj_canceller_id AS canj_canceller_id_5 FROM cancellation_justification t0 WHERE t0.canj_service_id = ?
Parameters:
[
  446
]
69 6.46 ms
SELECT t0.nedto_id AS nedto_id_1, t0.nedto_value AS nedto_value_2, t0.nedto_customer_id AS nedto_customer_id_3, t0.nedto_need_id AS nedto_need_id_4 FROM customer_need t0 WHERE t0.nedto_customer_id = ?
Parameters:
[
  23
]
70 5.28 ms
SELECT t0.ned_id AS ned_id_1, t0.ned_ogust_Id AS ned_ogust_id_2, t0.ned_title AS ned_title_3, t0.ned_type AS ned_type_4, t0.ned_status AS ned_status_5, t0.ned_avatar_url AS ned_avatar_url_6, t0.ned_needgroup_id AS ned_needgroup_id_7 FROM need t0 WHERE t0.ned_id = ?
Parameters:
[
  3
]
71 3.02 ms
SELECT t0.ned_gr_id AS ned_gr_id_1, t0.ned_gr_title AS ned_gr_title_2, t0.ned_gr_description AS ned_gr_description_3, t0.ned_gr_status AS ned_gr_status_4, t0.ned_usable_for_customer_needs AS ned_usable_for_customer_needs_5 FROM need_group t0 WHERE t0.ned_gr_id = ?
Parameters:
[
  2
]
72 6.80 ms
SELECT t0.ned_id AS ned_id_1, t0.ned_ogust_Id AS ned_ogust_id_2, t0.ned_title AS ned_title_3, t0.ned_type AS ned_type_4, t0.ned_status AS ned_status_5, t0.ned_avatar_url AS ned_avatar_url_6, t0.ned_needgroup_id AS ned_needgroup_id_7 FROM need t0 WHERE t0.ned_id = ?
Parameters:
[
  17
]
73 3.24 ms
SELECT t0.addr_id AS addr_id_1, t0.addr_line AS addr_line_2, t0.addr_supplement AS addr_supplement_3, t0.addr_zip AS addr_zip_4, t0.addr_city AS addr_city_5, t0.addr_country AS addr_country_6, t0.addr_id_address AS addr_id_address_7, t0.addr_late AS addr_late_8, t0.addr_long AS addr_long_9, t0.addr_update AS addr_update_10 FROM address t0 WHERE t0.addr_id = ?
Parameters:
[
  62
]
74 6.66 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_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_address_id = ?
Parameters:
[
  62
]
75 2.71 ms
SELECT t0.serdr_id AS serdr_id_1, t0.serdr_title AS serdr_title_2, t0.serdr_charge_to_customer AS serdr_charge_to_customer_3, t0.serdr_paid_to_intervener AS serdr_paid_to_intervener_4, t0.serdr_type_reason AS serdr_type_reason_5, t0.serdr_type AS serdr_type_6, t0.serdr_origin AS serdr_origin_7 FROM service_disruption_reason t0 WHERE t0.serdr_id = ?
Parameters:
[
  12
]
76 2.92 ms
SELECT t0.addr_id AS addr_id_1, t0.addr_line AS addr_line_2, t0.addr_supplement AS addr_supplement_3, t0.addr_zip AS addr_zip_4, t0.addr_city AS addr_city_5, t0.addr_country AS addr_country_6, t0.addr_id_address AS addr_id_address_7, t0.addr_late AS addr_late_8, t0.addr_long AS addr_long_9, t0.addr_update AS addr_update_10 FROM address t0 WHERE t0.addr_id = ?
Parameters:
[
  63
]
77 2.55 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_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_address_id = ?
Parameters:
[
  63
]
78 0.44 ms
SELECT t0.addr_id AS addr_id_1, t0.addr_line AS addr_line_2, t0.addr_supplement AS addr_supplement_3, t0.addr_zip AS addr_zip_4, t0.addr_city AS addr_city_5, t0.addr_country AS addr_country_6, t0.addr_id_address AS addr_id_address_7, t0.addr_late AS addr_late_8, t0.addr_long AS addr_long_9, t0.addr_update AS addr_update_10 FROM address t0 WHERE t0.addr_id = ?
Parameters:
[
  130
]
79 1.74 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_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_address_id = ?
Parameters:
[
  130
]

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 9
App\Entity\Discussion\Message 9
App\Entity\Event 7
App\Entity\User\User 5
App\Entity\Address 4
App\Entity\CancellationJustification 4
App\Entity\Sector 2
App\Entity\ProductLevel 2
App\Entity\Autonomous\AutonomousTeam 2
App\Entity\CustomerNeed 2
App\Entity\Need 2
App\Entity\Origin 1
App\Entity\BankAccount 1
App\Entity\ServiceDisruptionReason 1
App\Entity\NeedGroup 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\Event No errors.
App\Entity\Service No errors.
App\Entity\ProductLevel No errors.
App\Entity\ReplacementRequest No errors.
App\Entity\RemoteManagement No errors.
App\Entity\ReminderEvent No errors.
App\Entity\SectorEvent No errors.
App\Entity\CancellationJustification No errors.
App\Entity\ServiceDisruptionReason No errors.
App\Entity\Rate No errors.
App\Entity\Autonomous\AutonomousTeamRequest No errors.
App\Entity\Autonomous\AutonomousTeamMembers No errors.
App\Entity\SolicitationIntervenerKnowHowScore No errors.
App\Entity\ReplacementRequestAction No errors.
App\Entity\Need No errors.
App\Entity\NeedGroup No errors.
App\Entity\NeedSelectValue No errors.