Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.full_name AS full_name_6,
  t0.password AS password_7,
  t0.booking_btn_name AS booking_btn_name_8,
  t0.booking_btn_clr AS booking_btn_clr_9,
  t0.booking_btn_bg_clr AS booking_btn_bg_clr_10,
  t0.inner_color AS inner_color_11,
  t0.outer_color AS outer_color_12,
  t0.background_img AS background_img_13,
  t0.profile_img AS profile_img_14,
  t0.role AS role_15,
  t0.enabled AS enabled_16,
  t0.locked AS locked_17,
  t0.visible AS visible_18,
  t0.otp AS otp_19,
  t0.otp_sent_at AS otp_sent_at_20,
  t0.last_otp_verified AS last_otp_verified_21,
  t0.imap_setting AS imap_setting_22,
  t0.country_code AS country_code_23,
  t0.phone AS phone_24,
  t0.practitioner_commission AS practitioner_commission_25,
  t0.coordinator_commission AS coordinator_commission_26,
  t0.course_commission AS course_commission_27,
  t0.membership_commission AS membership_commission_28,
  t0.product_commission AS product_commission_29,
  t0.token AS token_30,
  t0.access_all_calendars AS access_all_calendars_31,
  t0.current_auth_token AS current_auth_token_32,
  t0.last_auth_time AS last_auth_time_33,
  t0.hash AS hash_34,
  t0.hx_change_token AS hx_change_token_35,
  t0.login_from AS login_from_36,
  t0.deleted_at AS deleted_at_37,
  t0.created_at AS created_at_38,
  t0.updated_at AS updated_at_39,
  t0.media_id AS media_id_40,
  t0.device_id AS device_id_41,
  t0.created_by_id AS created_by_id_42,
  t0.type,
  t0.organisation_id AS organisation_id_43,
  t0.current_clinic_id AS current_clinic_id_44,
  t0.status AS status_45,
  t0.birthday AS birthday_46,
  t0.country_code_alt AS country_code_alt_47,
  t0.secondary_phone AS secondary_phone_48,
  t0.next_kin AS next_kin_49,
  t0.next_kin_phone AS next_kin_phone_50,
  t0.description AS description_51,
  t0.glogau_scale AS glogau_scale_52,
  t0.fitzpatrick_scale AS fitzpatrick_scale_53,
  t0.gender AS gender_54,
  t0.receive_special_offer_email AS receive_special_offer_email_55,
  t0.receive_special_offer_sms AS receive_special_offer_sms_56,
  t0.receive_special_offer_push AS receive_special_offer_push_57,
  t0.receive_reminder_email AS receive_reminder_email_58,
  t0.receive_reminder_sms AS receive_reminder_sms_59,
  t0.receive_reminder_push AS receive_reminder_push_60,
  t0.parent_user_id AS parent_user_id_61,
  t0.account_type AS account_type_62,
  t0.terms_accepted AS terms_accepted_63,
  t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_64,
  t0.referral AS referral_65,
  t0.export_in_progress AS export_in_progress_66,
  t0.occupation AS occupation_67,
  t0.number_nhs AS number_nhs_68,
  t0.gp_name AS gp_name_69,
  t0.contact_gp AS contact_gp_70,
  t0.gp_address1 AS gp_address1_71,
  t0.gp_address2 AS gp_address2_72,
  t0.gp_town AS gp_town_73,
  t0.gp_county AS gp_county_74,
  t0.gp_post_code AS gp_post_code_75,
  t0.gp_country AS gp_country_76,
  t0.ref AS ref_77,
  t0.chronoscan_code AS chronoscan_code_78,
  t0.ethnicity AS ethnicity_79,
  t0.height AS height_80,
  t0.weight AS weight_81,
  t0.passport AS passport_82,
  t0.reference_number AS reference_number_83,
  t0.photo_consent AS photo_consent_84,
  t0.all_marketing AS all_marketing_85,
  t0.in_clinic_marketing AS in_clinic_marketing_86,
  t0.in_consultation AS in_consultation_87,
  t0.interested_in AS interested_in_88,
  t0.consultation_type AS consultation_type_89,
  t0.google_click_id AS google_click_id_90,
  t0.campaign_name AS campaign_name_91,
  t0.campaign_source AS campaign_source_92,
  t0.campaign_medium AS campaign_medium_93,
  t0.campaign_term AS campaign_term_94,
  t0.campaign_content AS campaign_content_95,
  t0.marketing_source AS marketing_source_96,
  t0.author AS author_97,
  t0.address1 AS address1_98,
  t0.address2 AS address2_99,
  t0.town AS town_100,
  t0.state AS state_101,
  t0.country AS country_102,
  t0.postcode AS postcode_103,
  t0.parent_id AS parent_id_104,
  t0.active_photo_id AS active_photo_id_105,
  t0.bar_code_image_id AS bar_code_image_id_106,
  t0.clinic_id AS clinic_id_107,
  t0.prospect_id AS prospect_id_108,
  t0.qualification AS qualification_109,
  t0.summary AS summary_110,
  t0.deleted AS deleted_111,
  t0.calendar_color AS calendar_color_112,
  t0.calendar_order_number AS calendar_order_number_113,
  t0.calendar_id AS calendar_id_114,
  t0.position AS position_115,
  t0.online_booking_availability AS online_booking_availability_116,
  t0.title AS title_117,
  t0.email_verify AS email_verify_118,
  t0.hash_user_short_url AS hash_user_short_url_119,
  t0.licence_number AS licence_number_120,
  t0.stripe_customer_id AS stripe_customer_id_121,
  t0.is_online AS is_online_122,
  t0.last_call_time AS last_call_time_123,
  t0.clinic_id AS clinic_id_124,
  t0.i_calendar_id AS i_calendar_id_125
