Query Metrics
74
Database Queries
18
Different statements
133.19 ms
Query time
4
Invalid entities
200
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
44.34 ms (33.29%) |
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_.qualification AS qualification_49, u0_.summary AS summary_50, u0_.deleted AS deleted_51, u0_.calendar_color AS calendar_color_52, u0_.calendar_order_number AS calendar_order_number_53, u0_.calendar_id AS calendar_id_54, u0_.position AS position_55, u0_.online_booking_availability AS online_booking_availability_56, u0_.title AS title_57, u0_.email_verify AS email_verify_58, u0_.hash_user_short_url AS hash_user_short_url_59, u0_.licence_number AS licence_number_60, u0_.stripe_customer_id AS stripe_customer_id_61, u0_.is_online AS is_online_62, u0_.last_call_time AS last_call_time_63, u0_.hide_report_menus AS hide_report_menus_64, u0_.type AS type_65, u0_.media_id AS media_id_66, u0_.device_id AS device_id_67, u0_.created_by_id AS created_by_id_68, u0_.clinic_id AS clinic_id_69, u0_.i_calendar_id AS i_calendar_id_70, u0_.organisation_id AS organisation_id_71, u0_.current_clinic_id AS current_clinic_id_72 FROM user u0_ LEFT JOIN clinics c1_ ON u0_.clinic_id = c1_.id LEFT JOIN organisation o2_ ON c1_.organisation_id = o2_.id WHERE (u0_.id <> ? AND u0_.deleted = 0 AND o2_.id = ?) AND u0_.type IN ('clinic_user', 'super_clinic_admin') ORDER BY u0_.last_name ASC
Parameters:
[ 3229 3 ] |
||||||||||||||||||||||||||||||||
|
11.87 ms (8.91%) |
9 |
SELECT t0.id AS id_1, t0.creditor AS creditor_2, t0.mandate AS mandate_3, t0.customer AS customer_4, t0.customer_bank_account AS customer_bank_account_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.clinic_id AS clinic_id_8 FROM gocardless_customer t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
11.01 ms (8.26%) |
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_.qualification AS qualification_49, u0_.summary AS summary_50, u0_.deleted AS deleted_51, u0_.calendar_color AS calendar_color_52, u0_.calendar_order_number AS calendar_order_number_53, u0_.calendar_id AS calendar_id_54, u0_.position AS position_55, u0_.online_booking_availability AS online_booking_availability_56, u0_.title AS title_57, u0_.email_verify AS email_verify_58, u0_.hash_user_short_url AS hash_user_short_url_59, u0_.licence_number AS licence_number_60, u0_.stripe_customer_id AS stripe_customer_id_61, u0_.is_online AS is_online_62, u0_.last_call_time AS last_call_time_63, u0_.hide_report_menus AS hide_report_menus_64, u0_.type AS type_65, u0_.media_id AS media_id_66, u0_.device_id AS device_id_67, u0_.created_by_id AS created_by_id_68, u0_.clinic_id AS clinic_id_69, u0_.i_calendar_id AS i_calendar_id_70, u0_.organisation_id AS organisation_id_71, u0_.current_clinic_id AS current_clinic_id_72 FROM user u0_ LEFT JOIN organisation o1_ ON u0_.organisation_id = o1_.id WHERE (o1_.id = ? AND u0_.id <> ?) AND u0_.type IN ('super_clinic_admin') ORDER BY u0_.last_name ASC
Parameters:
[ 3 3229 ] |
||||||||||||||||||||||||||||||||
|
10.53 ms (7.91%) |
9 |
SELECT t0.id AS id_1, t0.enabled AS enabled_2, t0.time_required_for_booking AS time_required_for_booking_3, t0.time_required_for_cancellation AS time_required_for_cancellation_4, t0.take_payment_for_new_patients AS take_payment_for_new_patients_5, t0.take_payment_for_existing_patients AS take_payment_for_existing_patients_6, t0.type AS type_7, t0.hide_full_price AS hide_full_price_8, t0.terms AS terms_9, t0.clinic_id AS clinic_id_10 FROM setting_online_booking t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
8.82 ms (6.62%) |
9 |
SELECT t0.id AS id_1, t0.confirmation_text AS confirmation_text_2, t0.treatment_info AS treatment_info_3, t0.clinic_id AS clinic_id_4 FROM email_setting_online_booking t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
8.67 ms (6.51%) |
9 |
SELECT t0.id AS id_1, t0.sid AS sid_2, t0.token AS token_3, t0.number_from AS number_from_4, t0.clinic_id AS clinic_id_5 FROM twilio t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
7.39 ms (5.55%) |
9 |
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.max_embed_width AS max_embed_width_3, t0.primary_interface_colour AS primary_interface_colour_4, t0.secondary_interface_colour AS secondary_interface_colour_5, t0.primary_font_colour AS primary_font_colour_6, t0.secondary_font_colour AS secondary_font_colour_7, t0.background_colour AS background_colour_8, t0.widget_hash AS widget_hash_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.clinic_id AS clinic_id_12, t0.custom_css_id AS custom_css_id_13, t14.id AS id_15, t14.s3key AS s3key_16, t14.name_file AS name_file_17, t14.url AS url_18, t14.type AS type_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21 FROM widget_online_booking t0 LEFT JOIN media t14 ON t0.custom_css_id = t14.id WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
6.78 ms (5.09%) |
9 |
SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.list_id AS list_id_3, t0.sync AS sync_4, t0.sync_date AS sync_date_5, t0.pro AS pro_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.clinic_id AS clinic_id_9 FROM mail_chimp_config t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
6.58 ms (4.94%) |
1 |
SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, t0_.updated_at AS updated_at_2 FROM table_conversation t0_ INNER JOIN user_conversation u1_ ON t0_.id = u1_.conversation_id INNER JOIN user u2_ ON u1_.user_id = u2_.id AND u2_.type IN ('admin', 'admin_support', 'super_clinic_admin', 'patient', 'clinic_user') WHERE u2_.id = ? ORDER BY t0_.id ASC
Parameters:
[
3229
]
|
||||||||||||||||||||||||||||||||
|
4.32 ms (3.25%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.sub_domain AS sub_domain_2, c0_.organisation_id AS organisation_id_3, c0_.smscredit AS smscredit_4, c0_.ai_token_credit AS ai_token_credit_5, c0_.last_daily_token_date AS last_daily_token_date_6, c0_.ai_seconds_credit AS ai_seconds_credit_7, c0_.daily_ai_token_credit AS daily_ai_token_credit_8, c0_.booking_btn_name AS booking_btn_name_9, c0_.booking_btn_clr AS booking_btn_clr_10, c0_.booking_btn_bg_clr AS booking_btn_bg_clr_11, c0_.inner_color AS inner_color_12, c0_.outer_color AS outer_color_13, c0_.background_img AS background_img_14, c0_.profile_img AS profile_img_15, c0_.meeting_price AS meeting_price_16, c0_.meeting_price_type AS meeting_price_type_17, c0_.show_in_public_profile AS show_in_public_profile_18, c0_.patient_ref_prefix AS patient_ref_prefix_19, c0_.email AS email_20, c0_.verified_email AS verified_email_21, c0_.web_site AS web_site_22, c0_.phone AS phone_23, c0_.contact_name AS contact_name_24, c0_.description AS description_25, c0_.widget_settings AS widget_settings_26, c0_.sms_number AS sms_number_27, c0_.sms_status AS sms_status_28, c0_.timezone AS timezone_29, c0_.reminder_header AS reminder_header_30, c0_.reminder_footer AS reminder_footer_31, c0_.reminder_recall_text AS reminder_recall_text_32, c0_.google_token AS google_token_33, c0_.google_id AS google_id_34, c0_.topic_arn AS topic_arn_35, c0_.pm_pin AS pm_pin_36, c0_.auto_email_reply_address AS auto_email_reply_address_37, c0_.pm_patient_message AS pm_patient_message_38, c0_.pm_clinic_intro AS pm_clinic_intro_39, c0_.auto_renew_subscription AS auto_renew_subscription_40, c0_.subscription_expiry AS subscription_expiry_41, c0_.email_reminder AS email_reminder_42, c0_.email_new AS email_new_43, c0_.sms_new AS sms_new_44, c0_.sms_reminder AS sms_reminder_45, c0_.when_answered_hide_where_did_you_hear_about_us AS when_answered_hide_where_did_you_hear_about_us_46, c0_.calendar_start_day AS calendar_start_day_47, c0_.calendar_end_day AS calendar_end_day_48, c0_.appointment_default_time AS appointment_default_time_49, c0_.appointment_slot_duration AS appointment_slot_duration_50, c0_.appointment_default_view AS appointment_default_view_51, c0_.private_mode_calendar AS private_mode_calendar_52, c0_.clinic_representative AS clinic_representative_53, c0_.data_protection_officer AS data_protection_officer_54, c0_.company_registration_number AS company_registration_number_55, c0_.email_to_withdraw AS email_to_withdraw_56, c0_.period_stored_data AS period_stored_data_57, c0_.survey_email_text AS survey_email_text_58, c0_.post_apt_form_email_text AS post_apt_form_email_text_59, c0_.export_in_progress AS export_in_progress_60, c0_.vat_number AS vat_number_61, c0_.enabled_vat AS enabled_vat_62, c0_.patient_list_display_pair AS patient_list_display_pair_63, c0_.stripe_refresh_token AS stripe_refresh_token_64, c0_.stripe_publishable_key AS stripe_publishable_key_65, c0_.stripe_account_id AS stripe_account_id_66, c0_.shared_all_patients AS shared_all_patients_67, c0_.currency AS currency_68, c0_.patient_info_to_document_header AS patient_info_to_document_header_69, c0_.t_and_c AS t_and_c_70, c0_.declaration AS declaration_71, c0_.treatment_plan_tand_c AS treatment_plan_tand_c_72, c0_.traffic_light AS traffic_light_73, c0_.booking_required_fields AS booking_required_fields_74, c0_.double_booking AS double_booking_75, c0_.required_confirmation AS required_confirmation_76, c0_.fixed_discount_amount AS fixed_discount_amount_77, c0_.required_questionnaires AS required_questionnaires_78, c0_.patient_required_fields AS patient_required_fields_79, c0_.prospect_required_fields AS prospect_required_fields_80, c0_.enabled_postcode AS enabled_postcode_81, c0_.enabled_chronoscan AS enabled_chronoscan_82, c0_.postcode_api_key AS postcode_api_key_83, c0_.enabled_prospect_web_form AS enabled_prospect_web_form_84, c0_.payment_sense AS payment_sense_85, c0_.xero_tenant_id AS xero_tenant_id_86, c0_.reduce_stock AS reduce_stock_87, c0_.patient_questionnaire AS patient_questionnaire_88, c0_.xero_bank_account AS xero_bank_account_89, c0_.is_new_clinic AS is_new_clinic_90, c0_.marketing_expert AS marketing_expert_91, c0_.clinic_survey_email_text AS clinic_survey_email_text_92, c0_.trial_end_date AS trial_end_date_93, c0_.shared_patient_date AS shared_patient_date_94, c0_.feature_custom_website_amount AS feature_custom_website_amount_95, c0_.feature_ad_amount AS feature_ad_amount_96, c0_.feature_message_amount AS feature_message_amount_97, c0_.feature_template_amount AS feature_template_amount_98, c0_.is_template_user_only AS is_template_user_only_99, c0_.new_user AS new_user_100, c0_.template_subscription_end_date AS template_subscription_end_date_101, c0_.onboarding_status AS onboarding_status_102, c0_.address1 AS address1_103, c0_.address2 AS address2_104, c0_.town AS town_105, c0_.state AS state_106, c0_.country AS country_107, c0_.postcode AS postcode_108, c0_.created_at AS created_at_109, c0_.updated_at AS updated_at_110, c0_.logo_id AS logo_id_111, c0_.background_id AS background_id_112, c0_.organisation_id AS organisation_id_113, c0_.promo_code_id AS promo_code_id_114, c0_.price_tier_id AS price_tier_id_115, c0_.xero_sync_job_id AS xero_sync_job_id_116 FROM clinics c0_ WHERE c0_.organisation_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
|
2.97 ms (2.23%) |
9 |
SELECT t0.id AS id_1, t0.server AS server_2, t0.file_location AS file_location_3, t0.username AS username_4, t0.password AS password_5, t0.email AS email_6, t0.clinic_id AS clinic_id_7 FROM setting_chronoscan t0 WHERE t0.clinic_id = ?
Parameters:
[
34
]
|
||||||||||||||||||||||||||||||||
|
2.37 ms (1.78%) |
1 |
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.clinic_id AS clinic_id_3, t0.widget_type AS widget_type_4, t0.title AS title_5, t0.settings AS settings_6, t0.position AS position_7, t0.size AS size_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM dashboard_widgets t0 WHERE t0.user_id = ? AND t0.widget_type = ? LIMIT 1
Parameters:
[ 3229 "_global_settings" ]
|
||||||||||||||||||||||||||||||||
|
2.35 ms (1.76%) |
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 (?)
Parameters:
[
109932
]
|
||||||||||||||||||||||||||||||||
|
1.72 ms (1.30%) |
1 |
SELECT d0_.id AS id_0, d0_.user_id AS user_id_1, d0_.clinic_id AS clinic_id_2, d0_.widget_type AS widget_type_3, d0_.title AS title_4, d0_.settings AS settings_5, d0_.position AS position_6, d0_.size AS size_7, d0_.is_active AS is_active_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10 FROM dashboard_widgets d0_ WHERE d0_.user_id = ? AND d0_.clinic_id = ? AND d0_.is_active = ? ORDER BY d0_.position ASC
Parameters:
[ 3229 3 1 ] |
||||||||||||||||||||||||||||||||
|
1.35 ms (1.01%) |
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')
Parameters:
[
3229
]
|
||||||||||||||||||||||||||||||||
|
0.92 ms (0.69%) |
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 = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
|
0.60 ms (0.45%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.subscription_rate AS subscription_rate_3, t0.enable_licensing AS enable_licensing_4, t0.enable_feature_licensing_ad AS enable_feature_licensing_ad_5, t0.enable_feature_licensing_message AS enable_feature_licensing_message_6, t0.enable_feature_licensing_custom_website AS enable_feature_licensing_custom_website_7, t0.xero_access_token AS xero_access_token_8, t0.xero_refresh_token AS xero_refresh_token_9, t0.deleted_at AS deleted_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM organisation t0 WHERE t0.id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
|
0.60 ms (0.45%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.license_cost AS license_cost_4, t0.additional_license_cost AS additional_license_cost_5, t0.license_cost_usd AS license_cost_usd_6, t0.additional_license_cost_usd AS additional_license_cost_usd_7, t0.practitioners_limit AS practitioners_limit_8, t0.team_members_limit AS team_members_limit_9, t0.deleted_at AS deleted_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.price_tiers_group_id AS price_tiers_group_id_13 FROM price_tier t0 WHERE t0.id = ?
Parameters:
[
15
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| pgsql | doctrine.dbal.pgsql_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Person\User | 106 |
| App\Entity\Media\Media | 50 |
| App\Entity\Clinic\Clinic | 10 |
| App\Entity\Person\Device | 10 |
| App\Entity\DashboardWidget | 7 |
| App\Entity\Clinic\PriceTier\PriceTier | 5 |
| App\Entity\Clinic\GocardlessCustomer | 2 |
| App\Entity\Clinic\OnlineBooking\Settings | 2 |
| App\Entity\Clinic\OnlineBooking\Widget | 2 |
| App\Entity\Clinic\OnlineBooking\EmailSettings | 2 |
| App\Entity\Organisation\Organisation | 1 |
| App\Entity\Clinic\Twilio | 1 |
| App\Entity\Clinic\MailChimp\MailChimpConfig | 1 |
| App\Entity\Clinic\PriceTier\PriceTiersGroup | 1 |