ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2a6a57c3e13: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-profit-a-loss at 2026-06-11 03:57:11 pm by 221.216.117.119

Performance Profiling

Total processing time: 206 ms; Peak memory: 4.649 MB. Show Profiling Timeline

总计73条数据
TimeDurationCategoryInfo
  
15:57:11.84612.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:57:11.81710.4 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:57:11.8817.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
15:57:11.8936.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-05-01') AND ("is_settle"=TRUE)
15:57:11.9405.4 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')
15:57:11.9714.9 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"
15:57:11.9574.8 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"
15:57:11.9664.6 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"
15:57:11.9524.2 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"
15:57:11.8753.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-6-01') AND ("is_settle"=TRUE)
15:57:11.9943.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":"2SCKb3BYAaSLDxSx0sIX1KfVKBB-1lWj"}', '{"code":2000,"result":{"list":[{"title":"\u6536\u5165\u7c7b","type":"total_in","amount":1,"all_amount":20871830.69,"type_id":"","child_type_id":"","index":1},{"title":"\u9500\u552e\u6536\u5165","type":"sales_amount","amount":1,"all_amount":20281012.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":871278,"all_amount":8273181.7183333,"index":1},{"title":"\u9500\u552e\u6210\u672c","type":"sales_cost","type_id":"","child_type_id":"","amount":888,"all_amount":6140584.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":-871277,"all_amount":12598648.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-11 15:57:11', 181221888) RETURNING "id"
15:57:11.9462.9 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')
15:57:11.9242.9 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"
15:57:11.9271.5 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"
15:57:11.9201.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=19) AND ("is_system"=TRUE)
15:57:11.9781.3 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')
15:57:11.8161.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:57:11.9631.1 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"
15:57:11.9311.0 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')
15:57:11.9801.0 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')
15:57:11.9820.9 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')
15:57:11.9220.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"
15:57:11.9330.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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:57:11.9370.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')
15:57:11.9120.9 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')
15:57:11.9030.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')
15:57:11.9860.8 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')
15:57:11.9080.8 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')
15:57:11.9880.8 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')
15:57:11.9840.7 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')
15:57:11.9350.7 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')
15:57:11.9770.7 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')
15:57:11.9890.7 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')
15:57:11.9850.6 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')
15:57:11.9860.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-01-01 00:00:00') AND ("t"."verify_at" <= '2026-06-30 23:59:59')
15:57:11.9150.6 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')
15:57:11.9180.6 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')
15:57:11.9890.6 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')
15:57:11.9380.6 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')
15:57:11.9050.5 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')
15:57:11.9170.5 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')
15:57:11.9050.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')
15:57:11.9900.5 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')
15:57:11.9830.5 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')
15:57:11.9070.5 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')
15:57:11.9090.5 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')
15:57:11.9140.5 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')
15:57:11.9910.5 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')
15:57:11.9080.4 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')
15:57:11.9140.4 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')
15:57:11.9110.4 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')
15:57:11.9130.4 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')
15:57:11.9360.4 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')
15:57:11.9300.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-06-01 00:00:00') AND ("sub"."verify_at" <= '2026-06-30 23:59:59') AND (0=1) GROUP BY "id"
15:57:11.9100.4 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')
15:57:11.9620.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 385) AND ("term_id"=15)
15:57:11.9300.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-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"
15:57:11.9510.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=385 ORDER BY "is_delete", "sort"
15:57:11.9320.4 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')
15:57:11.9020.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2026-07-01') AND ("is_settle"=TRUE)
15:57:11.9340.4 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')
15:57:11.9290.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("id" != 398) AND ("term_id"=19) AND ("is_system"=FALSE)
15:57:11.9500.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("name"='财务科目') AND ("term_id"=15) AND ("is_system"=TRUE)
15:57:11.9060.3 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')
15:57:11.9190.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')
15:57:11.9160.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')
15:57:11.9450.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')
15:57:11.9190.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')
15:57:11.9030.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_settles" WHERE ("date"='2025-12-01') AND ("is_settle"=TRUE)
15:57:11.9460.3 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')
15:57:11.9490.2 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')
15:57:11.9500.2 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')
15:57:11.9290.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE 0=1 ORDER BY "is_delete", "sort"