FROM
  user t0
WHERE
  t0.id = ?
  AND t0.type IN (
    'admin', 'super_clinic_admin', 'patient',
    'clinic_user'
  )

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.full_name AS full_name_6, t0.password AS password_7, t0.booking_btn_name AS booking_btn_name_8, t0.booking_btn_clr AS booking_btn_clr_9, t0.booking_btn_bg_clr AS booking_btn_bg_clr_10, t0.inner_color AS inner_color_11, t0.outer_color AS outer_color_12, t0.background_img AS background_img_13, t0.profile_img AS profile_img_14, t0.role AS role_15, t0.enabled AS enabled_16, t0.locked AS locked_17, t0.visible AS visible_18, t0.otp AS otp_19, t0.otp_sent_at AS otp_sent_at_20, t0.last_otp_verified AS last_otp_verified_21, t0.imap_setting AS imap_setting_22, t0.country_code AS country_code_23, t0.phone AS phone_24, t0.practitioner_commission AS practitioner_commission_25, t0.coordinator_commission AS coordinator_commission_26, t0.course_commission AS course_commission_27, t0.membership_commission AS membership_commission_28, t0.product_commission AS product_commission_29, t0.token AS token_30, t0.access_all_calendars AS access_all_calendars_31, t0.current_auth_token AS current_auth_token_32, t0.last_auth_time AS last_auth_time_33, t0.hash AS hash_34, t0.hx_change_token AS hx_change_token_35, t0.login_from AS login_from_36, t0.deleted_at AS deleted_at_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.media_id AS media_id_40, t0.device_id AS device_id_41, t0.created_by_id AS created_by_id_42, t0.type, t0.organisation_id AS organisation_id_43, t0.current_clinic_id AS current_clinic_id_44, t0.status AS status_45, t0.birthday AS birthday_46, t0.country_code_alt AS country_code_alt_47, t0.secondary_phone AS secondary_phone_48, t0.next_kin AS next_kin_49, t0.next_kin_phone AS next_kin_phone_50, t0.description AS description_51, t0.glogau_scale AS glogau_scale_52, t0.fitzpatrick_scale AS fitzpatrick_scale_53, t0.gender AS gender_54, t0.receive_special_offer_email AS receive_special_offer_email_55, t0.receive_special_offer_sms AS receive_special_offer_sms_56, t0.receive_special_offer_push AS receive_special_offer_push_57, t0.receive_reminder_email AS receive_reminder_email_58, t0.receive_reminder_sms AS receive_reminder_sms_59, t0.receive_reminder_push AS receive_reminder_push_60, t0.parent_user_id AS parent_user_id_61, t0.account_type AS account_type_62, t0.terms_accepted AS terms_accepted_63, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_64, t0.referral AS referral_65, t0.export_in_progress AS export_in_progress_66, t0.occupation AS occupation_67, t0.number_nhs AS number_nhs_68, t0.gp_name AS gp_name_69, t0.contact_gp AS contact_gp_70, t0.gp_address1 AS gp_address1_71, t0.gp_address2 AS gp_address2_72, t0.gp_town AS gp_town_73, t0.gp_county AS gp_county_74, t0.gp_post_code AS gp_post_code_75, t0.gp_country AS gp_country_76, t0.ref AS ref_77, t0.chronoscan_code AS chronoscan_code_78, t0.ethnicity AS ethnicity_79, t0.height AS height_80, t0.weight AS weight_81, t0.passport AS passport_82, t0.reference_number AS reference_number_83, t0.photo_consent AS photo_consent_84, t0.all_marketing AS all_marketing_85, t0.in_clinic_marketing AS in_clinic_marketing_86, t0.in_consultation AS in_consultation_87, t0.interested_in AS interested_in_88, t0.consultation_type AS consultation_type_89, t0.google_click_id AS google_click_id_90, t0.campaign_name AS campaign_name_91, t0.campaign_source AS campaign_source_92, t0.campaign_medium AS campaign_medium_93, t0.campaign_term AS campaign_term_94, t0.campaign_content AS campaign_content_95, t0.marketing_source AS marketing_source_96, t0.author AS author_97, t0.address1 AS address1_98, t0.address2 AS address2_99, t0.town AS town_100, t0.state AS state_101, t0.country AS country_102, t0.postcode AS postcode_103, t0.parent_id AS parent_id_104, t0.active_photo_id AS active_photo_id_105, t0.bar_code_image_id AS bar_code_image_id_106, t0.clinic_id AS clinic_id_107, t0.prospect_id AS prospect_id_108, t0.qualification AS qualification_109, t0.summary AS summary_110, t0.deleted AS deleted_111, t0.calendar_color AS calendar_color_112, t0.calendar_order_number AS calendar_order_number_113, t0.calendar_id AS calendar_id_114, t0.position AS position_115, t0.online_booking_availability AS online_booking_availability_116, t0.title AS title_117, t0.email_verify AS email_verify_118, t0.hash_user_short_url AS hash_user_short_url_119, t0.licence_number AS licence_number_120, t0.stripe_customer_id AS stripe_customer_id_121, t0.is_online AS is_online_122, t0.last_call_time AS last_call_time_123, t0.clinic_id AS clinic_id_124, t0.i_calendar_id AS i_calendar_id_125 FROM user t0 WHERE t0.id = 3229 AND t0.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user');

