Performance Profiling

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

总计11条数据

Time	Duration	Category	Info

17:45:56.661	3.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:45:56.681	2.5 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-erp-verify-processes', '{"is_delete":"","keyword":"","page":"1","web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":{"list":[{"id":22,"title":"\u5de5\u8d44\u5355","parent_title":"\u5de5\u8d44","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:35","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":23,"title":"\u793e\u4fdd\u5355","parent_title":"\u5de5\u8d44","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:35","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":24,"title":"\u516c\u79ef\u91d1\u5355","parent_title":"\u5de5\u8d44","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:35","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":25,"title":"\u4e2a\u7a0e\u5355","parent_title":"\u5de5\u8d44","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:35","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":26,"title":"\u5956\u91d1\u5355","parent_title":"\u5de5\u8d44","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:35","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":4,"title":"\u62a5\u635f\u5355","parent_title":"\u5e93\u5b58","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:23","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":5,"title":"\u62c6\u88c5\u5355","parent_title":"\u5e93\u5b58","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:23","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":11,"title":"\u4ed8\u6b3e\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:28","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":12,"title":"\u6536\u6b3e\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:28","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":13,"title":"\u8d39\u7528\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:29","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":14,"title":"\u5176\u4ed6\u6536\u5165\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:29","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":15,"title":"\u8d39\u7528\u8f6c\u5176\u4ed6\u6536\u5165\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:30","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":16,"title":"\u8f6c\u6b3e\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:30","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":17,"title":"\u73b0\u91d1\u8d39\u7528\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"1001","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:31","updatedBy":{"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"}},"verifyUsers":[{"id":1001,"email":"lrc@toast.com.cn","name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","sex":"M","birth_date":"1977-04-06","entry_date":"2005-06-06","department_id":4,"department_position_id":7,"mobile":"13501128560","telephone":"88864628","created_at":"2017-02-06 13:05:08","updated_at":"2025-08-06 16:56:18","id_number":"220523197704064411","native_place":"\u5409\u6797","graduate_school":"\u5409\u6797\u5de5\u4e1a\u5927\u5b66","specialty":"\u8ba1\u7b97\u673a\u5e94\u7528","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"821","leave_date":"","pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":"","namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","namecut4":"","budget_count":"5016468","profit_count":"76579.235000000000000000","bargain_count":"12","opportunity_budget_count":"360224.06","opportunity_count":"2","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":false,"work_off_remind":false,"check_client_same":true,"calendar_view_type":7,"search_all_client":true,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":18,"title":"\u9884\u4ed8\u6b3e\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:31","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":19,"title":"\u5176\u4ed6\u5e94\u4ed8\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:32","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":20,"title":"\u5176\u4ed6\u5e94\u6536\u5355","parent_title":"\u8d22\u52a1","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:32","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":1,"title":"\u91c7\u8d2d\u8ba2\u5355","parent_title":"\u91c7\u8d2d","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:21","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":2,"title":"\u91c7\u8d2d\u5165\u5e93\u5355","parent_title":"\u91c7\u8d2d","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:21","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"},{"id":3,"title":"\u91c7\u8d2d\u9000\u8d27\u5355","parent_title":"\u91c7\u8d2d","is_delete":false,"verify_user":"","carbon_copy_user":"","updated_by":1000,"updated_at":"2025-08-04 10:34:21","updatedBy":{"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"}},"verifyUsers":[],"carbonCopyUsers":[],"can_update":true,"can_stop":true,"can_start":false,"bgcolor":"#89c541"}],"can_create":true,"pagenation":{"totalcount":26,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-08 17:45:56') RETURNING "id"
17:45:56.659	2.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:45:56.666	2.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:45:56.671	1.3 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_erp_verify_processes" ORDER BY "is_delete", "parent_title", "id") "c"
17:45:56.674	0.9 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)
17:45:56.676	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001' ORDER BY array_position(array[1001], id)
17:45:56.673	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:45:56.675	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
17:45:56.673	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" ORDER BY "is_delete", "parent_title", "id" LIMIT 20
17:45:56.677	0.3 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"=1001)