Symfony Profiler

SELECT 
  acc_accounts_head.name, 
  acc_accounts_head.opening_balance, 
  acc_accounts_head.current_balance, 
  acc_accounts_head.current_balance_reconciled, 
  acc_accounts_head.path_tree, 
  acc_accounts_head.head_nature, 
  acc_accounts_head.cc_enabled, 
  acc_accounts_head.accounts_head_id, 
  acc_accounts_head.parent_id, 
  acc_accounts_head.type, 
  acc_accounts_head.advance_of, 
  b.name parent_name 
FROM 
  acc_accounts_head 
  left join acc_accounts_head as b on acc_accounts_head.parent_id = b.accounts_head_id 
WHERE 
  acc_accounts_head.company_id = 1 
  AND acc_accounts_head.parent_id != 0 
  AND acc_accounts_head.accounts_head_id NOT IN (
    0, 1, 3, 94, 95, 4, 5, 89, 90, 110, 99, 100, 
    101, 102, 103, 104, 105, 106, 107, 108, 
    139, 109, 112, 176, 177, 96, 114, 204, 
    129, 130, 121, 123, 234, 236, 235, 245, 
    241, 246, 243, 242, 244, 117, 337, 132, 
    680, 225, 892, 1122, 180, 1139, 1110, 
    134, 170, 118, 227, 181, 205, 956, 111, 
    340, 1310, 119, 1352, 907, 115, 228, 
    131, 120, 1420, 1423
  ) 
ORDER BY 
  name ASC

SELECT acc_accounts_head.name,
acc_accounts_head.opening_balance,
acc_accounts_head.current_balance,
acc_accounts_head.current_balance_reconciled,
acc_accounts_head.path_tree,
acc_accounts_head.head_nature,
 acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name  parent_name FROM acc_accounts_head left join acc_accounts_head as b
on acc_accounts_head.parent_id=b.accounts_head_id WHERE  acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423) ORDER BY name ASC;

select 
  * 
from 
  acc_accounts_head 
  left outer join (
    select 
      accounts_head_id opening_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) opening_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) opening_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date < '2024-11-01 00:00:00' 
    GROUP BY 
      accounts_head_id
  ) opening_add_table on opening_add_table.opening_head_id = acc_accounts_head.accounts_head_id 
  left outer join (
    select 
      accounts_head_id dur_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) dur_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) dur_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date >= '2024-11-01' 
      AND acc_transaction_details.ledger_hit_date <= '2024-11-01 23:59:59.999' 
    GROUP BY 
      accounts_head_id
  ) dur_balance_table on dur_balance_table.dur_head_id = acc_accounts_head.accounts_head_id 
where 
  acc_accounts_head.accounts_head_id not in(
    0, 1, 3, 94, 95, 4, 5, 89, 90, 110, 99, 100, 
    101, 102, 103, 104, 105, 106, 107, 108, 
    139, 109, 112, 176, 177, 96, 114, 204, 
    129, 130, 121, 123, 234, 236, 235, 245, 
    241, 246, 243, 242, 244, 117, 337, 132, 
    680, 225, 892, 1122, 180, 1139, 1110, 
    134, 170, 118, 227, 181, 205, 956, 111, 
    340, 1310, 119, 1352, 907, 115, 228, 
    131, 120, 1420, 1423
  ) 
  AND acc_accounts_head.type = 'exp'

select * from  acc_accounts_head left outer join (select accounts_head_id opening_head_id,
SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details
where  acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date < '2024-11-01 00:00:00'  GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id,

SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details
where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date >= '2024-11-01'  AND acc_transaction_details.ledger_hit_date <= '2024-11-01 23:59:59.999'  GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id  where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423)  AND acc_accounts_head.type ='exp'  ;

select 
  * 
