Performance Profiling

Total processing time: 20 ms; Peak memory: 4.895 MB. Show Profiling Timeline

总计10条数据

Time	Duration	Category	Info

14:28:20.338	2.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:28:20.343	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:28:20.337	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:28:20.352	1.3 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-taxonomy?term=19', '{"term":"19","is_delete":"","type":"","keyword":"","page":"1","web_access_token":"1oIEeDxvJLe30O-GCa2UzTZzY9D9JY1c"}', '{"code":2000,"result":{"list":[{"id":398,"name":"\u8d22\u52a1\u79d1\u76ee","term_id":19,"description":"","sort":1,"created_by":1000,"created_at":"2025-08-01 23:14:30","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":true,"serial_no":"6051","child":[{"id":399,"name":"\u5229\u606f\u6536\u5165","term_id":20,"description":"","sort":1,"created_by":1000,"created_at":"2025-08-01 23:14:30","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":true,"serial_no":"605101","can_update":false,"can_delete":false,"can_stop":true,"can_start":false},{"id":400,"name":"\u5176\u4ed6\u6536\u5165","term_id":20,"description":"","sort":2,"created_by":1000,"created_at":"2025-08-01 23:14:30","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":true,"serial_no":"605102","can_update":false,"can_delete":false,"can_stop":true,"can_start":false},{"id":401,"name":"\u8fd4\u70b9\u83b7\u5229\u6536\u5165","term_id":20,"description":"","sort":3,"created_by":1000,"created_at":"2025-08-01 23:14:30","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":true,"serial_no":"605103","can_update":false,"can_delete":false,"can_stop":true,"can_start":false},{"id":402,"name":"\u8c03\u8d26\u6536\u5165","term_id":20,"description":"","sort":4,"created_by":1000,"created_at":"2025-08-01 23:14:30","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":true,"serial_no":"605104","can_update":false,"can_delete":false,"can_stop":true,"can_start":false},{"id":430,"name":"\u5b9e\u65bd\u5de5\u7a0b\u5e08\u5de5\u65f6","term_id":20,"description":"","sort":5,"created_by":1001,"created_at":"2025-08-18 16:52:51","updated_at":"","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":false,"serial_no":"605105","can_update":true,"can_delete":true,"can_stop":true,"can_start":false},{"id":431,"name":"\u4ee3\u4ea4\u793e\u4fdd\u6536\u5165","term_id":20,"description":"","sort":6,"created_by":1001,"created_at":"2025-08-18 16:53:16","updated_at":"2025-08-18 16:53:29","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":398,"is_system":false,"serial_no":"605106","can_update":true,"can_delete":true,"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"}],"can_create":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-08 14:28:20') RETURNING "id"
14:28:20.346	0.9 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "term_id"='19' ORDER BY "is_delete", "sort") "c"
14:28:20.349	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
14:28:20.347	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "term_id"='19' ORDER BY "is_delete", "sort" LIMIT 20
14:28:20.350	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
14:28:20.348	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id"=398 ORDER BY "is_delete", "sort"
14:28:20.348	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000