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 IS NULL
LIMIT
  1

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

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
  t0.transaction_id AS transaction_id_1,
  t0.transaction_date AS transaction_date_2,
  t0.ledger_hit_date AS ledger_hit_date_3,
  t0.entity_doc_hash AS entity_doc_hash_4,
  t0.entity AS entity_5,
  t0.entity_id AS entity_id_6,
  t0.ref_transaction AS ref_transaction_7,
  t0.ref_doc AS ref_doc_8,
  t0.receipt_image AS receipt_image_9,
  t0.check_allowed AS check_allowed_10,
  t0.check_id_list AS check_id_list_11,
  t0.pending_reconciliation_id_list AS pending_reconciliation_id_list_12,
  t0.check_locked AS check_locked_13,
  t0.document_type AS document_type_14,
  t0.document_hash AS document_hash_15,
  t0.type_hash AS type_hash_16,
  t0.prefix_hash AS prefix_hash_17,
  t0.assoc_hash AS assoc_hash_18,
  t0.number_hash AS number_hash_19,
  t0.company_id AS company_id_20,
  t0.branch_id AS branch_id_21,
  t0.transaction_amount AS transaction_amount_22,
  t0.transaction_amount_currency AS transaction_amount_currency_23,
  t0.currency AS currency_24,
  t0.currency_multiply AS currency_multiply_25,
  t0.currency_multiply_rate AS currency_multiply_rate_26,
  t0.approved AS approved_27,
  t0.status AS status_28,
  t0.provisional AS provisional_29,
  t0.sms_notification_pending_flag AS sms_notification_pending_flag_30,
  t0.email_notification_pending_flag AS email_notification_pending_flag_31,
  t0.marker_hash AS marker_hash_32,
  t0.auto_created AS auto_created_33,
  t0.ledger_hit AS ledger_hit_34,
  t0.edit_flag AS edit_flag_35,
  t0.doc_booked_flag AS doc_booked_flag_36,
  t0.time_stamp_of_form AS time_stamp_of_form_37,
  t0.delete_flag AS delete_flag_38,
  t0.lock_flag AS lock_flag_39,
  t0.refresh_flag AS refresh_flag_40,
  t0.disabled_flag AS disabled_flag_41,
  t0.project_id AS project_id_42,
  t0.description AS description_43,
  t0.files AS files_44,
  t0.block_chain_unique_id AS block_chain_unique_id_45,
  t0.pr_method AS pr_method_46,
  t0.pr_reference AS pr_reference_47,
  t0.check_number AS check_number_48,
  t0.created_login_id AS created_login_id_49,
  t0.edited_login_id AS edited_login_id_50,
  t0.created_user_id AS created_user_id_51,
  t0.edited_user_id AS edited_user_id_52,
  t0.created_sig_id AS created_sig_id_53,
  t0.edited_sig_id AS edited_sig_id_54,
  t0.receiver_signature_id AS receiver_signature_id_55,
  t0.acknowledgement_completed_flag AS acknowledgement_completed_flag_56,
  t0.last_modified_date AS last_modified_date_57,
  t0.last_mongolog_id AS last_mongolog_id_58,
  t0.created_at AS created_at_59,
  t0.updated_at AS updated_at_60,
  t0.approved_by AS approved_by_61
FROM
  acc_transactions t0
WHERE
  t0.time_stamp_of_form = ?
  AND t0.doc_booked_flag = ?
ORDER BY
  t0.number_hash DESC
LIMIT
  1

SELECT t0.transaction_id AS transaction_id_1, t0.transaction_date AS transaction_date_2, t0.ledger_hit_date AS ledger_hit_date_3, t0.entity_doc_hash AS entity_doc_hash_4, t0.entity AS entity_5, t0.entity_id AS entity_id_6, t0.ref_transaction AS ref_transaction_7, t0.ref_doc AS ref_doc_8, t0.receipt_image AS receipt_image_9, t0.check_allowed AS check_allowed_10, t0.check_id_list AS check_id_list_11, t0.pending_reconciliation_id_list AS pending_reconciliation_id_list_12, t0.check_locked AS check_locked_13, t0.document_type AS document_type_14, t0.document_hash AS document_hash_15, t0.type_hash AS type_hash_16, t0.prefix_hash AS prefix_hash_17, t0.assoc_hash AS assoc_hash_18, t0.number_hash AS number_hash_19, t0.company_id AS company_id_20, t0.branch_id AS branch_id_21, t0.transaction_amount AS transaction_amount_22, t0.transaction_amount_currency AS transaction_amount_currency_23, t0.currency AS currency_24, t0.currency_multiply AS currency_multiply_25, t0.currency_multiply_rate AS currency_multiply_rate_26, t0.approved AS approved_27, t0.status AS status_28, t0.provisional AS provisional_29, t0.sms_notification_pending_flag AS sms_notification_pending_flag_30, t0.email_notification_pending_flag AS email_notification_pending_flag_31, t0.marker_hash AS marker_hash_32, t0.auto_created AS auto_created_33, t0.ledger_hit AS ledger_hit_34, t0.edit_flag AS edit_flag_35, t0.doc_booked_flag AS doc_booked_flag_36, t0.time_stamp_of_form AS time_stamp_of_form_37, t0.delete_flag AS delete_flag_38, t0.lock_flag AS lock_flag_39, t0.refresh_flag AS refresh_flag_40, t0.disabled_flag AS disabled_flag_41, t0.project_id AS project_id_42, t0.description AS description_43, t0.files AS files_44, t0.block_chain_unique_id AS block_chain_unique_id_45, t0.pr_method AS pr_method_46, t0.pr_reference AS pr_reference_47, t0.check_number AS check_number_48, t0.created_login_id AS created_login_id_49, t0.edited_login_id AS edited_login_id_50, t0.created_user_id AS created_user_id_51, t0.edited_user_id AS edited_user_id_52, t0.created_sig_id AS created_sig_id_53, t0.edited_sig_id AS edited_sig_id_54, t0.receiver_signature_id AS receiver_signature_id_55, t0.acknowledgement_completed_flag AS acknowledgement_completed_flag_56, t0.last_modified_date AS last_modified_date_57, t0.last_mongolog_id AS last_mongolog_id_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60, t0.approved_by AS approved_by_61 FROM acc_transactions t0 WHERE t0.time_stamp_of_form = '1785837674' AND t0.doc_booked_flag = 1 ORDER BY t0.number_hash DESC LIMIT 1;

