ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c8cb49b198f: POST https://beta.jinchangxiao.com/vue/setting/list-erp-account-caption at 2025-09-16 10:28:25 am by 114.244.128.96

Database Queries

总计34条数据
TimeDurationTypeQuery
  
10:28:25.7312.2 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5016

[+] Explain
10:28:25.7341.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
10:28:25.7370.9 msSELECTSELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"

[+] Explain
10:28:25.7380.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"

[+] Explain
10:28:25.7380.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56)

[+] Explain
10:28:25.7390.3 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
10:28:25.7390.7 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
10:28:25.7400.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
10:28:25.7410.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (54, 52)

[+] Explain
10:28:25.7410.2 msSELECTSELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
10:28:25.7410.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
10:28:25.7420.1 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10

[+] Explain
10:28:25.7420.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=4104

[+] Explain
10:28:25.7430.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410102

[+] Explain
10:28:25.7430.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410101

[+] Explain
10:28:25.7430.5 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7451.3 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

[+] Explain
10:28:25.7460.6 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7481.2 msSELECTSELECT SUM(esrps.total_actual_amount) FROM "a57be577deb434"."tbl_erp_sales_return_products" "esrps" LEFT JOIN "a57be577deb434"."tbl_erp_sales_returns" "t" ON esrps.erp_sales_return_id = t.id WHERE "t"."status"=2

[+] Explain
10:28:25.7531.1 msSELECTSELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7550.5 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7577.0 msSELECTSELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE ("t"."status"=2) AND ("t"."created_at" >= '2025-08-08 00:00')

[+] Explain
10:28:25.7681.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7690.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7741.0 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7750.4 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

[+] Explain
10:28:25.7801.1 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7810.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_personal_taxs" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7820.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_prizes" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7820.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_social_insurances" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7830.4 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_provident_funds" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7881.0 msSELECTSELECT SUM(t.out_amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7890.2 msSELECTSELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_builds" "t" WHERE "t"."status"=2

[+] Explain
10:28:25.7901.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/setting/list-erp-account-caption', '{"is_delete":"","type":"3","keyword":"","page":"1","web_access_token":"Ma1CLo37erP-0kiZ7BiRFWIjlwsiNp2I"}', '{"code":2000,"result":{"list":[{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"7280982.76","balance_amount":"7280982.76","actual_amount":"7280982.76","description":"","type":3,"sort":1,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","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":51,"parent_id":"","title":"\u8d44\u672c\u516c\u79ef","serial_no":"4002","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","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":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":69,"parent_id":52,"title":"\u6cd5\u5b9a\u76c8\u4f59\u516c\u79ef","serial_no":"410101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":70,"parent_id":52,"title":"\u4efb\u610f\u76c8\u4f59\u516c\u79ef","serial_no":"410102","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":52,"parent_id":"","title":"\u76c8\u4f59\u516c\u79ef","serial_no":"4101","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":3,"can_create_child":false,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"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":true,"can_start":false,"bgcolor":"#89c541"},{"id":53,"parent_id":"","title":"\u5229\u6da6\u5206\u914d","serial_no":"4104","amount":"-2083312.62","balance_amount":"-2083312.62","actual_amount":"-2083312.62","description":"","type":3,"sort":4,"can_create_child":true,"can_change_amount":true,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","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":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":0,"description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","child":[{"id":67,"parent_id":54,"title":"\u4f18\u5148\u80a1","serial_no":"611601","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":1,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"can_start":false},{"id":68,"parent_id":54,"title":"\u6c38\u7eed\u503a","serial_no":"611602","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":2,"can_create_child":false,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":"","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":54,"parent_id":"","title":"\u5176\u4ed6\u6743\u76ca\u5de5\u5177","serial_no":"6116","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":5,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","updated_at":""},"can_update":true,"can_delete":false,"can_stop":true,"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":true,"can_start":false,"bgcolor":"#89c541"},{"id":55,"parent_id":"","title":"\u5176\u4ed6\u7efc\u5408\u6536\u76ca","serial_no":"6111","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":6,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","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":56,"parent_id":"","title":"\u4e13\u9879\u50a8\u5907","serial_no":"4301","amount":"0","balance_amount":"0","actual_amount":"0","description":"","type":3,"sort":7,"can_create_child":true,"can_change_amount":false,"is_system":true,"is_delete":false,"is_current":false,"created_by":1000,"created_at":"2025-08-01 23:14:45","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":7,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 10:28:25') RETURNING "id"

[+] Explain