ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a20f07c01ffb: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-profit-a-loss at 2026-06-04 11:26:52 am by 221.216.117.119

Database Queries

总计72条数据
TimeDurationTypeQuery
  
11:26:52.0100.6 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
11:26:52.0110.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
11:26:52.0130.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:52.0140.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:52.0140.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:52.0150.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-07-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:52.0150.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)

[+] Explain
11:26:52.0150.5 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0160.3 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0160.3 msSELECTSELECT SUM(budget) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0170.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0170.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0180.2 msSELECTSELECT SUM(budget) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0180.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0180.2 msSELECTSELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0190.2 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0190.2 msSELECTSELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0190.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0200.2 msSELECTSELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0200.2 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0210.2 msSELECTSELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_disassembles" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0210.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0210.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_overflows" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0220.4 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0220.3 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0230.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0230.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0240.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=19) AND ("is_system"=TRUE)

[+] Explain
11:26:52.0240.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"

[+] Explain
11:26:52.0251.2 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (399, 400, 401, 402, 430, 431, 439)) GROUP BY "id"

[+] Explain
11:26:52.0260.9 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (399, 400, 401, 402, 430, 431, 439)) GROUP BY "id"

[+] Explain
11:26:52.0270.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 398) AND ("term_id"=19) AND ("is_system"=FALSE)

[+] Explain
11:26:52.0280.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE 0=1 ORDER BY "is_delete", "sort"

[+] Explain
11:26:52.0280.4 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) GROUP BY "id"

[+] Explain
11:26:52.0290.4 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_other_income_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 14 WHERE "r"."status"=2) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 20 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) AND ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) GROUP BY "id"

[+] Explain
11:26:52.0290.6 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0300.2 msSELECTSELECT SUM(cost) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0300.5 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0310.2 msSELECTSELECT SUM(cost) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0310.3 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0320.2 msSELECTSELECT SUM(amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status"=2) AND ("t"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0320.6 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0330.5 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0343.3 msSELECTSELECT SUM(sub.amount) FROM ((SELECT r.amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 )) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0370.2 msSELECTSELECT SUM(expense) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0380.2 msSELECTSELECT SUM(wage) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-06-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0382.1 msSELECTSELECT SUM(amount) FROM ((SELECT r.amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_social_insurances" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_provident_funds" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_personal_taxs" "r" WHERE "r"."status"=2 ) UNION ALL ( SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2 )) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0400.2 msSELECTSELECT SUM(expense) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0410.2 msSELECTSELECT SUM(wage) FROM "a57be577deb434"."tbl_erp_user_profits" "t" WHERE ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0410.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=15) AND ("is_system"=TRUE)

[+] Explain
11:26:52.0410.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=385 ORDER BY "is_delete", "sort"

[+] Explain
11:26:52.0422.3 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 426, 427, 428, 425, 429, 432, 433, 434, 435, 438, 440)) GROUP BY "id"

[+] Explain
11:26:52.0452.7 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 426, 427, 428, 425, 429, 432, 433, 434, 435, 438, 440)) GROUP BY "id"

[+] Explain
11:26:52.0470.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 385) AND ("term_id"=15)

[+] Explain
11:26:52.0480.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id" IN (406, 417, 412, 436, 185, 419, 198, 196, 197, 184, 183, 205, 307, 415, 308) ORDER BY "is_delete", "sort"

[+] Explain
11:26:52.0492.4 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) GROUP BY "id"

