Performance Profiling

Total processing time: 31 ms; Peak memory: 5.102 MB. Show Profiling Timeline

总计11条数据

Time	Duration	Category	Info

17:05:39.378	3.1 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/setting/list-taxonomy?term=12', '{"term":"7","page":"1","web_access_token":"s1xKbg9e3rlah-dvFsDEWCxiJPk9VpSm"}', '{"code":2000,"result":{"list":[{"id":113,"name":"\u6280\u672f\u65b9\u6848\u6a21\u7248","term_id":7,"description":"","sort":2,"created_by":1000,"created_at":"2017-08-18 20:24:09","updated_at":"2022-05-09 11:45:36","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":114,"name":"\u8bc1\u4e66","term_id":7,"description":"","sort":3,"created_by":1000,"created_at":"2017-08-18 20:24:20","updated_at":"2022-11-01 15:17:24","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":115,"name":"\u6807\u4e66\u6587\u4ef6","term_id":7,"description":"","sort":4,"created_by":1000,"created_at":"2017-08-18 20:24:31","updated_at":"2022-05-09 11:45:36","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":116,"name":"\u62d3\u5b9e\u670d\u52a1\u76ee\u5f55","term_id":7,"description":"","sort":5,"created_by":1000,"created_at":"2017-08-18 20:24:42","updated_at":"2022-05-09 11:45:36","is_delete":false,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":305,"name":"\u5408\u540c\uff06\u534f\u8bae","term_id":7,"description":"\u516c\u53f8\u81ea\u7528\u91c7\u8d2d\u4ea7\u54c1","sort":6,"created_by":1001,"created_at":"2021-09-13 10:20:55","updated_at":"2022-05-09 11:45:36","is_delete":false,"approve_verify_user":"\u516c\u53f8\u81ea\u7528\u91c7\u8d2d\u4ea7\u54c1","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"can_update":true,"can_delete":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":112,"name":"\u5e38\u7528\u6587\u6863","term_id":7,"description":"","sort":1,"created_by":1000,"created_at":"2017-08-18 20:23:57","updated_at":"2022-05-09 11:45:36","is_delete":true,"approve_verify_user":"","approve_carbon_copy_user":"","parent_id":"","is_system":false,"serial_no":"","child":[],"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"can_update":true,"can_delete":true,"can_stop":false,"can_start":true,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":6,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-15 17:05:39', 21630976) RETURNING "id"
17:05:39.359	1.4 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:05:39.367	1.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "term_id"='7' ORDER BY "is_delete", "sort") "c"
17:05:39.361	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:05:39.363	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:05:39.368	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "term_id"='7' ORDER BY "is_delete", "sort" LIMIT 20
17:05:39.369	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "parent_id" IN (113, 114, 115, 116, 305, 112) ORDER BY "is_delete", "sort"
17:05:39.371	0.4 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" IN (1000, 1001))
17:05:39.370	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 1001)
17:05:39.372	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (10, 4)
17:05:39.358	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta