| 1 |
3.62 ms |
SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 WHERE t0.active = ?
SELECT
t0.id AS id_1,
t0.sync_flag AS sync_flag_2,
t0.name AS name_3,
t0.image AS image_4,
t0.app_id AS app_id_5,
t0.owner_id AS owner_id_6,
t0.stripe_customer_id AS stripe_customer_id_7,
t0.manage_user_ids AS manage_user_ids_8,
t0.post_dated_job_active AS post_dated_job_active_9,
t0.address AS address_10,
t0.shipping_address AS shipping_address_11,
t0.billing_address AS billing_address_12,
t0.motto AS motto_13,
t0.invoice_footer AS invoice_footer_14,
t0.general_footer AS general_footer_15,
t0.company_allowed AS company_allowed_16,
t0.company_allocated AS company_allocated_17,
t0.country_id AS country_id_18,
t0.locale AS locale_19,
t0.company_remaining AS company_remaining_20,
t0.user_allowed AS user_allowed_21,
t0.user_allocated AS user_allocated_22,
t0.user_remaining AS user_remaining_23,
t0.admin_user_allowed AS admin_user_allowed_24,
t0.admin_user_allocated AS admin_user_allocated_25,
t0.admin_user_remaining AS admin_user_remaining_26,
t0.contact_number AS contact_number_27,
t0.email AS email_28,
t0.db_name AS db_name_29,
t0.db_pass AS db_pass_30,
t0.db_user AS db_user_31,
t0.db_host AS db_host_32,
t0.company_group_hash AS company_group_hash_33,
t0.company_group_unique_code AS company_group_unique_code_34,
t0.enabled_module_id_list AS enabled_module_id_list_35,
t0.company_group_server_id AS company_group_server_id_36,
t0.company_group_server_hash AS company_group_server_hash_37,
t0.company_group_server_address AS company_group_server_address_38,
t0.company_group_server_port AS company_group_server_port_39,
t0.company_bin AS company_bin_40,
t0.company_tin AS company_tin_41,
t0.company_reg AS company_reg_42,
t0.company_tl AS company_tl_43,
t0.initiate_flag AS initiate_flag_44,
t0.current_server_id AS current_server_id_45,
t0.current_server_hash AS current_server_hash_46,
t0.current_server_address AS current_server_address_47,
t0.current_server_port AS current_server_port_48,
t0.usage_valid_upto_date AS usage_valid_upto_date_49,
t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50,
t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51,
t0.current_server_domain_full_link AS current_server_domain_full_link_52,
t0.company_group_billing_info AS company_group_billing_info_53,
t0.company_group_next_bill_date AS company_group_next_bill_date_54,
t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55,
t0.company_group_billing_frequency AS company_group_billing_frequency_56,
t0.cash AS cash_57,
t0.sales AS sales_58,
t0.expense AS expense_59,
t0.payable AS payable_60,
t0.net_worth AS net_worth_61,
t0.monthly_growth AS monthly_growth_62,
t0.active AS active_63,
t0.read_only_mode AS read_only_mode_64,
t0.company_status AS company_status_65,
t0.package_type AS package_type_66,
t0.subscription_expiry AS subscription_expiry_67,
t0.last_activity_at AS last_activity_at_68,
t0.current_subscription_package_id AS current_subscription_package_id_69,
t0.subscription_month AS subscription_month_70,
t0.billing_amount AS billing_amount_71,
t0.subscription_details AS subscription_details_72,
t0.company_type AS company_type_73,
t0.company_description AS company_description_74,
t0.skip_in_web_flag AS skip_in_web_flag_75,
t0.skip_in_app_flag AS skip_in_app_flag_76,
t0.schema_update_pending_flag AS schema_update_pending_flag_77,
t0.created_at AS created_at_78,
t0.updated_at AS updated_at_79
FROM
company_group t0
WHERE
t0.active = ?
SELECT t0.id AS id_1, t0.sync_flag AS sync_flag_2, t0.name AS name_3, t0.image AS image_4, t0.app_id AS app_id_5, t0.owner_id AS owner_id_6, t0.stripe_customer_id AS stripe_customer_id_7, t0.manage_user_ids AS manage_user_ids_8, t0.post_dated_job_active AS post_dated_job_active_9, t0.address AS address_10, t0.shipping_address AS shipping_address_11, t0.billing_address AS billing_address_12, t0.motto AS motto_13, t0.invoice_footer AS invoice_footer_14, t0.general_footer AS general_footer_15, t0.company_allowed AS company_allowed_16, t0.company_allocated AS company_allocated_17, t0.country_id AS country_id_18, t0.locale AS locale_19, t0.company_remaining AS company_remaining_20, t0.user_allowed AS user_allowed_21, t0.user_allocated AS user_allocated_22, t0.user_remaining AS user_remaining_23, t0.admin_user_allowed AS admin_user_allowed_24, t0.admin_user_allocated AS admin_user_allocated_25, t0.admin_user_remaining AS admin_user_remaining_26, t0.contact_number AS contact_number_27, t0.email AS email_28, t0.db_name AS db_name_29, t0.db_pass AS db_pass_30, t0.db_user AS db_user_31, t0.db_host AS db_host_32, t0.company_group_hash AS company_group_hash_33, t0.company_group_unique_code AS company_group_unique_code_34, t0.enabled_module_id_list AS enabled_module_id_list_35, t0.company_group_server_id AS company_group_server_id_36, t0.company_group_server_hash AS company_group_server_hash_37, t0.company_group_server_address AS company_group_server_address_38, t0.company_group_server_port AS company_group_server_port_39, t0.company_bin AS company_bin_40, t0.company_tin AS company_tin_41, t0.company_reg AS company_reg_42, t0.company_tl AS company_tl_43, t0.initiate_flag AS initiate_flag_44, t0.current_server_id AS current_server_id_45, t0.current_server_hash AS current_server_hash_46, t0.current_server_address AS current_server_address_47, t0.current_server_port AS current_server_port_48, t0.usage_valid_upto_date AS usage_valid_upto_date_49, t0.usage_valid_upto_date_ts AS usage_valid_upto_date_ts_50, t0.company_group_server_domain_full_link AS company_group_server_domain_full_link_51, t0.current_server_domain_full_link AS current_server_domain_full_link_52, t0.company_group_billing_info AS company_group_billing_info_53, t0.company_group_next_bill_date AS company_group_next_bill_date_54, t0.company_group_next_bill_date_ts AS company_group_next_bill_date_ts_55, t0.company_group_billing_frequency AS company_group_billing_frequency_56, t0.cash AS cash_57, t0.sales AS sales_58, t0.expense AS expense_59, t0.payable AS payable_60, t0.net_worth AS net_worth_61, t0.monthly_growth AS monthly_growth_62, t0.active AS active_63, t0.read_only_mode AS read_only_mode_64, t0.company_status AS company_status_65, t0.package_type AS package_type_66, t0.subscription_expiry AS subscription_expiry_67, t0.last_activity_at AS last_activity_at_68, t0.current_subscription_package_id AS current_subscription_package_id_69, t0.subscription_month AS subscription_month_70, t0.billing_amount AS billing_amount_71, t0.subscription_details AS subscription_details_72, t0.company_type AS company_type_73, t0.company_description AS company_description_74, t0.skip_in_web_flag AS skip_in_web_flag_75, t0.skip_in_app_flag AS skip_in_app_flag_76, t0.schema_update_pending_flag AS schema_update_pending_flag_77, t0.created_at AS created_at_78, t0.updated_at AS updated_at_79 FROM company_group t0 WHERE t0.active = 1;
|