{"info":{"_postman_id":"00a933c2-177e-4375-9f67-3f2d6346fe2a","name":"APIJSON","schema":"https://schema.getpostman.com/json/collection/v2.0.0/collection.json","toc":[],"description":"","owner":"7711046","collectionId":"00a933c2-177e-4375-9f67-3f2d6346fe2a","publishedId":"UVC3jStM","public":true,"customColor":{"top-bar":"FFFFFF","right-sidebar":"303030","highlight":"EF5B25"},"publishDate":"2021-11-06T10:43:45.000Z"},"item":[{"name":"查询","id":"e05de086-a2de-486a-b901-6400999fd16b","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"[]\": {\r\n \"Message\": {\r\n },\r\n \"User\": {\r\n \"id@\": \"[]/Message/user_id\"\r\n }\r\n },\r\n \"debug\": true\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get","urlObject":{"protocol":"http","port":"9501","path":["get"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"232edc5c-5788-49a6-a597-6573758d217a","name":"单表查询","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"User\":{}\r\n}","options":{"raw":{"language":"json"}}},"url":"http://test.local/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Connection","value":"close"},{"key":"Content-Length","value":"137"},{"key":"Content-Encoding","value":"gzip"},{"key":"Content-Type","value":"application/json"},{"key":"Date","value":"Fri, 05 Nov 2021 09:02:01 GMT"},{"key":"Server","value":"nginx/1.21.0"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 1,\n \"username\": \"abigeater\",\n \"email\": \"abigeater@163.com\",\n \"password\": \"1\",\n \"create_time\": \"2021-11-02 06:57:56\"\n }\n}"},{"id":"8605c843-1ff6-4198-97c1-3222973b9776","name":"单表查询 - 带条件","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"User\": {\r\n \"id\": 1\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"http://test.local/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Connection","value":"close"},{"key":"Content-Length","value":"137"},{"key":"Content-Encoding","value":"gzip"},{"key":"Content-Type","value":"application/json"},{"key":"Date","value":"Fri, 05 Nov 2021 09:03:24 GMT"},{"key":"Server","value":"nginx/1.21.0"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 1,\n \"username\": \"abigeater\",\n \"email\": \"abigeater@163.com\",\n \"password\": \"1\",\n \"create_time\": \"2021-11-02 06:57:56\"\n }\n}"},{"id":"3f0ad016-9d15-4e4c-8484-f53d08ab9f25","name":"查询-数组查询","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"[]\": {\r\n \"count\": 10,\r\n \"page\": 1,\r\n \"User\": {\r\n \"password\": 1\r\n }\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"http://test.local/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Connection","value":"close"},{"key":"Content-Length","value":"144"},{"key":"Content-Encoding","value":"gzip"},{"key":"Content-Type","value":"application/json"},{"key":"Date","value":"Fri, 05 Nov 2021 10:19:56 GMT"},{"key":"Server","value":"nginx/1.21.0"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"[]\": [\n {\n \"User\": {\n \"id\": 1,\n \"username\": \"abigeater\",\n \"email\": \"abigeater@163.com\",\n \"password\": \"1\",\n \"create_time\": \"2021-11-02 06:57:56\"\n }\n }\n ]\n}"},{"id":"4215a191-efeb-4ff1-a1be-857dc39040ff","name":"查询 - 多表查询","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"User\": {\r\n \r\n },\r\n \"Message\": {}\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:21:01 GMT"},{"key":"Content-Length","value":"152"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n },\n \"Message\": {\n \"id\": 1,\n \"user_id\": 1,\n \"message\": \"1\"\n }\n}"},{"id":"7aacdeb6-2215-49e3-b0af-f86fa06bee4d","name":"查询 - 一对一查询","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"Message\": {},\r\n \"User\": {\r\n \"id@\": \"Message/user_id\"\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:22:10 GMT"},{"key":"Content-Length","value":"149"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"Message\": {\n \"id\": 1,\n \"user_id\": 1,\n \"message\": \"1\"\n },\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n }\n}"},{"id":"e945e7c7-6488-422c-872c-819e14f64cc1","name":"查询 - 一对多","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"User\": {\r\n \"id\": 2\r\n },\r\n \"[]\": {\r\n \"Message\": {\r\n \"user_id@\": \"User/id\"\r\n }\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 10:03:40 GMT"},{"key":"Content-Length","value":"166"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 2,\n \"username\": \"u2\",\n \"email\": \"e@2.com\",\n \"password\": \"p2\",\n \"create_time\": \"2021-11-06 16:53:20\"\n },\n \"[]\": [\n {\n \"Message\": {\n \"id\": 3,\n \"user_id\": 2,\n \"message\": \"3333\"\n }\n }\n ]\n}"},{"id":"6e72cd56-a417-4f3c-aa25-9c62bbc10405","name":"查询 - 数组内多表一对一联查","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"[]\": {\r\n \"Message\": {\r\n },\r\n \"User\": {\r\n \"id@\": \"[]/Message/user_id\"\r\n }\r\n }\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 10:18:48 GMT"},{"key":"Content-Length","value":"206"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"[]\": [\n {\n \"Message\": {\n \"id\": 1,\n \"user_id\": 1,\n \"message\": \"1\"\n },\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n }\n },\n {\n \"Message\": {\n \"id\": 2,\n \"user_id\": 1,\n \"message\": \"122\"\n },\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n }\n },\n {\n \"Message\": {\n \"id\": 3,\n \"user_id\": 2,\n \"message\": \"3333\"\n },\n \"User\": {\n \"id\": 2,\n \"username\": \"u2\",\n \"email\": \"e@2.com\",\n \"password\": \"p2\",\n \"create_time\": \"2021-11-06 16:53:20\"\n }\n }\n ]\n}"},{"id":"f51e5fb9-141a-4e6c-ad1d-65b61332499f","name":"查询 - debug用法","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\r\n \"[]\": {\r\n \"Message\": {\r\n },\r\n \"User\": {\r\n \"id@\": \"[]/Message/user_id\"\r\n }\r\n },\r\n \"debug\": true\r\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/get"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 10:35:20 GMT"},{"key":"Content-Length","value":"272"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"[]\": [\n {\n \"Message\": {\n \"id\": 1,\n \"user_id\": 1,\n \"message\": \"1\"\n },\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n }\n },\n {\n \"Message\": {\n \"id\": 2,\n \"user_id\": 1,\n \"message\": \"122\"\n },\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\",\n \"email\": \"e@1.com\",\n \"password\": \"p1\",\n \"create_time\": \"2021-11-06 16:53:02\"\n }\n },\n {\n \"Message\": {\n \"id\": 3,\n \"user_id\": 2,\n \"message\": \"3333\"\n },\n \"User\": {\n \"id\": 2,\n \"username\": \"u2\",\n \"email\": \"e@2.com\",\n \"password\": \"p2\",\n \"create_time\": \"2021-11-06 16:53:20\"\n }\n }\n ],\n \"debug\": [\n \"select * from `Message`\",\n \"select * from `User` where `id` = '1' limit 1\",\n \"select * from `User` where `id` = '1' limit 1\",\n \"select * from `User` where `id` = '2' limit 1\"\n ]\n}"}],"_postman_id":"e05de086-a2de-486a-b901-6400999fd16b"},{"name":"新增数据","id":"6cc2a6f5-1d5f-4e9d-af75-2a8023e34d5e","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"message[]\": [\n {\n \"user_id\":1,\n \"message\": \"1\"\n },\n {\n \"user_id\":1,\n \"message\": \"122\"\n },\n {\n \"user_id\":2,\n \"message\": \"3333\"\n }\n ]\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/post","urlObject":{"port":"9501","path":["post"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"de49502f-57bc-4c55-ba40-81296052aba0","name":"新增数据","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {\n \"username\":\"u2\",\n \"email\": \"e@2.com\",\n \"password\": \"p2\"\n }\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/post"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 08:53:02 GMT"},{"key":"Content-Length","value":"49"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 1\n }\n}"},{"id":"ccf6ebb5-802e-479c-b2a9-c8e684635837","name":"新增数据 - 多条","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User[]\": [\n {\n \"username\":\"u3\",\n \"email\": \"e@3.com\",\n \"password\": \"p3\"\n },\n {\n \"username\":\"u4\",\n \"email\": \"e@4.com\",\n \"password\": \"p4\"\n }\n ]\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/post"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:05:45 GMT"},{"key":"Content-Length","value":"58"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"id[]\": [\n 16,\n 17\n ],\n \"count\": 2\n}"}],"_postman_id":"6cc2a6f5-1d5f-4e9d-af75-2a8023e34d5e"},{"name":"修改数据","id":"14a27f3d-1a2f-4320-ad89-c660ef8ed581","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\"\n }\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/put","urlObject":{"port":"9501","path":["put"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"69d576ff-5d98-4fc4-9c77-232fbb06cf64","name":"修改数据 - 多个ID","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {\n \"id{}\": [14,15,16],\n \"username\": \"tt1\"\n }\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/put"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:15:38 GMT"},{"key":"Content-Length","value":"70"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id[]\": [\n 14,\n 15,\n 16\n ],\n \"count\": 3\n }\n}"},{"id":"b95850c9-b2a7-4a5b-a20b-8c84b77fe22f","name":"修改数据 - 单个","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {\n \"id\": 1,\n \"username\": \"ttt1\"\n }\n}","options":{"raw":{"language":"json"}}},"url":"localhost:9501/put"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:16:08 GMT"},{"key":"Content-Length","value":"49"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 1\n }\n}"}],"_postman_id":"14a27f3d-1a2f-4320-ad89-c660ef8ed581"},{"name":"删除数据","id":"f8022cba-c8b7-4f3b-86ad-6debc11dcf4c","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\":{\n \"id{}\":[18,19,20]\n }\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/delete","urlObject":{"protocol":"http","port":"9501","path":["delete"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"269446be-3a9e-42e4-953c-0f12efd53ff9","name":"删除数据 -单个","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\":{\n \"id\": 17\n }\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/delete"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:16:54 GMT"},{"key":"Content-Length","value":"50"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id\": 17\n }\n}"},{"id":"8c656664-03f9-495b-8b7d-b0e500cb6516","name":"删除数据 - 多个","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\":{\n \"id{}\":[18,19,20]\n }\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/delete"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:17:25 GMT"},{"key":"Content-Length","value":"70"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"id[]\": [\n 18,\n 19,\n 20\n ],\n \"count\": 3\n }\n}"}],"_postman_id":"f8022cba-c8b7-4f3b-86ad-6debc11dcf4c"},{"name":"统计","id":"0cf75a10-d3ce-48f5-b860-e2eaf168bfc9","protocolProfileBehavior":{"disableBodyPruning":true},"request":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {}\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/head","urlObject":{"protocol":"http","port":"9501","path":["head"],"host":["localhost"],"query":[],"variable":[]}},"response":[{"id":"29aeaeaa-d072-41c2-b090-d6957e9a0545","name":"统计 - 条件","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {\n \"id{}\": [1,2,3]\n }\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/head"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:18:46 GMT"},{"key":"Content-Length","value":"52"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"count\": 2\n }\n}"},{"id":"ff1c6b23-ca2c-470f-9bd0-3ada76cc4267","name":"统计 - 无条件","originalRequest":{"method":"POST","header":[],"body":{"mode":"raw","raw":"{\n \"User\": {}\n}","options":{"raw":{"language":"json"}}},"url":"http://localhost:9501/head"},"status":"OK","code":200,"_postman_previewlanguage":"json","header":[{"key":"Content-Type","value":"application/json"},{"key":"Server","value":"Hyperf"},{"key":"Connection","value":"keep-alive"},{"key":"Date","value":"Sat, 06 Nov 2021 09:18:56 GMT"},{"key":"Content-Length","value":"53"},{"key":"Content-Encoding","value":"br"}],"cookie":[],"responseTime":null,"body":"{\n \"code\": 200,\n \"msg\": \"Success!\",\n \"User\": {\n \"count\": 12\n }\n}"}],"_postman_id":"0cf75a10-d3ce-48f5-b860-e2eaf168bfc9"}]}