1 |
2.93 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.status AS status_4, t0.color_primary AS color_primary_5, t0.color_secondary AS color_secondary_6, t0.color_text AS color_text_7, t0.color_primary_button AS color_primary_button_8, t0.color_primary_button_accent AS color_primary_button_accent_9, t0.color_secondary_button AS color_secondary_button_10, t0.color_secondary_button_accent AS color_secondary_button_accent_11, t0.logo1 AS logo1_12, t0.logo2 AS logo2_13, t0.logo3 AS logo3_14, t0.logo4 AS logo4_15, t0.reimbursement_summary AS reimbursement_summary_16, t0.force_gateway AS force_gateway_17, t0.client_gateway AS client_gateway_18, t0.force_bp_override AS force_bp_override_19, t0.multiple_languages AS multiple_languages_20, t0.url AS url_21, t0.customer_number AS customer_number_22, t0.po_number AS po_number_23, t0.google_analytics AS google_analytics_24, t0.google_tag AS google_tag_25, t0.sso_cert AS sso_cert_26, t0.sso_key AS sso_key_27, t0.sso_signiture AS sso_signiture_28, t0.show_register AS show_register_29, t0.show_signin AS show_signin_30, t0.show_support AS show_support_31, t0.show_support_number AS show_support_number_32, t0.show_privacy AS show_privacy_33, t0.use_dob AS use_dob_34, t0.use_postal AS use_postal_35, t0.code_required AS code_required_36, t0.use_custom_login AS use_custom_login_37, t0.custom_login AS custom_login_38, t0.universal_login AS universal_login_39, t0.sso_create_password AS sso_create_password_40, t0.accessibility_opt_in AS accessibility_opt_in_41, t0.net_promoter AS net_promoter_42, t0.net_promoter_threshold AS net_promoter_threshold_43, t0.default_language AS default_language_44, t0.exchange_rate AS exchange_rate_45, t0.date_created AS date_created_46, t0.date_changed AS date_changed_47, t0.data_status AS data_status_48, t0.client_id AS client_id_49, t0.currency_id AS currency_id_50 FROM organizations t0 WHERE t0.url = ? LIMIT 1
Parameters: [
"emblemhealth"
]
SELECT
t0.id AS id_1,
t0.name AS name_2,
t0.tag AS tag_3,
t0.status AS status_4,
t0.color_primary AS color_primary_5,
t0.color_secondary AS color_secondary_6,
t0.color_text AS color_text_7,
t0.color_primary_button AS color_primary_button_8,
t0.color_primary_button_accent AS color_primary_button_accent_9,
t0.color_secondary_button AS color_secondary_button_10,
t0.color_secondary_button_accent AS color_secondary_button_accent_11,
t0.logo1 AS logo1_12,
t0.logo2 AS logo2_13,
t0.logo3 AS logo3_14,
t0.logo4 AS logo4_15,
t0.reimbursement_summary AS reimbursement_summary_16,
t0.force_gateway AS force_gateway_17,
t0.client_gateway AS client_gateway_18,
t0.force_bp_override AS force_bp_override_19,
t0.multiple_languages AS multiple_languages_20,
t0.url AS url_21,
t0.customer_number AS customer_number_22,
t0.po_number AS po_number_23,
t0.google_analytics AS google_analytics_24,
t0.google_tag AS google_tag_25,
t0.sso_cert AS sso_cert_26,
t0.sso_key AS sso_key_27,
t0.sso_signiture AS sso_signiture_28,
t0.show_register AS show_register_29,
t0.show_signin AS show_signin_30,
t0.show_support AS show_support_31,
t0.show_support_number AS show_support_number_32,
t0.show_privacy AS show_privacy_33,
t0.use_dob AS use_dob_34,
t0.use_postal AS use_postal_35,
t0.code_required AS code_required_36,
t0.use_custom_login AS use_custom_login_37,
t0.custom_login AS custom_login_38,
t0.universal_login AS universal_login_39,
t0.sso_create_password AS sso_create_password_40,
t0.accessibility_opt_in AS accessibility_opt_in_41,
t0.net_promoter AS net_promoter_42,
t0.net_promoter_threshold AS net_promoter_threshold_43,
t0.default_language AS default_language_44,
t0.exchange_rate AS exchange_rate_45,
t0.date_created AS date_created_46,
t0.date_changed AS date_changed_47,
t0.data_status AS data_status_48,
t0.client_id AS client_id_49,
t0.currency_id AS currency_id_50
FROM
organizations t0
WHERE
t0.url = ?
LIMIT
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.tag AS tag_3, t0.status AS status_4, t0.color_primary AS color_primary_5, t0.color_secondary AS color_secondary_6, t0.color_text AS color_text_7, t0.color_primary_button AS color_primary_button_8, t0.color_primary_button_accent AS color_primary_button_accent_9, t0.color_secondary_button AS color_secondary_button_10, t0.color_secondary_button_accent AS color_secondary_button_accent_11, t0.logo1 AS logo1_12, t0.logo2 AS logo2_13, t0.logo3 AS logo3_14, t0.logo4 AS logo4_15, t0.reimbursement_summary AS reimbursement_summary_16, t0.force_gateway AS force_gateway_17, t0.client_gateway AS client_gateway_18, t0.force_bp_override AS force_bp_override_19, t0.multiple_languages AS multiple_languages_20, t0.url AS url_21, t0.customer_number AS customer_number_22, t0.po_number AS po_number_23, t0.google_analytics AS google_analytics_24, t0.google_tag AS google_tag_25, t0.sso_cert AS sso_cert_26, t0.sso_key AS sso_key_27, t0.sso_signiture AS sso_signiture_28, t0.show_register AS show_register_29, t0.show_signin AS show_signin_30, t0.show_support AS show_support_31, t0.show_support_number AS show_support_number_32, t0.show_privacy AS show_privacy_33, t0.use_dob AS use_dob_34, t0.use_postal AS use_postal_35, t0.code_required AS code_required_36, t0.use_custom_login AS use_custom_login_37, t0.custom_login AS custom_login_38, t0.universal_login AS universal_login_39, t0.sso_create_password AS sso_create_password_40, t0.accessibility_opt_in AS accessibility_opt_in_41, t0.net_promoter AS net_promoter_42, t0.net_promoter_threshold AS net_promoter_threshold_43, t0.default_language AS default_language_44, t0.exchange_rate AS exchange_rate_45, t0.date_created AS date_created_46, t0.date_changed AS date_changed_47, t0.data_status AS data_status_48, t0.client_id AS client_id_49, t0.currency_id AS currency_id_50 FROM organizations t0 WHERE t0.url = 'emblemhealth' LIMIT 1;
|
2 |
3.88 ms |
SELECT t0.id AS id_1, t0.support_number AS support_number_2, t0.fax_number AS fax_number_3, t0.email AS email_4, t0.vanity_url AS vanity_url_5, t0.terms_url AS terms_url_6, t0.terms_use_url AS terms_use_url_7, t0.file_name AS file_name_8, t0.faq_url AS faq_url_9, t0.privacy_url AS privacy_url_10, t0.show_privacy_policy AS show_privacy_policy_11, t0.date_created AS date_created_12, t0.date_changed AS date_changed_13, t0.data_status AS data_status_14, t0.client_id AS client_id_15 FROM additional_info t0 WHERE t0.client_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.support_number AS support_number_2, t0.fax_number AS fax_number_3, t0.email AS email_4, t0.vanity_url AS vanity_url_5, t0.terms_url AS terms_url_6, t0.terms_use_url AS terms_use_url_7, t0.file_name AS file_name_8, t0.faq_url AS faq_url_9, t0.privacy_url AS privacy_url_10, t0.show_privacy_policy AS show_privacy_policy_11, t0.date_created AS date_created_12, t0.date_changed AS date_changed_13, t0.data_status AS data_status_14, t0.client_id AS client_id_15 FROM additional_info t0 WHERE t0.client_id = 59 LIMIT 1;
|