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

Performance Profiling

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

总计30条数据
TimeDurationCategoryInfo
  
17:21:21.6252.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:21:21.6231.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:21:21.6281.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:21:21.6681.5 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":"3","keyword":"","page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":50,"parent_id":"","title":"\u5b9e\u6536\u8d44\u672c","serial_no":"4001","amount":"0","balance_amount":"0","actual_amount":"0","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-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":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-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":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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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":"0","balance_amount":"0","actual_amount":90000,"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-04 10:34:39","updated_at":"","child":[{"id":66,"parent_id":53,"title":"\u672a\u5206\u914d\u5229\u6da6","serial_no":"410406","amount":"90000","balance_amount":"90000","actual_amount":"90000","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-04 10:34:39","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":53,"parent_id":"","title":"\u5229\u6da6\u5206\u914d","serial_no":"4104","amount":"0","balance_amount":"0","actual_amount":"0","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-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":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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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-04 10:34:39","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-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":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-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":7,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:21:21') RETURNING "id"
17:21:21.6401.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" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6311.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id") "c"
17:21:21.6430.9 msyii\db\Command::querySELECT 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" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6380.9 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6540.8 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_inventory_losts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6340.8 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:21:21.6480.7 msyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6500.7 msyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" WHERE "t"."status" IN (2, 5)
17:21:21.6490.6 msyii\db\Command::querySELECT SUM(t.settle_amount) FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6410.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_returns" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6600.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6650.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_purchase_gifts" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6550.6 msyii\db\Command::querySELECT SUM(t.amount) FROM "a57be577deb434"."tbl_erp_wage_tickets" "t" WHERE ("t"."status" IN (2, 5)) AND ("t"."created_at" >= '2025-08-01 00:00:00') AND ("t"."created_at" <= '2025-08-31 23:59:59')
17:21:21.6350.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:21:21.6710.4 msyii\db\Command::querySELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:141.0) Gecko/20100101 Firefox/141.0'
17:21:21.6330.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE ("type"='3') AND (parent_id is null) ORDER BY "is_delete", "sort", "id"
17:21:21.6330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "parent_id" IN (50, 51, 52, 53, 54, 55, 56)
17:21:21.6370.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410406
17:21:21.6350.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id" IN (54, 52, 53)
17:21:21.6340.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:21:21.6380.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410101
17:21:21.6710.2 msyii\db\Command::executeUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=6800 WHERE "id"=154
17:21:21.6360.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:21:21.6370.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "serial_no"=410102
17:21:21.6360.2 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:21:21.6370.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10