Performance Profiling

Total processing time: 101 ms; Peak memory: 4.350 MB. Show Profiling Timeline

总计29条数据

Time	Duration	Category	Info

17:36:50.959	18.8 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id"=2749) GROUP BY "object_id"
17:36:50.978	17.8 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"=2749) GROUP BY "object_id"
17:36:50.946	6.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r. FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id 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, 5446, 5461, 5476, 5499, 5500)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."created_by"='5064') AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000001) AND (r.erp_borrow_un_settle_amount > 0) GROUP BY "r"."id" ORDER BY r.created_at DESC) "c"
17:36:51.013	5.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2749)
17:36:51.020	4.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2749)
17:36:51.003	4.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id"=3711)
17:36:51.008	3.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id"=3711)
17:36:50.953	3.6 ms	yii\db\Command::query	SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_cancel_verify_rels" "rcvr" ON rcvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id 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, 5446, 5461, 5476, 5499, 5500)) OR ("rccr"."user_id"=1001) OR ("rvr"."user_id"=1001) OR ("rcvr"."user_id"=1001)) AND ("r"."created_by"='5064') AND ("r"."status"=2) AND ("dt1"."taxonomy_id"=2100000001) AND (r.erp_borrow_un_settle_amount > 0) GROUP BY "r"."id" ORDER BY r.created_at DESC
17:36:51.027	1.9 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/erp-other-collect-ticket/search-approve', '{"user_id":"5064","web_access_token":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":{"list":[{"id":2749,"client_id":"","project_id":"","title":"\u6d4b\u662f\u65b0\u5efa\u5ba1\u6279\u5ba2\u6237\u540d\u79f0\u5546\u673a\u540d\u79f0\u5ba1\u6279\u4f60\u90a3\u6ca1\u6709\u4ed6\u8bf4\u55ef\u662f\u70b9\u524d\u9762\u90a3\u4e2a\u5b58\u8349\u7684\u6309\u94ae\u7279\u957f\u4e86\u5176\u5b9e\u5e94\u8be5\u76f4\u63a5\u6210\u4ece\u4e00\u9003\u7a3f\u5c31\u5b8c\u4e8b\u4e86\u662f\u63d0\u793a\u5427\u5e94\u8be5\u5c31\u662f\u5c31\u662f\u63d0\u9192\u524d\u4e0d\u8981\u544a\u4ed6\u4e00\u58f0\u4ed6\u542c\u4e0d\u7b11\u7684\u662f\u4e0a\u5e02\u770b\u4e00\u4e0b\u5443\u7f51\u9875\u4e0a\u4e0d\u63d0\u9192\u7f51\u9875\u6211\u8981\u70b9\u4fdd\u5b58\u7684\u4ed3\u554a\u4ed6\u5c31\u76f4\u63a5\u5b58\u4e0a\u4e86\u5bf9\u6d4b\u8bd5\u6807\u9898\u6807\u9898\uff0c\u6d4b\u8bd5\u5207\u6765\u5207\u53bb\u3002\u7f16\u8f91\u5ba1\u6279\u6d4b\u8bd5\u3002\u54e6\uff0c\u7f16\u8f91\u5ba1\u6279\u6d4b\u8bd5\uff0c\u6211\u70b9\u4e00\u4e0b\u6682\u505c\u6587\u6848\u624d\u4f1a\u7cbe\u51c6\u3002\u5207\u6362\u8bed\u97f3\u4f4d\u7f6e\u3002","status":2,"next_verify_user":"","verify_at":"2026-04-16 10:31:09","description":"\u54c7\uff0c\u54e6\u6211\u7adf\u7136\u4e24\u4e2a\u90fd\u80fd\u540c\u65f6\u5f55\u97f3\u3002\u7533\u8bf7\u5185\u5bb9\u6d4b\u8bd5\u3002ok ok\u95ea\u7247\u4eba\u95ea\u53ef\u4eba\u8fd8\u53ef\u4ee5\u3002\u54b3\u55fd\u54b3\u55fd\u54b3\u55fd\u54b3\u55fd\u597d\u50cf\u559c\u6b22\u4ed6\u4eca\u5929\u8981\u5f00\u6ca1\u770b\u89c1\u8ddf\u90a3\u5929\u633a\u50cf\u4eca\u5929\u53c2\u7684\u5c0f\u5c0f\u516c\u4e3b\u88d9\u55ef\u6211\u89c9\u5f97\u5c31\u662f\u7684\u90a3\u4e2a\u7ecf\u7406\u4e86\u611f\u89c9\u53ef\u4ee5\u7684\u540d\u6211\u4f30\u8ba1\u770b\u5230\u56de\u6765\u56de\u5730\u53d8\u56e0\u7559\u5728\u6211\u7ed9\u4ed6\u8ba9\u4ed6\u542c\u5199\u55ef\uff0c\u7f16\u8f91\u5f55\u97f3\u529f\u80fd\u6d4b\u8bd5\u55ef\u3002\u539f\u6765\u662f\u8fd9\u4e2a\u6837\u5b50\u3002","refuse_description":"","is_resubmited":false,"created_by":5064,"created_at":"2026-04-13 14:25:00","updated_at":"2026-04-16 10:31:09","supplier_id":45,"purchase_contract_id":4458,"amount":"","borrow_amount":"500","borrow_collect_day":"","borrow_collect_status":0,"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":"500","next_cancel_verify_user":"","cancel_at":"","cancel_description":"","erp_payment_all_settle_amount":"0","createdBy":{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","sex":"F","department_id":10,"avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2749,"comment":27},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":9622,"approve_id":2749,"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":9623,"approve_id":2749,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}}],"approveVerifyRels":[{"id":3711,"approve_id":2749,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:31:09","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":"","haveApproveVerifyRel":{"id":3711,"approve_id":2749,"user_id":1001,"status":1,"description":"","verify_at":"2026-04-16 10:31:09"},"attachmentRelationships":[],"client":{},"project":"","supplier":{"id":45,"key":45,"name":"\u8054\u5f3a\u56fd\u9645\u8d38\u6613(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4458,"key":4458,"name":"\u6d4b\u8bd5\u62d2\u7edd\u540e\u7684\u72b6\u6001"},"files":[],"checked":false,"serial_no":""}],"can_create":true,"pagenation":{"totalcount":1,"thispage":1,"pagesize":-1}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.61","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-15 17:36:51', 93933056) RETURNING "id"
17:36:50.998	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2749
17:36:50.935	0.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1013
17:36:51.001	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2749 ORDER BY "id"
17:36:50.943	0.7 ms	yii\db\Command::query	SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
17:36:50.997	0.7 ms	yii\db\Command::query	SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (5, 226, 179, 177, 197, 199, 2100000001, 377, 340))
17:36:51.019	0.7 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4458
17:36:50.958	0.6 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"=5064)
17:36:50.937	0.6 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:36:51.013	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=2749) ORDER BY "id"
17:36:51.012	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2749) ORDER BY "id"
17:36:50.996	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2749
17:36:50.939	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:36:51.000	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1013, 5252)
17:36:51.000	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 (1013, 5252))
17:36:51.002	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:36:50.935	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:36:51.003	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)
17:36:50.957	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:36:51.019	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=45
17:36:50.959	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10