Symfony Profiler

SELECT
  l0_.id AS id_0,
  l0_.point_login AS point_login_1,
  l0_.created_at AS created_at_2,
  l0_.updated_at AS updated_at_3,
  l0_.user_id AS user_id_4
FROM
  login_log l0_
WHERE
  l0_.user_id = ?
  AND l0_.point_login = ?
ORDER BY
  l0_.created_at DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.point_login AS point_login_1, l0_.created_at AS created_at_2, l0_.updated_at AS updated_at_3, l0_.user_id AS user_id_4 FROM login_log l0_ WHERE l0_.user_id = 3221 AND l0_.point_login = 'LOGIN_WEB' ORDER BY l0_.created_at DESC LIMIT 1;

UPDATE
  user
SET
  last_auth_time = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_auth_time = '2026-08-03 13:28:13', updated_at = '2026-08-03 13:28:13' WHERE id = 3221;

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.full_name AS full_name_5,
  u0_.password AS password_6,
  u0_.booking_btn_name AS booking_btn_name_7,
  u0_.booking_btn_clr AS booking_btn_clr_8,
  u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9,
  u0_.inner_color AS inner_color_10,
  u0_.outer_color AS outer_color_11,
  u0_.background_img AS background_img_12,
  u0_.profile_img AS profile_img_13,
  u0_.role AS role_14,
  u0_.enabled AS enabled_15,
  u0_.locked AS locked_16,
  u0_.visible AS visible_17,
  u0_.is_disengaged AS is_disengaged_18,
  u0_.otp AS otp_19,
  u0_.otp_sent_at AS otp_sent_at_20,
  u0_.last_otp_verified AS last_otp_verified_21,
  u0_.imap_setting AS imap_setting_22,
  u0_.country_code AS country_code_23,
  u0_.phone AS phone_24,
  u0_.practitioner_commission AS practitioner_commission_25,
  u0_.coordinator_commission AS coordinator_commission_26,
  u0_.course_commission AS course_commission_27,
  u0_.membership_commission AS membership_commission_28,
  u0_.product_commission AS product_commission_29,
  u0_.token AS token_30,
  u0_.access_all_calendars AS access_all_calendars_31,
  u0_.current_auth_token AS current_auth_token_32,
  u0_.last_auth_time AS last_auth_time_33,
  u0_.hash AS hash_34,
  u0_.fcm_token AS fcm_token_35,
  u0_.hx_change_token AS hx_change_token_36,
  u0_.login_from AS login_from_37,
  u0_.ever_login_in_v3 AS ever_login_in_v3_38,
  u0_.permissions AS permissions_39,
  u0_.clinic_id AS clinic_id_40,
  u0_.fp_promoter_id AS fp_promoter_id_41,
  u0_.referral_link AS referral_link_42,
  u0_.fp_tracking_id AS fp_tracking_id_43,
  u0_.receive_special_offer_email AS receive_special_offer_email_44,
  u0_.receive_special_offer_sms AS receive_special_offer_sms_45,
  u0_.deleted_at AS deleted_at_46,
  u0_.created_at AS created_at_47,
  u0_.updated_at AS updated_at_48,
  u0_.stripe_customer_id AS stripe_customer_id_49,
  u0_.stripe_customer_id AS stripe_customer_id_50,
  u0_.status AS status_51,
  u0_.birthday AS birthday_52,
  u0_.country_code_alt AS country_code_alt_53,
  u0_.secondary_phone AS secondary_phone_54,
  u0_.next_kin AS next_kin_55,
  u0_.next_kin_phone AS next_kin_phone_56,
  u0_.description AS description_57,
  u0_.glogau_scale AS glogau_scale_58,
  u0_.fitzpatrick_scale AS fitzpatrick_scale_59,
  u0_.gender AS gender_60,
  u0_.receive_special_offer_push AS receive_special_offer_push_61,
  u0_.receive_reminder_email AS receive_reminder_email_62,
  u0_.receive_reminder_sms AS receive_reminder_sms_63,
  u0_.receive_reminder_push AS receive_reminder_push_64,
  u0_.parent_user_id AS parent_user_id_65,
  u0_.account_type AS account_type_66,
  u0_.terms_accepted AS terms_accepted_67,
  u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68,
  u0_.referral AS referral_69,
  u0_.export_in_progress AS export_in_progress_70,
  u0_.occupation AS occupation_71,
  u0_.number_nhs AS number_nhs_72,
  u0_.gp_name AS gp_name_73,
  u0_.contact_gp AS contact_gp_74,
  u0_.gp_address1 AS gp_address1_75,
  u0_.gp_address2 AS gp_address2_76,
  u0_.gp_town AS gp_town_77,
  u0_.gp_county AS gp_county_78,
  u0_.gp_post_code AS gp_post_code_79,
  u0_.gp_country AS gp_country_80,
  u0_.ref AS ref_81,
  u0_.chronoscan_code AS chronoscan_code_82,
  u0_.ethnicity AS ethnicity_83,
  u0_.height AS height_84,
  u0_.weight AS weight_85,
  u0_.passport AS passport_86,
  u0_.reference_number AS reference_number_87,
  u0_.photo_consent AS photo_consent_88,
  u0_.all_marketing AS all_marketing_89,
  u0_.in_clinic_marketing AS in_clinic_marketing_90,
  u0_.in_consultation AS in_consultation_91,
  u0_.interested_in AS interested_in_92,
  u0_.consultation_type AS consultation_type_93,
  u0_.google_click_id AS google_click_id_94,
  u0_.campaign_name AS campaign_name_95,
  u0_.campaign_source AS campaign_source_96,
  u0_.campaign_medium AS campaign_medium_97,
  u0_.campaign_term AS campaign_term_98,
  u0_.campaign_content AS campaign_content_99,
  u0_.marketing_source AS marketing_source_100,
  u0_.author AS author_101,
  u0_.address1 AS address1_102,
  u0_.address2 AS address2_103,
  u0_.town AS town_104,
  u0_.state AS state_105,
  u0_.country AS country_106,
  u0_.postcode AS postcode_107,
  u0_.qualification AS qualification_108,
  u0_.summary AS summary_109,
  u0_.deleted AS deleted_110,
  u0_.calendar_color AS calendar_color_111,
  u0_.calendar_order_number AS calendar_order_number_112,
  u0_.calendar_id AS calendar_id_113,
  u0_.position AS position_114,
  u0_.online_booking_availability AS online_booking_availability_115,
  u0_.title AS title_116,
  u0_.email_verify AS email_verify_117,
  u0_.hash_user_short_url AS hash_user_short_url_118,
  u0_.licence_number AS licence_number_119,
  u0_.stripe_customer_id AS stripe_customer_id_120,
  u0_.is_online AS is_online_121,
  u0_.last_call_time AS last_call_time_122,
  u0_.hide_report_menus AS hide_report_menus_123,
  u0_.type AS type_124,
  u0_.media_id AS media_id_125,
  u0_.device_id AS device_id_126,
  u0_.created_by_id AS created_by_id_127,
  u0_.organisation_id AS organisation_id_128,
  u0_.current_clinic_id AS current_clinic_id_129,
  u0_.parent_id AS parent_id_130,
  u0_.active_photo_id AS active_photo_id_131,
  u0_.bar_code_image_id AS bar_code_image_id_132,
  u0_.clinic_id AS clinic_id_133,
  u0_.prospect_id AS prospect_id_134,
  u0_.clinic_id AS clinic_id_135,
  u0_.i_calendar_id AS i_calendar_id_136