from 
  acc_accounts_head 
  left outer join (
    select 
      accounts_head_id opening_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) opening_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) opening_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date < '2024-09-01 00:00:00' 
    GROUP BY 
      accounts_head_id
  ) opening_add_table on opening_add_table.opening_head_id = acc_accounts_head.accounts_head_id 
  left outer join (
    select 
      accounts_head_id dur_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) dur_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) dur_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date >= '2024-09-01' 
      AND acc_transaction_details.ledger_hit_date <= '2024-09-30 23:59:59.999' 
    GROUP BY 
      accounts_head_id
  ) dur_balance_table on dur_balance_table.dur_head_id = acc_accounts_head.accounts_head_id 
where 
  acc_accounts_head.accounts_head_id not in(
    0, 1, 3, 94, 95, 4, 5, 89, 90, 110, 99, 100, 
    101, 102, 103, 104, 105, 106, 107, 108, 
    139, 109, 112, 176, 177, 96, 114, 204, 
    129, 130, 121, 123, 234, 236, 235, 245, 
    241, 246, 243, 242, 244, 117, 337, 132, 
    680, 225, 892, 1122, 180, 1139, 1110, 
    134, 170, 118, 227, 181, 205, 956, 111, 
    340, 1310, 119, 1352, 907, 115, 228, 
    131, 120, 1420, 1423
  ) 
  AND acc_accounts_head.type = 'exp'

select * from  acc_accounts_head left outer join (select accounts_head_id opening_head_id,
SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details
where  acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date < '2024-09-01 00:00:00'  GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id,

SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details
where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date >= '2024-09-01'  AND acc_transaction_details.ledger_hit_date <= '2024-09-30 23:59:59.999'  GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id  where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423)  AND acc_accounts_head.type ='exp'  ;

select 
  * 
from 
  acc_accounts_head 
  left outer join (
    select 
      accounts_head_id opening_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) opening_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) opening_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date < '2024-10-01 00:00:00' 
    GROUP BY 
      accounts_head_id
  ) opening_add_table on opening_add_table.opening_head_id = acc_accounts_head.accounts_head_id 
  left outer join (
    select 
      accounts_head_id dur_head_id, 
      SUM(
        CASE WHEN position = 'dr' THEN amount ELSE 0 END
      ) dur_balance_debit, 
      SUM(
        CASE WHEN position = 'cr' THEN amount ELSE 0 END
      ) dur_balance_credit 
    from 
      acc_transaction_details 
    where 
      acc_transaction_details.approved = 1 
      AND acc_transaction_details.ledger_hit = 1 
      AND acc_transaction_details.ledger_hit_date >= '2024-10-01' 
      AND acc_transaction_details.ledger_hit_date <= '2024-10-31 23:59:59.999' 
    GROUP BY 
      accounts_head_id
  ) dur_balance_table on dur_balance_table.dur_head_id = acc_accounts_head.accounts_head_id 
where 
  acc_accounts_head.accounts_head_id not in(
    0, 1, 3, 94, 95, 4, 5, 89, 90, 110, 99, 100, 
    101, 102, 103, 104, 105, 106, 107, 108, 
    139, 109, 112, 176, 177, 96, 114, 204, 
    129, 130, 121, 123, 234, 236, 235, 245, 
    241, 246, 243, 242, 244, 117, 337, 132, 
    680, 225, 892, 1122, 180, 1139, 1110, 
    134, 170, 118, 227, 181, 205, 956, 111, 
    340, 1310, 119, 1352, 907, 115, 228, 
    131, 120, 1420, 1423
  ) 
  AND acc_accounts_head.type = 'exp'

