Symfony Profiler

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.is_demo_clinic AS is_demo_clinic_103,
  t0.demo_signup_email AS demo_signup_email_104,
  t0.onboarding_status AS onboarding_status_105,
  t0.address1 AS address1_106,
  t0.address2 AS address2_107,
  t0.town AS town_108,
  t0.state AS state_109,
  t0.country AS country_110,
  t0.postcode AS postcode_111,
  t0.created_at AS created_at_112,
  t0.updated_at AS updated_at_113,
  t0.logo_id AS logo_id_114,
  t115.id AS id_116,
  t115.s3key AS s3key_117,
  t115.name_file AS name_file_118,
  t115.url AS url_119,
  t115.type AS type_120,
  t115.created_at AS created_at_121,
  t115.updated_at AS updated_at_122,
  t0.background_id AS background_id_123,
  t124.id AS id_125,
  t124.s3key AS s3key_126,
  t124.name_file AS name_file_127,
  t124.url AS url_128,
  t124.type AS type_129,
  t124.created_at AS created_at_130,
  t124.updated_at AS updated_at_131,
  t132.id AS id_133,
  t132.creditor AS creditor_134,
  t132.mandate AS mandate_135,
  t132.customer AS customer_136,
  t132.customer_bank_account AS customer_bank_account_137,
  t132.created_at AS created_at_138,
  t132.updated_at AS updated_at_139,
  t132.clinic_id AS clinic_id_140,
  t141.id AS id_142,
  t141.sid AS sid_143,
  t141.token AS token_144,
  t141.number_from AS number_from_145,
  t141.clinic_id AS clinic_id_146,
  t0.organisation_id AS organisation_id_147,
  t148.id AS id_149,
  t148.enabled AS enabled_150,
  t148.time_required_for_booking AS time_required_for_booking_151,
  t148.time_required_for_cancellation AS time_required_for_cancellation_152,
  t148.take_payment_for_new_patients AS take_payment_for_new_patients_153,
  t148.take_payment_for_existing_patients AS take_payment_for_existing_patients_154,
  t148.type AS type_155,
  t148.hide_full_price AS hide_full_price_156,
  t148.terms AS terms_157,
  t148.clinic_id AS clinic_id_158,
  t159.id AS id_160,
  t159.server AS server_161,
  t159.file_location AS file_location_162,
  t159.username AS username_163,
  t159.password AS password_164,
  t159.email AS email_165,
  t159.clinic_id AS clinic_id_166,
  t167.id AS id_168,
  t167.theme AS theme_169,
  t167.max_embed_width AS max_embed_width_170,
  t167.primary_interface_colour AS primary_interface_colour_171,
  t167.secondary_interface_colour AS secondary_interface_colour_172,
  t167.primary_font_colour AS primary_font_colour_173,
  t167.secondary_font_colour AS secondary_font_colour_174,
  t167.background_colour AS background_colour_175,
  t167.widget_hash AS widget_hash_176,
  t167.created_at AS created_at_177,
  t167.updated_at AS updated_at_178,
  t167.clinic_id AS clinic_id_179,
  t167.custom_css_id AS custom_css_id_180,
  t181.id AS id_182,
  t181.confirmation_text AS confirmation_text_183,
  t181.treatment_info AS treatment_info_184,
  t181.clinic_id AS clinic_id_185,
  t186.id AS id_187,
  t186.api_key AS api_key_188,
  t186.list_id AS list_id_189,
  t186.sync AS sync_190,
  t186.sync_date AS sync_date_191,
  t186.pro AS pro_192,
  t186.created_at AS created_at_193,
  t186.updated_at AS updated_at_194,
  t186.clinic_id AS clinic_id_195,
  t0.promo_code_id AS promo_code_id_196,
  t0.price_tier_id AS price_tier_id_197,
  t0.xero_sync_job_id AS xero_sync_job_id_198
FROM
  clinics t0
  LEFT JOIN media t115 ON t0.logo_id = t115.id
  LEFT JOIN media t124 ON t0.background_id = t124.id
  LEFT JOIN gocardless_customer t132 ON t132.clinic_id = t0.id
  LEFT JOIN twilio t141 ON t141.clinic_id = t0.id
  LEFT JOIN setting_online_booking t148 ON t148.clinic_id = t0.id
  LEFT JOIN setting_chronoscan t159 ON t159.clinic_id = t0.id
  LEFT JOIN widget_online_booking t167 ON t167.clinic_id = t0.id
  LEFT JOIN email_setting_online_booking t181 ON t181.clinic_id = t0.id
  LEFT JOIN mail_chimp_config t186 ON t186.clinic_id = t0.id
