Query Metrics
79
Database Queries
25
Different statements
298.59 ms
Query time
0
Invalid entities
52
Managed entities
Queries
| #▲ | 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 |