select * from  acc_accounts_head left outer join (select accounts_head_id opening_head_id,
SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) opening_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) opening_balance_credit from acc_transaction_details
where  acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date < '2024-10-01 00:00:00'  GROUP BY accounts_head_id) opening_add_table on opening_add_table.opening_head_id =acc_accounts_head.accounts_head_id left outer join (select accounts_head_id dur_head_id,

SUM(CASE WHEN position = 'dr' THEN amount ELSE 0 END) dur_balance_debit,
SUM(CASE WHEN position = 'cr' THEN amount ELSE 0 END) dur_balance_credit from acc_transaction_details
where acc_transaction_details.approved = 1 AND acc_transaction_details.ledger_hit=1  AND acc_transaction_details.ledger_hit_date >= '2024-10-01'  AND acc_transaction_details.ledger_hit_date <= '2024-10-31 23:59:59.999'  GROUP BY accounts_head_id) dur_balance_table on dur_balance_table.dur_head_id =acc_accounts_head.accounts_head_id  where acc_accounts_head.accounts_head_id not in(0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423)  AND acc_accounts_head.type ='exp'  ;

SELECT 
  t0.check_id AS check_id_1, 
  t0.accounts_head_id AS accounts_head_id_2, 
  t0.voucher_id AS voucher_id_3, 
  t0.rec_accounts_head_id AS rec_accounts_head_id_4, 
  t0.rec_accounts_head_id_list AS rec_accounts_head_id_list_5, 
  t0.acc_number AS acc_number_6, 
  t0.check_number AS check_number_7, 
  t0.check_book_number AS check_book_number_8, 
  t0.check_narration AS check_narration_9, 
  t0.check_amount AS check_amount_10, 
  t0.active AS active_11, 
  t0.status AS status_12, 
  t0.assigned AS assigned_13, 
  t0.printed AS printed_14, 
  t0.security_check AS security_check_15, 
  t0.destroyed AS destroyed_16, 
  t0.type AS type_17, 
  t0.details AS details_18, 
  t0.assigned_date AS assigned_date_19, 
  t0.recon_date AS recon_date_20, 
  t0.check_date AS check_date_21, 
  t0.transaction_date AS transaction_date_22, 
  t0.ledger_hit_date AS ledger_hit_date_23, 
  t0.format_id AS format_id_24, 
  t0.company_id AS company_id_25, 
  t0.create_login_id AS create_login_id_26, 
  t0.edit_login_id AS edit_login_id_27, 
  t0.created_at AS created_at_28, 
  t0.updated_at AS updated_at_29, 
  t0.doc_booked_flag AS doc_booked_flag_30, 
  t0.time_stamp_of_form AS time_stamp_of_form_31 
FROM 
  acc_check t0 
WHERE 
  t0.assigned = ? 
ORDER BY 
  t0.accounts_head_id DESC, 
  t0.check_number DESC

