Database Queries

总计8条数据

Time	Duration	Type	Query

21:42:01.730	3.5 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1000 /var/www/beta/models/Login.php:64 /var/www/beta/vendor/uranus/web/User.php:194 /var/www/beta/modules/vue/controllers/CommonController.php:223 [+] Explain
21:42:01.734	0.7 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 /var/www/beta/models/Login.php:64 /var/www/beta/modules/vue/controllers/CommonController.php:224 /var/www/beta/modules/vue/controllers/CommonController.php:104 [+] Explain
21:42:01.736	2.3 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 /var/www/beta/modules/vue/controllers/CommonController.php:122 /var/www/beta/modules/vue/controllers/ChangeLogController.php:31 [+] Explain
21:42:01.739	512.0 ms	SELECT	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='1756') AND ("object_type"='37') ORDER BY "created_at" DESC) "c" /var/www/beta/modules/vue/controllers/ChangeLogController.php:238 [+] Explain
21:42:02.251	78.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='1756') AND ("object_type"='37') ORDER BY "created_at" DESC LIMIT 20 /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
21:42:02.330	0.3 ms	SELECT	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
21:42:02.331	0.7 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
21:42:02.333	1.5 ms	INSERT	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/change-log/of-object', '{"object_type":"37","object_id":"1756","page":"1","web_access_token":"DkSM59AGtfUwbJa1Lr7tT74KmdPG8nsg"}', '{"code":2000,"result":{"list":[{"id":511127,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveVerifyRels","old_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f"]],"new_value":[["\u8f66\u660e\u98de"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u8f66\u660e\u98de;\u66f9\u6c38\u751f; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;"]},"created_by":1004,"created_at":"2025-08-02 21:40:01","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"2\u5206\u949f\u524d"},{"id":511124,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveVerifyRels","old_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5","\u970d\u4e1c\u9633"]],"new_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5;\u970d\u4e1c\u9633; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;"]},"created_by":1004,"created_at":"2025-08-02 21:39:00","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"3\u5206\u949f\u524d"},{"id":511121,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveCarbonCopyRels","old_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633","\u970d\u4e1c\u9633"]],"new_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u6284\u9001\u4eba","d4":["\u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633;\u970d\u4e1c\u9633; <b>\u53d8\u4e3a<\/b> \u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;"]},"created_by":1004,"created_at":"2025-08-02 21:38:25","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"3\u5206\u949f\u524d"},{"id":511118,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveCarbonCopyRels","old_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633"]],"new_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633","\u970d\u4e1c\u9633"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u6284\u9001\u4eba","d4":["\u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633; <b>\u53d8\u4e3a<\/b> \u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633;\u970d\u4e1c\u9633;"]},"created_by":1004,"created_at":"2025-08-02 21:30:52","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"11\u5206\u949f\u524d"},{"id":511117,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveVerifyRels","old_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5"]],"new_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5","\u970d\u4e1c\u9633"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5;\u970d\u4e1c\u9633;"]},"created_by":1004,"created_at":"2025-08-02 21:30:52","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"11\u5206\u949f\u524d"},{"id":511114,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveVerifyRels","old_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633"]],"new_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5;"]},"created_by":1004,"created_at":"2025-08-02 21:30:28","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"11\u5206\u949f\u524d"},{"id":511111,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveCarbonCopyRels","old_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363"]],"new_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u6284\u9001\u4eba","d4":["\u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363; <b>\u53d8\u4e3a<\/b> \u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633;"]},"created_by":1004,"created_at":"2025-08-02 21:28:39","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"13\u5206\u949f\u524d"},{"id":511108,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveCarbonCopyRels","old_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896"]],"new_value":[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u6284\u9001\u4eba","d4":["\u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896; <b>\u53d8\u4e3a<\/b> \u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;"]},"created_by":1004,"created_at":"2025-08-02 21:28:26","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"13\u5206\u949f\u524d"},{"id":511107,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":2,"attribute":"approveVerifyRels","old_value":[["\u97e9\u96c5\u82b3"]],"new_value":[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633"]],"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u97e9\u96c5\u82b3; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;"]},"created_by":1004,"created_at":"2025-08-02 21:28:26","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":false,"created_at_display":"13\u5206\u949f\u524d"},{"id":511104,"object_id":1756,"object_type":37,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"form_type":"","form_approveVerifyRels":"","form_approveCarbonCopyRels":"","keyword":"","from":"","to":"","period":"","unread":0},"new_value":{"form_type":"","form_approveVerifyRels":"","form_approveCarbonCopyRels":"","keyword":"","from":"","to":"","period":"","unread":0},"description":{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u521b\u5efa\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":[]},"created_by":1004,"created_at":"2025-08-02 21:25:46","is_delete":false,"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}},"need_hidden":true,"created_at_display":"16\u5206\u949f\u524d"}],"pagenation":{"totalcount":10,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-02 21:42:02') RETURNING "id" /var/www/beta/modules/vue/controllers/CommonController.php:663 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ChangeLogController.php:273 [+] Explain

[+] Explain all