Query Metrics
45
Database Queries
22
Different statements
39.67 ms
Query time
0
Invalid entities
38
Managed entities
Grouped Statements
| 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 |