ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a3e167ac7e91: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-profit-a-loss at 2026-06-26 02:04:42 pm by 221.216.117.25

Database Queries

总计72条数据
TimeDurationTypeQuery
  
14:04:42.8432.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:04:42.8482.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

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

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

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

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

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

[+] Explain
14:04:42.8600.9 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
14:04:42.8610.6 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
14:04:42.8621.6 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
14:04:42.8640.3 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
14:04:42.8650.3 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
14:04:42.8650.3 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
14:04:42.8660.6 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
14:04:42.8670.4 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
14:04:42.8670.3 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
14:04:42.8680.3 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
14:04:42.8680.5 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
14:04:42.8690.3 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
14:04:42.8700.3 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
14:04:42.8700.3 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
14:04:42.8710.6 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
14:04:42.8710.3 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
14:04:42.8720.6 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
14:04:42.8730.6 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
14:04:42.8740.3 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
14:04:42.8740.3 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
14:04:42.8751.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=19) AND ("is_system"=TRUE)

[+] Explain
14:04:42.8770.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"

[+] Explain
14:04:42.8782.7 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
14:04:42.8812.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-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
14:04:42.8840.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 398) AND ("term_id"=19) AND ("is_system"=FALSE)

[+] Explain
14:04:42.8840.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE 0=1 ORDER BY "is_delete", "sort"

[+] Explain
14:04:42.8850.5 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
14:04:42.8860.5 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
14:04:42.8874.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-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
14:04:42.8910.3 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
14:04:42.8920.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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')

[+] Explain
14:04:42.8930.3 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
14:04:42.8930.6 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
14:04:42.8940.3 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
14:04:42.8950.8 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
14:04:42.8960.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
14:04:42.8986.2 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
14:04:42.9040.3 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
14:04:42.9050.3 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
14:04:42.9063.3 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
14:04:42.9090.3 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
14:04:42.9100.3 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
14:04:42.9100.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=15) AND ("is_system"=TRUE)

[+] Explain
14:04:42.9110.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=385 ORDER BY "is_delete", "sort"

[+] Explain
14:04:42.91217.6 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
14:04:42.93052.1 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
14:04:42.9925.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 385) AND ("term_id"=15)

[+] Explain
14:04:43.0026.3 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
14:04:43.01410.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-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
14:04:43.0287.9 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
14:04:43.0395.1 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
14:04:43.04910.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
14:04:43.06813.8 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
14:04:43.09710.2 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
14:04:43.1107.0 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
14:04:43.1217.1 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
14:04:43.1316.0 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
14:04:43.1407.2 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
14:04:43.1496.0 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
14:04:43.1586.1 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
14:04:43.1678.1 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
14:04:43.1766.1 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
14:04:43.1856.0 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
14:04:43.1958.0 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
14:04:43.21512.5 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":"1"}', '{"code":2000,"result":{"list":[{"title":"\u6536\u5165\u7c7b","type":"total_in","amount":-17999,"all_amount":20853830.69,"type_id":"","child_type_id":"","index":1},{"title":"\u9500\u552e\u6536\u5165","type":"sales_amount","amount":-17999,"all_amount":20263012.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":"\u5176\u4ed6\u6536\u5165","type":"other_income","amount":0,"all_amount":59925.49,"type_id":"","child_type_id":"","index":2},{"title":"\u652f\u51fa\u7c7b","type":"total_out","type_id":"","child_type_id":"","amount":871378,"all_amount":8273280.7183333,"index":1},{"title":"\u9500\u552e\u6210\u672c","type":"sales_cost","type_id":"","child_type_id":"","amount":888,"all_amount":6140583.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":"\u8d39\u7528\u5408\u8ba1","type":"total_cost","type_id":"","child_type_id":"","amount":638167,"all_amount":1737847.65,"index":2},{"title":"\u5229\u6da6","type":"profit","type_id":"","child_type_id":"","amount":-889377,"all_amount":12580549.971667,"index":1}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/149.0.0.0 Safari\/537.36"}', FALSE, '2026-06-26 14:04:43', 394819072) RETURNING "id"

[+] Explain