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

Query Metrics

45 Database Queries
22 Different statements
39.67 ms Query time
0 Invalid entities
38 Managed entities

Grouped Statements

Show all queries

Time Count Info
7.96 ms
(20.06%)
1
SELECT t0.usr_id AS usr_id_8, t0.usr_mail AS usr_mail_9, t0.usr_pwd AS usr_pwd_10, t0.usr_title AS usr_title_11, t0.usr_first_name AS usr_first_name_12, t0.usr_last_name AS usr_last_name_13, t0.usr_maiden_name AS usr_maiden_name_14, t0.usr_date_of_birth AS usr_date_of_birth_15, t0.usr_last_connection AS usr_last_connection_16, t0.usr_register AS usr_register_17, t0.usr_rank AS usr_rank_18, t0.usr_slug AS usr_slug_19, t0.usr_active AS usr_active_20, t0.usr_update AS usr_update_21, t0.usr_inactive_date AS usr_inactive_date_22, t0.usr_token_reset_password AS usr_token_reset_password_23, t0.usr_avatar AS usr_avatar_24, t0.usr_is_blocked AS usr_is_blocked_25, t0.usr_date_is_blocked AS usr_date_is_blocked_26, t0.usr_is_dirty_to_ogust AS usr_is_dirty_to_ogust_27, t0.usr_main_phone AS usr_main_phone_28, t0.usr_additional_phone AS usr_additional_phone_29, t0.usr_google_id AS usr_google_id_30, t0.usr_apple_id AS usr_apple_id_31, t0.usr_facebook_id AS usr_facebook_id_32, t0.usr_has_2fa AS usr_has_2fa_33, t0.usr_2fa_code AS usr_2fa_code_34, t0.usr_2fa_method AS usr_2fa_method_35, t0.usr_2fa_version AS usr_2fa_version_36, t0.usr_balance AS usr_balance_37, t0.usr_bank_id AS usr_bank_id_38, t0.usr_bank_is_completed AS usr_bank_is_completed_39, t0.usr_place_of_birth AS usr_place_of_birth_40, t0.usr_country_of_birth AS usr_country_of_birth_41, t0.usr_department_of_birth AS usr_department_of_birth_42, t0.usr_app_settings AS usr_app_settings_43, t0.usr_address_id AS usr_address_id_44, t0.usr_bank_account_id AS usr_bank_account_id_45, t0.type, t1.cus_id_customer AS cus_id_customer_46, t1.cus_code AS cus_code_47, t1.cus_door_code AS cus_door_code_48, t1.cus_intercom_code AS cus_intercom_code_49, t1.cus_valid AS cus_valid_50, t1.social_insurance_number AS social_insurance_number_51, t1.cus_prescriptor_id AS cus_prescriptor_id_52, t1.cus_prescriptor_type AS cus_prescriptor_type_53, t1.cus_gir_score AS cus_gir_score_54, t1.cus_suivi_id AS cus_suivi_id_55, t1.cus_suivi_administrative_id AS cus_suivi_administrative_id_56, t1.cus_sector_id AS cus_sector_id_57, t1.cus_suivi_pro_id AS cus_suivi_pro_id_58, t1.cus_suivi_health_id AS cus_suivi_health_id_59, t1.cus_origin_id AS cus_origin_id_60, t1.cus_couple_id AS cus_couple_id_61, t2.int_id_employee AS int_id_employee_62, t2.int_number AS int_number_63, t2.int_has_to_be_validate AS int_has_to_be_validate_64, t2.int_completness AS int_completness_65, t2.int_social_insurance_number AS int_social_insurance_number_66, t2.int_nationality AS int_nationality_67, t2.int_coach_level_type AS int_coach_level_type_68, t2.int_referral_code AS int_referral_code_69, t2.int_onboarding_completed_at AS int_onboarding_completed_at_70, t2.int_social_skills_score AS int_social_skills_score_71, t2.int_social_skills_computed_at AS int_social_skills_computed_at_72, t2.int_sector_id AS int_sector_id_73, t2.int_coordinator_discussion_id AS int_coordinator_discussion_id_74, t2.int_instigator_id AS int_instigator_id_75, t2.int_referrer_id AS int_referrer_id_76, t3.una_url_photo AS una_url_photo_77, t3.una_sector_id AS una_sector_id_78, t4.rel_valid AS rel_valid_79, t4.rel_customer_string AS rel_customer_string_80, t5.hepr_valid AS hepr_valid_81, t5.hepr_customer_string AS hepr_customer_string_82 FROM user_account t0 LEFT JOIN customer t1 ON t0.usr_id = t1.usr_id LEFT JOIN intervener t2 ON t0.usr_id = t2.usr_id LEFT JOIN unaide t3 ON t0.usr_id = t3.usr_id LEFT JOIN relative t4 ON t0.usr_id = t4.usr_id LEFT JOIN health_professional t5 ON t0.usr_id = t5.usr_id LEFT JOIN co_living_manager t6 ON t0.usr_id = t6.usr_id LEFT JOIN co_living t7 ON t0.usr_id = t7.usr_id WHERE t0.usr_mail = ? LIMIT 1
Parameters:
[
  "customer1@utech.care"
]
5.73 ms
(14.45%)
7
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.95 ms
(12.49%)
7
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.89 ms
(9.82%)
2
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
]
3.81 ms
(9.61%)
2
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_id = ?
Parameters:
[
  74
]
2.20 ms
(5.56%)
7
SELECT t0.aut_id AS aut_id_1, t0.aut_title AS aut_title_2, t0.aut_description AS aut_description_3, t0.aut_avatar AS aut_avatar_4, t0.aut_created_at AS aut_created_at_5, t0.aut_updated_at AS aut_updated_at_6, t0.aut_coach_id AS aut_coach_id_7, t0.aut_discussion_id AS aut_discussion_id_8 FROM autonomous_team t0 WHERE t0.aut_discussion_id = ?
Parameters:
[
  66
]
1.41 ms
(3.55%)
1
SELECT t0.sop_id AS sop_id_1, t0.sop_status AS sop_status_2, t0.sop_state AS sop_state_3, t0.sop_intervener_id AS sop_intervener_id_4, t0.sop_solicitation_id AS sop_solicitation_id_5, t0.sop_reminder_event_id AS sop_reminder_event_id_6, t7.solc_id AS solc_id_8, t7.solc_is_valid_by_customer AS solc_is_valid_by_customer_9, t7.solc_is_valid_by_intervener AS solc_is_valid_by_intervener_10, t7.solc_validation_message AS solc_validation_message_11, t7.solc_created_at AS solc_created_at_12, t7.solc_social_skills_score AS solc_social_skills_score_13, t7.solc_final_choice AS solc_final_choice_14, t7.solc_initial_hourly_rate AS solc_initial_hourly_rate_15, t7.solc_discussion_id AS solc_discussion_id_16, t7.solc_employment_id AS solc_employment_id_17, t7.solc_task_id AS solc_task_id_18, t7.solc_contract_id AS solc_contract_id_19, t7.solc_solicitation_propose_id AS solc_solicitation_propose_id_20 FROM solicitation_propose t0 LEFT JOIN solicitation_connection t7 ON t7.solc_solicitation_propose_id = t0.sop_id WHERE t0.sop_id = ?
Parameters:
[
  10
]
1.29 ms
(3.25%)
1
SELECT t0.solc_id AS solc_id_1, t0.solc_is_valid_by_customer AS solc_is_valid_by_customer_2, t0.solc_is_valid_by_intervener AS solc_is_valid_by_intervener_3, t0.solc_validation_message AS solc_validation_message_4, t0.solc_created_at AS solc_created_at_5, t0.solc_social_skills_score AS solc_social_skills_score_6, t0.solc_final_choice AS solc_final_choice_7, t0.solc_initial_hourly_rate AS solc_initial_hourly_rate_8, t0.solc_discussion_id AS solc_discussion_id_9, t0.solc_employment_id AS solc_employment_id_10, t0.solc_task_id AS solc_task_id_11, t0.solc_contract_id AS solc_contract_id_12, t0.solc_solicitation_propose_id AS solc_solicitation_propose_id_13 FROM solicitation_connection t0 WHERE t0.solc_discussion_id = ? LIMIT 1
Parameters:
[
  164
]
1.07 ms
(2.70%)
2
SELECT t0.sec_id AS sec_id_2, t0.sec_code AS sec_code_3, t0.sec_name AS sec_name_4, t0.number AS number_5, t0.sec_active AS sec_active_6, t0.sec_upper_sector_id AS sec_upper_sector_id_7, t0.sec_type, t1.rtu_sector_created_at AS rtu_sector_created_at_8, t1.rtu_sector_updated_at AS rtu_sector_updated_at_9, t1.rtu_user_id AS rtu_user_id_10 FROM sector t0 LEFT JOIN rtu_sector t1 ON t0.sec_id = t1.sec_id WHERE t0.sec_id = ?
Parameters:
[
  8
]
0.90 ms
(2.27%)
1
SELECT s0_.sor_id AS sor_id_0, s0_.sor_start_time AS sor_start_time_1, s0_.sor_intervener_id AS sor_intervener_id_2, s0_.solicitation_service_id AS solicitation_service_id_3 FROM solicitation_response s0_ INNER JOIN solicitation_service s1_ ON s0_.solicitation_service_id = s1_.sos_id WHERE s0_.sor_intervener_id = ? AND s1_.sos_solicitation_id = ?
Parameters:
[
  74
  6
]
0.83 ms
(2.08%)
1
"COMMIT"
Parameters:
[]
0.77 ms
(1.93%)
2
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
]
0.75 ms
(1.88%)
1
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[
  "2026-07-01 10:49:21+0200"
  23
]
0.65 ms
(1.64%)
1
SELECT t0.gat_notification_state AS gat_notification_state_1, t0.gat_is_favorite AS gat_is_favorite_2, t0.gat_nb_unread AS gat_nb_unread_3, t0.gat_discussion_id AS gat_discussion_id_4, t0.gat_user_id AS gat_user_id_5, t0.gat_last_message_read_id AS gat_last_message_read_id_6 FROM gather t0 WHERE t0.gat_discussion_id = ?
Parameters:
[
  164
]
0.62 ms
(1.57%)
1
SELECT t0.prl_id AS prl_id_1, t0.prl_short_title AS prl_short_title_2, t0.prl_long_title AS prl_long_title_3, t0.prl_status AS prl_status_4, t0.prl_effective_hours AS prl_effective_hours_5, t0.prl_responsible_hours AS prl_responsible_hours_6, t0.prl_night_hours AS prl_night_hours_7 FROM product_level t0 WHERE t0.prl_id = ?
Parameters:
[
  2
]
0.62 ms
(1.56%)
2
SELECT t0.sos_id AS sos_id_1, t0.sos_rrule AS sos_rrule_2, t0.sos_period AS sos_period_3, t0.sos_day AS sos_day_4, t0.sos_duration AS sos_duration_5, t0.sos_product_level_id AS sos_product_level_id_6, t0.sos_solicitation_id AS sos_solicitation_id_7 FROM solicitation_service t0 WHERE t0.sos_id = ?
Parameters:
[
  19
]
0.57 ms
(1.43%)
1
SELECT t0.sol_id AS sol_id_1, t0.sol_contract_type AS sol_contract_type_2, t0.sol_start_date AS sol_start_date_3, t0.sol_end_date AS sol_end_date_4, t0.sol_created_at AS sol_created_at_5, t0.sol_updated_at AS sol_updated_at_6, t0.sol_state AS sol_state_7, t0.sos_timezone AS sos_timezone_8, t0.sol_type AS sol_type_9, t0.sol_net_hourly_rate AS sol_net_hourly_rate_10, t0.sol_unit_charge AS sol_unit_charge_11, t0.sol_initial_deal_breakers AS sol_initial_deal_breakers_12, t0.sol_active_deal_breakers AS sol_active_deal_breakers_13, t0.sol_has_vehicle_available AS sol_has_vehicle_available_14, t0.sol_customer_id AS sol_customer_id_15, t0.sol_rtu AS sol_rtu_16 FROM solicitation t0 WHERE t0.sol_id = ?
Parameters:
[
  6
]
0.54 ms
(1.36%)
1
SELECT t0.atm_joined_at AS atm_joined_at_1, t0.atm_autonomous_team_id AS atm_autonomous_team_id_2, t0.atm_member_id AS atm_member_id_3 FROM autonomous_team_members t0 WHERE t0.atm_member_id = ?
Parameters:
[
  74
]
0.36 ms
(0.90%)
1
SELECT t1.sec_id AS sec_id_2, t1.sec_code AS sec_code_3, t1.sec_name AS sec_name_4, t1.number AS number_5, t1.sec_active AS sec_active_6, t0.rtu_sector_created_at AS rtu_sector_created_at_7, t0.rtu_sector_updated_at AS rtu_sector_updated_at_8, t1.sec_upper_sector_id AS sec_upper_sector_id_9, t0.rtu_user_id AS rtu_user_id_10, t1.sec_type FROM rtu_sector t0 INNER JOIN sector t1 ON t0.sec_id = t1.sec_id WHERE t0.rtu_user_id = ?
Parameters:
[
  74
]
0.32 ms
(0.82%)
1
SELECT t0.sos_id AS sos_id_1, t0.sos_rrule AS sos_rrule_2, t0.sos_period AS sos_period_3, t0.sos_day AS sos_day_4, t0.sos_duration AS sos_duration_5, t0.sos_product_level_id AS sos_product_level_id_6, t0.sos_solicitation_id AS sos_solicitation_id_7 FROM solicitation_service t0 WHERE t0.sos_solicitation_id = ?
Parameters:
[
  6
]
0.22 ms
(0.55%)
1
"START TRANSACTION"
Parameters:
[]
0.21 ms
(0.53%)
1
SELECT t0.aut_id AS aut_id_1, t0.aut_title AS aut_title_2, t0.aut_description AS aut_description_3, t0.aut_avatar AS aut_avatar_4, t0.aut_created_at AS aut_created_at_5, t0.aut_updated_at AS aut_updated_at_6, t0.aut_coach_id AS aut_coach_id_7, t0.aut_discussion_id AS aut_discussion_id_8 FROM autonomous_team t0 WHERE t0.aut_coach_id = ?
Parameters:
[
  74
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Discussion\Discussion 7
App\Entity\Discussion\Message 6
App\Entity\User\User 4
App\Entity\Solicitation\SolicitationService 4
App\Entity\Address 3
App\Entity\Discussion\Gather 3
App\Entity\Sector 2
App\Entity\Solicitation\SolicitationResponse 2
App\Entity\ProductLevel 2
App\Entity\Origin 1
App\Entity\Solicitation\SolicitationConnection 1
App\Entity\Solicitation\SolicitationPropose 1
App\Entity\Autonomous\AutonomousTeam 1
App\Entity\Solicitation\Solicitation 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\Solicitation\SolicitationConnection No errors.
App\Entity\Solicitation\SolicitationPropose No errors.
App\Entity\Autonomous\AutonomousTeamRequest No errors.
App\Entity\Autonomous\AutonomousTeamMembers No errors.
App\Entity\SolicitationIntervenerKnowHowScore No errors.
App\Entity\Solicitation\Solicitation No errors.
App\Entity\Event No errors.
App\Entity\ReminderEvent No errors.
App\Entity\Solicitation\SolicitationService No errors.
App\Entity\Solicitation\SolicitationResponse No errors.
App\Entity\ProductLevel No errors.
App\Entity\Need No errors.
App\Entity\Rate No errors.