Symfony Profiler

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.app_id = ?
LIMIT
  1

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.app_id = 51 LIMIT 1;

SELECT
  COUNT(*)
FROM
  information_schema.tables
WHERE
  table_schema = DATABASE()
  AND table_name = 'platform_setting'

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = DATABASE() AND table_name = 'platform_setting';

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id = ?
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id = 51 LIMIT 1;

SELECT
  setting_value
FROM
  platform_setting
WHERE
  name = ?
  AND app_id IS NULL
LIMIT
  1

SELECT setting_value FROM platform_setting WHERE name = 'subscription_enforcement_enabled' AND app_id IS NULL LIMIT 1;

SELECT
  *
FROM
  expense_invoice
WHERE
  party_head_id IN (2091)
  AND due_amount > 0
  AND approved = 1
ORDER BY
  expense_invoice_date ASC

SELECT * FROM expense_invoice WHERE party_head_id IN (2091) AND due_amount > 0 AND approved = 1 ORDER BY expense_invoice_date ASC;

SELECT
  t0.supplier_id AS supplier_id_1,
  t0.device_id AS device_id_2,
  t0.device_id_locked_flag AS device_id_locked_flag_3,
  t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_4,
  t0.username AS username_5,
  t0.password AS password_6,
  t0.app_id AS app_id_7,
  t0.global_user_id AS global_user_id_8,
  t0.email_verification_hash AS email_verification_hash_9,
  t0.phone_verification_hash AS phone_verification_hash_10,
  t0.otp_action_id AS otp_action_id_11,
  t0.otp AS otp_12,
  t0.otp_expire_ts AS otp_expire_ts_13,
  t0.trigger_reset_password AS trigger_reset_password_14,
  t0.forgot_password_token AS forgot_password_token_15,
  t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_16,
  t0.is_email_verified AS is_email_verified_17,
  t0.is_phone_verified AS is_phone_verified_18,
  t0.is_banned AS is_banned_19,
  t0.ban_expires AS ban_expires_20,
  t0.strike_count AS strike_count_21,
  t0.strike_threshold AS strike_threshold_22,
  t0.account_status AS account_status_23,
  t0.accounts_head_id AS accounts_head_id_24,
  t0.image AS image_25,
  t0.provision_flag AS provision_flag_26,
  t0.advance_head_id AS advance_head_id_27,
  t0.representative_emails AS representative_emails_28,
  t0.representative_emails_data AS representative_emails_data_29,
  t0.head_addition_pending_flag AS head_addition_pending_flag_30,
  t0.company_id AS company_id_31,
  t0.supplier_name AS supplier_name_32,
  t0.supplier_short_code AS supplier_short_code_33,
  t0.category AS category_34,
  t0.type AS type_35,
  t0.supplier_paid AS supplier_paid_36,
  t0.supplier_due AS supplier_due_37,
  t0.initial_opening_balance AS initial_opening_balance_38,
  t0.supplier_address AS supplier_address_39,
  t0.factory_address AS factory_address_40,
  t0.tagged_item_groups AS tagged_item_groups_41,
  t0.credit_limit AS credit_limit_42,
  t0.contact_person AS contact_person_43,
  t0.contact_number AS contact_number_44,
  t0.email AS email_45,
  t0.fax AS fax_46,
  t0.is_individual AS is_individual_47,
  t0.general_info_tin AS general_info_tin_48,
  t0.general_info_bin AS general_info_bin_49,
  t0.general_info_bank_name AS general_info_bank_name_50,
  t0.general_info_bank_ac_name AS general_info_bank_ac_name_51,
  t0.general_info_bank_ac_number AS general_info_bank_ac_number_52,
  t0.date_of_addition AS date_of_addition_53,
  t0.edit_login_id AS edit_login_id_54,
  t0.create_login_id AS create_login_id_55,
  t0.status AS status_56,
  t0.last_settings_updated_ts AS last_settings_updated_ts_57,
  t0.created_at AS created_at_58,
  t0.updated_at AS updated_at_59,
  t0.doc_booked_flag AS doc_booked_flag_60,
  t0.time_stamp_of_form AS time_stamp_of_form_61
