ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a27d5a247ceb: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out at 2026-06-09 04:58:10 pm by 43.224.72.82

Performance Profiling

Total processing time: 108 ms; Peak memory: 5.050 MB. Show Profiling Timeline

总计31条数据
TimeDurationCategoryInfo
  
16:58:10.36923.4 msyii\db\Command::querySELECT u.*, sum(sub.amount) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN ((SELECT t.handler as user_id, sum(eipss.total_amount - eipss.actual_total_amount) as 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.handler is not null) GROUP BY "t"."handler") UNION ALL ( SELECT am.user_id, sum((eipss.total_amount - eipss.actual_total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.user_id, sum(t.budget - t.cost) as amount FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null)) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, 0 - sum(t.amount * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.handler as user_id, 0 - sum(eipss.actual_total_amount - eipss.total_amount) as 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.handler is not null) GROUP BY "t"."handler" ) UNION ALL ( SELECT am.user_id, 0 - sum((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) as amount FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.user_id, 0 - sum(t.expense) as amount FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id"
16:58:10.31810.6 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON am.erp_wage_prize_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3385.3 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))
16:58:10.3624.1 msyii\db\Command::querySELECT u.*, sum(sub.amount) as amount FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN ((SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id") UNION ALL ( SELECT am.user_id, sum(am.amount) as 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"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount 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"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON am.erp_wage_prize_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT am.user_id, sum(am.amount) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null) GROUP BY "am"."user_id" ) UNION ALL ( SELECT t.user_id, sum(t.wage) as amount FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."user_id" )) "sub" ON sub.user_id = u.id WHERE ("user_status"='1') OR (sub.amount is not null) GROUP BY "u"."id"
16:58:10.3443.7 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
16:58:10.3563.5 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount - eipss.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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.handler is not null)
16:58:10.3321.9 msyii\db\Command::querySELECT SUM((eipss.total_amount - eipss.actual_total_amount) * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.2981.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5493
16:58:10.3521.7 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
16:58:10.3601.3 msyii\db\Command::querySELECT SUM((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND ("t"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3971.3 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-wage-analysis/in-out', '{"created_at_period":"erpcurrentfascalyear","user_id":"","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"outCircle":[{"key":"erpWageTickets","name":"\u5de5\u8d44","value":372090,"y":60.49},{"key":"erpSocialInsurances","name":"\u793e\u4fdd","value":"184000","y":29.91},{"key":"erpProvidentFunds","name":"\u516c\u79ef\u91d1","value":"46000","y":7.48},{"key":"erpPersonalTaxs","name":"\u4e2a\u7a0e","value":"13000","y":2.11},{"key":"erpWagePrizes","name":"\u5956\u91d1","value":"","y":0}],"inCircle":[{"key":"outboundIn","name":"\u9500\u552e\u6536\u5165","value":13434872.341667,"y":99.69},{"key":"otherIn","name":"\u5176\u4ed6\u6536\u5165","value":41742,"y":0.31}],"profitCircle":[{"key":"totalIn","name":"\u6536\u5165\u603b\u91d1\u989d","value":13476614.341667,"y":95.64},{"key":"totalOut","name":"\u652f\u51fa\u603b\u91d1\u989d","value":615090,"y":4.36}],"seriesOut":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"31002"},{"key":1000,"name":"\u66f9\u6c38\u751f","avatar":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg","y":"27004"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"27004"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"27004"},{"key":1011,"name":"\u97e9\u96c5\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png","y":"27004"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"27004"},{"key":1022,"name":"\u5f90\u7855","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png","y":"27004"},{"key":1023,"name":"\u5468\u5b50\u5065","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg","y":"27004"},{"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png","y":"27004"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"27004"},{"key":5250,"name":"\u8463\u8363","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png","y":"27004"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"27004"},{"key":1015,"name":"\u5434\u660a","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg","y":"26004"},{"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png","y":"26004"},{"key":5085,"name":"\u970d\u4e1c\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg","y":"26004"},{"key":5248,"name":"\u6587\u4f73\u9f99","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png","y":"26004"},{"key":5252,"name":"\u738b\u7b11\u7b11","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png","y":"26004"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"26004"},{"key":5360,"name":"\u5f20\u7ea2\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png","y":"26004"},{"key":5446,"name":"\u5218\u5a1f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg","y":"26004"},{"key":5449,"name":"\u5468\u4e3d\u98de","avatar":"\/img\/avatar-default.jpg","y":"26004"},{"key":5461,"name":"\u8096\u5e05","avatar":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png","y":"26004"},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":"26004"},{"key":5388,"name":"\u6768\u71d5\u971e","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png","y":"1000"},{"key":1017,"name":"\u8f66\u660e\u98de","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg","y":"0"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":""},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":""},{"key":5467,"name":"\u9a6c\u6668\u5e0c","avatar":"\/img\/avatar-default.jpg","y":"0"}],"seriesIn":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":"12962607.595000000000"},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":"380833.06"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":"107716.730"},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":"41974.07"},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":"3953.2100"},{"key":1023,"name":"\u5468\u5b50\u5065","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg","y":"2880.0000000000000000"},{"key":5248,"name":"\u6587\u4f73\u9f99","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png","y":"2880.0000000000000000"},{"key":5085,"name":"\u970d\u4e1c\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg","y":"2680.0000000000000000"},{"key":1022,"name":"\u5f90\u7855","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png","y":"2580.0000000000000000"},{"key":1015,"name":"\u5434\u660a","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg","y":"1705.0000000000000000"},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":""},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":""},{"key":1003,"name":"\u5415\u5174\u5143","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png","y":"-1"},{"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png","y":"-9"},{"key":5250,"name":"\u8463\u8363","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png","y":"-9"},{"key":5461,"name":"\u8096\u5e05","avatar":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png","y":"-9"},{"key":1011,"name":"\u97e9\u96c5\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png","y":"-150.00"},{"key":5446,"name":"\u5218\u5a1f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg","y":"-199.00"},{"key":5252,"name":"\u738b\u7b11\u7b11","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png","y":"-200.00"},{"key":5360,"name":"\u5f20\u7ea2\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png","y":"-200.00"},{"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png","y":"-391.40"},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":"-1213.6"},{"key":1000,"name":"\u66f9\u6c38\u751f","avatar":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg","y":"-5885"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":"-7671.41"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":"-17256.9133333332"}],"total_in":13476614.341667,"total_out":615090,"profit":12861524.341667,"seriesProfit":[{"key":1001,"name":"\u5218\u4eba\u8bda","avatar":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png","y":12931605.595},{"key":5087,"name":"\u5218\u5fae","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png","y":353829.06},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png","y":80712.73},{"key":5295,"name":"\u9b4f\u6cfd\u6587","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg","y":14970.07},{"key":5332,"name":"\u970d\u536b\u8d85","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png","y":0},{"key":1003,"name":"\u5415\u5174\u5143","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1003.png","y":"-1"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg","y":-17256.913333333},{"key":5300,"name":"\u82cf\u6e05\u4e91","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png","y":-22050.79},{"key":5248,"name":"\u6587\u4f73\u9f99","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png","y":-23124},{"key":5085,"name":"\u970d\u4e1c\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg","y":-23324},{"key":1023,"name":"\u5468\u5b50\u5065","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg","y":-24124},{"key":1015,"name":"\u5434\u660a","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg","y":-24299},{"key":1022,"name":"\u5f90\u7855","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png","y":-24424},{"key":5476,"name":"\u6768\u5dcd","avatar":"\/img\/avatar-default.jpg","y":-26004},{"key":5016,"name":"\u9ad8\u90e1\u9633","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png","y":-26013},{"key":5461,"name":"\u8096\u5e05","avatar":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png","y":-26013},{"key":5446,"name":"\u5218\u5a1f","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg","y":-26203},{"key":5252,"name":"\u738b\u7b11\u7b11","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png","y":-26204},{"key":5360,"name":"\u5f20\u7ea2\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png","y":-26204},{"key":5250,"name":"\u8463\u8363","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png","y":-27013},{"key":1011,"name":"\u97e9\u96c5\u82b3","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png","y":-27154},{"key":5064,"name":"\u59da\u96ea\u7eaf","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png","y":-27395.4},{"key":1013,"name":"\u7fc1\u5bb6\u6210","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png","y":-28217.6},{"key":1000,"name":"\u66f9\u6c38\u751f","avatar":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg","y":-32889},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0","avatar":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg","y":-34675.41}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-09 16:58:10', 100802048) RETURNING "id"
16:58:10.3491.3 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
16:58:10.3361.2 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "a57be577deb434"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND ("pd"."project_id" IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
16:58:10.3511.1 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))
16:58:10.3311.1 msyii\db\Command::querySELECT SUM(eipss.total_amount - 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"."project_id" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (t.project_id is null)) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (t.handler is not null)
16:58:10.3101.0 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3341.0 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))
16:58:10.3480.9 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "a57be577deb434"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') AND (am.user_id is not null) AND (("sc"."from_project" NOT IN (SELECT t.project_id FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id")) OR (sales_contract_id is null))
16:58:10.3010.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:58:10.3120.6 msyii\db\Command::querySELECT SUM(am.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"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3130.6 msyii\db\Command::querySELECT SUM(am.amount) 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"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3100.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
16:58:10.3290.5 msyii\db\Command::querySELECT SUM(am.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND ("t"."settle_month" >= '2026-01-01 00:00:00') AND ("t"."settle_month" <= '2026-12-31 23:59:59') AND (am.user_id is not null)
16:58:10.3030.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:58:10.3950.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1001, 1003, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476))
16:58:10.3670.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 1023, 5248, 5311, 5446, 5087, 1022, 5016, 1004, 5467, 1015, 5295, 1001, 5461, 1000, 5300, 1017, 1013, 5332, 5250, 5360, 5476, 5388, 1011, 1005, 5085, 5449, 5064))
16:58:10.3300.4 msyii\db\Command::querySELECT SUM(wage) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59')
16:58:10.3610.3 msyii\db\Command::querySELECT SUM(expense) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59')
16:58:10.3090.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
16:58:10.3380.2 msyii\db\Command::querySELECT SUM(budget - cost) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59')
16:58:10.2980.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta