0.77 ms
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . media_id AS media_id_50 , t0 . device_id AS device_id_51 , t0 . created_by_id AS created_by_id_52 , t0 . type , t0 . stripe_customer_id AS stripe_customer_id_53 , t0 . stripe_customer_id AS stripe_customer_id_54 , t0 . organisation_id AS organisation_id_55 , t0 . current_clinic_id AS current_clinic_id_56 , t0 . status AS status_57 , t0 . birthday AS birthday_58 , t0 . country_code_alt AS country_code_alt_59 , t0 . secondary_phone AS secondary_phone_60 , t0 . next_kin AS next_kin_61 , t0 . next_kin_phone AS next_kin_phone_62 , t0 . description AS description_63 , t0 . glogau_scale AS glogau_scale_64 , t0 . fitzpatrick_scale AS fitzpatrick_scale_65 , t0 . gender AS gender_66 , t0 . receive_special_offer_push AS receive_special_offer_push_67 , t0 . receive_reminder_email AS receive_reminder_email_68 , t0 . receive_reminder_sms AS receive_reminder_sms_69 , t0 . receive_reminder_push AS receive_reminder_push_70 , t0 . parent_user_id AS parent_user_id_71 , t0 . account_type AS account_type_72 , t0 . terms_accepted AS terms_accepted_73 , t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_74 , t0 . referral AS referral_75 , t0 . export_in_progress AS export_in_progress_76 , t0 . occupation AS occupation_77 , t0 . number_nhs AS number_nhs_78 , t0 . gp_name AS gp_name_79 , t0 . contact_gp AS contact_gp_80 , t0 . gp_address1 AS gp_address1_81 , t0 . gp_address2 AS gp_address2_82 , t0 . gp_town AS gp_town_83 , t0 . gp_county AS gp_county_84 , t0 . gp_post_code AS gp_post_code_85 , t0 . gp_country AS gp_country_86 , t0 . ref AS ref_87 , t0 . chronoscan_code AS chronoscan_code_88 , t0 . ethnicity AS ethnicity_89 , t0 . height AS height_90 , t0 . weight AS weight_91 , t0 . passport AS passport_92 , t0 . reference_number AS reference_number_93 , t0 . photo_consent AS photo_consent_94 , t0 . all_marketing AS all_marketing_95 , t0 . in_clinic_marketing AS in_clinic_marketing_96 , t0 . in_consultation AS in_consultation_97 , t0 . interested_in AS interested_in_98 , t0 . consultation_type AS consultation_type_99 , t0 . google_click_id AS google_click_id_100 , t0 . campaign_name AS campaign_name_101 , t0 . campaign_source AS campaign_source_102 , t0 . campaign_medium AS campaign_medium_103 , t0 . campaign_term AS campaign_term_104 , t0 . campaign_content AS campaign_content_105 , t0 . marketing_source AS marketing_source_106 , t0 . author AS author_107 , t0 . address1 AS address1_108 , t0 . address2 AS address2_109 , t0 . town AS town_110 , t0 . state AS state_111 , t0 . country AS country_112 , t0 . postcode AS postcode_113 , t0 . parent_id AS parent_id_114 , t0 . active_photo_id AS active_photo_id_115 , t0 . bar_code_image_id AS bar_code_image_id_116 , t0 . clinic_id AS clinic_id_117 , t0 . prospect_id AS prospect_id_118 , t0 . qualification AS qualification_119 , t0 . summary AS summary_120 , t0 . deleted AS deleted_121 , t0 . calendar_color AS calendar_color_122 , t0 . calendar_order_number AS calendar_order_number_123 , t0 . calendar_id AS calendar_id_124 , t0 . position AS position_125 , t0 . online_booking_availability AS online_booking_availability_126 , t0 . title AS title_127 , t0 . email_verify AS email_verify_128 , t0 . hash_user_short_url AS hash_user_short_url_129 , t0 . licence_number AS licence_number_130 , t0 . stripe_customer_id AS stripe_customer_id_131 , t0 . is_online AS is_online_132 , t0 . last_call_time AS last_call_time_133 , t0 . hide_report_menus AS hide_report_menus_134 , t0 . clinic_id AS clinic_id_135 , t0 . i_calendar_id AS i_calendar_id_136 FROM user t0 WHERE t0 . id = ? AND t0 . type IN ('admin' , 'admin_support' , '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 . is_disengaged AS is_disengaged_19 ,
t0 . otp AS otp_20 ,
t0 . otp_sent_at AS otp_sent_at_21 ,
t0 . last_otp_verified AS last_otp_verified_22 ,
t0 . imap_setting AS imap_setting_23 ,
t0 . country_code AS country_code_24 ,
t0 . phone AS phone_25 ,
t0 . practitioner_commission AS practitioner_commission_26 ,
t0 . coordinator_commission AS coordinator_commission_27 ,
t0 . course_commission AS course_commission_28 ,
t0 . membership_commission AS membership_commission_29 ,
t0 . product_commission AS product_commission_30 ,
t0 . token AS token_31 ,
t0 . access_all_calendars AS access_all_calendars_32 ,
t0 . current_auth_token AS current_auth_token_33 ,
t0 . last_auth_time AS last_auth_time_34 ,
t0 . hash AS hash_35 ,
t0 . fcm_token AS fcm_token_36 ,
t0 . hx_change_token AS hx_change_token_37 ,
t0 . login_from AS login_from_38 ,
t0 . ever_login_in_v3 AS ever_login_in_v3_39 ,
t0 . permissions AS permissions_40 ,
t0 . clinic_id AS clinic_id_41 ,
t0 . fp_promoter_id AS fp_promoter_id_42 ,
t0 . referral_link AS referral_link_43 ,
t0 . fp_tracking_id AS fp_tracking_id_44 ,
t0 . receive_special_offer_email AS receive_special_offer_email_45 ,
t0 . receive_special_offer_sms AS receive_special_offer_sms_46 ,
t0 . deleted_at AS deleted_at_47 ,
t0 . created_at AS created_at_48 ,
t0 . updated_at AS updated_at_49 ,
t0 . media_id AS media_id_50 ,
t0 . device_id AS device_id_51 ,
t0 . created_by_id AS created_by_id_52 ,
t0 . type ,
t0 . stripe_customer_id AS stripe_customer_id_53 ,
t0 . stripe_customer_id AS stripe_customer_id_54 ,
t0 . organisation_id AS organisation_id_55 ,
t0 . current_clinic_id AS current_clinic_id_56 ,
t0 . status AS status_57 ,
t0 . birthday AS birthday_58 ,
t0 . country_code_alt AS country_code_alt_59 ,
t0 . secondary_phone AS secondary_phone_60 ,
t0 . next_kin AS next_kin_61 ,
t0 . next_kin_phone AS next_kin_phone_62 ,
t0 . description AS description_63 ,
t0 . glogau_scale AS glogau_scale_64 ,
t0 . fitzpatrick_scale AS fitzpatrick_scale_65 ,
t0 . gender AS gender_66 ,
t0 . receive_special_offer_push AS receive_special_offer_push_67 ,
t0 . receive_reminder_email AS receive_reminder_email_68 ,
t0 . receive_reminder_sms AS receive_reminder_sms_69 ,
t0 . receive_reminder_push AS receive_reminder_push_70 ,
t0 . parent_user_id AS parent_user_id_71 ,
t0 . account_type AS account_type_72 ,
t0 . terms_accepted AS terms_accepted_73 ,
t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_74 ,
t0 . referral AS referral_75 ,
t0 . export_in_progress AS export_in_progress_76 ,
t0 . occupation AS occupation_77 ,
t0 . number_nhs AS number_nhs_78 ,
t0 . gp_name AS gp_name_79 ,
t0 . contact_gp AS contact_gp_80 ,
t0 . gp_address1 AS gp_address1_81 ,
t0 . gp_address2 AS gp_address2_82 ,
t0 . gp_town AS gp_town_83 ,
t0 . gp_county AS gp_county_84 ,
t0 . gp_post_code AS gp_post_code_85 ,
t0 . gp_country AS gp_country_86 ,
t0 . ref AS ref_87 ,
t0 . chronoscan_code AS chronoscan_code_88 ,
t0 . ethnicity AS ethnicity_89 ,
t0 . height AS height_90 ,
t0 . weight AS weight_91 ,
t0 . passport AS passport_92 ,
t0 . reference_number AS reference_number_93 ,
t0 . photo_consent AS photo_consent_94 ,
t0 . all_marketing AS all_marketing_95 ,
t0 . in_clinic_marketing AS in_clinic_marketing_96 ,
t0 . in_consultation AS in_consultation_97 ,
t0 . interested_in AS interested_in_98 ,
t0 . consultation_type AS consultation_type_99 ,
t0 . google_click_id AS google_click_id_100 ,
t0 . campaign_name AS campaign_name_101 ,
t0 . campaign_source AS campaign_source_102 ,
t0 . campaign_medium AS campaign_medium_103 ,
t0 . campaign_term AS campaign_term_104 ,
t0 . campaign_content AS campaign_content_105 ,
t0 . marketing_source AS marketing_source_106 ,
t0 . author AS author_107 ,
t0 . address1 AS address1_108 ,
t0 . address2 AS address2_109 ,
t0 . town AS town_110 ,
t0 . state AS state_111 ,
t0 . country AS country_112 ,
t0 . postcode AS postcode_113 ,
t0 . parent_id AS parent_id_114 ,
t0 . active_photo_id AS active_photo_id_115 ,
t0 . bar_code_image_id AS bar_code_image_id_116 ,
t0 . clinic_id AS clinic_id_117 ,
t0 . prospect_id AS prospect_id_118 ,
t0 . qualification AS qualification_119 ,
t0 . summary AS summary_120 ,
t0 . deleted AS deleted_121 ,
t0 . calendar_color AS calendar_color_122 ,
t0 . calendar_order_number AS calendar_order_number_123 ,
t0 . calendar_id AS calendar_id_124 ,
t0 . position AS position_125 ,
t0 . online_booking_availability AS online_booking_availability_126 ,
t0 . title AS title_127 ,
t0 . email_verify AS email_verify_128 ,
t0 . hash_user_short_url AS hash_user_short_url_129 ,
t0 . licence_number AS licence_number_130 ,
t0 . stripe_customer_id AS stripe_customer_id_131 ,
t0 . is_online AS is_online_132 ,
t0 . last_call_time AS last_call_time_133 ,
t0 . hide_report_menus AS hide_report_menus_134 ,
t0 . clinic_id AS clinic_id_135 ,
t0 . i_calendar_id AS i_calendar_id_136
FROM
user t0
WHERE
t0 . id = ?
AND t0 . type IN (
'admin' , 'admin_support' , 'super_clinic_admin' ,
'patient' , 'clinic_user'
)Copy
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . media_id AS media_id_50 , t0 . device_id AS device_id_51 , t0 . created_by_id AS created_by_id_52 , t0 . type , t0 . stripe_customer_id AS stripe_customer_id_53 , t0 . stripe_customer_id AS stripe_customer_id_54 , t0 . organisation_id AS organisation_id_55 , t0 . current_clinic_id AS current_clinic_id_56 , t0 . status AS status_57 , t0 . birthday AS birthday_58 , t0 . country_code_alt AS country_code_alt_59 , t0 . secondary_phone AS secondary_phone_60 , t0 . next_kin AS next_kin_61 , t0 . next_kin_phone AS next_kin_phone_62 , t0 . description AS description_63 , t0 . glogau_scale AS glogau_scale_64 , t0 . fitzpatrick_scale AS fitzpatrick_scale_65 , t0 . gender AS gender_66 , t0 . receive_special_offer_push AS receive_special_offer_push_67 , t0 . receive_reminder_email AS receive_reminder_email_68 , t0 . receive_reminder_sms AS receive_reminder_sms_69 , t0 . receive_reminder_push AS receive_reminder_push_70 , t0 . parent_user_id AS parent_user_id_71 , t0 . account_type AS account_type_72 , t0 . terms_accepted AS terms_accepted_73 , t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_74 , t0 . referral AS referral_75 , t0 . export_in_progress AS export_in_progress_76 , t0 . occupation AS occupation_77 , t0 . number_nhs AS number_nhs_78 , t0 . gp_name AS gp_name_79 , t0 . contact_gp AS contact_gp_80 , t0 . gp_address1 AS gp_address1_81 , t0 . gp_address2 AS gp_address2_82 , t0 . gp_town AS gp_town_83 , t0 . gp_county AS gp_county_84 , t0 . gp_post_code AS gp_post_code_85 , t0 . gp_country AS gp_country_86 , t0 . ref AS ref_87 , t0 . chronoscan_code AS chronoscan_code_88 , t0 . ethnicity AS ethnicity_89 , t0 . height AS height_90 , t0 . weight AS weight_91 , t0 . passport AS passport_92 , t0 . reference_number AS reference_number_93 , t0 . photo_consent AS photo_consent_94 , t0 . all_marketing AS all_marketing_95 , t0 . in_clinic_marketing AS in_clinic_marketing_96 , t0 . in_consultation AS in_consultation_97 , t0 . interested_in AS interested_in_98 , t0 . consultation_type AS consultation_type_99 , t0 . google_click_id AS google_click_id_100 , t0 . campaign_name AS campaign_name_101 , t0 . campaign_source AS campaign_source_102 , t0 . campaign_medium AS campaign_medium_103 , t0 . campaign_term AS campaign_term_104 , t0 . campaign_content AS campaign_content_105 , t0 . marketing_source AS marketing_source_106 , t0 . author AS author_107 , t0 . address1 AS address1_108 , t0 . address2 AS address2_109 , t0 . town AS town_110 , t0 . state AS state_111 , t0 . country AS country_112 , t0 . postcode AS postcode_113 , t0 . parent_id AS parent_id_114 , t0 . active_photo_id AS active_photo_id_115 , t0 . bar_code_image_id AS bar_code_image_id_116 , t0 . clinic_id AS clinic_id_117 , t0 . prospect_id AS prospect_id_118 , t0 . qualification AS qualification_119 , t0 . summary AS summary_120 , t0 . deleted AS deleted_121 , t0 . calendar_color AS calendar_color_122 , t0 . calendar_order_number AS calendar_order_number_123 , t0 . calendar_id AS calendar_id_124 , t0 . position AS position_125 , t0 . online_booking_availability AS online_booking_availability_126 , t0 . title AS title_127 , t0 . email_verify AS email_verify_128 , t0 . hash_user_short_url AS hash_user_short_url_129 , t0 . licence_number AS licence_number_130 , t0 . stripe_customer_id AS stripe_customer_id_131 , t0 . is_online AS is_online_132 , t0 . last_call_time AS last_call_time_133 , t0 . hide_report_menus AS hide_report_menus_134 , t0 . clinic_id AS clinic_id_135 , t0 . i_calendar_id AS i_calendar_id_136 FROM user t0 WHERE t0 . id = 3229 AND t0 . type IN ('admin' , 'admin_support' , 'super_clinic_admin' , 'patient' , 'clinic_user' ); Copy
0.76 ms
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sub_domain AS sub_domain_3 , t0 . organisation_id AS organisation_id_4 , t0 . smscredit AS smscredit_5 , t0 . ai_token_credit AS ai_token_credit_6 , t0 . last_daily_token_date AS last_daily_token_date_7 , t0 . ai_seconds_credit AS ai_seconds_credit_8 , t0 . daily_ai_token_credit AS daily_ai_token_credit_9 , t0 . booking_btn_name AS booking_btn_name_10 , t0 . booking_btn_clr AS booking_btn_clr_11 , t0 . booking_btn_bg_clr AS booking_btn_bg_clr_12 , t0 . inner_color AS inner_color_13 , t0 . outer_color AS outer_color_14 , t0 . background_img AS background_img_15 , t0 . profile_img AS profile_img_16 , t0 . meeting_price AS meeting_price_17 , t0 . meeting_price_type AS meeting_price_type_18 , t0 . show_in_public_profile AS show_in_public_profile_19 , t0 . patient_ref_prefix AS patient_ref_prefix_20 , t0 . email AS email_21 , t0 . verified_email AS verified_email_22 , t0 . web_site AS web_site_23 , t0 . phone AS phone_24 , t0 . contact_name AS contact_name_25 , t0 . description AS description_26 , t0 . widget_settings AS widget_settings_27 , t0 . sms_number AS sms_number_28 , t0 . sms_status AS sms_status_29 , t0 . timezone AS timezone_30 , t0 . reminder_header AS reminder_header_31 , t0 . reminder_footer AS reminder_footer_32 , t0 . reminder_recall_text AS reminder_recall_text_33 , t0 . google_token AS google_token_34 , t0 . google_id AS google_id_35 , t0 . topic_arn AS topic_arn_36 , t0 . pm_pin AS pm_pin_37 , t0 . auto_email_reply_address AS auto_email_reply_address_38 , t0 . pm_patient_message AS pm_patient_message_39 , t0 . pm_clinic_intro AS pm_clinic_intro_40 , t0 . auto_renew_subscription AS auto_renew_subscription_41 , t0 . subscription_expiry AS subscription_expiry_42 , t0 . email_reminder AS email_reminder_43 , t0 . email_new AS email_new_44 , t0 . sms_new AS sms_new_45 , t0 . sms_reminder AS sms_reminder_46 , t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 , t0 . calendar_start_day AS calendar_start_day_48 , t0 . calendar_end_day AS calendar_end_day_49 , t0 . appointment_default_time AS appointment_default_time_50 , t0 . appointment_slot_duration AS appointment_slot_duration_51 , t0 . appointment_default_view AS appointment_default_view_52 , t0 . private_mode_calendar AS private_mode_calendar_53 , t0 . clinic_representative AS clinic_representative_54 , t0 . data_protection_officer AS data_protection_officer_55 , t0 . company_registration_number AS company_registration_number_56 , t0 . email_to_withdraw AS email_to_withdraw_57 , t0 . period_stored_data AS period_stored_data_58 , t0 . survey_email_text AS survey_email_text_59 , t0 . post_apt_form_email_text AS post_apt_form_email_text_60 , t0 . export_in_progress AS export_in_progress_61 , t0 . vat_number AS vat_number_62 , t0 . enabled_vat AS enabled_vat_63 , t0 . patient_list_display_pair AS patient_list_display_pair_64 , t0 . stripe_refresh_token AS stripe_refresh_token_65 , t0 . stripe_publishable_key AS stripe_publishable_key_66 , t0 . stripe_account_id AS stripe_account_id_67 , t0 . shared_all_patients AS shared_all_patients_68 , t0 . currency AS currency_69 , t0 . patient_info_to_document_header AS patient_info_to_document_header_70 , t0 . t_and_c AS t_and_c_71 , t0 . declaration AS declaration_72 , t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 , t0 . traffic_light AS traffic_light_74 , t0 . booking_required_fields AS booking_required_fields_75 , t0 . double_booking AS double_booking_76 , t0 . required_confirmation AS required_confirmation_77 , t0 . fixed_discount_amount AS fixed_discount_amount_78 , t0 . required_questionnaires AS required_questionnaires_79 , t0 . patient_required_fields AS patient_required_fields_80 , t0 . prospect_required_fields AS prospect_required_fields_81 , t0 . enabled_postcode AS enabled_postcode_82 , t0 . enabled_chronoscan AS enabled_chronoscan_83 , t0 . postcode_api_key AS postcode_api_key_84 , t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 , t0 . payment_sense AS payment_sense_86 , t0 . xero_tenant_id AS xero_tenant_id_87 , t0 . reduce_stock AS reduce_stock_88 , t0 . patient_questionnaire AS patient_questionnaire_89 , t0 . xero_bank_account AS xero_bank_account_90 , t0 . is_new_clinic AS is_new_clinic_91 , t0 . marketing_expert AS marketing_expert_92 , t0 . clinic_survey_email_text AS clinic_survey_email_text_93 , t0 . trial_end_date AS trial_end_date_94 , t0 . shared_patient_date AS shared_patient_date_95 , t0 . feature_custom_website_amount AS feature_custom_website_amount_96 , t0 . feature_ad_amount AS feature_ad_amount_97 , t0 . feature_message_amount AS feature_message_amount_98 , t0 . feature_template_amount AS feature_template_amount_99 , t0 . is_template_user_only AS is_template_user_only_100 , t0 . new_user AS new_user_101 , t0 . template_subscription_end_date AS template_subscription_end_date_102 , t0 . onboarding_status AS onboarding_status_103 , t0 . address1 AS address1_104 , t0 . address2 AS address2_105 , t0 . town AS town_106 , t0 . state AS state_107 , t0 . country AS country_108 , t0 . postcode AS postcode_109 , t0 . created_at AS created_at_110 , t0 . updated_at AS updated_at_111 , t0 . logo_id AS logo_id_112 , t113 . id AS id_114 , t113 . s3key AS s3key_115 , t113 . name_file AS name_file_116 , t113 . url AS url_117 , t113 . type AS type_118 , t113 . created_at AS created_at_119 , t113 . updated_at AS updated_at_120 , t0 . background_id AS background_id_121 , t122 . id AS id_123 , t122 . s3key AS s3key_124 , t122 . name_file AS name_file_125 , t122 . url AS url_126 , t122 . type AS type_127 , t122 . created_at AS created_at_128 , t122 . updated_at AS updated_at_129 , t130 . id AS id_131 , t130 . creditor AS creditor_132 , t130 . mandate AS mandate_133 , t130 . customer AS customer_134 , t130 . customer_bank_account AS customer_bank_account_135 , t130 . created_at AS created_at_136 , t130 . updated_at AS updated_at_137 , t130 . clinic_id AS clinic_id_138 , t139 . id AS id_140 , t139 . sid AS sid_141 , t139 . token AS token_142 , t139 . number_from AS number_from_143 , t139 . clinic_id AS clinic_id_144 , t0 . organisation_id AS organisation_id_145 , t146 . id AS id_147 , t146 . enabled AS enabled_148 , t146 . time_required_for_booking AS time_required_for_booking_149 , t146 . time_required_for_cancellation AS time_required_for_cancellation_150 , t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 , t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 , t146 . type AS type_153 , t146 . hide_full_price AS hide_full_price_154 , t146 . terms AS terms_155 , t146 . clinic_id AS clinic_id_156 , t157 . id AS id_158 , t157 . server AS server_159 , t157 . file_location AS file_location_160 , t157 . username AS username_161 , t157 . password AS password_162 , t157 . email AS email_163 , t157 . clinic_id AS clinic_id_164 , t165 . id AS id_166 , t165 . theme AS theme_167 , t165 . max_embed_width AS max_embed_width_168 , t165 . primary_interface_colour AS primary_interface_colour_169 , t165 . secondary_interface_colour AS secondary_interface_colour_170 , t165 . primary_font_colour AS primary_font_colour_171 , t165 . secondary_font_colour AS secondary_font_colour_172 , t165 . background_colour AS background_colour_173 , t165 . widget_hash AS widget_hash_174 , t165 . created_at AS created_at_175 , t165 . updated_at AS updated_at_176 , t165 . clinic_id AS clinic_id_177 , t165 . custom_css_id AS custom_css_id_178 , t179 . id AS id_180 , t179 . confirmation_text AS confirmation_text_181 , t179 . treatment_info AS treatment_info_182 , t179 . clinic_id AS clinic_id_183 , t184 . id AS id_185 , t184 . api_key AS api_key_186 , t184 . list_id AS list_id_187 , t184 . sync AS sync_188 , t184 . sync_date AS sync_date_189 , t184 . pro AS pro_190 , t184 . created_at AS created_at_191 , t184 . updated_at AS updated_at_192 , t184 . clinic_id AS clinic_id_193 , t0 . promo_code_id AS promo_code_id_194 , t0 . price_tier_id AS price_tier_id_195 , t0 . xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0 . logo_id = t113 . id LEFT JOIN media t122 ON t0 . background_id = t122 . id LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id WHERE t0 . id = ? LIMIT 1
SELECT
t0 . id AS id_1 ,
t0 . name AS name_2 ,
t0 . sub_domain AS sub_domain_3 ,
t0 . organisation_id AS organisation_id_4 ,
t0 . smscredit AS smscredit_5 ,
t0 . ai_token_credit AS ai_token_credit_6 ,
t0 . last_daily_token_date AS last_daily_token_date_7 ,
t0 . ai_seconds_credit AS ai_seconds_credit_8 ,
t0 . daily_ai_token_credit AS daily_ai_token_credit_9 ,
t0 . booking_btn_name AS booking_btn_name_10 ,
t0 . booking_btn_clr AS booking_btn_clr_11 ,
t0 . booking_btn_bg_clr AS booking_btn_bg_clr_12 ,
t0 . inner_color AS inner_color_13 ,
t0 . outer_color AS outer_color_14 ,
t0 . background_img AS background_img_15 ,
t0 . profile_img AS profile_img_16 ,
t0 . meeting_price AS meeting_price_17 ,
t0 . meeting_price_type AS meeting_price_type_18 ,
t0 . show_in_public_profile AS show_in_public_profile_19 ,
t0 . patient_ref_prefix AS patient_ref_prefix_20 ,
t0 . email AS email_21 ,
t0 . verified_email AS verified_email_22 ,
t0 . web_site AS web_site_23 ,
t0 . phone AS phone_24 ,
t0 . contact_name AS contact_name_25 ,
t0 . description AS description_26 ,
t0 . widget_settings AS widget_settings_27 ,
t0 . sms_number AS sms_number_28 ,
t0 . sms_status AS sms_status_29 ,
t0 . timezone AS timezone_30 ,
t0 . reminder_header AS reminder_header_31 ,
t0 . reminder_footer AS reminder_footer_32 ,
t0 . reminder_recall_text AS reminder_recall_text_33 ,
t0 . google_token AS google_token_34 ,
t0 . google_id AS google_id_35 ,
t0 . topic_arn AS topic_arn_36 ,
t0 . pm_pin AS pm_pin_37 ,
t0 . auto_email_reply_address AS auto_email_reply_address_38 ,
t0 . pm_patient_message AS pm_patient_message_39 ,
t0 . pm_clinic_intro AS pm_clinic_intro_40 ,
t0 . auto_renew_subscription AS auto_renew_subscription_41 ,
t0 . subscription_expiry AS subscription_expiry_42 ,
t0 . email_reminder AS email_reminder_43 ,
t0 . email_new AS email_new_44 ,
t0 . sms_new AS sms_new_45 ,
t0 . sms_reminder AS sms_reminder_46 ,
t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 ,
t0 . calendar_start_day AS calendar_start_day_48 ,
t0 . calendar_end_day AS calendar_end_day_49 ,
t0 . appointment_default_time AS appointment_default_time_50 ,
t0 . appointment_slot_duration AS appointment_slot_duration_51 ,
t0 . appointment_default_view AS appointment_default_view_52 ,
t0 . private_mode_calendar AS private_mode_calendar_53 ,
t0 . clinic_representative AS clinic_representative_54 ,
t0 . data_protection_officer AS data_protection_officer_55 ,
t0 . company_registration_number AS company_registration_number_56 ,
t0 . email_to_withdraw AS email_to_withdraw_57 ,
t0 . period_stored_data AS period_stored_data_58 ,
t0 . survey_email_text AS survey_email_text_59 ,
t0 . post_apt_form_email_text AS post_apt_form_email_text_60 ,
t0 . export_in_progress AS export_in_progress_61 ,
t0 . vat_number AS vat_number_62 ,
t0 . enabled_vat AS enabled_vat_63 ,
t0 . patient_list_display_pair AS patient_list_display_pair_64 ,
t0 . stripe_refresh_token AS stripe_refresh_token_65 ,
t0 . stripe_publishable_key AS stripe_publishable_key_66 ,
t0 . stripe_account_id AS stripe_account_id_67 ,
t0 . shared_all_patients AS shared_all_patients_68 ,
t0 . currency AS currency_69 ,
t0 . patient_info_to_document_header AS patient_info_to_document_header_70 ,
t0 . t_and_c AS t_and_c_71 ,
t0 . declaration AS declaration_72 ,
t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 ,
t0 . traffic_light AS traffic_light_74 ,
t0 . booking_required_fields AS booking_required_fields_75 ,
t0 . double_booking AS double_booking_76 ,
t0 . required_confirmation AS required_confirmation_77 ,
t0 . fixed_discount_amount AS fixed_discount_amount_78 ,
t0 . required_questionnaires AS required_questionnaires_79 ,
t0 . patient_required_fields AS patient_required_fields_80 ,
t0 . prospect_required_fields AS prospect_required_fields_81 ,
t0 . enabled_postcode AS enabled_postcode_82 ,
t0 . enabled_chronoscan AS enabled_chronoscan_83 ,
t0 . postcode_api_key AS postcode_api_key_84 ,
t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 ,
t0 . payment_sense AS payment_sense_86 ,
t0 . xero_tenant_id AS xero_tenant_id_87 ,
t0 . reduce_stock AS reduce_stock_88 ,
t0 . patient_questionnaire AS patient_questionnaire_89 ,
t0 . xero_bank_account AS xero_bank_account_90 ,
t0 . is_new_clinic AS is_new_clinic_91 ,
t0 . marketing_expert AS marketing_expert_92 ,
t0 . clinic_survey_email_text AS clinic_survey_email_text_93 ,
t0 . trial_end_date AS trial_end_date_94 ,
t0 . shared_patient_date AS shared_patient_date_95 ,
t0 . feature_custom_website_amount AS feature_custom_website_amount_96 ,
t0 . feature_ad_amount AS feature_ad_amount_97 ,
t0 . feature_message_amount AS feature_message_amount_98 ,
t0 . feature_template_amount AS feature_template_amount_99 ,
t0 . is_template_user_only AS is_template_user_only_100 ,
t0 . new_user AS new_user_101 ,
t0 . template_subscription_end_date AS template_subscription_end_date_102 ,
t0 . onboarding_status AS onboarding_status_103 ,
t0 . address1 AS address1_104 ,
t0 . address2 AS address2_105 ,
t0 . town AS town_106 ,
t0 . state AS state_107 ,
t0 . country AS country_108 ,
t0 . postcode AS postcode_109 ,
t0 . created_at AS created_at_110 ,
t0 . updated_at AS updated_at_111 ,
t0 . logo_id AS logo_id_112 ,
t113 . id AS id_114 ,
t113 . s3key AS s3key_115 ,
t113 . name_file AS name_file_116 ,
t113 . url AS url_117 ,
t113 . type AS type_118 ,
t113 . created_at AS created_at_119 ,
t113 . updated_at AS updated_at_120 ,
t0 . background_id AS background_id_121 ,
t122 . id AS id_123 ,
t122 . s3key AS s3key_124 ,
t122 . name_file AS name_file_125 ,
t122 . url AS url_126 ,
t122 . type AS type_127 ,
t122 . created_at AS created_at_128 ,
t122 . updated_at AS updated_at_129 ,
t130 . id AS id_131 ,
t130 . creditor AS creditor_132 ,
t130 . mandate AS mandate_133 ,
t130 . customer AS customer_134 ,
t130 . customer_bank_account AS customer_bank_account_135 ,
t130 . created_at AS created_at_136 ,
t130 . updated_at AS updated_at_137 ,
t130 . clinic_id AS clinic_id_138 ,
t139 . id AS id_140 ,
t139 . sid AS sid_141 ,
t139 . token AS token_142 ,
t139 . number_from AS number_from_143 ,
t139 . clinic_id AS clinic_id_144 ,
t0 . organisation_id AS organisation_id_145 ,
t146 . id AS id_147 ,
t146 . enabled AS enabled_148 ,
t146 . time_required_for_booking AS time_required_for_booking_149 ,
t146 . time_required_for_cancellation AS time_required_for_cancellation_150 ,
t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 ,
t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 ,
t146 . type AS type_153 ,
t146 . hide_full_price AS hide_full_price_154 ,
t146 . terms AS terms_155 ,
t146 . clinic_id AS clinic_id_156 ,
t157 . id AS id_158 ,
t157 . server AS server_159 ,
t157 . file_location AS file_location_160 ,
t157 . username AS username_161 ,
t157 . password AS password_162 ,
t157 . email AS email_163 ,
t157 . clinic_id AS clinic_id_164 ,
t165 . id AS id_166 ,
t165 . theme AS theme_167 ,
t165 . max_embed_width AS max_embed_width_168 ,
t165 . primary_interface_colour AS primary_interface_colour_169 ,
t165 . secondary_interface_colour AS secondary_interface_colour_170 ,
t165 . primary_font_colour AS primary_font_colour_171 ,
t165 . secondary_font_colour AS secondary_font_colour_172 ,
t165 . background_colour AS background_colour_173 ,
t165 . widget_hash AS widget_hash_174 ,
t165 . created_at AS created_at_175 ,
t165 . updated_at AS updated_at_176 ,
t165 . clinic_id AS clinic_id_177 ,
t165 . custom_css_id AS custom_css_id_178 ,
t179 . id AS id_180 ,
t179 . confirmation_text AS confirmation_text_181 ,
t179 . treatment_info AS treatment_info_182 ,
t179 . clinic_id AS clinic_id_183 ,
t184 . id AS id_185 ,
t184 . api_key AS api_key_186 ,
t184 . list_id AS list_id_187 ,
t184 . sync AS sync_188 ,
t184 . sync_date AS sync_date_189 ,
t184 . pro AS pro_190 ,
t184 . created_at AS created_at_191 ,
t184 . updated_at AS updated_at_192 ,
t184 . clinic_id AS clinic_id_193 ,
t0 . promo_code_id AS promo_code_id_194 ,
t0 . price_tier_id AS price_tier_id_195 ,
t0 . xero_sync_job_id AS xero_sync_job_id_196
FROM
clinics t0
LEFT JOIN media t113 ON t0 . logo_id = t113 . id
LEFT JOIN media t122 ON t0 . background_id = t122 . id
LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id
LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id
LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id
LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id
LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id
LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id
LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id
WHERE
t0 . id = ?
LIMIT
1 Copy
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sub_domain AS sub_domain_3 , t0 . organisation_id AS organisation_id_4 , t0 . smscredit AS smscredit_5 , t0 . ai_token_credit AS ai_token_credit_6 , t0 . last_daily_token_date AS last_daily_token_date_7 , t0 . ai_seconds_credit AS ai_seconds_credit_8 , t0 . daily_ai_token_credit AS daily_ai_token_credit_9 , t0 . booking_btn_name AS booking_btn_name_10 , t0 . booking_btn_clr AS booking_btn_clr_11 , t0 . booking_btn_bg_clr AS booking_btn_bg_clr_12 , t0 . inner_color AS inner_color_13 , t0 . outer_color AS outer_color_14 , t0 . background_img AS background_img_15 , t0 . profile_img AS profile_img_16 , t0 . meeting_price AS meeting_price_17 , t0 . meeting_price_type AS meeting_price_type_18 , t0 . show_in_public_profile AS show_in_public_profile_19 , t0 . patient_ref_prefix AS patient_ref_prefix_20 , t0 . email AS email_21 , t0 . verified_email AS verified_email_22 , t0 . web_site AS web_site_23 , t0 . phone AS phone_24 , t0 . contact_name AS contact_name_25 , t0 . description AS description_26 , t0 . widget_settings AS widget_settings_27 , t0 . sms_number AS sms_number_28 , t0 . sms_status AS sms_status_29 , t0 . timezone AS timezone_30 , t0 . reminder_header AS reminder_header_31 , t0 . reminder_footer AS reminder_footer_32 , t0 . reminder_recall_text AS reminder_recall_text_33 , t0 . google_token AS google_token_34 , t0 . google_id AS google_id_35 , t0 . topic_arn AS topic_arn_36 , t0 . pm_pin AS pm_pin_37 , t0 . auto_email_reply_address AS auto_email_reply_address_38 , t0 . pm_patient_message AS pm_patient_message_39 , t0 . pm_clinic_intro AS pm_clinic_intro_40 , t0 . auto_renew_subscription AS auto_renew_subscription_41 , t0 . subscription_expiry AS subscription_expiry_42 , t0 . email_reminder AS email_reminder_43 , t0 . email_new AS email_new_44 , t0 . sms_new AS sms_new_45 , t0 . sms_reminder AS sms_reminder_46 , t0 . when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_47 , t0 . calendar_start_day AS calendar_start_day_48 , t0 . calendar_end_day AS calendar_end_day_49 , t0 . appointment_default_time AS appointment_default_time_50 , t0 . appointment_slot_duration AS appointment_slot_duration_51 , t0 . appointment_default_view AS appointment_default_view_52 , t0 . private_mode_calendar AS private_mode_calendar_53 , t0 . clinic_representative AS clinic_representative_54 , t0 . data_protection_officer AS data_protection_officer_55 , t0 . company_registration_number AS company_registration_number_56 , t0 . email_to_withdraw AS email_to_withdraw_57 , t0 . period_stored_data AS period_stored_data_58 , t0 . survey_email_text AS survey_email_text_59 , t0 . post_apt_form_email_text AS post_apt_form_email_text_60 , t0 . export_in_progress AS export_in_progress_61 , t0 . vat_number AS vat_number_62 , t0 . enabled_vat AS enabled_vat_63 , t0 . patient_list_display_pair AS patient_list_display_pair_64 , t0 . stripe_refresh_token AS stripe_refresh_token_65 , t0 . stripe_publishable_key AS stripe_publishable_key_66 , t0 . stripe_account_id AS stripe_account_id_67 , t0 . shared_all_patients AS shared_all_patients_68 , t0 . currency AS currency_69 , t0 . patient_info_to_document_header AS patient_info_to_document_header_70 , t0 . t_and_c AS t_and_c_71 , t0 . declaration AS declaration_72 , t0 . treatment_plan_tand_c AS treatment_plan_tand_c_73 , t0 . traffic_light AS traffic_light_74 , t0 . booking_required_fields AS booking_required_fields_75 , t0 . double_booking AS double_booking_76 , t0 . required_confirmation AS required_confirmation_77 , t0 . fixed_discount_amount AS fixed_discount_amount_78 , t0 . required_questionnaires AS required_questionnaires_79 , t0 . patient_required_fields AS patient_required_fields_80 , t0 . prospect_required_fields AS prospect_required_fields_81 , t0 . enabled_postcode AS enabled_postcode_82 , t0 . enabled_chronoscan AS enabled_chronoscan_83 , t0 . postcode_api_key AS postcode_api_key_84 , t0 . enabled_prospect_web_form AS enabled_prospect_web_form_85 , t0 . payment_sense AS payment_sense_86 , t0 . xero_tenant_id AS xero_tenant_id_87 , t0 . reduce_stock AS reduce_stock_88 , t0 . patient_questionnaire AS patient_questionnaire_89 , t0 . xero_bank_account AS xero_bank_account_90 , t0 . is_new_clinic AS is_new_clinic_91 , t0 . marketing_expert AS marketing_expert_92 , t0 . clinic_survey_email_text AS clinic_survey_email_text_93 , t0 . trial_end_date AS trial_end_date_94 , t0 . shared_patient_date AS shared_patient_date_95 , t0 . feature_custom_website_amount AS feature_custom_website_amount_96 , t0 . feature_ad_amount AS feature_ad_amount_97 , t0 . feature_message_amount AS feature_message_amount_98 , t0 . feature_template_amount AS feature_template_amount_99 , t0 . is_template_user_only AS is_template_user_only_100 , t0 . new_user AS new_user_101 , t0 . template_subscription_end_date AS template_subscription_end_date_102 , t0 . onboarding_status AS onboarding_status_103 , t0 . address1 AS address1_104 , t0 . address2 AS address2_105 , t0 . town AS town_106 , t0 . state AS state_107 , t0 . country AS country_108 , t0 . postcode AS postcode_109 , t0 . created_at AS created_at_110 , t0 . updated_at AS updated_at_111 , t0 . logo_id AS logo_id_112 , t113 . id AS id_114 , t113 . s3key AS s3key_115 , t113 . name_file AS name_file_116 , t113 . url AS url_117 , t113 . type AS type_118 , t113 . created_at AS created_at_119 , t113 . updated_at AS updated_at_120 , t0 . background_id AS background_id_121 , t122 . id AS id_123 , t122 . s3key AS s3key_124 , t122 . name_file AS name_file_125 , t122 . url AS url_126 , t122 . type AS type_127 , t122 . created_at AS created_at_128 , t122 . updated_at AS updated_at_129 , t130 . id AS id_131 , t130 . creditor AS creditor_132 , t130 . mandate AS mandate_133 , t130 . customer AS customer_134 , t130 . customer_bank_account AS customer_bank_account_135 , t130 . created_at AS created_at_136 , t130 . updated_at AS updated_at_137 , t130 . clinic_id AS clinic_id_138 , t139 . id AS id_140 , t139 . sid AS sid_141 , t139 . token AS token_142 , t139 . number_from AS number_from_143 , t139 . clinic_id AS clinic_id_144 , t0 . organisation_id AS organisation_id_145 , t146 . id AS id_147 , t146 . enabled AS enabled_148 , t146 . time_required_for_booking AS time_required_for_booking_149 , t146 . time_required_for_cancellation AS time_required_for_cancellation_150 , t146 . take_payment_for_new_patients AS take_payment_for_new_patients_151 , t146 . take_payment_for_existing_patients AS take_payment_for_existing_patients_152 , t146 . type AS type_153 , t146 . hide_full_price AS hide_full_price_154 , t146 . terms AS terms_155 , t146 . clinic_id AS clinic_id_156 , t157 . id AS id_158 , t157 . server AS server_159 , t157 . file_location AS file_location_160 , t157 . username AS username_161 , t157 . password AS password_162 , t157 . email AS email_163 , t157 . clinic_id AS clinic_id_164 , t165 . id AS id_166 , t165 . theme AS theme_167 , t165 . max_embed_width AS max_embed_width_168 , t165 . primary_interface_colour AS primary_interface_colour_169 , t165 . secondary_interface_colour AS secondary_interface_colour_170 , t165 . primary_font_colour AS primary_font_colour_171 , t165 . secondary_font_colour AS secondary_font_colour_172 , t165 . background_colour AS background_colour_173 , t165 . widget_hash AS widget_hash_174 , t165 . created_at AS created_at_175 , t165 . updated_at AS updated_at_176 , t165 . clinic_id AS clinic_id_177 , t165 . custom_css_id AS custom_css_id_178 , t179 . id AS id_180 , t179 . confirmation_text AS confirmation_text_181 , t179 . treatment_info AS treatment_info_182 , t179 . clinic_id AS clinic_id_183 , t184 . id AS id_185 , t184 . api_key AS api_key_186 , t184 . list_id AS list_id_187 , t184 . sync AS sync_188 , t184 . sync_date AS sync_date_189 , t184 . pro AS pro_190 , t184 . created_at AS created_at_191 , t184 . updated_at AS updated_at_192 , t184 . clinic_id AS clinic_id_193 , t0 . promo_code_id AS promo_code_id_194 , t0 . price_tier_id AS price_tier_id_195 , t0 . xero_sync_job_id AS xero_sync_job_id_196 FROM clinics t0 LEFT JOIN media t113 ON t0 . logo_id = t113 . id LEFT JOIN media t122 ON t0 . background_id = t122 . id LEFT JOIN gocardless_customer t130 ON t130 . clinic_id = t0 . id LEFT JOIN twilio t139 ON t139 . clinic_id = t0 . id LEFT JOIN setting_online_booking t146 ON t146 . clinic_id = t0 . id LEFT JOIN setting_chronoscan t157 ON t157 . clinic_id = t0 . id LEFT JOIN widget_online_booking t165 ON t165 . clinic_id = t0 . id LEFT JOIN email_setting_online_booking t179 ON t179 . clinic_id = t0 . id LEFT JOIN mail_chimp_config t184 ON t184 . clinic_id = t0 . id WHERE t0 . id = '3' LIMIT 1 ; Copy
0.54 ms
2
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sale_price AS sale_price_3 , t0 . deposit AS deposit_4 , t0 . purchase_price AS purchase_price_5 , t0 . retail_product AS retail_product_6 , t0 . availability_online AS availability_online_7 , t0 . description AS description_8 , t0 . gift_voucher AS gift_voucher_9 , t0 . is_org AS is_org_10 , t0 . org_number AS org_number_11 , t0 . deleted_at AS deleted_at_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . clinic_id AS clinic_id_15 , t0 . treatment_id AS treatment_id_16 , t0 . created_by_id AS created_by_id_17 , t0 . updated_by_id AS updated_by_id_18 , t0 . deleted_by_id AS deleted_by_id_19 FROM price_list t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . sale_price AS sale_price_3 , t0 . deposit AS deposit_4 , t0 . purchase_price AS purchase_price_5 , t0 . retail_product AS retail_product_6 , t0 . availability_online AS availability_online_7 , t0 . description AS description_8 , t0 . gift_voucher AS gift_voucher_9 , t0 . is_org AS is_org_10 , t0 . org_number AS org_number_11 , t0 . deleted_at AS deleted_at_12 , t0 . created_at AS created_at_13 , t0 . updated_at AS updated_at_14 , t0 . clinic_id AS clinic_id_15 , t0 . treatment_id AS treatment_id_16 , t0 . created_by_id AS created_by_id_17 , t0 . updated_by_id AS updated_by_id_18 , t0 . deleted_by_id AS deleted_by_id_19 FROM price_list t0 WHERE t0 . id = 699 ; Copy
0.52 ms
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . status AS status_50 , t0 . birthday AS birthday_51 , t0 . country_code_alt AS country_code_alt_52 , t0 . secondary_phone AS secondary_phone_53 , t0 . next_kin AS next_kin_54 , t0 . next_kin_phone AS next_kin_phone_55 , t0 . description AS description_56 , t0 . glogau_scale AS glogau_scale_57 , t0 . fitzpatrick_scale AS fitzpatrick_scale_58 , t0 . gender AS gender_59 , t0 . receive_special_offer_push AS receive_special_offer_push_60 , t0 . receive_reminder_email AS receive_reminder_email_61 , t0 . receive_reminder_sms AS receive_reminder_sms_62 , t0 . receive_reminder_push AS receive_reminder_push_63 , t0 . parent_user_id AS parent_user_id_64 , t0 . account_type AS account_type_65 , t0 . terms_accepted AS terms_accepted_66 , t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_67 , t0 . referral AS referral_68 , t0 . export_in_progress AS export_in_progress_69 , t0 . occupation AS occupation_70 , t0 . number_nhs AS number_nhs_71 , t0 . gp_name AS gp_name_72 , t0 . contact_gp AS contact_gp_73 , t0 . gp_address1 AS gp_address1_74 , t0 . gp_address2 AS gp_address2_75 , t0 . gp_town AS gp_town_76 , t0 . gp_county AS gp_county_77 , t0 . gp_post_code AS gp_post_code_78 , t0 . gp_country AS gp_country_79 , t0 . ref AS ref_80 , t0 . chronoscan_code AS chronoscan_code_81 , t0 . ethnicity AS ethnicity_82 , t0 . height AS height_83 , t0 . weight AS weight_84 , t0 . passport AS passport_85 , t0 . reference_number AS reference_number_86 , t0 . photo_consent AS photo_consent_87 , t0 . all_marketing AS all_marketing_88 , t0 . in_clinic_marketing AS in_clinic_marketing_89 , t0 . in_consultation AS in_consultation_90 , t0 . interested_in AS interested_in_91 , t0 . consultation_type AS consultation_type_92 , t0 . google_click_id AS google_click_id_93 , t0 . campaign_name AS campaign_name_94 , t0 . campaign_source AS campaign_source_95 , t0 . campaign_medium AS campaign_medium_96 , t0 . campaign_term AS campaign_term_97 , t0 . campaign_content AS campaign_content_98 , t0 . marketing_source AS marketing_source_99 , t0 . author AS author_100 , t0 . address1 AS address1_101 , t0 . address2 AS address2_102 , t0 . town AS town_103 , t0 . state AS state_104 , t0 . country AS country_105 , t0 . postcode AS postcode_106 , t0 . media_id AS media_id_107 , t0 . device_id AS device_id_108 , t0 . created_by_id AS created_by_id_109 , t0 . parent_id AS parent_id_110 , t0 . active_photo_id AS active_photo_id_111 , t0 . bar_code_image_id AS bar_code_image_id_112 , t0 . clinic_id AS clinic_id_113 , t0 . prospect_id AS prospect_id_114 , t115 . email AS email_116 , t115 . id AS id_117 , t115 . first_name AS first_name_118 , t115 . last_name AS last_name_119 , t115 . gender AS gender_120 , t115 . country_code AS country_code_121 , t115 . phone AS phone_122 , t115 . full_phone_number AS full_phone_number_123 , t115 . info AS info_124 , t115 . notes AS notes_125 , t115 . archive AS archive_126 , t115 . convert_to_patient AS convert_to_patient_127 , t115 . date_convert AS date_convert_128 , t115 . due_date AS due_date_129 , t115 . interested_in AS interested_in_130 , t115 . birthday AS birthday_131 , t115 . consultation_type AS consultation_type_132 , t115 . google_click_id AS google_click_id_133 , t115 . campaign_name AS campaign_name_134 , t115 . campaign_source AS campaign_source_135 , t115 . campaign_medium AS campaign_medium_136 , t115 . campaign_term AS campaign_term_137 , t115 . campaign_content AS campaign_content_138 , t115 . marketing_source AS marketing_source_139 , t115 . author AS author_140 , t115 . address1 AS address1_141 , t115 . address2 AS address2_142 , t115 . town AS town_143 , t115 . state AS state_144 , t115 . country AS country_145 , t115 . postcode AS postcode_146 , t115 . created_at AS created_at_147 , t115 . updated_at AS updated_at_148 , t115 . user_id AS user_id_149 , t115 . alan_chat_id AS alan_chat_id_150 , t115 . clinic_id AS clinic_id_151 , t115 . not_convert_reason_id AS not_convert_reason_id_152 , t115 . stage_id AS stage_id_153 , t115 . clinic_user_id AS clinic_user_id_154 , t115 . media_id AS media_id_155 , t0 . type FROM user t0 LEFT JOIN lead_capture t115 ON t0 . prospect_id = t115 . id WHERE t0 . id = ? AND t0 . type IN ('patient' )
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 . is_disengaged AS is_disengaged_19 ,
t0 . otp AS otp_20 ,
t0 . otp_sent_at AS otp_sent_at_21 ,
t0 . last_otp_verified AS last_otp_verified_22 ,
t0 . imap_setting AS imap_setting_23 ,
t0 . country_code AS country_code_24 ,
t0 . phone AS phone_25 ,
t0 . practitioner_commission AS practitioner_commission_26 ,
t0 . coordinator_commission AS coordinator_commission_27 ,
t0 . course_commission AS course_commission_28 ,
t0 . membership_commission AS membership_commission_29 ,
t0 . product_commission AS product_commission_30 ,
t0 . token AS token_31 ,
t0 . access_all_calendars AS access_all_calendars_32 ,
t0 . current_auth_token AS current_auth_token_33 ,
t0 . last_auth_time AS last_auth_time_34 ,
t0 . hash AS hash_35 ,
t0 . fcm_token AS fcm_token_36 ,
t0 . hx_change_token AS hx_change_token_37 ,
t0 . login_from AS login_from_38 ,
t0 . ever_login_in_v3 AS ever_login_in_v3_39 ,
t0 . permissions AS permissions_40 ,
t0 . clinic_id AS clinic_id_41 ,
t0 . fp_promoter_id AS fp_promoter_id_42 ,
t0 . referral_link AS referral_link_43 ,
t0 . fp_tracking_id AS fp_tracking_id_44 ,
t0 . receive_special_offer_email AS receive_special_offer_email_45 ,
t0 . receive_special_offer_sms AS receive_special_offer_sms_46 ,
t0 . deleted_at AS deleted_at_47 ,
t0 . created_at AS created_at_48 ,
t0 . updated_at AS updated_at_49 ,
t0 . status AS status_50 ,
t0 . birthday AS birthday_51 ,
t0 . country_code_alt AS country_code_alt_52 ,
t0 . secondary_phone AS secondary_phone_53 ,
t0 . next_kin AS next_kin_54 ,
t0 . next_kin_phone AS next_kin_phone_55 ,
t0 . description AS description_56 ,
t0 . glogau_scale AS glogau_scale_57 ,
t0 . fitzpatrick_scale AS fitzpatrick_scale_58 ,
t0 . gender AS gender_59 ,
t0 . receive_special_offer_push AS receive_special_offer_push_60 ,
t0 . receive_reminder_email AS receive_reminder_email_61 ,
t0 . receive_reminder_sms AS receive_reminder_sms_62 ,
t0 . receive_reminder_push AS receive_reminder_push_63 ,
t0 . parent_user_id AS parent_user_id_64 ,
t0 . account_type AS account_type_65 ,
t0 . terms_accepted AS terms_accepted_66 ,
t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_67 ,
t0 . referral AS referral_68 ,
t0 . export_in_progress AS export_in_progress_69 ,
t0 . occupation AS occupation_70 ,
t0 . number_nhs AS number_nhs_71 ,
t0 . gp_name AS gp_name_72 ,
t0 . contact_gp AS contact_gp_73 ,
t0 . gp_address1 AS gp_address1_74 ,
t0 . gp_address2 AS gp_address2_75 ,
t0 . gp_town AS gp_town_76 ,
t0 . gp_county AS gp_county_77 ,
t0 . gp_post_code AS gp_post_code_78 ,
t0 . gp_country AS gp_country_79 ,
t0 . ref AS ref_80 ,
t0 . chronoscan_code AS chronoscan_code_81 ,
t0 . ethnicity AS ethnicity_82 ,
t0 . height AS height_83 ,
t0 . weight AS weight_84 ,
t0 . passport AS passport_85 ,
t0 . reference_number AS reference_number_86 ,
t0 . photo_consent AS photo_consent_87 ,
t0 . all_marketing AS all_marketing_88 ,
t0 . in_clinic_marketing AS in_clinic_marketing_89 ,
t0 . in_consultation AS in_consultation_90 ,
t0 . interested_in AS interested_in_91 ,
t0 . consultation_type AS consultation_type_92 ,
t0 . google_click_id AS google_click_id_93 ,
t0 . campaign_name AS campaign_name_94 ,
t0 . campaign_source AS campaign_source_95 ,
t0 . campaign_medium AS campaign_medium_96 ,
t0 . campaign_term AS campaign_term_97 ,
t0 . campaign_content AS campaign_content_98 ,
t0 . marketing_source AS marketing_source_99 ,
t0 . author AS author_100 ,
t0 . address1 AS address1_101 ,
t0 . address2 AS address2_102 ,
t0 . town AS town_103 ,
t0 . state AS state_104 ,
t0 . country AS country_105 ,
t0 . postcode AS postcode_106 ,
t0 . media_id AS media_id_107 ,
t0 . device_id AS device_id_108 ,
t0 . created_by_id AS created_by_id_109 ,
t0 . parent_id AS parent_id_110 ,
t0 . active_photo_id AS active_photo_id_111 ,
t0 . bar_code_image_id AS bar_code_image_id_112 ,
t0 . clinic_id AS clinic_id_113 ,
t0 . prospect_id AS prospect_id_114 ,
t115 . email AS email_116 ,
t115 . id AS id_117 ,
t115 . first_name AS first_name_118 ,
t115 . last_name AS last_name_119 ,
t115 . gender AS gender_120 ,
t115 . country_code AS country_code_121 ,
t115 . phone AS phone_122 ,
t115 . full_phone_number AS full_phone_number_123 ,
t115 . info AS info_124 ,
t115 . notes AS notes_125 ,
t115 . archive AS archive_126 ,
t115 . convert_to_patient AS convert_to_patient_127 ,
t115 . date_convert AS date_convert_128 ,
t115 . due_date AS due_date_129 ,
t115 . interested_in AS interested_in_130 ,
t115 . birthday AS birthday_131 ,
t115 . consultation_type AS consultation_type_132 ,
t115 . google_click_id AS google_click_id_133 ,
t115 . campaign_name AS campaign_name_134 ,
t115 . campaign_source AS campaign_source_135 ,
t115 . campaign_medium AS campaign_medium_136 ,
t115 . campaign_term AS campaign_term_137 ,
t115 . campaign_content AS campaign_content_138 ,
t115 . marketing_source AS marketing_source_139 ,
t115 . author AS author_140 ,
t115 . address1 AS address1_141 ,
t115 . address2 AS address2_142 ,
t115 . town AS town_143 ,
t115 . state AS state_144 ,
t115 . country AS country_145 ,
t115 . postcode AS postcode_146 ,
t115 . created_at AS created_at_147 ,
t115 . updated_at AS updated_at_148 ,
t115 . user_id AS user_id_149 ,
t115 . alan_chat_id AS alan_chat_id_150 ,
t115 . clinic_id AS clinic_id_151 ,
t115 . not_convert_reason_id AS not_convert_reason_id_152 ,
t115 . stage_id AS stage_id_153 ,
t115 . clinic_user_id AS clinic_user_id_154 ,
t115 . media_id AS media_id_155 ,
t0 . type
FROM
user t0
LEFT JOIN lead_capture t115 ON t0 . prospect_id = t115 . id
WHERE
t0 . id = ?
AND t0 . type IN ('patient' )Copy
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . status AS status_50 , t0 . birthday AS birthday_51 , t0 . country_code_alt AS country_code_alt_52 , t0 . secondary_phone AS secondary_phone_53 , t0 . next_kin AS next_kin_54 , t0 . next_kin_phone AS next_kin_phone_55 , t0 . description AS description_56 , t0 . glogau_scale AS glogau_scale_57 , t0 . fitzpatrick_scale AS fitzpatrick_scale_58 , t0 . gender AS gender_59 , t0 . receive_special_offer_push AS receive_special_offer_push_60 , t0 . receive_reminder_email AS receive_reminder_email_61 , t0 . receive_reminder_sms AS receive_reminder_sms_62 , t0 . receive_reminder_push AS receive_reminder_push_63 , t0 . parent_user_id AS parent_user_id_64 , t0 . account_type AS account_type_65 , t0 . terms_accepted AS terms_accepted_66 , t0 . terms_accepted_patient_mode AS terms_accepted_patient_mode_67 , t0 . referral AS referral_68 , t0 . export_in_progress AS export_in_progress_69 , t0 . occupation AS occupation_70 , t0 . number_nhs AS number_nhs_71 , t0 . gp_name AS gp_name_72 , t0 . contact_gp AS contact_gp_73 , t0 . gp_address1 AS gp_address1_74 , t0 . gp_address2 AS gp_address2_75 , t0 . gp_town AS gp_town_76 , t0 . gp_county AS gp_county_77 , t0 . gp_post_code AS gp_post_code_78 , t0 . gp_country AS gp_country_79 , t0 . ref AS ref_80 , t0 . chronoscan_code AS chronoscan_code_81 , t0 . ethnicity AS ethnicity_82 , t0 . height AS height_83 , t0 . weight AS weight_84 , t0 . passport AS passport_85 , t0 . reference_number AS reference_number_86 , t0 . photo_consent AS photo_consent_87 , t0 . all_marketing AS all_marketing_88 , t0 . in_clinic_marketing AS in_clinic_marketing_89 , t0 . in_consultation AS in_consultation_90 , t0 . interested_in AS interested_in_91 , t0 . consultation_type AS consultation_type_92 , t0 . google_click_id AS google_click_id_93 , t0 . campaign_name AS campaign_name_94 , t0 . campaign_source AS campaign_source_95 , t0 . campaign_medium AS campaign_medium_96 , t0 . campaign_term AS campaign_term_97 , t0 . campaign_content AS campaign_content_98 , t0 . marketing_source AS marketing_source_99 , t0 . author AS author_100 , t0 . address1 AS address1_101 , t0 . address2 AS address2_102 , t0 . town AS town_103 , t0 . state AS state_104 , t0 . country AS country_105 , t0 . postcode AS postcode_106 , t0 . media_id AS media_id_107 , t0 . device_id AS device_id_108 , t0 . created_by_id AS created_by_id_109 , t0 . parent_id AS parent_id_110 , t0 . active_photo_id AS active_photo_id_111 , t0 . bar_code_image_id AS bar_code_image_id_112 , t0 . clinic_id AS clinic_id_113 , t0 . prospect_id AS prospect_id_114 , t115 . email AS email_116 , t115 . id AS id_117 , t115 . first_name AS first_name_118 , t115 . last_name AS last_name_119 , t115 . gender AS gender_120 , t115 . country_code AS country_code_121 , t115 . phone AS phone_122 , t115 . full_phone_number AS full_phone_number_123 , t115 . info AS info_124 , t115 . notes AS notes_125 , t115 . archive AS archive_126 , t115 . convert_to_patient AS convert_to_patient_127 , t115 . date_convert AS date_convert_128 , t115 . due_date AS due_date_129 , t115 . interested_in AS interested_in_130 , t115 . birthday AS birthday_131 , t115 . consultation_type AS consultation_type_132 , t115 . google_click_id AS google_click_id_133 , t115 . campaign_name AS campaign_name_134 , t115 . campaign_source AS campaign_source_135 , t115 . campaign_medium AS campaign_medium_136 , t115 . campaign_term AS campaign_term_137 , t115 . campaign_content AS campaign_content_138 , t115 . marketing_source AS marketing_source_139 , t115 . author AS author_140 , t115 . address1 AS address1_141 , t115 . address2 AS address2_142 , t115 . town AS town_143 , t115 . state AS state_144 , t115 . country AS country_145 , t115 . postcode AS postcode_146 , t115 . created_at AS created_at_147 , t115 . updated_at AS updated_at_148 , t115 . user_id AS user_id_149 , t115 . alan_chat_id AS alan_chat_id_150 , t115 . clinic_id AS clinic_id_151 , t115 . not_convert_reason_id AS not_convert_reason_id_152 , t115 . stage_id AS stage_id_153 , t115 . clinic_user_id AS clinic_user_id_154 , t115 . media_id AS media_id_155 , t0 . type FROM user t0 LEFT JOIN lead_capture t115 ON t0 . prospect_id = t115 . id WHERE t0 . id = 146133 AND t0 . type IN ('patient' ); Copy
0.50 ms
1
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . payment_type_api AS payment_type_api_8 , t0 . payment_amount_api AS payment_amount_api_9 , t0 . status AS status_10 , t0 . unpaid AS unpaid_11 , t0 . private_note AS private_note_12 , t0 . invoice_note AS invoice_note_13 , t0 . xero_invoice_id AS xero_invoice_id_14 , t0 . send_nps_survey AS send_nps_survey_15 , t0 . saved_vat_number AS saved_vat_number_16 , t0 . saved_vat_company_name AS saved_vat_company_name_17 , t0 . patient_id AS patient_id_18 , t0 . clinic_id AS clinic_id_19 , t0 . practitioner_id AS practitioner_id_20 , t0 . user_id AS user_id_21 , t0 . pdf_media_id AS pdf_media_id_22 , t23 . id AS id_24 , t23 . s3key AS s3key_25 , t23 . name_file AS name_file_26 , t23 . url AS url_27 , t23 . type AS type_28 , t23 . created_at AS created_at_29 , t23 . updated_at AS updated_at_30 , t0 . consultation_practitioner_id AS consultation_practitioner_id_31 , t32 . id AS id_33 , t32 . code AS code_34 , t32 . amount AS amount_35 , t32 . remaining_amount AS remaining_amount_36 , t32 . created_at AS created_at_37 , t32 . updated_at AS updated_at_38 , t32 . owner_id AS owner_id_39 , t32 . owner_invoice_id AS owner_invoice_id_40 , t32 . clinic_id AS clinic_id_41 , t32 . created_by_id AS created_by_id_42 , t32 . updated_by_id AS updated_by_id_43 , t32 . deleted_by_id AS deleted_by_id_44 , t0 . consultation_note_id AS consultation_note_id_45 , t46 . id AS id_47 , t46 . active AS active_48 , t46 . stripe_recurring_id AS stripe_recurring_id_49 , t46 . membershipcount AS membershipcount_50 , t46 . rcount AS rcount_51 , t46 . created_at AS created_at_52 , t46 . updated_at AS updated_at_53 , t46 . invoice_id AS invoice_id_54 , t46 . clinic_user_id AS clinic_user_id_55 , t46 . patient_id AS patient_id_56 , t46 . clinic_id AS clinic_id_57 , t46 . membership_id AS membership_id_58 , t0 . clinic_vat_registration_id AS clinic_vat_registration_id_59 , t0 . created_by_id AS created_by_id_60 , t0 . updated_by_id AS updated_by_id_61 , t0 . deleted_by_id AS deleted_by_id_62 , t0 . type FROM invoice t0 LEFT JOIN media t23 ON t0 . pdf_media_id = t23 . id LEFT JOIN generated_patient_voucher t32 ON t32 . owner_invoice_id = t0 . id LEFT JOIN used_membership t46 ON t46 . invoice_id = t0 . id WHERE t0 . id = ? AND t0 . type IN ('invoice' )
SELECT
t0 . id AS id_1 ,
t0 . prev_balance AS prev_balance_2 ,
t0 . archive AS archive_3 ,
t0 . ref AS ref_4 ,
t0 . charge_id AS charge_id_5 ,
t0 . created_at AS created_at_6 ,
t0 . updated_at AS updated_at_7 ,
t0 . payment_type_api AS payment_type_api_8 ,
t0 . payment_amount_api AS payment_amount_api_9 ,
t0 . status AS status_10 ,
t0 . unpaid AS unpaid_11 ,
t0 . private_note AS private_note_12 ,
t0 . invoice_note AS invoice_note_13 ,
t0 . xero_invoice_id AS xero_invoice_id_14 ,
t0 . send_nps_survey AS send_nps_survey_15 ,
t0 . saved_vat_number AS saved_vat_number_16 ,
t0 . saved_vat_company_name AS saved_vat_company_name_17 ,
t0 . patient_id AS patient_id_18 ,
t0 . clinic_id AS clinic_id_19 ,
t0 . practitioner_id AS practitioner_id_20 ,
t0 . user_id AS user_id_21 ,
t0 . pdf_media_id AS pdf_media_id_22 ,
t23 . id AS id_24 ,
t23 . s3key AS s3key_25 ,
t23 . name_file AS name_file_26 ,
t23 . url AS url_27 ,
t23 . type AS type_28 ,
t23 . created_at AS created_at_29 ,
t23 . updated_at AS updated_at_30 ,
t0 . consultation_practitioner_id AS consultation_practitioner_id_31 ,
t32 . id AS id_33 ,
t32 . code AS code_34 ,
t32 . amount AS amount_35 ,
t32 . remaining_amount AS remaining_amount_36 ,
t32 . created_at AS created_at_37 ,
t32 . updated_at AS updated_at_38 ,
t32 . owner_id AS owner_id_39 ,
t32 . owner_invoice_id AS owner_invoice_id_40 ,
t32 . clinic_id AS clinic_id_41 ,
t32 . created_by_id AS created_by_id_42 ,
t32 . updated_by_id AS updated_by_id_43 ,
t32 . deleted_by_id AS deleted_by_id_44 ,
t0 . consultation_note_id AS consultation_note_id_45 ,
t46 . id AS id_47 ,
t46 . active AS active_48 ,
t46 . stripe_recurring_id AS stripe_recurring_id_49 ,
t46 . membershipcount AS membershipcount_50 ,
t46 . rcount AS rcount_51 ,
t46 . created_at AS created_at_52 ,
t46 . updated_at AS updated_at_53 ,
t46 . invoice_id AS invoice_id_54 ,
t46 . clinic_user_id AS clinic_user_id_55 ,
t46 . patient_id AS patient_id_56 ,
t46 . clinic_id AS clinic_id_57 ,
t46 . membership_id AS membership_id_58 ,
t0 . clinic_vat_registration_id AS clinic_vat_registration_id_59 ,
t0 . created_by_id AS created_by_id_60 ,
t0 . updated_by_id AS updated_by_id_61 ,
t0 . deleted_by_id AS deleted_by_id_62 ,
t0 . type
FROM
invoice t0
LEFT JOIN media t23 ON t0 . pdf_media_id = t23 . id
LEFT JOIN generated_patient_voucher t32 ON t32 . owner_invoice_id = t0 . id
LEFT JOIN used_membership t46 ON t46 . invoice_id = t0 . id
WHERE
t0 . id = ?
AND t0 . type IN ('invoice' )Copy
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . payment_type_api AS payment_type_api_8 , t0 . payment_amount_api AS payment_amount_api_9 , t0 . status AS status_10 , t0 . unpaid AS unpaid_11 , t0 . private_note AS private_note_12 , t0 . invoice_note AS invoice_note_13 , t0 . xero_invoice_id AS xero_invoice_id_14 , t0 . send_nps_survey AS send_nps_survey_15 , t0 . saved_vat_number AS saved_vat_number_16 , t0 . saved_vat_company_name AS saved_vat_company_name_17 , t0 . patient_id AS patient_id_18 , t0 . clinic_id AS clinic_id_19 , t0 . practitioner_id AS practitioner_id_20 , t0 . user_id AS user_id_21 , t0 . pdf_media_id AS pdf_media_id_22 , t23 . id AS id_24 , t23 . s3key AS s3key_25 , t23 . name_file AS name_file_26 , t23 . url AS url_27 , t23 . type AS type_28 , t23 . created_at AS created_at_29 , t23 . updated_at AS updated_at_30 , t0 . consultation_practitioner_id AS consultation_practitioner_id_31 , t32 . id AS id_33 , t32 . code AS code_34 , t32 . amount AS amount_35 , t32 . remaining_amount AS remaining_amount_36 , t32 . created_at AS created_at_37 , t32 . updated_at AS updated_at_38 , t32 . owner_id AS owner_id_39 , t32 . owner_invoice_id AS owner_invoice_id_40 , t32 . clinic_id AS clinic_id_41 , t32 . created_by_id AS created_by_id_42 , t32 . updated_by_id AS updated_by_id_43 , t32 . deleted_by_id AS deleted_by_id_44 , t0 . consultation_note_id AS consultation_note_id_45 , t46 . id AS id_47 , t46 . active AS active_48 , t46 . stripe_recurring_id AS stripe_recurring_id_49 , t46 . membershipcount AS membershipcount_50 , t46 . rcount AS rcount_51 , t46 . created_at AS created_at_52 , t46 . updated_at AS updated_at_53 , t46 . invoice_id AS invoice_id_54 , t46 . clinic_user_id AS clinic_user_id_55 , t46 . patient_id AS patient_id_56 , t46 . clinic_id AS clinic_id_57 , t46 . membership_id AS membership_id_58 , t0 . clinic_vat_registration_id AS clinic_vat_registration_id_59 , t0 . created_by_id AS created_by_id_60 , t0 . updated_by_id AS updated_by_id_61 , t0 . deleted_by_id AS deleted_by_id_62 , t0 . type FROM invoice t0 LEFT JOIN media t23 ON t0 . pdf_media_id = t23 . id LEFT JOIN generated_patient_voucher t32 ON t32 . owner_invoice_id = t0 . id LEFT JOIN used_membership t46 ON t46 . invoice_id = t0 . id WHERE t0 . id = '3246' AND t0 . type IN ('invoice' ); Copy
0.41 ms
1
SELECT t0 . id AS id_1 , t0 . s3key AS s3key_2 , t0 . name_file AS name_file_3 , t0 . url AS url_4 , t0 . type AS type_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 FROM media t0 WHERE t0 . id IN (? )
SELECT t0 . id AS id_1 , t0 . s3key AS s3key_2 , t0 . name_file AS name_file_3 , t0 . url AS url_4 , t0 . type AS type_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 FROM media t0 WHERE t0 . id IN (109932 ); Copy
0.41 ms
1
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . sale_price AS sale_price_3 , t0 . discount AS discount_4 , t0 . total AS total_5 , t0 . saved_vat_rate AS saved_vat_rate_6 , t0 . saved_vat_name AS saved_vat_name_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . invoice_id AS invoice_id_10 , t0 . price_list_id AS price_list_id_11 , t0 . vat_id AS vat_id_12 , t0 . discount_reason_id AS discount_reason_id_13 , t0 . type , t0 . notes AS notes_14 , t0 . prepay AS prepay_15 , t0 . auth_code AS auth_code_16 , t0 . kind_id AS kind_id_17 , t0 . prepayment_id AS prepayment_id_18 , t0 . prepay_treatment_item_id AS prepay_treatment_item_id_19 , t0 . terminal_id AS terminal_id_20 FROM invoice_item t0 WHERE t0 . invoice_id = ? AND t0 . type IN ('item' , 'refund' )
SELECT t0 . id AS id_1 , t0 . quantity AS quantity_2 , t0 . sale_price AS sale_price_3 , t0 . discount AS discount_4 , t0 . total AS total_5 , t0 . saved_vat_rate AS saved_vat_rate_6 , t0 . saved_vat_name AS saved_vat_name_7 , t0 . created_at AS created_at_8 , t0 . updated_at AS updated_at_9 , t0 . invoice_id AS invoice_id_10 , t0 . price_list_id AS price_list_id_11 , t0 . vat_id AS vat_id_12 , t0 . discount_reason_id AS discount_reason_id_13 , t0 . type , t0 . notes AS notes_14 , t0 . prepay AS prepay_15 , t0 . auth_code AS auth_code_16 , t0 . kind_id AS kind_id_17 , t0 . prepayment_id AS prepayment_id_18 , t0 . prepay_treatment_item_id AS prepay_treatment_item_id_19 , t0 . terminal_id AS terminal_id_20 FROM invoice_item t0 WHERE t0 . invoice_id = 3246 AND t0 . type IN ('item' , 'refund' ); Copy
0.27 ms
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . qualification AS qualification_50 , t0 . summary AS summary_51 , t0 . deleted AS deleted_52 , t0 . calendar_color AS calendar_color_53 , t0 . calendar_order_number AS calendar_order_number_54 , t0 . calendar_id AS calendar_id_55 , t0 . position AS position_56 , t0 . online_booking_availability AS online_booking_availability_57 , t0 . title AS title_58 , t0 . email_verify AS email_verify_59 , t0 . hash_user_short_url AS hash_user_short_url_60 , t0 . licence_number AS licence_number_61 , t0 . stripe_customer_id AS stripe_customer_id_62 , t0 . is_online AS is_online_63 , t0 . last_call_time AS last_call_time_64 , t0 . hide_report_menus AS hide_report_menus_65 , t0 . media_id AS media_id_66 , t0 . device_id AS device_id_67 , t0 . created_by_id AS created_by_id_68 , t0 . clinic_id AS clinic_id_69 , t0 . i_calendar_id AS i_calendar_id_70 , t0 . type , t0 . organisation_id AS organisation_id_71 , t0 . current_clinic_id AS current_clinic_id_72 FROM user t0 WHERE t0 . id = ? AND t0 . type IN ('clinic_user' , 'super_clinic_admin' )
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 . is_disengaged AS is_disengaged_19 ,
t0 . otp AS otp_20 ,
t0 . otp_sent_at AS otp_sent_at_21 ,
t0 . last_otp_verified AS last_otp_verified_22 ,
t0 . imap_setting AS imap_setting_23 ,
t0 . country_code AS country_code_24 ,
t0 . phone AS phone_25 ,
t0 . practitioner_commission AS practitioner_commission_26 ,
t0 . coordinator_commission AS coordinator_commission_27 ,
t0 . course_commission AS course_commission_28 ,
t0 . membership_commission AS membership_commission_29 ,
t0 . product_commission AS product_commission_30 ,
t0 . token AS token_31 ,
t0 . access_all_calendars AS access_all_calendars_32 ,
t0 . current_auth_token AS current_auth_token_33 ,
t0 . last_auth_time AS last_auth_time_34 ,
t0 . hash AS hash_35 ,
t0 . fcm_token AS fcm_token_36 ,
t0 . hx_change_token AS hx_change_token_37 ,
t0 . login_from AS login_from_38 ,
t0 . ever_login_in_v3 AS ever_login_in_v3_39 ,
t0 . permissions AS permissions_40 ,
t0 . clinic_id AS clinic_id_41 ,
t0 . fp_promoter_id AS fp_promoter_id_42 ,
t0 . referral_link AS referral_link_43 ,
t0 . fp_tracking_id AS fp_tracking_id_44 ,
t0 . receive_special_offer_email AS receive_special_offer_email_45 ,
t0 . receive_special_offer_sms AS receive_special_offer_sms_46 ,
t0 . deleted_at AS deleted_at_47 ,
t0 . created_at AS created_at_48 ,
t0 . updated_at AS updated_at_49 ,
t0 . qualification AS qualification_50 ,
t0 . summary AS summary_51 ,
t0 . deleted AS deleted_52 ,
t0 . calendar_color AS calendar_color_53 ,
t0 . calendar_order_number AS calendar_order_number_54 ,
t0 . calendar_id AS calendar_id_55 ,
t0 . position AS position_56 ,
t0 . online_booking_availability AS online_booking_availability_57 ,
t0 . title AS title_58 ,
t0 . email_verify AS email_verify_59 ,
t0 . hash_user_short_url AS hash_user_short_url_60 ,
t0 . licence_number AS licence_number_61 ,
t0 . stripe_customer_id AS stripe_customer_id_62 ,
t0 . is_online AS is_online_63 ,
t0 . last_call_time AS last_call_time_64 ,
t0 . hide_report_menus AS hide_report_menus_65 ,
t0 . media_id AS media_id_66 ,
t0 . device_id AS device_id_67 ,
t0 . created_by_id AS created_by_id_68 ,
t0 . clinic_id AS clinic_id_69 ,
t0 . i_calendar_id AS i_calendar_id_70 ,
t0 . type ,
t0 . organisation_id AS organisation_id_71 ,
t0 . current_clinic_id AS current_clinic_id_72
FROM
user t0
WHERE
t0 . id = ?
AND t0 . type IN (
'clinic_user' , 'super_clinic_admin'
)Copy
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 . is_disengaged AS is_disengaged_19 , t0 . otp AS otp_20 , t0 . otp_sent_at AS otp_sent_at_21 , t0 . last_otp_verified AS last_otp_verified_22 , t0 . imap_setting AS imap_setting_23 , t0 . country_code AS country_code_24 , t0 . phone AS phone_25 , t0 . practitioner_commission AS practitioner_commission_26 , t0 . coordinator_commission AS coordinator_commission_27 , t0 . course_commission AS course_commission_28 , t0 . membership_commission AS membership_commission_29 , t0 . product_commission AS product_commission_30 , t0 . token AS token_31 , t0 . access_all_calendars AS access_all_calendars_32 , t0 . current_auth_token AS current_auth_token_33 , t0 . last_auth_time AS last_auth_time_34 , t0 . hash AS hash_35 , t0 . fcm_token AS fcm_token_36 , t0 . hx_change_token AS hx_change_token_37 , t0 . login_from AS login_from_38 , t0 . ever_login_in_v3 AS ever_login_in_v3_39 , t0 . permissions AS permissions_40 , t0 . clinic_id AS clinic_id_41 , t0 . fp_promoter_id AS fp_promoter_id_42 , t0 . referral_link AS referral_link_43 , t0 . fp_tracking_id AS fp_tracking_id_44 , t0 . receive_special_offer_email AS receive_special_offer_email_45 , t0 . receive_special_offer_sms AS receive_special_offer_sms_46 , t0 . deleted_at AS deleted_at_47 , t0 . created_at AS created_at_48 , t0 . updated_at AS updated_at_49 , t0 . qualification AS qualification_50 , t0 . summary AS summary_51 , t0 . deleted AS deleted_52 , t0 . calendar_color AS calendar_color_53 , t0 . calendar_order_number AS calendar_order_number_54 , t0 . calendar_id AS calendar_id_55 , t0 . position AS position_56 , t0 . online_booking_availability AS online_booking_availability_57 , t0 . title AS title_58 , t0 . email_verify AS email_verify_59 , t0 . hash_user_short_url AS hash_user_short_url_60 , t0 . licence_number AS licence_number_61 , t0 . stripe_customer_id AS stripe_customer_id_62 , t0 . is_online AS is_online_63 , t0 . last_call_time AS last_call_time_64 , t0 . hide_report_menus AS hide_report_menus_65 , t0 . media_id AS media_id_66 , t0 . device_id AS device_id_67 , t0 . created_by_id AS created_by_id_68 , t0 . clinic_id AS clinic_id_69 , t0 . i_calendar_id AS i_calendar_id_70 , t0 . type , t0 . organisation_id AS organisation_id_71 , t0 . current_clinic_id AS current_clinic_id_72 FROM user t0 WHERE t0 . id = 146541 AND t0 . type IN ('clinic_user' , 'super_clinic_admin' ); Copy
0.25 ms
1
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . amount AS amount_8 , t0 . remaining_amount_generate_voucher AS remaining_amount_generate_voucher_9 , t0 . patient_id AS patient_id_10 , t0 . clinic_id AS clinic_id_11 , t0 . practitioner_id AS practitioner_id_12 , t0 . invoice_id AS invoice_id_13 , t0 . generate_voucher_id AS generate_voucher_id_14 , t0 . created_by_id AS created_by_id_15 , t0 . updated_by_id AS updated_by_id_16 , t0 . deleted_by_id AS deleted_by_id_17 , t0 . type FROM invoice t0 WHERE t0 . invoice_id = ? AND t0 . type IN ('voucher' )
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . amount AS amount_8 , t0 . remaining_amount_generate_voucher AS remaining_amount_generate_voucher_9 , t0 . patient_id AS patient_id_10 , t0 . clinic_id AS clinic_id_11 , t0 . practitioner_id AS practitioner_id_12 , t0 . invoice_id AS invoice_id_13 , t0 . generate_voucher_id AS generate_voucher_id_14 , t0 . created_by_id AS created_by_id_15 , t0 . updated_by_id AS updated_by_id_16 , t0 . deleted_by_id AS deleted_by_id_17 , t0 . type FROM invoice t0 WHERE t0 . invoice_id = 3246 AND t0 . type IN ('voucher' ); Copy
0.22 ms
1
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . amount AS amount_8 , t0 . description AS description_9 , t0 . patient_id AS patient_id_10 , t0 . clinic_id AS clinic_id_11 , t0 . practitioner_id AS practitioner_id_12 , t0 . invoice_id AS invoice_id_13 , t0 . created_by_id AS created_by_id_14 , t0 . updated_by_id AS updated_by_id_15 , t0 . deleted_by_id AS deleted_by_id_16 , t0 . type FROM invoice t0 WHERE t0 . invoice_id = ? AND t0 . type IN ('creditNote' )
SELECT t0 . id AS id_1 , t0 . prev_balance AS prev_balance_2 , t0 . archive AS archive_3 , t0 . ref AS ref_4 , t0 . charge_id AS charge_id_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . amount AS amount_8 , t0 . description AS description_9 , t0 . patient_id AS patient_id_10 , t0 . clinic_id AS clinic_id_11 , t0 . practitioner_id AS practitioner_id_12 , t0 . invoice_id AS invoice_id_13 , t0 . created_by_id AS created_by_id_14 , t0 . updated_by_id AS updated_by_id_15 , t0 . deleted_by_id AS deleted_by_id_16 , t0 . type FROM invoice t0 WHERE t0 . invoice_id = 3246 AND t0 . type IN ('creditNote' ); Copy
0.21 ms
1
SELECT t0 . id AS id_1 , t0 . prepay AS prepay_2 , t0 . amount AS amount_3 , t0 . amount_refunded AS amount_refunded_4 , t0 . notes AS notes_5 , t0 . auth_code AS auth_code_6 , t0 . payment_sense_id AS payment_sense_id_7 , t0 . is_refunded AS is_refunded_8 , t0 . xero_payment_id AS xero_payment_id_9 , t0 . primary_account_number AS primary_account_number_10 , t0 . payment_intent_id AS payment_intent_id_11 , t0 . stripe_inv_id AS stripe_inv_id_12 , t0 . transaction_id AS transaction_id_13 , t0 . xref AS xref_14 , t0 . handpoint_response AS handpoint_response_15 , t0 . created_at AS created_at_16 , t0 . updated_at AS updated_at_17 , t0 . type_id AS type_id_18 , t0 . invoice_id AS invoice_id_19 , t0 . prepayment_id AS prepayment_id_20 , t0 . prepay_treatment_item_id AS prepay_treatment_item_id_21 , t0 . terminal_id AS terminal_id_22 FROM payment t0 WHERE t0 . invoice_id = ?
SELECT t0 . id AS id_1 , t0 . prepay AS prepay_2 , t0 . amount AS amount_3 , t0 . amount_refunded AS amount_refunded_4 , t0 . notes AS notes_5 , t0 . auth_code AS auth_code_6 , t0 . payment_sense_id AS payment_sense_id_7 , t0 . is_refunded AS is_refunded_8 , t0 . xero_payment_id AS xero_payment_id_9 , t0 . primary_account_number AS primary_account_number_10 , t0 . payment_intent_id AS payment_intent_id_11 , t0 . stripe_inv_id AS stripe_inv_id_12 , t0 . transaction_id AS transaction_id_13 , t0 . xref AS xref_14 , t0 . handpoint_response AS handpoint_response_15 , t0 . created_at AS created_at_16 , t0 . updated_at AS updated_at_17 , t0 . type_id AS type_id_18 , t0 . invoice_id AS invoice_id_19 , t0 . prepayment_id AS prepayment_id_20 , t0 . prepay_treatment_item_id AS prepay_treatment_item_id_21 , t0 . terminal_id AS terminal_id_22 FROM payment t0 WHERE t0 . invoice_id = 3246 ; Copy