Performance Profiling

Total processing time: 18 ms; Peak memory: 4.806 MB. Show Profiling Timeline

总计7条数据

Time	Duration	Category	Info

13:38:29.635	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:38:29.633	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:38:29.646	1.4 ms	yii\db\Command::query	INSERT 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-role', '{"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":77,"name":"Admin","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u7cfb\u7edf\u7ba1\u7406\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2017-01-13 17:56:37","visible":true,"editable":false,"deletable":false,"order":-100,"system":true,"display_name":"\u7cfb\u7edf\u7ba1\u7406\u5458","can_update":false,"can_delete":false,"bgcolor":"#89c541"},{"id":78,"name":"GM","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u603b\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:53:13","visible":true,"editable":true,"deletable":false,"order":-90,"system":true,"display_name":"\u603b\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":79,"name":"Engineer","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5de5\u7a0b\u5e08)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-07-08 15:14:56","visible":true,"editable":true,"deletable":false,"order":-40,"system":true,"display_name":"\u5de5\u7a0b\u5e08","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":81,"name":"AccountManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-03-19 19:16:23","visible":true,"editable":true,"deletable":false,"order":-50,"system":true,"display_name":"\u5ba2\u6237\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":82,"name":"TechDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6280\u672f\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2022-11-07 17:54:26","visible":true,"editable":true,"deletable":false,"order":-70,"system":true,"display_name":"\u6280\u672f\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":83,"name":"SalesManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-04-25 22:24:33","visible":true,"editable":true,"deletable":false,"order":-60,"system":true,"display_name":"\u9500\u552e\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":84,"name":"SalesDirector","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9500\u552e\u603b\u76d1)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-03-21 07:10:24","visible":true,"editable":true,"deletable":false,"order":-80,"system":true,"display_name":"\u9500\u552e\u603b\u76d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":85,"name":"CommercialAttache","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5546\u52a1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2024-08-22 16:14:32","visible":true,"editable":true,"deletable":false,"order":-20,"system":true,"display_name":"\u5546\u52a1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":92,"name":"ProjectManager","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u9879\u76ee\u7ecf\u7406)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-22 13:21:50","updated_at":"2025-02-24 15:42:21","visible":true,"editable":true,"deletable":false,"order":-9,"system":true,"display_name":"\u9879\u76ee\u7ecf\u7406","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":86,"name":"StoreKeeper","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5e93\u7ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2016-12-27 11:24:21","updated_at":"2024-08-22 16:14:58","visible":true,"editable":true,"deletable":false,"order":-10,"system":true,"display_name":"\u5e93\u7ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":99,"name":"Accountant","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u4f1a\u8ba1\u4e13\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2017-04-25 23:29:27","updated_at":"2024-08-23 16:18:30","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u4f1a\u8ba1\u4e13\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":161,"name":"Dispatcher","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u6d3e\u5355\u5458)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2018-09-18 10:46:37","updated_at":"2022-11-07 17:37:14","visible":true,"editable":true,"deletable":false,"order":-8,"system":true,"display_name":"\u6d3e\u5355\u5458","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":175,"name":"Operator","type":1,"description":"\u7cfb\u7edf\u9ed8\u8ba4\u89d2\u8272(\u5ba2\u6237\u8fd0\u8425)\uff0c\u4e0d\u80fd\u5220\u9664\uff01","rule_name":"","data":"","created_at":"2019-12-02 18:25:10","updated_at":"2022-11-07 17:55:50","visible":true,"editable":true,"deletable":false,"order":-7,"system":true,"display_name":"\u5ba2\u6237\u8fd0\u8425","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":101,"name":"\u8f6f\u4ef6\u5f00\u53d1","type":1,"description":"","rule_name":"","data":"","created_at":"2017-05-25 16:47:52","updated_at":"2024-11-07 21:01:21","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8f6f\u4ef6\u5f00\u53d1","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":110,"name":"\u4eba\u529b\u8d44\u6e90","type":1,"description":"","rule_name":"","data":"","created_at":"2017-09-06 17:54:48","updated_at":"2025-04-15 13:43:22","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u4eba\u529b\u8d44\u6e90","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":174,"name":"\u7535\u8bdd\u9500\u552e","type":1,"description":"","rule_name":"","data":"","created_at":"2019-10-08 09:18:30","updated_at":"2022-11-07 17:56:59","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u7535\u8bdd\u9500\u552e","can_update":true,"can_delete":false,"bgcolor":"#89c541"},{"id":182,"name":"\u8fd0\u8425\u603b\u76d1","type":1,"description":"","rule_name":"","data":"","created_at":"2019-12-03 19:52:10","updated_at":"2022-11-07 17:57:11","visible":true,"editable":true,"deletable":true,"order":0,"system":false,"display_name":"\u8fd0\u8425\u603b\u76d1","can_update":true,"can_delete":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":17,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-26 13:38:29') RETURNING "id"
13:38:29.638	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:38:29.643	1.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name" IN ('Admin', 'GM', 'Engineer', 'AccountManager', 'TechDirector', 'SalesManager', 'SalesDirector', 'CommercialAttache', 'ProjectManager', 'StoreKeeper', 'Accountant', 'Dispatcher', 'Operator', '软件开发', '人力资源', '电话销售', '运营总监')
13:38:29.641	0.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id") "c"
13:38:29.642	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"=1) AND ("visible"=TRUE) ORDER BY "system" DESC, "created_at", "id" LIMIT 20