SELECT
  t0.transaction_id AS transaction_id_1,
  t0.transaction_date AS transaction_date_2,
  t0.ledger_hit_date AS ledger_hit_date_3,
  t0.entity_doc_hash AS entity_doc_hash_4,
  t0.entity AS entity_5,
  t0.entity_id AS entity_id_6,
  t0.ref_transaction AS ref_transaction_7,
  t0.ref_doc AS ref_doc_8,
  t0.receipt_image AS receipt_image_9,
  t0.check_allowed AS check_allowed_10,
  t0.check_id_list AS check_id_list_11,
  t0.pending_reconciliation_id_list AS pending_reconciliation_id_list_12,
  t0.check_locked AS check_locked_13,
  t0.document_type AS document_type_14,
  t0.document_hash AS document_hash_15,
  t0.type_hash AS type_hash_16,
  t0.prefix_hash AS prefix_hash_17,
  t0.assoc_hash AS assoc_hash_18,
  t0.number_hash AS number_hash_19,
  t0.company_id AS company_id_20,
  t0.branch_id AS branch_id_21,
  t0.transaction_amount AS transaction_amount_22,
  t0.transaction_amount_currency AS transaction_amount_currency_23,
  t0.currency AS currency_24,
  t0.currency_multiply AS currency_multiply_25,
  t0.currency_multiply_rate AS currency_multiply_rate_26,
  t0.approved AS approved_27,
  t0.status AS status_28,
  t0.provisional AS provisional_29,
  t0.sms_notification_pending_flag AS sms_notification_pending_flag_30,
  t0.email_notification_pending_flag AS email_notification_pending_flag_31,
  t0.marker_hash AS marker_hash_32,
  t0.auto_created AS auto_created_33,
  t0.ledger_hit AS ledger_hit_34,
  t0.edit_flag AS edit_flag_35,
  t0.doc_booked_flag AS doc_booked_flag_36,
  t0.time_stamp_of_form AS time_stamp_of_form_37,
  t0.delete_flag AS delete_flag_38,
  t0.lock_flag AS lock_flag_39,
  t0.refresh_flag AS refresh_flag_40,
  t0.disabled_flag AS disabled_flag_41,
  t0.project_id AS project_id_42,
  t0.description AS description_43,
  t0.files AS files_44,
  t0.block_chain_unique_id AS block_chain_unique_id_45,
  t0.pr_method AS pr_method_46,
  t0.pr_reference AS pr_reference_47,
  t0.check_number AS check_number_48,
  t0.created_login_id AS created_login_id_49,
  t0.edited_login_id AS edited_login_id_50,
  t0.created_user_id AS created_user_id_51,
  t0.edited_user_id AS edited_user_id_52,
  t0.created_sig_id AS created_sig_id_53,
  t0.edited_sig_id AS edited_sig_id_54,
  t0.receiver_signature_id AS receiver_signature_id_55,
  t0.acknowledgement_completed_flag AS acknowledgement_completed_flag_56,
  t0.last_modified_date AS last_modified_date_57,
  t0.last_mongolog_id AS last_mongolog_id_58,
  t0.created_at AS created_at_59,
  t0.updated_at AS updated_at_60,
  t0.approved_by AS approved_by_61
FROM
  acc_transactions t0
WHERE
  t0.type_hash = ?
  AND t0.prefix_hash = ?
  AND t0.assoc_hash = ?
ORDER BY
  t0.number_hash DESC
LIMIT
  1

