ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d36df25780: POST https://beta.jinchangxiao.com/vue/erp-wage-analysis/in-out at 2026-06-01 03:38:07 pm by 43.224.72.82

Performance Profiling

Total processing time: 187 ms; Peak memory: 3.733 MB. Show Profiling Timeline

总计30条数据
TimeDurationCategoryInfo
  
15:38:07.27118.2 msyii\db\Command::querySELECT SUM(eipss.total_amount - eipss.actual_total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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)
15:38:07.25114.5 msyii\db\Command::querySELECT SUM(wage) FROM "o6a13e2c574d5a"."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')
15:38:07.21413.7 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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)
15:38:07.17111.9 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:38:07.2049.6 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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)
15:38:07.3248.2 msyii\db\Command::querySELECT u.*, sum(sub.amount) as amount FROM "o6a13e2c574d5a"."tbl_users" "u" LEFT JOIN ((SELECT t.handler as user_id, sum(eipss.total_amount - eipss.actual_total_amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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"
15:38:07.1957.7 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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)
15:38:07.2367.1 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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)
15:38:07.3005.0 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cash_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cash_cost_tickets" "t" ON am.erp_cash_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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))
15:38:07.1854.0 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_erp_settles" WHERE ("date"='2026-12-01') AND ("is_settle"=TRUE)
15:38:07.2903.2 msyii\db\Command::querySELECT SUM((eipss.total_amount - eipss.actual_total_amount) * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_outbounds" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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)
15:38:07.2442.8 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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)
15:38:07.3162.5 msyii\db\Command::querySELECT SUM(eipss.actual_total_amount - eipss.total_amount) FROM "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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)
15:38:07.2952.5 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_other_income_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_other_income_tickets" "t" ON am.erp_other_income_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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))
15:38:07.3202.1 msyii\db\Command::querySELECT u.*, sum(sub.amount) as amount FROM "o6a13e2c574d5a"."tbl_users" "u" LEFT JOIN ((SELECT am.user_id, sum(am.amount) as amount FROM "o6a13e2c574d5a"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_wage_prize_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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"
15:38:07.3082.1 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_tickets" "t" ON am.erp_cost_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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))
15:38:07.3131.6 msyii\db\Command::querySELECT SUM(am.amount) FROM "o6a13e2c574d5a"."tbl_erp_cost_convert_ticket_handlers" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_cost_convert_tickets" "t" ON am.erp_cost_convert_ticket_id = t.id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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))
15:38:07.3061.3 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
15:38:07.2981.3 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
15:38:07.3111.1 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
15:38:07.3330.9 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5493, 5, 'vue/erp-wage-analysis/in-out', '{"created_at_period":"erpcurrentfascalyear","user_id":"","web_access_token":"YwFaPh8a1dbQrFwOp6grZ7RlSTuMSejO"}', '{"code":2000,"result":{"outCircle":[{"key":"erpPersonalTaxs","name":"\u4e2a\u7a0e","value":"","y":0},{"key":"erpProvidentFunds","name":"\u516c\u79ef\u91d1","value":"","y":0},{"key":"erpSocialInsurances","name":"\u793e\u4fdd","value":"","y":0},{"key":"erpWagePrizes","name":"\u5956\u91d1","value":"","y":0},{"key":"erpWageTickets","name":"\u5de5\u8d44","value":0,"y":0}],"inCircle":[{"key":"otherIn","name":"\u5176\u4ed6\u6536\u5165","value":0,"y":0},{"key":"outboundIn","name":"\u9500\u552e\u6536\u5165","value":0,"y":0}],"profitCircle":[{"key":"totalIn","name":"\u6536\u5165\u603b\u91d1\u989d","value":0,"y":0},{"key":"totalOut","name":"\u652f\u51fa\u603b\u91d1\u989d","value":0,"y":0}],"seriesOut":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":""},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":""}],"seriesIn":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":"0"},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":""}],"total_in":0,"total_out":0,"profit":0,"seriesProfit":[{"key":5493,"name":"97289742","avatar":"\/img\/avatar-default.jpg","y":0},{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","avatar":"\/img\/avatar-default.jpg","y":0}]},"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-01 15:38:07', 176442880) RETURNING "id"
15:38:07.3150.8 msyii\db\Command::querySELECT SUM(t.amount * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_sales_contracts" "sc" ON sc.from_project = pd.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."tbl_erp_profit_distributes" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id"))
15:38:07.1580.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5493
15:38:07.3180.8 msyii\db\Command::querySELECT SUM((eipss.actual_total_amount - eipss.total_amount) * am.pct / 100) FROM "o6a13e2c574d5a"."tbl_erp_profit_distribute_pcts" "am" LEFT JOIN "o6a13e2c574d5a"."tbl_erp_profit_distributes" "pd" ON am.erp_profit_distribute_id = pd.id LEFT JOIN "o6a13e2c574d5a"."tbl_erp_sales_gifts" "t" ON pd.project_id = t.project_id LEFT JOIN "o6a13e2c574d5a"."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 "o6a13e2c574d5a"."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)
15:38:07.1600.5 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
15:38:07.3220.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495))
15:38:07.2990.3 msyii\db\Command::querySELECT SUM(budget - cost) FROM "o6a13e2c574d5a"."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')
15:38:07.1580.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:38:07.3320.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495))
15:38:07.3190.2 msyii\db\Command::querySELECT SUM(expense) FROM "o6a13e2c574d5a"."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')