FROM
  user u0_
  LEFT JOIN device d1_ ON u0_.device_id = d1_.id
WHERE
  (
    d1_.token = ?
    AND d1_.expired_at > ?
    AND d1_.logout_by_reason_of_license <> 1
  )
  AND u0_.type IN (
    'admin', 'admin_support', 'super_clinic_admin',
    'patient', 'clinic_user'
  )
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ LEFT JOIN device d1_ ON u0_.device_id = d1_.id WHERE (d1_.token = 'please_do_not_reply@consentz.com' AND d1_.expired_at > '2026-08-03 13:28:13' AND d1_.logout_by_reason_of_license <> 1) AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1;

"COMMIT"

"COMMIT";

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.email AS email_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.full_name AS full_name_5,
  u0_.password AS password_6,
  u0_.booking_btn_name AS booking_btn_name_7,
  u0_.booking_btn_clr AS booking_btn_clr_8,
  u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9,
  u0_.inner_color AS inner_color_10,
  u0_.outer_color AS outer_color_11,
  u0_.background_img AS background_img_12,
  u0_.profile_img AS profile_img_13,
  u0_.role AS role_14,
  u0_.enabled AS enabled_15,
  u0_.locked AS locked_16,
  u0_.visible AS visible_17,
  u0_.is_disengaged AS is_disengaged_18,
  u0_.otp AS otp_19,
  u0_.otp_sent_at AS otp_sent_at_20,
  u0_.last_otp_verified AS last_otp_verified_21,
  u0_.imap_setting AS imap_setting_22,
  u0_.country_code AS country_code_23,
  u0_.phone AS phone_24,
  u0_.practitioner_commission AS practitioner_commission_25,
  u0_.coordinator_commission AS coordinator_commission_26,
  u0_.course_commission AS course_commission_27,
  u0_.membership_commission AS membership_commission_28,
  u0_.product_commission AS product_commission_29,
  u0_.token AS token_30,
  u0_.access_all_calendars AS access_all_calendars_31,
  u0_.current_auth_token AS current_auth_token_32,
  u0_.last_auth_time AS last_auth_time_33,
  u0_.hash AS hash_34,
  u0_.fcm_token AS fcm_token_35,
  u0_.hx_change_token AS hx_change_token_36,
  u0_.login_from AS login_from_37,
  u0_.ever_login_in_v3 AS ever_login_in_v3_38,
  u0_.permissions AS permissions_39,
  u0_.clinic_id AS clinic_id_40,
  u0_.fp_promoter_id AS fp_promoter_id_41,
  u0_.referral_link AS referral_link_42,
  u0_.fp_tracking_id AS fp_tracking_id_43,
  u0_.receive_special_offer_email AS receive_special_offer_email_44,
  u0_.receive_special_offer_sms AS receive_special_offer_sms_45,
  u0_.deleted_at AS deleted_at_46,
  u0_.created_at AS created_at_47,
  u0_.updated_at AS updated_at_48,
  u0_.stripe_customer_id AS stripe_customer_id_49,
  u0_.stripe_customer_id AS stripe_customer_id_50,
  u0_.status AS status_51,
  u0_.birthday AS birthday_52,
  u0_.country_code_alt AS country_code_alt_53,
  u0_.secondary_phone AS secondary_phone_54,
  u0_.next_kin AS next_kin_55,
  u0_.next_kin_phone AS next_kin_phone_56,
  u0_.description AS description_57,
  u0_.glogau_scale AS glogau_scale_58,
  u0_.fitzpatrick_scale AS fitzpatrick_scale_59,
  u0_.gender AS gender_60,
  u0_.receive_special_offer_push AS receive_special_offer_push_61,
  u0_.receive_reminder_email AS receive_reminder_email_62,
  u0_.receive_reminder_sms AS receive_reminder_sms_63,
  u0_.receive_reminder_push AS receive_reminder_push_64,
  u0_.parent_user_id AS parent_user_id_65,
  u0_.account_type AS account_type_66,
  u0_.terms_accepted AS terms_accepted_67,
  u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68,
  u0_.referral AS referral_69,
  u0_.export_in_progress AS export_in_progress_70,
  u0_.occupation AS occupation_71,
  u0_.number_nhs AS number_nhs_72,
  u0_.gp_name AS gp_name_73,
  u0_.contact_gp AS contact_gp_74,
  u0_.gp_address1 AS gp_address1_75,
  u0_.gp_address2 AS gp_address2_76,
  u0_.gp_town AS gp_town_77,
  u0_.gp_county AS gp_county_78,
  u0_.gp_post_code AS gp_post_code_79,
  u0_.gp_country AS gp_country_80,
  u0_.ref AS ref_81,
  u0_.chronoscan_code AS chronoscan_code_82,
  u0_.ethnicity AS ethnicity_83,
  u0_.height AS height_84,
  u0_.weight AS weight_85,
  u0_.passport AS passport_86,
  u0_.reference_number AS reference_number_87,
  u0_.photo_consent AS photo_consent_88,
  u0_.all_marketing AS all_marketing_89,
  u0_.in_clinic_marketing AS in_clinic_marketing_90,
  u0_.in_consultation AS in_consultation_91,
  u0_.interested_in AS interested_in_92,
  u0_.consultation_type AS consultation_type_93,
  u0_.google_click_id AS google_click_id_94,
  u0_.campaign_name AS campaign_name_95,
  u0_.campaign_source AS campaign_source_96,
  u0_.campaign_medium AS campaign_medium_97,
  u0_.campaign_term AS campaign_term_98,
  u0_.campaign_content AS campaign_content_99,
  u0_.marketing_source AS marketing_source_100,
  u0_.author AS author_101,
  u0_.address1 AS address1_102,
  u0_.address2 AS address2_103,
  u0_.town AS town_104,
  u0_.state AS state_105,
  u0_.country AS country_106,
  u0_.postcode AS postcode_107,
  u0_.qualification AS qualification_108,
  u0_.summary AS summary_109,
  u0_.deleted AS deleted_110,
  u0_.calendar_color AS calendar_color_111,
  u0_.calendar_order_number AS calendar_order_number_112,
  u0_.calendar_id AS calendar_id_113,
  u0_.position AS position_114,
  u0_.online_booking_availability AS online_booking_availability_115,
  u0_.title AS title_116,
  u0_.email_verify AS email_verify_117,
  u0_.hash_user_short_url AS hash_user_short_url_118,
  u0_.licence_number AS licence_number_119,
  u0_.stripe_customer_id AS stripe_customer_id_120,
  u0_.is_online AS is_online_121,
  u0_.last_call_time AS last_call_time_122,
  u0_.hide_report_menus AS hide_report_menus_123,
  u0_.type AS type_124,
  u0_.media_id AS media_id_125,
  u0_.device_id AS device_id_126,
  u0_.created_by_id AS created_by_id_127,
  u0_.organisation_id AS organisation_id_128,
  u0_.current_clinic_id AS current_clinic_id_129,
  u0_.parent_id AS parent_id_130,
  u0_.active_photo_id AS active_photo_id_131,
  u0_.bar_code_image_id AS bar_code_image_id_132,
  u0_.clinic_id AS clinic_id_133,
  u0_.prospect_id AS prospect_id_134,
  u0_.clinic_id AS clinic_id_135,
  u0_.i_calendar_id AS i_calendar_id_136
