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

Performance Profiling

Total processing time: 162 ms; Peak memory: 4.646 MB. Show Profiling Timeline

总计73条数据
TimeDurationCategoryInfo
  
11:25:51.85918.7 msyii\db\Command::querySELECT "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"
11:25:51.75713.0 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:25:51.8227.4 msyii\db\Command::querySELECT "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"
11:25:51.8406.6 msyii\db\Command::querySELECT 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')
11:25:51.8855.1 msyii\db\Command::querySELECT "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"
11:25:51.7704.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:25:51.7904.4 msyii\db\Command::querySELECT 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')
11:25:51.8184.2 msyii\db\Command::querySELECT "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"
11:25:51.8104.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=19) AND ("is_system"=TRUE)
11:25:51.8554.0 msyii\db\Command::querySELECT "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"
11:25:51.8483.8 msyii\db\Command::querySELECT 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')
11:25:51.8813.3 msyii\db\Command::querySELECT "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"
11:25:51.7852.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
11:25:51.7772.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:25:51.9011.5 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-analysis/list-profit-a-loss', '{"year":"2026","month":"6","hide":"1","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":"\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":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":"\u8d39\u7528\u5408\u8ba1","type":"total_cost","type_id":"","child_type_id":"","amount":638067,"all_amount":1737747.65,"index":2},{"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:25:51', 147650816) RETURNING "id"
11:25:51.7981.2 msyii\db\Command::querySELECT 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')
11:25:51.8140.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"
11:25:51.8790.9 msyii\db\Command::querySELECT * 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"
11:25:51.8360.9 msyii\db\Command::querySELECT 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')
11:25:51.7880.9 msyii\db\Command::querySELECT 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')
11:25:51.8320.9 msyii\db\Command::querySELECT 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')
11:25:51.8910.9 msyii\db\Command::querySELECT 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')
11:25:51.8340.8 msyii\db\Command::querySELECT 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')
11:25:51.8370.7 msyii\db\Command::querySELECT 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')
11:25:51.8020.7 msyii\db\Command::querySELECT 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')
11:25:51.8930.7 msyii\db\Command::querySELECT 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')
11:25:51.8970.6 msyii\db\Command::querySELECT 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')
11:25:51.7830.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)
11:25:51.8930.6 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"."verify_at" >= '2026-06-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
11:25:51.8310.6 msyii\db\Command::querySELECT "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"
11:25:51.8310.6 msyii\db\Command::querySELECT "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"
11:25:51.8050.6 msyii\db\Command::querySELECT 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')
11:25:51.8980.5 msyii\db\Command::querySELECT 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')
11:25:51.8540.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=385 ORDER BY "is_delete", "sort"
11:25:51.8040.5 msyii\db\Command::querySELECT 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')
11:25:51.8950.5 msyii\db\Command::querySELECT 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')
11:25:51.7950.5 msyii\db\Command::querySELECT 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')
11:25:51.8060.5 msyii\db\Command::querySELECT 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')
11:25:51.8350.5 msyii\db\Command::querySELECT 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')
11:25:51.8990.5 msyii\db\Command::querySELECT 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')
11:25:51.8950.5 msyii\db\Command::querySELECT 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')
11:25:51.8980.4 msyii\db\Command::querySELECT 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')
11:25:51.8960.4 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"."verify_at" >= '2026-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
11:25:51.8780.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 385) AND ("term_id"=15)
11:25:51.7950.4 msyii\db\Command::querySELECT 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')
11:25:51.8910.4 msyii\db\Command::querySELECT 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')
11:25:51.8530.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=15) AND ("is_system"=TRUE)
11:25:51.8300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 398) AND ("term_id"=19) AND ("is_system"=FALSE)
11:25:51.8030.3 msyii\db\Command::querySELECT 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')
11:25:51.8070.3 msyii\db\Command::querySELECT 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')
11:25:51.7990.3 msyii\db\Command::querySELECT 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')
11:25:51.8940.3 msyii\db\Command::querySELECT 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')
11:25:51.8000.3 msyii\db\Command::querySELECT 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')
11:25:51.9000.3 msyii\db\Command::querySELECT 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')
11:25:51.7960.3 msyii\db\Command::querySELECT 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')
11:25:51.8050.3 msyii\db\Command::querySELECT 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')
11:25:51.8020.3 msyii\db\Command::querySELECT 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')
11:25:51.8360.3 msyii\db\Command::querySELECT 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')
11:25:51.8070.3 msyii\db\Command::querySELECT 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')
11:25:51.9000.3 msyii\db\Command::querySELECT 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')
11:25:51.8030.3 msyii\db\Command::querySELECT 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')
11:25:51.8000.3 msyii\db\Command::querySELECT 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')
11:25:51.8330.3 msyii\db\Command::querySELECT 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')
11:25:51.8520.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-06-30 23:59:59')
11:25:51.8530.3 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-06-30 23:59:59')
11:25:51.7960.3 msyii\db\Command::querySELECT 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')
11:25:51.8470.3 msyii\db\Command::querySELECT 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')
11:25:51.7840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
11:25:51.8300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE 0=1 ORDER BY "is_delete", "sort"
11:25:51.8480.2 msyii\db\Command::querySELECT 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')
11:25:51.7840.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
11:25:51.8350.2 msyii\db\Command::querySELECT 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')
11:25:51.7840.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-07-01') AND ("is_settle"=TRUE)