Performance Profiling

Total processing time: 29 ms; Peak memory: 5.101 MB. Show Profiling Timeline

总计17条数据

Time	Duration	Category	Info

19:04:34.221	3.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=29) AND ("visit_date"='2025-08-08')
19:04:34.204	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
19:04:34.211	2.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%wxx%') OR ("email" ILIKE '%wxx%') OR ("pinyin_shortcut" ILIKE '%wxx%')) ORDER BY "updated_at" DESC) "c"
19:04:34.202	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
19:04:34.207	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
19:04:34.226	1.2 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/account/list', '{"AccountSearch":{"department_id":"","department_position_id":"","keyword":"wxx"},"page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":5252,"email":"wangxiaoxiao@toast.com.cn","name":"\u738b\u7b11\u7b11","user_status":"1","pinyin_shortcut":"wxx","sex":"F","birth_date":"1995-06-16","entry_date":"2021-01-04","department_id":6,"department_position_id":16,"mobile":"18736768324","telephone":"88864628","created_at":"2021-01-04 09:48:16","updated_at":"2021-03-23 18:05:00","id_number":"411424199506165066","native_place":"\u6cb3\u5357\u7701\u67d8\u57ce\u53bf","graduate_school":"\u4e2d\u539f\u5de5\u5b66\u9662\u4fe1\u606f\u5546\u52a1\u5b66\u9662","specialty":"\u4f1a\u8ba1","education":"\u4e13\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"wang","pinyin2":"xiao","pinyin3":"xiao","pinyin4":"","namecut1":"\u738b","namecut2":"\u7b11","namecut3":"\u7b11","namecut4":"","budget_count":"0","profit_count":"0","bargain_count":"0","opportunity_budget_count":"0","opportunity_count":"0","work_log_score":"0","e_implement_count":"0","e_budget_count":"0","e_profit_count":"0","e_client_count":"0","e_project_count":"0","e_point_count":"0","visit_resource_sync":false,"client_lock":false,"view_public":true,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"avatar":{"user_id":5252,"avatar":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"},"departmentPosition":{"id":16,"key":16,"name":"\u4f1a\u8ba1"},"userRoles":[{"id":99,"key":99,"name":"Accountant","display_name":"\u4f1a\u8ba1\u4e13\u5458"}],"is_sales":false,"is_admin":false,"can_update_visit_auth":true,"can_update":true,"can_change_password":true,"can_delete":true,"can_destroy":false,"can_resend":false,"can_reactivate":false,"sex_display":"\u5973","bgcolor":"#89c541"}],"create_notice":false,"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-08-08 19:04:34') RETURNING "id"
19:04:34.225	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=7, "last_visit_at"='now()' WHERE "id"=54985
19:04:34.214	0.8 ms	yii\db\Command::query	SELECT "user_id", "meta_value" AS "avatar" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
19:04:34.213	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND (("name" ILIKE '%wxx%') OR ("email" ILIKE '%wxx%') OR ("pinyin_shortcut" ILIKE '%wxx%')) ORDER BY "updated_at" DESC LIMIT 20
19:04:34.217	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE "name"='Accountant'
19:04:34.219	0.4 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_enterprises" WHERE "id"=2
19:04:34.215	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
19:04:34.216	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "item_name" AS "name", "item_name", "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=5252
19:04:34.216	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_department_positions" WHERE "id"=16
19:04:34.218	0.3 ms	yii\db\Command::query	SELECT * FROM "global"."tbl_logins" WHERE "id"=1001
19:04:34.217	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "display_name" FROM "a57be577deb434"."tbl_auth_items" WHERE ("type"='1') AND ("name"='Accountant')
19:04:34.217	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_auth_assignments" WHERE "user_id"=5252