Symfony Profiler

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 = ?

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 = 8;

UPDATE
  user_account
SET
  usr_last_connection = ?
WHERE
  usr_id = ?

UPDATE user_account SET usr_last_connection = '2026-07-01 10:49:10+0200' WHERE usr_id = 23;

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

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 = 'customer1@utech.care' LIMIT 1;

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 = ?

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 = 66;

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 = ?

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 = 66;

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 = ?

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 = 66;

SELECT
  s0_.solc_id AS solc_id_0,
  s0_.solc_is_valid_by_customer AS solc_is_valid_by_customer_1,
  s0_.solc_is_valid_by_intervener AS solc_is_valid_by_intervener_2,
  s0_.solc_validation_message AS solc_validation_message_3,
  s0_.solc_created_at AS solc_created_at_4,
  s0_.solc_social_skills_score AS solc_social_skills_score_5,
  s0_.solc_final_choice AS solc_final_choice_6,
  s0_.solc_initial_hourly_rate AS solc_initial_hourly_rate_7,
  s0_.solc_discussion_id AS solc_discussion_id_8,
  s0_.solc_employment_id AS solc_employment_id_9,
  s0_.solc_task_id AS solc_task_id_10,
  s0_.solc_contract_id AS solc_contract_id_11,
  s0_.solc_solicitation_propose_id AS solc_solicitation_propose_id_12
FROM
  solicitation_connection s0_
  INNER JOIN solicitation_propose s1_ ON s0_.solc_solicitation_propose_id = s1_.sop_id
  INNER JOIN solicitation s2_ ON s1_.sop_solicitation_id = s2_.sol_id
WHERE
  s2_.sol_customer_id IN (?)
  AND s1_.sop_status = ?
  AND s1_.sop_state = ?
  AND s2_.sol_type = ?

SELECT s0_.solc_id AS solc_id_0, s0_.solc_is_valid_by_customer AS solc_is_valid_by_customer_1, s0_.solc_is_valid_by_intervener AS solc_is_valid_by_intervener_2, s0_.solc_validation_message AS solc_validation_message_3, s0_.solc_created_at AS solc_created_at_4, s0_.solc_social_skills_score AS solc_social_skills_score_5, s0_.solc_final_choice AS solc_final_choice_6, s0_.solc_initial_hourly_rate AS solc_initial_hourly_rate_7, s0_.solc_discussion_id AS solc_discussion_id_8, s0_.solc_employment_id AS solc_employment_id_9, s0_.solc_task_id AS solc_task_id_10, s0_.solc_contract_id AS solc_contract_id_11, s0_.solc_solicitation_propose_id AS solc_solicitation_propose_id_12 FROM solicitation_connection s0_ INNER JOIN solicitation_propose s1_ ON s0_.solc_solicitation_propose_id = s1_.sop_id INNER JOIN solicitation s2_ ON s1_.sop_solicitation_id = s2_.sol_id WHERE s2_.sol_customer_id IN (23) AND s1_.sop_status = 1 AND s1_.sop_state = 1 AND s2_.sol_type = 'selfed';

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

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 = ?

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 = 23;