SELECT t0.transaction_id AS transaction_id_1, t0.transaction_date AS transaction_date_2, t0.ledger_hit_date AS ledger_hit_date_3, t0.entity_doc_hash AS entity_doc_hash_4, t0.entity AS entity_5, t0.entity_id AS entity_id_6, t0.ref_transaction AS ref_transaction_7, t0.ref_doc AS ref_doc_8, t0.receipt_image AS receipt_image_9, t0.check_allowed AS check_allowed_10, t0.check_id_list AS check_id_list_11, t0.pending_reconciliation_id_list AS pending_reconciliation_id_list_12, t0.check_locked AS check_locked_13, t0.document_type AS document_type_14, t0.document_hash AS document_hash_15, t0.type_hash AS type_hash_16, t0.prefix_hash AS prefix_hash_17, t0.assoc_hash AS assoc_hash_18, t0.number_hash AS number_hash_19, t0.company_id AS company_id_20, t0.branch_id AS branch_id_21, t0.transaction_amount AS transaction_amount_22, t0.transaction_amount_currency AS transaction_amount_currency_23, t0.currency AS currency_24, t0.currency_multiply AS currency_multiply_25, t0.currency_multiply_rate AS currency_multiply_rate_26, t0.approved AS approved_27, t0.status AS status_28, t0.provisional AS provisional_29, t0.sms_notification_pending_flag AS sms_notification_pending_flag_30, t0.email_notification_pending_flag AS email_notification_pending_flag_31, t0.marker_hash AS marker_hash_32, t0.auto_created AS auto_created_33, t0.ledger_hit AS ledger_hit_34, t0.edit_flag AS edit_flag_35, t0.doc_booked_flag AS doc_booked_flag_36, t0.time_stamp_of_form AS time_stamp_of_form_37, t0.delete_flag AS delete_flag_38, t0.lock_flag AS lock_flag_39, t0.refresh_flag AS refresh_flag_40, t0.disabled_flag AS disabled_flag_41, t0.project_id AS project_id_42, t0.description AS description_43, t0.files AS files_44, t0.block_chain_unique_id AS block_chain_unique_id_45, t0.pr_method AS pr_method_46, t0.pr_reference AS pr_reference_47, t0.check_number AS check_number_48, t0.created_login_id AS created_login_id_49, t0.edited_login_id AS edited_login_id_50, t0.created_user_id AS created_user_id_51, t0.edited_user_id AS edited_user_id_52, t0.created_sig_id AS created_sig_id_53, t0.edited_sig_id AS edited_sig_id_54, t0.receiver_signature_id AS receiver_signature_id_55, t0.acknowledgement_completed_flag AS acknowledgement_completed_flag_56, t0.last_modified_date AS last_modified_date_57, t0.last_mongolog_id AS last_mongolog_id_58, t0.created_at AS created_at_59, t0.updated_at AS updated_at_60, t0.approved_by AS approved_by_61 FROM acc_transactions t0 WHERE t0.type_hash = 'CV' AND t0.prefix_hash = 'GN' AND t0.assoc_hash = '0' ORDER BY t0.number_hash DESC LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO acc_transactions (
  transaction_date, ledger_hit_date,
  entity_doc_hash, entity, entity_id,
  ref_transaction, ref_doc, receipt_image,
  check_allowed, check_id_list, pending_reconciliation_id_list,
  check_locked, document_type, document_hash,
  type_hash, prefix_hash, assoc_hash,
  number_hash, company_id, branch_id,
  transaction_amount, transaction_amount_currency,
  currency, currency_multiply, currency_multiply_rate,
  approved, STATUS, provisional, sms_notification_pending_flag,
  email_notification_pending_flag,
  marker_hash, auto_created, ledger_hit,
  edit_flag, doc_booked_flag, time_stamp_of_form,
  delete_flag, lock_flag, refresh_flag,
  disabled_flag, project_id, description,
  files, block_chain_unique_id, pr_method,
  pr_reference, check_number, created_login_id,
  edited_login_id, created_user_id,
  edited_user_id, created_sig_id,
  edited_sig_id, receiver_signature_id,
  acknowledgement_completed_flag,
  last_modified_date, last_mongolog_id,
  created_at, updated_at, approved_by
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO acc_transactions (transaction_date, ledger_hit_date, entity_doc_hash, entity, entity_id, ref_transaction, ref_doc, receipt_image, check_allowed, check_id_list, pending_reconciliation_id_list, check_locked, document_type, document_hash, type_hash, prefix_hash, assoc_hash, number_hash, company_id, branch_id, transaction_amount, transaction_amount_currency, currency, currency_multiply, currency_multiply_rate, approved, STATUS, provisional, sms_notification_pending_flag, email_notification_pending_flag, marker_hash, auto_created, ledger_hit, edit_flag, doc_booked_flag, time_stamp_of_form, delete_flag, lock_flag, refresh_flag, disabled_flag, project_id, description, files, block_chain_unique_id, pr_method, pr_reference, check_number, created_login_id, edited_login_id, created_user_id, edited_user_id, created_sig_id, edited_sig_id, receiver_signature_id, acknowledgement_completed_flag, last_modified_date, last_mongolog_id, created_at, updated_at, approved_by) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'CV/GN/0/961', 'CV', 'GN', '0', 961, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, '1785837674', NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2026-08-04 16:01:12', NULL, NULL);

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;

"START TRANSACTION"

"START TRANSACTION";