[+] Explain
11:26:52.0522.8 msSELECTSELECT "id", sum(amount) as amount FROM ((SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.bank_settle_at as verify_at FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 11 WHERE ("r"."status"=2) AND ("is_payment_settle"=TRUE)) UNION ALL ( SELECT dt.taxonomy_id as id, dt.out_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 9 WHERE "r"."status"=2 ) UNION ALL ( SELECT dt.taxonomy_id as id, dt.in_amount as amount, r.verify_at FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt" ON dt.object_id = r.id AND dt.term_id = 18 AND dt.object_type = 10 WHERE "r"."status"=2 )) "sub" WHERE ("sub"."verify_at" >= '2026-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) AND ("sub"."verify_at" >= '2026-01-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND ("id" IN (323, 349, 367, 346, 338, 327, 369, 348, 326, 354, 377, 374, 332, 356, 342, 340, 352, 366, 379, 380, 384, 405, 407, 408, 409, 410, 411, 413, 414, 416, 418, 420, 421, 422, 423, 437, 372, 371, 364, 355, 357, 362, 329, 368, 334, 345, 335, 350, 361, 365, 378, 373, 331, 358, 337, 325, 336, 347, 324, 339, 343, 341, 370, 328, 353, 376, 363, 344, 359, 351, 330, 360, 333, 375)) GROUP BY "id"

[+] Explain
11:26:52.0550.3 msSELECTSELECT SUM(sub.amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0560.6 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0570.5 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0570.4 msSELECTSELECT 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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0580.2 msSELECTSELECT SUM(amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_tickets" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0580.3 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0590.3 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0590.3 msSELECTSELECT 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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0600.4 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0600.4 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0610.3 msSELECTSELECT 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-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0610.3 msSELECTSELECT 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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0620.2 msSELECTSELECT SUM(sub.amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-06-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0620.2 msSELECTSELECT SUM(amount) FROM (SELECT r.amount, r.verify_at FROM "a57be577deb434"."tbl_erp_wage_prizes" "r" WHERE "r"."status"=2) "sub" WHERE ("verify_at" >= '2026-01-01 00:00:00') AND ("verify_at" <= '2026-06-30 23:59:59')

[+] Explain
11:26:52.0632.7 msINSERTINSERT 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-analysis/list-profit-a-loss', '{"year":"2026","month":"6","hide":"0","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"title":"\u6536\u5165\u7c7b","type":"total_in","amount":0,"all_amount":20871829.69,"type_id":"","child_type_id":"","index":1},{"title":"\u9500\u552e\u6536\u5165","type":"sales_amount","amount":0,"all_amount":20281011.2,"type_id":"","child_type_id":"","index":2},{"title":"\u5546\u54c1\u7c7b\u6536\u5165","type":"inventory_build","amount":0,"all_amount":530893,"type_id":"","child_type_id":"","index":2},{"title":"\u5546\u54c1\u62c6\u88c5\u5dee\u4ef7","type":"inventory_build_disassemble","amount":0,"all_amount":296155,"type_id":"","child_type_id":"","index":3},{"title":"\u5546\u54c1\u62a5\u6ea2\u91d1\u989d","type":"inventory_overflow","amount":"","all_amount":"234738","type_id":"","child_type_id":"","index":3},{"title":"\u5176\u4ed6\u6536\u5165","type":"other_income","amount":0,"all_amount":59925.49,"type_id":"","child_type_id":"","index":2},{"title":"\u5229\u606f\u6536\u5165","type":"other_income","type_id":"","child_type_id":399,"amount":0,"all_amount":"194.89","index":3},{"title":"\u5176\u4ed6\u6536\u5165","type":"other_income","type_id":"","child_type_id":400,"amount":0,"all_amount":0,"index":3},{"title":"\u8fd4\u70b9\u83b7\u5229\u6536\u5165","type":"other_income","type_id":"","child_type_id":401,"amount":0,"all_amount":"703.6","index":3},{"title":"\u8c03\u8d26\u6536\u5165","type":"other_income","type_id":"","child_type_id":402,"amount":0,"all_amount":"41737","index":3},{"title":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6","type":"other_income","type_id":"","child_type_id":430,"amount":0,"all_amount":"17290","index":3},{"title":"\u4ee3\u4ea4\u793e\u4fdd\u6536\u5165","type":"other_income","type_id":"","child_type_id":431,"amount":0,"all_amount":0,"index":3},{"title":"\u9500\u552e\u7a0e\u91d1\u6536\u5165","type":"other_income","type_id":"","child_type_id":439,"amount":0,"all_amount":0,"index":3},{"title":"\u652f\u51fa\u7c7b","type":"total_out","type_id":"","child_type_id":"","amount":870390,"all_amount":8272293.7183333,"index":1},{"title":"\u9500\u552e\u6210\u672c","type":"sales_cost","type_id":"","child_type_id":"","amount":0,"all_amount":6139696.235,"index":2},{"title":"\u5546\u54c1\u7c7b\u652f\u51fa","type":"product_out","type_id":"","child_type_id":"","amount":232323,"all_amount":394849.83333333,"index":2},{"title":"\u5546\u54c1\u62a5\u635f\u91d1\u989d","type":"inventory_lost","type_id":"","child_type_id":"","amount":"232323","all_amount":"267668","index":3},{"title":"\u8d60\u9001\u4ea7\u54c1\u652f\u51fa","type":"sales_gift","type_id":"","child_type_id":"","amount":"","all_amount":"127181.8333333332","index":3},{"title":"\u8d39\u7528\u5408\u8ba1","type":"total_cost","type_id":"","child_type_id":"","amount":638067,"all_amount":1737747.65,"index":2},{"title":"\u8d44\u4ea7\u5904\u7f6e\u635f\u76ca","type":"cost","type_id":"","child_type_id":386,"amount":0,"all_amount":"1574","index":3},{"title":"\u5e73\u53f0\u4f63\u91d1","type":"cost","type_id":"","child_type_id":387,"amount":0,"all_amount":0,"index":3},{"title":"\u5176\u4ed6\u8d39\u7528","type":"cost","type_id":"","child_type_id":388,"amount":0,"all_amount":0,"index":3},{"title":"\u90e8\u95e8\u7ba1\u7406\u8d39\u7528","type":"cost","type_id":"","child_type_id":389,"amount":0,"all_amount":0,"index":3},{"title":"\u4f18\u60e0","type":"cost","type_id":"","child_type_id":390,"amount":0,"all_amount":0,"index":3},{"title":"\u56fa\u5b9a\u8d44\u4ea7\u6298\u65e7","type":"cost","type_id":"","child_type_id":391,"amount":0,"all_amount":0,"index":3},{"title":"\u624b\u7eed\u8d39","type":"cost","type_id":"","child_type_id":392,"amount":0,"all_amount":"24.5","index":3},{"title":"\u7a0e\u91d1","type":"cost","type_id":"","child_type_id":393,"amount":0,"all_amount":"192666.60","index":3},{"title":"\u8d54\u4ed8","type":"cost","type_id":"","child_type_id":394,"amount":0,"all_amount":0,"index":3},{"title":"\u8fd0\u8d39","type":"cost","type_id":"","child_type_id":395,"amount":0,"all_amount":0,"index":3},{"title":"\u8c03\u8d26\u4e8f\u635f","type":"cost","type_id":"","child_type_id":396,"amount":0,"all_amount":0,"index":3},{"title":"\u5de5\u4f1a\u7ecf\u8d39","type":"cost","type_id":"","child_type_id":397,"amount":0,"all_amount":"9578.58","index":3},{"title":"\u57ce\u5e02\u7ef4\u62a4\u5efa\u8bbe\u7a0e","type":"cost","type_id":"","child_type_id":426,"amount":0,"all_amount":"6743.33","index":3},{"title":"\u6559\u80b2\u8d39\u9644\u52a0","type":"cost","type_id":"","child_type_id":427,"amount":0,"all_amount":"2889.99","index":3},{"title":"\u5730\u65b9\u6559\u80b2\u9644\u52a0","type":"cost","type_id":"","child_type_id":428,"amount":0,"all_amount":"1926.65","index":3},{"title":"\u5404\u79cd\u9879\u76ee\u5956\u52b1","type":"cost","type_id":"","child_type_id":425,"amount":0,"all_amount":"33142","index":3},{"title":"\u9500\u552e\u4eba\u5458\u8d39\u7528","type":"cost","type_id":"","child_type_id":429,"amount":0,"all_amount":"17290","index":3},{"title":"\u56de\u6263\u8fd4\u70b9","type":"cost","type_id":"","child_type_id":432,"amount":0,"all_amount":"433936","index":3},{"title":"\u8d2d\u53d1\u7968\u7a0e\u70b9","type":"cost","type_id":"","child_type_id":433,"amount":0,"all_amount":"8059","index":3},{"title":"\u91d1\u7545\u900d\u8d39\u7528","type":"cost","type_id":"","child_type_id":434,"amount":0,"all_amount":"8325.76","index":3},{"title":"\u601d\u8054\u79d1\u8baf\u8d39\u7528","type":"cost","type_id":"","child_type_id":435,"amount":0,"all_amount":0,"index":3},{"title":"\u9500\u552e\u7a0e\u91d1","type":"cost","type_id":"","child_type_id":438,"amount":0,"all_amount":0,"index":3},{"title":"\u5370\u82b1\u7a0e","type":"cost","type_id":"","child_type_id":440,"amount":0,"all_amount":"4005.86","index":3},{"title":"\u4f1a\u8bae\u8d39","type":"cost","type_id":406,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u6c34\u7535\u51b7\u6696\u8d39","type":"cost","type_id":417,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u8d22\u52a1\u8d39\u7528","type":"cost","type_id":412,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u88c5\u4fee\u8d39","type":"cost","type_id":436,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u4e1a\u52a1\u62db\u5f85\u8d39","type":"cost","type_id":185,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u4eba\u529b\u8d44\u6e90\u8d39","type":"cost","type_id":419,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u6807\u4e66\u8d39","type":"cost","type_id":198,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u54a8\u8be2\u8d39","type":"cost","type_id":196,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u5e7f\u544a\u8d39","type":"cost","type_id":197,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u4ea4\u901a\u8d39","type":"cost","type_id":184,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u5dee\u65c5\u8d39","type":"cost","type_id":183,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u5176\u4ed6","type":"cost","type_id":205,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u529e\u516c\u8d39","type":"cost","type_id":307,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u623f\u79df\u7269\u4e1a\u8d39","type":"cost","type_id":415,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u529e\u516c\u8f6f\u4ef6","type":"cost","type_id":308,"child_type_id":"","amount":0,"all_amount":0,"index":3},{"title":"\u5de5\u8d44","type":"wageTicket","type_id":"","child_type_id":"","amount":500067,"all_amount":500113,"index":3},{"title":"\u793e\u4fdd","type":"wage","type_id":"","child_type_id":"","amount":"115000","all_amount":"115000","index":3},{"title":"\u516c\u79ef\u91d1","type":"providentFunds","type_id":"","child_type_id":"","amount":"23000","all_amount":"23000","index":3},{"title":"\u5956\u91d1","type":"wagePrizes","type_id":"","child_type_id":"","amount":"","all_amount":"","index":3},{"title":"\u5229\u6da6","type":"profit","type_id":"","child_type_id":"","amount":-870390,"all_amount":12599535.971667,"index":1}]},"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; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-04 11:26:52', 54456832) RETURNING "id"

[+] Explain