6a2a678946dfb: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-assets at 2026-06-11 03:45:13 pm by 221.216.117.119
Performance Profiling
Total processing time: 810 ms; Peak memory: 9.519 MB. Show Profiling Timeline
总计331条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 15:45:13.308 | 16.1 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:45:13.495 | 14.3 ms | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:45:13.762 | 13.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101' |
| 15:45:13.783 | 13.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102' |
| 15:45:13.733 | 12.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.324 | 10.0 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 15:45:13.693 | 9.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.912 | 9.7 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.707 | 9.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.654 | 9.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."ticket_type"=3) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.856 | 9.5 ms | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:45:13.532 | 9.3 ms | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:45:13.522 | 9.1 ms | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:45:13.750 | 8.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2101' |
| 15:45:13.720 | 8.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.922 | 8.5 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.677 | 8.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type"=3) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.847 | 8.2 ms | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2025-12-31 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:45:13.838 | 7.8 ms | yii\db\Command::query | SELECT SUM(COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_sales_orders" "ord" ON t.id = ord.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(t.amount) as amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = t.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "sales" ON t.id = sales.sales_contract_id LEFT JOIN (SELECT sc.id as sales_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON t.id = esrps.erp_sales_return_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbound_spent_products" "esips" ON esips.id = esrps.erp_sales_outbound_spent_product_id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "pi" ON pi.id = esips.erp_sales_outbound_id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pi.project_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "sc"."id") "return" ON t.id = return.sales_contract_id LEFT JOIN (SELECT u.contract_id as sales_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.sales_contract_id WHERE ((sales.sales_contract_id is not null) OR (settle.sales_contract_id is not null)) AND ((COALESCE(sales.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:45:13.935 | 7.6 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.455 | 7.6 ms | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0)) |
| 15:45:13.943 | 7.3 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.016 | 7.3 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.049 | 7.3 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.057 | 7.2 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.024 | 7.2 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 11 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id WHERE ("t"."status"=2) AND (tt.serial_no = '221106') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.831 | 6.7 ms | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."verify_at" <= '2026-06-30 23:59:59') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) >= 0) OR (ord.is_done = true)) |
| 15:45:13.419 | 6.5 ms | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0)) |
| 15:45:13.542 | 6.3 ms | yii\db\Command::query | SELECT SUM(COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0)) FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_orders" "ord" ON t.id = ord.purchase_contract_id LEFT JOIN (SELECT t.purchase_contract_id, sum(amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "t"."purchase_contract_id") "purchase" ON t.id = purchase.purchase_contract_id LEFT JOIN (SELECT pi.purchase_contract_id, sum(esrps.total_amount) as amount FROM "a57be577deb434"."tbl_erp_purchase_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_purchase_returns" "t" ON t.id = esrps.erp_purchase_return_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbound_products" "esips" ON esips.id = esrps.erp_purchase_inbound_product_id LEFT JOIN "a57be577deb434"."tbl_erp_purchase_inbounds" "pi" ON pi.id = esips.erp_purchase_inbound_id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND ("t"."created_at" >= '2025-08-08 14:34:58') GROUP BY "pi"."purchase_contract_id") "return" ON t.id = return.purchase_contract_id LEFT JOIN (SELECT u.contract_id as purchase_contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND (r.purchase_contract_id is not null) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "u"."contract_id") "settle" ON t.id = settle.purchase_contract_id WHERE ("cost_type"=1) AND ((purchase.purchase_contract_id is not null) OR (settle.purchase_contract_id is not null)) AND ((COALESCE(purchase.amount,0) - COALESCE(return.amount,0) - COALESCE(settle.amount, 0) < 0) AND (ord.is_done != true)) |
| 15:45:13.471 | 5.0 ms | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE ("cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount < COALESCE(sub.amount, 0)) |
| 15:45:13.814 | 4.8 ms | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0)) |
| 15:45:14.086 | 4.5 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/erp-analysis/list-assets', '{"year":"2026","month":"6","hide":"1","web_access_token":"4eQAiv21khj4ckVl-aCvgG-h5XZj42Z5"}', '{"code":2000,"result":{"list":[{"title":"\u8d44\u4ea7\u7c7b","type":1,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":1,"parent_id":"","title":"\u5e93\u5b58\u73b0\u91d1","serial_no":"1001","amount":"0","balance_amount":"0","actual_amount":798908.16,"description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":73,"parent_id":1,"title":"\u73b0\u91d1","serial_no":"100101","amount":"3480","balance_amount":"8610","actual_amount":8610,"description":"","type":1,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 15:39:57","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":4460,"index":3},{"id":103,"parent_id":1,"title":"\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c\u7fc1\u5bb6\u6210 6217000010081010749","serial_no":"100103","amount":"19445.25","balance_amount":"345.48","actual_amount":345.48,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:36:06","updated_at":"2025-12-16 17:12:36","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":365.25,"index":3},{"id":104,"parent_id":1,"title":"\u6dd8\u5b9d\u7f51","serial_no":"100104","amount":"258.78","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":true,"is_current":false,"created_by":1001,"created_at":"2025-08-08 17:47:02","updated_at":"2025-12-29 17:52:40","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"last_actual_amount":0,"index":3},{"id":102,"parent_id":1,"title":"\u62db\u5546\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c \u7fc1\u5bb6\u6210 6225880174507062","serial_no":"100102","amount":"458031.1","balance_amount":"789952.68","actual_amount":789952.68,"description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:35:40","updated_at":"2025-08-08 15:37:37","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":1033558.73,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1038383.98,"can_stop":false,"index":2},{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":1562739.96,"description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":101,"parent_id":3,"title":"\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6d77\u6dc0\u897f\u533a\u4e16\u7eaa\u91d1\u6e90\u652f\u884c0200069919100105717","serial_no":"100203","amount":"93723.6","balance_amount":"55209.98","actual_amount":55209.98,"description":"","type":1,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":false,"created_by":5064,"created_at":"2025-08-08 15:34:38","updated_at":"2025-08-11 19:33:40","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":709.98,"index":3},{"id":72,"parent_id":3,"title":"\u4e2d\u56fd\u5efa\u8bbe\u94f6\u884c\u5317\u4eac\u91d1\u6e90\u652f\u884c11050161620000001495","serial_no":"100202","amount":"632136.5","balance_amount":"23097.26","actual_amount":23097.26,"description":"","type":1,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":false,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-18 17:24:17","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":22393.66,"index":3},{"id":71,"parent_id":3,"title":"\u534e\u590f\u94f6\u884c\u5317\u4eac\u4e16\u7eaa\u57ce\u652f\u884c4065200001801900009530","serial_no":"100201","amount":"2875779.6","balance_amount":"1484433.72","actual_amount":1484432.72,"description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"2025-08-08 18:50:15","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":642388.63,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":665492.27,"can_stop":false,"index":2},{"id":4,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d44\u4ea7","serial_no":"1101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":5,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d44\u4ea7","serial_no":"1421","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":6,"parent_id":"","title":"\u5e94\u6536\u7968\u636e","serial_no":"1121","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":7,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u5408\u540c)","serial_no":"1122","amount":"0","balance_amount":"0","actual_amount":92685234.71,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":12589970.44,"can_stop":false,"index":2},{"id":74,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e(\u9500\u552e\u51fa\u5e93\u5355)","serial_no":"112200","amount":"5500","balance_amount":"5500","actual_amount":21133759.64,"description":"","type":1,"sort":7,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11371505.84,"can_stop":false,"index":2},{"id":8,"parent_id":"","title":"\u9884\u4ed8\u6b3e\u9879","serial_no":"1123","amount":"0","balance_amount":"0","actual_amount":"0.0000000000","description":"","type":1,"sort":8,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0.0000000000","can_stop":false,"index":2},{"id":11,"parent_id":"","title":"\u5176\u4ed6\u5e94\u6536\u6b3e","serial_no":"1132","amount":"0","balance_amount":"0","actual_amount":1177547.78,"description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1153342,"can_stop":false,"index":2},{"id":12,"parent_id":"","title":"\u5b58\u8d27","serial_no":"1221","amount":"0","balance_amount":"0","actual_amount":549564.61166667,"description":"","type":1,"sort":12,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":98336.77,"can_stop":false,"index":2},{"id":13,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d44\u4ea7","serial_no":"1481","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":14,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u7684\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1501","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":15,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d44\u4ea7","serial_no":"1401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":15,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":25222520.151667,"last_actual_amount":14327060.86,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":16,"parent_id":"","title":"\u53ef\u4f9b\u51fa\u552e\u91d1\u878d\u8d44\u4ea7","serial_no":"1503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":16,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":17,"parent_id":"","title":"\u6301\u6709\u81f3\u5230\u671f\u6295\u8d44","serial_no":"1502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":17,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":18,"parent_id":"","title":"\u957f\u671f\u5e94\u6536\u6b3e","serial_no":"1506","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":18,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":19,"parent_id":"","title":"\u957f\u671f\u80a1\u6743\u6295\u8d44","serial_no":"1511","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":19,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":20,"parent_id":"","title":"\u6295\u8d44\u6027\u623f\u5730\u4ea7","serial_no":"1521","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":20,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":21,"parent_id":"","title":"\u56fa\u5b9a\u8d44\u4ea7","serial_no":"1601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":21,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":22,"parent_id":"","title":"\u5728\u5efa\u5de5\u7a0b","serial_no":"1604","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":22,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":23,"parent_id":"","title":"\u751f\u4ea7\u6027\u751f\u7269\u8d44\u4ea7","serial_no":"1621","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":23,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":24,"parent_id":"","title":"\u65e0\u5f62\u8d44\u4ea7","serial_no":"1701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":24,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":25,"parent_id":"","title":"\u6cb9\u6c14\u8d44\u4ea7","serial_no":"1531","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":25,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":26,"parent_id":"","title":"\u5f00\u53d1\u652f\u51fa","serial_no":"1702","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":26,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":27,"parent_id":"","title":"\u5546\u8a89","serial_no":"1711","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":27,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":28,"parent_id":"","title":"\u957f\u671f\u5f85\u644a\u8d39\u7528","serial_no":"1801","amount":"222","balance_amount":"222","actual_amount":"222","description":"","type":1,"sort":28,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":29,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d44\u4ea7","serial_no":"1811","amount":"2","balance_amount":"2","actual_amount":"2","description":"","type":1,"sort":29,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"2","can_stop":false,"index":2},{"id":30,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1901","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":30,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u975e\u6d41\u52a8\u8d44\u4ea7\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":224,"last_actual_amount":224,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d44\u4ea7\u603b\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":25222744.151667,"last_actual_amount":14327284.86,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"list2":[{"title":"\u8d1f\u503a\u7c7b","type":2,"serial_no":"","parent_id":"","amount":"","balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":31,"parent_id":"","title":"\u77ed\u671f\u501f\u6b3e","serial_no":"2001","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":32,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d1f\u503a","serial_no":"2101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":33,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d1f\u503a","serial_no":"2102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":34,"parent_id":"","title":"\u5e94\u4ed8\u7968\u636e","serial_no":"2201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":35,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5408\u540c)","serial_no":"2202","amount":"0","balance_amount":"0","actual_amount":10238566.08,"description":"","type":2,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":11472011.72,"can_stop":false,"index":2},{"id":75,"parent_id":"","title":"\u5e94\u4ed8\u8d26\u6b3e(\u91c7\u8d2d\u5165\u5e93\u5355)","serial_no":"220200","amount":"33","balance_amount":"33","actual_amount":5693009.49,"description":"","type":2,"sort":6,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2026-01-23 16:05:33","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":6725499.98,"can_stop":false,"index":2},{"id":36,"parent_id":"","title":"\u9884\u6536\u6b3e\u9879","serial_no":"2203","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":37,"parent_id":"","title":"\u5e94\u4ed8\u804c\u5de5\u85aa\u916c","serial_no":"2211","amount":"0","balance_amount":"0","actual_amount":-2481663.42,"description":"","type":2,"sort":8,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":57,"parent_id":37,"title":"\u5e94\u4ed8\u804c\u5de5\u5de5\u8d44","serial_no":"221101","amount":"0","balance_amount":"0","actual_amount":-2619663.42,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":-1956321.62,"index":3},{"id":58,"parent_id":37,"title":"\u5e94\u4ed8\u5956\u91d1","serial_no":"221102","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":59,"parent_id":37,"title":"\u5e94\u4ed8\u793e\u4f1a\u4fdd\u9669\u8d39","serial_no":"221104","amount":"0","balance_amount":"0","actual_amount":115000,"description":"","type":2,"sort":4,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":60,"parent_id":37,"title":"\u5e94\u4ed8\u4f4f\u623f\u516c\u79ef\u91d1","serial_no":"221105","amount":"0","balance_amount":"0","actual_amount":23000,"description":"","type":2,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3},{"id":61,"parent_id":37,"title":"\u5de5\u4f1a\u7ecf\u8d39","serial_no":"221106","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":7,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":-1956321.62,"can_stop":false,"index":2},{"id":38,"parent_id":"","title":"\u5e94\u4ea4\u7a0e\u8d39","serial_no":"2221","amount":"0","balance_amount":"0","actual_amount":13000,"description":"","type":2,"sort":9,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":62,"parent_id":38,"title":"\u5e94\u4ea4\u589e\u503c\u7a0e","serial_no":"222101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":63,"parent_id":38,"title":"\u5e94\u4ea4\u4e2a\u7a0e","serial_no":"222102","amount":"0","balance_amount":"0","actual_amount":13000,"description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":0,"index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"can_stop":false,"index":2},{"id":39,"parent_id":"","title":"\u5176\u4ed6\u5e94\u4ed8\u6b3e","serial_no":"2241","amount":"0","balance_amount":"0","actual_amount":2274858.34,"description":"","type":2,"sort":10,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":2168715.33,"can_stop":false,"index":2},{"id":40,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d1f\u503a","serial_no":"2245","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":11,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":41,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2231","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":12,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":42,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d1f\u503a","serial_no":"2242","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":5499204.41,"last_actual_amount":6937893.69,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":43,"parent_id":"","title":"\u957f\u671f\u501f\u6b3e","serial_no":"2501","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":14,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":44,"parent_id":"","title":"\u5e94\u4ed8\u503a\u5238","serial_no":"2502","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":2,"sort":15,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":64,"parent_id":44,"title":"\u4f18\u5148\u80a1","serial_no":"250201","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":65,"parent_id":44,"title":"\u6c38\u7eed\u503a","serial_no":"250202","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":45,"parent_id":"","title":"\u957f\u671f\u5e94\u4ed8\u6b3e","serial_no":"2701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":16,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":46,"parent_id":"","title":"\u9884\u8ba1\u8d1f\u503a","serial_no":"2801","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":17,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":47,"parent_id":"","title":"\u9012\u5ef6\u6536\u76ca","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":18,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":48,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d1f\u503a","serial_no":"2401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":19,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":49,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d1f\u503a","serial_no":"2503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":2,"sort":20,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":true,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u975e\u6d41\u52a8\u8d1f\u503a\u5408\u8ba1","type":1,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":0,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u8d1f\u503a\u5408\u8ba1","type":2,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":5499204.41,"last_actual_amount":6937893.69,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\u7c7b\uff09","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":"","last_actual_amount":"","description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1},{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"222","balance_amount":"222","actual_amount":"222","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"222","can_stop":false,"index":2},{"id":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"3333","balance_amount":"3333","actual_amount":"3333","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"3333","can_stop":false,"index":2},{"id":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":244444,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"222222","balance_amount":"222222","actual_amount":"222222","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"222222","index":3},{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"22222","balance_amount":"22222","actual_amount":"22222","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"22222","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":244444,"can_stop":false,"index":2},{"id":53,"parent_id":"","title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"4104","amount":"-2082915.66","balance_amount":"-2082915.66","actual_amount":13999528.251667,"description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":1400879.28,"can_stop":false,"index":2},{"id":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":67,"parent_id":54,"title":"\u4f18\u5148\u80a1","serial_no":"611601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3},{"id":68,"parent_id":54,"title":"\u6c38\u7eed\u503a","serial_no":"611602","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"last_actual_amount":"0","index":3}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":0,"index":2},{"id":55,"parent_id":"","title":"\u5176\u4ed6\u7efc\u5408\u6536\u76ca","serial_no":"6111","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"id":56,"parent_id":"","title":"\u4e13\u9879\u50a8\u5907","serial_no":"4301","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"bgcolor":"#89c541","last_actual_amount":"0","index":2},{"title":"\u6240\u6709\u8005\u6743\u76ca\uff08\u6216\u80a1\u4e1c\u6743\u76ca\uff09\u5408\u8ba1","type":3,"serial_no":"","parent_id":"","amount":0,"balance_amount":0,"actual_amount":14247527.251667,"last_actual_amount":0,"description":"","sort":0,"is_delete":false,"is_system":true,"can_create_child":false,"can_change_amount":false,"created_by":"","created_at":"","updated_at":"","index":1}],"count":{"list1_sum":25222744.151667,"list2_sum":19746731.661667,"last_list1_sum":14327284.86,"last_list2_sum":8586771.97,"start_list1_sum":6566525.43,"start_list2_sum":143761.74},"show_libra":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-11 15:45:14', 783253760) RETURNING "id" |
| 15:45:13.825 | 4.3 ms | yii\db\Command::query | SELECT SUM(pc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.purchase_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_purchase_contracts" "t" LEFT JOIN (SELECT t.purchase_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_purchase_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."purchase_contract_id") "cancel" ON t.id = cancel.purchase_contract_id WHERE (t.is_draft = false) AND (t.is_refuse = false) AND ("t"."cost_type"=1) AND ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59')) "pc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status"=2 ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status"=2 )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON pc.id = sub.contract_id WHERE (pc.id is not null) AND (pc.amount >= COALESCE(sub.amount, 0)) |
| 15:45:13.467 | 3.8 ms | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount >= COALESCE(sub.amount, 0)) |
| 15:45:13.809 | 3.7 ms | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2026-06-30 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2026-06-30 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2026-06-30 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0)) |
| 15:45:13.361 | 3.6 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73 |
| 15:45:13.909 | 3.5 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.821 | 3.2 ms | yii\db\Command::query | SELECT SUM(sc.amount - COALESCE(sub.amount, 0)) FROM (SELECT t.id, case when cancel.sales_contract_id is null then t.amount else 0 end as amount FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN (SELECT t.sales_contract_id, min(t.cancel_at) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=8) AND ("t"."cancel_at" >= '2025-08-08 14:34:58') AND ("t"."cancel_at" <= '2025-12-31 23:59:59') GROUP BY "t"."sales_contract_id") "cancel" ON t.id = cancel.sales_contract_id WHERE ("t"."created_at" >= '2025-08-08 14:34:58') AND ("t"."created_at" <= '2025-12-31 23:59:59') AND ("build_by_project"=TRUE)) "sc" LEFT JOIN (SELECT u.contract_id, sum(amount) as amount FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status"=2)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description, t.bank_settle_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status"=2) )) "u" WHERE "u"."bank_settle_at" <= '2025-12-31 23:59:59' GROUP BY "contract_id") "sub" ON sc.id = sub.contract_id WHERE (sc.id is not null) AND (sc.amount < COALESCE(sub.amount, 0)) |
| 15:45:13.931 | 3.0 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.003 | 2.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.803 | 2.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201' |
| 15:45:14.037 | 2.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" >= '2025-08-08 14:34:58') AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.014 | 2.4 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.047 | 2.4 ms | yii\db\Command::query | SELECT SUM(dt1.out_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = t.id AND dt1.term_id = 18 AND dt1.object_type = 9 LEFT JOIN "a57be577deb434"."tbl_term_taxonomies" "tt" ON dt1.taxonomy_id = tt.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "p" ON p.erp_cost_ticket_id = t.id LEFT JOIN (SELECT "r"."erp_cost_ticket_id", sum(r.amount) as amount FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') GROUP BY "r"."erp_cost_ticket_id") "c" ON c.erp_cost_ticket_id = t.id WHERE ("t"."status"=2) AND ((p.amount + c.amount) < t.amount) AND (tt.serial_no = '221106') AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.384 | 1.9 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=101 |
| 15:45:13.386 | 1.8 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72 |
| 15:45:13.403 | 1.6 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:45:13.967 | 1.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.379 | 1.6 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1 |
| 15:45:13.885 | 1.6 ms | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.366 | 1.6 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=73 |
| 15:45:13.368 | 1.5 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=103 |
| 15:45:13.339 | 1.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 15:45:13.393 | 1.5 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0 |
| 15:45:13.405 | 1.5 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true) |
| 15:45:13.963 | 1.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.372 | 1.5 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=104 |
| 15:45:13.557 | 1.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.375 | 1.5 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=102 |
| 15:45:13.390 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71 |
| 15:45:13.382 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2026-06-30 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=101 |
| 15:45:13.974 | 1.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.564 | 1.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.388 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=72 |
| 15:45:13.395 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=0 |
| 15:45:13.392 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=71 |
| 15:45:13.370 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=103 |
| 15:45:13.380 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."type"=1 |
| 15:45:13.377 | 1.4 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=102 |
| 15:45:13.373 | 1.3 ms | yii\db\Command::query | SELECT COALESCE(sum(ba.amount), 0) + COALESCE(sum(f.in_amount), 0) - COALESCE(sum(f.out_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_banks" "b" LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_erp_banks" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59') "ba" ON ba.id = b.id LEFT JOIN (SELECT "s"."erp_bank_id", sum(in_amount) as in_amount, sum(out_amount) as out_amount FROM (SELECT * FROM "a57be577deb434"."tbl_erp_bank_amount_change_logs" "t" WHERE "t"."settle_at" <= '2025-12-31 23:59:59') "s" GROUP BY "s"."erp_bank_id") "f" ON f.erp_bank_id = b.id WHERE "b"."erp_account_caption_id"=104 |
| 15:45:13.463 | 1.3 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=TRUE) |
| 15:45:13.978 | 1.3 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.623 | 1.2 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.807 | 1.2 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false) |
| 15:45:13.819 | 1.2 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("t"."cost_type"=1) AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = false) |
| 15:45:13.352 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) AND ("is_delete"=FALSE) ORDER BY "is_current" DESC, "sort", "id" |
| 15:45:13.877 | 1.1 ms | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.465 | 1.1 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_purchase_contracts" "t" WHERE ("cost_type"=1) AND ("t"."created_at" < '2025-08-08 14:34:58') AND (t.is_draft = false) AND (t.is_refuse = false) AND (t.is_chargeback = true) |
| 15:45:13.559 | 1.0 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.898 | 1.0 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.598 | 1.0 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.607 | 1.0 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.551 | 0.9 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59') |
| 15:45:13.903 | 0.9 ms | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.802 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2102' |
| 15:45:13.808 | 0.8 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:45:13.355 | 0.8 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5064, 1001)) |
| 15:45:13.563 | 0.8 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.820 | 0.8 ms | yii\db\Command::query | SELECT SUM(t.erp_un_settle_amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."created_at" < '2025-08-08 14:34:58') AND ("build_by_project"=TRUE) AND ("need_analysis"=FALSE) |
| 15:45:13.902 | 0.8 ms | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.549 | 0.8 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:14.000 | 0.8 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.614 | 0.8 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.969 | 0.8 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.869 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.556 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.901 | 0.7 ms | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.973 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.957 | 0.7 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.561 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2026-06-30 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:14.001 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.997 | 0.7 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.567 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.033 | 0.7 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.345 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE) |
| 15:45:13.960 | 0.7 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2026-06-30 23:59:59')) |
| 15:45:13.965 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.552 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2026-06-30 23:59:59') |
| 15:45:13.622 | 0.7 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.976 | 0.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.963 | 0.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "op" ON op.id = r.erp_other_payment_ticket_id WHERE (r.erp_other_payment_ticket_id is not null) AND ("op"."ticket_type" IN (1, 2, 4)) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.571 | 0.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2026-06-30 23:59:59' |
| 15:45:13.595 | 0.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.579 | 0.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.035 | 0.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.erp_other_income_ticket_id is not null) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.041 | 0.6 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.628 | 0.6 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.879 | 0.6 ms | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:14.008 | 0.6 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.566 | 0.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amount_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "oc" ON oc.id = r.erp_other_collect_ticket_id WHERE (r.erp_other_collect_ticket_id is not null) AND (("oc"."is_start"=TRUE) OR ("oc"."bank_settle_at" <= '2025-12-31 23:59:59')) AND ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.588 | 0.6 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.887 | 0.6 ms | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.904 | 0.6 ms | yii\db\Command::query | SELECT SUM(am.company_pension_insurance + am.company_unemployment_insurance + am.company_medical_insurance + am.maternity_insurance + am.injury_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.889 | 0.5 ms | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.629 | 0.5 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.624 | 0.5 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.961 | 0.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:45:13.890 | 0.5 ms | yii\db\Command::query | SELECT SUM(am.personal_pension_insurance + am.personal_unemployment_insurance + am.personal_medical_insurance) FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.356 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4) |
| 15:45:13.967 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.972 | 0.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (is_start = false) |
| 15:45:13.977 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.979 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "ct" ON ct.id = r.erp_cost_ticket_id WHERE (r.erp_cost_ticket_id is not null) AND ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.067 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=1) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:45:14.074 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49) |
| 15:45:13.971 | 0.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND (is_start = true) |
| 15:45:13.905 | 0.5 ms | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.001 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.073 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:45:13.891 | 0.5 ms | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.553 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59') |
| 15:45:13.562 | 0.5 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') AND (t.is_start = false) |
| 15:45:13.906 | 0.5 ms | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:13.554 | 0.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("t"."status"=2) AND (r.erp_advance_payment_ticket_id is not null) AND ("t"."created_at" <= '2025-12-31 23:59:59') |
| 15:45:13.892 | 0.4 ms | yii\db\Command::query | SELECT SUM(personal_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.907 | 0.4 ms | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.889 | 0.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("r"."settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.561 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:45:13.970 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.is_start = false) AND ("t"."verify_at" <= '2025-12-31 23:59:59') AND (("t"."bank_settle_at" IS NULL) OR ("t"."bank_settle_at" > '2025-12-31 23:59:59')) |
| 15:45:13.354 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) |
| 15:45:13.630 | 0.4 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_lost_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.631 | 0.4 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_build_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.068 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 74, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) |
| 15:45:13.572 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.907 | 0.4 ms | yii\db\Command::query | SELECT SUM(company_amount) FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.009 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.959 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.899 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:14.035 | 0.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.989 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:45:13.555 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND (is_start = true) |
| 15:45:14.034 | 0.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.649 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=2) AND (parent_id is null) ORDER BY "is_current" DESC, "sort", "id" |
| 15:45:13.531 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200 |
| 15:45:13.962 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE ("t"."status"=2) AND ("ticket_type" IN (1, 2, 4)) AND ("t"."verify_at" <= '2026-06-30 23:59:59') AND (is_start = false) |
| 15:45:13.555 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') AND (t.is_start = false) |
| 15:45:13.983 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242' |
| 15:45:13.984 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701' |
| 15:45:13.996 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.626 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_inbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.078 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"=3) AND (parent_id is null) ORDER BY "is_delete", "sort", "id" |
| 15:45:13.631 | 0.4 ms | yii\db\Command::query | SELECT SUM(eipss.actual_total_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_inventory_disassemble_spent_id = t.id WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.007 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.065 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111' |
| 15:45:13.983 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2242' |
| 15:45:13.355 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001) |
| 15:45:14.032 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.959 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.553 | 0.4 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" WHERE ("t"."status"=2) AND ("is_payment_settle"=TRUE) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:13.866 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203' |
| 15:45:13.650 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (31, 32, 33, 34, 35, 75, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49) |
| 15:45:14.069 | 0.4 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5064, 1001)) |
| 15:45:13.867 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.977 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.009 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.980 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245' |
| 15:45:14.006 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.966 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.476 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=112200 |
| 15:45:14.075 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.990 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:45:13.998 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.041 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.888 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.958 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2026-06-30 23:59:59') |
| 15:45:14.072 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE "is_start"=TRUE |
| 15:45:13.596 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.011 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.012 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.982 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231' |
| 15:45:14.071 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.400 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101' |
| 15:45:14.031 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104 |
| 15:45:14.078 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56) |
| 15:45:14.013 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.012 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.002 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.045 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.900 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.632 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481' |
| 15:45:13.996 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104 |
| 15:45:13.640 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601' |
| 15:45:13.985 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2701' |
| 15:45:13.993 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.901 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."bank_settle_at" <= '2025-12-31 23:59:59') |
| 15:45:14.011 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.043 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.991 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:14.034 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.036 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.068 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5064, 1001) |
| 15:45:13.846 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200 |
| 15:45:13.981 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2245' |
| 15:45:14.077 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_other_payment_tickets" "t" WHERE "is_start"=TRUE |
| 15:45:14.046 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.994 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001' |
| 15:45:13.995 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002' |
| 15:45:14.007 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.042 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.006 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.040 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.065 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='6111' |
| 15:45:13.806 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2201' |
| 15:45:13.346 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE) |
| 15:45:14.039 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.641 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604' |
| 15:45:14.066 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301' |
| 15:45:14.044 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.989 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503' |
| 15:45:14.040 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.401 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1101' |
| 15:45:13.991 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.995 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4002' |
| 15:45:14.045 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.981 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2231' |
| 15:45:13.830 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=220200 |
| 15:45:14.010 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:14.077 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:14.081 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.632 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1481' |
| 15:45:13.649 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901' |
| 15:45:13.985 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801' |
| 15:45:14.013 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2026-06-30 23:59:59') |
| 15:45:13.987 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:45:13.988 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:45:13.986 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:45:14.043 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.651 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.986 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2801' |
| 15:45:13.647 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811' |
| 15:45:14.074 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:14.080 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:14.044 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.627 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.646 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711' |
| 15:45:13.635 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503' |
| 15:45:13.987 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2401' |
| 15:45:13.988 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2503' |
| 15:45:13.992 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:14.046 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.626 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.647 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801 |
| 15:45:13.866 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='2203' |
| 15:45:13.994 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4001' |
| 15:45:13.638 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511' |
| 15:45:14.066 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='4301' |
| 15:45:14.076 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.627 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.076 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.358 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.639 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521' |
| 15:45:13.642 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621' |
| 15:45:13.645 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702' |
| 15:45:14.070 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.625 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" WHERE "t"."created_at" <= '2025-12-31 23:59:59' |
| 15:45:13.637 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506' |
| 15:45:14.070 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4) |
| 15:45:13.628 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:13.630 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" <= '2025-12-31 23:59:59') |
| 15:45:14.072 | 0.3 ms | yii\db\Command::query | SELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_starts" "t" |
| 15:45:14.081 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.640 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1601' |
| 15:45:14.079 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.634 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501' |
| 15:45:13.633 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1501' |
| 15:45:13.652 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.639 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1521' |
| 15:45:13.646 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801 |
| 15:45:13.644 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531' |
| 15:45:13.651 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.992 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.636 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502' |
| 15:45:13.652 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) |
| 15:45:13.648 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1811' |
| 15:45:13.648 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1901' |
| 15:45:13.643 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1531' |
| 15:45:13.634 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401' |
| 15:45:13.357 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 15:45:13.645 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1711' |
| 15:45:13.401 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421' |
| 15:45:13.643 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701' |
| 15:45:13.642 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1701' |
| 15:45:13.644 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1702' |
| 15:45:13.403 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121' |
| 15:45:13.635 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1503' |
| 15:45:13.402 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1421' |
| 15:45:13.641 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1604' |
| 15:45:13.642 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1621' |
| 15:45:13.637 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1506' |
| 15:45:13.636 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1502' |
| 15:45:13.638 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1511' |
| 15:45:13.634 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1401' |
| 15:45:13.402 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"='1121' |
| 15:45:14.082 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:13.993 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:14.071 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:14.075 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:14.080 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:13.653 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:13.651 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |
| 15:45:13.358 | 0.2 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10 |