{"id":210280,"date":"2020-11-27T11:39:25","date_gmt":"2020-11-27T03:39:25","guid":{"rendered":"http:\/\/4563.org\/?p=210280"},"modified":"2020-11-27T11:39:25","modified_gmt":"2020-11-27T03:39:25","slug":"%e4%b8%a4%e4%b8%aa%e6%95%b0%e6%8d%ae%e5%ba%93%ef%bc%8c%e5%90%8c%e6%a0%b7%e7%9a%84%e8%a1%a8%e5%92%8c%e6%95%b0%e6%8d%ae%ef%bc%8c%e6%9f%a5%e8%af%a2%e6%97%b6%e9%97%b4%e7%9b%b8%e5%b7%ae%e5%be%88%e5%a4%9a","status":"publish","type":"post","link":"http:\/\/4563.org\/?p=210280","title":{"rendered":"\u4e24\u4e2a\u6570\u636e\u5e93\uff0c\u540c\u6837\u7684\u8868\u548c\u6570\u636e\uff0c\u67e5\u8be2\u65f6\u95f4\u76f8\u5dee\u5f88\u591a"},"content":{"rendered":"
\n
\n
\n

\u4e24\u4e2a\u6570\u636e\u5e93\uff0c\u540c\u6837\u7684\u8868\u548c\u6570\u636e\uff0c\u67e5\u8be2\u65f6\u95f4\u76f8\u5dee\u5f88\u591a <\/h1>\n

<\/p>\n

\n
\u8cc7\u6df1\u5927\u4f6c : kkkeen <\/span> <\/i> 3<\/span> <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/p><\/div>\n
<\/p>\n

\u4e0d\u80fd\u8d34\u56fe\uff0c\u53ea\u80fd\u63cf\u8ff0\u4e86 \u76f8\u540c\u7684 sql:select 1 from ice_sell_5 i,ice_sell_types s WHERE status=3 AND state_on = 0 and i.typeid = s.typeid AND keyword LIKE ‘%731%’ group by username \u91cc\u9762\u6d89\u53ca\u7684 2 \u4e2a\u8868\u90fd\u662f\u4e00\u6837\u7684\uff0c\u6267\u884c\u8ba1\u5212 EXPLAIN \u4e5f\u662f\u4e00\u6837 2 \u4e2a\u6570\u636e\u5e93\u8fd8\u662f\u5728\u540c\u4e00\u53f0\u673a\u5668 \u4f46\u4e00\u4e2a\u5e93\u67e5\u8be2\u8981 6 \u79d2\uff0c\u53e6\u4e00\u4e2a\u5374\u662f 1 \u79d2 ice_sell_5 \u6570\u636e\u91cf 60 \u591a\u4e07\uff0cice_sell_types \u6570\u636e 8 \u6761 \u518d\u8d34\u4e2a sell_5 \u7684\u4e00\u4e9b\u7ed3\u6784: PRIMARY KEY (itemid<\/code>), UNIQUE KEY sell_idx<\/code> (title<\/code>,username<\/code>,brand<\/code>,cangku<\/code>,pihao<\/code>) USING BTREE, KEY username<\/code> (username<\/code>) USING BTREE, KEY editdate<\/code> (editdate<\/code>,vip<\/code>,edittime<\/code>) USING BTREE, KEY edittime<\/code> (edittime<\/code>) USING BTREE, KEY catid<\/code> (catid<\/code>) USING BTREE, KEY mycatid<\/code> (mycatid<\/code>) USING BTREE, KEY areaid<\/code> (areaid<\/code>) USING BTREE, KEY typeid<\/code> (typeid<\/code>,username<\/code>) USING BTREE, KEY title<\/code> (title<\/code>) USING BTREE, KEY pihao<\/code> (pihao<\/code>) USING BTREE, KEY idx_stat_on<\/code> (state_on<\/code>), KEY status<\/code> (status<\/code>), KEY addtime<\/code> (addtime<\/code>)<\/p>\n<\/p><\/div>\n

\u5927\u4f6c\u6709\u8a71\u8aaa<\/b> (0<\/span>) <\/div>\n
<\/div>\n<\/p><\/div>\n<\/p><\/div>\n
    \n
  • \n","protected":false},"excerpt":{"rendered":"

    \u4e24\u4e2a\u6570\u636e\u5e93\uff0c\u540c\u6837\u7684\u8868\u548c\u6570\u636e\uff0c\u67e5\u8be2\u65f6…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[],"tags":[],"_links":{"self":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/210280"}],"collection":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=210280"}],"version-history":[{"count":0,"href":"http:\/\/4563.org\/index.php?rest_route=\/wp\/v2\/posts\/210280\/revisions"}],"wp:attachment":[{"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=210280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=210280"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/4563.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=210280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}