{"id":449,"title":"elasticsearch\u67e5\u8be2\u5b9e\u4f8b-\u6a21\u62df\u6570\u636e","good":0,"bad":3,"hit":2841,"created_at":"2020-04-05 13:43:24","content":"<p>\u6211\u4eec\u7528\u4e0b\u9762\u7684\u6570\u636e\u6d4b\u8bd5\uff1a<\/p><p>\u53ef\u4ee5\u7528postman\u6279\u91cf\u5bfc\u5165es,\u5b9e\u73b0\u4e00\u4e2a\u7c7b\u4f3csql\u7684\u67e5\u8be2\uff1a<\/p><pre class=\"brush:php;toolbar:false\">select&nbsp;*&nbsp;from&nbsp;users&nbsp;\nwhere&nbsp;(name&nbsp;like&nbsp;&#39;%\u5f20\u4e09%&#39;&nbsp;or&nbsp;name&nbsp;like&nbsp;&#39;%\u674e\u56db%&#39;)&nbsp;\n\tand&nbsp;sex=1&nbsp;and&nbsp;city_id&nbsp;in&nbsp;(1,2)\n\tand&nbsp;(address&nbsp;like&nbsp;&#39;%\u5e7f\u5dde%&#39;&nbsp;or&nbsp;address&nbsp;like&nbsp;&#39;%\u6df1\u5733%&#39;)&nbsp;\n\tand&nbsp;create_time&gt;&#39;2020-04-04&nbsp;12:30:30&#39;\norder&nbsp;by&nbsp;position&nbsp;desc\nlimit&nbsp;10,2<\/pre><pre class=\"brush:php;toolbar:false\">id,tel,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;name,&nbsp;&nbsp;sex,city_id,city_name,lon,lat,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;create_time,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;address,\n1,&nbsp;13533592801,\u5f20\u4e09\u4e30,1,&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u6df1\u5733\u5e02,&nbsp;&nbsp;&nbsp;114.364493,22.719571,2020-04-04&nbsp;15:57:20,\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u576a\u5c71\u7ad9\n2,&nbsp;13533592802,\u5f20\u4e09\u82b1,2,&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u6df1\u5733\u5e02,&nbsp;&nbsp;&nbsp;114.062088,22.632069,2020-04-04&nbsp;15:58:52,\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u5742\u7530\u7ad9\n3,&nbsp;13533592803,\u5f20\u4e09,&nbsp;&nbsp;1,&nbsp;&nbsp;2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u5e7f\u5dde\u5e02,&nbsp;&nbsp;&nbsp;113.261805,23.265706,2020-04-04&nbsp;16:03:12,\u5e7f\u4e1c\u7701\u5e7f\u5dde\u5e02\u5929\u6cb3\u5ba2\u8fd0\u7ad9\n4,&nbsp;13533592804,\u674e\u56db\u56db,1,&nbsp;&nbsp;4,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u4e2d\u5c71\u5e02,&nbsp;&nbsp;&nbsp;113.408984,22.522077,2020-04-04&nbsp;16:23:22,\u5e7f\u4e1c\u7701\u4e2d\u5c71\u5e02\u5ba2\u8fd0\u7ad9\n5,&nbsp;13533592805,\u674e\u8bd7\u56db,2,&nbsp;&nbsp;3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u4e1c\u839e\u5e02,&nbsp;&nbsp;&nbsp;113.747034,23.025384,2020-04-04&nbsp;16:35:38,\u5e7f\u4e1c\u7701\u4e1c\u839e\u5e02\u68e0\u6d8c\u5ba2\u8fd0\u7ad9\n6,&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;\u7a7a\u6570\u636e,0,&nbsp;&nbsp;0,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0,0,2020-03-04,,\n-----------------------------------------------------------------------\u4ee5\u4e0b\u6570\u636e\u683c\u5f0f\u4e0d\u8981\u6539\uff1a\u4e0d\u80fd\u683c\u5f0f\u5316json,\u6700\u540e\u4e00\u884c\u6570\u636e\u540e\u56de\u8f66\u4e24\u6b21-------------------------------------------\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;1&quot;,&quot;tel&quot;:&quot;13533592801&quot;,&quot;name&quot;:&quot;\u5f20\u4e09\u4e30&quot;,&quot;sex&quot;:&quot;1&quot;,&quot;city_id&quot;:&quot;1&quot;,&quot;city_name&quot;:&quot;\u6df1\u5733\u5e02&quot;,&quot;location&quot;:{&quot;lat&quot;:22.719571,&quot;lon&quot;:114.364493},&quot;create_time&quot;:&quot;2020-04-04&nbsp;15:57:20&quot;,&quot;address&quot;:&quot;\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u576a\u5c71\u7ad9&quot;}\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;2&quot;,&quot;tel&quot;:&quot;13533592802&quot;,&quot;name&quot;:&quot;\u5f20\u4e09\u82b1&quot;,&quot;sex&quot;:&quot;2&quot;,&quot;city_id&quot;:&quot;1&quot;,&quot;city_name&quot;:&quot;\u6df1\u5733\u5e02&quot;,&quot;location&quot;:{&quot;lat&quot;:22.632069,&quot;lon&quot;:114.062088},&quot;create_time&quot;:&quot;2020-04-04&nbsp;15:58:52&quot;,&quot;address&quot;:&quot;\u5e7f\u4e1c\u7701\u6df1\u5733\u5e02\u9f99\u5c97\u533a\u5742\u7530\u7ad9&quot;}\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;3&quot;,&quot;tel&quot;:&quot;13533592803&quot;,&quot;name&quot;:&quot;\u5f20\u4e09&quot;,&quot;sex&quot;:&quot;1&quot;,&quot;city_id&quot;:&quot;2&quot;,&quot;city_name&quot;:&quot;\u5e7f\u5dde\u5e02&quot;,&quot;location&quot;:{&quot;lat&quot;:23.265706,&quot;lon&quot;:113.261805},&quot;create_time&quot;:&quot;2020-04-04&nbsp;16:03:12&quot;,&quot;address&quot;:&quot;\u5e7f\u4e1c\u7701\u5e7f\u5dde\u5e02\u5929\u6cb3\u5ba2\u8fd0\u7ad9&quot;}\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;4&quot;,&quot;tel&quot;:&quot;13533592804&quot;,&quot;name&quot;:&quot;\u674e\u56db\u56db&quot;,&quot;sex&quot;:&quot;1&quot;,&quot;city_id&quot;:&quot;4&quot;,&quot;city_name&quot;:&quot;\u4e2d\u5c71\u5e02&quot;,&quot;location&quot;:{&quot;lat&quot;:22.522077,&quot;lon&quot;:113.408984},&quot;create_time&quot;:&quot;2020-04-04&nbsp;16:23:22&quot;,&quot;address&quot;:&quot;\u5e7f\u4e1c\u7701\u4e2d\u5c71\u5e02\u5ba2\u8fd0\u7ad9&quot;}\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;5&quot;,&quot;tel&quot;:&quot;13533592805&quot;,&quot;name&quot;:&quot;\u674e\u8bd7\u56db&quot;,&quot;sex&quot;:&quot;2&quot;,&quot;city_id&quot;:&quot;3&quot;,&quot;city_name&quot;:&quot;\u4e1c\u839e\u5e02&quot;,&quot;location&quot;:{&quot;lat&quot;:23.025384,&quot;lon&quot;:113.747034},&quot;create_time&quot;:&quot;2020-04-04&nbsp;16:35:38&quot;,&quot;address&quot;:&quot;\u5e7f\u4e1c\u7701\u4e1c\u839e\u5e02\u68e0\u6d8c\u5ba2\u8fd0\u7ad9&quot;}\n{&quot;create&quot;:{&quot;_index&quot;:&quot;student&quot;}}\n{&quot;id&quot;:&quot;6&quot;,&quot;tel&quot;:&quot;&quot;,&quot;name&quot;:&quot;\u7a7a\u6570\u636e&quot;,&quot;sex&quot;:&quot;0&quot;,&quot;city_id&quot;:&quot;0&quot;,&quot;city_name&quot;:&quot;&quot;,&quot;location&quot;:{&quot;lat&quot;:0,&quot;lon&quot;:0},&quot;create_time&quot;:&quot;2020-03-04&quot;,&quot;address&quot;:&quot;&quot;}\n\n\n-----------------------------------------------------------------------\u4ee5\u4e0a\u6570\u636e\u683c\u5f0f\u4e0d\u8981\u6539-------------------------------------------<\/pre><p>\u6279\u91cf\u6dfb\u52a0\u6570\u636e\uff1a<\/p><p><span style=\"color: rgb(80, 80, 80); font-family: OpenSans, Helvetica, Arial, sans-serif; font-size: 12px; white-space: pre-wrap; background-color: rgb(255, 255, 255);\">https:\/\/es\u5730\u5740\/student\/_bulk<\/span><\/p><p><img src=\"https:\/\/api.hu-rong.com\/uploads\/image\/20200405\/1586065463519928.png\" title=\"1586065463519928.png\" alt=\"image.png\"\/><\/p>"}