select
  *
from
  conversation
where
  id = ?
  and FIND_IN_SET(?, user_ids)

select * from conversation where id = '160' and FIND_IN_SET(3229,user_ids);

select
  m.*,
  concat(u.first_name, ' ', u.last_name) as name,
  u.profile_img as image,
  media.url as media_url
from
  chat_messages as m
  left join user as u on u.id = m.from_user_id
  left join media on u.media_id = media.id
where
  m.conversation_id = ?AND (
    m.deleted_by IS NULL
    OR m.deleted_by NOT LIKE ?
  )
order by
  m.created_at desc
limit
  50 offset 0

select m.*,concat(u.first_name,' ',u.last_name) as name ,u.profile_img as image,media.url as media_url  from chat_messages as m left join user as u on u.id=m.from_user_id left join media on u.media_id=media.id where m.conversation_id='160'AND (m.deleted_by IS NULL OR m.deleted_by NOT LIKE '%3229%') order by m.created_at desc limit 50 offset 0 ;

UPDATE
  `chat_messages`
SET
  `status` = 1
WHERE
  `conversation_id` = ?
  and `to_user_id` = ?

UPDATE `chat_messages` SET `status` = 1 WHERE `conversation_id`='160' and `to_user_id`=3229 ;

UPDATE
  `chat_messages`
SET
  `read_user_ids` = concat(read_user_ids, ',3229')
WHERE
  `conversation_id` = ?
  and not FIND_IN_SET(?, read_user_ids)

UPDATE `chat_messages` SET `read_user_ids` =concat(read_user_ids,',3229')  WHERE `conversation_id`='160' and not FIND_IN_SET(3229,read_user_ids) ;