FROM
  user u0_
WHERE
  (u0_.username = ?)
  AND u0_.type IN (
    'admin', 'admin_support', 'super_clinic_admin',
    'patient', 'clinic_user'
  )
LIMIT
  1

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.email AS email_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.full_name AS full_name_5, u0_.password AS password_6, u0_.booking_btn_name AS booking_btn_name_7, u0_.booking_btn_clr AS booking_btn_clr_8, u0_.booking_btn_bg_clr AS booking_btn_bg_clr_9, u0_.inner_color AS inner_color_10, u0_.outer_color AS outer_color_11, u0_.background_img AS background_img_12, u0_.profile_img AS profile_img_13, u0_.role AS role_14, u0_.enabled AS enabled_15, u0_.locked AS locked_16, u0_.visible AS visible_17, u0_.is_disengaged AS is_disengaged_18, u0_.otp AS otp_19, u0_.otp_sent_at AS otp_sent_at_20, u0_.last_otp_verified AS last_otp_verified_21, u0_.imap_setting AS imap_setting_22, u0_.country_code AS country_code_23, u0_.phone AS phone_24, u0_.practitioner_commission AS practitioner_commission_25, u0_.coordinator_commission AS coordinator_commission_26, u0_.course_commission AS course_commission_27, u0_.membership_commission AS membership_commission_28, u0_.product_commission AS product_commission_29, u0_.token AS token_30, u0_.access_all_calendars AS access_all_calendars_31, u0_.current_auth_token AS current_auth_token_32, u0_.last_auth_time AS last_auth_time_33, u0_.hash AS hash_34, u0_.fcm_token AS fcm_token_35, u0_.hx_change_token AS hx_change_token_36, u0_.login_from AS login_from_37, u0_.ever_login_in_v3 AS ever_login_in_v3_38, u0_.permissions AS permissions_39, u0_.clinic_id AS clinic_id_40, u0_.fp_promoter_id AS fp_promoter_id_41, u0_.referral_link AS referral_link_42, u0_.fp_tracking_id AS fp_tracking_id_43, u0_.receive_special_offer_email AS receive_special_offer_email_44, u0_.receive_special_offer_sms AS receive_special_offer_sms_45, u0_.deleted_at AS deleted_at_46, u0_.created_at AS created_at_47, u0_.updated_at AS updated_at_48, u0_.stripe_customer_id AS stripe_customer_id_49, u0_.stripe_customer_id AS stripe_customer_id_50, u0_.status AS status_51, u0_.birthday AS birthday_52, u0_.country_code_alt AS country_code_alt_53, u0_.secondary_phone AS secondary_phone_54, u0_.next_kin AS next_kin_55, u0_.next_kin_phone AS next_kin_phone_56, u0_.description AS description_57, u0_.glogau_scale AS glogau_scale_58, u0_.fitzpatrick_scale AS fitzpatrick_scale_59, u0_.gender AS gender_60, u0_.receive_special_offer_push AS receive_special_offer_push_61, u0_.receive_reminder_email AS receive_reminder_email_62, u0_.receive_reminder_sms AS receive_reminder_sms_63, u0_.receive_reminder_push AS receive_reminder_push_64, u0_.parent_user_id AS parent_user_id_65, u0_.account_type AS account_type_66, u0_.terms_accepted AS terms_accepted_67, u0_.terms_accepted_patient_mode AS terms_accepted_patient_mode_68, u0_.referral AS referral_69, u0_.export_in_progress AS export_in_progress_70, u0_.occupation AS occupation_71, u0_.number_nhs AS number_nhs_72, u0_.gp_name AS gp_name_73, u0_.contact_gp AS contact_gp_74, u0_.gp_address1 AS gp_address1_75, u0_.gp_address2 AS gp_address2_76, u0_.gp_town AS gp_town_77, u0_.gp_county AS gp_county_78, u0_.gp_post_code AS gp_post_code_79, u0_.gp_country AS gp_country_80, u0_.ref AS ref_81, u0_.chronoscan_code AS chronoscan_code_82, u0_.ethnicity AS ethnicity_83, u0_.height AS height_84, u0_.weight AS weight_85, u0_.passport AS passport_86, u0_.reference_number AS reference_number_87, u0_.photo_consent AS photo_consent_88, u0_.all_marketing AS all_marketing_89, u0_.in_clinic_marketing AS in_clinic_marketing_90, u0_.in_consultation AS in_consultation_91, u0_.interested_in AS interested_in_92, u0_.consultation_type AS consultation_type_93, u0_.google_click_id AS google_click_id_94, u0_.campaign_name AS campaign_name_95, u0_.campaign_source AS campaign_source_96, u0_.campaign_medium AS campaign_medium_97, u0_.campaign_term AS campaign_term_98, u0_.campaign_content AS campaign_content_99, u0_.marketing_source AS marketing_source_100, u0_.author AS author_101, u0_.address1 AS address1_102, u0_.address2 AS address2_103, u0_.town AS town_104, u0_.state AS state_105, u0_.country AS country_106, u0_.postcode AS postcode_107, u0_.qualification AS qualification_108, u0_.summary AS summary_109, u0_.deleted AS deleted_110, u0_.calendar_color AS calendar_color_111, u0_.calendar_order_number AS calendar_order_number_112, u0_.calendar_id AS calendar_id_113, u0_.position AS position_114, u0_.online_booking_availability AS online_booking_availability_115, u0_.title AS title_116, u0_.email_verify AS email_verify_117, u0_.hash_user_short_url AS hash_user_short_url_118, u0_.licence_number AS licence_number_119, u0_.stripe_customer_id AS stripe_customer_id_120, u0_.is_online AS is_online_121, u0_.last_call_time AS last_call_time_122, u0_.hide_report_menus AS hide_report_menus_123, u0_.type AS type_124, u0_.media_id AS media_id_125, u0_.device_id AS device_id_126, u0_.created_by_id AS created_by_id_127, u0_.organisation_id AS organisation_id_128, u0_.current_clinic_id AS current_clinic_id_129, u0_.parent_id AS parent_id_130, u0_.active_photo_id AS active_photo_id_131, u0_.bar_code_image_id AS bar_code_image_id_132, u0_.clinic_id AS clinic_id_133, u0_.prospect_id AS prospect_id_134, u0_.clinic_id AS clinic_id_135, u0_.i_calendar_id AS i_calendar_id_136 FROM user u0_ WHERE (u0_.username = 'please_do_not_reply@consentz.com') AND u0_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";