FROM
  acc_suppliers t0
WHERE
  t0.status = ?

SELECT t0.supplier_id AS supplier_id_1, t0.device_id AS device_id_2, t0.device_id_locked_flag AS device_id_locked_flag_3, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_4, t0.username AS username_5, t0.password AS password_6, t0.app_id AS app_id_7, t0.global_user_id AS global_user_id_8, t0.email_verification_hash AS email_verification_hash_9, t0.phone_verification_hash AS phone_verification_hash_10, t0.otp_action_id AS otp_action_id_11, t0.otp AS otp_12, t0.otp_expire_ts AS otp_expire_ts_13, t0.trigger_reset_password AS trigger_reset_password_14, t0.forgot_password_token AS forgot_password_token_15, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_16, t0.is_email_verified AS is_email_verified_17, t0.is_phone_verified AS is_phone_verified_18, t0.is_banned AS is_banned_19, t0.ban_expires AS ban_expires_20, t0.strike_count AS strike_count_21, t0.strike_threshold AS strike_threshold_22, t0.account_status AS account_status_23, t0.accounts_head_id AS accounts_head_id_24, t0.image AS image_25, t0.provision_flag AS provision_flag_26, t0.advance_head_id AS advance_head_id_27, t0.representative_emails AS representative_emails_28, t0.representative_emails_data AS representative_emails_data_29, t0.head_addition_pending_flag AS head_addition_pending_flag_30, t0.company_id AS company_id_31, t0.supplier_name AS supplier_name_32, t0.supplier_short_code AS supplier_short_code_33, t0.category AS category_34, t0.type AS type_35, t0.supplier_paid AS supplier_paid_36, t0.supplier_due AS supplier_due_37, t0.initial_opening_balance AS initial_opening_balance_38, t0.supplier_address AS supplier_address_39, t0.factory_address AS factory_address_40, t0.tagged_item_groups AS tagged_item_groups_41, t0.credit_limit AS credit_limit_42, t0.contact_person AS contact_person_43, t0.contact_number AS contact_number_44, t0.email AS email_45, t0.fax AS fax_46, t0.is_individual AS is_individual_47, t0.general_info_tin AS general_info_tin_48, t0.general_info_bin AS general_info_bin_49, t0.general_info_bank_name AS general_info_bank_name_50, t0.general_info_bank_ac_name AS general_info_bank_ac_name_51, t0.general_info_bank_ac_number AS general_info_bank_ac_number_52, t0.date_of_addition AS date_of_addition_53, t0.edit_login_id AS edit_login_id_54, t0.create_login_id AS create_login_id_55, t0.status AS status_56, t0.last_settings_updated_ts AS last_settings_updated_ts_57, t0.created_at AS created_at_58, t0.updated_at AS updated_at_59, t0.doc_booked_flag AS doc_booked_flag_60, t0.time_stamp_of_form AS time_stamp_of_form_61 FROM acc_suppliers t0 WHERE t0.status = 1;

SELECT
  *
FROM
  purchase_order
WHERE
  supplier_head_id IN (2091)
  AND (
    po_amount - invoice_amount - advance_amount
  ) > 0
ORDER BY
  purchase_order_date ASC

SELECT * FROM purchase_order WHERE supplier_head_id IN (2091) AND (po_amount-invoice_amount-advance_amount) > 0 ORDER BY purchase_order_date ASC;

SELECT
  *
FROM
  purchase_invoice
WHERE
  supplier_head_id IN (2091)
  AND due_amount > 0
ORDER BY
  purchase_invoice_date ASC

SELECT * FROM purchase_invoice WHERE supplier_head_id IN (2091) AND due_amount > 0 ORDER BY purchase_invoice_date ASC;

SELECT
  data
FROM
  acc_setting
WHERE
  name = 'cors_extra_origins'
ORDER BY
  id DESC
LIMIT
  1

SELECT data FROM acc_setting WHERE name = 'cors_extra_origins' ORDER BY id DESC LIMIT 1;

SELECT
  *
FROM
  acc_accounts_head
WHERE
  accounts_head_id IN (2091)

SELECT * FROM acc_accounts_head WHERE accounts_head_id IN (2091);