SELECT t0.check_id AS check_id_1, t0.accounts_head_id AS accounts_head_id_2, t0.voucher_id AS voucher_id_3, t0.rec_accounts_head_id AS rec_accounts_head_id_4, t0.rec_accounts_head_id_list AS rec_accounts_head_id_list_5, t0.acc_number AS acc_number_6, t0.check_number AS check_number_7, t0.check_book_number AS check_book_number_8, t0.check_narration AS check_narration_9, t0.check_amount AS check_amount_10, t0.active AS active_11, t0.status AS status_12, t0.assigned AS assigned_13, t0.printed AS printed_14, t0.security_check AS security_check_15, t0.destroyed AS destroyed_16, t0.type AS type_17, t0.details AS details_18, t0.assigned_date AS assigned_date_19, t0.recon_date AS recon_date_20, t0.check_date AS check_date_21, t0.transaction_date AS transaction_date_22, t0.ledger_hit_date AS ledger_hit_date_23, t0.format_id AS format_id_24, t0.company_id AS company_id_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM acc_check t0 WHERE t0.assigned = 0 ORDER BY t0.accounts_head_id DESC, t0.check_number DESC;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.image AS image_3, 
  t0.app_id AS app_id_4, 
  t0.country_id AS country_id_5, 
  t0.company_hash AS company_hash_6, 
  t0.company_unique_code AS company_unique_code_7, 
  t0.enabled_module_id_list AS enabled_module_id_list_8, 
  t0.company_type AS company_type_9, 
  t0.usage_valid_upto_date AS usage_valid_upto_date_10, 
  t0.post_dated_job_active AS post_dated_job_active_11, 
  t0.address AS address_12, 
  t0.shipping_address AS shipping_address_13, 
  t0.sms_notification_enabled AS sms_notification_enabled_14, 
  t0.sms_settings AS sms_settings_15, 
  t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_16, 
  t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_17, 
  t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_18, 
  t0.dark_vibrant AS dark_vibrant_19, 
  t0.light_vibrant AS light_vibrant_20, 
  t0.vibrant AS vibrant_21, 
  t0.billing_address AS billing_address_22, 
  t0.motto AS motto_23, 
  t0.invoice_footer AS invoice_footer_24, 
  t0.general_footer AS general_footer_25, 
  t0.company_bin AS company_bin_26, 
  t0.company_tin AS company_tin_27, 
  t0.company_reg AS company_reg_28, 
  t0.company_tl AS company_tl_29, 
  t0.user_allowed AS user_allowed_30, 
  t0.user_allocated AS user_allocated_31, 
  t0.user_remaining AS user_remaining_32, 
  t0.me_str AS me_str_33, 
  t0.cash AS cash_34, 
  t0.bank AS bank_35, 
  t0.sales AS sales_36, 
  t0.asset AS asset_37, 
  t0.liability AS liability_38, 
  t0.expense AS expense_39, 
  t0.revenue AS revenue_40, 
  t0.payable AS payable_41, 
  t0.receivable AS receivable_42, 
  t0.net_worth AS net_worth_43, 
  t0.monthly_growth AS monthly_growth_44, 
  t0.wacc AS wacc_45, 
  t0.active AS active_46, 
  t0.created_at AS created_at_47, 
  t0.updated_at AS updated_at_48, 
  t0.doc_booked_flag AS doc_booked_flag_49, 
  t0.time_stamp_of_form AS time_stamp_of_form_50 
FROM 
  company t0 
WHERE 
  t0.active = ? 
  AND t0.id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.app_id AS app_id_4, t0.country_id AS country_id_5, t0.company_hash AS company_hash_6, t0.company_unique_code AS company_unique_code_7, t0.enabled_module_id_list AS enabled_module_id_list_8, t0.company_type AS company_type_9, t0.usage_valid_upto_date AS usage_valid_upto_date_10, t0.post_dated_job_active AS post_dated_job_active_11, t0.address AS address_12, t0.shipping_address AS shipping_address_13, t0.sms_notification_enabled AS sms_notification_enabled_14, t0.sms_settings AS sms_settings_15, t0.lock_device_id_on_first_login_user AS lock_device_id_on_first_login_user_16, t0.lock_device_id_on_first_login_supplier AS lock_device_id_on_first_login_supplier_17, t0.lock_device_id_on_first_login_client AS lock_device_id_on_first_login_client_18, t0.dark_vibrant AS dark_vibrant_19, t0.light_vibrant AS light_vibrant_20, t0.vibrant AS vibrant_21, t0.billing_address AS billing_address_22, t0.motto AS motto_23, t0.invoice_footer AS invoice_footer_24, t0.general_footer AS general_footer_25, t0.company_bin AS company_bin_26, t0.company_tin AS company_tin_27, t0.company_reg AS company_reg_28, t0.company_tl AS company_tl_29, t0.user_allowed AS user_allowed_30, t0.user_allocated AS user_allocated_31, t0.user_remaining AS user_remaining_32, t0.me_str AS me_str_33, t0.cash AS cash_34, t0.bank AS bank_35, t0.sales AS sales_36, t0.asset AS asset_37, t0.liability AS liability_38, t0.expense AS expense_39, t0.revenue AS revenue_40, t0.payable AS payable_41, t0.receivable AS receivable_42, t0.net_worth AS net_worth_43, t0.monthly_growth AS monthly_growth_44, t0.wacc AS wacc_45, t0.active AS active_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.doc_booked_flag AS doc_booked_flag_49, t0.time_stamp_of_form AS time_stamp_of_form_50 FROM company t0 WHERE t0.active = 1 AND t0.id = 1 LIMIT 1;