WHERE
  t0.sub_domain = ?
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.is_demo_clinic AS is_demo_clinic_103, t0.demo_signup_email AS demo_signup_email_104, t0.onboarding_status AS onboarding_status_105, t0.address1 AS address1_106, t0.address2 AS address2_107, t0.town AS town_108, t0.state AS state_109, t0.country AS country_110, t0.postcode AS postcode_111, t0.created_at AS created_at_112, t0.updated_at AS updated_at_113, t0.logo_id AS logo_id_114, t115.id AS id_116, t115.s3key AS s3key_117, t115.name_file AS name_file_118, t115.url AS url_119, t115.type AS type_120, t115.created_at AS created_at_121, t115.updated_at AS updated_at_122, t0.background_id AS background_id_123, t124.id AS id_125, t124.s3key AS s3key_126, t124.name_file AS name_file_127, t124.url AS url_128, t124.type AS type_129, t124.created_at AS created_at_130, t124.updated_at AS updated_at_131, t132.id AS id_133, t132.creditor AS creditor_134, t132.mandate AS mandate_135, t132.customer AS customer_136, t132.customer_bank_account AS customer_bank_account_137, t132.created_at AS created_at_138, t132.updated_at AS updated_at_139, t132.clinic_id AS clinic_id_140, t141.id AS id_142, t141.sid AS sid_143, t141.token AS token_144, t141.number_from AS number_from_145, t141.clinic_id AS clinic_id_146, t0.organisation_id AS organisation_id_147, t148.id AS id_149, t148.enabled AS enabled_150, t148.time_required_for_booking AS time_required_for_booking_151, t148.time_required_for_cancellation AS time_required_for_cancellation_152, t148.take_payment_for_new_patients AS take_payment_for_new_patients_153, t148.take_payment_for_existing_patients AS take_payment_for_existing_patients_154, t148.type AS type_155, t148.hide_full_price AS hide_full_price_156, t148.terms AS terms_157, t148.clinic_id AS clinic_id_158, t159.id AS id_160, t159.server AS server_161, t159.file_location AS file_location_162, t159.username AS username_163, t159.password AS password_164, t159.email AS email_165, t159.clinic_id AS clinic_id_166, t167.id AS id_168, t167.theme AS theme_169, t167.max_embed_width AS max_embed_width_170, t167.primary_interface_colour AS primary_interface_colour_171, t167.secondary_interface_colour AS secondary_interface_colour_172, t167.primary_font_colour AS primary_font_colour_173, t167.secondary_font_colour AS secondary_font_colour_174, t167.background_colour AS background_colour_175, t167.widget_hash AS widget_hash_176, t167.created_at AS created_at_177, t167.updated_at AS updated_at_178, t167.clinic_id AS clinic_id_179, t167.custom_css_id AS custom_css_id_180, t181.id AS id_182, t181.confirmation_text AS confirmation_text_183, t181.treatment_info AS treatment_info_184, t181.clinic_id AS clinic_id_185, t186.id AS id_187, t186.api_key AS api_key_188, t186.list_id AS list_id_189, t186.sync AS sync_190, t186.sync_date AS sync_date_191, t186.pro AS pro_192, t186.created_at AS created_at_193, t186.updated_at AS updated_at_194, t186.clinic_id AS clinic_id_195, t0.promo_code_id AS promo_code_id_196, t0.price_tier_id AS price_tier_id_197, t0.xero_sync_job_id AS xero_sync_job_id_198 FROM clinics t0 LEFT JOIN media t115 ON t0.logo_id = t115.id LEFT JOIN media t124 ON t0.background_id = t124.id LEFT JOIN gocardless_customer t132 ON t132.clinic_id = t0.id LEFT JOIN twilio t141 ON t141.clinic_id = t0.id LEFT JOIN setting_online_booking t148 ON t148.clinic_id = t0.id LEFT JOIN setting_chronoscan t159 ON t159.clinic_id = t0.id LEFT JOIN widget_online_booking t167 ON t167.clinic_id = t0.id LEFT JOIN email_setting_online_booking t181 ON t181.clinic_id = t0.id LEFT JOIN mail_chimp_config t186 ON t186.clinic_id = t0.id WHERE t0.sub_domain = 'testclinic' LIMIT 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);

SELECT
  cutc.clinic_user_id,
  m.url as mediaurl,
  u.address1,
  u.town,
  u.state,
  u.country,
  u.postcode,
  u.qualification,
  u.username,
  u.first_name,
  u.last_name,
  GROUP_CONCAT(cr.name) AS room_names
FROM
  clinic_user_online_treatment_clinic AS cutc
  LEFT JOIN user AS u ON cutc.clinic_user_id = u.id
  LEFT JOIN rooms_treatments AS rt ON cutc.treatment_clinic_id = rt.treatment_clinic_id
  LEFT JOIN clinic_room AS cr ON rt.room_id = cr.id
  LEFT JOIN media AS m ON m.id = u.media_id
