ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6895c75786c92: POST https://beta.jinchangxiao.com/vue/setting/list-erp-account-caption at 2025-08-08 05:45:59 pm by 124.64.23.198

Performance Profiling

Total processing time: 52 ms; Peak memory: 5.089 MB. Show Profiling Timeline

总计26条数据
TimeDurationCategoryInfo
  
17:45:59.5834.7 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND ("sales_contract_id" IN (SELECT "t"."id" FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON t.client_id = c.id WHERE (("c"."sales_rep" IN (1001, 5087, 1005, 1004, 5295, 5300, 5311, 5332, 1013, 5449)) OR (c.sales_rep is null)) AND ("t"."created_at" < '2025-08-05 17:19:26') AND (need_analysis = true))) AND ("t"."created_at" < '2025-08-05 17:19:26')
17:45:59.5794.2 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_sales_contracts" "t" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON t.client_id = c.id WHERE (("c"."sales_rep" IN (1001, 5087, 1005, 1004, 5295, 5300, 5311, 5332, 1013, 5449)) OR (c.sales_rep is null)) AND ("t"."created_at" < '2025-08-05 17:19:26') AND (need_analysis = true)
17:45:59.5573.1 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:45:59.5542.6 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:45:59.5992.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-erp-account-caption', '{"is_delete":"","type":"1","keyword":"","page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":1,"parent_id":"","title":"\u5e93\u5b58\u73b0\u91d1","serial_no":"1001","amount":"0","balance_amount":"0","actual_amount":30000007,"description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[{"id":73,"parent_id":1,"title":"\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1\u73b0\u91d1","serial_no":"100201","amount":"30000007","balance_amount":"30000007","actual_amount":"30000007","description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"2025-08-08 17:45:30","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":1,"parent_id":"","title":"\u5e93\u5b58\u73b0\u91d1","serial_no":"1001","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":1,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":false,"can_start":false}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":11999890.54,"description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[{"id":71,"parent_id":3,"title":"\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d\u652f\u4ed8\u5b9d","serial_no":"100101","amount":"10000000","balance_amount":"9999890.54","actual_amount":"9999890.54","description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"2025-08-07 18:01:25","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":false,"can_start":false},{"id":72,"parent_id":3,"title":"\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e\u94f6\u884c\u5b58\u6b3e","serial_no":"100102","amount":"2000000","balance_amount":"2000000","actual_amount":"2000000","description":"","type":1,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"2025-08-07 18:01:14","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"parent":{"id":3,"parent_id":"","title":"\u5168\u90e8\u94f6\u884c\u8d26\u6237","serial_no":"1002","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":2,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":""},"can_update":true,"can_delete":false,"can_stop":false,"can_start":false}],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":4,"parent_id":"","title":"\u4ee5\u516c\u5141\u4ef7\u503c\u8ba1\u91cf\u4e14\u5176\u53d8\u52a8\u8ba1\u5165\u5f53\u671f\u635f\u76ca\u7684\u91d1\u878d\u8d44\u4ea7","serial_no":"1101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":3,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":5,"parent_id":"","title":"\u884d\u751f\u91d1\u878d\u8d44\u4ea7","serial_no":"1421","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":4,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":6,"parent_id":"","title":"\u5e94\u6536\u7968\u636e","serial_no":"1121","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":5,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":7,"parent_id":"","title":"\u5e94\u6536\u8d26\u6b3e","serial_no":"1122","amount":"0","balance_amount":"0","actual_amount":13725556,"description":"","type":1,"sort":6,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":8,"parent_id":"","title":"\u9884\u4ed8\u8d26\u6b3e","serial_no":"1123","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":7,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":11,"parent_id":"","title":"\u5176\u4ed6\u5e94\u6536\u6b3e","serial_no":"1132","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":10,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":12,"parent_id":"","title":"\u5e93\u5b58\u5546\u54c1","serial_no":"1221","amount":"0","balance_amount":"0","actual_amount":"3000","description":"","type":1,"sort":11,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":false,"can_start":false,"bgcolor":"#89c541"},{"id":13,"parent_id":"","title":"\u6301\u6709\u5f85\u552e\u8d44\u4ea7","serial_no":"1481","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":12,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":14,"parent_id":"","title":"\u4e00\u5e74\u5185\u5230\u671f\u7684\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1501","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":13,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":15,"parent_id":"","title":"\u5176\u4ed6\u6d41\u52a8\u8d44\u4ea7","serial_no":"1401","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":14,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":true,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":16,"parent_id":"","title":"\u53ef\u4f9b\u51fa\u552e\u91d1\u878d\u8d44\u4ea7","serial_no":"1503","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":15,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":17,"parent_id":"","title":"\u6301\u6709\u81f3\u5230\u671f\u6295\u8d44","serial_no":"1502","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":16,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":18,"parent_id":"","title":"\u957f\u671f\u5e94\u6536\u6b3e","serial_no":"1506","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":17,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":19,"parent_id":"","title":"\u957f\u671f\u80a1\u6743\u6295\u8d44","serial_no":"1511","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":18,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":20,"parent_id":"","title":"\u6295\u8d44\u6027\u623f\u5730\u4ea7","serial_no":"1521","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":19,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":21,"parent_id":"","title":"\u56fa\u5b9a\u8d44\u4ea7","serial_no":"1601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":20,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":22,"parent_id":"","title":"\u5728\u5efa\u5de5\u7a0b","serial_no":"1604","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":21,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":23,"parent_id":"","title":"\u751f\u4ea7\u6027\u751f\u7269\u8d44\u4ea7","serial_no":"1621","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":22,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":24,"parent_id":"","title":"\u65e0\u5f62\u8d44\u4ea7","serial_no":"1701","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":23,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":25,"parent_id":"","title":"\u6cb9\u6c14\u8d44\u4ea7","serial_no":"1531","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":24,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":26,"parent_id":"","title":"\u5f00\u53d1\u652f\u51fa","serial_no":"1702","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":25,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":27,"parent_id":"","title":"\u5546\u8a89","serial_no":"1711","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":26,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":28,"parent_id":"","title":"\u957f\u671f\u5f85\u644a\u8d39\u7528","serial_no":"1801","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":1,"sort":27,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":29,"parent_id":"","title":"\u9012\u5ef6\u6240\u5f97\u7a0e\u8d44\u4ea7","serial_no":"1811","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":28,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":30,"parent_id":"","title":"\u5176\u4ed6\u975e\u6d41\u52a8\u8d44\u4ea7","serial_no":"1901","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":1,"sort":29,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-04 10:34:39","updated_at":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":false,"can_delete":false,"can_stop":true,"can_start":false,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":27,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:45:59') RETURNING "id"
17:45:59.5612.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:45:59.5751.6 msyii\db\Command::querySELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON u.id = aa.user_id WHERE ("u"."user_status"=1) AND ("aa"."item_name"='AccountManager')
17:45:59.5661.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='1') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"
17:45:59.5901.3 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE "t"."status"=2
17:45:59.5881.1 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_orders" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-05 17:19:26')
17:45:59.5691.1 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
17:45:59.5920.9 msyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-05 17:19:26')
17:45:59.5910.9 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_returns" "t" WHERE "t"."status"=2
17:45:59.5730.8 msyii\db\Command::querySELECT SUM(balance_amount) FROM "a57be577deb434"."tbl_erp_banks" WHERE "type"=1
17:45:59.5940.7 msyii\db\Command::querySELECT SUM(t.amount - t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_collect_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:45:59.5950.7 msyii\db\Command::querySELECT SUM(inventory * actual_amount) FROM "a57be577deb434"."tbl_erp_inventory_products"
17:45:59.5960.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=1801
17:45:59.5670.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='1') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
17:45:59.5710.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:45:59.5680.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (1, 3, 4, 5, 6, 7, 8, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30)
17:45:59.5690.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:45:59.5710.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (3, 1)
17:45:59.5720.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:45:59.5740.3 msyii\db\Command::querySELECT SUM(balance_amount) FROM "a57be577deb434"."tbl_erp_banks" WHERE "type"=0
17:45:59.5720.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
17:45:59.5730.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10