GET https://preprod-backapp.utech.care/api/discussions?nb_per_page=25&page=1

Query Metrics

18 Database Queries
9 Different statements
80.61 ms Query time
0 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
46.04 ms
(57.11%)
1
SELECT disc.*,
            gat.gat_notification_state,
            gat.gat_is_favorite,
            gat.gat_nb_unread,
            gat.gat_last_message_read_id,
            msg.mes_id,
            msg.mes_message,
            msg.mes_sent_at,
            msg.mes_type,
            sender.usr_id AS sender_id,
            sender.usr_first_name AS sender_first_name,
            sender.usr_last_name AS sender_last_name,
            sender.usr_slug AS sender_slug,
            sender.usr_rank AS sender_rank,
            sender.usr_title AS sender_title,
            usr_cus.usr_id AS customer_id,
            usr_cus.usr_title AS customer_title,
            usr_cus.usr_first_name AS customer_first_name,
            usr_cus.usr_last_name AS customer_last_name,
            aut.aut_id AS autonomous_team_id,
            aut.aut_avatar AS autonomous_team_avatar
            FROM gather gat
            INNER JOIN discussion disc ON gat.gat_discussion_id = disc.dis_id
            LEFT JOIN message msg ON msg.mes_id = disc.dis_last_message_id
            LEFT JOIN user_account sender ON sender.usr_id = mes_user_id
            LEFT JOIN autonomous_team aut ON aut.aut_discussion_id = disc.dis_id
            LEFT JOIN customer cow ON cow.cus_suivi_id = disc.dis_id
            LEFT JOIN customer cus ON cus.cus_suivi_pro_id = disc.dis_id
            LEFT JOIN customer cua ON cua.cus_suivi_administrative_id = disc.dis_id
            LEFT JOIN customer cuh ON cuh.cus_suivi_health_id = disc.dis_id
            LEFT JOIN user_account usr_cus ON (
                cow.usr_id = usr_cus.usr_id
                OR cus.usr_id = usr_cus.usr_id
                OR cua.usr_id = usr_cus.usr_id
                OR cuh.usr_id = usr_cus.usr_id
            )
            WHERE gat.gat_user_id = ? ORDER BY gat.gat_is_favorite DESC NULLS LAST,
            mes_sent_at DESC NULLS LAST,
            gat_nb_unread DESC NULLS LAST,
            dis_title ASC,
            dis_id ASC LIMIT ? OFFSET ?
Parameters:
[
  23
  25
  0
]
18.53 ms
(22.99%)
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.60 ms
(6.95%)
4
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.32 ms
(5.36%)
4
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
]
2.50 ms
(3.10%)
4
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.24 ms
(1.53%)
1
"COMMIT"
Parameters:
[]
1.21 ms
(1.50%)
1
SELECT t0.sec_id AS sec_id_2, t0.sec_code AS sec_code_3, t0.sec_name AS sec_name_4, t0.number AS number_5, t0.sec_active AS sec_active_6, t0.sec_upper_sector_id AS sec_upper_sector_id_7, t0.sec_type, t1.rtu_sector_created_at AS rtu_sector_created_at_8, t1.rtu_sector_updated_at AS rtu_sector_updated_at_9, t1.rtu_user_id AS rtu_user_id_10 FROM sector t0 LEFT JOIN rtu_sector t1 ON t0.sec_id = t1.sec_id WHERE t0.sec_id = ?
Parameters:
[
  8
]
0.80 ms
(1.00%)
1
UPDATE user_account SET usr_last_connection = ? WHERE usr_id = ?
Parameters:
[
  "2026-07-01 10:49:14+0200"
  23
]
0.38 ms
(0.47%)
1
"START TRANSACTION"
Parameters:
[]

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 4
App\Entity\Discussion\Message 4
App\Entity\User\User 2
App\Entity\Address 1
App\Entity\Sector 1
App\Entity\Origin 1