Performance Profiling

Total processing time: 113 ms; Peak memory: 5.632 MB. Show Profiling Timeline

总计32条数据

Time	Duration	Category	Info

15:39:19.607	20.1 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2236) GROUP BY "object_id"
15:39:19.643	19.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2236)
15:39:19.627	16.4 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=2236) GROUP BY "object_id"
15:39:19.569	6.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:39:19.664	3.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-09-12')
15:39:19.580	3.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:39:19.575	3.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:39:19.588	2.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT "r". FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = r.project_id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (r.status != 0) AND ("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND (("r"."status"='1')) ORDER BY "r"."created_at" DESC) "c"
15:39:19.598	2.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id"=2930)
15:39:19.600	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id"=2930)
15:39:19.603	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2236)
15:39:19.605	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2236)
15:39:19.591	1.5 ms	yii\db\Command::query	SELECT "r".* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id LEFT JOIN "a57be577deb434"."tbl_projects" "project" ON project.id = r.project_id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (r.status != 0) AND ("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) AND (("r"."status"='1')) ORDER BY "r"."created_at" DESC LIMIT 20
15:39:19.669	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/analysis/approve-data-list', '{"status":["1"],"keyword":"","timeType":"year","page":"1","to":"","from":"","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":2236,"client_id":"","project_id":"","title":"\u5b9d\u8d1d\u5b9d\u8d1d","status":1,"next_verify_user":1001,"verify_at":"","description":"\u82b1\u955c\u5a1c\u5a1c","refuse_description":"","is_resubmited":false,"created_by":5446,"created_at":"2025-09-12 14:01:11","updated_at":"2025-09-12 14:01:32","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":1,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","createdBy":{"id":5446,"key":5446,"name":"\u5218\u5a1f","sex":"F","department_id":8,"avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"},"department":{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90"}},"client":{},"project":{},"supplier":"","purchaseContract":"","type":{"id":316,"name":"\u63d0\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7915,"approve_id":2236,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7916,"approve_id":2236,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"approveVerifyRels":[{"id":2930,"approve_id":2236,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2930,"approve_id":2236,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"haveApproveVerifyRel":"","attachmentRelationships":[],"files":[],"commentCount":{"object_id":2236,"comment":2},"unreadComments":{"object_id":2236,"unread":1},"comments":[{"id":191273,"object_id":2236,"object_type":"37","parent":"","description":"\u5218\u5a1f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":5446,"created_at":"2025-09-12 14:01:11","reply_to":"","is_system":true,"for_user":"","description2":"\u5b9d\u8d1d\u5b9d\u8d1d","createdBy":{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"liu","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5a1f","namecut3":"","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":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true}},{"id":191274,"object_id":2236,"object_type":"37","parent":"","description":"\u5218\u5a1f \u6709\u4e00\u4e2a\u5ba1\u6279\u9700\u8981\u5ba1\u6279","created_by":5446,"created_at":"2025-09-12 14:01:32","reply_to":"","is_system":true,"for_user":"","description2":"\u5b9d\u8d1d\u5b9d\u8d1d","createdBy":{"id":5446,"email":"liujuan@toast.com.cn","name":"\u5218\u5a1f","user_status":"1","pinyin_shortcut":"lj","sex":"F","birth_date":"1987-10-04","entry_date":"2025-03-03","department_id":8,"department_position_id":61,"mobile":"15699735973","telephone":"88864628","created_at":"2025-03-03 10:55:13","updated_at":"2025-03-03 10:55:13","id_number":"413026198710047225","native_place":"\u7518\u8083\u7701\u5609\u5cea\u5173\u5e02","graduate_school":"\u5317\u4eac\u4e1c\u65b9\u5927\u5b66","specialty":"\u5de5\u5546\u4f01\u4e1a\u7ba1\u7406","education":"\u672c\u79d1","telephone_area_code":"010","telephone_extension_number":"","leave_date":"","pinyin1":"liu","pinyin2":"juan","pinyin3":"","pinyin4":"","namecut1":"\u5218","namecut2":"\u5a1f","namecut3":"","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":false,"client_remind_alarm_before":"","work_on_remind":true,"work_off_remind":true,"check_client_same":true,"calendar_view_type":7,"search_all_client":true}}],"bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"}],"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-12 15:39:19') RETURNING "id"
15:39:19.668	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=147, "last_visit_at"='now()' WHERE "id"=56539
15:39:19.587	0.8 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
15:39:19.595	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2236
15:39:19.593	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"=5446)
15:39:19.663	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:39:19.596	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2236 ORDER BY "id"
15:39:19.603	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=2236) ORDER BY "id"
15:39:19.594	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=8
15:39:19.595	0.3 ms	yii\db\Command::query	SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (5, 1, 2, 229, 153, 184, 189, 316, 349))
15:39:19.602	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2236) ORDER BY "id"
15:39:19.593	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:39:19.596	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5388)
15:39:19.594	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2236
15:39:19.597	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:39:19.602	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:39:19.596	0.2 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 (5388, 1013))
15:39:19.597	0.2 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)
15:39:19.602	0.2 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)