WHERE
  cutc.treatment_clinic_id = ?
  AND u.role = 'ROLE_PRACTITIONER'
  AND u.deleted = 0
  AND u.online_booking_availability = 1
  AND u.locked = 0
GROUP BY
  cutc.clinic_user_id,
  u.username,
  u.first_name,
  u.last_name

SELECT cutc.clinic_user_id,m.url as mediaurl, u.address1, u.town, u.state,u.country, u.postcode, 
                u.qualification, u.username, u.first_name, u.last_name, GROUP_CONCAT(cr.name) AS room_names
            FROM  clinic_user_online_treatment_clinic AS cutc
            LEFT JOIN user AS u ON cutc.clinic_user_id = u.id 
            LEFT JOIN rooms_treatments AS rt ON cutc.treatment_clinic_id = rt.treatment_clinic_id 
            LEFT JOIN clinic_room AS cr ON rt.room_id = cr.id 
            LEFT JOIN media AS m ON m.id = u.media_id
            WHERE cutc.treatment_clinic_id = '1837'
            AND u.role = 'ROLE_PRACTITIONER'
            AND u.deleted = 0
            AND u.online_booking_availability = 1
            AND u.locked = 0
            GROUP BY cutc.clinic_user_id, u.username, u.first_name, u.last_name
        ;

SELECT
  day,
  start_time,
  end_time,
  enabled,
  location_id
FROM
  daily_schedule
WHERE
  clinic_user_id = ?

SELECT day, start_time, end_time, enabled, location_id
                FROM daily_schedule
                WHERE clinic_user_id = 146811
            ;

SELECT
  start
FROM
  appointment
WHERE
  start >= ?
  AND
end <= ?
AND payment_status = '1'
AND clinic_user_id = ?

SELECT start FROM appointment
                WHERE start >= '2026-08-11 13:59:50' AND end <= '2026-09-04 13:59:50' AND payment_status = '1' AND clinic_user_id = 146811
            ;

SELECT
  al.start
FROM
  appointment_lead al
  JOIN event e ON e.id = al.event_id
WHERE
  al.start >= ?
  AND al.end <= ?
  AND e.clinic_user_id = ?

SELECT al.start FROM appointment_lead al
                JOIN event e ON e.id = al.event_id
                WHERE al.start >= '2026-08-11 14:59:50' AND al.end <= '2026-09-04 14:59:50' AND e.clinic_user_id = 146811
            ;

SELECT
  day,
  start_time,
  end_time,
  enabled,
  location_id
FROM
  daily_schedule
WHERE
  clinic_user_id = ?

SELECT day, start_time, end_time, enabled, location_id
                FROM daily_schedule
                WHERE clinic_user_id = 147343
            ;

SELECT
  start
FROM
  appointment
WHERE
  start >= ?
  AND
end <= ?
AND payment_status = '1'
AND clinic_user_id = ?

SELECT start FROM appointment
                WHERE start >= '2026-08-11 13:59:50' AND end <= '2026-09-04 13:59:50' AND payment_status = '1' AND clinic_user_id = 147343
            ;

SELECT
  al.start
FROM
  appointment_lead al
  JOIN event e ON e.id = al.event_id
WHERE
  al.start >= ?
  AND al.end <= ?
  AND e.clinic_user_id = ?

SELECT al.start FROM appointment_lead al
                JOIN event e ON e.id = al.event_id
                WHERE al.start >= '2026-08-11 14:59:50' AND al.end <= '2026-09-04 14:59:50' AND e.clinic_user_id = 147343
            ;

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 = 146811 AND t0.type IN ('clinic_user', 'super_clinic_admin');

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.start_time AS start_time_3,
  t0.end_time AS end_time_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.clinic_user_id AS clinic_user_id_8,
  t0.location_id AS location_id_9
FROM
  daily_schedule t0
WHERE
  t0.clinic_user_id = ?
  AND t0.day IN (?, ?)
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.clinic_user_id AS clinic_user_id_8, t0.location_id AS location_id_9 FROM daily_schedule t0 WHERE t0.clinic_user_id = 146811 AND t0.day IN ('Monday', 'Tuesday') AND t0.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.start_time AS start_time_3,
  t0.end_time AS end_time_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.clinic_user_id AS clinic_user_id_8,
  t0.location_id AS location_id_9
FROM
  daily_schedule t0
WHERE
  t0.clinic_user_id = ?
  AND t0.day IN (?, ?)
  AND t0.enabled = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.clinic_user_id AS clinic_user_id_8, t0.location_id AS location_id_9 FROM daily_schedule t0 WHERE t0.clinic_user_id = 146811 AND t0.day IN ('Tuesday', 'Wednesday') AND t0.enabled = 1;