Symfony Profiler

SELECT
  c.*,
  pc.clinic_id
FROM
  communication as c
  join patient_conversation as pc on pc.id = c.conversation_id
where
  pc.clinic_id = ?
  and c.read_status = 0
  and c.sender_type = ?
LIMIT
  1

SELECT c.*,pc.clinic_id FROM communication as c join patient_conversation as pc on pc.id=c.conversation_id where  pc.clinic_id='3' and c.read_status=0 and c.sender_type=1 LIMIT 1;

SELECT
  cm.*
FROM
  `chat_messages` as cm
  join conversation as c on c.id = cm.conversation_id
where
  not FIND_IN_SET(?, cm.read_user_ids)
  and FIND_IN_SET(?, c.user_ids)
limit
  1

SELECT cm.* FROM `chat_messages` as cm join conversation as c on c.id=cm.conversation_id where not FIND_IN_SET(3229,cm.read_user_ids) and FIND_IN_SET(3229,c.user_ids) limit 1;

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.ever_login_in_v3 AS ever_login_in_v3_37,
  t0.deleted_at AS deleted_at_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.media_id AS media_id_41,
  t0.device_id AS device_id_42,
  t0.created_by_id AS created_by_id_43,
  t0.type,
  t0.organisation_id AS organisation_id_44,
  t0.current_clinic_id AS current_clinic_id_45,
  t0.status AS status_46,
  t0.birthday AS birthday_47,
  t0.country_code_alt AS country_code_alt_48,
  t0.secondary_phone AS secondary_phone_49,
  t0.next_kin AS next_kin_50,
  t0.next_kin_phone AS next_kin_phone_51,
  t0.description AS description_52,
  t0.glogau_scale AS glogau_scale_53,
  t0.fitzpatrick_scale AS fitzpatrick_scale_54,
  t0.gender AS gender_55,
  t0.receive_special_offer_email AS receive_special_offer_email_56,
  t0.receive_special_offer_sms AS receive_special_offer_sms_57,
  t0.receive_special_offer_push AS receive_special_offer_push_58,
  t0.receive_reminder_email AS receive_reminder_email_59,
  t0.receive_reminder_sms AS receive_reminder_sms_60,
  t0.receive_reminder_push AS receive_reminder_push_61,
  t0.parent_user_id AS parent_user_id_62,
  t0.account_type AS account_type_63,
  t0.terms_accepted AS terms_accepted_64,
  t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_65,
  t0.referral AS referral_66,
  t0.export_in_progress AS export_in_progress_67,
  t0.occupation AS occupation_68,
  t0.number_nhs AS number_nhs_69,
  t0.gp_name AS gp_name_70,
  t0.contact_gp AS contact_gp_71,
  t0.gp_address1 AS gp_address1_72,
  t0.gp_address2 AS gp_address2_73,
  t0.gp_town AS gp_town_74,
  t0.gp_county AS gp_county_75,
  t0.gp_post_code AS gp_post_code_76,
  t0.gp_country AS gp_country_77,
  t0.ref AS ref_78,
  t0.chronoscan_code AS chronoscan_code_79,
  t0.ethnicity AS ethnicity_80,
  t0.height AS height_81,
  t0.weight AS weight_82,
  t0.passport AS passport_83,
  t0.reference_number AS reference_number_84,
  t0.photo_consent AS photo_consent_85,
  t0.all_marketing AS all_marketing_86,
  t0.in_clinic_marketing AS in_clinic_marketing_87,
  t0.in_consultation AS in_consultation_88,
  t0.interested_in AS interested_in_89,
  t0.consultation_type AS consultation_type_90,
  t0.google_click_id AS google_click_id_91,
  t0.campaign_name AS campaign_name_92,
  t0.campaign_source AS campaign_source_93,
  t0.campaign_medium AS campaign_medium_94,
  t0.campaign_term AS campaign_term_95,
  t0.campaign_content AS campaign_content_96,
  t0.marketing_source AS marketing_source_97,
  t0.author AS author_98,
  t0.address1 AS address1_99,
  t0.address2 AS address2_100,
  t0.town AS town_101,
  t0.state AS state_102,
  t0.country AS country_103,
  t0.postcode AS postcode_104,
  t0.parent_id AS parent_id_105,
  t0.active_photo_id AS active_photo_id_106,
  t0.bar_code_image_id AS bar_code_image_id_107,
  t0.clinic_id AS clinic_id_108,
  t0.prospect_id AS prospect_id_109,
  t0.qualification AS qualification_110,
  t0.summary AS summary_111,
  t0.deleted AS deleted_112,
  t0.calendar_color AS calendar_color_113,
  t0.calendar_order_number AS calendar_order_number_114,
  t0.calendar_id AS calendar_id_115,
  t0.position AS position_116,
  t0.online_booking_availability AS online_booking_availability_117,
  t0.title AS title_118,
  t0.email_verify AS email_verify_119,
  t0.hash_user_short_url AS hash_user_short_url_120,
  t0.licence_number AS licence_number_121,
  t0.stripe_customer_id AS stripe_customer_id_122,
  t0.is_online AS is_online_123,
  t0.last_call_time AS last_call_time_124,
  t0.clinic_id AS clinic_id_125,
  t0.i_calendar_id AS i_calendar_id_126
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.ever_login_in_v3 AS ever_login_in_v3_37, t0.deleted_at AS deleted_at_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.media_id AS media_id_41, t0.device_id AS device_id_42, t0.created_by_id AS created_by_id_43, t0.type, t0.organisation_id AS organisation_id_44, t0.current_clinic_id AS current_clinic_id_45, t0.status AS status_46, t0.birthday AS birthday_47, t0.country_code_alt AS country_code_alt_48, t0.secondary_phone AS secondary_phone_49, t0.next_kin AS next_kin_50, t0.next_kin_phone AS next_kin_phone_51, t0.description AS description_52, t0.glogau_scale AS glogau_scale_53, t0.fitzpatrick_scale AS fitzpatrick_scale_54, t0.gender AS gender_55, t0.receive_special_offer_email AS receive_special_offer_email_56, t0.receive_special_offer_sms AS receive_special_offer_sms_57, t0.receive_special_offer_push AS receive_special_offer_push_58, t0.receive_reminder_email AS receive_reminder_email_59, t0.receive_reminder_sms AS receive_reminder_sms_60, t0.receive_reminder_push AS receive_reminder_push_61, t0.parent_user_id AS parent_user_id_62, t0.account_type AS account_type_63, t0.terms_accepted AS terms_accepted_64, t0.terms_accepted_patient_mode AS terms_accepted_patient_mode_65, t0.referral AS referral_66, t0.export_in_progress AS export_in_progress_67, t0.occupation AS occupation_68, t0.number_nhs AS number_nhs_69, t0.gp_name AS gp_name_70, t0.contact_gp AS contact_gp_71, t0.gp_address1 AS gp_address1_72, t0.gp_address2 AS gp_address2_73, t0.gp_town AS gp_town_74, t0.gp_county AS gp_county_75, t0.gp_post_code AS gp_post_code_76, t0.gp_country AS gp_country_77, t0.ref AS ref_78, t0.chronoscan_code AS chronoscan_code_79, t0.ethnicity AS ethnicity_80, t0.height AS height_81, t0.weight AS weight_82, t0.passport AS passport_83, t0.reference_number AS reference_number_84, t0.photo_consent AS photo_consent_85, t0.all_marketing AS all_marketing_86, t0.in_clinic_marketing AS in_clinic_marketing_87, t0.in_consultation AS in_consultation_88, t0.interested_in AS interested_in_89, t0.consultation_type AS consultation_type_90, t0.google_click_id AS google_click_id_91, t0.campaign_name AS campaign_name_92, t0.campaign_source AS campaign_source_93, t0.campaign_medium AS campaign_medium_94, t0.campaign_term AS campaign_term_95, t0.campaign_content AS campaign_content_96, t0.marketing_source AS marketing_source_97, t0.author AS author_98, t0.address1 AS address1_99, t0.address2 AS address2_100, t0.town AS town_101, t0.state AS state_102, t0.country AS country_103, t0.postcode AS postcode_104, t0.parent_id AS parent_id_105, t0.active_photo_id AS active_photo_id_106, t0.bar_code_image_id AS bar_code_image_id_107, t0.clinic_id AS clinic_id_108, t0.prospect_id AS prospect_id_109, t0.qualification AS qualification_110, t0.summary AS summary_111, t0.deleted AS deleted_112, t0.calendar_color AS calendar_color_113, t0.calendar_order_number AS calendar_order_number_114, t0.calendar_id AS calendar_id_115, t0.position AS position_116, t0.online_booking_availability AS online_booking_availability_117, t0.title AS title_118, t0.email_verify AS email_verify_119, t0.hash_user_short_url AS hash_user_short_url_120, t0.licence_number AS licence_number_121, t0.stripe_customer_id AS stripe_customer_id_122, t0.is_online AS is_online_123, t0.last_call_time AS last_call_time_124, t0.clinic_id AS clinic_id_125, t0.i_calendar_id AS i_calendar_id_126 FROM user t0 WHERE t0.id = 3229 AND t0.type IN ('admin', 'super_clinic_admin', 'patient', 'clinic_user');

SELECT
  c.*,
  pc.clinic_id
FROM
  prospect_communication as c
  join prospect_conversation as pc on pc.id = c.conversation_id
where
  pc.clinic_id = ?
  and c.read_status = 0
  and c.sender_type = ?
LIMIT
  1

SELECT c.*,pc.clinic_id FROM prospect_communication as c join prospect_conversation as pc on pc.id=c.conversation_id where pc.clinic_id='3' and c.read_status=0 and c.sender_type=1 LIMIT 1;