SELECT 
  sales_order.*, 
  acc_clients.* 
FROM 
  sales_order 
  JOIN acc_clients on acc_clients.client_id = sales_order.client_id 
WHERE 
  sales_order.status = 1 
  AND sales_order.approved = 1 
  AND sales_order.company_id = 1 
ORDER BY 
  sales_order.sales_order_date DESC, 
  sales_order.so_amount DESC 
LIMIT 
  5

SELECT sales_order.*, acc_clients.*
                          FROM sales_order
                            JOIN acc_clients on acc_clients.client_id= sales_order.client_id
                               WHERE sales_order.status=1 AND sales_order.approved=1 AND sales_order.company_id=1
                                        ORDER BY sales_order.sales_order_date DESC, sales_order.so_amount DESC LIMIT  5;

SELECT 
  t0.id AS id_1, 
  t0.name AS name_2, 
  t0.data AS data_3, 
  t0.company_id AS company_id_4, 
  t0.create_login_id AS create_login_id_5, 
  t0.edit_login_id AS edit_login_id_6, 
  t0.lock_flag AS lock_flag_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.doc_booked_flag AS doc_booked_flag_10, 
  t0.time_stamp_of_form AS time_stamp_of_form_11 
FROM 
  acc_setting t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.data AS data_3, t0.company_id AS company_id_4, t0.create_login_id AS create_login_id_5, t0.edit_login_id AS edit_login_id_6, t0.lock_flag AS lock_flag_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM acc_setting t0 WHERE t0.name = 'payment_voucher_credit_parents' LIMIT 1;

SELECT 
  t0.accounts_head_id AS accounts_head_id_1, 
  t0.parent_id AS parent_id_2, 
  t0.replication_head_id AS replication_head_id_3, 
  t0.replicate AS replicate_4, 
  t0.advance_tagged AS advance_tagged_5, 
  t0.advance_of AS advance_of_6, 
  t0.name AS name_7, 
  t0.narration_on_check AS narration_on_check_8, 
  t0.path_tree AS path_tree_9, 
  t0.head_level AS head_level_10, 
  t0.type AS type_11, 
  t0.head_nature AS head_nature_12, 
  t0.cc_enabled AS cc_enabled_13, 
  t0.opening_balance AS opening_balance_14, 
  t0.current_balance AS current_balance_15, 
  t0.current_balance_reconciled AS current_balance_reconciled_16, 
  t0.marker_hash AS marker_hash_17, 
  t0.cost_centre_types AS cost_centre_types_18, 
  t0.company_id AS company_id_19, 
  t0.ledger_head_code AS ledger_head_code_20, 
  t0.edit_flag AS edit_flag_21, 
  t0.delete_flag AS delete_flag_22, 
  t0.lock_flag AS lock_flag_23, 
  t0.refresh_flag AS refresh_flag_24, 
  t0.disabled_flag AS disabled_flag_25, 
  t0.create_login_id AS create_login_id_26, 
  t0.edit_login_id AS edit_login_id_27, 
  t0.created_at AS created_at_28, 
  t0.updated_at AS updated_at_29 
FROM 
  acc_accounts_head t0

SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0;

SELECT 
  count(sales_order.sales_order_id) so_count 
FROM 
  sales_order 
WHERE 
  sales_order.status = 1 
  AND sales_order.approved = 1 
  AND sales_order.company_id = 1

SELECT count(sales_order.sales_order_id) so_count
                          FROM sales_order

                               WHERE sales_order.status=1 AND sales_order.approved=1 AND sales_order.company_id=1;

SELECT 
  DISTINCT acc_accounts_head.parent_id 
FROM 
  acc_accounts_head 
where 
  company_id = 1

