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.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.patient_ref_prefix = ?
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.patient_ref_prefix = 'CXW' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.sms_providers AS sms_providers_2,
  t0.twilio_rate AS twilio_rate_3,
  t0.twilio_settings AS twilio_settings_4,
  t0.plivo_settings AS plivo_settings_5,
  t0.currency_rate AS currency_rate_6,
  t0.feature_custom_website_amount AS feature_custom_website_amount_7,
  t0.feature_ad_amount AS feature_ad_amount_8,
  t0.feature_message_amount AS feature_message_amount_9,
  t0.feature_template_amount AS feature_template_amount_10,
  t0.template_us_stripe_price_id AS template_us_stripe_price_id_11,
  t0.template_gbp_stripe_price_id AS template_gbp_stripe_price_id_12,
  t0.ai_api_key AS ai_api_key_13,
  t0.system_prompt AS system_prompt_14,
  t0.ai_modal AS ai_modal_15,
  t0.ai_modal_temperature AS ai_modal_temperature_16,
  t0.ai_top_p AS ai_top_p_17,
  t0.ai_max_tokens AS ai_max_tokens_18,
  t0.daily_ai_token_credit AS daily_ai_token_credit_19,
  t0.referral_levels AS referral_levels_20,
  t0.firstpromoter_api_key AS firstpromoter_api_key_21,
  t0.firstpromoter_account_id AS firstpromoter_account_id_22,
  t0.firstpromoter_campaign_id AS firstpromoter_campaign_id_23
FROM
  admin_setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.sms_providers AS sms_providers_2, t0.twilio_rate AS twilio_rate_3, t0.twilio_settings AS twilio_settings_4, t0.plivo_settings AS plivo_settings_5, t0.currency_rate AS currency_rate_6, t0.feature_custom_website_amount AS feature_custom_website_amount_7, t0.feature_ad_amount AS feature_ad_amount_8, t0.feature_message_amount AS feature_message_amount_9, t0.feature_template_amount AS feature_template_amount_10, t0.template_us_stripe_price_id AS template_us_stripe_price_id_11, t0.template_gbp_stripe_price_id AS template_gbp_stripe_price_id_12, t0.ai_api_key AS ai_api_key_13, t0.system_prompt AS system_prompt_14, t0.ai_modal AS ai_modal_15, t0.ai_modal_temperature AS ai_modal_temperature_16, t0.ai_top_p AS ai_top_p_17, t0.ai_max_tokens AS ai_max_tokens_18, t0.daily_ai_token_credit AS daily_ai_token_credit_19, t0.referral_levels AS referral_levels_20, t0.firstpromoter_api_key AS firstpromoter_api_key_21, t0.firstpromoter_account_id AS firstpromoter_account_id_22, t0.firstpromoter_campaign_id AS firstpromoter_campaign_id_23 FROM admin_setting t0 WHERE t0.id = 1;