SELECT DISTINCT acc_accounts_head.parent_id FROM acc_accounts_head where company_id=1 ;

SELECT 
  * 
FROM 
  acc_cost_centre 
WHERE 
  1 
ORDER BY 
  name ASC

SELECT * FROM acc_cost_centre WHERE 1 ORDER BY name ASC;

select 
  * 
from 
  fiscal_closing 
where 
  closing_end_date < '2024-11-01 00:00:00' 
Order by 
  closing_end_date desc 
limit 
  1

select * from fiscal_closing where closing_end_date < '2024-11-01 00:00:00'  Order by closing_end_date desc limit 1;

SELECT 
  t0.accounts_head_id AS accounts_head_id_1, 
  t0.parent_id AS parent_id_2, 
  t0.replication_head_id AS replication_head_id_3, 
  t0.replicate AS replicate_4, 
  t0.advance_tagged AS advance_tagged_5, 
  t0.advance_of AS advance_of_6, 
  t0.name AS name_7, 
  t0.narration_on_check AS narration_on_check_8, 
  t0.path_tree AS path_tree_9, 
  t0.head_level AS head_level_10, 
  t0.type AS type_11, 
  t0.head_nature AS head_nature_12, 
  t0.cc_enabled AS cc_enabled_13, 
  t0.opening_balance AS opening_balance_14, 
  t0.current_balance AS current_balance_15, 
  t0.current_balance_reconciled AS current_balance_reconciled_16, 
  t0.marker_hash AS marker_hash_17, 
  t0.cost_centre_types AS cost_centre_types_18, 
  t0.company_id AS company_id_19, 
  t0.ledger_head_code AS ledger_head_code_20, 
  t0.edit_flag AS edit_flag_21, 
  t0.delete_flag AS delete_flag_22, 
  t0.lock_flag AS lock_flag_23, 
  t0.refresh_flag AS refresh_flag_24, 
  t0.disabled_flag AS disabled_flag_25, 
  t0.create_login_id AS create_login_id_26, 
  t0.edit_login_id AS edit_login_id_27, 
  t0.created_at AS created_at_28, 
  t0.updated_at AS updated_at_29 
FROM 
  acc_accounts_head t0 
WHERE 
  (
    t0.parent_id IN (?) 
    OR t0.parent_id IS NULL
  ) 
  AND t0.company_id = ?

SELECT t0.accounts_head_id AS accounts_head_id_1, t0.parent_id AS parent_id_2, t0.replication_head_id AS replication_head_id_3, t0.replicate AS replicate_4, t0.advance_tagged AS advance_tagged_5, t0.advance_of AS advance_of_6, t0.name AS name_7, t0.narration_on_check AS narration_on_check_8, t0.path_tree AS path_tree_9, t0.head_level AS head_level_10, t0.type AS type_11, t0.head_nature AS head_nature_12, t0.cc_enabled AS cc_enabled_13, t0.opening_balance AS opening_balance_14, t0.current_balance AS current_balance_15, t0.current_balance_reconciled AS current_balance_reconciled_16, t0.marker_hash AS marker_hash_17, t0.cost_centre_types AS cost_centre_types_18, t0.company_id AS company_id_19, t0.ledger_head_code AS ledger_head_code_20, t0.edit_flag AS edit_flag_21, t0.delete_flag AS delete_flag_22, t0.lock_flag AS lock_flag_23, t0.refresh_flag AS refresh_flag_24, t0.disabled_flag AS disabled_flag_25, t0.create_login_id AS create_login_id_26, t0.edit_login_id AS edit_login_id_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM acc_accounts_head t0 WHERE (t0.parent_id IN (0, NULL) OR t0.parent_id IS NULL) AND t0.company_id = 1;

SELECT 
  acc_accounts_head.name, 
  acc_accounts_head.opening_balance, 
  acc_accounts_head.current_balance, 
  acc_accounts_head.current_balance_reconciled, 
  acc_accounts_head.path_tree, 
  acc_accounts_head.head_nature, 
  acc_accounts_head.cc_enabled, 
  acc_accounts_head.accounts_head_id, 
  acc_accounts_head.parent_id, 
  acc_accounts_head.type, 
  acc_accounts_head.advance_of, 
  b.name parent_name 
FROM 
  acc_accounts_head 
  left join acc_accounts_head as b on acc_accounts_head.parent_id = b.accounts_head_id 
WHERE 
  acc_accounts_head.company_id = 1 
  AND acc_accounts_head.parent_id != 0 
  AND acc_accounts_head.accounts_head_id NOT IN (
    0, 1, 3, 94, 95, 4, 5, 89, 90, 110, 99, 100, 
    101, 102, 103, 104, 105, 106, 107, 108, 
    139, 109, 112, 176, 177, 96, 114, 204, 
    129, 130, 121, 123, 234, 236, 235, 245, 
    241, 246, 243, 242, 244, 117, 337, 132, 
    680, 225, 892, 1122, 180, 1139, 1110, 
    134, 170, 118, 227, 181, 205, 956, 111, 
    340, 1310, 119, 1352, 907, 115, 228, 
    131, 120, 1420, 1423
  ) 
  AND (
    acc_accounts_head.path_tree like '%/5/%' 
    OR acc_accounts_head.path_tree like '%/1249/%'
  ) 
ORDER BY 
  name ASC

SELECT acc_accounts_head.name,
acc_accounts_head.opening_balance,
acc_accounts_head.current_balance,
acc_accounts_head.current_balance_reconciled,
acc_accounts_head.path_tree,
acc_accounts_head.head_nature,
 acc_accounts_head.cc_enabled, acc_accounts_head.accounts_head_id, acc_accounts_head.parent_id, acc_accounts_head.type, acc_accounts_head.advance_of, b.name  parent_name FROM acc_accounts_head left join acc_accounts_head as b
on acc_accounts_head.parent_id=b.accounts_head_id WHERE  acc_accounts_head.company_id=1 AND acc_accounts_head.parent_id !=0 AND acc_accounts_head.accounts_head_id NOT IN (0,1,3,94,95,4,5,89,90,110,99,100,101,102,103,104,105,106,107,108,139,109,112,176,177,96,114,204,129,130,121,123,234,236,235,245,241,246,243,242,244,117,337,132,680,225,892,1122,180,1139,1110,134,170,118,227,181,205,956,111,340,1310,119,1352,907,115,228,131,120,1420,1423)AND (acc_accounts_head.path_tree like '%/5/%'  OR acc_accounts_head.path_tree like '%/1249/%'  )  ORDER BY name ASC;

SELECT 
  t0.id AS id_1, 
  t0.date AS date_2, 
  t0.cash AS cash_3, 
  t0.bank AS bank_4, 
  t0.cash_position AS cash_position_5, 
  t0.bank_position AS bank_position_6, 
  t0.asset AS asset_7, 
  t0.liability AS liability_8, 
  t0.asset_position AS asset_position_9, 
  t0.liability_position AS liability_position_10, 
  t0.revenue AS revenue_11, 
  t0.expense AS expense_12, 
  t0.revenue_position AS revenue_position_13, 
  t0.expense_position AS expense_position_14, 
  t0.receivable AS receivable_15, 
  t0.payable AS payable_16, 
  t0.receivable_position AS receivable_position_17, 
  t0.payable_position AS payable_position_18, 
  t0.loan AS loan_19, 
  t0.net_worth AS net_worth_20, 
  t0.monthly_growth AS monthly_growth_21, 
  t0.company_id AS company_id_22, 
  t0.branch_id AS branch_id_23 
FROM 
  monthly_summary t0 
WHERE 
  t0.company_id = ? 
  AND (
    t0.branch_id IN (?) 
    OR t0.branch_id IS NULL
  ) 
ORDER BY 
  t0.date DESC 
LIMIT 
  11